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

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

CR:376291

CR Number:   376291 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) 13 Jan 2005 Fixed 14 Jan 2005 Fixed Description When incorrect keywords (MESSAGE PROPERTY, OPTION, etc) are passed to messaging builtins (msgsend(), msgrecv(), etc) The following error is reported Incorrect syntax near 'Invalid pointer param number 2, pointer value 0x10'.

CR:376303

CR Number:   376303 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2005 Fixed Description sp_monitorconfig 'permission cache entries' reports an active value greater than the configured value on the system. This misreporting occurs even on single engine cases without runtime re-configuration of permission cache entries.

CR:376344

CR Number:   376344 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) 13 Jan 2005 Fixed 13 Jan 2005 Fixed 02 Feb 2005 Not a Bug 24 Feb 2005 Presently Not Targeted For Any Future Release Of This Product Description ASE panic stacktrace in ksfreesocket after sp_listener operation Workaround Description  avoid doing the operations in the reproduction!

CR:376404

CR Number:   376404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2005 Fixed Description Application context SYS_SESSION fails to return results for attributes clientname, clientappname and clienthostname.

CR:376412

CR Number:   376412 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2005 Fixed Description Some SYS_SESSION application contexts, namely client_name, client_hostname and client_applname, can result in either wrong results.

CR:376419

CR Number:   376419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2005 One-off Provided 14 Feb 2005 Fixed 18 Mar 2005 One-off Provided 05 May 2005 One-off Provided 11 Apr 2005 One-off Provided 29 Jun 2005 Bundled Request Description ASE gives timeslice errors when heavy I/O operations are executed on RedHat Linux variant RHEL 3.0 version

CR:376482

CR Number:   376482 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) 21 Jan 2005 Fixed Description The stored procedure sp_tables does not show any user table but those owned by DBO if the executor has SA role but it is not the SA user.

CR:376490

CR Number:   376490 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2005 Fixed 28 Feb 2005 Fixed 31 Mar 2005 Fixed 26 Apr 2005 Bundled Request 22 Apr 2005 Fixed 17 Aug 2005 Fixed 28 Apr 2005 Fixed Description ASE running on the Windows Server 2003 platform does not produce correct stacktrace if ASE executable sqlsrvr.exe is not found in the current working directory. Workaround Description  Copy the sqlsrvr.exe executable to the server's current working directory. The working directory for an ASE that is started as a service is c:\winodws\system32 by default.

CR:376647

CR Number:   376647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed 05 Jan 2006 Fixed Description SELECT ... COUNT(<cnt_col>) INTO <new_tab> from ... GROUP BY ... results in a column with the same type as cnt_col instead of int.

CR:376755

CR Number:   376755 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2005 Fixed 14 Feb 2005 Fixed Description RTMS feature is supported on hppa64 platform as of ASE 12.5.3, however installmsgsvss script is not included in ASE 12.5.3 release. Also, instructions for post installation tasks on hppa64 platform for RTMS is missing in ASE 12.5.3 Coverletter. Workaround Description  *** Wednesday, January 12, 2005 2:42:54 PM *** cooperg *** Engineering thinks that the installmsgsvss file from Solaris should work. TSE will try it.

CR:376767

CR Number:   376767 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2005 Duplicate Description CIS : An error is reported when UPDATE and DELETE statements with TOP syntax are sent to remote servers that do not support the TOP syntax.

CR:376777

CR Number:   376777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2005 Fixed 09 Jun 2005 Fixed Description Add MIT Kerberos support on IBMAIX64 platform.

CR:376841

CR Number:   376841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2005 Duplicate Description Some queries involving data-only locked tables that are executed at transaction isolation level 3 (holdlock) may return an incorrect result set. Workaround Description  Force the plan.

CR:376858

CR Number:   376858 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2005 Fixed Description A 3939 error, "Illegal attempt to rollback transaction ... that has already committed in database '<temporary_database_name>'", may be reported if a session is interrupted with ^C during the dropping of a temporary table and the 3706 trace flag is turned on. The interrupted session is terminated abnormally and may not have its resources cleaned up. Workaround Description  Don't use -T3706 traceflag that forces the release of locks on catalogs at commit time.

CR:376861

