Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:697612

CR Number:   697612 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2012 Fixed 02 May 2012 Fixed Description ASE running in Threaded kernel mode does not generate shared memory dump if CSMD condition is encountered by a non-engine thread.

CR:697690

CR Number:   697690 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description internal-only: new feature. Add command: shutdown instance <instancename> wait <time>

CR:697751

CR Number:   697751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2012 Fixed 11 May 2012 Reservation Made 30 May 2012 Fixed Description For an LOB column which is defined both in-row and LOB compressed, if the column is marked as replicated, when replicating the LOB data from this LOB column, the data selected from the target table may be corrupt.

CR:697800

CR Number:   697800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a non-blocking dbcc command to correct OAM pages, resolving errors such as "The requested update to the OAM for object ... would cause a negative page count"

CR:697823

CR Number:   697823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2012 Fixed Description A 7975 error, "Page number <number> is out of range for this database master", will be reported when running DBCC TEXTALLOC on a table with TEXT column.

CR:697828

CR Number:   697828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2012 Fixed 05 Mar 2012 Fixed 06 Mar 2012 Fixed 02 Oct 2012 One-off Provided 27 Sep 2012 Fixed 05 Nov 2012 Fixed Description High rprocmgr or rpmctrl spinlock contention may be observed under heavy workload of dynamic SQL or stored procedures.

CR:697886

CR Number:   697886 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve optimization for single key self-referential integrity checks. This feature is to streamline the query plan is specific scenarios where the attributes and indices have specific properties in order to remove any unnecessary scans.

CR:697890

CR Number:   697890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The selectivity costings for referential integrity probes use the total density for the join selectivity which can cause inefficient plan choices in circumstances involving data skew. This request is to look to improve the selectivity calculations to take advantage of any histogram that might be usable on the child table. Workaround Description  sp_modifystats 'a', 'a2','REMOVE_SKEW_FROM_DENSITY'

CR:697891

CR Number:   697891 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to extend the abstract plan API to allow the specification of operators used for referential integrity checking during dml operations.

CR:697908

CR Number:   697908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2012 Fixed 06 Apr 2012 Fixed Description UNION query (using MERGE or HASH UNION operators) against semantically partitioned table may fail to remove duplicates when executed in parallel mode with constant literal search arguments for predicates on each side of the union operator. Workaround Description  set literal_autoparam on --or turn on with statement cache if running without statement cache or:- set parallel_query off (or run allrows_oltp)

CR:698059

CR Number:   698059 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2012 Third Party Problem 02 Jul 2012 Fixed by Integrated Component 08 Oct 2014 Port Not Needed Description Multiple failed connection attempts may result in memory related stacktraces in Ct-library and hang up the server completely. This is resolved by OCS CR 585954 (fixed in OCS 15.5 GA onwards).

CR:698063

CR Number:   698063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2012 DEFER 16 Mar 2012 Fixed 16 Mar 2012 Reservation Made 07 May 2012 One-off Provided 01 Oct 2012 Fixed 20 May 2013 Fixed Description When an INSERT query attempts to insert an explicit value for a TIMESTAMP column a warning will be reported, but query execution continues. If the explicit value for the TIMESTAMP column is the result of evaluating an expression, and the query plan for the INSERT is re-executed (i.e. because the statement cache and literal auto parameterization are enabled or because the INSERT query is part of a stored procedure), memory corruption may occur, leading to various stack traces. Workaround Description  set statement_cache off

CR:698066

CR Number:   698066 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sybmigrate uses one worker process per partition for partitioned tables is unable to migrate tables with more than 255 partitions as ASE has a hard limit for "max parallel degree". Sybmigrate raises a message suggesting configuration to an unsupported value: "Attention: Configuration check failed for migration of path.... The config parameter 'max parallel degree' should be configured to a minimum value '[value > 255]'" on the source server. Workaround is to repartition to fewer than 256 partitions prior to migration. Workaround Description  repartition the table to fewer than 256 partitions.

CR:698070

