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

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

CR:389281

CR Number:   389281 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) 19 Jul 2005 Fixed Description A version string has been added to the installmontables script and this version is registered with ASE when the script is installed using the sp_version stored procedure.

CR:389287

CR Number:   389287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2005 Fixed 16 Jun 2005 Fixed Description Encryption key names are limited to 29 characters, whereas other identifiers in ASE (stored procedure names, table names, etc) can be upto 30 characters in length.

CR:389302

CR Number:   389302 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2005 Fixed 29 Jun 2005 Fixed Description Sqlupgrade may report "Error fetching results for query: ... CREATE TABLE spt_committab... " after "Running installcommit script", likewise the installcommit script may report error 2714, "There is already an object named 'spt_committab' in the database." Workaround Description  - Ignore this upgrade error. In the past CR 120859, filtered this 2714 message during install - Make a small change to the installcommit script: use sybsystemdb go if not exists (select * from sysobjects where name = "spt_committab" and sysstat & 7 = 3) begin +execute (" CREATE TABLE spt_committab ( commid int, /* id used to refer to transaction */ suid int, /* Server Login id of user that starts xa tran ** branch. This is only used by the XA interface. */ start datetime, /* time transaction started */ lastchange datetime, /* last time this row was updated */ totnum smallint, /* number of servers ** initially involved in xact */ outnum smallint, /* number of servers ** who still have not completed */ heur char(1), /* 'y'- was heuristically completed */ status char(1), /* 'a'- abort, 'c'- commit, 'b'- begin, 'p' - prepare */ xid binary(140), /* tran branch name */ applname varchar(30), /* application name */ xactname varchar(30), /* transaction name */ password varchar(30) NULL /* password protection for updating */ ) lock allpages +") end go

CR:389336

CR Number:   389336 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) 12.5.4 10 Aug 2005 Fixed 19 Nov 2007 Fixed Description Enhance the LOAD WITH HEADERONLY command to display disk fragment information

CR:389364

CR Number:   389364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2005 Fixed 20 Sep 2005 Fixed Description ASE may prematurely enforce a resource limit for "tempdb_space" resulting in error 11056 "Exceeded tempdb space limit of <value> pages." being raised. This may happen due to some inaccurate accounting of tempdb space during the execution of DROP TABLE, TRUNCATE TABLE and CREATE INDEX commands.

CR:389399

CR Number:   389399 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2013 Duplicate Description F.R. a system table or dbcc to list database dump / load info / history.

CR:389409

CR Number:   389409 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 Jul 2006 Fixed 07 Aug 2006 Fixed Description The message "current process infected with 11" in the module 'memcpy' togther with a stacktrace which includes the module 'ct_get_data' may be reported when accessing parsed XML documents using a local proxy table mapped to a remote proxy table that has an external directory defined on it. Workaround Description  instead of referencing the external file proxy table as another proxy table, first create a local table and then reference that as a proxy table. Create proxy table referencing the xml document. use testxml go create proxy_table xmlxfsTab external directory at "/work2/xmldocs;R" go select filename ,xmlcol=xmlextract("/",content) into xmldoctab from xmlxfsTab <----------inserted step where the external table data is extracted into a local table I referenced this new table xmldoctab on another 12.5 server called KAL_125 thus - create proxy_table kpxy at "GURU_1252.testxml.dbo.xmldoctab" go and then ran select xmlextract('/',xmlcol) from kpxy ..this did not get failure.

CR:389428

CR Number:   389428 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2009 Fixed Description monSysStatement does not distinguish between multiple executions of the same stored procedure in a single batch

CR:389523

CR Number:   389523 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) 31 Aug 2006 Fixed Description In rare circumstances on a heavily-loaded multi-engine system, when java is enabled, 10707 errors may be reported in an errorlog while deserializing java objects due to serialVersionUID mismatch between stream and local class.

CR:389537

