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

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

CR:567820

CR Number:   567820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) Description (Internal only) Test environment issue.

CR:567885

CR Number:   567885 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2009 Fixed Description Fully qualified ASE table names in a query cause an exception when using DBISQL's Query Editor.

CR:567909

CR Number:   567909 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FR Dbcc command to delete object from system tables.

CR:567910

CR Number:   567910 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2009 Fixed Description Due to the addition of two new columns in monDeadLock in 15.0.2 the length of a particular sql statement has increased to be in excess of the previous limit of 1024 chars in sp_monitor_deadlock. (The columns are replaced with dummies in 12.5.4) Workaround Description  Re-create the sp_monitor_deadlock procedure with an increased data type length for the @sqlstmt variable declaration. create procedure sp_monitor_deadlock( @arg1 varchar(30) = NULL , @arg2 varchar(30) = NULL , @arg3 varchar(30) = NULL ) as begin -- declare @sqlstmt varchar(1024) declare @sqlstmt varchar(1500) ... ...

CR:567911

CR Number:   567911 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2009 Duplicate 24 Feb 2010 Fixed Description Feature request to support using sybmigrate from ASE 12.5.x using non-utf8 charset to ASE using utf8 charset. Workaround Description  Possibly using BCP to transfer data after setup. Change source database to utf8 before sybmigrate or target ASE to utf8 after sybmigrate.

CR:567916

CR Number:   567916 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 3710 can be missleading Cannot use DROP with 'test_c1_427145536' because 'test_c1_427145536' is a constraint. Use ALTER TABLE. But the command you do is drop default test_c1_427145536 and the message is because you try to drop a created by declaration default. Workaround Description  // Drop this defaults from the systemtables.

CR:567924

CR Number:   567924 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Workaround Description Queries containing joins of several complex views may fail with Signal 11 or Access Violation and stack trace in vu_pd_validresdom(). Workaround Description  Cst found work-around of re-writing query such that it does NOT need more than 14 work-tables. Break the query into select into #temp_table and join with that. Eg: SELECT * INTO #GL_Mapping FROM VW_TW_GL_Mapping WHERE VW_TW_GL_Mapping.GL_Name is not null SELECT 1 FROM VW_TW_Instrument , VW_TW_GL_Balance , #GL_Mapping WHERE VW_TW_GL_Balance.INSTRUMENTIDNUM=VW_TW_Instrument.INSTRUMENTIDNUM AND VW_TW_GL_Balance.GLACCTNBR = #GL_Mapping.GLACCTNBR AND #GL_Mapping.SUBINSTRTYPEID=VW_TW_GL_Balance.SUBINSTRTYPEID

CR:567959

CR Number:   567959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2009 Fixed Description ASE Cluster Edition with two or more instances may crash an instance with the message "current process infected with Signal 11" reported in errorlog containing 'cmcc__pri_bcmt_proc' in the stacktrace. .

CR:567961

CR Number:   567961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description when customer upgraded from ASE 12.5.4 to ASE 15.x using dump and load ... since all the binding information is stored in the sysattributes table in masster database related to Multiple temporary databases ... those bindings are missing for all their logins in the upgraded server. So now this customer has to recreate all the bindings done with sp_tempdb in the past again now from scratch. The customer wants the feature of using dump and load to upgrade their database versions and have all the binding information related to Multiple temporary databases for all the logins to be present in the upgraded server. maybe the feature would be 1) to relocate the binding info to some table other then sysattributes 2) create a stored procedure or instructions to migrate the Multiple temporary database binding info from the older server to the newer server.

CR:567968

CR Number:   567968 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Fixed 14 Jan 2010 Fixed 10 Feb 2010 One-off Provided Description Online database hits error 3905 while undoing a split log record on an APL table with clustered index.

CR:568036

CR Number:   568036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2009 Fixed 23 Apr 2009 Reservation Made 23 Apr 2009 Fixed Description In rare circumstances , in multi-instance cluster environment when upgrade of a database is done on one of the instances, error 968(upgrade in progress) may be reported in the errorlog while using database on another instance in the cluster.

