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

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

CR:393849

CR Number:   393849 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 Nov 2006 Fixed Description F.R. LDAPUA to have persistent connections from ASE to the LDAP server

CR:393895

CR Number:   393895 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2005 Fixed 07 Jul 2005 Fixed 17 Jun 2005 Fixed Description Makefile make.unix provided for sample program sample/esp/xp_echo.c does not work on IBM AIX 64bit platform.

CR:393940

CR Number:   393940 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 Oct 2007 Deferred Description With trace 4418 ON the view materialization is no longer necessary for a view which is an inner member of the outer join and the view returns NULL constant.

CR:394172

CR Number:   394172 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   AIX Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Fixed 12 May 2009 Fixed Description License Monitoring is counting spids supporting the Job Scheduler as licensed users.

CR:394178

CR Number:   394178 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2005 Fixed Description sjobcontrol stored procedure does not stop JS immediately when stop_js command is issued.

CR:394179

CR Number:   394179 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2005 Bundled Request Description JS stored procedure sjobcontrol does not return 0 for success for all the command options.

CR:394278

CR Number:   394278 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2005 Fixed 05 Jul 2005 Fixed Description Error 20019 "Attempt to initiate a new SQL Server operation with results pending." will be reported by a dblibrary routine that tries to send new commands to the server after a successful call to dbwritetext().

CR:394341

CR Number:   394341 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2005 Fixed 17 Jun 2005 Fixed Description Typo in an informational message when running Sybmigrate. "Migrate database data is not allow because migrate server data wasn't selected during the setup session." Should be 'allowed' instead of 'allow'

CR:394365

CR Number:   394365 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2006 Fixed Description Server Groups folder Details panels now displays "n/a" (Not Available) on version/platform/status columns when the information is not available, i.e. when ASEP is not connected to the server and the server is not monitored by Unified Agent.

CR:394444

CR Number:   394444 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) 01 Oct 2007 Deferred Description Trailing spaces are lost from fixed char data type columns when you run UNION query with OUTER JOINs.

CR:394510

CR Number:   394510 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 Feature request for a method to convert DATETIME values to strings using flexible format-strings rather than predefined styles

CR:394524

CR Number:   394524 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2005 Fixed 04 Nov 2005 Fixed Description The number of private buffers for parallel query plans were not being accurately calculated and claimed. This could result in infinite loops in the cache manager where somewhere higher on the stack a Lava expensive operator was attempting to grab a buffer.

CR:394527

CR Number:   394527 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 2010 Fixed Description sp_helpconfig does not return error when groupname passed as configname

CR:394529

CR Number:   394529 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2005 Fixed Description configname options static,dynamic & read-only not documented for sp_helpconfig

CR:394542

CR Number:   394542 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed 31 Aug 2009 Fixed Description A Dump or Load command that uses an archive device name with newline character in it hits a segmentation fault in sybmultbuf.

CR:394544

CR Number:   394544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: need a 'user' version of sybmon

CR:394709

CR Number:   394709 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 Jan 2006 Fixed 15 Jan 2006 Fixed 08 Mar 2007 Fixed 23 Jul 2007 Fixed 09 Mar 2006 Fixed Description The table in the second argument to sp_monitorconfig will not be created if it does not exist.

CR:394717

CR Number:   394717 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2005 Insufficient priority to fix Description datediff in a trigger causes overflow at runtime error Workaround Description  Update one row at a time and it works fine.

CR:394750

CR Number:   394750 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2005 Fixed 28 Jul 2005 Fixed Description Killing a spid with status "MAINTENANCE TOKEN" during login authentication with Kerberos when traceflag 7844 is used, blocks all Kerberos activity on the engine. A dataserver should be run with traceflag 7844 when MIT 1.3 Kerberos libraries are used to workaround concurrency problems within the MIT Kerberos client libraries.

CR:394754

CR Number:   394754 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed Description The Adaptive Server Enterprise 32-bit Express Edition on Linux has the 2GB memory configuration and hence the configuration 'enable extended cache' is not a valid option for the server.

CR:394825

CR Number:   394825 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2005 One-off Provided 14 Dec 2005 Fixed Description Monitor Server in an SSL configuration may crash after several hours of running.