CR Number:   389537 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Jun 2005 Fixed 14 Jun 2005 Fixed Description UPDATE STATISTICS on proxy table that contains numeric or decimal datatytpes may fail with Error Message 11291, Level 11, State 3: Histogram(step) statistics for colidarray <hex colidarray> is unavailable or incomplete in the remote server. together with diagnostic error in ASE errorlog stating Query in fetch_histogram() has error in fetched col = (varbinary column). Expect datum length .... Workaround Description  Turn on trace flag 11229 for those proxy tables that have indexes with numeric or decimal datatypes as the leading column. This will cause UPDATE STATS to run in the *old* behavior.

CR:389791

CR Number:   389791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2005 Fixed Description In rare circumstances, error 100024 (as reported by dbcc checkstorage) may remain unfixed by either dbcc checalloc or dbcc tablealloc with fix option.

CR:389812

CR Number:   389812 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2007 Fixed Description sp_modifylogin can remove the 'passwd expiration', 'min passwd length' and 'max failed_logins' value set for a single login and make that login have the same value as the system wide setting.

CR:389885

CR Number:   389885 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2005 Fixed Description Sybase Central ASE Plug-in generates a stack trace when trying to generate DDL for a Unique Constraint.

CR:389952

CR Number:   389952 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2005 Fixed 23 Mar 2006 One-off Provided 26 Mar 2006 Fixed 28 Mar 2006 Fixed Description ASE may experience a hang under heavy disk i/o conditions due to lost delayed I/O requests.

CR:390136

CR Number:   390136 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2005 Fixed 25 May 2005 Fixed Description An INSERT ... SELECT query that uses the TOP delimiter will unexpectedly insert zero rows in the target table.

CR:390150

CR Number:   390150 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 ESD#3 23 May 2005 Fixed Description EFTS: txtsvr core dumps when processing two sp_text_notify procedure calls from two different user databases.

CR:390179

CR Number:   390179 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2005 Fixed Description Unregister of ASEP will remove its icon from Sybase Central frame.

CR:390188

CR Number:   390188 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 Aug 2008 Bundled Request Description Feature request to allow SA to specify which errors will be logged by severity level Workaround Description  update master.dbo.sysmessages set dlevel = dlevel | hextoint("0x80") where severity = <severity>

CR:390212

CR Number:   390212 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2005 Fixed 24 Feb 2006 Fixed 09 Feb 2006 Fixed Description User will see English Help if Help contents is missing from Localized help but included in English help.

CR:390282

CR Number:   390282 Product Name:   Adaptive Server Generic Docs Product Component:   Using Sybase Failover In a HA System Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2005 Not a Bug Description Adaptive Server software installed on both cluster nodes, with the at least one Sybase release directory(%SYBASE%) directory(preferably Primary) residing on a shared volume. Not as part of a cluster group."

CR:390291

CR Number:   390291 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2009 Insufficient priority to fix Description Unlike isql, the charset utility does not tolerate spaces between parameter flags and values Workaround Description  Don't specify spaces between the parameter flags and values on the command line.

CR:390371

CR Number:   390371 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2006 Fixed 17 Jun 2005 Fixed 29 Mar 2006 Fixed 12 Jul 2006 Fixed Description select into encrypt is NOT failing with error 11776 when identity columns are encrypted.

CR:390450

CR Number:   390450 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2005 Fixed 13 May 2005 Fixed Description ASE has supported Apple's service discovery mechanism, previously called Rendezvous (and now called BonJour) since ASE version 12.5.0.2. This service allowed client programs to discover the location of a server, and connect to it, without having to configure the server in an interfaces file. However, services could only be discovered on the same subnet as the client. Since Mac OS X 10.3, the Rendezvous (BonJour) API has been updated to allow domain-wide service registration and service discovery. To enable domain-wide service registration within ASE, first set an environment variable in the RUN_servername command file at $SYBASE/ASE-12_5/install. The environment variable is BONJOUR_DOMAIN. For example: set BONJOUR_DOMAIN sybase.com. ; export BONJOUR_DOMAIN This feature is also available for Backup Server and XP Server, and is triggered by the same environment variable.

CR:390457

CR Number:   390457 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 default value of 'heap memory per user' is 4K It should be three times the size of logical page

CR:390522

