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

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

CR:306210

CR Number:   306210 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Fixed Description When server's default character set is utf-8 (or other Asian character sets), server stack traces when creating over 16k nchar/unichar local variables.

CR:306222

CR Number:   306222 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed 31 Mar 2003 Presently Not Targeted For Any Future Release Of This Product 19 Feb 2003 Duplicate Description CIS: A 'sp_stop_rep_agent nowait' command, or a 'kill' of the RepAgent thread could result in "current process infected with 11" stacktrace on the following functions ra_ct_sendpassthru(), ct_sendpassthru(), and ksctsuspend().

CR:306265

CR Number:   306265 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2003 Fixed Description When used with Unichar values containing surrogate pairs, use of the "stuff" built-in function sometimes causes truncation of the resulting value.

CR:306276

CR Number:   306276 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2003 Fixed Description With 12.5.1, sp_deviceattr will print out a reboot message when 'dsync' attribute is changed. Eg: When 'dsync' is turned 'off' for device 'emp_dev' using sp_deviceattr, you will get the message: 'dsync' attribute of device 'emp_dev' turned 'off'. Restart Adaptive Server for the change to take effect.

CR:306295

CR Number:   306295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Sep 2006 Fixed 27 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 27 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 28 Aug 2007 Not reproducible with latest version of the product available as of Resolution Date Description dbcc checkstorage will unnecessarily abort after it receives an error 9962, "Access to table '%.*s' index '%.*s' in the target database failed." This can occur when dbcc checkstorage attempts to gather metadata for a table that is being dropped. Workaround Description  restart checkstorage after 9962 errors, or avoid dropping tables while checkstorage is getting underway.

CR:306333

CR Number:   306333 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2003 Fixed 29 Jan 2003 Fixed 13 Feb 2003 Fixed Description Under some circumstances Adaptive Server could send an additional return status when a stored procedure is invoked by a client application as a remote procedure call and a cancel attention is also sent by that client application.

CR:306353

CR Number:   306353 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2003 Fixed Description bcpintoa proxytablemappedtoOraclefails with Oracle erroORA-01036

CR:306457

CR Number:   306457 Product Name:   ASE Replicator Product Component:   Log Extract Status:   Closed OS:   Generic Original Version:   12.5.0.105P2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.109P6 27 Jan 2003 Fixed 2.0.0 05 Sep 2003 Fixed 2.0.0 25 Jul 2011 Insufficient priority to fix Description ASE Replicator: Executing dump database causes the Primary Connection to come down. Workaround Description  *** Thursday, January 23, 2003 12:25:02 PM *** dreiger *** There is no simple workaround. However, the user could quiesce the pdb, then dump the pdb, and then modify the primary connection to start reading from the end of the log.

CR:306552

CR Number:   306552 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2003 Fixed 07 Feb 2003 Fixed Description Error message reporting CHECK contraint violation may indicate incorrect constraint name or sometimes no name at all.

CR:306553

CR Number:   306553 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2003 Fixed 13 Jun 2003 Fixed Description In rare circumstances trailing control characters of a CREATE PROCEDURE or CREATE TRIGGER batch are not saved in syscomments.

CR:306566

CR Number:   306566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2004 Fixed 13 Feb 2004 Fixed Description The 'QUIESCE DATABASE RELEASE' command may fail to resume the update activity for a given database by raising an unexpected 2222 error. This may happen if ever the 'sp_configure' stored procedure was run subsequently to suspending the update activity for this database using the 'QUIESCE DATABASE HOLD' command. Workaround Description  None.

CR:306573

CR Number:   306573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2003 Fixed 28 May 2003 Fixed 04 Jun 2003 Fixed 02 Jun 2003 Fixed 02 Jun 2003 Fixed Description In rare cirumstances an 1127 error, "Internal Error: The OAM has no room for new inserts. Check OAM for object <value>, index <value>.", may be reported when there are very large number of concurrent page allocations resulting in the session being killed. A stack trace in the error log will report modules 'pg__oamspace', 'pg__allocoam' and 'pg__cond_insertoam'. Workaround Description  N/A

