Targeted CR List for ASE 12.5.3 ESD #2 The purpose of this document is to help Sybase customers obtain a general idea of potential bug fixes in future Adaptive Server Enterprise (ASE) EBF releases. Please be sure to read the Disclaimer and General Notes below. Disclaimer: This document lists the targeted (not committed) fixed CR list for the release listed above. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. Sybase does not commit to releasing EBFs on the specified dates or to including the CR fixes in the said EBF. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that Sybase may decide not to release an EBF that was previously scheduled for release.
| Bug ID | Description |
|---|---|
| 385033 | Supply a document (ASE-12_5/ThirdPartyLegal/ASE-1253ThirdPartyLegal.pdf) containing licenses for third party products included as a part of ASE 12.5.3. The PDF contains links to the source code distributions for those third party components that require it as a part of their licenses. |
| 382866 | The installer fails with "Object to update not found in VPD..." error when user tries to install other Sybase products over ASE 12.5.3 IR or ASE 12.5.3 ESD1 installation. |
| 380822 | SybMigrate not preserving identity values during migration. When migrating tables with identity columns the identity values were recomputed when created on the target server. |
| 379991 | The word "foreign" is misspelled as "forign" in error messages 1718 and 1724. |
| 379449 | Deadlocks involving system tables may sometimes happen when a REORG REBUILD command is being run concurrently with a CREATE TABLE command or other DDLs. |
| 378870 | A 109 error, "There are more columns in the INSERT statement than values specified in the VALUES clause" will be reported by optdiag when using the -i (input) option to load a statistics file that contains a column list with more than one column. |
| 378774 | User can't choose the location of sybsystemdb device in syconfig.exe. It always use the device at %SYBASE%\data\sybsysdb.dat. |
| 378748 | Error 7742,"You must change your password using the sp_password system stored procedure before you can continue." can be raised at the secondary site in a HA environment if the password has expired in the primary, and sp_password is run to change it. |
| 378391 | "Error: 702, Severity: 20, State: 1 Memory request for XXXXX bytes exceeds the size of a single page of 16384 bytes." together with "The SQL Server is terminating this process" may be found in the error log when concatenating strings together. |
| 378184 | When server's charset is SJIS, client charset is EUCJIS and builtin conversion (enable unicode conversion is set to 0 or 1) is used, 4847 error is raised with BCP IN command. |
| 377973 | In rare circumstances a 3474 error, "During redo the page timestamp value is less than old timestamp from log....", may be reported in the error log during recovery of a transaction which ,at runtime, was truncating a table around the time that a checkpoint was taking place. |
| 377912 | DDLGen generates NULL in Grant Statements for 'Update Statistics' and 'Truncate Table' |
| 377737 | The error 11206, "Unable to connect to server '%s'" followed by error 4002, "Login failed', will be raised if a procedure fired when a threshold is crossed tries to access an MDA table. |
| 377503 | After an upgrade to ASE 12.5.1 or above, a 7417 error may be raised by the DBCC CHECKCATALOG command run for the SYBSYSTEMPROCS database. |
| 377488 | The message infected with 11 in startscan() is raised together with a stacktrace written to the errorlog containing the modules 'curs_open', 'execute' and 'exec_eop', when a cursor statement contains a SELECT with a UNION- and a JOIN-clause using the REFORMATTING strategy, when the OPEN of the cursor is executed. The set option FMTONLY must be set on to see this issue. |
| 377437 | ASE running on multiprocessor Windows systems may occasionally fail to acknowledge cancel requests from client application causing the client application to hang in ct_cancel or ct_results. |
| 377105 | If the trace flag 9217 is active, the Replication Agent will not stop operating after having reported the error 9289 due to an inconsistent log record found. Instead it will attempt to continue the replication after having reported the error 9290 in the error log. |
| 377075 | A 9289 error, "RepAgent(5). Log record (1370, 17) contains inconsistent data. Transaction log may be corrupt" may be reported in a server with a multi byte character set when data inserted in a varchar column is longer than the definition of the column. This can happen for an insert using binary values for the character column. |
| 377059 | A new file, ASE-12_5/ThirdPartyLegal/ASE-1253ThirdPartyLegal.pdf, is included which contains the licensing terms of all third-party source code included in ASE 12.5.3. |
| 376858 | A 3939 error, "Illegal attempt to rollback transaction ... that has already committed in database ' < temporary_database_name > '", may be reported if a session is interrupted with ^C during the dropping of a temporary table and the 3706 trace flag is turned on. The interrupted session is terminated abnormally and may not have its resources cleaned up. |
| 376767 | CIS : An error is reported when UPDATE and DELETE statements with TOP syntax are sent to remote servers that do not support the TOP syntax. |
| 376490 | ASE running on the Windows Server 2003 platform does not produce correct stacktrace if ASE executable sqlsrvr.exe is not found in the current working directory. |
| 376419 | ASE gives timeslice errors when heavy I/O operations are executed on RedHat Linux variant RHEL 3.0 version |
| 376412 | Some SYS_SESSION application contexts, namely client_name, client_hostname and client_applname, can result in either wrong results. |
| 376404 | Application context SYS_SESSION fails to return results for attributes clientname, clientappname and clienthostname. |
| 375914 | When UPDATE STATISTICS is run on a proxy table that maps to a non-ASE remote server, the warning messages 11294 "The remote server ('server_name') class < id > is not supported by UPDATE STATISTICS in import mode." and "UPDATE STATISTICS will not run in import mode." will be displayed. This causes sp_text_notify on EFTS text index table to produce an error "RMTQUERY, Execution of query 'update statistics < dbname > . < owner > . < text_index > ' failed." in the EFTS log. |
| 375755 | hpia64 : If "maxfiles" (soft maximum number of file descriptors per process) kernel paramter is greater than 32767, ASE could go down due to infected with 11 with a stack trace including kadefer(). |
| 374951 | The ASE server process disappears after generating the message "fatal flex scanner internal error--end of buffer missed" on the ASE console, while executing a query using the Abstract Plan syntax. |
| 374815 | In rare circumstances, Adaptive Server may hang as a result of an undetected self deadlock for a process that is trying to flush its user log cache when the cache replacement policy for the given cache is "relaxed LRU replacement". |
| 374681 | DBCC ORPHANTABLES enhanced to drop stranded temporary tables holding EX_TAB locks. These locks may be left around as a result of an ungraceful termination of a connection. |
| 374625 | The error 2601, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'" will be raised by the server upgrade item 1412 if a role with password expiration different than zero exists. |
| 374160 | When migrating only indexes and constraints for a database then the migration can hang and an unhandled exception is printed on the console window: java.lang.ClassCastException: java.math.BigDecimal at com.sybase.sybmigration.ObjectSelectForm$NextTask.doWork(ObjectSelect Form.java:2082) at com.sybase.sybmigration.MigrationToolThread.run(MigrationToolThread.j ava:28) |
| 374049 | In some cases, the sp_displaylogin system stored procedure will incorrectly repeat the value for the "Current Failed login attempts" property for the following item "Authenticate with". |
| 373858 | If a command is sent to ASE which contains a huge number of syntax errors (eg thousands), then the ASE task handling the command may hang in 'send sleep'. This is because the client machine has not yet called ct_results to retrieve input, and the large number of syntax error messages sent back to the client may fill the client's tcp/ip receive buffer. To prevent this, only the first 25 syntax errors in any single command batch will be reported. |
| 373573 | In rare cases, a distributed XA transaction will be left in an "In Abort Tran" state after an XA transaction manager (TM) has issued an asynchronous abort request on it and there is at least one pending attach request. A further attempt by the TM to roll back the transaction or an attempt to roll back the transaction using DBCC COMPLETE_XACT will fail. |
| 373461 | In some cases logins will be blocked when a session that is modifying a system table in the 'master' database (eg the sysattributes table through the sp_addengine stored procedure), is itself blocked because the 'master' database has been quiesced. |
| 372728 | Automatic lightweight validation of pages physically read from or written to disk will now occur when either a 694 error or some variants of a 697 error are reported. This is indicated by the message "Diagnostic checks have been turned on to report if a corrupted page is read from or written to disk. Use DBCC TRACEOFF(615) to turn these checks off" in the error log. The automatic validation may be permanently turned off by starting Adaptive Server with the 615 trace flag. |
| 372630 | The message "current process infected with 11" in the module 'next_root' together with a stack trace which includes the modules 'vu_call_colnames' or 'clean_vars' may be reported in the error log if a view or a stored procedure using a derived table with a UNION is recompiled. |
| 372533 | The execution of "SP_SPACEUSED < table_name > " may deadlock with other sessions trying to create/drop tables in the given database. |
| 372435 | When the JS agent unexpectedly loses contact with the JS task (e.g., as a result of ASE shutting down with "nowait") while the agent is running multiple, simultaneous jobs, it attempts to shut itself down and mismanages jobs queues and memory in the process, causing the agent to core dump or hang (and not be able to resume when the JS task is revived). Symptoms include (1) a core file, (2) a freshly started JS task unable to launch and connect to a JS agent, (3) the JS task logging an error such as "Failed to receive communication buff". |
| 372285 | Allow parallel execution of queries selecting from a view with union. |
| 372269 | DDLGen now supports ASE 11.9.2 and up. |
| 371993 | In some rare cases, ALTER TABLE on a DOL table may corrupt the clustered index so that entries for some rows are missing, resulting in a lower rowcount. DBCC checktable will report a 7928 error. |
| 371757 | At times, the Job scheduler may not calculate time intervals correctly, if the job is scheduled to run past midnight. The next callout calculations were not correctly handling cases where the schedule starttime was after the schedule endtime, that is a schedule that wraps over midnight. The net effect of this error was that the schedule was being offset from the starttime when it passed midnight. The current fix handles this case correctly so schedules are rolled over midnight properly. The fix in effect recognizes that midnight, which is stored as a 0 in a CS_DATETIME, effectively needs to be viewed as the largest allowable value when approached clockwise during an operational schedule rather than as a 0. In addition to the direct fix there are a couple side effects to this fix that users may see: 1) End times are now enforced correctly. This means that when a recurrence interval falls on the end time the job will not run. The current situation is that a job can actually run past the endtime because the next callout calculation was allowing the next callout time to be outside the endtime boundary so the job would be run past the endtime and then the following callout time would move up to the next starttime. This was clearly incorrect and has been fixed, however this represents a change in current behavior. 2) Schedules where starttime equals endtime, either as default values or explicitly set are treated correctly. That is the schedule will run in continuous intervals without interruption unless constraints (day of week/date of month) are set. |
| 371703 | If SET PROXY is executed in a batch where one of the commands fail, the security context will be partially lost and the user will not be able to revert its identity. The output of sp_who will show that both the original name and the current name are set to the faked user's name. |
| 371310 | On 64 bit platforms "sp_configure 'additional network memory' ,2147481600" silently fails. |
| 371154 | Error message number 216 : "Attempt to automatically drop temporary table failed." and the stack trace may be written to the errorlog when the server encounters an error during the recompilation of the stored procedure using cursor on the temporary table. |
| 370932 | The following cp1252 sort order files are missing from $SYBASE/charsets/cp1252 directory: dictionary.srt, espdict.srt, espnoac.srt, espnocs.srt, nocase.srt, noaccents.srt and nocasepref.srt. |
| 370092 | In rare circumstances a deserialized Object attempts to validate on an incomplete read. In this case the read may be retried with an expectation of success so a retry mechanism was incorporated in the deserialization mechanism. |
| 369966 | In the case of fatal errors occuring at online time during the recovery process, Adaptiver Server error handling may not be graceful and may fail to recover subsequent databases. |
| 369961 | When using sqldebugger utility some warning messages and messages sent via PRINT statement are silently ignored without printing. |
| 369933 | The error "ct_fetch(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received." will be raised if updating a table with a timestamp field results in a duplicate key error. |
| 369675 | The error 5850 will be incorrectly raised when the configuration parameter 'enable ldap auth' is set to zero in those platforms where LDAP is not supported. |
| 369469 | When INSERT or DELETE privileges are granted to PUBLIC, it is not possible to GRANT the same privilege WITH GRANT OPTION to an individual user. |
| 369121 | When some serious error is encountered by the server during recompilation of the stored procedure the session may be killed with the stack trace and error 216: "Attempt to automatically drop temporary table failed." This error is spurious and no temporary object will remain in the temporaray database. This problem may happen only if a stored procedure creates non temporary table. |
| 368943 | SELECT POWER(0,0) returns 'Domain error' in Adaptive Server Enterprise. |
| 368333 | LIKE can pattern match trailing-control characters without the necessary wild-card operator. |
| 368132 | The message "current process infected with 11" in the module 'param_setup' together with a stack trace may be reported in the error log if Union with dateadd() and getdate() builtin routines are used on proxy tables. |
| 367984 | The message infected with 11 in run() is printed in the errorlog together with a stacktrace containing the modules 'run', 'exec_eop' and 'execute' when using the STR() built-in function when the parameter 'length' is not a constant but an expression evaluating to the value bigger than 255. |
| 367567 | A role that has been locked can be incorrectly enabled unless it is protected with a password. |
| 367339 | For ASE running on linux 32bit system, 'disk init' on a tmpfs filesystem based file device fails with the message "Device activation error. PHYSNAME ' < filename > ' may be incorrect". ASE errorlog also reports "kernel dopen: open ' < filename > ', Invalid argument". |
| 367261 | The upgrade program has been enhanced to parse the text of existing stored procedures |
| 367186 | Message "infected with 11 in logcommand()" together with a stacktrace containing the modules 'logcommand', 's__altertab' and 's_execute' is printed in the errorlog when executing an ALTER TABLE statement while DDL replication for that database and statement cache are enabled. |
| 366822 | When SPID=0 is specified as a search argument to any of the Monitoring Tables the messages "ubo_object_from_slot:Pss Invalid slot id 0" and "An internal memory management error has occured. Error code: Invalid slot id." are written to the ASE errorlog followed by a stacktrace showing the ubo_object_from_slot() function as the instigator. These messages are harmless but should not be produced. |
| 366696 | The SuspendedProcesses column of the monOpenDatabase Monitoring Table should report 0 when no processes are suspended rather than NULL. |
| 366659 | The Yields, DiskIOChecks, DiskIOPolled and DiskIOCompleted columns should be added to the monEngine Monitoring Table to report the number of times the engine yielded to the OS, the number of checks for asynchronous I/O, the number of times I/O was polled for, and the number of times this poll showed that I/O completed, respectively. |
| 364403 | The message "infected with 11 in apu_force_j_alg()" is printed in the errorlog together with a stacktrace containing the modules 'apa__struct_plan', 's_ap_apply' and 's_compile_stmt' when a SELECT INTO statement is executed based on a join together with the PLAN-clause using an AP join operator describing the AP-plan for the join. |
| 364117 | The message "infected with 11 in startscan" is printed in the errorlog together with a stacktrace containing the modules 'exec_eop', 's_execute' and 'sequencer' when an assignment SELECT is executed using a VIEW with a UNION clause and the "set fmtonly" option is set on. |
| 363815 | Implemented a new strategy for fast first row return for queries using cursors with an ORDERBY. This strategy can be enabled via boot time Traceflag -T329. |
| 362865 | A 20196 error, "ubo_object_from_slot: Mail Boxes Invalid slot id < negative value > " may appear in the error log followed by a stack trace including the module 'ubo_object_from_slot' and 'smget' or 'smdestroymbox' when a query or a sort operation was executed in parallel and there was a lack of 'Mail Boxes' objects. |
| 362703 | When Adaptive Server re-evaluates the grantable lock requests that are no longer blocked, if a new lock request comes in then it may be queued behind the re-queued locks although it is compatible with them. This situation is rare, but it will result in unnecessary blocking situations, for example a 'shared intent' table lock that is granted to task A may block a 'shared intent' compatible table lock requested by task B. |
| 362316 | A 6401 error, "Cannot rollback < XACT_NAME > - no transaction or savepoint of that name found." will be reported if a named transaction is rolled back in which a SELECT that required a worktable (ORDER BY or DISTINCT for example) preceeded any transactional activity and if the database has replicated objects. |
| 362100 | If a table is altered to add a new identity column, a view created on such table column will incorrectly set the status to allow nulls. |
| 362075 | ASE running on Sun 32bit platforms may receive signal 10 or signal 11 in routine ksmask__complete. This problem affects ASE running on 32bit systems but using more than 2Gb of memory. |
| 361979 | On the NT platform, sp_listener may incorrectly report a 12990 error when a listener using the NLWNSCK protocol is specified. This may be resolved by removing any trailing whitespace from the sql.ini entry that represents this listener. |
| 361967 | The error 10901 "This query requires < value > auxiliary scan descriptors, but currently there are only < value > auxiliary scan descriptors available. Either raise the value of the 'number of aux scan descriptors' configuration parameter or try your query later." can be raised during the execution of a complex query despite having increased the 'number of aux scan descriptors' to the appropriate value. |
| 360372 | Error 3626 is raised with the text 'Message empty' when the configured stack size is insufficient to run a query. Instead the text "The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces..." should be reported. |
| 359754 | CIS: In rare circumstances, a query with an aggregation and a GROUP BY clause on a same remote column will be passed to the remote server with some incorrect query text and return wrong results |
| 358090 | Two new builtin functions have been added, XA_GTRID( < xactname > , 0) and XA_BQUAL( < xactname > , 0) that decode an XA transaction < xactname > and report the decoded GTRID or BQUAL as a VARBINARY value. These builtins are useful in mapping XA transactions on Adaptive Server to XA transaction |
Back to Top