CR Number:   390522 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed Description Auditinit support on Linix on EMT64/AMD64 platform. Target Version  12.5.4

CR:390534

CR Number:   390534 Product Name:   ASE Replicator Product Component:   Utilities Status:   Closed OS:   Generic Original Version:   4.0.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.0.0 15 Jun 2005 Fixed Description ASE Replicator: "sp_helprep version" now logs Java System properties in the system.log.

CR:390627

CR Number:   390627 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) 27 May 2005 Fixed 01 Jul 2005 Fixed Description The error 4821 "Identity value overflow error" may be unexpectedly raised during the insertion of rows with the BCP utility, if the target table had its schema changed earlier to gain an IDENTITY column and one or more non nullable column(s). This error would manifest only if the given columns were added through a single ALTER TABLE command. Workaround Description  a workaround is to remove the table descriptor from the cache after the ALTER TABLE command.

CR:390632

CR Number:   390632 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   NA Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2006 Fixed 28 Feb 2006 Fixed Description Message "getMsg: failure during argument substitution for message code %1" is printed to stderr when srvbuild[res] or sqlupgrade[res] failed to install installmaster.

CR:390649

CR Number:   390649 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) 02 Jun 2005 Presently Not Targeted For Any Future Release Of This Product 09 Jun 2005 Fixed 14 Sep 2005 Fixed Description Add a monLicense Monitoring Table to present information about licenses in use by the Adaptive Server Enterprise.

CR:390696

CR Number:   390696 Product Name:   Adaptive Server Enterprise Product Component:   sqldbgr Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2005 Fixed Description Wrong linenumbers could be reported while debugging a stored procedure using the sqldbgr program.

CR:390760

CR Number:   390760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed Description Performance optimization and enhancements on Mac OS X 10.4.2

CR:390802

CR Number:   390802 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) 14 Jun 2005 Fixed Description The boot time message "Database <DBNAME> is now online." may be unexpectedly printed twice in the ASE errorlog for "model", "sybsystemdb", and "tempdb" system databases.

CR:390896

CR Number:   390896 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 May 2005 Fixed Description Not customer visible

CR:390897

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

CR:390898

CR Number:   390898 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) 25 May 2005 Fixed Description Not customer visible

CR:390899

CR Number:   390899 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) 01 Jun 2005 Fixed 02 Jun 2005 Fixed Description Not customer visible

CR:390932

CR Number:   390932 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2005 Fixed Description HA VCS: During failover, dataserver process is not killed if shutdown is not successful. This can result in failback operation failure with error "Agent is unable to offline resource. Administrative intervention may be required." Workaround Description  Modify the "clean" script on line 137 to replace the following line: $engpid = split; Change to: ($engpid, $args) = split; Declare a $args variable in the beginning of the script.

CR:390936

CR Number:   390936 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2005 Fixed Description HA VCS: Offline operation may timeout and fail because, under high load conditions, ASE waits indefinitely for the server to complete all transactions on shutdown with wait.

CR:390942

CR Number:   390942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Performance enhancement: reduce 'recovery interval in minutes' below a minute Customer would like to be able to do checkpoint more often than 1 minute...they would like to checkpoint to run after so many SECONDS rather than MINUTES.

CR:391080

CR Number:   391080 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2006 Fixed Description The message "current process infected with 11" in the module 'pre_alttab' may be reported in the error log when executing the 'ALTER TABLE' command for a table having an 'auto identity' column and if the command needs a data copy. This may happen if the session level 'quoted_identifier' option is on or if the table name length is greater than 28 characters. Workaround Description  1. Rename the object with a name less than 29 character long. 2. Do not use quoted identifier 3. do not use 'auto identity'

CR:391093

CR Number:   391093 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) 06 Jun 2005 Fixed Description When sybsystemdb is bound to a named cache, customer may hit a segmentation violation with message "current process (<value>) infected with 11" in module 'bufdlink' followed by a stack trace in the error log. This results in an implicit shutdown of ASE. Workaround Description  1) Don't bind sybsystemdb 2) Turn off xact coordination 3) unbind sybsystemdb before 'shutdown' and bind it back after Recovery is complete and ASE is booted

