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

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

CR:343115

CR Number:   343115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2004 Fixed 18 Feb 2004 Fixed Description Two processes setting up a site_handler may hit a race condition, causing a hang. The hang will be accompanied by the message "A call to srv__waitfor_read() was interrupted by an attention". Workaround Description  for the backupserver hang case, sp_serveroption SYB_BACKUP, "timeouts", false go will help to decrease the possibility that we try to create 2 site handlers for the same server at the same time.

CR:343118

CR Number:   343118 Product Name:   Adaptive Server Enterprise Product Component:   buildmaster Status:   Open OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Include 11x_bmaster binary with ASE >= 12.5.x installs

CR:343120

CR Number:   343120 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Bundled Request Description 'number of dumps' counter of CSMD increments even if memdump is failed Workaround Description  "Reset the number of dumps by command - sp_shmdumpconfig 'reset', <type>, value"

CR:343252

CR Number:   343252 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed Description Querying the monCachedObject table can cause other processes to timeslice. When this occurs the query will take much longer to execute and the ASE errorlog will contain the error "timeslice -<value>, current process infected" followed by a stacktrace.

CR:343260

CR Number:   343260 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) 12 Jan 2004 Fixed 12 Mar 2004 Fixed Description If an @variable is buried in a nested derived table, it may lead to stack trace.

CR:343360

CR Number:   343360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Presently Not Targeted For Any Future Release Of This Product 24 Feb 2004 Fixed Description CIS: Local server may show stack trace when errors are encountered on sp_remotesql or sp_passthru in a multi-session environment in which some of the sessions may hang in 'remote i/o'. Workaround Description  Explicity run "set quoted_identifier on" before running sp_remotesql

CR:343363

CR Number:   343363 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2004 Fixed Description With ASE 12.5.2 ASEPlugin, the plugin parsing of template documents, JS Template schema and instance documents have been modified. The JS Template XML instance documents must be re-installed if users are upgrading from the ASE 12.5.1 ASEPlugin. If users do not upgrade their ASEPlugin, the latest JS Template instance documents should not be upgraded. The changes were required to support localization for the Job Scheduler interface within the ASEPlugin.

CR:343446

CR Number:   343446 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) 16 Jan 2004 Fixed Description Query using non intialized bit local variable may fail with error 245: "Domain error during implicit conversion of BIT value '0' to a BIT field." Workaround Description  Assign some value to thelocal variable before running the query.

CR:343448

CR Number:   343448 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jan 2004 One-off Provided Description INSTRUMENTATION: Network listeners disappear without error on ASE 12.5.1 running on win2000 adv server

CR:343495

CR Number:   343495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2004 Fixed 02 Dec 2004 One-off Provided 29 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date Description A 12536 message "Sysstatistics upgrade warning for table <table>. New row-length after upgrade, 1965, ... exceeds maximum limit of 1964. Run update statistics on this table after upgrade." may be reported in rare circumstances during an upgrade from a pre 12.5 server. Workaround Description  1.Use query from CR description to find the length of statistics rows before upgrade 2.For rows with length 1964, save the stats before the upgrade to a file using optdiag and restore them after the updrade.

CR:343514

CR Number:   343514 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2004 Fixed 23 Feb 2004 Fixed Description A query SELECT ...UNION ...SELECT may return incorrect result or hang if different UNION sides are executed with different degree of parallelism. Workaround Description  Problem did not occur 1) when max scan parallel degree and max parallel degree , both=10 or 2) with enable sort-merge join and JTC=0 or 3) if we changed query and removed 1=2 clause*/

CR:343560

CR Number:   343560 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) 21 Jan 2004 Fixed Description Error 103, "The identifier that starts with "<constraint name>" is too long. Maximum length is 28." is raised during ALTER TABLE add <column> command on a table which has a column using a constraint name of 30 characters. Workaround Description  Use an APL table or shorten the identifier name

CR:343593

CR Number:   343593 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2004 Fixed Description Job Scheduler sp_sjobsetstatus commands embedded into a job's SQL were incorrectly operable on other job's besides its own. This has been corrected.

CR:343638

CR Number:   343638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 One-off Provided Description INSTRUMENTATION: A stack trace occurs either in krtmsg or kaddmsg due to corrupted message queue.

CR:343644

CR Number:   343644 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) 11 May 2004 Fixed Description Text/image columns should not be listed on the second page of Index Wizard for creating a new index because they cannot be the columns of an index.

CR:343673

