Known Issues for Adaptive Server

Learn about known issues and apply workarounds for Adaptive Server. Known issues are listed in descending order of Change Request (CR) numbers.

Note: Sybase does not include system problem reports (SPRs) and closed problem reports (CPRs) with Adaptive Server Enterprise. You can search the Web site for solved cases. Click Support > Services > Solved Cases.

CR #	Description
684713	sybmail configuration fails with this error: `Sybmail CMC Error: There was a generic failure that does not fit the description of any other return code.` The configuration can not be completed as documented in the Configuration Guide because the Messaging Application Programming Interface(MAPI) used by sybmail has been removed from current versions of Windows. Workaround: None.
684556	The select for update semantics introduced in version 15.7 do not support datapages-locked tables. select for update support exists only for datarows-locked pages. Workaround: None.
662413	In some cases, alter database...log on or alter database...log off generates an error: "You must have the database `dbname` in single-user mode to perform an operation that either partially fills a hole or removes a partial disk fragment from the database." Workaround: Set single-user mode using: `sp_dboption single user`, then re-run the command.
595923	There are two known issues with transfer table: When creating a unique index that is using the ignore_dup_key property, importing a row with a key that is already present in the table leads to an error, and the import is aborted. This differs from when a duplicate key is inserted with bcp or with a regular insert statement, since in those cases, the row is discarded, and the transaction continues. When an insert trigger exists, the trigger is not fired when data is inserted through transfer table...from. Workaround: None.
593866	Cannot access help from syconfig in Windows 2008. When you click Help in syconfig, you see an error message that online help cannot be shown. Workaround: Download the WinHlp32.exe file from Microsoft. See the Microsoft Support site at http://support.microsoft.com/kb/917607/en#3.
589269	Adaptive Server may stop responding during start-up. If you are using the in-memory database or relaxed-durability database feature, Adaptive Server may run into a timeslice error during start-up if it cannot access the license server as it starts. Workaround: Make sure Adaptive Server can access the license server.
582815	Under certain conditions, you may need to re-create abstract plans associated with stored procedures that include the built-in function isnull. These are the conditions: One of the parameters to isnull is a char datatype and another is a literal. enable literal parameterization is set to on. Workaround: Re-create the abstract plans associated with the stored procedure.
470078	Running syconfig during upgrade may not execute. If you install a new version of Adaptive Server in a different directory than the existing installation directory, the length of the path environment variable may exceed the maximum permissible length. As a result, syconfig may not be able to execute preupgrade during the upgrade process. Workaround: Remove unwanted directories from the path and make sure new Adaptive Server installation directories are included in the path.
439406	Configuring Job Scheduler Self Management for Simplified Chinese. When you configure the Job Scheduler Self Management feature for an Adaptive Server localized for Simplified Chinese, you may receive an error saying that a `varchar` datatype cannot be converted to a date. The Job Scheduler configuration process stops at this point. Workaround: Do not configure the Self Management feature for Simplified Chinese.
439404	Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese. When you attempt to create a Job Scheduler schedule using the Adaptive Server plug-in for an Adaptive Server that is localized for Simplified Chinese, you may receive an error indicating that the `varchar` datatype cannot be converted to a date. Workaround: Localize the Adaptive Server for Simplified Chinese before configuring Job Scheduler.