CR Number:   376861 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2005 Fixed 07 Apr 2005 Fixed Description After user entered the password to configure an existing ASE with Syconfig, Syconfig displayed error message "Server '%1' is a pre-4.8 Sybase Server. It must be upgraded to at least version 4.8 before being used with auditinit.".

CR:376974

CR Number:   376974 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Duplicate Description Enable XML Services feature on HP-IPF machines

CR:377075

CR Number:   377075 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) 01 Feb 2005 Fixed 01 Jul 2005 Fixed Description A 9289 error, "RepAgent(5). Log record (1370, 17) contains inconsistent data. Transaction log may be corrupt" may be reported in a server with a multi byte character set when data inserted in a varchar column is longer than the definition of the column. This can happen for an insert using binary values for the character column.

CR:377105

CR Number:   377105 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) 08 Feb 2005 Fixed 05 Jul 2005 Fixed Description If the trace flag 9217 is active, the Replication Agent will not stop operating after having reported the error 9289 due to an inconsistent log record found. Instead it will attempt to continue the replication after having reported the error 9290 in the error log.

CR:377211

CR Number:   377211 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2005 Fixed 07 Jul 2005 Fixed 29 Apr 2005 Fixed Description LDAP User Authentication feature is ported to AIX 64bit platform.

CR:377282

CR Number:   377282 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) 08 Feb 2006 Insufficient priority to fix 19 Jul 2006 Fixed Description No error is shown when a text, image or unitext column of a proxy table appears in an order by clause.

CR:377300

CR Number:   377300 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) 19 Mar 2005 Insufficient priority to fix Description Customer has a problem with syblicenseslog table being in master, Even though the table will only grow roughly .02 MEG a year. Customer does not like to see the table growing under the Master database. Since the table is only a user table the customer would like the table moved to the sybsystemproc database or another database.

CR:377307

CR Number:   377307 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2005 Fixed 24 Jan 2005 Fixed 31 May 2005 Bundled Request 22 Apr 2005 Fixed 31 May 2005 Bundled Request Description Update ASE Plug-in to Sybase Central 4.3 and to co-exist with other Sybase Central Plug-ins under Sybase Central 4.3.

CR:377338

CR Number:   377338 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 Add date/time of Max_Used in sp_monitorconfig output

CR:377369

CR Number:   377369 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 Apr 2005 Fixed Description Message 209, Level 16, State 3: Ambiguous column name <column name> is raised when executing a stored procedure with the recompile option. The stored procedure contains a derived table expression which is referencing a temporary table column. The message is raised when the procedure is executed having a different @@tempdbid from the one the procedure was created under. Workaround Description  don't use user defined tempdbs

CR:377386

CR Number:   377386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2005 Fixed 07 Apr 2005 Fixed Description MIT Kerberos support is added for PA-RISC HPUX64.

CR:377426

CR Number:   377426 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) 09 Mar 2010 Duplicate Description FR to have a configure options to use the page ASE reads the second time when ASE find a page read from disk do not have correct page id , object id. (we raise Errpr 694) Workaround Description  N/A

CR:377437

CR Number:   377437 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2005 Fixed 15 Mar 2005 Fixed Description ASE running on multiprocessor Windows systems may occasionally fail to acknowledge cancel requests from client application causing the client application to hang in ct_cancel or ct_results.

CR:377473

CR Number:   377473 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) 19 Feb 2006 Fixed Description There are 3 issues with the conments list below: 1. The comment at the beginning of sp_helptext is wrong. It states that 18406 is a problem with "allow select on syscomments.text". However, 18406 is raise when sp_hidetext was run for the object NOT when "allow select on syscomments.text" is set to 0. Note that the quoted text is also incorrect; there is no "allow" in the configuration argument. 2. There is a next comment: /* ** If the configuration parameter 'allow select on syscomments.text' is set to ** 0, then the user can use sp_helptext ONLY in the following cases ** ** 1. if the user has sa_role ** 2. if the object is a system stored procedure ** 3. if the object is owned by the user ** */ It should include dbo as well because dbo or dbo alias could also run sp_helptext. 3. The text for error 18180 says: "Configuration Parameter 'allow select on syscomments.text' is set to 0. Only the object owner or user with sa_role can run sp_helptext on this object." Again there should be no "allow" in the parameter name and the message should includde dbo as well.

