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

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

CR:399057

CR Number:   399057 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed 06 Feb 2006 One-off Provided 16 Apr 2006 Presently Not Targeted For Any Future Release Of This Product Description Feature request to support a secondary server in the case of DN lookup URL Workaround Description  Manually change the URL on failure or use failover feature of LDAP server.

CR:399077

CR Number:   399077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2005 Fixed Description Some memory usage improvement to histogram merging during optimization. This can significantly reduce the compilation time and the procedure cache consumption for some queries. Target Version  15.0 ESD#1

CR:399125

CR Number:   399125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2006 Fixed Description DBCC USEDEXTENTS has been enhanced to also report extent allocations on device fragments which do not reference any segments.

CR:399137

CR Number:   399137 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 3 problems to be fixed in the TSG doc: 1. For error 3019 replace severity level from 16 to 10 and also add info about severity level 18. 2. For error 3020 add info about severity level 18 3. Add information about error 3021 which is completely missing from documentation.

CR:399163

CR Number:   399163 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2005 Fixed Description ASE Plug-in previously only uses default RMI port (port number 9999) to communicate with Unified Agent. This now can be modified by opening ASE Plug-in preference dialog (Tools -> Adaptive Server Enterprise -> Preferences) and select "Use agent port number <port_number> by default" where user can set <port_number> to be the port number that ASE Plug-in should use.

CR:399320

CR Number:   399320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2005 Fixed 05 Aug 2005 Fixed Description Make the network listener immune to non fatal errors.

CR:399344

CR Number:   399344 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2006 Fixed Description DDLGen did not use to accept white spaces after the parameter types i.e. ddlgen -Usa [ no space after -U was allowed]. This did not match the standards of other applications like isql which used to accept spaces. This fix solves this issue, and users can specify white spaces after the parameter types i.e. ddlgen -U sa [now works!!!]

CR:399374

CR Number:   399374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2005 Fixed 06 Aug 2005 Fixed Description An incorrect RETURN status may be sent by Adaptive Server when executing a dynamic SQL statement which had to be internally recompiled, for example, due to a schema change for some of objects referenced by the statement. Workaround Description  Workaround is handle TDS_RETURNSTATUS token by coding it in ct library The code will have to look for CS_STATUS_RESULT after ct_results() call as seen in my sample code.

CR:399400

CR Number:   399400 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2006 Fixed 03 Nov 2006 Fixed Description The maximum value for "default network packet size" and "max network packet size" is 65535 as per the syscurconfigs table. However the maxiumum value ASE will allow the administrator to configure is 65024. Therefore this CR changes the syscurconfigs maximum to be 65024.

CR:399421

CR Number:   399421 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Aug 2005 Fixed Description INTERNAL ONLY: when JS Agent is enabled in a server being upgraded but the JS role names do not have the IDs that ASE expects for them, upgrade fails with a "duplicate key" error in sysusers for any database containing JS roles.

CR:399440

CR Number:   399440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2005 Fixed Description UPDATE all STATISTICS on a proxy table that has partitions results in a stacktrace with Server Error Msg 1142 "Invalid OAM page 0"

CR:399476

CR Number:   399476 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2006 Presently Not Targeted For Any Future Release Of This Product Description Use sp_version instead of sp_server_info in ASE 15.0 which provides detailed version information on each install scripts (installmaster, installmodel, installsecurity)

CR:399545

CR Number:   399545 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2006 Fixed 27 Apr 2007 Presently Not Targeted For Any Future Release Of This Product Description If recovery suspect granularity is set for page level and if a data-only locked table btree insert or delete log record is undone and if that page is found to be corrupted, subsequent page fetches will fail with Error 605: Severity: 21: State 1.

CR:399678

CR Number:   399678 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2005 Fixed 12 Jan 2006 Fixed Description Under certain circumstances, if ASE is startted with '-w master', then immediately restarted with '-w model', then restarted with '-m' followed by 'disk reinit' and 'disk refit', recovering tempdb may fail with error 806: Could not find virtual page for logical page 1280 in database 'tempdb'.

