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

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

CR:380474

CR Number:   380474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2006 Fixed Description A database that once had replicated tables or stored procedures incorrectly continues to appear as such. This can have different effects, for example, that DBCC CHECKTABLE continues to unnecessarily check for replication information. Workaround Description  none. I'm not sure that having this bit reset makes a difference

CR:380498

CR Number:   380498 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed Description This release of ASE 12.5.3 ESD#3 has added a new platform support for the 64bit Linux for the AMD64 or Intel EM64T compatible processor.

CR:380800

CR Number:   380800 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2005 Fixed 17 Jan 2006 Fixed Description The message Msg. 702, "Memory request for <n> bytes exceeds the size of a single page of 16384 bytes", is raised together with a stacktrace in the errorlog including the modules 'memalloc', 'q_oreop_fill' and 'substitute' when a user executes a query with a very large IN-list in the WHERE-clause. Workaround Description  *** Tuesday, February 22, 2005 7:24:15 AM *** cooperg *** None.

CR:380801

CR Number:   380801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2005 Fixed Description The error 11068, "Transaction was found in the incorrect state of 'Command-attached'." will be raised if a parallel select into fails due to lack of memory. Workaround Description  Take action to avoid the error preceding error 11068: for error 701, increase the procedure cache (and/or decrease the number of sort buffers).

CR:380806

CR Number:   380806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2005 One-off Provided Description Internal Only: Description below was included in EBF 12498, not needed in 12.5.3 ESD#2. INSTRUMENTATION: ASE running on multiprocessor NT platforms with heavy use of ct_cancel by client application may miss acknowledging one or more cancel operations leading to a hang at the client end. Print diagnostics under traceflag 9999 to confirm the problem was encountered and corrective action take by ASE. NOTE: Fix for this problem is in ASE 12.5.3 ESD#2 under CR 377437

CR:380822

CR Number:   380822 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2005 Fixed 23 Feb 2005 Fixed 23 Feb 2005 Fixed Description SybMigrate not preserving identity values during migration. When migrating tables with identity columns the identity values were recomputed when created on the target server.

CR:380862

CR Number:   380862 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2007 Fixed Description Document that use of CIS features will cause a connection to affinity to a particular engine for the lifetime of the connection

CR:380995

CR Number:   380995 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2005 Fixed 01 Jul 2005 Fixed Description CIS: Segmentation fault occurred in routine omni_prune_subtree_cnvtnode() for select-into queries against DB2 backends. Workaround Description  Replace the selectinto query with two queries: 1. select * into #tab from tab_exist where 1=2 2. insert into #tab select * from tab_exist where a in (111,121)

CR:381009

CR Number:   381009 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2005 Fixed 11 May 2005 Fixed Description Invoking sp_sjobcontrol with the run_now option does not result in the job being immediately run. Instead, the job is run when another stored procedure request is handled or the next scheduled job comes due.

CR:381120

CR Number:   381120 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 Mar 2005 Fixed Description Query performing outer join and OR strategy may return incorrect results. This may happen if the Dynamic Index strategy is choosen by the optimizer to execute the query.

CR:381168

CR Number:   381168 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2005 Fixed Description Hide Password information when display Monitor Viewer

CR:381170

CR Number:   381170 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) 28 Jun 2005 Fixed Description A 551 error, "An unknown EVAL was sent to the execution module" or signal 11 in modules like 'qualpage' or 'do__groups' may be reported in the error log for a query with two GROUP BY clauses; in the main query and in a subquery, when it is executed in parallel. Workaround Description  Disable the paralleslim or don't execute the query specifying isolation level 0 (dirty read)

CR:381230

CR Number:   381230 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Unknown Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2005 Fixed Description CIS: Connections to remote servers are not disconnected and remain engine affinitied until the client session terminates. The connections can now be dropped and detached from an engine after executing a statement to the remote server by enabling Traceflag 11231. Exceptions are when the statement is participating in cursor, transaction or stored procedure operations; or when ASE is in either HA failover or failback states.