CR:377488

CR Number:   377488 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2005 Fixed Description The message infected with 11 in startscan() is raised together with a stacktrace written to the errorlog containing the modules 'curs_open', 'execute' and 'exec_eop', when a cursor statement contains a SELECT with a UNION- and a JOIN-clause using the REFORMATTING strategy, when the OPEN of the cursor is executed. The set option FMTONLY must be set on to see this issue.

CR:377503

CR Number:   377503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2005 Fixed Description After an upgrade to ASE 12.5.1 or above, a 7417 error may be raised by the DBCC CHECKCATALOG command run for the SYBSYSTEMPROCS database. Workaround Description  How to get rid of the 7417/7411 errors ? 1. shutdown with nowait + ASE restart 2. Or assuming ASE is 12.5.2 or above : sp_dboption "sybsystemprocs", "single", true go dbcc findstranded(sybsystemprocs) go sp_dboption "sybsystemprocs", "single", false go

CR:377508

CR Number:   377508 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2005 Fixed Description In the Transact-SQL User's Guide in Chapter 19 Transactions: Maintaining Data Consistency and Recovery, under Transaction modes and stored procedures, sp_proxmode should be spelled sp_procxmode. http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/sqlug/@Generic__BookView?DwebQuery=sp_proxmode

CR:377526

CR Number:   377526 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) 19 Apr 2005 Bundled Request Description The sp_ldapadmin check_login 'login_name' fails.

CR:377543

CR Number:   377543 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2005 Duplicate Description

CR:377571

CR Number:   377571 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2005 Fixed Description Not customer visible

CR:377617

CR Number:   377617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2005 Fixed 13 Jun 2005 One-off Provided 01 Jul 2005 Fixed Description On the Solaris platform, ASE tasks may hang indefinitely while waiting for disk I/O to complete. This will occur sometime after a different task encounters a fatal error, such as a timeslice error, while performing disk I/O. The stacktrace for the timeslice error will include functions such as aioread() or aiowrite(), kaio__daiostart(), and basis_daiostart. Workaround Description  None, other than to fix the O/S problem that caused the timeslice in the first place.

CR:377625

CR Number:   377625 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2005 Fixed Description Message 141, 'A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.' is raised when the result of derived table expression is assigned to a local variable. With fix the behavior is changed and it's now allowed to do so.

CR:377674

CR Number:   377674 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2006 Fixed Description A 624 error may be reported in case a database is dumped to an existing file and ASE crashes during dump operation.

CR:377713

CR Number:   377713 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) 29 Feb 2008 Added to user documentation Description As per QTS 258273 the Default number for the I/O Batch Size has been changed to 100 from 10

CR:377737

CR Number:   377737 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) 07 Feb 2005 Fixed Description The error 11206, "Unable to connect to server '%s'" followed by error 4002, "Login failed', will be raised if a procedure fired when a threshold is crossed tries to access an MDA table. Workaround Description  If you add the login as an external login to the same server (sp_addexternlogin loopback,KAYSER_C,KAYSER_C in my example where the login is KAYSER_C), then everything works fine.

CR:377803

CR Number:   377803 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 Sep 2005 Fixed Description In rare circumstances, a 9539 error, "Insufficient amount of memory per worker process to execute this parallel query. Increase the value of the configuration parameter 'memory per worker process'." may be reported in a server with a low number of worker processes and a high number of user connections. Workaround Description  Increase worker process memory using sp_configure "memory per worker process", <value>

CR:377912

CR Number:   377912 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2005 Fixed 24 Feb 2005 Fixed 24 Feb 2005 Fixed Description DDLGen generates NULL in Grant Statements for 'Update Statistics' and 'Truncate Table'

CR:377920

CR Number:   377920 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2005 Fixed 16 Feb 2005 Fixed DEFER 10 Jan 2006 Bundled Request Description Role and Login can be copy and paste (or drag and drop) to a ServerGroup, Server or similar type of object folder in different servers.

CR:377973

CR Number:   377973 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) 26 Jan 2005 Fixed 03 Feb 2005 Fixed 09 Feb 2005 Fixed Description In rare circumstances a 3474 error, "During redo the page timestamp value is less than old timestamp from log....", may be reported in the error log during recovery of a transaction which ,at runtime, was truncating a table around the time that a checkpoint was taking place. Workaround Description  Use the 3453 trace flag during recovery. This allows this timestamp check to be bypassed. This tracee flag must be used with care. See CR 224826.