CR:391119

CR Number:   391119 Product Name:   Adaptive Server Enterprise Product Component:   DBXray Status:   Closed OS:   Microsoft Windows Original Version:   3.2.01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2006 Fixed Description DBXray for ASE client is now a java application instead of a web-based applet

CR:391170

CR Number:   391170 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2005 Fixed Description HA VCS: Clean operation generates "Illegal division by zero at sybhautil.pm line 1258" error. Workaround Description  Append a quotes and "$" before errorlog. i.e. the final line should read as: $errorlog="$Sybase_home/$errorlog";

CR:391178

CR Number:   391178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description The input parameter @table_name in sp_columns is limited to 32 characters. Passing in a name greater then 32 characters using [] to 'escape' special character _ for the LIKE clauses used in sp_columns, will cause sp_columns to return no results for that tablename. Workaround Description  rewrite sproc. Enlarge identifiers table_name, owner and columnname from 32 to 255.

CR:391187

CR Number:   391187 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 Oct 2006 Fixed 25 Mar 2009 Not a Bug Description When range predicates are used on columns involved in join predicates then the join estimations may not be accurate. This may affect join orders in complex queries. In the query below, before the fix, the row cound estimate of the result was 1892, but after the correction, the estimate of 187 rows is much closer to the actual join result of 184 rows. select count(*) from t1, t2 where a1=b1 and a1<1893 go ----------- 184 ==================== Lava Operator Tree ==================== Emit (VA = 5) r:1 er:1 cpu: 0 / ScalarAgg Count (VA = 4) r:1 er:1 cpu: 0 / MergeJoin Inner Join (VA = 3) r:184 er:187 / \ Sort IndexScan (VA = 1) i1 r:185 er:187 (VA = 2) l:6 el:6 r:184 er:187 p:0 ep:0 l:2 el:4 cpu: 0 bufct: 24 p:0 ep:4 / TableScan t1 (VA = 0) r:185 er:187 l:36 el:36 p:0 ep:36 ============================================================

CR:391255

CR Number:   391255 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2005 Fixed 18 Oct 2006 Fixed Description The datepart function gives incorrect results for TIME NULL values.

CR:391298

CR Number:   391298 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2005 Fixed Description TIBCO JMS libraries are now dynmically loaded rather than statically linked into the ASE executable. The user must include the correct DLL path(s) in LD_LIBRARY_PATH or equivalent.

CR:391335

CR Number:   391335 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for HP Status:   Open OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Found the wrong description about granting MLOCK permission in Installation Guide Adaptive Server Enterprise for HP-UX.

CR:391364

CR Number:   391364 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) 25 May 2005 Fixed Description LDAP allows users to get authenticated and there are check_login inconsistencies when set_access_acct is invalid and anonymous binds are turned off in the LDAP server.

CR:391370

CR Number:   391370 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2005 Duplicate 17 Jul 2005 One-off Provided Description Instrumentation to track a missing write on data or index pages. Workaround Description  No workaround (DOL not tried).

CR:391486

CR Number:   391486 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 Request from customer to extend CR#292330 to database level

CR:391536

CR Number:   391536 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) 24 Oct 2006 Fixed 13 Jul 2006 Fixed Description Under rare circumstances, a timeslice error in module 'des__do_unlink' may be reported in the error log when a session tries to drop a dynamic statement. The module 'lwp_drop' will also be reported in the stack trace. Workaround Description  n/a

CR:391683

CR Number:   391683 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2006 Fixed Description libtcl.cfg fails to load if there are embedded comments in the file.

CR:391734

CR Number:   391734 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2005 Fixed 05 Jun 2005 Fixed 28 Jun 2005 Fixed Description On a 32 bit Linux platform, an OAM page of a recently created table may contain the object id of another recently created table, resulting in a 605 error when server is configured for Large Memory Support (the "extended cache size" is set to a non-zero value). Workaround Description  increase "number of oam trips" sp_configure parameter

CR:391822

CR Number:   391822 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 2010 Not a Bug Description max_rows_per_page limitation for tables on higher logical page size servers (4K to 16K) should be more than 256".