CR:381231

CR Number:   381231 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) 04 Mar 2005 Fixed 11 Oct 2005 Fixed 09 Mar 2005 Fixed Description The message "Type Code: 100019; Soft fault that has been upgraded to a hard fault OAM entry is present but there is no allocation." may be mistakenly reported by DBCC CHECKSTORAGE when it is run on a freshly loaded database dump and the given database dump was taken on a busy ASE environment initially.

CR:381301

CR Number:   381301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2007 Fixed 02 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description On AIX, sp_helpdevice reports a "device_number" one greater than the actual value for device numbers greater than 127 Workaround Description  select device_name = name, device_number = convert(tinyint, substring(convert(binary(4), low), 1, 1)) from master..sysdevices where cntrltype=0

CR:381308

CR Number:   381308 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2005 Fixed 01 Jul 2005 Fixed Description DBCC CHECKSTORAGE run for a database with no text/image data may fail raising the error message "You cannot use the text workspace '<TEXT_WORKSPACE_NAME>' for database '<DBNAME>'; required minimum size is <X> KB. The workspace is only <Y> KB"

CR:381340

CR Number:   381340 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2008 Workaround Description In some cases, a cross-database INSERT of java datatype value fails with a java.io.EOFException Workaround Description  bcp the data out and bcp it into the other database

CR:381343

CR Number:   381343 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) 09 Dec 2005 Fixed Description System stored procedure sp_who may incorrectly report login name for a session executing stored procedure if the stored procedure is being recompiled and the procedure executor does not own the procedure being executed.

CR:381404

CR Number:   381404 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Release Bulletin-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2005 Fixed Description The sample in Release Bulletin ASE 12.5.2 is different than set proc_output_params actually works.

CR:381456

CR Number:   381456 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2005 Fixed Description sybmgmtdb log fills when installing Job Scheduler.

CR:381503

CR Number:   381503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2009 Duplicate Description Feature request to provide automatic locking of login accounts that haven't been used for a configurable period.

CR:381526

CR Number:   381526 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2005 Fixed 25 Apr 2005 Fixed Description ASE may not be able to boot against a configuration file on HP and RS6000 platforms due to number of file descriptor issues, even if the configuration file contains low values for the number of user connections and the number of devices. ASE boot failure reports in errorlog "Verification failed for parameter 'number of user connections'". Workaround Description  *** Wednesday, March 23, 2005 20:47:20 *** taghi *** The workaround consists of configuring the machine to allow ASE to raise the hard limit on fds to MAXFD, as specified in the platform documentation, or at least for the current soft limit on the number of fds to be sufficiently high with respect to the number of fds required by the configured values of user connections and devices.

CR:381612

CR Number:   381612 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2006 Fixed 21 Nov 2006 Reservation Made 04 Oct 2007 Fixed Description Improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started. This enhancement is triggered by -T3710 either at boot time or via DBCC TRACEON(3710).

CR:381629

CR Number:   381629 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2005 Fixed Description Correct this error: Device number greater than MAX Java Integer value will display as zero.

CR:381706

CR Number:   381706 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) 05 Jun 2007 Fixed Description Feature request to enhance password encryption algorithm key to 128 bits or better

CR:381815

CR Number:   381815 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) 15 Mar 2005 Fixed 17 Mar 2005 Fixed 22 Mar 2005 Fixed Description Remove the limit of 1024 elements in the IN() clause.

CR:381820

CR Number:   381820 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) 08 Mar 2005 Fixed Description The message "current process (0x1c001c) infected with 11" together with a stacktrace involving module "compare_value" may be seen when a range query involves NULL date, time or bit values.

CR:381821

CR Number:   381821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2005 Fixed Description The command ONLINE DATABASE reported a syntax error if the database name was passed enclosed in singled quotes.

CR:381823

CR Number:   381823 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) 25 Apr 2005 Fixed Description DUMP DATABASE now has a WITH VERIFY [= HEADER | FULL ] option. This performs basic page header sanity checks (HEADER) and both page header checks and intra-page row checks (FULL) on every page that is dumped by the Backup Server.