CR:378029

CR Number:   378029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2005 Fixed Description The status bit 0x0001 in syslogins was set when users had short or null passwords, but the bit is no longer used. The internal upgrade process will reset it..

CR:378068

CR Number:   378068 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description GROUP BY <DATE NULL> produces output with multiple NULL groups

CR:378099

CR Number:   378099 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 Apr 2005 Fixed 09 Jan 2006 Fixed Description The sp_helprotect stored procedure does not display DELETE STATISTICS when this command is granted.

CR:378102

CR Number:   378102 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2005 Reservation Made 21 Feb 2006 Fixed Description Feature request to allow sqlupgraderes to perform all the necessary preupgrade checks WITHOUT actually UPGRADING. Currently this call can be done with the GUI sqlupgrade.

CR:378126

CR Number:   378126 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) 01 Apr 2005 Fixed Description A query using a compute clause on an empty table will cause a stack trace. For example, "select col1 from tabA compute max(col1)" will fail if there are no rows in tabA.

CR:378145

CR Number:   378145 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) 22 Feb 2005 Fixed Description The message "current process infected with 11" in the module 's_compile_stmt' together with a stack trace which includes the modules 's_compile' and 'sequencer', may be reported in the error log when the user has a soft binding with an user temporary database and both this user and the system temporary databases are not available.

CR:378184

CR Number:   378184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2005 Fixed Description When server's charset is SJIS, client charset is EUCJIS and builtin conversion (enable unicode conversion is set to 0 or 1) is used, 4847 error is raised with BCP IN command. Workaround Description  Use -Y option of BCP.

CR:378295

CR Number:   378295 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2013 Insufficient priority to fix 20 Dec 2005 Fixed 29 Nov 2006 Fixed Description When the web service consumer starts, refresh the consumer metadata so that external websebservice are accessible. Workaround Description  In addition to executing sp_webservices 'add' in the intended database, execute sp_webservices 'add' in the master database.

CR:378301

CR Number:   378301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2008 Fixed 20 Oct 2008 Fixed 10 Oct 2008 Reservation Made 11 Nov 2008 Reservation Made 11 Nov 2008 Fixed 19 Nov 2008 Fixed Description Message "Invalid column length", does not identify the database and object in the message.

CR:378391

CR Number:   378391 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) 09 Feb 2005 Fixed Description "Error: 702, Severity: 20, State: 1 Memory request for XXXXX bytes exceeds the size of a single page of 16384 bytes." together with "The SQL Server is terminating this process" may be found in the error log when concatenating strings together.

CR:378442

CR Number:   378442 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) 13 Mar 2006 Fixed 25 Oct 2006 Fixed Description BCP IN operation may report 2404 error when unilib conversion is enabled. Workaround Description  Try -Y option on bcp side.

CR:378481

CR Number:   378481 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2005 Fixed 08 Jun 2005 Fixed Description When UPDATE STATISTICS is run on a proxy table that has more than 1 index and the remote statistics is not available, error message 11290 Distribution statistics for column '<column name>' in index '<index name>' is unavailable or incomplete in the remote server. shows incorrect <index name> against the <column name>.

CR:378518

CR Number:   378518 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2005 Fixed 16 Nov 2006 Not reproducible with latest version of the product available as of Resolution Date Description CIS: When a table is marked for replication with sp_setreptable, updating the table with proxy text data results in Msg 605 error.

CR:378535

CR Number:   378535 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) 01 Feb 2005 Fixed Description Not to display SQL Preview and Scheduler Button for Java Wizard

CR:378541

CR Number:   378541 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2005 Fixed Description References to "SQL Advantage" and "JISQL" have been removed in ASE Plug-in. These two query tools are replaced by Interactive SQL, which has tighter integration with ASE Plug-in.

CR:378604

CR Number:   378604 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2005 One-off Provided Description INSTRUMENTATION : The message infected with 11 in sqt__release_chunks together with a stacktrace containing the modules 'sequencer','lwp_create' and 'sqt_deallocate' is written to the errorlog using dynamic SQL against the server. Workaround Description  n/a