CR Number:   698070 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to increase or eliminate the current hard limit of 255 on "max parallel degree".

CR:698083

CR Number:   698083 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2012 Fixed Description Installer fails to optimize ASE if user chooses to configure an 16k page size ASE.

CR:698089

CR Number:   698089 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2012 Fixed Description A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database '%.*s' (id %d)" may be reported under some circumstances when Adaptive Server has been booted with trace flag 3608, shutdown after some operations and then restarted in normal mode. Workaround Description  Put database in single user mode, use the database, and run: dbcc tablealloc(syslogs,fast,fix)

CR:698105

CR Number:   698105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2012 Fixed 22 Mar 2012 Fixed 22 Mar 2012 Fixed 03 Apr 2012 Fixed Description Replication Agent may incorrectly send "remove table" to Replication Server when a stored procedure is removed from the schema cache.

CR:698134

CR Number:   698134 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2012 Fixed 21 Sep 2012 One-off Provided 07 Nov 2012 Fixed Description In some rare scenarios, procedure cache memory tracking data structures may get accessed after they are freed to global memory queue. This may lead to procedure cache memory corruption.

CR:698209

CR Number:   698209 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2012 Fixed 12 Mar 2012 Fixed Description Permission is denied when a procedure is executed as a RPC event not as a LANGUAGE event.

CR:698315

CR Number:   698315 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 One-off Provided 24 Feb 2012 Fixed 01 Oct 2012 Fixed Description The message "current process infected with 11" in the module 'bufpindirty' together with a stack trace which includes the modules 'xact__rollbackxact' and 's_execute' may be reported in the error log if a SELECT INTO statement involving a big number of tables (more than 96) is aborted with a 226 error, "SELECT INTO command not allowed within multi-statement transaction". If after that a ROLLBACK TRAN is executed by the same session a 6203 error "Unable to do cleanup for the killed process; received Msg ..." may also be reported in the error log.

CR:698331

CR Number:   698331 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2013 Not reproducible with latest version of the product available as of Resolution Date Description The message "current process infected with 11" in the module '_memcpy' together with a stack trace which includes the modules 'AnyDataType::AnyConvertType', 'EmbedDataSet::embedConvertType' and 'OptBlock::OptDoPredElim' may be reported in the error log when a UNION query is run with a parameterized WHERE clause on a semantically partitioned table. Workaround Description  Change the query in question. SELECT col1 FROM t1 WHERE t1.col1 = convert(varchar, ?) UNION ALL SELECT NULL AS col1

CR:698363

CR Number:   698363 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2012 Bundled Request Description Customer may hit error 257 on sp_downgrade while running installmaster.

CR:698381

CR Number:   698381 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2012 Fixed Description In ASE Cluster Edition, changing a database from a non mixed-log-and-data to mixed-log-and-data may invalidate an internal assumption and server may exhibit unknown issues.

CR:698388

CR Number:   698388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2012 Fixed 23 Feb 2012 Fixed 23 Feb 2012 Fixed 02 Mar 2012 Fixed 07 Mar 2012 Fixed Description In rare circumstances, the message "current process infected with 11" together with a stack trace which includes the module 'jvmh_utl_printn' may be reported in the error log when ASE attempts to bootstrap the COTS JVM. This will result in Java operations being impossible to execute. Workaround Description  Change the global java.policy file used by ASE and add the rule below. This file for Solaris 64 can be located at $SYBASE/shared/JRE-6_0_24/lib/security/java.policy // Change the string starting after file: with the appropriate value // for /absolute/path/to/sybase/ASE-15_0/lib/pca/sybasert.jar grant codeBase "file:/absolute/path/to/sybase/ASE-15_0/lib/pca/sybasert.jar" { permission java.lang.reflect.ReflectPermission "suppressAccessChecks"; }; An example would be: grant codeBase "file:/opt/sybase/ASE-15_0/lib/pca/sybasert.jar" { permission java.lang.reflect.ReflectPermission "suppressAccessChecks"; };

CR:698393