CR Number:   343673 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) 15 Jan 2004 Fixed Description ASE will incorrectly report the messages "WARNING: Pss found with open sdes ... range entry <value> ..." or "WARNING: Pss found with open sdes ... system table entry <value> ..." when a session hits a non-fatal internal error and a system or user table has been left open mistakenly.

CR:343685

CR Number:   343685 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) 21 Jan 2004 Fixed Description sp_sysmon reports negative Cache Misses on a multi-engine server on NT platform when there is considerable load on the server.

CR:343707

CR Number:   343707 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2004 Duplicate Description XP Server sample xp_echo won't compile. Missing the Open Server header files. Workaround Description  Purchase an Open Server license to get the required files.

CR:343710

CR Number:   343710 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2004 Fixed Description Job Scheduler job output which contains "(return status = <status>)" may not be appropriately followed by starting a new line. This has been corrected.

CR:343729

CR Number:   343729 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2006 Fixed Description XP Server documentation is outdated, incorrect and incomplete. Workaround Description  Call support for an explanation.

CR:343769

CR Number:   343769 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   macosx Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jun 2004 Not reproducible with latest version of the product available as of Resolution Date 29 Sep 2004 Fixed Description For Mac OS X platform: When the Backup Server is shutdown normally, a message warning of possible memory corruption is written to the backup server errorlog. This problem has been corrected.

CR:343795

CR Number:   343795 Product Name:   Adaptive Server Enterprise Product Component:   DBXray Status:   Closed OS:   Solaris Original Version:   3.0.01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2006 Fixed Description Invalid output problem using DBXray with non-English locales now has been fix via BMC Bug #388263 Workaround Description  When the ct later changed the OS language from spanish to english, the tool worked as intended.

CR:343799

CR Number:   343799 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) 27 Jan 2004 Fixed Description Under some circumstances when executing a client cursor or a SELECT ... FOR BROWSE on a view, the base table column names are returned instead of the view column names. Workaround Description  1. Client application can use descriptor returned when statement is declared (not after cursor is opened). 2. Code view to use convert() (or similar functions) to "hide" table column names.

CR:343826

CR Number:   343826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2004 Fixed Description Use 'auditinit' to install Auditting capabilities may see the messages of "Task failed: install auditing capabilities. Terminating configuration." on AIX platform. Workaround Description  Looking through the sub-case notes - sybsecurity db seems to be setup correctly with truncate log on checkpoint. So the workaround is to ignore the message.

CR:343958

CR Number:   343958 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) 04 Feb 2004 Insufficient priority to fix Description Feature request for a method to automatically propogate ALTER TABLE changes such as drop column, add column, and modify datatype on base tables to proxy table definitions

CR:343982

CR Number:   343982 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) 05 Feb 2004 Fixed Description Passing a serialized java object on a non Java enabled server causes signal 11

CR:343992

CR Number:   343992 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2004 Fixed 15 Aug 2004 Presently Not Targeted For Any Future Release Of This Product Description A 5807 error, "Invalid memory move request encountered for the <poolsize> pool in cache <cachename>" is reported when trying to configure a 4G pool on a 64 bit server.

CR:344012

CR Number:   344012 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2004 Fixed 22 Jan 2004 Fixed Description Stored procedure text stored in syscomments with strings of spaces may not be correctly retrieved with defncopy tool. Spaces may be missing in the defncopy generated file.

CR:344016

CR Number:   344016 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) 02 Feb 2004 Fixed Description The error 2812, "Stored procedure '"$monSysSQLText"'", will be raised when selecting from the MDA table monSysSQLText if quoted_identifier is enabled. Workaround Description  Set quoted_identifier off before running these queries.

CR:344097

CR Number:   344097 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2004 Fixed Description dump with compress option, when tape drive full not prompting for new tape Workaround Description  Not to use compression

CR:344164

CR Number:   344164 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2004 Fixed Description Dropping a proxy table which was mapped to an external directory with the ;R (recursive) option and recreating it again without it, still leaves the ;R option active. Workaround Description  Recycle ASE to clear option or Use another proxy_table name.

CR:344182

CR Number:   344182 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed Description Job Scheduler agent process may hang while processing a shutdown request if its Job Scheduler ASE shutdowns first. This has been corrected.

CR:344187

CR Number:   344187 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) 19 Feb 2004 Bundled Request Description When using Sybase Central ASE Plugin to create a schedule on localized Chinese or Korean systems the error "com.sybase.jdbc2.jdbc.SybSQLException: Syntax error during explicit conversion of VARCHAR value '2004/1/20 Uと 1:56' to a DATETIME field." occurs (actual date values will vary).