CR:378615

CR Number:   378615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2006 Fixed 09 May 2006 Fixed Description System application contexts can be overwritten if issued in the same statement. Workaround Description  Select attributes one at a time into a temporary char variable.

CR:378698

CR Number:   378698 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2005 Fixed 01 Jun 2005 Fixed Description Changing execution class from EC0 to EC1 does not correctly reset process priority until the next login, it should happen immediately.

CR:378746

CR Number:   378746 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2011 Duplicate Description Feature request to enhance the error 4207 to include why and what the minimally logged operation was that prevented a dump tran. Workaround Description  Use the dbcc dbinfo(dbname) command to check on dbi_ldstate. If the value for this is anything other than 0x0, then it will not be able to issue a successful dump tran command. Also, based on what the value for this field is, one can even determine what was the non-logged operation that caused the 4207 error. For instance, if the bitmapped field is 0x4 = select into previously occured; 0x8 = dump tran with truncate_only occurred; 0x12 = bcp occurred.

CR:378748

CR Number:   378748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2005 Fixed Description Error 7742,"You must change your password using the sp_password system stored procedure before you can continue." can be raised at the secondary site in a HA environment if the password has expired in the primary, and sp_password is run to change it.

CR:378764

CR Number:   378764 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2005 Fixed 12 Apr 2005 Fixed 09 May 2005 Fixed 05 Jun 2006 Fixed 23 Jun 2005 One-off Provided Description A new ASE dataserver option -k and an environment variable SYBASE_PRINCIPAL are provided to specify an ASE principal name that is different from ASEs server name. This feature is applicable to an ASE configured for Kerberos authentication. Workaround Description  Issue 1) User name mapping to ASE acceptable login when multiple realms are used. --------------------------------------------------------------------------------- Issue is that ASE is receiving a "user@realm" login name after it authenticates the user using Kerberos mechanism. This "user@realm" needs to be translated to a login name acceptable to ASE such as "user". The customer also has the need to do a mapping from lower case to upper case login names. The sybmapname functionality can be used to filter out realm information and do other character mapping, such as lower case to upper case. This functionality is not found in documentation, except by reference, although it has been used to handle other customer cases. The sample program $SYBASE/$SYBASE_ASE/samples/server/sybmapname.c can be modified and compiled to run as a shared object. It is then placed in $SYBASE/$SYBASE_ASE/lib with permissions that allow only the 'sybase' user to read/write/exec the shared object. This workaround to be tried out by the customer at the customer site. Sybase support to provide additional information for building and using the sybmapname program to filter login names for ASE. Issue 2) ASE should support a method for specifying the server principal name. ------------------------------------------------------------------------------- ASE principal name can be specified as -C "server principal name" or by setting environment variable SYBASE_PRINCIPAL. Please refer Resolution#2(CR 378764-2) for more details

CR:378766

CR Number:   378766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Certification for Kerberos cross realm authentication

CR:378774

CR Number:   378774 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) 08 Feb 2005 Fixed 08 Feb 2005 Fixed Description User can't choose the location of sybsystemdb device in syconfig.exe. It always use the device at %SYBASE%\data\sybsysdb.dat.

CR:378782

CR Number:   378782 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) 04 Apr 2005 Fixed Description Preserve the functionality of traceflag 7703 indefinitely in all future versions

CR:378792

CR Number:   378792 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 13 Sep 2005 Fixed Description Documentation refers to incorrect location of libtcl.cfg. The correct location for this file is $SYBASE/$SYBASE_OCS/config

CR:378870

CR Number:   378870 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) 16 Feb 2005 Fixed Description A 109 error, "There are more columns in the INSERT statement than values specified in the VALUES clause" will be reported by optdiag when using the -i (input) option to load a statistics file that contains a column list with more than one column. Workaround Description  This issue happens during insert of stats by optdiag in. When there are existing statistics for the column combitation, optdiag does an update instead of insert. The update does not hit the 109 error. So an workaround should be: make sure there are statistics for the combination of columns, so opdaig will update them.

CR:378915

CR Number:   378915 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 Mar 2005 Fixed 23 Jul 2005 Presently Not Targeted For Any Future Release Of This Product Description Add IPv6 support for ASE on Windows 2003 and HP-UX 11i.