CR:568088

CR Number:   568088 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 8242 severity 16 state 2: "The table '%S_OBJID' in database '%S_DBID' is bound to metadata cache memory. Unbind the table and retry the query later. To resolve this error, ensure that all users are out of the database, or reboot ASE and run: dbcc tune(des_unbind)

CR:568246

CR Number:   568246 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Customer request that order-by be allowed in a "for update" cursor.

CR:568255

CR Number:   568255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2010 Added to user documentation Description Changing Lock Scheme to DOL May Impact Query Plan customer changed locking scheme from APL to DOL and now the optimizer fails to choose the most ideal query plan. the customer had to execute ... 'update index statistics' ... before the optimizer would succeed again in selecting the most ideal query plan. WARNING! Changing the locking scheme on a table can cause the optimizer to alter its costing estimates for accesses to the table. The impact of changing the locking scheme should always be tested in a non-production environment before deployment to production. Given that the clustered index on an APL table is a very direct mechanism to access the data AND that there are Search Arguments on all three columns of the clustered index, ASE most likely bases its decided upon join order around a clustered index scan of matter_participant. Given that clustered indexes on DOL tables are not as strong as they are on APL tables ASE ends up selecting a non-optimal index. Update Index Stats ... 'update index statistics' ... after this is executed ... ASE will then have histograms on additional columns and then ASE is better equiped to select the correct join order and query plan. Conclusion: the conclusion here is that changing locking schemes is not directly tied to the need to run 'update index statistics', rather, the additional histograms created by 'update index statistics' will, in some circumstances, be required in order for the ASE 12.5.x optimizer to select the most ideal query plan.

CR:568259

CR Number:   568259 Product Name:   Adaptive Server Enterprise Product Component:   Pluggable_JVM Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2009 Fixed 22 Apr 2009 Fixed 21 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date 12 May 2009 Fixed Description Due to a defect under AIX 5.3 ML7, PROCESS_SHARED locks and conditions pose server hangs when multiple ASE engines are in effect. This problem is filed at IBM under PMR 51261,756,000. A workaround for those server hangs PCI Bridge Virtual access approaches are disabled under IBM AIX 5.3 ML7, making it the default server behavior. This despite an understood performance loss. IBM AIX servers can be booted with traceflag -T9403 allowing them for full PCI Bridge access mode. Doing this, such poses strong risk to server hangs, but won't cause performance loss on operations.

CR:568357

CR Number:   568357 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2009 Fixed 23 Apr 2009 Fixed Description User selects "specified license key" option, but the specified license does not take effect and installer license validation can not pass.

CR:568425

CR Number:   568425 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2009 Fixed Description Support sp_configure 'nondefault' in SDC.

CR:568427

CR Number:   568427 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2009 Fixed Description In sp_configure, for cluster-wide settings, display 'cluster-wide' instead of 'NULL' in instancename.

CR:568430

CR Number:   568430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2009 Fixed Description In rare circumstances, in a ASE CE server, timeslice error could be reported in the errorlog. The stack trace could contain strings like "hk_chores_proc", and "bufwritedes_log_all".

CR:568449

CR Number:   568449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2009 Fixed 16 Apr 2009 Fixed 16 Apr 2009 Fixed 17 Aug 2009 Not a Bug Description On IBM AIX platform, ASE will not give complete stack trace when any ASE task hits timeslice error.

CR:568458

CR Number:   568458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2009 Fixed 19 May 2009 Fixed 28 May 2009 Fixed 22 May 2009 Fixed 09 Jun 2009 Fixed 21 May 2009 Fixed 29 May 2009 Fixed Description ASE generates an infected with 11 stacktrace in the errorlog containing the function rvm_has_decrypt_perm when a cursor accesses an encrypted column on which a decrypt_default has been declared.

CR:568554