CR:344209

CR Number:   344209 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   HP-UX Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Feb 2004 Fixed 06 Jul 2004 Fixed Description CIS: In some situations, a SELECT statement against a proxy table involving CASE and GROUP BY may have duplicate returns even if GROUP BY list is exactly the same as SELECT list.

CR:344299

CR Number:   344299 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2004 Fixed Description When object names are provided to parameterized LANGUAGE statements and the datatype of the parameter is specified as UNICHAR, conversion from UNICHAR to CHAR may not be correct if the server's default character set is configured to something other than UTF-8.

CR:344324

CR Number:   344324 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2004 Presently Not Targeted For Any Future Release Of This Product 26 Apr 2004 Fixed Description The error 10334, Level 18, State 80, may be raised if a procedure contains a select into statement using a view created on table that is recreated. Workaround Description  sp_configure "auditing",0

CR:344343

CR Number:   344343 Product Name:   Adaptive Server Enterprise Product Component:   upgrade Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2004 Fixed Description Minor upgrade does not detect date or time user defined types that are upper case. Workaround Description  see email in CR descrition

CR:344349

CR Number:   344349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2004 Fixed Description Sp_addtype should not allow user defined types with upper case versions of system type names.

CR:344391

CR Number:   344391 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) 09 Feb 2004 Bundled Request Description Rows with blank PlanText should not be reported in monSysPlanText.

CR:344403

CR Number:   344403 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2004 Fixed 04 Jun 2004 Fixed Description A performance decrease may result when executing a query in a stored procedure that has to be recompiled and renormalized (for example due to a load database, an object recreation, etc.) and that query contains a search condition using a NUMERIC arithmetic expression (addition or subtraction). Workaround Description  workarounds identified are: (1) drop/create the sproc after dump/load (2) change the sproc so an explicit convert(numeric(18,0),(@var +1)) or define @var as numeric(17,0) instead of numeric(18,0) (3) use traceflag 291

CR:344416

CR Number:   344416 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) 02 Feb 2004 Fixed Description The error 18898 will be raised in the stored procedure 'sp_modifylogin' when setting up the login script if the length of the user's default database plus the login name exceed 27 characters. Workaround Description  Change the size of 'sqltext' in sp_modifylogin: e.g. declare @sqltext varchar(255)

CR:344466

CR Number:   344466 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2006 DEFER Description When dump mulitple databases to a tape recieved "Tape will be rewound message" on Linux AS 2.1

CR:344484

CR Number:   344484 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2004 Fixed 26 Feb 2004 Fixed Description 1> HAaseAgent Fails to start, errors saying libsybtcl.so not found. 2> when the HAase Agent online scripts start ASE, it starts as user "root" and not as user "sybase" and when Agent offline script trys to stop ASE , it is not stopped . Platform: Linux

CR:344561

CR Number:   344561 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed Description The message "Incorrectly built binary which accesses errno or h_errno directly. Needs to be fixed." appears when srvbuild and other ASE utilities are run on Red Hat Enterprise Linux 3.0.

CR:344578

CR Number:   344578 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) 08 Feb 2004 Duplicate 08 Feb 2004 Duplicate Description Clients sometimes get unable to connect errors when there are high numbers of connection requests to an ASE using the sockets nrt library. Workaround Description  Use the TLI driver as this has a backlog of 128

CR:344620

CR Number:   344620 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.0.0.8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2004 Fixed 05 Feb 2004 Fixed 13 Aug 2004 One-off Provided Description CIS: In some circumstances, a multi-engine server may be infected with signal 10 or 11 and core dumps, or causes ASE to hang after running sp_showplan. Workaround Description  No workaround except to run ASE in mono-engine mode.

CR:344650

CR Number:   344650 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2004 Presently Not Targeted For Any Future Release Of This Product 21 Jun 2004 Presently Not Targeted For Any Future Release Of This Product Description backupserver hangs during load of striped database on Linux AS 2.1 Workaround Description  Don't do a striped load/dump.

CR:344713

CR Number:   344713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed 08 Mar 2004 Fixed 02 Apr 2004 Fixed Description When inserting data using BCP into a table with a DEFAULT value defined on a VARCHAR column and the file to load does not specify value for that column, the DEFAULT value inserted into the table is silently truncated to 30 chars. Workaround Description  After bulk copy in, run update on columns that contain the truncated value (assuming that value is unique!).