CR:391824

CR Number:   391824 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2005 Fixed Description documentation of 'max_rows_per_page' of 'create index' command is no correct

CR:391901

CR Number:   391901 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2005 Fixed 26 May 2005 Insufficient priority to fix 13 Jun 2005 Fixed Description A 2630 error "In database '<value>', page <value> is linked backward to page <value>, but that page is linked forward to page <value>." may sometimes be encountered while several sessions are running concurrent DELETEs on the same DATA_ONLY LOCKED table in a multi-engine environment.

CR:392000

CR Number:   392000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2005 Duplicate Description query on a datarows table, generates 551 error Workaround Description  use all pages locking schema

CR:392008

CR Number:   392008 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) 06 Jun 2005 Fixed 27 Oct 2005 Fixed 07 Jul 2006 Fixed 11 Jul 2006 Reservation Made Description Enhance DBCC CHECKTABLE to give a better estimate of table fragmentation for DATA_ONLY_LOCKED tables.

CR:392070

CR Number:   392070 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) 09 Dec 2005 Fixed Description A process may deadlocked with itself on an allocation page latch following a log full condition (1105 error). This connection may then block other connections needing the same latch or other locks this session holds.

CR:392078

CR Number:   392078 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc bug in description of intent locks

CR:392110

CR Number:   392110 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2005 Fixed Description On the Windows platform, when ASE is blocked while sending results to an SSL client, the process can now be terminated using the kill command.

CR:392181

CR Number:   392181 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2005 Fixed Description 'Invalid pointer param number' message is appended to Error Msg 10331, when 'create proc' is run by a login with insufficient permissions, on an IBM AIX 64 bit ASE FBO dataserver.

CR:392262

CR Number:   392262 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2005 Bundled Request Description On (32-bit Linux) RH AS 2.1 or RHEL 3.0, the operating system ignores requests from ASE to bypass the file system cache for file system database devices. This can result in modified data pages not flushed to disk when ASE thinks the data is on disk. In cases where there is a power failure or other system crash, these modifications may be lost leading to data corruption.

CR:392320

CR Number:   392320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   IRIX Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2006 Not reproducible with latest version of the product available as of Resolution Date Description Several instances of increased lock usage when running ASE 12.5.2 or higher. Problem does not appear on 12.5.0.x. The following are two instances that show this problem: 1) dbcc checkalloc. 2) Multiple bcp's running against the same database. Workaround Description  *** Tuesday, May 31, 2005 1:21:24 PM *** cooperg *** None.

CR:392325

CR Number:   392325 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2005 Fixed 18 Jan 2006 Fixed Description Monitor GUI been updated to use JfreeChart from Netchart.

CR:392381

CR Number:   392381 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2006 Fixed Description sp_sysmon may show you negative values in "Other Causes" of "Task Context Switches Due To:" section if "disable disk mirroring" configuration parameter is 0.

CR:392419

CR Number:   392419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2005 Fixed 27 Jun 2005 Fixed Description The previous restriction on IDENTITY columns created by the select/into statement, which limited the datatype to NUMERIC, has been lifted. With this change, identity columns may be of type numeric, int, smallint or tinyint. All other aspects of managing the identity value remain the same as in previous releases. New syntax allowed: select columnname=IDENTITY(int|smallint|tinyint|integer) ... into tablename... Previous behavior, which created a new NUMERIC column with specified precision, remains unchanged.

CR:392463

CR Number:   392463 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2005 Duplicate 04 Aug 2005 Fixed 17 Oct 2005 Fixed 26 Oct 2005 Fixed 26 May 2006 Fixed Description syconfig.exe or sybatch.exe creates "%SYBASE%\data\sybsysdb.dat" device during the ASE upgrade.

CR:392492

CR Number:   392492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2005 Fixed Description The message current process infected with 11 in vu_fixupvar is printed in the errorlog together with a stacktrace containing the modules 'vu_fixupview', 'vu_addviewqual' and 'pre_aggview' when executing a SELECT containing a subquery in the select-list, a derived table expression in the FROM clause and another subquery in the WHERE-clause.

