2081350 - Targeted CR List for ASE 15.5 ESD#5.4 -SAP ASE Symptom The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below. If the EBF/SP has been released, check the CR list and coverletter at the.
Adaptive Server® Enterprise 15.7 ESD #2 Linux. PC-Client Product Descriptions and Layout. Downgrading from Adaptive Server 15.7 ESD #2. Community homepage for SAP Adaptive Server Enterprise. Find the latest user blogs, questions and answers, and resources along with featured content.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time.
It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release. CR number Description 687372 A 697 error, 'An attempt was made to fetch logical page for database.' , during transaction rollback, if the transaction is doing some DMLs to upgrade row lock to table lock.
688481 The message 'current process infected with 11' in the module sdesnuminchain together with a stack trace which includes the modules killproc and LeExecSqlFunc may be reported in the error log if a long running user-defined SQL function session gets killed. ASE may need to be rebooted following this error. 693413 The wash size may be returned as a negative value in the ASE configuration file.
706799 Memory allocation failures appear in the ASE errorlog when the network memory pool is exhausted or when fragmentation of memory occurs due to memory that is not freed. 710847 The error messge, 'Page Verification Error: Virtual page in device is out of database range.'
May be reported in the Backup Server error log as a result of a LOAD DATABASE command. 730673 The PCI Memory management layer is enhanced to better service memory allocation requests for ASE tasks executing JAVA operations. The layer now makes a better decision from where to allocate the requested memory. It either uses the PCI Fragment memory pool for end-user coded objects, or the O/S system run-time for JavaVM internal operations. 735036 When running concurrent SELECT commands and DELETE/UPDATE commands on TEXT/IMAGE/UNITEXT columns, the client connection may hang or report a TDS token error or raise error 7128 state 6. 736426 The Java Compile Suite layer in Adaptive Server that is responsible for UDF/ADT support and SQLJ queries execution towards the target JavaVM has been enhanced to allow the release of intermediate allocated Java objects.
This was causing the JavaVM heap memory allocation to be exhausted under a heavy load application environment. 740020 Under rare circumstances on Windows NT 64-bit platform ASE may stop with no errors being reported while processing Web Services requests that involve the execution of Java code. 744011 When a user database is binded to a named cache, create index in it might report Error 693 while a dump database process running simutanously. 744013 In a High Availability server, spaddlogin and spaddremotelogin will fail with permission errors when the user executing the stored procedures is granted ssorole only. 744389 The message, 'Current process infected with signal 8 (SIGFPE)', followed by a stack trace that includes the module samsetupptn may be reported in the error log under rare circumstances. 745599 In rare circumstances the message 'current process infected with 6' in the module 'systemcall' together with a stack trace which includes the modules 'jvmfini' and 'BRIDGEjvmAbortJavaVM' may be reported in the error log during the execution of a UDF/ADT or SQLJ query.
745873 In rare cases a 692 error, 'Uninitialized logical page ' ' was read while accessing database.' May be reported sometime after loading a database dump that was taken of a database in both Enterprise Edition and Cluster Edition, that had been created on devices with “direct i/o” turned on, or taken of a database in a Cluster Edition system only, that had been created on devices with “dsync” turned on. 746349 Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE.
The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a named pipe. 746442 Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature.
Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h.
This feature failed when the connection to the backup server was through a AFUNIX socket. 749101 The connection to a backup server can be rejected if the client host has multiple IP addresses and the entries in the target backup server hosts.allow file are not authorizing the first remote IP address. Likewise, the connections will be rejected if the host name used in the first column of the hosts.allow file specifies a host alias different from the actual host name. 750316 Under rare race conditions, when BCP IN is in progress with the INSERTs running concurrently on the same table, BCP may encounter an 820 error where the process tries to dirty a buffer which is already pinned to another PLC. 750683 In rare circumstances, the execution of Java User Defined Functions (UDF) could mistakenly ignore the arguments it expects when these are presented to it through a single argument that holds a white space separated string. 750719 Error 247:'Arithmetic overflow during implicit conversion of value to a field.' Can be seen while running stored procedure spspaceusage on large table.
750991 spsysmon gives wrong Average values for Engine Busy Utilization in process kernel mode. 751034 If the DUMP DATABASE is run on a database, a 691 error, 'Encountered invalid logical page while accessing database, object, index, partition. This is an internal system error. Please contact Sybase Technical Support.' , might be reported when running SELECT INTO cmd to create a proxy table in this database.
752391 In rare case, if DOL table has unique index, concurrent dmls may hit index corrupt(error 12313 'Insert into page id of index id of table ' ' (id = ) in database ' ' tried to replace undeleted RID (, ) at slot and ridposn. Try dropping and recreating the index.' 752591 A segmentation violation occurs when the config option enable xact coordination is set to 0 and a connection is established between a primary and secondary server.
754283 Backup Server on HPUX may die with error messages: A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 1, error code=0, system message=Pipe I/O returned 0 bytes. D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes while trying to print out a legitimate API error. 754622 Performance of concurrent insert is slow. 754856 When we try to alter temporary table for the database which has proxy database mapped on secondary companion, we hit error 177: CREATE PROXYTABLE cannot create a temporary object (with '#' as the first character name.
756618 Duplicate identity values may be generated after loading a transaction log dump containing transactions that inserted identity values reserved using multiple calls to RESERVEIDENTITY. 756631 A 644 error, 'Index row entry for data row id (, ) is missing from index page of index id of table ' ' in database ' '.
Print2CAD Crack Print2CAD Crack combines PDF file according to CAD, convert them and make set. Autocad 2017 crack. So, you can use RGB color scheme in Print2CAD Key in the form of CAD files because it has almost all colors which is used in multimedia files.
Xactid is ( ). Drop and re-create the index.' May sometimes be reported in heavily concurrent systems using DATAROWS LOCKED or DATAPAGES LOCKED tables. 758938 When a process that is executing a DUMP DATABASE command is killed either using the KILL command or using CTRL-C or the SQL session goes away, the Backup Server will not release its associated resources until it finishes copying the whole database. One of the consequences is that the archive devices can remain locked for a long time because the sybmultbuf processes stay alive. 761275 When there are several scans on the same index and some of the scans hit the same index page needed to be shrunk concurrently, the index page may be shrunk twice. The second attempt will fail and a 2630 error, 'In database, page is linked backward to page, but that page is linked forward to page.
Please report this internal error to SAP Technical Support'. Although a 2630 error is raised, the index is not corrupted. 763301 The ASE COTS JavaVM version is updated to version JRE 6 update 45 for each supported platform in the sybpcidb database. 765720 Under some circumstances the backup server may report the error “Backup Server: 18.104.22.168: Volume validation error: attempt to set directio mode on returned -1.” while a DUMP DATABASE or DUMP TRANSACTION command is being executed. To avoid this problem from happening execute in the master database the command “spdeviceattr ‘devicename’,’directio’,false”. 766109 Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNICreateJavaVM; failed attaching to the JVM for AttachCurrentThread with -1' and 'PCI(M1): ERROR: JNICreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log.
These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted. 766427 The indexes created internally for the replication of text/image columns are system objects and they cannot be renamed by executing the system stored procedure sprename. 766647 Under a heavily loaded Java application environment, the messages 'PCI(M1): ERROR: JNICreateJavaVM; failed attaching to the JVM for AttachCurrentThread with -1' and 'PCI(M1): ERROR: JNICreateJavaVM; PCA/VM FAILED; general failure' may be reported in the SAP Adaptive Server error log. These messages usually indicate that the JavaVM heap space is exhausted. In order to solve this problem the SAP Adaptive Server needs be restarted.
2080810 - Targeted CR List for ASE 15.7 ESD#4.2 - SAP ASE Symptom The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below. If the EBF/SP has been released, check the CR list and coverletter at the.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.
CR Number Description 578515 spsysmon applandlogin does not show the detail of activity by application name and login name. 639813 Execution of stored procedure 'sprenamedb' from read-only database results in error '3906: Attempt to BEGIN TRANSACTION in database failed because database is READ ONLY.' 721824 When the following is true: - the statement cache is on and - a dynamic prepared SQL statement containing a abstract plan clause is executed and - the same statement is prepared and executed by another ASE session, then the entry in the statement cache that was created by the first execution is not found when the dynamic prepare command is executed in the second session.
As a result, a new LWP is created by the second session. 721887 With partitioned tables, some query plans may choose the Merge Union All operator, rather than Dynamic Partition Elimination. 722823 Different behavior for ISNULL on a MAX or MIN aggregate of a character column may be observed when statement cache is used with esql. 722898 During connection termination an error 4720 may be raised for a #table (temporary table). Error:4270 = 'Cannot truncate table '%.s' because there are one or more isolation level 0 scans, or REORG command, active on the table.'
The #table here is found to have a dlevel0cnt = 12. 723437 A new database option 'deallocate first text page', and a new configuration value 2 of table attribute 'deallocfirsttxtpg', are provided for tables having text/image/unitext off-row storage columns, to control whether to deallocate the first text page after updating off-row LOB value from non-NULL to NULL, or whether to allocate a first text page when updating LOB value from NULL to NULL. 724593 In some rare cases, a union query could return wrong result resulting in truncation.
724990 In 15.x, under the default isolation level (Level 1), deletes/updates involving joins and/or correlated subquery could cause more number of exclusive locks to be acquired even when the qualifying number of rows are much less. 725661 The performance of the rollback of a skewed transaction, that is, a transaction that had bursts of activity separated by periods of inactivity, was unnecessarily slow. 725667 Miscellaneous enhancements to the performance of boot time, LOAD DATABASE and LOAD TRAN recovery including better performance in undoing long-running (incomplete) transactions i.e. Those that have bursts of activity separated by periods of inactivity. 725708 The KILL WITH STATUSONLY command has been enhanced and now provides information on the amount of log space scanned and to be scanned for a full transaction rollback. It differentiates different types of rollbacks, and reports a subset of information in cases where the rollback is not a full transaction rollback. 726234 Timeslice in rvmdispatch function with show switch or any server-wide statement in stored procedures.
726379 A 11051 error, 'ALTER TABLE ' ' failed. Table is currently being used by one or more other tasks.' May be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 'Object does not exist in this database.' 727073 ddlgen does not generate ddls of a logical key on views when using -TLK or -TV 727186 JS Agent disappears without any trace in the JS Agent log, ASE may report errors like 'JS: failed to receive jsagent response' and 'Job Scheduler Task lost its Agent connection'.
If core dumps are enabled on the platform, a core file is generated from JS Agent that contains the function sybcsimemfree on the stack. 727484 The stored procedure spdbextend gives following error when invoked in chained mode: Msg 17260, Level 16, State 1: Procedure 'spdbextend', Line 44: Can't run spdbextend from within a transaction.
727597 Under very specific circumstances it is possible when executing a procedure that the incorrect statement may be executed (one statement ahead of the correct one). The correct statement will be missed entirely, and the subseqent statement executed twice. This can only happen when deferred compilation was due to compile and execute the correct statement. Precisely what statement types operators and or semantics lead to this is under investigation, but it arises during procedure tree remapping. Won't happen with an existing re-use of a cached query tree with a cached plan that undergoes no renormalization nor recompilation). Showplan output will show the plan for the incorrect statement under the line number of the statement which should have been executed.
The next statement (which will be the same as the previous one) could then lead to an number of errors or problem result sets. QUERY PLAN FOR STATEMENT 42 (at line 471) (this will be actually next statement not line 471) 728364 Error 806 'Could not find virtual page for logical page%u in database ' '.' May be encountered when executing a stored procedure whose query plan is cached. 728430 Running update statistics on an index containing non-materializing column could throw an error with a stack trace containing the functions 'statbldrow' and 'collocate' in it.
728444 A 2601 error, 'Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes', followed by an 11068 error, 'Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.'
, may be reported in the error log during ASE startup in a Windows environment, if the configuration file has a 'Dump Configuration' section where the 'stripe directory' option is set to a value where backslash characters are specified. 728528 Upgrade from 12.5.4 to asecarina may fail at step 1564 with message 3606 'Arithmetic overflow occurred.' 728634 If a user that has been granted sarole indirectly through a user defined role executes spaddthreshold in a database where the user is not the actual owner the user will get an 17879 error, 'Only users that have System Administrator (SA) authorization granted directly may add, or modify thresholds in that database.' 728759 When the number of statements in the Adaptive Server statement cache is large (approximately 13,000 or more) a query on monCachedStatement may terminate with error 3621, Command has been aborted. 728845 When attempting to migrate objects that may have storable comments such as procedures, views, udfs, pre-computed result set etc, if there are braces (curly brackets) within a comment section they will fail to migrate and report:- JZ0S8 java.sql.SQLException: JZ0S8: An escape sequence in a SQL Query was malformed The same error will be observed if a curly brace appears anywhere in the proc ddl (search argument for example). 729373 During the execution of DUMP DATABASE if the 'compress::' option is used and only one stripe is specified, ASE 15.7 ESD#3, 15.7 ESD#3.1 and 15.7 ESD#4 will ignore the compression option prefix, resulting in an uncompressed dump.
Additionally loading a valid pre-15.7 ESD#3 compressed single stripe dump will fail. 729603 In rare cases, after the last chance threshold is crossed and the user executes DUMP TRANSACTION to free up log space, the last chance bit DBTHLASTCHANCE will remain set in memory in DBTABLE, which will continue to cause processes to be suspended by the last chance threshold mistakenly. 729766 A new configuration value of '2' is added to configuration option 'enable xml' for external entity reference in XML documents, ie, set 'spconfigure 'enable xml', 2' for external entity reference in XML documents. 729919 In very rare situations where incorrect port number is specified for splistener, subsequent calls to splistener might fail.
729984 getpass.exe which is utilized in Web Services on Windows only, is currently not compatible with x64 platforms. 730276 The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3. The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE. 730354 spsysmon can return incorrect CPU metrics. 730807 While using the partitionname builtin on multiple objects, the active objects could be recycled resulting in an information message to printed in the ASE errorlog: 'Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation.' 731026 Certain stored procedures created with 'execute as caller' may produce errors at execution time.
731079 The number of unreserved pages may be incorrect after LOAD DATABASE has been executed and the database dump is from an older ASE version and it contains a large number of tables each having multiple partitions. 731179 The recovery redo pass unnecessarily attempts to fix problems with deallocations and reservations for some committed transactions in cases where there was a long-running transaction at the time of the last checkpoint. 731305 PC Client installer first screen says ESD#2, but should say ESD#4 731354 A signal 11 occurs in the function collectMonCSInfo when a query is executed on the monCachedStatement MDA table and the statement cache contains a statement that was created with a user-defined optimization goal.
731437 DUMP DATABASE with verify=header full options and LOAD DATABASE with verifyonly=header full options commands have been enhanced to detect a mismatch between the page header and tail timestamps for Data Only Locked tables. 731617 When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file ‘backuptape.cfg’ exists, ASE will not be able to read it and the dump will fail. The Backup Server will report an error: 'The format of the device configuration file /backuptape.cfg is invalid.
Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0'. 731758 When the command 'update statistics objname using calibrate = nnn' is invoked, and objname contains unusual characters, the command may fail with an internal error. 731818 The backup server is enhanced to perform consistency checks on All Pages Locked (APL) and Data Only Locked (DOL) data pages during DUMP DATABASE execution. If an error is detected on a page, the page is reread for validation. These checks will be performed if DUMP DATABASE is executed using WITH VERIFY option. Alternatively, start up the backup server with boot time trace flag -D64, or use the run time trace flag SYBBACKUP.qatraceon 8, to enable these checks by default.
731874 Msg 15432, Level 16, State 2 (A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password.) error is raised when a user with login association of a key executes a stored procedure that accesses a column that is encrypted with the key. 732064 A CREATE INDEX or REORG REBUILD command may encounter a signal 11 stack trace in the function ptngetaphintpage. 732329 Under some rare conditions, if autotemptablestats is turned on, it could return Msg 4720 (Cannot truncate table '%.s' because there are one or more isolation level 0 scans, or REORG command, active on the table.) 732406 sybmigrate does not preserve indexes in the indexid order. 732728 The unreserved space stored in the table sysusages can become a huge number bigger than the fragment itself if the number of allocated pages indicated in the OAM pages for some objects becomes corrupted and show pages allocated than are not. 732777 While #table (temporary table) is being dropped, sometimes an error 4720 is raised. Error:4270 = 'Cannot truncate table '%.s' because there are one or more isolation level 0 scans, or REORG command, active on the table.'
The #table here is found to have a dlevel0cnt = 12. 732995 Sometimes Procedure Cache ELC (Engine Local Cache) for some of the engines does not get configured during engine boot, which leads to Procedure cache ELC not getting used on the engine and thus leads to contention on the rproccachespin spinlock. This issue can be detected using the ASE errorlog. If an engine is brought online but does not have the following message for that engine then it means the Procedure Cache ELC is not properly configured for that engine. The message is 'Proc header memory allocated.
Sybase Adaptive Server Enterprise Pc Client
Pages for engine local cache' 733051 If the number of system roles of target server is more than source server's, after running symigrate -m migrate, sybmigrate will drop from sysusers those roles that are 'new' in the target server. This issue can specially be seen when users are migrating from ASE 12.5.4 to ASE 15.7.x 733146 In rare cases, when creating an index on a PAGE compressed table, the message 'Invalid column length' may be printed in the ASE errorlog to indicate there are issues in the index creation. 733604 Add the ability to suppress warning message regarding the ignoring of hints under the presence of abstract plans.
This is enabled under Trace Flag 15381. 733907 The error 822 'Could not start I/O for request.' Followed by a stack trace that includes the module altdbshrinklog could be raised in a Cluster Edition server if a fragment of the database log is shurnk using the command ALTER DATABASE LOG OFF and the device where this fragment was is dropped.
Adaptive Server Enterprise Pc Client
734214 Command line trace flag 16964 is added to turn off the row constructor optimization for range predicates. This optimization may cause an underestimate of the limiting selectivity of an index scan when a range predicate exists on an indexed column followed by limiting predicates on subsequent columns. For example, if an index I(a,b,c) has predicates a 5 and b=10 and c 20 then the range predicate on “a” is followed by minor attributes “b” and “c” which also have limiting predicates. Then the scan selectivity on the index 'I' may be underestimated. 734660 The error 'Page Verification Error: Page mismatch.
Page contains 0 in page header.' Could be incorrectly printed in the backup server errorlog when executing DUMP DATABASE WITH VERIFY. This error is spurious and can be ignored. 734702 For objects with no storage, error 691 may be encountered while running a CREATE INDEX command if either a dump is in progress or an incremental dump is in progress.
734716 At times the Systabstats empty page count column may get values near to 2^32 if inserts into a table roll back. 735431 The error 'Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table.'
Will be incorrectly reported in the backup server error log on pages with deleted rows that belong to an All Pages Locked scheme table when executing DUMP/LOAD WITH VERIFY.