CR:399694

CR Number:   399694 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2005 Fixed Description DBISQL failed to import Excel 2.1 worksheet. This has ben fixed.

CR:399737

CR Number:   399737 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2005 Fixed Description Under rare circumstances a session may hang forever during a lock request despite the session having send an interrupt request to ASE (Control-C). This may happen if the session was waiting initially for the lock request and ASE receives the attention request just before it awakes this session in order to initiate a deadlock search. Workaround Description  Increase the "deadlock checking period" parameter. Use lock timeouts instead of a cancellation of the command.

CR:399782

CR Number:   399782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2009 Insufficient priority to fix Description When a stored procedure encounters an error, parameter values can return incorrect results. Workaround Description  to check @@error after the proc, it is set to 247 and so one ought not continue.

CR:399884

CR Number:   399884 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   SQL Remote for Adaptive Server Enterprise Status:   Closed OS:   Linux Original Version:   8.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.2 3168 05 Aug 2005 Fixed 9.0.1 2056 05 Aug 2005 Fixed 8.0.3 5285 05 Aug 2005 Fixed Description If SQL Remote for ASE hooks were defined in an ASE consolidated database, the ssremote output log would have indicated that the hooks had fired, but the stored procedures were not actually being executed. This has been fixed and the stored procedures are now being called. The list of valid SQL Remote for ASE hooks is sp_hook_ssrmt_begin, sp_hook_ssrmt_end, sp_hook_ssrmt_shutdown, sp_hook_ssrmt_recv_begin, sp_hook_ssrmt_recv_end, sp_hook_ssrmt_send_begin, sp_hook_ssrmt_send_end, sp_hook_ssrmt_msg_sent, sp_hook_ssrmt_msg_missing, sp_hook_ssrmt_apply_begin and sp_hook_ssrmt_apply_end.

CR:399952

CR Number:   399952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2005 Fixed 11 Sep 2005 Fixed Description When a local index is created on a partitioned table with a large number of partitions, then a large number of locks will be required to perform the implicit updates to sysstatistics. This fix will greatly reduce the number of locks required in this scenario to be a fraction of the previously required locks.

CR:399972

CR Number:   399972 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed 14 Oct 2005 Fixed Description Enable native XML support for HPIA64 platform

CR:399978

CR Number:   399978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2005 Fixed Description Attention during unmount operation is not properly handled. DBT3_UNMOUNT_IN_PROGRESS and DBT3_DBSHUTDOWN_FROM_ACCESS bits in dbtable are not cleared when we unkeep it. So, the database is not accessible to anyone after this.

CR:400034

CR Number:   400034 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2006 Fixed Description The correct @@error values can be got when we run xmlvalidate(),xmlextract() and xmlparse(), involving the options "null" and "message", meeting with some exceptions (such as the XML parser error).

CR:400036

CR Number:   400036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2005 Fixed Description The stored procedure 'sp_cacheconfig' of Adaptive Server sometimes does not list the buffer pools for an available cache in sorted order of pool size.

CR:400053

CR Number:   400053 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 14 Oct 2005 Fixed 15.0 ESD#1 14 Oct 2005 Fixed Description Previously Make Permanent button of Options dialog does not save preferences permanently. This has been fixed in build 3204.

CR:400058

CR Number:   400058 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Fixed Description A message indicating that the query enountered a signal 10 or signal 11 may occur in the server errorlog when a query is performed on the monProcessObject table. When this happens the query will be aborted and must be resubmitted.

CR:400122

CR Number:   400122 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed 10 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description Got stack trace when upgrade from text the computed columns that invoke SQLJ functions.

CR:400160

CR Number:   400160 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2006 Fixed Description CIS: In some circumstance, syntax error 102 will be reported when OR and like clauses coexist for a query involving a view on a proxy table Workaround Description  traceflag 11210, i.e. disable omni optimizer

CR:400194

