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.

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
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: In the source and target server, run the query: `select u.* from sysusers u, syssrvroles r where u.name = r.name and r.srid < 31 order by u.uid` Compare the results of the above query retrieved from the source and target servers. In source server, insert rows returned from the query into master.dbo.sysusers table. These rows contain server roles that exist in target sysusers table and do not exist in the source sysusers table. Run `sybmigrate -m setup` Delete the same rows that you inserted in step 3 from source's master.dbo.sysusers. For example, when migrating from Adaptive Server 15.0 to Adaptive Server 15.7 ESD #2. Run the following query in the source and target servers: `select u.* from sysusers u, syssrvroles r where u.name = r.name and r.srid < 31 order by u.uid` Your query shows you need to insert one row (-2, 16398, 16398, 'keycustodian_role', NULL) into the source master.dbo.sysusers table. Run the following SQL in the source server: `use master` `exec sp_configure 'allow updates to system tables' 1` `insert sysusers values(-2, 16398, 16398, 'keycustodian_role', NULL)` `exec sp_configure 'allow updates to system tables', 0` Run `sybmigrate -m setup` Run the following SQL in the source server: `use master` `exec sp_configure 'allow updates to system tables' 1` `delete sysusers where name = 'keycustodian_role'` `exec sp_configure 'allow updates to system tables', 0`
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: Active-passive configuration – run RepAgent on the active node to ensure that data and log pages are on the same node as RepAgent. Active-active configuration – start Adaptive Server with the 16872 trace flag to prevent log page corruption and 69x errors. However, using this flag degrades the server performance.
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.
615890	Cannot disable RMI socket operations using pca_jvm_netio. RMI sockets continue to function, even if you have either manually disabled them, or executed: sp_jreconfig "disable", "pca_jvm_netio" Consequently, a Java RMI client continues to connect to a remote RMI server to execute functionality over the network. Workaround: Remove any unused RMI classes from the database. By default, pca_jvm_netio is enabled.
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.
595859	A single-engine Adaptive Server may stop responding when, after performing a Java task, additional engines are manually brought online. While running on a single engine, Adaptive Server may either stop responding, or cause connected clients to block indefinitely, generate a stack trace, or not process when the server performs a task that uses Java, as soon as additional engines are manually brought online. This problem occurs due to an issue with the HP-UX commercial off-the-shelf Java Virtual Machine. Workaround: Always have a minimum of two engines configured when starting Adaptive Server; this allows the HP-UX commercial off-the-shelf JVM to automatically target the highest engine number available. In addition, do not set any configuration options in Adaptive Server that targets engine 0 for the HP-UX commercial off-the-shelf JVM.
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.
551972	Using Java in the database to create a file fails on HP-UX. Due to a known issue in HP-UX, creating a file using the Java in the database feature fails unless the working directory permission mask is set to 0777 or equivalent. Workaround: Set the mask on the working directory to 0777. (This is not the same as the physical directory permissions in the file system. The physical directory can have any permissions mask that is appropriate for that directory.) This setting is only for the sybpcidb configuration properties, where you can configure a working directory with a mask that allows or prevents certain actions from within the JVM. Apply the mask using either an add command or an update command. For example: sp_jreconfig 'add', pca_jvm_work_dir, '/some/path(ugo=rwx)' or: sp_jreconfig 'update', pca_jvm_work_dir, '/old/path', '/newpath(ugo=rwx)'
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.