Learn about known issues and apply workarounds for Adaptive Server. Known issues are listed in descending order of Change Request (CR) numbers.
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
.CR # | Description |
---|---|
714061 | The forwrowcnt column in
the systabstats table does not change after running online reorg
rebuild
The number of forwarded rows in the forwrowcnt column of the systabstats table does not zero out after running the online reorg rebuild command. Workaround: Run update statistics on the table after running online reorg rebuild. |
713855 | An exception is
raised when migrating from Adaptive Server versions, 12.5.4 through 15.0 to
version 15.7 ESD #2 using sybmigrate An exception is raised due to inconsistencies between roles that exist in the sysusers table of the source server and the roles that exist in the sysusers table of the target server. Workaround:
For example, when migrating from Adaptive Server 15.0 to
Adaptive Server 15.7 ESD #2.
|
713631 | Create index in parallel with
descending keys may fail with error 832 In some cases, when the creation of an index in parallel mode using the WITH CONSUMERS=number option is executed, and the configuration parameter enable functionality group is on, Adaptive Server may generate the following error: Error 832: Unable to place buffer 0x4e498f68 holding logical page 2344 in sdes for object <table name> - there is no room in sdes aux keep pool. The following is an example of a command that may generate the error message: 1> create index ind on tab(a desc,b, c) with consumers = 3 2> go Workaround: This is an internal error that does not lead to data corruption. Traceflag 549 could be used to avoid running into this error. |
713464 | Create index in parallel with
descending keys may fail with error 1503 In some cases, when the creation of an index in parallel mode using the WITH CONSUMERS=number option is executed, and the configuration parameter enable functionality group is on, Adaptive Server may generate the following error: Msg 1503, Level 20, State 2: Line 1: Sort Internal Error: The Root page of right/left sub-index tree is missing. Command has been aborted. The following is an example of a command that may generate the error message: 1> create index ind on tab(a desc,b, c) with consumers = 3 2> go Workaround: This is an internal error that does not lead to data corruption. Traceflag 549 could be used to avoid running into this error. |
696072 | In some Cluster Edition
configurations, Adaptive Server 624 and 69x errors may occur in rare
circumstances during database replication of a database or replication of
tables within a database. In active-active or active-passive cluster configurations, you can configure RepAgent to run on only one node of the cluster. These errors may occur in rare circumstances when RepAgent reads an older image of database log pages that is on disk while the latest image is on another node. Workaround: Sybase recommends that for:
|
695625 | This message is
reported by Open Client applications connecting to Adaptive Server
Enterprise: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read. This message is reported in some cases when Kerberos message confidentiality service is turned on. Workaround: Reconnect to the server with confidentiality service turned off. |
694912 |
The sybcluster localize utility
does not function properly and exceptions are raised.
If the $SYBASE/SYBASE_ASE/locales directory contains files or directories that are not server-related locales files, the sybcluster localize utility does not function properly. If unrelated files are in the locales directory, the localize command aborts and raises an exception at the beginning phase. If an unrelated directory is in the locales directory, the charset selection menu is shown incorrectly and localize may abort during further processing. Workaround: Do not place files or directories unrelated to localization in the $SYBASE/SYBASE_ASE/locales directory. |
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. |
595923 |
There are two known issues with transfer table:
Workaround: None. |
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. |
478875 |
In the Adaptive Server plug-in, you cannot drop a connected instance; your
connection is lost as soon as the instance is shut down.
Workaround: Before shutting down the instance to drop, connect to another instance in the cluster. |