CR Number:   400194 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2008 Insufficient priority to fix Description DBMS task is sleeping forever on hung native thread.

CR:400253

CR Number:   400253 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2006 Fixed 17 Mar 2006 Fixed 02 Jun 2006 Bundled Request Description After the preupgrade test in sqlupgrade, if you click the "Go Back" button, it takes you to the "sqlupgrade - Specify sybsystemprocs device" screen, instead of the options screen.

CR:400309

CR Number:   400309 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2005 Fixed 11 Aug 2005 Fixed 29 Aug 2005 Fixed Description Client applications requesting the ipaddr receives 64 characters instead of 15, potentially breaking a client application. This problem may appear on all platforms in 12.5.3 ESD#3 and the 12.5.3a GA releases. Workaround Description  added a resolv.conf file or added the host name and IP address to the file /etc/inet/ipnodes also eliminates the problem.

CR:400320

CR Number:   400320 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 01 Mar 2006 Fixed Description Corrected drop for EFTS for 12.5.4, with all needed files.

CR:400327

CR Number:   400327 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed 11 Jul 2006 Fixed Description The error 216 "Attempt to automatically drop temporary table failed." may be raised when the configuration parameter "number of locks" is under-configured.

CR:400341

CR Number:   400341 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2005 Fixed Description Syntax errors may be reported from the remote server when a select into query is executed on a proxy table and the local column names do not match the remote coumn names.

CR:400361

CR Number:   400361 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2005 Fixed 24 Oct 2005 Fixed 14 Mar 2006 Fixed 17 Aug 2003 Bundled Request Description sqlupgrade and sqlupgraderes report "Adaptive Server failed to restart" if one or more databases fail to recover.

CR:400368

CR Number:   400368 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2005 Fixed Description Job Scheduler install fails when configuration parameter 'check password for digit' is enabled.

CR:400393

CR Number:   400393 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 30 Mar 2006 Fixed Description sortkey('sjisbin') function does not work correctly with SJIS Hankaku-Katakana characters.

CR:400446

CR Number:   400446 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed Description The documentation is missing the caret in some range specifications, i.e. 2^31 is showing up as 231.

CR:400447

CR Number:   400447 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2005 Fixed Description A query with ORDER BY clause which assigns local variable from the view which has UNION ALL statement may fail to execute correctly. Stack trace may be logged in the errorlog file. Following modules may be reported in the stack trace: execute(), exec_eop(), run().

CR:400449

CR Number:   400449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2009 Insufficient priority to fix Description Feature request to raise an error if user code attempts to RETURN a reserved value

CR:400452

CR Number:   400452 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed Description An UPDATE of a local table joined to a proxy table, where the local text column is set to the value of a remote text column, can result in a stack trace that includes the routine syb10_text_read_init and omni_txcp_rem2txpgs.

CR:400479

CR Number:   400479 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 14 Oct 2005 Fixed Description Previously DBISQL command "output to" does not work for saving a single result set from a stored procedure, such as: sp_helpartition go output to sp_helpartition.txt go This has been fixed.

CR:400505

CR Number:   400505 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Aug 2006 Fixed 09 Jan 2007 Presently Not Targeted For Any Future Release Of This Product Description For logins ======= Delete: Can delete any logins except 'sa' and 'probe'. Cut: Can not cut 'sa' and 'probe' and also those are bound by at least one user, with a SSO role is a must for this action. For roles: ======= Delete: Can not delete the following system roles, with a SSO role is a must for this action. DTM_TM_ROLE HA_ROLE NAVIGATOR_ROLE OPER_ROLE REPLICATION_ROLE SA_ROLE SSO_ROLE SYBASE_TS_ROLE MON_ROLE WEBSERVICES_ROLE JS_ADMIN_ROLE JS_CLIENT_ROLE JS_USER_ROLE MESSAGING_ROLE Cut: Same condition as Delete needs.

CR:400554

CR Number:   400554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2005 Fixed Description The ipaddr column in sysprocesses may contain trailing junk when each field of the ip address contains 3 digits. Workaround Description  Use substring: select substring(ipaddr,1,15) from sysprocesses