CR:394843

CR Number:   394843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2006 Fixed 05 Jan 2006 Fixed Description XFS: Update to filename in proxy tables mapped to file system directories using the recursion option may fail with error message Msg 11277 when a constant string is concantenated to the filename. Workaround Description  Use this update command which finds and updates the filename part, trimming off the directory path: /* This update finds and changes just the filename without the dirname ** and it succeeds. */ update jDir set filename = isnull(substring(filename, char_length(filename) - charindex('\',reverse(filename))+2, char_length(filename)),filename) + "_UPD" where filetype = 'REG' go select convert(char(40),filename), filetype, size from jDir go

CR:394869

CR Number:   394869 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) 22 Jun 2005 Fixed Description Command line trace flag 7603 is no longer supported. The client's IP Address is always logged as part of the LOGIN Audit Event.

CR:394880

CR Number:   394880 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 Jul 2005 Fixed Description An Infected with 11 stacktrace containing functions omni_getnext and exec_eop is generated when a query uses an aggregate function against a DATE column in a proxy table defined against an ASIQ table. Workaround Description  Instead of using the create proxy_table syntax to generate the proxy table: First create the object definition with sp_addobjectdef, then create the proxy table with the create existing table, using the DATETIME datatype to map to the ASIQ column.

CR:394913

CR Number:   394913 Product Name:   ASE Replicator Product Component:   Plug-ins Status:   Closed OS:   Generic Original Version:   4.0.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2012 EOL'd version. Not to be Fixed. Description Selecting the "Advanced" button in the "Add Subscription" wizard causes a stack trace condition that you can ignore. The stack trace will not impact the functionality of the Add Subscription process. Workaround Description  Just hit OK on the stack trace, and keep going!

CR:394927

CR Number:   394927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2005 Fixed Description A 221 message, "Column of type (BIT) does not allow nulls. It may not be compared with null." is raised when assigning the result of SELECT to a variable of type BIT. The SELECT is from a view with a UNION ALL clause with a select-list having a column of type BIT.

CR:395095

CR Number:   395095 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2005 Fixed 10 Jan 2006 Fixed Description Include license info from sp_lmconfig

CR:395119

CR Number:   395119 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2005 Fixed Description On windows platforms only the sybmigrate tool for ASE 12.5.3 fails to start with ASE 12.5.3 ESD#1 or ASE 12.5.3 ESD#2 installed. The error at startup is: Exception in thread "main" java.lang.NoClassDefFoundError: com/sybase/util/ds/ldap/LDAPWarning Workaround Description  Edit the %SYBASE%\%SYBASE_ASE%\bin\sybmigrate.bat file and do the following... A) fix the spelling of... %SYBASE%\%SYBASE_ASE%\lib\iniparser.jar; ...and put it back to... %SYBASE%\%SYBASE_ASE%\lib\dsparser.jar B) fix path to the following files... dsparser.jar, jndi.jar, ldap.jar, providerutil.jar, DDLGen.jar the path needs to be... %SYBASE%\shared-1_0\lib\ ...instead of... %SYBASE%\%SYBASE_ASE%\lib\ C) fix %SYBASE%\%SYBASE_ASE%\lib\3pclasses.jar ...needs to be changed to... %SYBASE%\ASEP\lib\3pclasses.jar D) ignore %SYBASE%\%SYBASE_ASE%\lib\LDAPparser.jar; ...this is missing from within the %SYBASE% directory structure... ...sybmigrate.bat at least starts when this file is missing... ...if it is necessary for this file to be accessible by sybmigrate, then engineering will need to provide this file to the customer before this workaround will fully resolve the problem

CR:395125

CR Number:   395125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2006 Bundled Request 04 Dec 2006 Presently Not Targeted For Any Future Release Of This Product 09 Jun 2006 One-off Provided 05 Jun 2006 Fixed Description ASE running on Linux kernel 2.6 and above on amd64 platform encounters I/O performance degradation. This is because librtkaio support has been withdrawn on these linux kernel versions and by default POSIX AIO is used. Enable trace flag 1649 to use Linux Kernel Asynchronous IO.

CR:395240

CR Number:   395240 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2006 Fixed 20 Dec 2006 Fixed Description Dump database on tape using "with compression = compress_level" option works fine but load fails with a read error. Workaround Description  Suggested customer to use disk device or not to use "with compression " option on tape device. Modern tape device has its own compression turn on automatically. So there is not much gain using compression to a tape, only negative impact of CPU usage and doing extra work on 2 ends.

CR:395321

CR Number:   395321 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed Description Java support is enabled for Linux AMD64.

CR:395497

CR Number:   395497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2005 Fixed Description A new feature has been added to allow a load of 15.0 database dump file from a byte-swapped architecture.

CR:395523

CR Number:   395523 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2005 Fixed Description The command 'sp_encryption system_encr_passwd, null' fails with a message 'Message number 19339, passed to RAISERROR, does not exist in the sysmessages catalog.'

CR:395712

CR Number:   395712 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2005 Fixed Description Use valid_name( 'name', 255 ) for checking object names with large identifier support

CR:395732

CR Number:   395732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description During sec_session_close the Kerberos security session context is freed. During heavy login and disconnect processing the sec_memfree can get a segv.

CR:395745

CR Number:   395745 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) 10 Aug 2005 Fixed 07 Jul 2005 Fixed Description sp_encryption 'remove_catalog' fails to give an error when it finds a column encrypted by a given key in the same database. It removes the sysencryptkeys system table in preparation for downgrade without adequate checking.

CR:395749

CR Number:   395749 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) 30 Sep 2005 Fixed 07 Jul 2005 Fixed 17 Aug 2005 Fixed 08 Nov 2005 Fixed Description Using bcp OUT of a view using the -C option on bcp will fail if the view uses an encrypted column in the where clause.