CR:344722

CR Number:   344722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2004 Fixed Description If command line trace flag 11906 is turned on, informational messages from REORG will no longer be printed to the errorlog.

CR:344729

CR Number:   344729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a unique constraint on sysloginroles (suid,srid)

CR:344752

CR Number:   344752 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2004 Fixed Description The list of engines in the output of the system stored procedure sp_showcontrolinfo is truncated when there are more than 5 engines bound to a certain engine-group.

CR:344805

CR Number:   344805 Product Name:   ASE Replicator Product Component:   Distributor Status:   Closed OS:   Generic Original Version:   12.5.0.109P6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.0.0 24 Feb 2004 Fixed Description ASE Replicator: A replicate stored procedure with nocount set off that contains a SELECT and a RAISERROR does not stop replication if the RAISERROR fires. Workaround Description  Add as first line in a replicated stored procedure the clause "set nocount on"

CR:344840

CR Number:   344840 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2004 Fixed Description srvbuild, srvbuildres, syconfig.exe, and sybatch.exe adds XP server as "ASEnterprise" server class. XP server should have "RPCServer" server class.

CR:344983

CR Number:   344983 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) 18 Feb 2004 Fixed 24 Mar 2004 Fixed Description Feature extension. Before this fix the XML builtin xmlparse retuned the result xml fragment as image datatype. The fix adds the ability to return the result xml fragment also as varbinary/binary datatype using additional 'returns' clause syntax. Before this fix the XML builtin xmlextract returned the result xml data as either text or varchar. With the fix the user will be able to return the result xml data as java.lang.String also. Before this fix the XML builtin xmlrepresentation accepted xml documents only as image datatype as one of its operands. With this fix user can now pass xml documents of varbinary/binary datatype also to this builtin.

CR:345007

CR Number:   345007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2004 Fixed 18 Feb 2004 Fixed 25 Feb 2004 Diagnostic Provided Description Error 102, "Incorrect syntax near '?'." is raised when a prepared statement is executed using JDBC having ANSI-style comments at the end of the command string sent from the client. Workaround Description  None. Have to revert back to ASE 12.5.0.1

CR:345045

CR Number:   345045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Fixed Description On the Mac OS X platform the ServerDiscovery tool has been enhanced to display Replication Server.

CR:345056

CR Number:   345056 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Feb 2004 Fixed Description The StartTime and EndTime columns in monSysStatement have a resolution of a second. This is not acceptable for measuring statement statistics so the resolution should be at least that of the DATETIME datatype.

CR:345067

CR Number:   345067 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Fixed Description Job Scheduler agent process does not properly shutdown if its Job Scheduler ASE shutdowns while the agent is still processing a startup request. This has been corrected.

CR:345175

CR Number:   345175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 16 Feb 2004 Fixed 08 Apr 2004 Fixed Description Multi-engine ASE does not always wake a comatosed engine in a timely manner when there is work ready for that engine.

CR:345193

CR Number:   345193 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) 20 Feb 2004 Fixed 10 Nov 2005 Fixed Description The ASE server 1601, "There are not enough 'user connect ions' available", followed by the connectivity errors 11216 and 11206 will be raised, if trying to access an MDA table from within a user's login script.

CR:345260

CR Number:   345260 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed Description ASE running on Windows platforms may suffer loss of the listener process, without any stack trace or error message.

CR:345272

CR Number:   345272 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.8 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Apr 2004 Fixed 23 Aug 2004 Fixed Description In rare circumstances, a 1511 error (state 8), followed by a 4313 error may be reported when loading a transaction log which contains a CREATE INDEX on a large table. Workaround Description  None.

CR:345293

CR Number:   345293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2004 Fixed 20 Apr 2004 Fixed Description Performance improvement in opening java.net connections

CR:345314

CR Number:   345314 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2004 Bundled Request Description Incorporate SSL 3.1.5 with SB/GSE (FIPS-140-2 approved crypto module) into ASE. This ASE should be used with OCS release containing the same SSL and SB libraries.

CR:345316

CR Number:   345316 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2004 Fixed Description Error message 8211 will be enhanced to report object name and object id as well. The new message will read: "Mismatch found between the name and id descriptor hash table for table '<tablename>', objid = <objid>. Descriptor hashed by name = <address> and hashed by id = <address>."

CR:345353