CR:381856

CR Number:   381856 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to allow use of varaibles for object names in place of literal values in TSQL code, as in "select * from @mytablename"

CR:381870

CR Number:   381870 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 Mar 2005 Fixed 01 Jul 2005 Fixed 04 Jul 2005 Fixed 04 Jul 2005 Fixed 04 Jul 2005 Fixed 19 Oct 2005 Presently Not Targeted For Any Future Release Of This Product Description An 834, 821, 8201 and other errors may be reported when ONLINE DATABASE is performed on a fully onlined database. Workaround Description  Do not online a fully onlined database.

CR:381924

CR Number:   381924 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) 20 May 2005 Not a Bug Description Inccorrect values for sysindexes maxirow column are not corrected when executing dbcc checkcatalog(db,fix) Workaround Description  [May 20 2005, frankl] This is not a bug, you should use dbcc checkcatalog(pubs2,fixall) to also fix incorrect maxirow for system tables.

CR:381985

CR Number:   381985 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) 08 Jun 2005 Fixed 08 Aug 2005 Presently Not Targeted For Any Future Release Of This Product 08 Jun 2005 Fixed 20 Jun 2005 Fixed 21 Jun 2005 Fixed 07 Jul 2005 Fixed 07 Jul 2005 Fixed 19 Jul 2005 Fixed 18 Jul 2005 Fixed Description ASE ships the sample program, sybmapname.c, in $SYBASE/$SYBASE_ASE/sample/server but there is no accompanying README file to explain the purpose of the program, care to be taken with implementing it, hints of coding useage etc. This CR is to request engineering/build to provide a suitable README in the same directory (or other documentation) as the program itself. Workaround Description  preliminary README (amadsen - thanks) ------------------------------------ README: This README accompanies sybmapname.c sample code for ASE. Files in the example: README - this file sybmapname.c - sample filters out @realm and sets name in uppercase makefile - example makefile to build for 64bit solaris This example for name filtering is intended to only be used with Kerberos security mechanism in ASE. This example assumes that ASE has already been configured for Kerberos. Build the shared object (DLL) using the makefile supplied. For other platforms or to build 32bit solaris, the makefile needs to be modified. Place the resulting shared object libsybnamename.so in $SYBASE/$SYBASE_OCS/lib directory. The file should have read and execute permissions for the 'sybase' operating system user, that is, the operating system user that is used to execute the ASE dataserver program. It is recommended that only the 'sybase' user be allowed read and execute permissions, all other access should be denied. Verify with login to ASE using kerberos authentication. Cautions: Take care with the sample program and any modifications to it to avoid code that may segfault, that may call exit(), that may call system calls(), that may change UNIX signals, or make any blocking calls. Inproper coding or calls may interfere with the ASE server (engine) currently running. Code defensively, check all pointers before dereferencing them, avoid system calls. This must be a quick name filtering function. Feb 25 2005

CR:382028

CR Number:   382028 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 May 2009 Insufficient priority to fix Description Feature request for a syntax shortcut to create sharable temporary tables in the currently bound tempdb analogous to the use of "#" to create private temporary tables.

CR:382129

CR Number:   382129 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) 28 Mar 2005 Insufficient priority to fix Description 605 or 69x errors may be reported when loading a dump of a pre 11-9 database of size less than or equal to (n * 63) GB into a database of size greater than (n * 63) GB (for n = 1, 2, 3...). Workaround Description  the following will fix the problem pg_gam(dbid, -1, -1, fix)

CR:382140

CR Number:   382140 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) 08 Mar 2005 Fixed Description The message "current process infected with 11" may be reported in the module 'ind__get_sysindrow' when DBCC LISTOAM is run with an object ID value that is not a table. The stack trace in the error log will also report the modules 'ind_getval' and 'pg_list_oam'.

CR:382145