CR:379119

CR Number:   379119 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) 24 Aug 2006 Fixed 22 Sep 2006 Fixed 28 Sep 2006 Fixed Description The sp_sysmon application monitor report does not report data for processes or applications.

CR:379128

CR Number:   379128 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) 15 Sep 2006 Not a Bug Description sp_sysmon output for appl_and_login breakdown is not correct.

CR:379200

CR Number:   379200 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2005 Fixed 27 Jun 2005 Fixed Description The error (warning) message 11290 "Distribution statistics for column '<column name>' in index '<index name>' is unavailable or incomplete in the remote server. UPDATE STATISTICS will not run in import mode." is displayed if UPDATE STATISTICS on proxy table detects no entries in the remote systems statistics catalogs. This warning message will no longer be displayed.

CR:379391

CR Number:   379391 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer would like ASE to work under HP Work Load Manager. More information can be found in the attached documents and at the following web sites: http://docs.hp.com/en/netsys.html http://www.software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B8843CA http://www.usenix.org/events/osdi2000/wiess2000/full_papers/subramanian/subramanian.pdf Workaround Description  *** Monday, February 07, 2005 9:13:58 AM *** cooperg *** N/A

CR:379449

CR Number:   379449 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) 10 Feb 2005 Fixed Description Deadlocks involving system tables may sometimes happen when a REORG REBUILD command is being run concurrently with a CREATE TABLE command or other DDLs.

CR:379513

CR Number:   379513 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) 17 Mar 2005 Fixed 11 May 2005 Fixed Description The previous limit of eight databases for any QUIESCE DATABASE, MOUNT DATABASE or UNMOUNT DATABASE command has now been removed. Workaround Description  N/A

CR:379525

CR Number:   379525 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2009 Insufficient priority to fix Description When the expression joining a quantified predicate subquery is nullable, the optimizer uses a "Positioning at index start" instead of "Positioning by key" in a subquery. Workaround Description  select count(*) from k3 where convert(char(7),c3) not in (select c4 from k4) go

CR:379527

CR Number:   379527 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) 29 Mar 2005 Fixed Description "sp_procxmode" on a stored procedure prefixed with a database name different from the current database and no mode specification results in its mode getting set to "Chained"; if the procedure exists.

CR:379621

CR Number:   379621 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Database Tools Interface Status:   Closed OS:   Generic Original Version:   7.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.2 3034 14 Feb 2005 Fixed 9.0.1 1989 14 Feb 2005 Fixed 8.0.3 5215 14 Feb 2005 Fixed 8.0.2 4519 14 Feb 2005 Fixed 7.0.4 3540 14 Feb 2005 Fixed Description It was possible for the SQL Remote for ASE Message Agent to become deadlocked while doing conflict resolution, but the ASE Consolidated database would not detect the deadlock. The deadlock is now properly detected by the consolidated database and the offending thread is rolled back and retried by the Message Agent. This fix introduced a change to the SQL Remote system tables in the consolidated database. When the SQL Remote for ASE binaries are upgraded, the script ssupdate.sql must be run against the consolidated database as well, to ensure that the schema of the SQL Remote system tables matches what the binaries are expecting.

CR:379670

CR Number:   379670 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Ftp Messaging for Adaptive Server Enterprise Status:   Closed OS:   Linux Original Version:   9.0.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.2 3033 15 Feb 2005 Fixed 9.0.1 1988 15 Feb 2005 Fixed 9.0.0 1398 15 Feb 2005 Fixed Description On Unix systems the SQL Remote Message Agent may have prompted for link settings, (ie host, username, password), when using the FTP or SMTP message links. If an end-of-file character was read, a garbage link parameter may have been set. Workaround Description  Resetting Replication

CR:379715

CR Number:   379715 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 Jun 2005 Fixed Description Built-in audit_event_name() returns a non-NULL string for supported audit events only and returns NULL for unsupported events.

CR:379721

CR Number:   379721 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 enhancemdnt change request: create config option--revert to pre 12.5 method of assigning spid numbers to new connections prior to version 12.5 ASE assigned spid numbers to new conncetions using a ..."lowest free spid #" method. Now with ASE 12.5 the method has changed to..."least recently used spid" method. The config option would give the customer the option to switch back to the pre 12.5 method of ..."lowest free spid #" method.