CR Number:   698393 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Closed OS:   all Original Version:   15.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2012 Added to user documentation Description dog bug:ASE Cluster Edition 15.5 Install documentation contradiction.

CR:698494

CR Number:   698494 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2012 Fixed Description After DBISQL receives an out of memory error when retrieving the rows of a large resultset, it fails to cancel the underlying query. Instead, it allows the query to run to completion and hold locks and other ASE resources for the duration.

CR:698506

CR Number:   698506 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2012 Duplicate Description Signal 11 may be seen in function yyparse() and the spid terminated after having received an error 156 during attempted execution of invalid 'create procedure' statement contained within begin..end block.

CR:698657

CR Number:   698657 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2012 Fixed 02 Aug 2012 Fixed Description The error 'Invalid RPC sequence at RPC as_cmd' may be reported by the Backup Server when a dump is attempted using a remote backup server and the local interfaces name is different from the remote backup server start-up name.

CR:698692

CR Number:   698692 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2012 Fixed Description After loading a dump from ASE version 15.5 or lower into a ASE version 15.7 server, when the server is first onlined, a signal 11 may be encountered followed by a stacktrace involving the modules 'ptnc_get_ptncond', 'ptnc_fill_ptnvals' and 'ind_ides_init'. Workaround Description  Victor and Andrezj in qryexec suggested trace flag 2810 to workaround the upgrade issue: dbcc traceon(3604,2810) go load database mnpdba from '/c11720510/dump/DTSNRS3_mnpdba.dump' go online database mnpdba go dbcc traceoff(3604, 2810) <--- remember to turn off trace 2810 after online the database go ----------------- Output from db upgrade with 2810 trace on: -------------------------------- ...... Database 'mnpdba': beginning upgrade step [ID 1702]: noting the present database upgrade level Database 'mnpdba': beginning upgrade step [ID 1719]: executing SQL statement ("update sysattributes set object_inf...") (0 rows affected) Database 'mnpdba': beginning upgrade step [ID 1720]: noting the present database upgrade level Upgrade has finished in database 'mnpdba'. ASE is now updating table level statistics for its system tables. Please be patient. Regenerating tree from text <------ Regenerating tree from text <------- Regenerating tree from text <------ Database 'mnpdba' is now online. DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

CR:698873

CR Number:   698873 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guides - All Platforms Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2012 Added to user documentation Description When using the binary overlay upgrade method, a polite shutdown (rather than with nowait) should be used both initially and once the upgrade has completed before putting the upgraded server into service.

CR:698897

CR Number:   698897 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request to confirm the progress of long running queries.

CR:698913

CR Number:   698913 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2012 Not a Bug Description SELECT list and GROUP BY clause containing a CASE expression with/without variables/parameters may produce inconsistent results. Workaround Description  Modify the java code to ensure only the same variable name can be in the case statements in the select list and the group by clause:- String sqlstr = "declare @p1 char(3) select @p1 = ? select col1, CASE WHEN col1 = @p1 THEN col2 ELSE col3 END " + " , sum(col4) " + "from t1 " + "where col1 >= '100' " + "group by col1, CASE WHEN col1 = @p1 THEN col2 ELSE col3 END"; System.out.println("[begin SQL to run]"); System.out.println(sqlstr); System.out.println("[end SQL to run]"); PreparedStatement pstmt = conn.prepareStatement(sqlstr); pstmt.setString(1, "100"); //pstmt.setString(2, "100");

CR:699094

CR Number:   699094 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Fixed 18 Jun 2012 Presently Not Targeted For Any Future Release Of This Product Description In ASE Cluster Edition, if a node crashes in the middle of DROP DATABASE, a signal 10 may be reported when the crashed node re-joins the cluster.

CR:699115

CR Number:   699115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 Drop#3B Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed 16 Mar 2012 Fixed 06 Jul 2012 Not reproducible with latest version of the product available as of Resolution Date Description A 9830 error, "Compression version 0 is invalid for table 'Invalid pointer param number 3, pointer value 0x11' (ID <tblID>), database <dbName> while compressing page <pageid>.", may be reported when doing a deferred INSERT into a table having page compression enabled. Workaround Description  Disable page compression on tables where deferred insert is inserting into.