CR Number:   382145 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2008 Duplicate Description Outgoing ct-lib connections (via CIS or Replication Agent) may hang when the primary DNS is down. Also, if the outgoing connection is being done from engine zero, ASE server could stop accepting new connections.

CR:382169

CR Number:   382169 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2006 Fixed 02 Jul 2007 Insufficient priority to fix Description Historical Server README File incorectly states the ASE server name is a column in the output tables Workaround Description  Join Output table and sessions table to obtain the ASE server name

CR:382241

CR Number:   382241 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2005 Fixed 11 Feb 2007 Not reproducible with latest version of the product available as of Resolution Date Description A SELECT statement might run very slowly when a BIT column is involved in the WHERE clause. This could now be resolved by turning on traceflag 15303.

CR:382258

CR Number:   382258 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2005 Fixed Description During session termination, if session has done a messaging operation (msgsend(), msgrecv(), msgpublish(), or msgconsume()), a stacktrace (signal 11) may occur. The stacktrace in the errorlog will contain um_destroy_conn().

CR:382284

CR Number:   382284 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   NA Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2005 Fixed 23 Mar 2005 Fixed 16 Mar 2005 Fixed 22 Mar 2005 Fixed Description New feature: support added in migration tool to allow encrypted column migration.

CR:382293

CR Number:   382293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2005 Presently Not Targeted For Any Future Release Of This Product 10 Mar 2005 Fixed Description The message, "current process infected with 11" in the module 'sendichars()' together with a stacktrace containing the modules 'lwp_create', 'tdssend_dynparams' and 's_crtproc' is printed in the errorlog when sending a batch of dynamic SQL commands which in total have more than 255 dynamic parameters. Workaround Description  limit the number of placeholders (?) in a batch of Dynamic SQL statements to 255.

CR:382323

CR Number:   382323 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 May 2009 Insufficient priority to fix Description PARSER: Error 7348 is not consistently raised when duplicate column headings are used.

CR:382355

CR Number:   382355 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) 10 Jun 2005 Fixed 13 Jun 2005 Fixed Description Improve housekeeper garbage collection rate for index pages under aggressive GC option.

CR:382386

CR Number:   382386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2005 Fixed Description Replication Agent may do not sent the after image of an update if the column is defined as unsigned smallint.

CR:382474

CR Number:   382474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2005 Fixed Description 1) Referrals are chased automatically when LDAP user authentication mechanism is used by ASE which results in failure. 2) The sp_ldapadmin check_login 'login_name' fails.

CR:382522

CR Number:   382522 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2005 Fixed 29 Jun 2005 Fixed 07 Jul 2005 Fixed Description When UPDATE STATISTICS is run on proxy table that maps to a remote view, the command fails with some diagnostic errors in the ASE error log file. Workaround Description  The problem can be worked around using traceflag 11229.

CR:382542

CR Number:   382542 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) 15 Mar 2005 Fixed 23 Jun 2005 Fixed Description Spinlock contention on the memory pool that manages the 'heap memory per user' configuration parameter may be observed on a heavily-used multi-engine Adaptive Server. Workaround Description  Increasing "heap memory per user" from the default 4K to 16K should significantly reduce the contention on the heap block pool.

CR:382548

CR Number:   382548 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed 02 Jun 2005 Fixed Description The concurrent execution of a batch or a stored procedure that contains the commands CREATE INDEX on a partitioned table, DROP of a partitioned table, and SELECT-INTO that is run in parallel, may cause an undetected deadlock scenario between the concurrent tasks, requiring an ASE restart to unblock the situation. Workaround Description  For our in-house unit, trace flag 5303 (select-into run in serial) will avoid the hang situation. The trace flag 4915 (ex_tab vs. ex_int on syspartitions) won't be of help here. Suggest trace flag 5303 usage, granted that the customer is running similar stuff with our in-house unit.

CR:382555

CR Number:   382555 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) 25 Mar 2005 Fixed 13 Jun 2005 Fixed Description A 12314 error: "Bad child page pointer found on page <pageno> of index with id <indid> of table <tabname> in database <dbname>. Expected child page pointer to be <pageno1> but found <pageno2>. Check if the index is consistant using DBCC." may be encountered while running a lot of concurrent INSERTs, DELETEs and UPDATEs on a DATA_ONLY locked table.