CR:379771

CR Number:   379771 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) 11 Jan 2006 Fixed Description Feature Request to raise warning error message when setting the number of memory dumps greater than one, and the dump file name is not default. This can result in overwritting the dump file.

CR:379813

CR Number:   379813 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2005 Fixed Description Using 'SET STATISTICS TIME ON' to measure elapsed cpu time can result in negative time values.

CR:379852

CR Number:   379852 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2005 Fixed Description Temporary disable Monitor GUI in ASEP Galaxy Beta2 due to JRE1.1.8 remove from drop area No more Monitor Server selection in Server Properties or display of Monitor folder.

CR:379866

CR Number:   379866 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2007 Fixed Description On servers running multiple engines the data returned by queries on the monDeviceIO Monitoring Table may be incomplete.

CR:379887

CR Number:   379887 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) 17 Sep 2007 Fixed 03 Oct 2007 Fixed Description When a threshold procedure fails to execute due to permission problems, it is unclear from the "Login failure" error that the threshold procedure ownership is the cause of the failure.

CR:379911

CR Number:   379911 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) 17 Oct 2006 Fixed 18 Oct 2006 Fixed 09 Aug 2007 Fixed Description For socket migration engine 0 is always a possible target. When using specific execution binding, the socket migration does not restricts the search to the set of engines associated to the execution class. Workaround Description  None.

CR:379991

CR Number:   379991 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) 15 Feb 2005 Fixed Description The word "foreign" is misspelled as "forign" in error messages 1718 and 1724.

CR:380035

CR Number:   380035 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 Jul 2006 Deferred Description After a connection migration failure, new incoming connections to ASE hang. If there are several new incoming connections, the earlier hung connections get released but the later ones now hang.

CR:380036

CR Number:   380036 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) 03 Aug 2006 Fixed 29 Aug 2006 Fixed Description Socket migration is vulnerable to interruption by signals Workaround Description  None.

CR:380059

CR Number:   380059 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 Jan 2007 Fixed 19 Jan 2007 Fixed Description Feature request for a way to determine when a locked login became locked

CR:380069

CR Number:   380069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2005 Not reproducible with latest version of the product available as of Resolution Date Description If RS is rebooted without doing sp_start_rep_agent, ASE RA may not reconnect upon RS startup. Workaround Description  Stop the rep agent before rebooting the Rep Server.

CR:380074

CR Number:   380074 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2005 Fixed Description Default job timeout value is now 60 instead of 1800.

CR:380102

CR Number:   380102 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2005 Fixed Description sp_reportstats doesn't report chargeback accounting statistics for users with sa_role

CR:380122

CR Number:   380122 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2006 Fixed Description A query assigning and using the same variable in the qualification may fail with errors or produce incorrect result.

CR:380171

CR Number:   380171 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2005 Fixed Description CIS: When a setuser command has been issued on the session, create proxy_table command will fail with Msg 911 and 11206. Workaround Description  Define external login using sp_externlogin for the remote user we want to impersonate.

CR:380184

CR Number:   380184 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2005 Fixed Description The JS-XX_X directory has been moved under the ASE-XX_X directory and renamed jobscheduler.

CR:380209

CR Number:   380209 Product Name:   SQL Remote for Adaptive Server Enterprise Product Component:   Database Tools Interface Status:   Closed OS:   Generic Original Version:   9.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 9.0.2 3034 15 Feb 2005 Fixed 9.0.1 1989 15 Feb 2005 Fixed 8.0.3 5216 15 Feb 2005 Fixed 8.0.2 4519 15 Feb 2005 Fixed 7.0.4 3540 15 Feb 2005 Fixed Description The SQL Remote for ASE Message Agent will now check to ensure that its version is not greater than the version of the SQL Remote system tables that exist in the target database. Previously, only the version of the stableq system tables were checked by the Message Agent.

CR:380433

CR Number:   380433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2005 Fixed 10 Mar 2005 Fixed 01 Jul 2005 Fixed Description Applications using Dynamic SQL may encounter an "infected with 11 in sqt__release_chunks" message; modules 'sequencer','lwp_create' and 'sqt_deallocate' are found in the stack trace for the terminated connection in the errorlog. Workaround Description  n/a