CR Number:   568554 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2010 Fixed Description In some circumstances, when attempting to login to the server and the server runs out of locks, a 1204 error may be raised and a signal 11 may be reported in the errorlog followed by a stacktrace involving the module 'lock_logical'.

CR:568615

CR Number:   568615 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2009 Fixed 15 Jan 2014 Presently Not Targeted For Any Future Release Of This Product 21 Jul 2009 Fixed Description Too many primary BCM requeues causing 100% CPU usage.

CR:568659

CR Number:   568659 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2009 Fixed Description Under rare conditions a query on the monOpenObjectActivity MDA table may result in a timeslice error.

CR:568753

CR Number:   568753 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2009 Fixed 07 Jul 2009 Duplicate Description Adaptive Server might boot with some cases of wrong cache configuration in config file resulting in cache creation with incorrect configuration.

CR:568763

CR Number:   568763 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 107 is raised when a 102 syntax error would be more appropriate for unmatched parenthesis in the select clause. Example: select substring(sysobjects.name,1,2)) from sysobjects Workaround Description  don't write syntax error.

CR:568798

CR Number:   568798 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2009 Fixed 16 Jun 2009 Fixed 24 Jun 2009 Fixed Description Under some circumstances, a signal 4 may be raised while calling ex_raise and ex_print.

CR:568811

CR Number:   568811 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2009 Fixed 02 Oct 2009 Fixed 11 Mar 2010 One-off Provided Description In an ASE cluster, when Rep Agent is running on one node on a given database, and clients modify data in that database from the same node or from remote nodes, Rep Agent may replicate some data with a delay. Workaround Description  None.

CR:568939

CR Number:   568939 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2009 Fixed Description After loading database dump of version 1501 into pyxis server, the datatype of 4 columns of system table "systabstats" have the wrong data types. ColName expected dtype actual dtype pioclmdata real int pioclmindex real int piocsmdata real int piocsmindex real int

CR:568957

CR Number:   568957 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2009 Fixed 02 Oct 2009 Fixed 02 Sep 2009 Reservation Made Description "ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received" may result when accessing data containing null bytes on an ASE server when character set conversion using Unilib is employed. Workaround Description  sp_configure 'enable unicode conversion', 0 --this will force built-in conversion, which is not available, so no conversion will take --place.

CR:568980