CR:395858

CR Number:   395858 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) 31 Aug 2005 Fixed 06 Sep 2005 Fixed Description In rare circumstances the message "ubo_object_from_slot:Pss Invalid slot id 0" together with a stack trace that includes the modules 'ubo_object_from_slot', 'pss_getunkept_pss', 'lock_vsema' and 'log__unlock' may be reported when many transactions are active within a database and at least one of these is a transaction that is externally coordinated by XA, MSDTC or a remote Adaptive Server (a transactional RPC). Workaround Description  None.

CR:395894

CR Number:   395894 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) 31 Aug 2005 Fixed Description A 2631 error, "The maximum number of index levels '255' has been reached for index <indname> of table <tablename> in database <dbname>" may sometimes be encountered while inserting data into a clustered index with a large index key. Workaround Description  Cut the group-by list from 14 to less 13 columns

CR:395902

CR Number:   395902 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) 16 Mar 2006 Fixed 16 Mar 2006 Fixed Description When using jconnect sp_mda locks sysconfigure table to get the ASE version , so when sp_sysmon is run it hangs till the lock is released. Fix is to get the ASE version from the global variable @@version_as_integer and save the current isolation level and set it back once the sp_mda is executed. This way we dont interfere with ASE locks and system tables.

CR:395937

CR Number:   395937 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   Generic Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2006 Fixed Description Installing sybsyntax fails due to Msg 18047 "There is not enough room in the default devices to create the sybsyntax database.". Workaround Description  Line 12 to 15 in ins_syn_sql seem to be incorrect: 12 - (select sum (isnull (size, 0)) from sysusages, sysdevices 13 where vstart >= sysdevices.low 14 and vstart <= sysdevices.high 15 and sysdevices.status &1 = 1) Workaround is to modify line 15 as follows: 12 - (select sum (isnull (size, 0)) from sysusages, sysdevices 13 where vstart >= sysdevices.low 14 and vstart <= sysdevices.high 15 and sysdevices.status &1 = 1 and sysdevices.vdevno = sysusages.vdevno) And you may need to add "dump tran sybsyntax with truncate_only" into somewhere in ins_syn_sql.

CR:396081

CR Number:   396081 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2006 Fixed 23 Jan 2006 Fixed Description Sybase Central ASEPlugin now supports BCP in/out for User Tables(/partitions), and views

CR:396098