CR:400585

CR Number:   400585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description save to system table CREATE INDEX's parameters 'consumers' and 'statistics'

CR:400662

CR Number:   400662 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2005 Fixed Description Various errors related to the TEXT pointer inconsistency may be raised when executing a query under trace flag 289 and the query references a view with union and is using convert function on TEXT data.

CR:400664

CR Number:   400664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2007 Fixed 23 Nov 2005 Fixed 05 Mar 2007 Fixed Description New built-in function pssinfo(<spid>, '<pss field>') that returns several fields of the process structure.

CR:400669

CR Number:   400669 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2005 Fixed Description CIS: A 2762 error, "CREATE TABLE command is not allowed within multiple statement transaction" may be reported when executing a SQL INSERT..SELECT from proxy table mapped to a RPC. This is resolved with a server-wide traceflag 11232 or a session level traceflag 11228. Either traceflag has to be turned on to allow CREATE TABLE command in the remote procedure.

CR:400746

CR Number:   400746 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed 20 Aug 2005 Fixed Description After upgrade to 15.0, the LCT value selected from systhresholds can differ from the in-memory value reported by sp_helpthreshold's invocation of lct_admin("reserve", 0). When this problem occurs, the in-memory value is correct, and the systhresholds value is slightly lower.

CR:400751

CR Number:   400751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2005 Fixed Description When exec_procedure auditing is enabled for system stored procedures sp_companion and sp_config_rep_agent, the password parameters are visible in the audit trail.

CR:400797

CR Number:   400797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2005 Fixed Description HA: When a cross database 'drop table' operation is performed on the primary node of an HA configuration, the operation succeeds on the primary but fails on the proxy database on the secondary node without error. Workaround Description  Do not perform cross table drop operation. If a drop table operation needs to be performed, only perform it after issuing a "use" on the table's parent database.

CR:400826

CR Number:   400826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2006 Fixed Description A new builtin rand2([integer]) is introduced which is evaluated for each row in the result set. The original builtin rand([integer]) was only evaluated once for the result set.

CR:400834

CR Number:   400834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2007 Fixed Description sqlupgrade takes too long time to start the offline server when the RUN_server file includes invalid config file or incorrect format.

CR:400907

CR Number:   400907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2005 Fixed 30 Aug 2005 Fixed Description Improve the performance of drop table in tempdb by extending the functionality implemented under CR 316222 to the drop of user objects in tmpdb. CR 316222 released the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started; this enhancement is triggered by -T3706 either at boot time or via DBCC TRACEON(3706).

CR:400910

CR Number:   400910 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2008 Fixed Description DBISQL 9.0.2 limits the number of result sets that it can display. This limit has been removed in DBISQL 11 (shipped with ASE 15.0.3).

CR:400948

CR Number:   400948 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Fixed Description Remote Job Scheduling wizard inappropriately displays the Load and SQL Editor buttons, implying that the user can modify the automatically generated job commands.

CR:400980

CR Number:   400980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2011 Fixed Description sp_monitorconfig "heap memory per user" does not show you bytes of Num_active and Max_Used. Workaround Description  Use the following query instead of sp_monitorconfig. select Num_active = config_admin(22, 399, 2, 0, NULL, NULL) * 2048 , Max_Used = config_admin(22, 399, 3, 0, NULL, NULL) * 2048 , Num_Reuse = config_admin(22, 399, 4, 0, "heap_mem_waits", NULL) go If you want to know number of bytes of each value per user, divide Num_active or Max_Used by the sum of "number of user connections" and "number of worker processes".

CR:401012

CR Number:   401012 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2005 One-off Provided 13 Dec 2005 Fixed Description An interrupt during an open cursor statement involving a light weight procedure may lead to a stacktrace in the errorlog with functions curs_release(), close_range(), sortend().

CR:401066