CR Number:   568980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2009 Duplicate Description instmstr is terminated by ASE when it causes an exception in modules such as destroyRemoteAccess and VTABRemoteAccess::`scalar deleting destructor' Workaround Description  They worked around the issue by enabling and altering the 'Monitoring' section of their configuration file: [Monitoring] enable monitoring = 1 sql text pipe active = 1 sql text pipe max messages = 1000 plan text pipe active = 1 plan text pipe max messages = 1000 statement pipe active = 1 statement pipe max messages = 25000 errorlog pipe active = 1 errorlog pipe max messages = 1000 deadlock pipe active = 1 deadlock pipe max messages = 100 wait event timing = 1 process wait events = 1 object lockwait timing = 1 SQL batch capture = 1 statement statistics active = 1 per object statistics active = 1 max SQL text monitored = 2048

CR:568983

CR Number:   568983 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2009 Not a Bug Description update of a view on a proxy table with text/image data fails with error 7732 Workaround Description  According to CR 371323 the index may be required: ===================================================================================== CIS: When a proxy table is updated via ct_dynamic in a client application, error 7732 may occur indicating that the cursor is READONLY. With this change, remote tables may need to be created with a unique index for table scans on updatable cursor. ===================================================================================== So we tried the following and it worked but customer is unable to use it due to their business requirements: create unique clustered index i1 on text_test (id) go

CR:568997

CR Number:   568997 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   Windows XP Original Version:   tyresias Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In an XML model, adding a new item to a sequence via right-click\new will reformat the displayed hierarchy of the sequence. Thus losing all the diagram formatting. Workaround: Select the desired object in the tool palette and add it to sequence. The object is added at the end of the hierarchy

CR:569001

CR Number:   569001 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: a supported way to rename a local index partition such that its name matches to the name of the underlying data partition.

CR:569005

CR Number:   569005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jan 2010 Fixed 12 Jun 2010 Fixed Description Upgrade may fail with a 2601 error on sysusers while trying to add system role 'dtm_tm_role'. A workaround is to remove DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE from sysusers and sysroles in the database on the original ASE version and retry the upgrade. Workaround Description  Remove the entries for DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE from sysusers & sysroles on the user database. This is best done prior on the original source before taking a new database dump. if this is not possible (e.g.: production environment) : - either dump/load the DB in another ASE server of the same version and remove the roles manually - On the target ASE 15 server : use traceflag 990 in order to gain access to the database as 'sa' (bypassing recovery and upgrade) and remove the roles. You can then issue an online database, and it should perform the upgrade successfully. ------------------------------------------------------------------------------ (Update 8/31/2010 ningzhen): A sample sql scripts to delete the system roles in the target 15 ASE after upgrade database db1 fails with 2601 error: ------------ dbcc traceon(990) go sp_configure 'allow updates to system table',1 go use db1 go begin tran go delete from sysroles where exists (select * from sysusers where uid=sysroles.lrid and name in ('dtm_tm_role', 'ha_role', 'mon_role', 'messaging_role', 'js_admin_role')) go delete from sysusers where name in ('dtm_tm_role', 'ha_role', 'mon_role', 'messaging_role','js_admin_role') go commit tran go sp_configure 'allow updates to system table',0 go dbcc traceoff(990) go online database db1 go

CR:569011

CR Number:   569011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE 12.5.4 RA sends different LTL between bcp and isql for nullable text column and replicate_if_changed. ASE 15.x sends same LTL. Want to know when this was changed and what is the long-term direction.

CR:569169

CR Number:   569169 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2009 DEFER 28 Jul 2009 Fixed Description In ASE Cluster Edition, a process inserting a row in a DOL table could get blocked indefinitely on a RANGE lock which is held by itself.

CR:569171

CR Number:   569171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2009 Fixed Description A stack trace in the function, setGlobalIdentity, may be generated when an INSERT query is run and this query inserts into a proxy table that is created on a remote view and the remote view is created on a table that contains an identity column and the datatype of the identity column is not NUMERIC (i.e. it could be integer or smallint) and the remote view has an instead-of trigger for insert and the instead-of trigger contains a query that selects the identity column from the inserted pseudo table.

CR:569332

CR Number:   569332 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) 30 Jun 2009 Fixed 29 Jun 2009 Reservation Made 13 Jul 2009 Fixed 14 Jul 2009 One-off Provided Description Servers with many database entries in sysdatabases may fail to upgrade to 15.x with errors 3461 and 3452 regarding failure of upgrade steps 21 and 1501. Workaround Description  The problem seems to be with the size of sysdatabases. The problem has been worked around in several cases by: 1) dumping master (not necessary to the workaround, but you want to know you have a good dump) 2) create a table in master with the same format as sysdatabases and insert into it all the rows from sysdatabases 3) delete all the rows for user databases from sysdatabases. 4) go through upgrade, it should succeed. 5) insert the user database rows back into sysdatabases from the holding table. Note that there is an additional column now (audflags2) which takes a NULL value. 6) Shutdown ase and reboot. The user databases will go through upgrade as part of recovery.

CR:569403

CR Number:   569403 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Added to user documentation Description Doc CR : You may be able to use packet sizes that are larger than the default size even if additional network memory is still 0. This is why ASE reserves space for the new security features in the network buffer memory. You still need to increase additional network memory to extend the network buffer memory if you increase max network packet size.

CR:569441

CR Number:   569441 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2010 Presently Not Targeted For Any Future Release Of This Product 24 Sep 2010 Fixed 28 Feb 2012 Fixed Description sqlupgrade fails to work if old version server to be upgraded is registered to LDAP server, it always tries to copy the interfaces file entry to the new directory and quits as failing to do so.

CR:569515

CR Number:   569515 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2009 Fixed 13 May 2009 Fixed 19 Jun 2009 Fixed 02 Jul 2009 Presently Not Targeted For Any Future Release Of This Product Description Running a very large batch with many many IF statements when 'statement cache' is enabled causes error: Msg 632: Attempt to move memory with an incorrect length of 25600. Maximum allowed length is 16384. Workaround Description  Run small batches (as this will make use of statement caching). Turn off statement caching.

CR:569518

CR Number:   569518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2009 Fixed 11 May 2009 Fixed 05 Jul 2009 Presently Not Targeted For Any Future Release Of This Product Description When an OpenSwitch is used between two ASE servers, executing an UPDATE statement on a VIEW attached with an INSTEAD OF UPDATE TRIGGER on a text or image column may result in Msg 156 "Incorrect syntax near the keyword 'WHERE'" error and/or a stacktrace in 'omni_tname'.

CR:569523

CR Number:   569523 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2009 Fixed 30 Apr 2009 Fixed Description If the interfaces file does not exist or contains no server entries, opening 'Job Scheduler Server' page of Server Properties results an NullPointerException.

CR:569527

CR Number:   569527 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin for HP Status:   Closed OS:   HP-UX Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2012 Presently Not Targeted For Any Future Release Of This Product Description doc request: release bulletin should include warnings on HP license server vers.

CR:569531

CR Number:   569531 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2009 Fixed Description Server Properties dialog's Configuration tab's configuration group selection does not remain after Apply.

CR:569541

CR Number:   569541 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2009 Fixed 21 Dec 2009 Presently Not Targeted For Any Future Release Of This Product Description After changing the name of a table with sp_rename, triggers defined on the table may no longer work.

CR:569567

CR Number:   569567 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2009 Fixed 29 Apr 2009 Reservation Made Description Allow UPDATE STATISTICS to be performed in a multi-statement transaction. Update statistics changes will become part of the transaction, and and all the work done by update statistics will be removed by any rollback. If a multi-statement transaction does not exist, then update statistics will continue to use internal transactions to commit multiple minimal atomic parts of the update statistics command which will remain even if the command is aborted. Trace flag 2720 can be used to continue with the pre-fix behaviour, in which case an attempt to run this command in a multi-statement transaction is disallowed with an error message.

CR:569660

CR Number:   569660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed Description When dbcc checkalloc against archive database read the page from the disk into the reserved buffer, the server don't update actual page number read so that this check failed with table corrupt.

CR:569713

CR Number:   569713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2009 Fixed Description The realdb and the archive db can't get the same count of page format errors, so that dbcc checkverify get different result from them.

CR:569724

CR Number:   569724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2009 Fixed Description Update ASE startup reporting changed to recognise Windows Vista and Windows Server 2008, avoiding the message "ASE booted on unrecognised or unsupported operating system".

CR:569742

CR Number:   569742 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2009 Fixed Description Logins folder's Full Name column was mistakenly removed.

CR:569790

CR Number:   569790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature request where the index partition names can specified in the alter table command when add partition results in local indexes on the new partition(s) if a local index is present on the existing partition(s).

CR:569804

CR Number:   569804 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2009 Fixed 12 Aug 2009 Fixed Description Logging SQL when an instance is shut down gets a NullPointerException.

CR:569808

CR Number:   569808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2012 Fixed 17 Jul 2012 Fixed Description In rare circumstances, the message "current process infected with 11" in the module 'adb__reserve_pg' together with a stack trace which includes the module 'adb_dirty' may be reported in the error log after the load of an archive database.

CR:569815

CR Number:   569815 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   HP-UNIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2009 Fixed Description HP-UX 11.23 will not be supported any more.

CR:569832

CR Number:   569832 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2009 Fixed 14 May 2009 Duplicate Description The default behavior of DBCC PAGE without specifying "CACHE" and "CACHENAME" option is to first check if the buffer of the specified page is in the cache of the local node. If it doesn't exists, the page will be read from disk. With the Cluster Edition, DBCC PAGE will first check if the buffer of the specified page is in the cache of the local node. If it doesn't exists, it will check the caches of all nodes before reading the page from disk.

CR:569855

CR Number:   569855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed 25 Feb 2010 One-off Provided Description Adaptive Server Shared Disk Cluster may fail over unnecessarily even if config parameter "cluster heartbeat retries" is increased.

CR:569904

CR Number:   569904 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2009 Fixed 21 Jul 2009 Fixed 21 Jul 2009 Fixed Description In rare circumstances, Job Scheduler might fail to run with the error "Incorrect syntax near '`'".