CR Number:   396098 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin-Adaptive Server Enterprise Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2005 Fixed Description Need to document Monitor Server/Historical Server are not available in ASE 12.5.x for Sun x86.

CR:396136

CR Number:   396136 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) 13 Dec 2005 Fixed 02 Mar 2006 Fixed Description Under rare circumstances the execution of DBCC CHECKSTORAGE may hang if the given scan workspace is very large. Workaround Description  You may be able to avoid this problem. Add 50MB or 100MB to scan workspace. OR Subtract 50MB or 100MB from scan workspace. I reproduced this problem with scan workscape = 4200M. But if I changed scan workspace size from 4200M to 4250M, this problem went away.

CR:396144

CR Number:   396144 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) 22 Sep 2005 Fixed Description The message "current process infected with 11" in the module 'memcpy' together with a stack trace which includes the modules 'ss_chartoblob' and 'run' may be reported in the error log during an UPDATE of a TEXT column using a J-connect program or a CT-library program that uses host variables. In some cases a 510 error, "Bad eop type 0x.." may be reported instead. Workaround Description  Disable statement cache.

CR:396187

CR Number:   396187 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   Windows 2000 Original Version:   penelope EBF1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In an XML model perform File >Print Selection. The printed diagram only prints the 1st line of the text zone (name of element) for the selection of symbols. Word wrapping has been temporarily dismantled on the selection of symbols (elements)to print. However, when you perform File > Print the whole text zone for the element symbols are printed fine. note: if you use View > Redisplay or Zoom IN/OUT, the element symbol in the model diagram is refreshed and it's display in the diagram reverts back to the word wrapping setting.

CR:396198

CR Number:   396198 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer is having a problem upgrading with the installer on a 4 and 8 CPU Windows 2003 System. Customer would like Sybase to Certify that ASE Installer works correctly without errors on multiple CPU systems for both product install and upgrades.

CR:396229

CR Number:   396229 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) 14 Dec 2005 Fixed 14 Dec 2005 Fixed 14 Dec 2005 Fixed Description An application error in transaction nesting leads to a segmentation fault with message 3934 "Transaction manager has detected a nesting failure. Number of BEGIN TRAN commands (issued after an attach operation) do not match the number of COMMIT TRAN commands (issued before a detach operation)". A stack trace with module finish_xact() will be found in the errorlog.

CR:396266

CR Number:   396266 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) 12 Jul 2005 Fixed Description The message "infected with 11 in s_is_cachable" is printed in the errorlog together with a stacktrace containing the modules 's_normalize' and 'sequencer' when executing a query performing an INSERT into a temporary table based and on a SELECT with a UNION clause whereby the last SELECT contains a subquery.

CR:396296

CR Number:   396296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2005 Fixed 15 Jan 2006 Not a Bug Description Sub-optimal performances may be seen on queries with LIKE expression performed on a unichar or univarchar column.

CR:396479

CR Number:   396479 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) 28 Sep 2005 Fixed Description When an UPDATE that uses the tsequal() builtin function is done within a stored procedure, tsequal() no longer returns a timestamp value unless the 4080 trace flag is being used. When an UPDATE that uses the tsequal() builtin function is done outside a stored procedure, tsequal() returns a timestamp value in the TDS_RETURNVALUE token.

CR:396509

CR Number:   396509 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2005 Fixed 23 Nov 2005 Fixed 11 Aug 2006 Fixed Description An INSERT-SELECT statement can corrupt the inserted rows in the target table when the target table is a Data Only Locked table and the SELECT contains a UNION ALL first, followed by one or more UNION statements grouped together using (). Workaround Description  rewrite query.

CR:396536

CR Number:   396536 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) 22 Dec 2005 Fixed 12 Oct 2005 Fixed Description sp_helpdevice reports the allocated database fragments on a database device

CR:396565

CR Number:   396565 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) 08 Jul 2005 Fixed Description DDLGen has a new type - 'LK' for generating DDL defintions of Logical Keys - keys generated by sp_primarykey, sp_commonkey, sp_foreignkey statements. The name to be supplied in '-N' parameter is the table name.

CR:396598