CR Number:   401066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2007 Fixed 22 Aug 2007 Fixed Description Error 3935, "Fatal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Abort tran-attached' state." may be hit in module 'xact_beginupdate' with a stack trace in the error log, when a rollback occurred during the execution of a stored procedure that is marked for replication. The module 'log_repproc_exec' will also be reported in the stack trace. Workaround Description  *** Tuesday, August 16, 2005 1:37:20 PM *** cooperg *** Don't replicate stored procedure. Not acceptable to customer at this time.

CR:401092

CR Number:   401092 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2005 Fixed 10 Oct 2005 Fixed Description When LDAP User Authentication feature is enabled and the LDAP directory service does not respond to connection or search requests from ASE, logins attempts will hang. This prevents further authentication requests from succeeding on any engine where this occurs. Messages such as "Waiting for native threads to be released, or for 'max number of native threads' to be increased." appear repeatedly in the errorlog after a number of login requests become blocked. When this message appears in the errorlog, other use of native threads are also prevented.

CR:401098

CR Number:   401098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2005 Fixed 17 Nov 2005 Fixed 09 Nov 2005 Fixed Description sp_helpartition reports the number of data pages per partition. This is extended to report the number of rows per partitions in addition to the number data pages.

CR:401149

CR Number:   401149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Fixed 23 Nov 2005 Fixed Description CIS: Ctrl-C on rpc mapped to a remote procedure will not cancel the execution of the remote procedure if it does not execute any SQL queries on the tables.

CR:401153

CR Number:   401153 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2005 Fixed 17 Aug 2005 Fixed 12.5.3 ESD#5 17 Aug 2005 Fixed 12.5.3 ESD#4 17 Aug 2005 Fixed Description sp_syntax does not include mount/unmount command help. The ins_syn_sql script is now included to complete the resolution of CR 350291.

CR:401167

CR Number:   401167 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2005 Fixed 17 Aug 2003 Not a Bug Description On 64-bit platforms, an infected with 11 message followed by a stacktrace may appear in the ASE error log due to the execution of the sp_shmdumpconfig stored procedure when a "message" type dump condition is configured in ASE. Workaround Description  A version of sp_shmdumpdisp that does not use the ssel_message() builtin is available: /usr/u/dwein/shmdumpdisp_fixed.sql Import this file using isql -i and it will recreate sp_shmdumpdisp with a "safe" version.

CR:401190

CR Number:   401190 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2005 One-off Provided 06 Mar 2006 Not reproducible with latest version of the product available as of Resolution Date 13 Jul 2006 Fixed 31 Jul 2006 One-off Provided Description A 102 error, "Incorrect syntax near ''." , may be unexpectedly reported when using "batch updates" (sending several dynamic sql statement executions in the same batch) and the statement that was already prepared had to be recompiled because, for example, the underlying table schema changed. Workaround Description  Do not use "batch updates": i.e. sending several dynamic prepared statement executions in the same batch.

CR:401237

CR Number:   401237 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Not a Bug Description The compression API does not support multiple dump files per device.

CR:401238

CR Number:   401238 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2006 Fixed Description The Job Scheduler task may die unexpectedly if it is unable to handle an exception raised by Adaptive Server Enterprise. A message like "-> JS: js__execute; run [CHECK WAKEUP]" together with module name such as "terminate_process(), close_network() ... jobscheduler()" may be seen in the errorlog.

CR:401242

CR Number:   401242 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2007 Fixed Description Improve wording of dbcc message 7912 to indicate that dbcc FIX option has fixed the condition.

CR:401249

CR Number:   401249 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2005 Fixed Description Put Directory Services Editor under ASE Plug-in utilities tab for Unix platforms.

CR:401265

CR Number:   401265 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2005 Fixed Description The Job Scheduler Administration dialog always indicates the Job Scheduler is not running, even when it is running. Workaround Description  User must use the command line to start or stop the Job Scheduler, and must ignore the status shown in the JS Admin window.

CR:401279