CR:306744

CR Number:   306744 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2003 Fixed Description Performance degradation may occur when running dbcc checkverify() because index selection may be skipped on the dbcc_faults and dbcc_fault_params tables in the dbccdb database.

CR:306753

CR Number:   306753 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2003 Fixed Description example one for use of proc_role in ASE 1`2.5 Ref Manual Vol. 1, chapter 2 (docid 36271-01-1250-01) is wrong: It reads: create procedure sa_check as if (proc_role("sa_role") > 0) begin return(1) end print "You are a System Administrator." The print statement is placed past the end of the proc definition. The correct code example should be: create procedure sa_check as if (proc_role("sa_role") > 0) begin print "You are a System Administrator." return(1) end

CR:306864

CR Number:   306864 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2004 Fixed Description When running parallel queries, the error message "ubo_object_from_slot: Sybproc invalid slot id 0" may may be reported in the error log together with a stacktrace which includes the modules 'ubo_object_from_slot', 'uwforeachchild', 'wt_pss_family_owners', 'lock__set_sleepingowner_list' and 'lock__check_deadlock'.

CR:306972

CR Number:   306972 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2003 Fixed Description In a very highly active High Available(HA) subsystem, where lots of user tasks are using a database and the system crashes, the database shutdown may not succeed complaining that there are active users currently using the datbase.

CR:306976

CR Number:   306976 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2003 Fixed Description With applications that use temporary tables having defaults defined on its columns from within stored procedures, deadlocks may sometimes happen involving tables Syscolumns and Syscomments. Workaround Description  Turn on trace flag 2808 to skip checking of presence of text of a compiled object(default, rule, view, procedure or trigger) in syscoments.

CR:307132

CR Number:   307132 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2003 Fixed Description In rare circumstances, a 7949 error may be reported after a transaction log has been loaded that includes a CREATE INDEX. Workaround Description  None, unless dumping transaction logs for recovery after an index creation can be avoided. The problem only happens in 'rare' circumstances and can be fixed running dbcc checkalloc with fix option.

CR:307212

CR Number:   307212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2003 Fixed 28 May 2003 Fixed 04 Jun 2003 Fixed Description Extend the 'force' option of dbcc upgrade_object() to force the recreate of a stored procedure from text in syscomments. Workaround Description  dbcc traceon(2810) go exec <proc> with recompile go

CR:307449

CR Number:   307449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2003 Fixed Description sp_checkresword shows in error that 'double and 'precision' are reserve words.

CR:307460

CR Number:   307460 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2003 Fixed 12 Mar 2003 Not a Bug Description 'About ASEPlugin' dialog now shows the build date of the plug-in. The copyright information is now better formatted. To open the dialog, select menu itme 'Help'->'About ASEPlugin'.

CR:307603

CR Number:   307603 Product Name:   Adaptive Server Enterprise Product Component:   sybsetup - PC Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2003 Fixed 09 Jun 2003 Presently Not Targeted For Any Future Release Of This Product Description RPM install overwrites customized files.

CR:307773

CR Number:   307773 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2003 Fixed 05 Nov 2003 Fixed Description When loading a transaction log dump containing a CREATE INDEX operation using a server that has a different buffer pool configuration from that at runtime, a 3474 or a 6902 error may be reported. Workaround Description  Try and use the same pool configuration. (Yet, there's no guarantee that the same pool get reused.) Alternatively, we may able to load the dump having turned on 3453 trace. dbcc traceon(3453) load the dumps in question. We need to verify that the page

CR:307785

CR Number:   307785 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   voyager Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2003 Fixed Description This feature allows the user to shut down a server from ASEPlugin. The server can be either shut down immediately (with 'nowait' option) or normally. During a normal shutdown, if the server doesn't go down after a certain time period, the user has a choice to continue waiting or shut down the server immediately.

CR:307797

CR Number:   307797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4/18/03 18 Apr 2003 Fixed Description On the Linux platform, improve shared memory address mapping to increase the upper limit of ASE's "max memory" parameter from roughly 2 gb to roughly 2.75 gb. Target Version  12.5.1 Review Status  Fixed in 12.5.1 Workaround Description  Right now there is now way to achieve > 2 gb of max memory on Linux.

CR:307857

CR Number:   307857 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2003 Fixed 12 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description The ASE Plugin will now check at the time the backup/restore wizard is started to determine whether the backupserver is running

CR:308175

CR Number:   308175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2003 Fixed Description If the ASE's default sort order is case insensitive 'nocase_iso_1',an index creation on a Data Only Locked table that has a lot of rows may cause 'dbcc checktable' to raise error 12905 "Index <indid> of object <objid> corrupt; key values in child page <pageid> inconsistent for parent page <pageid>. Drop and recreate the index". Workaround Description  Use session wide trace flag 12604

CR:308181

CR Number:   308181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2007 Fixed 27 Oct 2014 Insufficient priority to fix Description Feature request to enhance the resource governor so it can enforce limits against processes that are idle for a configurable amount of time. Target Version  To Be Determined Review Status  Will be implemented in a future release. Workaround Description  http://www.sypron.nl/sp__idleReaper.sql

CR:308220

CR Number:   308220 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2003 Fixed 10 Apr 2003 Fixed 29 Apr 2003 Fixed 29 Apr 2003 Fixed Description Space allocation is not optimal when BCP inserts rows into an indexed DOL table using a small batch size by using -b option.

CR:308247

CR Number:   308247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2003 Presently Not Targeted For Any Future Release Of This Product 18 Apr 2005 Duplicate Description The existing data type of count(*) is not enough for a customer's huge table. Workaround Description  For ASE15.0, use count_big(*) instead of count(*)

CR:308320

CR Number:   308320 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed Description The code for compiled objects is displayed on a panel. The code is not formatted correctly.

CR:308334

CR Number:   308334 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2003 Not a Bug Description ASE 12.5.0.2 on Linux RH 7.2 fails to start via rc script during OS boot. Workaround Description  Testing has shown that one work-around for this problem has been to: 1) edit the script $SYBASE/install/rc.sybase 2) Add the assignment of the env var LD_LIBRARY_PATH after existing entries SYBASE_ASE and SYBASE_OCS SYBASE_ASE=ASE SYBAS

CR:308383

CR Number:   308383 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2004 Consult Complete Description For standby database, message 9215 is in the ASE log, when this is a valid condition for a standby database in a warm standby envionment. Target Version  To Be Determined Review Status  Under review Workaround Description  None that I know of

CR:308432

CR Number:   308432 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2003 Fixed Description When selecting from a proxy table mapped to a directory and specifying a specific filename a search is done of all files.

CR:308518

CR Number:   308518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2003 Fixed Description When creating a clustered index with sorted_data option, error 1509 Severity 20 State 1 may sometimes occur: "Row compare failure of RIDs (<pagenum>, <rownum>) and (<pagenum>, <rownum>), keycnt = <keycount>, compflags = <value>, rowformat = <value>, minlen = <value>. Workaround Description  Re-issue create index command or remove the sorted_data option.

CR:308581

CR Number:   308581 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2003 Third Party Problem Description In an HA environment, if the primary machine fails (hardware failure), an outstanding HA connection waiting to receive data from the ASE on the primary machine may take a little over two hours to fail over properly. Decreasing the tcp keepalive time period on the OS system where the HA connection is running will avoid this problem.

CR:308621

CR Number:   308621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2003 Fixed Description The message "Logical Process Manager Error: Failed to use database with id 1. Check preceding errors related to usability of this database." is reported in the error log when loading database 'master' (with Adaptive Server started in 'single user' mode). This message doesn't affect the load and recovery of 'master' database.

CR:308659

CR Number:   308659 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2003 Duplicate Description Feature request to support the "with file = <name>" clause when using the dump compression feature. Target Version  12.5.2 Review Status  Targeted 12.5.2

CR:308668

CR Number:   308668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2003 Fixed 18 Apr 2003 Fixed 08 May 2003 Fixed 10 May 2003 Not a Bug 24 Mar 2004 One-off Provided Description Add support for a new server class, RPCServer. This will enable Backup Server, XP Server and any other Open Server applications to be handled as RPC servers.

CR:308752

CR Number:   308752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2003 Fixed 25 Nov 2003 Fixed Description A 325 error "Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact Sybase Technical Support." may be reported when executing a query with nested subqueries which contain an aggregate function like MAX() or MIN() on a table that is not correlated. Workaround Description  Use trace 370 or use forceplan

CR:308756

CR Number:   308756 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Fixed 18 Feb 2003 Fixed Description An 834 error, "Illegal attempt to clean buffer", may be reported in the error log if a user tries to log in to Adaptive Server while the master database is being loaded. Workaround Description  Ensure no one attempts login to the server. Then try load master database.

CR:308785

CR Number:   308785 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2003 Fixed 13 Jun 2003 Fixed Description A 8402, 6902 or 631 error may be raised during rollback of an "insert..select from view" statement where the view contains a union, and the view references a table in a different database to that where the table is being inserted into. Workaround Description  Do not use unions in the view for an insert..select type query.

CR:308823

CR Number:   308823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2003 Fixed 24 Mar 2003 Fixed 31 Mar 2003 Fixed Description In rare circumstances the END keyword of a T-SQL batch sent to the server used to create a stored procedure or a trigger could be missing from syscomments. This happens when the END keyword is the last keyword in the batch and there is no space or carriage return present after the END keyword. Workaround Description  put space or \n after last keyword or ANSI-style comment.

CR:308921

CR Number:   308921 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2003 Fixed Description It is not possible to audit the "mon_role" system role using sp_audit "all", "mon_role"

CR:308938

CR Number:   308938 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2003 Fixed Description Executing a readtext on a proxy table mapped to a directory, the length argument is ignored and all of the text is returned.

CR:309016

CR Number:   309016 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed 17 Feb 2004 Fixed Description Feature Request: Provide native, non-API based, compression for backupserver. Target Version  12.5.2 Review Status  Targeted for 12.5.2.

CR:309113

CR Number:   309113 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Unknown Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description Sql statement generated produces zero number of records when the wrong record number is captured. Target Version  To Be Determined Review Status  Under Review

CR:309170

CR Number:   309170 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin-Adaptive Server Enterprise Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2003 Fixed Description Add to documentation steps on how to recover a secondary companion from a secondary failover mode.

CR:309232

CR Number:   309232 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2003 Fixed 07 Mar 2003 Fixed 21 Mar 2003 Fixed 28 Mar 2003 Fixed 12 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description Finish button on a wizard is enabled when the wizard is ready to create an object. The user does not need to go to the last page of a wizard to create the object.

CR:309287

CR Number:   309287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2003 Fixed 20 Mar 2003 Fixed Description Error message 2358 is reported when running 'sp_modifylogin' under HA from user's default database which is not the master database. Error message 18897 is reported when user switched to the master database and running 'sp_modifylogin' there.

CR:309392

CR Number:   309392 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Dec 2003 Fixed Description With syconfig.exe 12.5, the upgrade task of backupserver may add an invalid '-i' option in RUN_SERVER_BS file and the registry. This problem prevents us from starting up backupserver. Target Version  12.5.1 Review Status  Targeted for 12.5.1 Workaround Description  W/A of the start error of backupserver is to remove an option '-i' from RUN_SERVER_BS and registry.

CR:309433

CR Number:   309433 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2006 Insufficient priority to fix Description Grid Result View truncates result set at 32760 rows without warning or error message when using SQL Advantage. Workaround Description  For large datasets do not use the grid view.

CR:309516

CR Number:   309516 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2003 Fixed 13 Mar 2003 Fixed 28 Mar 2003 Fixed Description EFTS: ICU locales and some filter files are missing.

CR:309558

CR Number:   309558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2003 Fixed Description A 105 error, "Unclosed quote before the character string ')'" will be raised by the stored procedures sp_password and sp_addlogin when trying to set a password that contains a single quote. Workaround Description  use 2 quotes

CR:309680

CR Number:   309680 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2003 Fixed Description Fixed a bug in which the server does not take into account static cache parameters while allocating new resources. This will result in ovecompensation of physical memory in a pre 12.5.1 ASE server.

CR:309719

CR Number:   309719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2003 Fixed 22 Apr 2003 Fixed 04 Jun 2003 Presently Not Targeted For Any Future Release Of This Product 05 Sep 2003 Fixed Description A 2762 error, "The 'CREATE TABLE' command is not allowed within a multi-statement transaction" will be reported when one of the stored procedures sp_tables, sp_stored_procedures or sp_ijdbc_stored_procedures is executed in an active transaction. Workaround Description  1.Use a version of sp_tables before fix 169725. -OR- 2.Use a version of sp_tables from the ODBC dir under a NT 12.0 installation. In the file ODBC-3_5\sycsp11.sql. Works with roles, but does not work for role included in other roles.

CR:309738

CR Number:   309738 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   AIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2003 Fixed 23 Jun 2003 Fixed Description CIS: A 911 error, "Attempt to locate entry in sysdatabases for database <name> by name failed", 195 error, "Incorrect syntax near ','", and 102 error, "<char> is not a recognized parameter option" may be reported when CREATE DATABASE...WITH DEFAULT_LOCATION...FOR PROXY_UPDATE is run against a remote table. Workaround Description  Dump the transaction log of the new database manually.

CR:309815

CR Number:   309815 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2003 Fixed Description CIS: Selecting rows from proxy table which is mapped to a RPC might give ct-library error and hang the dataserver on the subsequent select when the proxy table is defined with more columns than the total number of columns returned by the RPC which it is mapped to.

CR:309909

CR Number:   309909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2003 Fixed 30 Apr 2003 Duplicate Description The message "current process infected with 11" in the module 'vu_unionpushdown' together with a stacktrace which includes the modules 'pre_aggview' and 'tmp_preprocess' may be reported in the errorlog if a SELECT INTO having a UNION clause based on views which also contain UNION clauses is executed. Workaround Description  Enable traceflag 4402 to stop pushdown of views. However, this may have a performance impact.

CR:309945

CR Number:   309945 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2003 Fixed 12 May 2003 Fixed 12 May 2003 Fixed Description The peformance of the stored procedure sp_locklogin degrades in a HA environment when ASE contains a large number of logins and roles. Workaround Description  No workaround excpet to modify a system stored procedure (sp_locklogin).

CR:309989

CR Number:   309989 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   SQL Remote for Adaptive Server Enterprise Status:   Closed OS:   Microsoft Windows 2000 Original Version:   8.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 8.0.3 4592 06 Mar 2003 Fixed 8.0.2 4219 06 Mar 2003 Fixed 8.0.1 3101 06 Mar 2003 Fixed Description While scanning log operations into the stable queue, ssremote may have crashed when processing a particular set of log operations in a particular order. This bug is now fixed. Workaround Description  Short of trashing/skipping that section of the transaction log there is no workaround

CR:310001

CR Number:   310001 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2004 Fixed 12 Apr 2004 Fixed 24 Jun 2004 Fixed 13 Jun 2007 Fixed 22 May 2007 Fixed Description syconfig and sybatch delete the namepipe entry in sql.ini Target Version  12.5.1 Review Status  Targeted for 12.5.1

CR:310018

CR Number:   310018 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 Oct 2006 Fixed Description DBCC LOGTRANSFER with a context eauql to 100 does not display to the client columns xold_ts and xnew_ts for data modification log records on tables marked for replication.

CR:310026

CR Number:   310026 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2003 Fixed Description The extractjava and installjava binaries were missing from the 12.5.0.3 IR release. As a result, new binaries with fixes were not available in 12.5.0.3 IR

CR:310085

CR Number:   310085 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2003 Presently Not Targeted For Any Future Release Of This Product Description would like to have implemented a way for the server to migrate exisiting connections from an engine to another if engine is to be offlined.

CR:310095

CR Number:   310095 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2004 Not a Bug Description remove the uniqueness requirement csysservers index Target Version  To Be Determined Review Status  Under review.

CR:310184

CR Number:   310184 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2003 Fixed 12 Mar 2003 Presently Not Targeted For Any Future Release Of This Product Description A unique build number is provided for easy identification of the product. To see the build number, along with other version information, do one of the following: - Select 'Help'->'About ASEPlugin' menu item. A dialog shows up with the build information. - Select 'Help'->'About Sybase Central' menu item. A dialog shows the version string with the build information.

CR:310292

CR Number:   310292 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2003 Fixed 27 Mar 2003 Fixed 03 Oct 2003 Not reproducible with latest version of the product available as of Resolution Date Description CIS: signal 11 stack traces occur in syb_net_write or syb_net_read when remote connection is killed manually using 'kill spid' or when the remote server is shut down with 'no wait' option. Workaround Description  None.

CR:310384

CR Number:   310384 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2003 Fixed Description Under rare circumstances error 2525 may be raised by 'dbcc tablealloc' when run against a Data Only Locked table followed by a segmentation violation in module 'getpage_with_validation' with a stack trace in the error log resulting in the session being killed. Workaround Description  N/A

CR:310388

CR Number:   310388 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2009 Insufficient priority to fix Description XA: Enhancement request for keeping cursor open while making component call within same transction branch

CR:310441

CR Number:   310441 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2003 Fixed Description Document ASE's default locking behavior for uncommitted rows

CR:310444

CR Number:   310444 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.3 12 Sep 2003 Fixed 12.5.1 ESD#2 12 Sep 2003 Fixed Description EFTS: E3-0418 (VDK 2): None of the 1 source keys were valid, error in txtsvr log for query.

CR:310512

CR Number:   310512 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2003 Fixed 06 Mar 2003 Bundled Request Description The -u option of the Sun Cluster3.0 install/admin script 'syscadm' fails to UNMANAGE a resource group, if the resource group is not offline or if any of its resources are not disabled.

CR:310554

CR Number:   310554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2003 Fixed Description Monitoring table date column definitions are changed to 'datetime null' for all columns where the date could be null. Previously these were returned as 'Jan 1 1900 12:00AM'.

CR:310668

CR Number:   310668 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2003 Fixed Description The Extended Stored Procedure example, xp_echo on 64bit HP platform failed with error mesage, "Could not load library examples.sl".

CR:310685

CR Number:   310685 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Bulletin for Solaris Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2003 Fixed Description Request to either have an absolute path for 'whoami' in the utils.ksh script eg 'usr/ucb/whoami' or a document warning to have it set in the PATH variable.

CR:310689

CR Number:   310689 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2003 Third Party Problem Description ASE diagserver running on Sun Solaris may generate the diagnostic message "### kipollsignal: resetting sigmask" continuously in the errorlog. This problem is due to Sun Bug ID 4457358. To resolve the problem, install Sun patch 105210-41 for Solaris 2.6, 108244-03 for Solaris 7, 109384-02 for Solaris 8.

CR:310696

CR Number:   310696 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2003 Fixed 30 May 2003 Fixed Description The CHECKPOINT process will get blocked on a database marked as 'trunc log on chkpt' while DBCC CHECKVERIFY is being executed in that database. Workaround Description  Disable 'truncate log on chkpt' database option whilst running dbcc checkverify

CR:310699

CR Number:   310699 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2003 Fixed Description CIS: Temporary proxy tables (#tempTab) mapped to remote procedures do not support "parameter columns" with names beginning with underscores. Target Version  12.5.1 Review Status  Fixed in 12.5.1 Workaround Description  Avoid using #tempTable for proxy tables or avoid using underscore columns to pass parameters.

CR:310793

CR Number:   310793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Mar 2003 Fixed 06 Mar 2003 Fixed 10 Mar 2003 Fixed Description When a session opens multiple cursors on an object in a transaction that results in promotion to an exclusive table level lock on that same object, then other readers or writers accessing this object will not be blocked by this exclusive lock. An 820 error may be reported by the concurrent sessions that are trying to update the same pages. Workaround Description  Per farima's suggestion: In order to alleviate this problem, please have the client increase the threshold for lock promotions. The current value is 200. Alternatively, remove one of the cursors that the update is using as to only have one SH_INT.

CR:310798

CR Number:   310798 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Fixed Description EFTS: txtsvr aborts when using combination of sequence operators, max_docs and sort_by columns.

CR:310855

CR Number:   310855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2003 Fixed Description New functionality is added, so that CS- / CT-Library messages are printed at boot time when there's a CS- / CT-Library issue.

CR:310953

CR Number:   310953 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2003 Fixed Description remove all references to "load tran with standby_access", as it is incorrect syntax.

CR:310994

CR Number:   310994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2003 Fixed 12 Mar 2003 Fixed Description The sampling option of update statistics for DOL tables does not result in a significant performance improvement.

CR:311039

CR Number:   311039 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2003 Fixed 10 Apr 2003 Fixed 13 May 2003 Fixed Description When auditing an object with a long name (fully qualified database name and owner name), Msg 7604 "An unknown audit event type was received" will be reported. Workaround Description  either make sure that their total objectname size including dbname and owner name is under 30 chars or switch to the database using use dbname and then execute the select * into on the objectname.

CR:311044

CR Number:   311044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2004 Presently Not Targeted For Any Future Release Of This Product Description XPSERVER: xp_freedll failse with 'unable to unload' error due to incorrect parameter length. Recreate extended stored procedure using the following: create procedure xp_freedll @dllname varchar(25) as external name sybsyesp Target Version  To Be Determined Review Status  Under review Workaround Description  > use sybsystemprocs > drop procedure xp_freedll > create procedure xp_freedll @dllname varchar(25) as external name sybsyesp

CR:311102

CR Number:   311102 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2003 Presently Not Targeted For Any Future Release Of This Product Description Feature request to allow control of the housekeeper tasks at the database and/or cache level, such as an sp_dboption control over whether housekeeper will do garbage collection in a database in addition to the existing server-level sp_configure "enable housekeeper gc" setting, and a cache-level configuration corresponding to the "free write percentage" setting. Target Version  12.5.0.3 Review Status  With the changes made in 12.5.0.3 this should no longer be needed.

CR:311168

CR Number:   311168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2003 Fixed 12.5.1 25 Mar 2003 Fixed Description extractjava used to truncate extracted JAR files to a size of 32K. This problem has now been corrected.

CR:311175

CR Number:   311175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2003 Fixed 11 Apr 2003 Fixed Description When a java method executing within ASE uses the native JDBC facility to execute a query that contains at least one aggregation operation and an ORDER BY clause containing the DESC keyword, the server may terminate the connection.

CR:311206

CR Number:   311206 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2003 Bundled Request Description The following columns are monitor counters and will therefore be reset by sp_sysmon. The 0x00000002 bit is now set in the Indicators column of monTableColumns to indicate this fact: monCachePool.Stalls monDataCache.Stalls monDataCache.CacheSearches monDataCache.LogicalReads monDataCache.PhysicalWrites

CR:311229

CR Number:   311229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Fixed 15 Apr 2003 Fixed 05 May 2003 Fixed 05 May 2003 Fixed Description New monitors have been added to track the number of recompilations of stored procedures and the reason for these recompilations. In the same way, SP_SYSMON output have been extented to report these new values in the "Procedure Cache Management" section. Workaround Description  To avoid hitting issue 3) boot ASE with trace flag 2707 (granted that you are not anyhow interested to the MTDB feature).

CR:311461

CR Number:   311461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2003 Fixed 12 Mar 2003 Fixed Description When the procedure cache is fully utilized, most recently used procedure plans are discarded in favor of less recently used plans. This unintended change in the replacement policy results in more procedure reads and lead to a performance degradation. Applications that use EXECUTE <proc> WITH RECOMPILE, will observe a heavier degradation due to a higher need for caching new plans; creating these procedures using CREATE <proc> WITH RECOMPILE will improve the performance of ASE. Workaround Description  create the procedure with recompile instead of doing 'exec with recompile'. This prevents filling up of the cache which causes these replacements.

CR:311477

CR Number:   311477 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2003 Bundled Request Description The total number of parallel queries attempted by a process is added to the monProcessWorkerThread monitoring table as column ParallelQueries. The family identifier is also reported as column FamilyID.

CR:311574

CR Number:   311574 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2003 Fixed 19 May 2003 Fixed 22 Apr 2003 Fixed 23 Apr 2003 Fixed Description When there exists an application binding (to a specific temporary database or to the default group), and an application with a zero length application name logs into the server, the session gets assigned a temporary database based on the first application binding that gets retrieved from SYSATTRIBUTES. An application with a zero length application name will not have any application binding that it qualifies for. Further, it will not be possible to create an application binding for an application name of "" (i.e. the empty string). Workaround Description  There are two workarounds. The reasoning for the second workaround are provided, but no thorough testing has been done. 1) Have no application bindings, in which case a tempdb is assigned from the "default" group. 2) Create an application binding

CR:311604

CR Number:   311604 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2003 Fixed 22 Jun 2004 Fixed 15 Aug 2003 Fixed 03 Sep 2003 Fixed Description If user fails to connect to server with default charset, ASE Plugin will suggest user to reconnect using iso_1 charset, it will reconnect after get a confirmation from user.

CR:311691

CR Number:   311691 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2003 Fixed 03 Apr 2003 Fixed Description A 264 error, "Column name appears more than once in the result column list." may be incorrectly reported if a stored procedure tries to create a table with the same name as the procedure.

CR:311722

CR Number:   311722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2003 Fixed 25 Mar 2003 Fixed Description Fix for CR 196218 causes problems with char_length() reporting a wrong length on variables with a VARCHAR or VARBINARY datatype. This happens when the variable with CHAR / BINARY datatype is asigned to the variable with the VARCHAR / VARBINARY datatype. A new version of the fix for CR 196218 will be available later under CR 263837. Workaround Description  To use rtrim or ltrim on the variable on which char_length is to be called. e.g char_length(rtrim(@b))

CR:311724

CR Number:   311724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2003 Fixed 29 Jul 2003 Fixed 25 Jul 2003 Fixed Description In rare circumstances, Adaptive Server may incorrectly store SQL-text in syscomments when multiple control characters like spaces are present between certain SQL keywords. For example CREATE<space><space>TABLE could be stored as CCREATE<space>TABLE.

CR:311725

CR Number:   311725 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2003 Duplicate Description Sybmigrate fails with error 4847 when trying to migrate an ASE with a single byte default characterset to an ASE with a multi-byte default characterset Target Version  12.5.1 Review Status  Fixed in 12.5.1 Workaround Description  1)Manually bcp the table out and back in again using open client esd 9 or above with the -Y command line option 2)Traceflag 11224 was added to 12.5.0.3 to support transfer from iso_1 to UTF8. Turn this on in ASE or sybmigrate before starting migration.

CR:311733

CR Number:   311733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2003 Not a Bug Description Aggregate function in the Having clause returns 0 rows back Workaround Description  Either declare a variable and calculate the aggregate function before the having clause or if using this select in a stored procedure then break it into 2 sp's where 1st sp does the aggreagate function stuff and to the 2nd sp it will pass the return value