CR:392544

CR Number:   392544 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2005 Fixed 08 Mar 2007 Fixed Description sp_helprotect does not show privileges related to encryption keys.

CR:392556

CR Number:   392556 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) 26 Oct 2006 Fixed 28 Mar 2008 Fixed Description sp_monitorconfig reports a high value for Num_Reuse output per pss resources and doesn't correlate with the values displayed in column Num_Active.

CR:392645

CR Number:   392645 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2005 Fixed 26 Jan 2006 Fixed 19 Jul 2005 Fixed Description SamReport, the utility by Microvision supporting SySAM 2.0, should be launched from ASE Plug-in's Utilities Panel. Modify Utilities folder, add Wizard so user can add in external utilities

CR:392653

CR Number:   392653 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2005 Fixed 03 Apr 2006 Fixed 28 Mar 2006 Fixed 02 Jun 2006 Bundled Request Description Syconfig creates "sybsystemdb" logical device for "sybsystemdb" database. The correct logical device name for "sybsystemdb" database is "systemdbdev".

CR:392691

CR Number:   392691 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2005 Fixed Description Revoke Decrypt does not get called for group and user objects when revoke (a cross sign) is selected on permission tab. Correct that in this CR.

CR:392692

CR Number:   392692 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2005 Fixed Description For internal use only (update complete lists for DBISQL, ASEP, DDLGen and PlanViewer drop)

CR:392749

CR Number:   392749 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) 21 May 2008 Fixed Description When nested VIEWs are used (i.e. VIEWs defined by referencing other VIEWs), then it is possible that the query will not be correctly processed and result in an error in which the session could be terminated. If this is suspected, then it can be verified by using the diagserver and looking for an assertion such as the following: "Assertion (infinite_loop != vrangep) failed"

CR:392779

CR Number:   392779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description Disk Init on NFS : On AIX, performing a disk init of a very large device over an NFS share hangs indefinitely. Workaround Description  *** Friday, June 03, 2005 10:32:38 AM *** cooperg *** None.

CR:392945

CR Number:   392945 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description error 404 occurs when more than 1024 AND/OR expression are used in a query not 251

CR:392963

CR Number:   392963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description The message "current process infected with 11" in the module 'ind__copy_row' together with a stack trace which includes the modules 'des__systs_flushall' and 'des_checkpoint' may be reported in the error log during dump database when the "number of open indexes" is under configured and Adaptive Server is configured to use more than one engines. Workaround Description  Looks like this is related to scavenging IDES structures and flushing stats for the being scavenged IDES at the same time. Workaround may be to increase config "number of open indexes" to avoid scavenging.

CR:393021

CR Number:   393021 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2005 Fixed Description Error message shown when localized help is missing or a help topic is missing from localized help.

CR:393052

CR Number:   393052 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) 07 Sep 2005 Insufficient priority to fix Description FR to have user defined roles set as Default 'ON'

CR:393089

CR Number:   393089 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 15 Jun 2005 Fixed Description Under command line trace flag 1138, implement mechanism to reduce fragmentation of DATA_ONLY_LOCKED tables.

CR:393125

CR Number:   393125 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2005 Fixed 12 Jul 2005 Fixed Description The error 17230,"Server '%s', Procedure 'sp_optimal_text_space', Line 103: You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure." will be incorrectly raised if the user is an alias to the DBO. Workaround Description  >isql -Usa 1> sp_addlogin cool, "yayat67" 2> go Password correctly set. Account unlocked. New login created. (return status = 0) 1> use test2 2> go 1> sp_changedbowner cool 2> go The dependent aliases were dropped. DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. Database owner changed. (return status = 0) 1> quit >isql -Ucool -Pyayat67 1> use test2 2> go 1> create table t ( a int , b text ) 2> go Msg 2714, Level 16, State 1: Server 'loc_server', Line 1: There is already an object named 't' in the database. 1> sp_chgattribute t, "dealloc_first_txtpg", 1 2> go 'dealloc_first_txtpg' attribute of object 't' changed to 1. (return status = 0)

CR:393211