CR:382645

CR Number:   382645 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2005 Fixed Description An error "Incorrect syntax near ')'." is reported with sp_helpdb if wildcards are used and a single match is returned.

CR:382686

CR Number:   382686 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2005 Fixed Description Feature request to let the backup server check the logical page number consistency as the pages ar copied to the dump archive. The feature is enabled if the backup server is started with trace flag -D64.

CR:382697

CR Number:   382697 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Not a Bug Description ASE fails to describe the name of input parameters for dynamic prepare statement: ct_dynamic(CS_DESCRIBE_INPUT) Workaround Description  When the application gets ready to execute the prepared statement, it must describe and send the parameters with ct_param() or ct_setparam() so in most cases, the application programmer knows what parameters they are trying to insert. An example of describing the input parameters for the insert statement: /* Execute phase of the dynamic statement */ ret = ct_dynamic(cmd_ptr, CS_EXECUTE, "d_insert", strlen("d_insert"), NULL, CS_UNUSED); RETURN_IF(ret, "execute phase failed"); /* prepare the first parameter description */ strcpy( param_fmt.name, "dynamic_ins"); param_fmt.namelen = strlen(param_fmt.name); param_fmt.status = CS_INPUTVALUE; param_fmt.datatype = CS_INT_TYPE; param_fmt.format = CS_FMT_UNUSED; /* set up the first paramenter */ ret = ct_param(cmd_ptr, ¶m_fmt, &col1, CS_SIZEOF(col1), CS_UNUSED); RETURN_IF(ret, "parameter one setup failed");

CR:382699

CR Number:   382699 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2008 Deferred Description ASE does not support TDS_PROTO_DYNAMIC capability per TDS Specification

CR:382806

CR Number:   382806 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2005 Fixed 03 Oct 2005 Fixed 11 Jan 2006 Fixed Description sp_addtype does not support the new feature allowing IDENTITY with INTEGER datatypes.

CR:382808

CR Number:   382808 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) 24 Mar 2005 Fixed Description The message "timeslice -501, current process infected" is raised together with a stacktrace printed in the errorlog containing the modules 's_crtproc', 'lwp_create' and 'make_negative_obj_id' when sending large amounts of dynamic SQL statements to the server without deallocating these dynamic SQL statements. Workaround Description  Use ct_dynamic() with CS_DEALLOC for each prepared statement finished. In the repro this part is commented out and therefore one will see the stacktrace + timeslice error.

CR:382824

CR Number:   382824 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 an easier method to retrieve data from a corrupt table

CR:382837

CR Number:   382837 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) 15 Aug 2005 Not a Bug Description Sybase Central ASE Plug-in and Interactive SQL (DBISQL) display binary datatype values differently depending on the size. Trailing 0's are displayed for size less than 256.

CR:382855

CR Number:   382855 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 Apr 2005 Fixed Description When the errors 1131 and 1142 are raised by the OAM builtins such as data_pgs() or used_pgs(), they are unexpectedly also written in the ASE's error log. Workaround Description  May want to use trace flag 1116.

CR:382856

CR Number:   382856 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) 24 Dec 2009 Duplicate 24 Dec 2009 Duplicate 24 Dec 2009 Duplicate Description The spinlock monitor area should dynamically increase to accomodate spinlock pool growth. Workaround Description  Reboot the server to cause the correct number of spinlock monitor counters to be allocated.

CR:382892

CR Number:   382892 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2005 Presently Not Targeted For Any Future Release Of This Product 23 Dec 2005 Fixed 23 Dec 2005 Fixed 20 Mar 2006 Fixed 09 Jan 2006 Fixed Description A new column RowsAffected has been added to monSysStatement and monProcessStatement indicating the number of rows affected by the completed statement and by the currently running statement, respectively. For monSysStatement, this columns corresponds to the value of @@rowcount after the statement's execution.