CR Number:   401279 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2005 Fixed 07 Sep 2005 Fixed Description Error 632, Severity: 20, State 9, during upgrade to 15.0, if the pre-15.0 installation had system catalogs bound to named caches and if the caches are not defined in the config file used during upgrade. This problem will not occur if the upgrade is performed through sqlupgrade.

CR:401281

CR Number:   401281 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2005 Fixed Description Negative zero value may be inserted into a float column on HP-UX and Linux platforms only.

CR:401306

CR Number:   401306 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2005 Fixed 13 Sep 2005 Fixed Description Enable native XML support for Linux AMD64 platform.

CR:401336

CR Number:   401336 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2005 Fixed Description This fixed the following wrong result bug: if you have an equi-join clause between two different length char() and char()/varchar() type columns and also use char_length() on one of the columns, the result of the char_length() is indeterminate and is a function of the final plan because we have different truncate models for the equi-join and char_length() on char() type columns. Here is an example: create table t1 (sid char(8), styp char(5)) go create table t2 (sid char(16)) go select char_length(a.sid) from t1 a, t2 b where a.sid=b.sid and styp = 'R1' go The same for binary() and varbinary() with data_length(), unichar() and univarchar() with char_length(). Target Version  15.0 ESD#1

CR:401382

CR Number:   401382 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2005 Fixed Description sp_helprotect was not showing the 'Decrypt' permissions that were granted. Workaround Description  1> update master.dbo.spt_values set number = 353 2> where name = 'Decrypt' and type = 'T' 3> go

CR:401385

CR Number:   401385 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2005 Fixed 08 Nov 2005 Fixed Description Error when executing trigger after an alter table .. decrypt a column. Misleading error when altering a column that belonged to a clustered/placement index Workaround Description  Drop index, run alter on table to encryt column and recreate index.

CR:401397

CR Number:   401397 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 14 Oct 2005 Fixed Description Previously DBISQL does not refresh database dropdown list when "create database" statement is inside a if...else statement. This has been fixed.

CR:401414

CR Number:   401414 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2005 Fixed Description Scheduled Job Summary says that the Job Timeout value is in seconds instead of minutes.

CR:401442

CR Number:   401442 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed Description If an exception occurs during an internal sort, a subsequent query execution will result in the process termination with Error 706, Severity 20 and State 3.

CR:401500

CR Number:   401500 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Fixed 11 Jan 2006 Duplicate Description For unsigned integers, sp_datatype_info should return the user syntax "unsigned <int>", not the internal name "u<int>

CR:401523

CR Number:   401523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2007 Fixed Description Add Mnemonic Keys for Unix ICU tools GUI.

CR:401537

CR Number:   401537 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed Description 508: Correct the bug that table items cannot be access by up and down arrow.

CR:401538

CR Number:   401538 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2007 Fixed Description syconfig did not support mnemonic keys

CR:401543

CR Number:   401543 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support for the configuration parameter "allow backward scans" is unavailable. Therefore, even if it is disabled Adaptive Server is selecting plans containing "backward scans".

CR:401546

CR Number:   401546 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed Description 508: When SQL Preview dialog close, focus should go back to the dialog that spawns the Preview dialog.

CR:401561

CR Number:   401561 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2008 Fixed Description Select statements failing with 701 do not show up in monSysStatement.

CR:401595

CR Number:   401595 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2006 Fixed 22 Sep 2005 Fixed Description A 702 error, "Memory request for 49858 bytes exceeds the size of single page of 16384 bytes." together with a stack trace which includes the modules 'cpyconstvalue' and 'memalloc' may be reported in the error log for a SELECT INTO statement with a aggregate on a string longer then 16384 characters.

CR:401660

CR Number:   401660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2006 Fixed 27 Aug 2005 Fixed Description In ASE 15.0, after Load Database has loaded a database dump that was created by an ASE executable of a version preceding 15.0, if there should be a system failure during the Online Database command, then the ensuing boot recovery may see error 605 (page uninitialized) or error 692 (wrong object affinity) or error 806 (page number out of range) while recovering the same database. Workaround Description  Reload the DB Dump