CR:699211

CR Number:   699211 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2012 Fixed Description The 'no_DBISQL' variable is missing in ASEIP.bat

CR:699381

CR Number:   699381 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2012 Fixed 13 Apr 2012 Fixed Description The error message, "symbol _port_dispatch: referenced symbol not found", may be reported on Solaris 11 platforms. The '_port_dispatch' function call is no longer supported on Solaris 11 and is replaced by 'port_send'.

CR:699429

CR Number:   699429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2014 Duplicate 29 May 2014 Port Not Needed Description In process mode, ASE may not accept new connections and "ncheck: select, Bad file descriptor" messages fill up errorlog after stopping/restarting listeners.

CR:699485

CR Number:   699485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Fixed Description ALTER TABLE MOVE PARTITION can fail if the destination segment does not have enough space. However the transaction does not get rollback successfully. The SYSPARTITION update does not get rollback.

CR:699534

CR Number:   699534 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2012 One-off Provided 17 Dec 2013 Port Not Needed 17 Dec 2013 Port Not Needed Description Instrumentation: ASE reports a timeslice error and shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. Workaround Description  Unknown.

CR:699592

CR Number:   699592 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Fixed Description Creating a replication index, using sp_setreptable, sp_reptostandby or ALTER TABLE, on an in-row LOB column whose maximum in-row length is larger than the maximum allowable size for an index fails with error 1903.

CR:699665

CR Number:   699665 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2013 Insufficient priority to fix Description Error 1526 occurs due to using estimated sort buffers for the wrong cache if the login is not binded to the cache. Workaround Description  A workaround which makes use of ase authenicated user, not kerberos user and also with omni connection. You add your ASE server and loopback to it. 2> sp_addexternlogin ase157,kiki,niki,niki2cute 3> go (return status = 0) isql -Ukiki -Sase157 -V 1> connect to ase157 2> go No security mechanism authentication attempted for connection to server 'ase157'. Using default authentication. Entered passthru mode to server 'ase157'. 1> dump database imdb to "/tmp/db" 2> go Backup Server session id is: 46. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 4.41.1.1: Creating new disk file /tmp/db.

CR:699818

CR Number:   699818 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2012 Fixed Description ASE may encounter a SEGV after issuing DBCC STACKUSED and the task issuing DBCC STACKUSED may hang.

CR:699826

CR Number:   699826 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Kerberos users can't dump imdb Workaround Description  - Add an external login that uses ASE authentication (sp_addexternlogin THIS_SERVER_NAME,...) So that all connections, or at least the connections for certain logins that are authorized to dump, become an ASE authenticated user. - Connect to the same ASE (connect to THIS_SERVER_NAME) - This user can dump the in-memory database

CR:699862

CR Number:   699862 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2012 Bundled Request 05 Mar 2012 One-off Provided Description In ASE Cluster Edition, DROP DATABASE may transfer locks reserved for non-logical locks to logical lock pool causing server to run out of non-logical locks.

CR:699976

CR Number:   699976 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2012 Fixed Description DBISQL login with expired password can fail if invalid entries are present in the sql.ini

CR:700034

CR Number:   700034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2012 Fixed Description A parameterized varchar column in the SELECT lists combined by a UNION (ALL) clause in the derived table may return unexpected trailing spaces if statement cache is enabled. Workaround Description  Change the query as below. SELECT dt.col1, dt.data1 FROM (SELECT convert(varchar(1),?) as col1, data1 from t1 UNION ALL SELECT convert(varchar(1),?) as col1, data1 from t2) dt

CR:700227

CR Number:   700227 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2012 Fixed 06 Sep 2012 Fixed 12 Sep 2012 Fixed 06 Nov 2012 Reservation Made 14 Dec 2012 Fixed Description Reduce additional logging done on page compressed DMLs for replication support, trigger support, and online utilities support.