CR:569927

CR Number:   569927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2009 One-off Provided 01 May 2009 Fixed 01 Sep 2009 One-off Provided Description When compatibility mode is enabled, executing a cursor declare query with UNION may hit stack trace in the module of metrics_write() together with curs_open() on hpia64 platform.

CR:569936

CR Number:   569936 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Troubleshooting guide should be expanded to offer general help on errors not covered explicitly within the guide.

CR:569940

CR Number:   569940 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2009 Fixed 23 Jun 2009 Fixed 22 Jun 2009 Fixed Description Truncate table is not consistent when switching tables under 'suspend audit when device full=0'

CR:569947

CR Number:   569947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed 02 Jun 2009 Reservation Made Description SELECT INTO using ISNULL builtin in the SELECT list could lead to target table column non-nullable while the early behavior of ASE would make the target table column nullable even when the ISNULL result can't be null for the query. Workaround Description  use traceflag 15336 to disable the change made by 497066 to get back to the old ISNULL bebavior.

CR:569969

CR Number:   569969 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2009 Fixed 18 Dec 2009 Fixed 01 Sep 2009 Fixed 01 Sep 2009 Fixed 18 Dec 2009 Fixed Description Update DBISQL from version 11.0.0 to 11.0.1.

CR:570087

CR Number:   570087 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed Description In rare circumstances , error 8243 may be reported into the errorlog when one of the instance in the multinode cluster crashes.