CR:382905

CR Number:   382905 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2005 Fixed Description Remove Preview from Proxy Table wizard

CR:382961

CR Number:   382961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2005 Fixed Description In Warm Standby Replication environments replicating DDL, a drop command may be incorrectly replicated if the object is using a large identifier.

CR:383017

CR Number:   383017 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2005 Fixed Description JISQL and SQL Advantage are removed from Utilities folder. These tools are replaced by Interactive SQL.

CR:383040

CR Number:   383040 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2005 Fixed Description CIS: Occasionally, on a heavily-loaded multi-engine system, the message "current process infected with 11" or "current process infected with 10" together with some stacktraces including different modules may be reported in the error log, and sometimes some ASE engines hang as well when running some CIS queries with 'set showplan on' option enabled.

CR:383052

CR Number:   383052 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed Description Add more explanations and instructions about default and rule expression, as wizard should be self explanatory.

CR:383053

CR Number:   383053 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) 03 Apr 2005 Fixed Description Contention on the procedure cache and the heap block pool governed by the "heap memory per used" configuration parameter is reduced by the addition of a spinlock specifically to synchronize access to the heap block pool.

CR:383054

CR Number:   383054 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) 19 Apr 2005 Fixed Description Spinlock contention can be caused by housekeeper license information chore on server with a high number of user connections configured. Workaround Description  sp_configure "license information",0 will disable this functionality and avoid the problem

CR:383064

CR Number:   383064 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2006 Fixed Description CIS: ct_command call may stack trace with Signal 11 at ct__api_new_sendcmd or Memory allocation failure message.

CR:383069

CR Number:   383069 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2005 Fixed 15 Jan 2006 Fixed 17 Jan 2006 Reservation Made Description In some cases, the message "current process infected with 11" in the module 'constree' together with a stack trace which includes the modules 'com_resdoms' and 'com_query' may be reported in the error log when referencing a column more than once and that column is defined as a subquery within a view.

CR:383083

CR Number:   383083 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) 14 Apr 2005 Fixed 19 Aug 2005 Fixed Description A transaction will be incorrectly rolled back when rolling back to a save point that follows a save point to which a rollback has already been performed.

CR:383410

CR Number:   383410 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) 01 Apr 2005 Fixed Description New feature request to export the set options textsize, stringsize and rowcount to the caller process of a login trigger. Currently this is enabled under trace flag 4073 only.

CR:383435

CR Number:   383435 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2005 Fixed Description Not visible to user.

CR:383617

CR Number:   383617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Feb 2006 Third Party Problem 13 Dec 2007 Third Party Problem Description On the Solaris platform, ASE may encounter undetected deadlocks, hung "waitfor" commands or database and transaction dumps, and similar problems when the operating system time is changed to an older date / time. This problem will resolve itself once the OS time moves ahead of where it was when it was set backwards. Workaround Description  Either wait it out, or reboot ASE when the OS clock moves backwards. The OS time should be changed by a delta approach. See adjtime/date -a. This adjusts the time but avoids UTC going backwards. Changing the OS time to simulate daylight saving changes is very artificial and is not what happens under the covers when daylight saving transitions happen... i.e. UTC is always going forwards and it is just the calculated wall clock time that changes.

CR:383660

CR Number:   383660 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 17 Jan 2006 Fixed 23 Jan 2006 Presently Not Targeted For Any Future Release Of This Product Description A Schedule's Between time option is not being saved when selected. Workaround Description  *** Thursday, March 17, 2005 2:52:57 PM *** cooperg *** Make sure you always re-check the radio button for Between before applying changes to repeating Jobs.

CR:383690

CR Number:   383690 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2005 Fixed Description Request to add description about error 880 message like below. "Your query is blocked because it tried to write and database 'testdb' is in quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE."

CR:383691