CR Number:   396598 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2005 Bundled Request Description The message "current process infected with signal 10 (SIGBUS)" in the module 'vbit_set' together with a stack trace which includes the modules 'rec_analyze_log' and 'rec_onlinetime' may be reported in the error log during ONLINE DATABASE on the HPUX 64 bits platform.

CR:396703

CR Number:   396703 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) 20 Mar 2006 Fixed 21 Dec 2006 Failed Description Feature request for an option to sp_configure that would display all the configurations that were set to a non-default value

CR:396708

CR Number:   396708 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 Aug 2005 Fixed Description A 15052 error, "Index error: Table id <id>, indid <id> calculated maxlen <value> does not match <value> in Sysindexes" may be reported by DBCC CHECKCATALOG on a table that has at least two bit columns, after ALTER TABLE was run to add/modify a variable length or NULL column. Workaround Description  - Use dbcc checkcatalog(<db_name>, fix) after alter table to fix this error. - OR ignore the 15052 error from checkcatalog for the moment, it is not a big problem, because maxlen is larger then it should be.

CR:396811

CR Number:   396811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2005 Bundled Request 07 Nov 2005 Bundled Request Description The message "current process infected with 11" in the module 'lddb__stat_translate' together with a stack trace which includes the modules 'lddb__unscr_stat_page' may be reported in the error log, when loading a database across platform, if the database has an orphan row in syssatistics. Workaround Description  Find and delete orphan rows from sysstatistics something like: 1> use <databasename> 2> go 1> delete from sysstatistics where id not in (select id from sysobjects) 2> go (x rows affected)

CR:396812

CR Number:   396812 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 May 2008 Duplicate Description dbcc checkcatalog() does not check or fix the consistency of the sysstatistics table. Workaround Description  None.

CR:397029

CR Number:   397029 Product Name:   ASE Replicator Product Component:   Log Extract Status:   Closed OS:   Generic Original Version:   12.5.3.304P1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1.410P1 13 Dec 2005 Fixed Description ASE REPLICATOR: occasionally, the order of replicated operations within a transaction at the replicate database does not match the order of operations at the primary database. Workaround Description  None

CR:397149

CR Number:   397149 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2005 Fixed 19 Jul 2005 Fixed Description ASE Plugin for Sybase Central: "Create Table DDL" inserts extra commas into table contraints if they are longer than 255 characters. Workaround Description  None known.

CR:397155

CR Number:   397155 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2005 Presently Not Targeted For Any Future Release Of This Product 18 Nov 2005 Fixed Description A login attempt into ASE may fail with a 1601 error after several recurring 709 errors have been raised because of procedure cache memory shortage. Workaround Description  Allow enough procedure cache in order to avoid error 709.

CR:397210

CR Number:   397210 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) 18 May 2010 Presently Not Targeted For Any Future Release Of This Product Description Avoid shutdown and restart of license deamon when it is not required

CR:397229

CR Number:   397229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2005 Third Party Problem 22 Nov 2005 Third Party Problem Description ASE running on Solaris 10 operating system encounters performance degradation when using asynchronous IO on file system devices. This is liable to manifest as severe performance degradation on single CPU machines and significant performance degradation on multi CPU machines under load. This is due to a bug in Solaris kernel, Sun BugID 6302167. Install the following patch from Sun Support for resolving this performance problem. Solaris 10 SPARC: PatchID 120048-03 Solaris 10 x86/x64: PatchID 120049-03 Workaround Description  1. Use raw device for ASE 2. On single CPU box, use RPSC=3 and start ASE with traceflag 1636 3. On multi CPU box, configure number of ASE engines to be less than number of CPUs

CR:397260

CR Number:   397260 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) 24 Aug 2005 Fixed Description The config numbers for 'max online Q engines' and 'number of Q engines at startup' are not correct. They should be 447 and 448 instead of 443 and 444.

CR:397291

CR Number:   397291 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 10 Jul 2008 Fixed Description Global variables may return invalid negative values.

CR:397320

CR Number:   397320 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) 13 Sep 2005 Fixed Description HAFAILOVER occurs on clients when killing a spid on ASE. The condition occurs when the spid is involved in a non-resultset transaction, such as insert into command. When the kill is issued, ASE is internally rolling back the transaction, and the HA Session id is still valid at this point. This enables the client to re-connect. Client should receive some sort of disconnect message instead, like jConnect JZ006 IOException, or isql operation terminated due to disconnect.