CR Number:   345353 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2011 Presently Not Targeted For Any Future Release Of This Product 29 Apr 2011 Fixed 31 May 2011 Added to user documentation 28 Jul 2011 Presently Not Targeted For Any Future Release Of This Product Description Add more stored procedure details on MDA tables

CR:345389

CR Number:   345389 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) 10 Feb 2004 Fixed 09 Feb 2004 Presently Not Targeted For Any Future Release Of This Product Description On 64-bit IBM systems, a 12545 error, "Database '<db>' is now online with a lower server version number..." may be incorrectly reported when upgrading a database to a 12.5.1 release. Workaround Description  N/A

CR:345479

CR Number:   345479 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2004 Fixed 31 Mar 2004 One-off Provided Description An 8211 error: "Mismatch found between the name and id descriptor hash table. Descriptor hashed by name = 0x0 and hashed by id = <value>" may be reported while executing a Dynamic SQL lightweight procedure when the dynamic sql changes the user id on the fly.

CR:345546

CR Number:   345546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2004 Fixed Description Inserts into partitioned data-only locked tables with placement index may cause wasted space, the space waste being more pronounced for tables with higher number of partitions, and also for larger page sizes.

CR:345730

CR Number:   345730 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2004 Not a Bug Description When a job / scheduled is created the stattime value defaults to 'now'. This means that repeating jobs only run from starttime to midnight. Workaround Description  Clear the starttime value in repeating jobs/scehdules that need to run 24hours a day.

CR:345731

CR Number:   345731 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2004 Fixed Description When a stored procedure is created with an underscore in the name and a parameter type of unichar or univarchar, sp_sproc_columns doesn't return any data type information, NULL is returned.

CR:345793

CR Number:   345793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2004 Fixed Description When a remote user is ampped to a different user using 'sp_addremotelogin' and RPC auditing is enabled, the server incorrectly stored the external user name in the audit trail instead of the actual usre name. The suid is stored, and this suid does not match the loginname.

CR:345802

CR Number:   345802 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2004 Fixed 20 Feb 2004 Fixed 23 Feb 2004 Fixed Description Support for administering and configuring Web Services has been added to the ASE Plugin.

CR:345865

CR Number:   345865 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) 03 Jun 2004 Fixed Description Improve compilation time and optimize internal stack usage when compiling complex SQL queries with a huge number of IN() elements.

CR:345874

CR Number:   345874 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2009 Insufficient priority to fix Description Feature Request to treat utf8 parameter data received in TDS_PARAM in Unicode so that it can be inserted cleanly into unichar/univarchar columns. Workaround Description  Set charset to iso_1 instead of utf8 in the jConnect client.

CR:345877

CR Number:   345877 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) 09 Jul 2004 Fixed Description A 3429 error may be reported by boot time recovery while trying to access the commit service to determine the status of a two-phase transaction involving a replicated table.

CR:345879

CR Number:   345879 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) 11 Feb 2004 Bundled Request Description The text of the 1105 error message has been has been modified to "Can't allocate space for object '<obj>' in database '<db>' because '<seg>' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment."

CR:345943

CR Number:   345943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2004 Fixed Description After unmirroring the master device keeping the secondary side, dumps of the master database fail with an attempt to access the original master device. Workaround Description  Reboot ASE (this refreshes the Resource datastructure).

CR:345983

CR Number:   345983 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed Description An unexpected out of log error may be raised while executing the LOAD TRAN command and during the redo phase of an index creation for a Data Only Locked table.

CR:346066

CR Number:   346066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Fixed Description The error 2601, 'Attempt to insert duplicate key' or 1205, '...encountered a deadlock situation. ...' can be raised when the stored procedure sp_addlogin is executed concurrently from different sessions.

CR:346081

CR Number:   346081 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) 03 Feb 2005 Fixed 12 Jul 2005 Fixed 12 Jul 2005 Fixed Description In rare circumstances, the message "current process infected with 11" in the module stat_check_sampling_perct may be reported in the errorlog for queries requiring sort executed in parallel.

CR:346083

CR Number:   346083 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) 12.5 10 Feb 2004 Workaround Description Allow users access to the number of shared memory dumped for a given condition that have already occurred. Workaround Description  Two workarounds: [1] dbcc traceon(3604) sp_shmdumpconfig debug [2] using sybmon attach to running server dumpconditions <= will display ndumps value.

CR:346141

CR Number:   346141 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Feb 2004 Duplicate Description The routine for checking sampling option on update stastitics generates signal 11.

CR:346146