CR:700231

CR Number:   700231 Product Name:   SCC Web Framework Product Component:   Security Status:   Closed OS:   Generic Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2012 Fixed 05 Mar 2012 Fixed 02 Apr 2012 Added to user documentation Description This resolution addresses an issue which prevented the SCC LDAP login module from handling ecrypted passwords

CR:700292

CR Number:   700292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2014 Already Fixed by Another CR Description A cross-platform load may fail with a timeslice error with function lddb__unscr_phys_pages on the stack, due to the dump containing unallocated pages containing garbage values. As a possible workaround, try executing sp_dumpoptimize 'archive_space = minimum' to include only allocated pages in the dump, then dump and load the database again. Workaround Description  execute sp_dumpoptimize 'archive_space = minimum' and then dump the database again.

CR:700356

CR Number:   700356 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Not reproducible with latest version of the product available as of Resolution Date 10 May 2012 Fixed Description In diagserver, the message "current process infected with signal 11" together with a stack trace which includes the modules "mda__read_lock_table" may be reported in errorlog when the monLock MDA table is queried.

CR:700361

CR Number:   700361 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2012 Fixed 11 Apr 2012 Presently Not Targeted For Any Future Release Of This Product Description Under certain circumstances, in ASE Cluster Edition, CREATE DATABASE immediately following a DROP DATABASE may hang with messages in the error log indicating failure to reclaim active locks.

CR:700379

CR Number:   700379 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Shared locks, which are blocked by demand lock on an earlier lock request, cannot be requeued after the blocking process is killed.

CR:700382

CR Number:   700382 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2012 Fixed 09 Feb 2013 One-off Provided 29 Apr 2013 Fixed Description Shared locks, which are blocked by a demand lock on an earlier lock request, cannot be requeued after the blocking process is killed. Workaround Description  swskipped must be maxed out before it can be requeued. Max out swskipped by requesting PR_LKs, and then issue dbcc lock_requeue. select * from t1 where a=1 go select * from t1 where a=1 go select * from t1 where a=1 go dbcc lock_requeue(...) go

CR:700388

CR Number:   700388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2012 Fixed Description sp_helpthread shows a value of 0 for TargetSize in 15.7 ESD1 SMP.

CR:700404

CR Number:   700404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2012 Fixed 27 Mar 2012 One-off Provided 20 Sep 2012 One-off Provided 03 Dec 2012 One-off Provided 09 Nov 2012 Fixed Description Optcriteria 619756 (enabled in optlevels ase1503esd4 or ase_current) could generate a SEGV and/or assertion failure. The stacktrace associated with the SEGV will typically include references to optimizer routines. In a diagserver, the following assertion (eqc->eqcIsUnrefed() || OptDuringGtuLocalGroupingPrimingHack()) may fail. Workaround Description  set cr619756 off --no TF available to disable fix or configure the server to run with an optlevel of ase1503esd3

CR:700405

CR Number:   700405 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2013 Insufficient priority to fix Description In rare circumstances queries that contain HAVING clauses that contain aggregate functions may hit signal 11 or access violations referencing modules CgpPop::_CgpReplaceVars Workaround Description  None known

CR:700512

CR Number:   700512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Fixed Description When a table has some compressed LOB columns and is marked as replicated, slow BCP'ing data into this table will hit 7105 error and stack trace.

CR:700602

CR Number:   700602 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to enhance the pssinfo() function so it can return the spid, CMD, and various status bitmap fields. Workaround Description  (workaround only for getting spid): get_appcontext('SYS_SESSION', 'spid')

CR:700640

CR Number:   700640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2012 Fixed 07 Aug 2012 One-off Provided 30 May 2012 Fixed Description In Threaded kernel mode, if an ASE task which is doing remote I/O is killed more than once, a SIGSEGV followed by a stack trace that includes the module np__conn_doconnect() may occur and the dataserver then crashes. Workaround Description  Remove retry and retry_delay from interfaces entries for remote cis connections if running in kernel mode = threaded.