CR:570117

CR Number:   570117 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2009 Fixed Description Deleting a table with LOB columns (text, image, unitext) and non-datarows locking scheme under direct mode may hit SIGSEGV together with stack trace in the module of LeDeleteOp::_LeOpNext() if the query plan has merge joins. Workaround Description  Turn off merge joins or use 'datarows' locking scheme

CR:570136

CR Number:   570136 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2009 Fixed 04 Dec 2009 One-off Provided Description Restore the old behavior in ASE125 to use parallel sort while creating index on more than one output devices.

CR:570149

CR Number:   570149 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for some way to cause ASE to abort startup if specified errors occur during startup.

CR:570154

CR Number:   570154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2009 Fixed Description In rare circumstances on an ASE CE server, a 820 error, "Attempt to dirty non-log buffer <buffer-address> which is in I/O" may be reported during an instance failover.

CR:570288

CR Number:   570288 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve scalability of housekeeper statistic flushing on very large systems.

CR:570307

CR Number:   570307 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2009 Fixed Description Deferred compilation may cause unexpected parse errors when setting quoted_identifier on\off within a procedure defintion. (Error 102, 257 etc) Workaround Description  1. use '[' and ']' as a quote delimiter. example: create table #t1([c1 c] int) update #t1 set [c1 c] = s.id from sysobjects s 2.set switch on 7730 with override --disable DC for the session

CR:570329

CR Number:   570329 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2009 Presently Not Targeted For Any Future Release Of This Product aries 12 Jun 2009 Fixed Description The failover of a Shared Disk Cluster may stall due to the cluster view inconsistency on different instances.

CR:570335

CR Number:   570335 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   Solaris Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2011 Duplicate Description Investigate - When enabling a licensed feature via sp_configure a timeslice in klicense_checkout() may occur if insufficient licenses are available from the license server.

CR:570337

CR Number:   570337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a LIST aggregate function similar to the one in SQL Anywhere.

CR:570345