CR:397342

CR Number:   397342 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2006 Fixed 11 Jan 2006 Bundled Request Description Flush all data to the Sybmon log file whenver the 'log off' command is executed.

CR:397359

CR Number:   397359 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) 29 Jul 2005 Fixed Description The error 632 "Attempt to move memory with an incorrect length of <len>. Maximum allowed length is <maxlen>." will now be raised during garbage collection of index leaf pages if the length of memory being moved goes beyond a page boundary, instead of silently trashing the data cache.

CR:397535

CR Number:   397535 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) 02 Sep 2005 Fixed Description When exec_procedure auditing is enabled for system stored procedures sp_encryption and sp_ssladmin, the password parameters are visible in the audit trail.

CR:397539

CR Number:   397539 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed 04 Jan 2006 Fixed Description The recovery task may appear to hang forever executing the functions 'at_do_reserve', 'pg_oam_pagecounts' and 'pg_recalcoam' after loading a database dump which was taken on a very active ASE environment.

CR:397636

CR Number:   397636 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) 19 Jul 2005 Fixed Description Job and Schedule names with spaces and other nonalphanumeric characters were being rejected by the ASE Plugin GUI.

CR:397658

CR Number:   397658 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2005 Fixed Description If an LDAP server does not allow anonymous binds then one cannot set the "primary_url" and "dn_lookup_url" even if the "access_account" has been successfuly set. Workaround Description  Bring up the ldap server allowing bind_anon, and set the urls. Then recycle the ldap server after setting "disallow bind_anon".

CR:397665

CR Number:   397665 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 Dec 2005 Fixed Description ASE incorrectly allows identifiers that start with a pound sign (#) to be used as column names. All column-names defined in a CREATE TABLE, CREATE VIEW statement and in the column-list of a derived table expression are now checked against the rules for valid identifiers as stated in the standard documentation.

CR:397672

CR Number:   397672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2006 Fixed 15 Oct 2007 Fixed 07 Mar 2007 Fixed Description If complete deadlock information which gives deadlock chains and details is not needed, customer can set 'print deadlock information' to value 2. This will print only 1 line summary of Deadlock giving only Deadlock ID.

CR:397679

CR Number:   397679 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) 23 Sep 2009 Presently Not Targeted For Any Future Release Of This Product Description Feature request to enhance the 4002 error message ("Login failed") to include the specified user name ("Login failed for user 'joeuser'"). Workaround Description  sp_configure "log audit logon failure" prints username and ip address to the errorlog.

CR:397693

CR Number:   397693 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2006 Fixed 19 Dec 2006 Fixed Description New Feature - Sybase Central ASE Plug-in supports restoration of tables and partitions from 15.0.2

CR:397700

CR Number:   397700 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed 11 Feb 2006 Presently Not Targeted For Any Future Release Of This Product 17 Aug 2005 Fixed 17 Aug 2005 Fixed 12 Jan 2006 Fixed Description ASE Job Scheduler fails to execute jobs scheduled to repeat with an interval greater than approximately 25 minutes. Workaround Description  Schedule a dummy job to run every 25 minutes or more frequently.

CR:397873

CR Number:   397873 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2005 Fixed 07 Sep 2005 Fixed Description Enable Java support on Solaris x64 (opteron) platform.

CR:397910

CR Number:   397910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2005 Deferred 26 Aug 2005 Fixed 06 Jan 2006 Fixed Description Suppress raising error 2513 from DBCC CHECKCATALOG if rows are found missing in syscomments for definition-time partition condition objects that were left behind due to some errors that occured during creation of tables with partition conditions.

CR:397943

CR Number:   397943 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 Enhance error messages 3409, 3410 and 3411 to include the transaction id. Target Version  12.5.3

CR:397966

CR Number:   397966 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2005 Fixed Description Not customer visible

CR:397984