CR:401680

CR Number:   401680 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed Description When ASE's default charset is multi-byte charset, if a specified object name string contains more than three dots (full object name is in the format of server_name.db_name.owner_name.obj_name), server stack traces.

CR:401682

CR Number:   401682 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2005 Fixed 28 Aug 2005 Fixed Description When the 15.0 server runs against an installation created by ASE version 12.0, and the 15.0 server is started using the 'DE' license, it will print a message stating that a graced license has expired. ASE will then shut down. This problem does not occur when using the 'EE' license.

CR:401684

CR Number:   401684 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2005 Fixed Description When an error is encountered by the server during recompilation of a stored procedure the session may be killed, and a stack trace may occur with error 216: "Attempt to automatically drop temporary table failed." This error is spurious and no temporary object will remain in the temporaray database.

CR:401715

CR Number:   401715 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2005 Fixed Description Enable end users configure WebServices logging level dynamically via stored procedure "SP_WEBSERVICES".

CR:401718

CR Number:   401718 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2005 Fixed Description proc_role() may return incorrect results if run in parallel. Workaround Description  add (parallel 0) after table / alias definitions or unconfigure parallelism.

CR:401742

CR Number:   401742 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1 02 Feb 2006 Fixed Description Windows Only: When perfmon is used with ASE 15.0, ASE counters are not visible in the perfmon utility to monitor.

CR:401743

CR Number:   401743 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2006 Fixed Description If user do not has permission to table syssrvoles, will get error message "SELECT permission denied on object syssrvoles, database master, owner dbo" when selecting permissions tab under a stored procedure that login owns in Sybase Central. This behavior is corrected so user can still access this tab and read permission for users and groups (roles is blocked).

CR:401753

CR Number:   401753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2005 Fixed 29 Aug 2005 Fixed 28 Aug 2005 Fixed Description This fixes a stacktrace for parallel plan when the plan is inserting into a table with identity column using SELECT DISTINCT and one of the SELECT DISTINCT list items is an expression. Target Version  15.0 ESD#1

CR:401755

CR Number:   401755 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2006 Fixed 01 May 2006 Fixed 02 Jun 2006 Bundled Request Description The installer placed the Full-Text Search server log in $SYBASE/ASE-15_0/install directory. It should be in $SYBASE/EFTS-15_0/install directory.

CR:401779

CR Number:   401779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2005 Fixed 03 Oct 2005 Fixed 13 Jan 2006 Presently Not Targeted For Any Future Release Of This Product Description When a 11.9 or 12.0 installation is upgraded to 15.0, dbcc checkstorage() on the master database may report faults 100029 , 100038 on the first page of the syscharsets text index.

CR:401834

CR Number:   401834 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2006 Fixed Description Customer reported that after applying EBF 12338 to ASE 12.5.2 release, Sybase Central ASE Plug-in stopped displaying Java Objects folder. The same problem seemed to persist after upgrading to 12.5.3. If such problem is encountered, it has advised to update ASE Plug-in to at least 12.5.4, which does not exhibit the error. (12.5.4 ASE Plug-in verified: Sybase Central ASE Plug-in/12.5.4/GA Build 1/S/1.4/ase1254dev//Thu Mar 2 17:00:13 PST 2006) Workaround Description  We can install packages, java classes and JAR files using commands via ISQL

CR:401843

CR Number:   401843 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2006 Fixed 02 May 2006 Fixed 10 Mar 2006 Fixed Description Assertion failure in Monitor Client library (SYDateTimeValue::init ())when client application uses cs_ctx_global() without CS_VERSION_110. Workaround Description  Avoid cs_ctx_global(CS_VERSION_110). This is impossible when client application requires functionality from a different version.

CR:401895

CR Number:   401895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2005 Fixed Description Error 1204 occurs during installjsdb after an upgrade to ASE 15.0 and if the configuration parameter 'number of locks' is insufficient. The preupgrade utility has been augmented to report the required number of locks.