CR Number:   393211 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2005 Fixed 05 Jul 2005 Fixed 09 Jan 2006 Fixed 09 Jan 2006 Fixed Description Some of the memory data items in monitor client library (e.g. SMC_NAME_MEM_CODE_SIZE, SMC_NAME_MEM_KERNEL_STRUCT_SIZE) always return a zero value.

CR:393214

CR Number:   393214 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 to have option of turning off "database context change" messages. Workaround Description  None.

CR:393264

CR Number:   393264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer does not like to have to "disable" triggers, Run BCP and then, "enable" triggers, would like it to be an option of BCP. BCP would need to alter the table to disable triggers and the enbale the trigger once the BCP has run. Related to the above: Customer would also like a Warning message letting them know that he disabled the trigger on a Table. He thinks it's dangerous not to be reminded that a trigger was disabled.

CR:393368

CR Number:   393368 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2005 Fixed 29 Jun 2005 Fixed Description The message "Invalid column length: <xx>. Value must be between 0 and 30 for 'all-pages' row with minimum row length of <xx>." is printed in the errorlog together with a stacktrace containing the modules 'insert_index_row', 'ncupdate' and 'obj_newrow' when executing CREATE TABLE <identifier>, whereby the identifier is >30 bytes using a multibyte character set.

CR:393380

CR Number:   393380 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2006 Fixed Description The syconfig.exe doesn't use user specified system database device path.

CR:393408

CR Number:   393408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2006 Fixed 24 Aug 2006 Fixed 11 Apr 2007 Fixed Description An INSERT into a table with a varbinary column using several UNION clauses to select data from columns based on the timestamp datatype can lose the original selected values. New timestamp values are inserted instead in the varbinary column. Workaround Description  Use convert(varbinary,timestamp_colum) seems to solve the issue. insert into A (c1, c2) select c1, c2 from B union all select c1, convert(varbinary,c2) from C union all select c1, convert(varbinary,c2) from D go

CR:393452

CR Number:   393452 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   AIX 5.1 Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2005 Fixed Description Column level constraints don't show up in Sybase Central if column numbers are used instead of column names

CR:393501

CR Number:   393501 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) 14 Sep 2006 Fixed Description Setting the 'short ltl keywords' configuration option of replication agent to true, then replication agent will send short ltl keywords of transaction log language to the replication server. Workaround Description  The true/false is just opposite of what it should be. For long keywords, set ltl short keywords to true. For short keywords, set ltl short keywords to false (default)

CR:393502

CR Number:   393502 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2005 Fixed Description Highlight text foreground color forced to be white color.

CR:393526

CR Number:   393526 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) 11 Jan 2006 Fixed 15 Jan 2006 Fixed Description New LDAPUA feature that sends additonal password related infromation to the audit log, when a login tries to bind to the LDAP server.

CR:393542

CR Number:   393542 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) 16 Jun 2005 Fixed 21 Jul 2005 Fixed 15 Sep 2005 Fixed Description In rare circumstances, a 692 or other similar error may be reported on the master database when restarting Adaptive Server after a earlier abnormal termination or SHUTDOWN WITH NOWAIT.

CR:393573

CR Number:   393573 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) 18 Sep 2005 Presently Not Targeted For Any Future Release Of This Product Description For certain value distributions the scoring for a < column = constant> is too high compared to <column between constant and constant> Workaround Description  Increasing step-count can help

CR:393647

CR Number:   393647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2005 Insufficient priority to fix Description error 3626 showing %d, %s instead of values from pss structure

CR:393740

CR Number:   393740 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Aug 2005 Fixed 04 Sep 2005 Fixed 05 Jun 2006 Fixed 29 Aug 2005 Fixed Description The stored procedure sp_help when used on an encryption key displays a blank name, owner and object type information.

CR:393754

CR Number:   393754 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2005 Fixed Description CR 378774 fix in 12.5.3 ESD#2 is not effective and syconfig.exe does not allow choosing location of sybsystemdb device.

CR:393772

CR Number:   393772 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request to give memdump command an option to take memdump without halting engines in the case all engines can't be stopped