CR Number:   397984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2006 Fixed 03 May 2006 Fixed Description The SQL data type UNSIGNED BIGINT is currently mapped to the Java type "double". This conversion will incorrectly give an approximate value when the UNSIGNED BIGINT value is large enough.

CR:398110

CR Number:   398110 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2005 Fixed 28 Jul 2005 Fixed Description Transactional queries involving remote tables may hang on Windows platform configured with SSL when trace flag 3431 is used.

CR:398200

CR Number:   398200 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) 14 Nov 2005 Fixed 18 Nov 2005 Fixed Description When the sampling option is used for UPDATE STATISTICS, existing multi-attribute density values may not be reused. With this fix, range density and total density will be calculated from the sampled dataset, unless existing values were from a full scan of data.

CR:398212

CR Number:   398212 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) 08 Aug 2005 Fixed Description If Adaptive Server is unable to find an encryption key when it is processing an encrypted column, an unhelpful error message (15424) is raised. This scenario can occur if, for example, the database containing the key has been taken offline.

CR:398295

CR Number:   398295 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a way to display the name of the source ASE for a dump file, perhaps by including the name in the dump header and displaying it using listonly or headeronly.

CR:398320

CR Number:   398320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2007 Fixed 28 Jun 2007 Fixed Description The error 10302, "Only the DBO of database 'dbccdb' or a user with System Administrator (SA) role can run this command." will be incorrectly raised when a user without SA role different from the DBO executes DBCC CHECKVERIFY even if this access has been granted in the target database.

CR:398435

CR Number:   398435 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2009 Fixed Description DBISQL returned error from queries with compute clause.

CR:398443

CR Number:   398443 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) 07 Feb 2007 Fixed 29 May 2007 Fixed 09 Feb 2007 Fixed Description In rare circumstances , an error message "Internal error, FDP API, fdp_get_memory() :Failed to allocate xxxxx bytes" may be logged in the ASE errorlog when sp_configure is executed.

CR:398491

CR Number:   398491 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 Jun 2010 Fixed Description ASE now can save 999999999 copies of configuration files instead of the previous 999. And the format of the backup config file will be xxx.000000001 instead of xxx.001.

CR:398586

CR Number:   398586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2008 Fixed 19 Feb 2008 Fixed Description ASE server or client will not start when IP 0.0.0.0 is present as master/query in interfaces file. ASE Server fails to start with error "ninit: cannot find host 0.0.0.0". Workaround Description  add ip address to /etc/hosts (fake entry)

CR:398666

CR Number:   398666 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) 22 Jul 2005 Fixed Description The preupgrade utility does not check for and enforce correct spelling in its printed messages.

CR:398675

CR Number:   398675 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2005 Fixed 27 Jul 2005 Fixed Description The error 874 "Process <spid> is trying to unkeep buffer <buf_addr> (dbid: <dbid>, pageno: <pageno>) without releasing the <type> latch it holds on the buffer." may be raised when an interrupt is received by a query on a Data-Only-Locked table using the isolation level 3 (serializable) and performing a backward scan.

CR:398768

CR Number:   398768 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2005 Fixed Description A 8206 error, "Object <negative number> was not found in WorkTabList" may be reported in the error log for a query referencing multiple times the same view and performing aggregates on view columns. This problem will happen only if the query is executed in the parallel mode.

CR:398792

CR Number:   398792 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2010 Fixed Description Installing 12.5.3, ESD#2 after moving $SYBASE will report a null and block the install process. Workaround Description  The work-around used was to update the vpd.properties and change the path to match new location of $SYBASE.

CR:398819

CR Number:   398819 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) 15 Aug 2005 Fixed Description ASE reports "master device corrupt" even for the situation of missing master device when booting a server without providing the master device.

CR:398897

CR Number:   398897 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2005 Fixed Description The output from sp_sysmon system stored procedure may report incorrect values for the "Free" counters in the section "Metadata Cache Management".

CR:398968

CR Number:   398968 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed 21 Oct 2005 Fixed Description User can specify RMI port other than 9999 for Unified Agent connection.

CR:399023

CR Number:   399023 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2006 Fixed 20 Jul 2006 Fixed Description Feature request: improve time to open Stored Procedures Folder within Sybase Central ASE plugin