CR Number:   383691 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2005 Fixed Description Feature request to turn off error 880 message "Your query is blocked because it tried to write and database '<dbname>' is in quiesce state. Your query will proceed after the DBA performs QUIESCE DATABASE RELEASE." The behavior is activated using trace 833 in the runserver file.

CR:383722

CR Number:   383722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2005 Fixed 23 Apr 2005 One-off Provided 22 Jun 2005 Fixed Description In rare circumstances, a 605 error "An attempt was made to fetch logical page <page> belongs to object with id ..." may be reported by a table scan on a DOL table when a slow BCP IN command has been previously run parallel on this table. Only expected for a 64 bits server with more than one engine or a 32 bits server which is started with -T712. Workaround Description  Possible w/a: - disable LSA with TF 1101

CR:383744

CR Number:   383744 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2006 Fixed 06 Mar 2006 Fixed 16 Mar 2006 Fixed Description Space allocation is not optimal when inserting rows into an APL table having a clustered index and if the conditions are such that this table can hold 256 rows per page. Workaround Description  Create the inserted APL table using the 'with max_rows_per_page = 255' clause.

CR:383946

CR Number:   383946 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Presently Not Targeted For Any Future Release Of This Product Description SUBCASE NUMBER: 11122441-11 DATE: Fri Mar 18 12:47:23 EST 2005 TSE Login Name: marinak -- Marina Vilensky CUSTOMER NAME: Federal Express BASIC INFORMATION: Cust requeted to provide a new feature: Parallel Union All (high need) ============================== Currently in ASE, a union-all query is processed serially with each result set materialized in order. FEDEX would like the union-all to be able to execute in parallel - effectively with the same result set processing that a parallel query on a partitioned table in pre-15.x servers (in other words, results are set immediately through a family synch vs. held until previous query is complete). This would be controlled by %93max parallel degree%94/%94set parallel_degree%94 setting as well as by the parallel query controls (another Feature Request addressed by the subcase 11122438-11). ADDITIONAL INFORMATION: CR 362551 addresses a similar issue (Query with more than one union all is not run in parallel). It is a defect CR and is fixed in ASE 15.0. If the fix for the existing CR 362551 covers cust's request please associate this subcase with CR 362551. Otherwise, please open a new feature request. PLATFORM: Sun, HP. Operating System: Solaris, HP-UX Customer's ASE Release Version: 12.5.1 ESD#2 for 64-bit release. Workaround Description  *** Monday, March 21, 2005 9:02:01 AM *** cooperg *** N/A

CR:383950

CR Number:   383950 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2005 Fixed 30 Jun 2005 Fixed Description Maintain high-water mark for monSysStatement.MemUsageKB to reflect the max. amount of procedure cache memory allocated by each individual statement.

CR:383962

CR Number:   383962 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 Jun 2007 Fixed Description Message 18472 is raised by sp_dbcc_delete_history and is an informational message that should be printed rather than raised as an error.

CR:383967

CR Number:   383967 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 minimal-impact tool to fix misplaced extents in wrong segments without requiring entire table be reorganized.

CR:384050

CR Number:   384050 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) 29 Jun 2005 Bundled Request 16 Jun 2005 Fixed 06 Jun 2005 Fixed Description In rare circumstances, on a multi-engine ASE running with traceflag 1641, heavy disk i/o load can result in ASE client hang. In some situations it could also lead to server shutdown.

CR:384112

CR Number:   384112 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) 27 May 2005 Fixed Description For long job or schedule descriptions some of the description text may not be visible.

CR:384140

CR Number:   384140 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2010 Fixed 05 Mar 2010 Fixed 15 Mar 2010 Fixed Description Failed to build sample programs testmon and testhist on multiple platforms. Workaround Description  Compile on AS 2.1 with Makefile_linux_native

CR:384203

CR Number:   384203 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2007 Fixed Description -Y option of bcp 12.5.x does not support unilib conversion.

CR:384212

CR Number:   384212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2005 Fixed Description The message current process infected with 11 in treecpynames() with a stacktrace is printed in the errorlog containing the modules 'execproc', 's_compile', 'vu_viewcopy' when statement cache is enabled and a statement containing a derived table expression is send to the server. Workaround Description  switch off stmt cache