CR:700645

CR Number:   700645 Product Name:   ASE Management Product Component:   Monitoring Data Collector Status:   Open OS:   Generic Original Version:   3.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR: create some user friendly canned reports in SCC

CR:700652

CR Number:   700652 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2012 Fixed 03 May 2012 One-off Provided 05 Jun 2012 One-off Provided 06 Jun 2012 Fixed 02 Nov 2012 Fixed Description In rare circumstances, a signal 11 may be reported in the errorlog with a stack trace involving the sort module if a reformatting query plan is used. Workaround Description  disable reformatting via 'set store_index off'

CR:700762

CR Number:   700762 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Insufficient priority to fix Description In scenarios where the return value of a user-defined function may be null and it is evaluated against a constant under 'set ansinull off' (default behaviour) it is possible for behaviour to return to legacy behaviour seen prior to version 15.0.2 ESD#5. Workaround Description  dbcc traceon (7737) /*to disable the MATCHNULL support added via 466998 (this can lead to inconsistent results in other areas involving joins and local variables)*/

CR:700765

CR Number:   700765 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2014 Fixed Description The behaviour described in the T-SQL Users Guide with regards to system-generated NULL behaviour under ansinull off (default):- http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/sqlug94.htm is no longer applicable since 15.0.2 ESD#5, we need to update the documentation

CR:700777

CR Number:   700777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2012 Fixed Description When increasing the parameter 'number of disk tasks' on ASE on the IBM AIX platform, a stack trace and/or error 823 may be reported and the server becomes unresponsive. Workaround Description  Not increase the parameter

CR:700877

CR Number:   700877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2012 Fixed Description ASE on Linux platform cannot start second or subsequent disk controller threads.

CR:700895

CR Number:   700895 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2012 Added to user documentation Description Request to document "OAM count threshold" and its relevance for checkstorage:- The 'OAM count threshold' respresents the percentage by which the discrepancy between between the actual row count and the row count as reported by the OAM pages can vary before checkstorage will raise error 100025 - 'row count error'. Under normal circumstances it is safe to leave this at the default value of 2%.

CR:701065

CR Number:   701065 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2012 Fixed 01 Jun 2012 Fixed Description In rare circumstances, a 2601 error, "Attempt to insert duplicate key row in object 'syspartitions' with unique index 'ncsyspartitions'", may be reported when creating or partitioning a table, some time after the creation of a table within the database was recovered (either after an impolite shutdown, or by LOAD DATABASE or LOAD TRAN). Workaround Description  N/A

CR:701083

CR Number:   701083 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed Description The error message, "Heap memory not freed", is printed in the error log during character encoding compression.

CR:701154

CR Number:   701154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2012 Fixed 23 Mar 2012 One-off Provided 05 Nov 2012 Fixed Description The message, "timeslice -501, current process infected at 0x<address>", in the module 'cm_writelogdes_upto_sequence' together with a stack trace which includes the modules 'cmcc__wri_bcmt_proc' and 'bufwritedes_log' may be reported in the error log when ASE flushes a syslogs page on disk while downgrading the physical lock held on this syslogs page in a 2 node Cluster Edition setup.

CR:701256

CR Number:   701256 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2012 Fixed 05 Jun 2012 Fixed Description Changing the default for configuration of "number of histogram steps" would not have an effect on subsequent update statistics commands for columns which already have statistics. The number of steps used by update statistics should only be preserved from earlier commands if it was run with the option "using <step> values". The "with sampling = <value> percent" will be preserved in the same way as a explicit "using <step> values" between update statistics commands. That is, a preserved explicit value will become the default when subsequent commands do not specify a value, ignoring the configured default.

CR:701299

CR Number:   701299 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2012 Fixed 26 Apr 2012 Reservation Made 27 Apr 2012 Fixed 12 Oct 2012 Fixed Description Implement variable network packet size for better performance.

CR:701310

CR Number:   701310 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE does not support the NOLOCK hint, but does not raise a warning or syntax error when it is used.

