Learn about known issues and apply workarounds for Adaptive Server.
Sybase does not include System Problem Reports (SPR) and Closed Problem Reports (CPR) with Adaptive Server Enterprise. You can search the Web site for solved cases. Click
.CR# | Description |
---|---|
566820 |
The backupserver and auditinit utilities incorrectly list "XXXXXX" in their version strings instead of the actual EBF number for Adaptive Server.
Workaround: None |
564321 |
Establishing a server-to-server Component Integration Services (CIS) connection using SSL on an AIX Adaptive Server causes a segmentation violation, and closes the client connection.
Workaround: None. |
550035 |
Configuring Job Scheduler fails on IBM AIX.
srvbuild and srvbuildres fail to configure Job Scheduler. Workaround: Add $SYBASE_JRE6/bin/classic to the LIBPATH environment variable before running srvbuild or srvbuildres. |
547700 |
Adaptive Server may hang on IBM platforms.
In some cases, on IBM platforms, Adaptive Server may hang. The following messages will be found in the errorlog:
kernel PCI(M1): ERROR: JNI_CreateJavaVM; failed retrieving the JVMTI handle in GetEnv() with -4 kernel PCI(M1): ERROR: JNI_CreateJavaVM; PCA/VM FAILED; not enough memory kernel PCI(M1): ERROR: jsigcache_destroy; Signature cache destroy request without a JavaVM handle to destroy kernel PCI(M1): PCA/JVM Signature cache is detached kernel PCI(M1): Failed to destroy the VM signature cache Workaround: None. Restart Adaptive Server if the server hangs due to this issue. |
CR# | Description |
---|---|
564420 |
Out-of-the-box memory configuration defaults to 80% of physical memory on the machine.
When you create a new Adaptive Server, the out-of-the-box configuration feature prompts you to allocate a total amount of memory for Adaptive Server, and a default value that is 80% of the system's physical memory. The server does not start if the amount of memory specified is not actually available for use by Adaptive Server. Workaround: Determine the amount of memory you need, and confirm that this amount is available for Adaptive Server. |
560437 |
Replication does not work if primary table lacks owner information.
When using SQL statement replication on a table subscription-based replication topology, a data markup language (DML) executed on a replicated table owned by the database owner (dbo) is not replicated as a statement if the replication definition defined for the primary table does not include the owner information. In such cases, the standard replication used instead. For a database subscription-based replication topology, a DML is replicated according to the settings in the database replication definition. If both a table and database replication definition/subscription exist on a table, and the owner information is not specified in the table replication definition, a DML is replicated according to the settings in the database replication definition. Workaround: Mark the table as 'owner_on' at the source database, and create a replication definition for the primary table using the owner information. |
551577 |
Opening a database may cause a scavenging process to stop responding.
When opening a database at the same time a process is scavenging the DBTABLE of that same database, the process may stop responding. You see modules dbt_grab(), dbt_clean(), metrics_proc_dump(), metrics_dump(), and dbt_get() in the stack of the blocked spid. Workaround: Increase the number of open databases and reboot the server. The number of open databases should be configured to be at least the value returned by the query 'select count(*) from master..sysdatabases'. |
544889 |
Potential performance degredation when CIS and Java in database are both enabled.
If the Java-in-the-database feature is enabled in Adaptive Server 15.0.3 or 15.0.3 ESD #1, all processes that access remote servers through Component Integration Services (CIS) are redirected to the engine that handles processes using Java. This can have a serious performance impact in a multi-engine system where most of the processes use CIS, as all of the processes are running on a single engine. Workaround: If CIS and Java in the database feature are not used by the same client, the -T 9403 trace flag may improve performance by distributing CIS connections across all engines. Note: Do not use the -T 9403 trace flag if you are unsure whether CIS and Java in database features are being used together by the same client. Doing so can result in a stack trace.
|
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 localized for Simplified Chinese, you occasionally 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. |
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 occasionally 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. |
416569 |
Updating file names requires the file name to be included in the where clause.
When updating the filename column of a proxy table mapped to a directory of files, Sybase recommends that you qualify the update to specific files by including the filename in the where clause. Some file systems may rename a file by deleting and re-creating a new directory entry; therefore, the same file name may be updated multiple times if the update is not restricted. For example, this statement could cause multiple updates: update t1 set filename=filename + 'old' where filetype = 'REG' Workaround: Add a clause such as 'and filename like '%.c'. |
401543 |
Running allow backward scan does not work.
The allow backward scan configuration parameter does not work in Adaptive Server. |
400784 |
Starting Monitor Client GUI fails when the LDAP server is used.
When you start the Monitor Client GUI in an environment using LDAP instead of an interfaces file, the Monitor Client GUI cannot connect to any servers. Workaround: Create an interfaces file with entries for the servers that are monitored and use this with the Monitor Client GUI. |
382874 |
Creating RSSD database fails with earlier versions of Replication Server.
rs_init in Replication Server version 12.6 and earlier cannot create an RSSD database in Adaptive Server Enterprise version 15.0 or later. Workaround: If you do not use an embedded RSSD (ERSSD), manually create the RSSD database before using rs_init to create a new Replication Server. See the Replication Server Administration Guide. |