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 |
---|---|
567056 |
Japanese, Korean and Chinese localized files for high-availability support on Windows (sybcaeja.dll, sybcaeko.dll, and sybcaezh.dll) are missing from Adaptive Server 15.0.3 ESD #1. Workaround: Contact Sybase Technical Support to obtain thsee files. |
556521 |
Starting a server may fail on Microsoft Windows 32-bit platform.
Adaptive Server 15.0.3 on Microsoft Windows 32-bit platform may fail to start with an error message saying "NT operating system error 87 in module 'nt386\ksource\blkmem\osmntmmap.c' at line 479 The parameter is incorrect" followed by "kernel os_create_region: Failed to get virtual memory information".
Workaround: On Microsoft Windows 32-bit platform with 2GB or more configured memory, Adaptive Server binary (sqlsrvr.exe) must be configured as large memory aware. Use the Microsoft imagecfg.exe tool to do this. Enter:
imagecfg -l %SYBASE%\%SYBASE_ASE%\bin\sqlsrvr.exeIf you are unsure about performing this configuration or need any further help on this issue contact Sybase Technical Support. |
551479 |
Configuring high availability on Windows produces operating system error.
Operating system error 5042 is encountered when attempting to configure high availabiltiy on a Windows system using sp_companion. Workaround: Install EBF 16472 on Adaptive Server 15.0.3 in order to access high availability functionality. If your previous installation is configured for high availability, install EBF 16472 after upgrading to Adaptive Server 15.0.3. |
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. |
426402 |
Unsetting LANG before running syconfig.
[CR# 426402] Connectivity errors may prevent syconfig from completing tasks if you have not unset the LANG environment variable before running syconfig. Workaround: Unset the LANG environmental variable before running syconfig. |
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. |