CR:384216

CR Number:   384216 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) 26 Jun 2005 Fixed Description UPDATE STATISTICS on proxy table may fail with error 10353 "You must have the following role(s) to execute this command/procedure: 'sa_role'". Workaround Description  Enable 11229. This also means that UPDATE STATS on proxy table will be done with the old behavior.

CR:384233

CR Number:   384233 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) 23 Mar 2005 Fixed Description Not customer visible

CR:384234

CR Number:   384234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2005 Fixed 21 Jul 2005 Fixed Description In multi engine scenario running a "disk resize" on an engine other than the one on which device has been initilized fails with an error 5166. Workaround Description  Bind a session to the engine already holding the advisory lock on the raw device being resized and execute 'disk resize' from that session. Use lsof or analyse the errorlog (look at the engine number for the message "Virtual device %d started using %s i/o").

CR:384261

CR Number:   384261 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) 08 Apr 2005 Fixed Description Under some conditions when an error occurs during SELECT INTO statement execution the Adaptive Server may attempt to unslice just created table even if this table is not sliced. While in majority of cases this action will not do any harm sometimes it may lead to errors like 622 ("Opentable was passed a varno of 2. Object already has that session descriptor in use.", 216 ("Attempt to automatically drop temporary table failed. ") and 3702 ("Cannot drop the table because it is currently in use. ") Workaround Description  change the subselect used to assign the column_variable so it returns only on item instead of multiple items...basically get rid of the 512 error.

CR:384412

CR Number:   384412 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) 27 Apr 2005 Fixed 21 May 2005 Fixed Description Error message 14513 requires two arguments (the database name, and name length), but ASE was providing none. The result was a poorly formatted error message, or, on some platforms, a stack trace and terminated connection.

CR:384429

CR Number:   384429 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 Sep 2005 Not a Bug Description Feature request: BCP to work when using -E for a table without identity column.

CR:384452

CR Number:   384452 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2006 Bundled Request Description Previsouly ASE Plug-in does not allow editing in place for compiled objects (stored procedures, views, etc.). This has been changed in 15.0 ESD#2 to allow editing when "DDL in tran" database option is enabled. Workaround Description  Right click on your stored procedure, select "Generate DDL". Make edits in DDL generator and save file as T-SQL. Use another application (such as ISQL) to run the modified T-SQL script.

CR:384613

CR Number:   384613 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2005 Fixed 01 May 2005 One-off Provided Description Segmentation violations in third pary Kerberos client libraries cause ASE crashes and denied access with high numbers of concurrent Kerberos authentication attempts from OpenClient applications. When using MIT Kerberos client library version 1.3.1 or earlier you can start ASE with traceflag 7844 that limits concurrent Kerberos authentications to avoid segmentation violations. The traceflag is not needed with CyberSafe or MIT verion 1.4 client libraries.

CR:384621

CR Number:   384621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2005 Bundled Request Description On platforms that support Kerberos, a catastrophic failure, such as when a segmentation violation or a call to the C library routine "abort()" has occurred within the 3rd party Kerberos client libraries, results in error message: "Internal error - Security Control Layer (SCL) is unavailable on this engine and cannot support any external security mechanisms". The error path also disables Kerberos operations on that engine. The fix intercepts execution in the error path to release resources and allows Kerberos operations to continue on that engine.

CR:384649

CR Number:   384649 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2005 Fixed Description On the Windows platform the message "Could not get context for engine %d because engine is running." may apppear in the errorlog during a configured shared memory dump. Workaround Description  Ignore the message, it is harmless

CR:384731

CR Number:   384731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed Description Command text auditing was erroneously capturing the SQL text of stored procedures during upgrade.

CR:384733

CR Number:   384733 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2006 Bundled Request Description Generate a warning message when a query is performed on the monOpenObjectActivity MDA table when the monitored server does not have the 'lock wait timing' configuration option enabled.