CR:701471

CR Number:   701471 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2012 Fixed Description After upgrading to ASE 15.7, DDLGEN may generate incomplete "lob_compression=" clauses in 'create table' DDLs. Workaround Description  sp_configure 'allow updates', 1 go update sysobjects set lobcomp_lvl=0 where type='U' and lobcomp_lvl is null go --and rerun ddlgen --or just modify ddlgen generated script removing the partial 'with lob_compression' clauses

CR:701512

CR Number:   701512 Product Name:   ASE Management Product Component:   Administration Client Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed Description This problem happens in ASEMAP 3.2.6 when object permission is granted to a role or a group in Table view. The Adaptive Server Enterprise does not allow granting object permission with with-grant option to a role or a group. It is corrected in ASEMAP 3.2.7.

CR:701575

CR Number:   701575 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2012 Added to user documentation Description The full logging for alter table feature also supports alter table partition command. But this feature does not support alter table lock command.

CR:701585

CR Number:   701585 Product Name:   Unified Agent Product Component:   Agent Server Status:   Closed OS:   Solaris Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 09 Apr 2012 Fixed 09 Apr 2012 Fixed 09 Apr 2012 Fixed 3.2.6 08 Jun 2012 Fixed Description The SCC server that hosts the RMS will not start on a Sun Solaris computer when the language is set to Chinese. The workaround is to edit the script $SYBASE/SCC-3_2/bin/sccinstance. Change the line that sets the path from 'PATH=/usr/bin:/bin:/usr/local/bin' to 'PATH=/usr/xpg4/bin:/usr/bin:/bin:/usr/local/bin'. Workaround Description  The workaround is to edit the script $SYBASE/SCC-3_2/bin/sccinstance. Change the line that sets the path from 'PATH=/usr/bin:/bin:/usr/local/bin' to 'PATH=/usr/xpg4/bin:/usr/bin:/bin:/usr/local/bin'.

CR:701608

CR Number:   701608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2013 Fixed Description Signal 11 in LeSarg::mapSarg is reported due to incorrect classification of Transitive Closure predicates, at optimization time. Workaround Description  Workaround 1 : ============================================================ forcing t1 to be the inner table, results in no SARGs, no err ============================================================ set forceplan on go SELECT * FROM table2, table1 where calc_start = calc_end and calc_end = CONVERT (datetime, start_date + '/' + CONVERT (varchar, datepart (yy, calc_end)) ) ==================== Lava Operator Tree : Set Force plan on==================== Emit (VA = 5) / NestLoopJoin Inner Join (VA = 4) / \ Restrict Restrict (0)(0)(0)(4)(0) (0)(0)(0)(14)(0) (VA = 1) (VA = 3) / / TableScan TableScan table2 table1 (VA = 0) (VA = 2) ============================================================ Workaround 2 : ============================================================ Forcefully disable the SARG creation by casting the SARGable columns ============================================================ i.e using CONVERT(datetime, calc_start) = CONVERT(datetime, calc_end) instead of calc_start = calc_end

CR:701629

CR Number:   701629 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2012 Fixed Description Adaptive Server Enterprise 15.7 > Performance and Tuning Series: Query Processing and Abstract Plans > Controlling Optimization > Viewing current optimizer settings There is a reference to 'auto_template_stats' This should read 'auto_temptable_stats'

CR:701632

CR Number:   701632 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Fixed 13 Apr 2012 Fixed 24 Apr 2012 One-off Provided 02 May 2012 Fixed 03 May 2012 Fixed 17 May 2012 Fixed Description The ASE server is unable to online an additional engine in Process kernel mode if Kerberos is enabled. The engine online will fail with the message, "engine <engine_id>, os pid <os_pid> exited" reported in the error log.

CR:701639

CR Number:   701639 Product Name:   SySAM Product Component:   FLEXlm Status:   Closed OS:   Linux Original Version:   11.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2012 Fixed Description On Dell powerdedge servers with RHEL6, hostid does not work for the purpose of generating a license.