CR Number:   570345 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed Description Sybmon planprint could cause stacktrace.

CR:570346

CR Number:   570346 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2009 Fixed Description In some circumstances an inbound migrating task may be redirected by the workload manager, resulting in protocol error in the client.

CR:570398

CR Number:   570398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date Description Signal 11 in ubffree().

CR:570421

CR Number:   570421 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2009 Fixed 14 May 2009 Fixed 16 Jun 2009 Fixed Description If sp_dbrecovery_order specifies a recovery order with "strict" option, the databases many not be brought online in the specified order.

CR:570429

CR Number:   570429 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature requests that we document error "kernel nopen: accept" in the troubleshooting guide making particular emphasis on the fact that this is due to an operating system problem, not an ASE issue.

CR:570442

CR Number:   570442 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed 05 May 2009 Fixed Description Executing groupby queries with groupby columns reference java ADT might get wrong result if query plan chosen LeGroupInsOp (group inserting).

CR:570457

CR Number:   570457 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2009 Fixed 13 Oct 2009 Fixed Description Stacktrace could happen during GroupInsert operator execution under compatibility mode for GroupBy query with a lot of aggregates. Workaround Description  use traceflag 446 to disable restrcited compatibility mode. Or use traceflag 454 to disable groupinserting operator under restricted compatibility mode.

CR:570478

CR Number:   570478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2009 Fixed 01 May 2009 Fixed Description When compatibility mode is enabled, executing a query with GROUP BY clause may get error 414 saying the key size of a worktable exceeds the maximum allowable limit.

CR:570485

CR Number:   570485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2009 Duplicate Description NAMEPIPE generate nl__read_defer: read failed on socket 13.

CR:570519

CR Number:   570519 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) 14 May 2009 Duplicate Description Feature request to enhance pssinfo() with an option to return the current port number used by a client.

CR:570528

CR Number:   570528 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2009 Fixed Description First item in a folder was skipped in sorting.

CR:570642

CR Number:   570642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Oct 2010 Fixed Description ASE was awarded a license on run-time grace rather than obtaining a license from the secondary license server after the primary was killed.

CR:570657

CR Number:   570657 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2009 Fixed 01 May 2009 Fixed Description ASE stack tracing mechanism may not work correctly on Windows 2008 and Vista

CR:570671

CR Number:   570671 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2009 Fixed 05 May 2009 Reservation Made 18 May 2009 One-off Provided 19 May 2009 Fixed 13 May 2009 Fixed 06 Jul 2009 Fixed Description In certain circumstances, distinct equi-join queries may return too few rows in non-binary sortorder servers (which are typically case-insensitive). This will only occur if reformatting is chosen for the join strategy. This could only occur if an equi-join predicate contains (var)char columns and the distinct select-list contains one or more columns that are not in any of the equi-join predicates. Workaround Description  set store_index off or:- Add -T328 to the run file if widespread(328 disables reformatting globally) These workarounds currently introduce the possibility of cr 570963, which is a 325 error (no legal plan found).

CR:570712

CR Number:   570712 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2010 Fixed Description CREATE DATABASE command should print a warning message to the user if the number of databases on the server exceeds the value of the 'number of open databases' configuration parameter.

CR:570744

CR Number:   570744 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jul 2009 One-off Provided 13 Jul 2009 One-off Provided 16 Jul 2009 Fixed 16 Jul 2009 Fixed 21 Jul 2009 Fixed Description On p-Series Linux: Segmentation violation and memory corruption result in ASE panic under stress conditions during decryption operations.

CR:570758

CR Number:   570758 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If an uncompressed dump to tape is followed by a dump made with the "with compression" option, the compressed dump cannot be loaded and backupserver raises a volume validation error: illegal volume change, device /dev/rmt/0n: stripe 0 is already loaded.

CR:570789

CR Number:   570789 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Generic Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2009 Fixed 04 May 2009 Fixed Description An arithmetic overflow exception may occur when the Data Caches screen in the ASE Monitor is opened.