CR Number:   346146 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) 02 Mar 2004 Fixed Description When using a 16K server, after a long running transaction has reached the last chance threshold and got aborted due to a log full condition, it may fail to rollback successfully raising a fatal 3475 error.

CR:346163

CR Number:   346163 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed Description When preparing to upgrade an installation, if the preupgrade utility encounters an offline database, it will report that the offline database does not have enough space to run upgrade. This is not true: the database has not actually been checked because it is offline.

CR:346210

CR Number:   346210 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2004 Fixed Description CIS: creation of proxy table mapping to remote table or RPC using CREATE EXISTING TABLE command may not work within a procedure or batch. With this fix, CREATE EXISTING TABLE ... EXTERNAL TABLE/PROCEDURE/FILE and CREATE TABLE ... EXTERNAL TABLE/FILE commands are now able to work in a procedure and batch.

CR:346231

CR Number:   346231 Product Name:   Adaptive Server Enterprise Product Component:   coverletter Status:   Closed OS:   SunOS Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2005 Fixed Description A filelist has been added to the image at $IMAGE_ROOT/manifest.txt listing all the files that will be installed by this EBF. Workaround Description  *** Thursday, February 12, 2004 7:14:08 AM *** cooperg *** N/A

CR:346240

CR Number:   346240 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2005 Bundled Request Description ASE 12.5.1 Sybase Central version 4.1.1.1403: User information is being written to the DOS Console including ID and PSWD, when doing Monitor reporting. This needs to be changed Workaround Description  NONE

CR:346252

CR Number:   346252 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2004 Fixed Description Wash size under Cache is not changeable in Sybase Central; the OK Button is disabled until a value is entered in the Amount Pool field. Workaround Description  None

CR:346285

CR Number:   346285 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2004 Fixed Description Spinlock was obtained by calling a function which is very expensive for no contention calls. Also on Intel processors with Hyperthreading support, busy loop in spinlock code was not having pause instruction.

CR:346292

CR Number:   346292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2006 Insufficient info provided Description In rare circumstances, the message "Logical Process Manager Error: Failed to delete row from sysattributes table related to a task level specification" will appear in the ASE error log upon the termination of a process whose priority has been set via the sp_setpsexe stored procedure. This message may be safely ignored. Workaround Description  Either don't use sp_setpsexec, or run sp_clearpsexe if the errors are encountered.

CR:346326

CR Number:   346326 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2010 Duplicate 10 Jun 2005 Fixed 24 May 2010 Bundled Request Description Allow spaces for destination directory names during the installation process.

CR:346360

CR Number:   346360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2004 Fixed Description A message infected with 11 in omni_adjust_eops() together with stacktrace containing the modules 'omni_code_gen_subq' and 'omni_opt_select' is sometimes printed in the errorlog when executing a complex SQL query containing a SELECT using views. The stacktrace is printed after raising message 404, 'Too many ANDs or ORs in expression (limit 1024 per expression level). Try splitting query or limiting ANDs and ORs.'

CR:346369

CR Number:   346369 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2004 Fixed Description possible crash on procedure activity view when there is no activity

CR:346373

CR Number:   346373 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) 19 Feb 2004 Fixed 22 Feb 2004 Fixed Description A combination of having a union in the derived table expression and then assigning it to a local variable is what is causing the infected with 11 in yyparse

CR:346426

CR Number:   346426 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) 09 Jun 2004 Fixed Description The $SYBASE/$SYBASE_ASE/scripts/installjconnect script has "^M" characters at the end of every lines.

CR:346582

CR Number:   346582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2005 Fixed 21 Jan 2008 Workaround Description User is receiving ASE error 7789 indicating that a complex query exceeds the internal fixed limit of 14 worktables. Customer would like this limit extended. The Hardcoded limit is located: /view/ase1251_cscope_vu/calm/svr/sql/generic/include/server.h # define MAXWORK 14 /* max active SDESes for non-RI work tables */

CR:346584

CR Number:   346584 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Insufficient priority to fix Description User has a very complex query and how it may be simplified is dependent on how much in excess of the limit the query is. User would like the 7789 error to include the exact number of worktables needed to process the query in question.

CR:346585

CR Number:   346585 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Presently Not Targeted For Any Future Release Of This Product Description Customer would like a mechanism for determining how many worktables a given query would require would be very desirable. This is not possible, at present. So that customer can predetermine how many Work Tables a Query would require.

CR:346592

CR Number:   346592 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2004 Fixed Description The ASE localization utility syconfig does not allow built-in UTF-8 non-binary sort orders to be selected.