CR:701688

CR Number:   701688 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2012 Fixed Description If the server is configured using multibyte charset, READTEXT with 'using chars/characters' option from compressed TEXT/UNITEXT/IMAGE column may encounter a signal 11 followed by a stack trace that includes the module txt__position() and readtext().

CR:701705

CR Number:   701705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP50 09 Apr 2013 Fixed 15 Mar 2013 Fixed 25 Mar 2013 Fixed Description New monitors have been added to collect each engine resource's Engine Local Caches (ELC) performance.

CR:701747

CR Number:   701747 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2012 Fixed Description ASE Reference Manual incorrectly states that Regular Expressions are supported. Currently only wildcard patterns _, %, [], and [^] are supported.

CR:701749

CR Number:   701749 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2012 Fixed Description Executing sp_monitorconfig 'all' will display 'kernel resource memory' twice but fails to display 'compression info pool size' information. Workaround Description  Run:- sp_monitorconfig 'compression info pool size'

CR:701958

CR Number:   701958 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description Feature request to have dumps made via the Backupserver API include all the default headers needed to allow them to be loaded without using the API.

CR:702011

CR Number:   702011 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Open OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Permission information is missing in some system procedures and commands.

CR:702014

CR Number:   702014 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2013 Added to user documentation Description Please add Permission information about 3 system procedures in Cluster environments.

CR:702022

CR Number:   702022 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2012 Fixed Description set option command of Interactive SQL Commands does not work as described in Reference Manual: Commands.

CR:702031

CR Number:   702031 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2012 Added to user documentation Description DocBug : System Administration Guide 2 ( DOCUMENT ID: DC31644-01-1570-01 / P191) DTM Option is included in base ASE license after ASE15.x.

CR:702038

CR Number:   702038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2012 Fixed Description In ASE Cluster Edition, error 941 may be reported when executing sp_configure "current audit table".

CR:702047

CR Number:   702047 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This is a new feature request to allow login triggers to set a session-level lock-wait limit.

CR:702073

CR Number:   702073 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 Fixed Description In situations whereby there may be existing in-memory identity information, it is possible for a insertion into a table with an identity column to produce a duplicate identity value after dump\load. This may be specific to a change in server-level 'identity grab size'.

CR:702161

CR Number:   702161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2012 Fixed Description A 712 message, "There is insufficient heap memory to allocate <number_of_bytes> bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.", may be reported when creating an index on a table with a large number of partitions.

CR:702162

CR Number:   702162 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2012 Fixed Description When an insensitive cursor is declared over a result set that contains at least two LOB columns and one of these columns is an in-row LOB with at least one result value actually stored in the row, a SIG BUS may be raised when the result set is FETCH. This error only occurs on platforms that require memory address alignment.

CR:702220

CR Number:   702220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_sysmon show confusing values for committed xacts per CPU unit in 15.7 in a low Engine utilization ASE.

CR:702240

CR Number:   702240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a housekeeper check for timestamp values increasing at an abnormally rapid rate.

CR:702339

CR Number:   702339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.7 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2012 Fixed Description After upgrading to release 15.7 ldap logins fail. Initial attempt fell back to ase login. Next attempt received 'Server is unwilling to perform'. Workaround Description  1. Reset the access accounts for the ldap servers: e.g. sp_ldapadmin 'set_access_acct', <access account>, <password> 2. Drop all attribues, Class 17 and re-do ldap setup. Note: the customer did this and it worked for him. I just did #1 and it worked fine for me.

CR:702345

CR Number:   702345 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2012 Fixed 28 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description In ASE Cluster Edition, if create database reuses the dbid of a dropped database, it may hang due to blocking on some locks.

CR:702355

CR Number:   702355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_helprotect now displays owner name as part of the object name column for objects like tables, database etc.

CR:702362

CR Number:   702362 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2012 Fixed 06 Apr 2012 Fixed 07 May 2012 Fixed Description In rare circumstances, the message "current process infected with signal 11" together with a stack trace may be reported when involving compressed tables.