CR:570794

CR Number:   570794 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2009 Fixed Description Execution of a stored procedure which creates a table with non-materialized computed column may sometimes result in a message "current process infected with 11" and the stack trace reported in the errlrog file if the procedure performs SELECT query on this table. This is likely to happen if a procedure query tree is renormalized. Stack trace may reference modules pre__replace_cpc and s_getTreeOrPlan. Workaround Description  Make the column materialized and explicitly list the computed column in the select list: create procedure pscott as begin create table #mono( old_id char(6), tid numeric(5) identity, id_seed int default 1, id_calc AS id_seed + tid materialized, ) insert into #mono(old_id) values('A00001') select old_id, tid, id_seed, id_calc from #mono end

CR:570804

CR Number:   570804 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2009 Fixed 18 May 2009 Fixed 11 May 2009 Fixed Description Typo "Temdb" in the ASE server attribute editor screen.

CR:570818

CR Number:   570818 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2009 Fixed Description sp_cacheconfig will display wash size as '****** Kb' if the number of digits in the wash size is greater than 6.

CR:570890

CR Number:   570890 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Msg 10330 is reported executing xp_*s procedures if installmaster is executed. Needed to give the permission to users to execute xp_*s procedures again. C:\WINDOWS\system32>isql -Ulogin_ing Password: 1> xp_cmdshell "dir" 2> go . . . 02/28/2003 09:38 PM 113 zonedon.reg 2032 File(s) 379,119,114 bytes 48 Dir(s) 28,418,981,888 bytes free (2087 rows affected) (return status = 0) C:\Sybase\ASE-15_0\scripts>isql -Usa -SASE15 -i instmstr -o saida Password: C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing Password: 1> xp_cmdshell "dir" 2> go Msg 10330, Level 14, State 1: Server 'ASE15', Procedure 'xp_cmdshell', Line 2: EXECUTE permission denied on object xp_cmdshell, database sybsystemprocs, owner dbo (return status = -4) To solve the situation : C:\Sybase\ASE-15_0\scripts>isql -Usa Password: 1> use sybsystemprocs 2> go 1> grant execute on xp_cmdshell to login_ing 2> go 1> exit C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing Password: 1> xp_cmdshell "dir" 2> go . . . 2032 File(s) 379,119,114 bytes 48 Dir(s) 28,418,904,064 bytes free (2087 rows affected) (return status = 0) 1> Target Version  To Be Determined Workaround Description  C:\Sybase\ASE-15_0\scripts>isql -Usa Password: 1> use sybsystemprocs 2> go 1> grant execute on xp_cmdshell to login_ing 2> go 1> exit C:\Sybase\ASE-15_0\scripts>isql -Ulogin_ing Password: 1> xp_cmdshell "dir" 2> go . . . 2032 File(s) 379,119,114 bytes 48 Dir(s) 28,418,904,064 bytes free (2087 rows affected) (return status = 0) 1>

CR:570901

CR Number:   570901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2009 Fixed 26 Aug 2009 Fixed Description ASE 15.0.3, esd#1 HKGC, Error 12316 occurs repeatedly

CR:570910

CR Number:   570910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Fixed Description The message "storage access violation" in various XML related modules together with a stack trace which includes XML related built-in modules may be reported in the error log after an error 712 raised from a previous XML query involving a large XML document. Workaround Description  Try increasing the "heap memory per user" to avoid the 712 errors.

CR:570925

CR Number:   570925 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2009 Fixed 20 Jun 2009 Fixed Description In an active database, Checkstorage may report a 100021 and 100015 as a hard fault when checking the last log page.

CR:570931

CR Number:   570931 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2009 Fixed 17 Aug 2009 Fixed 04 Jun 2009 Reservation Made 26 Aug 2009 Fixed 15 Oct 2009 One-off Provided Description On rare occasions a 605 error may be reported when BCP and UPDATE INDEX STATISTICS with sampling are concurrently executed on the same Data Only Locked table that has at least one non-clustered index present.