提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 联系我们获取数据库技术支持!
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:311797
CR Number:   311797
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)
25 Mar 2003 Fixed
Description
There were no means of specifying user/owner of the SQLJ Function from the list of

available users for the database. This is now fixed.



CR:311824
CR Number:   311824
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)
13 Mar 2003 Fixed
3/21/03 16 Mar 2003 Fixed
Description
When using install script 'syscadm' to create ASE resouce group and
related resources on Sun Cluster3.0, the script fails if global device paths
or device group names are specified for SUNW.HAStorage/SUNW.HAStoragePlus
resource properties. Also, the script fails if multiple resource group names
are specified as a comma separated list, to the -r and -u options.
Workaround Description
 Workaround:

To comment out the below check on script:



> > if [[ -n $global_device_paths &&

> > ! -d $global_device_paths ]]; then

> >

> > print "Error!!

> > GlobalDevicePaths$pri_sec=$global_device_paths doe



CR:311830
CR Number:   311830
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)
20 Mar 2003 Fixed
Description
Login bindings for all logins are now possible for the multiple tempdb feature.

Previously these were restricted to the 'sa' only. This restriction has

been removed. Login bindings take priority over application bindings.

(Login, Application) pair bindings are still not supported.



CR:311877
CR Number:   311877
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)
16 Jul 2003 Fixed
15 Jul 2003 Fixed
Description
An XAER_RMERR may be reported by 'xa_commit' when committing an external XA transaction and the Adaptive Server configuration parameter "lock scheme" is not set to "allpages". This is applicable only when native XA DTM services are not being used. In order to get the benefit of this fix, the 'sybsystemdb.dbo.spt_committab' table must be dropped before running the 'installcommit' script (the 'instcomm' script on NT). This should only be done when the table has no rows in it.
Workaround Description
 Drop and re-create sybsystemdb..spt_committab with LOCK ALLPAGES.



CR:311901
CR Number:   311901
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)
22 May 2003 Fixed
04 Jun 2003 Fixed
05 Jun 2003 Fixed
Description
Negative values for "empty page count" may appear in the output of optdiag.



CR:311983
CR Number:   311983
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)
01 Apr 2003 Fixed
02 Apr 2003 Fixed
Description
isql 12.5 hangs if the length of character/binary column is greater than 255 byte in one side of UNION ALL and less than or equal to 255 byte in another side of UNION ALL.
Workaround Description
 Use sql advantage 12.5/12.0 or isql 12.0/11.1.1



CR:312072
CR Number:   312072
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)
16 Apr 2003 Fixed
17 Apr 2003 Fixed
Description
A 156 error, "Incorrect syntax near the keyword 'end'." while creating a procedure or trigger could

be raised because of an empty BEGIN/END block in the SQL being used. This error is raised correctly but the procedure/trigger text is saved in syscomments anyway.



CR:312194
CR Number:   312194
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)
25 Apr 2003 Fixed
Description
On NT only, booting with -M flag overrides %SYBASE% setting/



CR:312212
CR Number:   312212
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Fixed
Description
Error 11054, "The table '<table name>' is an inner member of an outer-join clause. This is not

allowed if the table also participates in a regular join clause." can be raised when executing a

SELECT INTO. The message is correct but temporary tables created during that session are orphaned.



CR:312304
CR Number:   312304
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2003 Presently Not Targeted For Any Future Release Of This Product
23 Jun 2003 Fixed
Description
The message "current process infected with 10" in the module 'getnext' may be reported in the error log for case statement involving text conversion as one of its case elements when trace flag 289 is enabled.
Workaround Description
 Fall back to 12.0.x or earlier.



CR:312310
CR Number:   312310
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   SunOS
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2004 Fixed
Description
sybmigrate throws "java.lang.NoClassDefFoundError" exception in "sybase/scf/resources/sc/SCResourceConstants" class when parsing incorrect server entry format in the interfaces file.
Target Version
 12.5.1
Review Status
 Targeted for 12.5.1
Workaround Description
 Look for invalid server entry in the interfaces file. In this specific case the wrong entry was :





SIDTEST2_1200

master tli tcp 158.159.50.164 4280

query tli tcp 158.159.50.164 4280





tli entries should have the address and port



CR:312344
CR Number:   312344
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)
13 Mar 2003 Duplicate
Description
When creating a stored procedure from within a db-lib or ct-lib application the last command in the procedure may be excluded from syscomments under some circumstances.
Workaround Description
 Add a newline or space to the end of all procedure definitions before send them to the ASE



CR:312382
CR Number:   312382
Product Name:   Adaptive Server Generic Docs
Product Component:   New Functionality in ASE 12.5.x
Status:   Closed
OS:   all
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2003 Fixed
Description
add information on how to setup MDA tables in a cluster environment



CR:312432
CR Number:   312432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
14 May 2003 Fixed
Description
Under rare circunstances Replication Agent can report the error 9219 followed signal 11 and stacktrace including function kbremove() when it tries to process a corrupted log record.



CR:312480
CR Number:   312480
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)
17 Mar 2003 Fixed
25 Mar 2003 Fixed
08 Feb 2005 Fixed
Description
Bad rowlengths from BCP could corrupt the target table and/or
generate errors 4837, 2624, 631. Errors 614 could follow.
This is usually caused by network/hardware/OS problems.
Workaround Description
 N/A



CR:312518
CR Number:   312518
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)
04 Apr 2003 Fixed
09 Apr 2003 Fixed
Description
A 255 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." maybe be reported when executing system stored procedures or when querying system tables.
Workaround Description
 Statistics on system tables should be dropped via DELETE STATISTICS

command and recreated if necessary. This should be done only for

those system tables that already have statistics or for tables

involved in queries that hit error 225.



CR:312541
CR Number:   312541
Product Name:   Adaptive Server Enterprise
Product Component:   dsedit - UNIX
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2003 Fixed
Description
If the interfaces file has read only permissions, dsedit will get a segmentation fault (core dump) when user clicks the OK button on the first screen.
Workaround Description
 Change permissions on the interfaces file to allow the user to access it. Permissions change will be needed in order for DSEDIT to modify the file.



CR:312570
CR Number:   312570
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)
23 Jan 2004 Not a Bug
Description
sysprocesses clientname column stores spaces instead of NULL even when it is set to NULL
Target Version
 12.5.2
Review Status
 Targeted for 12.5.2



CR:312690
CR Number:   312690
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Extraction Utility
Status:   Closed
OS:   Linux
Original Version:   7.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.4 3432 18 Mar 2003 Fixed
8.0.1 3107 18 Mar 2003 Fixed
8.0.2 4230 18 Mar 2003 Fixed
8.0.3 4614 18 Mar 2003 Fixed
Description
If a view, trigger or stored procedure was created on an ASE 12 (or greater) database that contained a "*" as a column list in a select statement, it was possible for ssxtract to either crash or generate a reload.sql file with syntax errors when extracting that object. This is now fixed.



CR:312703
CR Number:   312703
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)
18 Mar 2003 Fixed
12.5.1 17 Mar 2003 Fixed
Galaxy 17 Mar 2003 Fixed
Description
Using JDBC/Jconnect, queries against the Full-Text Search SDS (FTS) fail with the message "syntax error, near TOKEN [.]". The same failure occurs when using isql, if the user has set quoted_identifier on.
Workaround Description
 Issue set quoted_identifier off prior to executing a query against an FTS index.



CR:312714
CR Number:   312714
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   NA
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 15 Apr 2003 Fixed
12.5.0.3 12 Sep 2003 Fixed
Description
EFTS: Error(): Available files (-1) less than min 5 in the txtsvr log. txtsvr process has reached process File Descriptor limit.



CR:312813
CR Number:   312813
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)
09 Jan 2004 Fixed
27 Jan 2004 One-off Provided
20 Feb 2004 Fixed
Description
Enable shared memory dump on DBCC error messages.



CR:313072
CR Number:   313072
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 19 Mar 2003 Fixed
Description
The three files, make.unix, gen_export.sh and examples.imp are missing under

$SYBASE/$SYBASE_ASE/sample/esp/ on ibmaix64 platform.



CR:313075
CR Number:   313075
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)
31 Mar 2003 Fixed
Description
sp_dbcc_faultreport supports a new parameter, @hard_only that can be 0 or 1.

1 indicates report only hard faults. 0 is the default and reports everything as currently.



CR:313088
CR Number:   313088
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)
Not To Be Released 23 Jun 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Feature Request: enhance errorlog reporting to include: Checked out license as in 12.5
Target Version
 Not To Be Released
Review Status
 This will not be back ported to 12.0



CR:313131
CR Number:   313131
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)
01 Apr 2003 Fixed
05 Nov 2003 Presently Not Targeted For Any Future Release Of This Product
Description
On a multi-engine HP-UX 64-bit system, the message "current process infected with 11"

together with a stack trace which includes the modules 'keipanic' and 'ueshutdown' may

be reported in the error log when 'shutdown" or 'shutdown with nowait' is executed

on an Adapative Server that has started XP server.
Workaround Description
 None.



CR:313141
CR Number:   313141
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2003 Fixed
04 Nov 2005 Not a Bug
Description
The segment size is now corrected for server which is not 2K.



The device tab of segment properties is now showing the size of device that is used by segment, not total device size. The device size can be found in database device properties which can be interlink from the device tab of segment properties.
Workaround Description
 Use sp_helpdb or sp_helpdevice



CR:313152
CR Number:   313152
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2004 Insufficient priority to fix
Description
XPserver: Request for the option to set default character set with a command line option.
Target Version
 Galaxy
Review Status
 Targeted for a future release.
Workaround Description
 Set environment variable LC_ALL to force OpenClient/Server default.



CR:313219
CR Number:   313219
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2003 Fixed
08 Sep 2003 Not a Bug
Description
In rare circumstances, the message "current process infected with 11" may

be reported in the error log when accessing a proxy table on another server.



CR:313231
CR Number:   313231
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2003 Fixed
08 Apr 2003 Fixed
Description
DDLGen does not generate definitions for Procedure Groups in an ASE whose version is less than 12.5.0.1.



CR:313273
CR Number:   313273
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)
23 Apr 2003 Fixed
25 May 2003 Fixed
02 Jun 2003 Fixed
Description
CIS : In a HA environment, the ASTC coordinator connecting to a companion server as 'probe' login may result in repeated connection failure and error "Msg 4073 : HA login failed. Server not in primary configuration" message



CR:313284
CR Number:   313284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2003 Fixed
29 Apr 2003 Fixed
20 May 2003 Bundled Request
Description
sp_object_stats does not report activity on objects in tempdb.



CR:313290
CR Number:   313290
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Fixed
23 Jun 2003 Fixed
22 Sep 2004 Fixed
23 Sep 2004 One-off Provided
Description
BCP operation may fail with 4837 (bad row length) or other random error when the real cause is a read failure from the network.



CR:313300
CR Number:   313300
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server Troubleshooting Guide
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2004 Fixed
Description
The writeup for error 1108 in the troubleshooting guide states that the error is only raised by the diagserver. This is incorrect.
Review Status
 Under review



CR:313324
CR Number:   313324
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 Jun 2003 Presently Not Targeted For Any Future Release Of This Product
24 Mar 2003 Fixed
24 Mar 2003 Fixed
08 Jul 2003 Fixed
Description
In rare circumstances, a 2628 or 2583 error may be reported after restarting Adaptive Server following a SHUTDOWN WITH NOWAIT which was performed whilst a transaction that had allocated pages was being rolled back.



CR:313417
CR Number:   313417
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)
26 Mar 2003 Fixed
Description
str_replace() function does not allow specifying a null replacement string.



CR:313431
CR Number:   313431
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)
16 Apr 2003 Fixed
04 Apr 2003 Fixed
23 Dec 2003 Fixed
Description
Inrarecircumstances,themessage"currentprocessinfectedwith10"maybereportedintheerrorlogtogetherwithastacktracewhichincludesthemodule'run'whenprocessinga querythatusesanAVGaggregate on 64 bit ASE.



CR:313444
CR Number:   313444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Error 702 with a stacktrace occurs if parallel degree greater that one and there is

convertion of a char(>15) column to text value.
Target Version
 To Be Determined
Review Status
 Under review



CR:313459
CR Number:   313459
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2009 Fixed
Description
sp_servertype stored procedure is obsolete and has been removed.
Target Version
 To Be Determined
Review Status
 Under review
Workaround Description
 (1) Revoke execute from sp_servertype to stop it from being executed.

(2) Drop sp_servertype if OmniConnect is not in use.

(3) Change stored procedure text so as to check for the sso_role, such as:

if (proc_role("sso_role") = 0)

return (1)



CR:313499
CR Number:   313499
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2003 Fixed
28 Apr 2003 Fixed
Description
DDLGen gives error for a table, whose inline default/check constraint spans multiple rows

in the syscomments.



CR:313580
CR Number:   313580
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)
26 Mar 2003 Fixed
02 Apr 2003 Fixed
Description
UPPER() and LOWER() functions return wrong results for Roman numeral characters in SJIS and EUCJIS

character sets.



CR:313630
CR Number:   313630
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2010 EOL'd version. Not to be Fixed.
22 Oct 2010 Duplicate
Description
Feature request for a command or utility that can extract the segment layout for a database from the dump of a database, so that in cases where the layout of a dump isn't known, the database can be created correctly before loading the database.
Target Version
 Galaxy
Review Status
 Targeted for a future release



CR:313646
CR Number:   313646
Product Name:   System Admin Guide
Product Component:   System Administration Guide
Status:   Closed
OS:   NA
Original Version:   5.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.0 30 Apr 2003 Fixed
Description
Customer is requesting that we add more of a description of the parameters in the Database Types Properties Files.



CR:313706
CR Number:   313706
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2013 Consult Complete
Description
Feature request for an option to raise an error and prevent LOAD DATABASE from loading a database that would result in segment remapping (which might result in mixed data and log segments on a device) unless a "with override" clause were provided..
Target Version
 Galaxy
Review Status
 Targeted for a later release.



CR:313710
CR Number:   313710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2003 Fixed
Description
When using sp_dropsegment or sp_extendsegment to drop or modify a database segment, if the user is not in the database supplied as a parameter to the procedure then the procedure will mistakenly say that the user may not 'add' a segment in that database.



CR:313720
CR Number:   313720
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)
28 Mar 2003 Fixed
Description
Without this fix, TEXT/IMAGE column datatype was always showed as JAVA OBJECT type

at meta data in internal JDBC driver.



With this fix, TEXT/IMAGE column datatype is showed as TEXT/IMAGE type at

meta data in internal JDBC driver.



CR:313734
CR Number:   313734
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2003 Fixed
Description
Internal Development: Sanitized Desc. not required.



CR:313744
CR Number:   313744
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)
12 Apr 2003 Fixed
24 Jun 2003 Fixed
Description
Under very rare circumstances, an HA failover session may fail raising errors 6502 and 941.
Workaround Description
 Change your PHYSICAL PATH name.



CR:313760
CR Number:   313760
Product Name:   Adaptive Server Enterprise
Product Component:   Language Modules
Status:   Closed
OS:   macosx
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2003 Fixed
Description
This does not affect English version of the ASE release.



CR:313764
CR Number:   313764
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2003 Fixed
Description
sqldbgr raises a signal 11 on ps_dl_ncmp against a noaccent ASE sort order



CR:313804
CR Number:   313804
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2003 Fixed
25 Apr 2003 Fixed
07 Apr 2004 Fixed
Description
ASE skips polling unused network types leading to too few CPU yields. This problem also causes the sp_sysmon 'number of CPU yields' to be incorrect.
Workaround Description
 There is no way to control this poll ratio for the user side. However, if the customer

believes they are really being hurt by this problem, the may be able to decrease the io

process polling count to check the network more often.



CR:313807
CR Number:   313807
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2003 Bundled Request
Description
The sp_sysmon stored procedure inaccurately reports the number of CPU Yields in the Kernel Utilization section. Users should refer to "blocking network checks" instead. This affects ASE 12.5 on the Solaris and Linux platforms.
Target Version
 12.5.1
Review Status
 Fixed in 12.5.1
Workaround Description
 Ignore CPU Yields by engine. Look at blocking network checks instead.



CR:313809
CR Number:   313809
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2003 Fixed
06 Jun 2003 Fixed
Description
Cross-database SELECT INTO using a view may report incorrect user types in syscolumns.



CR:313838
CR Number:   313838
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2003 Fixed
19 Feb 2004 Not a Bug
Description
On 32 bit systems, sp_configure "total memory" incorrectly accepts values that are larger than what the underlying 32 bit system platform can support.



CR:313869
CR Number:   313869
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)
29 Apr 2003 Fixed
09 Jun 2003 Fixed
Description
A 706 error, "Process ... tried to remove PROC_HDR ... that it does not hold in Pss." maybe reported in the errrorlog with a stacktrace which includes the modules 'free_netdiagbuf' and 'rm_prochdr' when running a stored procedure that contains DBCC TRACEON(3604) or DBCC TRACEOFF(3604) commmands.



CR:313955
CR Number:   313955
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2003 Fixed
Description
Fixed a bug in the Java subsystem where the server allocates java memory under a spinlock. The bug might show up as time slice errors on other tasks in a pre ASE 12.5.1 server.



CR:314030
CR Number:   314030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2003 Fixed
23 May 2003 Fixed
Description
Under rare circumstances, when a SELECT max(<colname>) type query is run on a data-only locked table, with a backward scan chosen, and there are other sessions doing a lot of INSERTs to the table in parallel, the query might fail with a signal 11 in module bt__lfrow_cmp(). The stack trace will include routines bt__nextpg_chase() and bt__row_and_rid_compare().



CR:314049
CR Number:   314049
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)
07 Apr 2003 Fixed
08 Apr 2003 Fixed
08 Apr 2003 Fixed
Description
In rare circumstances, a protocol error may be incorrectly reported by an XA TM when a thread attaches to a transaction that has a branch in an Adaptive Server database at exactly the same time as another thread detaches from the same transaction.
Workaround Description
 None.



CR:314059
CR Number:   314059
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2003 Fixed
25 Jan 2006 Fixed
Description
Add useful information on running processes to the Sybase Central ASE Plug-in Processes folder.



CR:314155
CR Number:   314155
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)
19 May 2003 Fixed
04 Apr 2003 Fixed
04 Apr 2003 Fixed
Description
Queries with GROUP BY and ORDER BY clause with DESC order may not return rows in requested order. This happens only if backward scans are enabled.
Workaround Description
 Disable option "allow backward scans".



CR:314222
CR Number:   314222
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)
01 Jul 2003 Fixed
08 Aug 2003 Fixed
Description
On IBM AIX and HP-UX platforms, the ASE-imposed limit of 2000 on the maximum available file descriptors has been removed. This will enable more than 2000 user connections per engine, unless limited by other factors such as memory or the OS limit on file descriptors. This change makes obsolete the use of traceflag -T1627 on the HP platform.



CR:314306
CR Number:   314306
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)
25 Apr 2003 Fixed
Description
Without this fix, "getString" on Java object column will have error raised.

With this fix, the string representation of the object will returned without error.



CR:314332
CR Number:   314332
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2003 Not a Bug
Description
Error 1605



CR:314435
CR Number:   314435
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
09 Feb 2004 Fixed
Description
The 3475 message, "There is no space available in SYSLOGS for process <spid> to log a record for which space has been reserved...", may be incorrectly reported when the failure to log a record is due to a reason other than a lack of space in SYSLOGS.
Workaround Description
 N/A



CR:314463
CR Number:   314463
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0.0.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2006 Fixed
Description
In rare circumstances error 5854 "Configuration Error: Cannot write

out file '<file name>' due to system error '<system error message>'"

could be unable to report correctly the file name of the configuration

file specifying the message "Invalid pointer param number 2, pointer

value 0x00000000" instead of the default configuration file name.



CR:314468
CR Number:   314468
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2003 Fixed
Description
When the diagserver is run and implicit cursors are used in a client application, the following errors can be generated if all of the qualifying rows of the cursor can be returned in the CURSOR OPEN command (i.e. a subsequent CURSOR FETCH command will find no more rows):
Open Client Message:
Message number: LAYER = (4) ORIGIN = (2) SEVERITY = (6) NUMBER = (36)
internal Client Library error: There is a tds state machine error.
illegal tds token sequence was received.
This error can only happen with the diagserver, not the dataserver.



CR:314474
CR Number:   314474
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)
01 Apr 2003 Fixed
01 Apr 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CR 260642 was reported as resolved in 12.5.0.3 IR. However, the fix for the stored procedure, sp_dbcc_faultreport, was not included in the release.



CR:314497
CR Number:   314497
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)
10 May 2003 Fixed
Description
If a login trigger is created using 'quoted identifier', error 105 "Unclosed quote before the character string 's_proc'." may be reported at login time



CR:314512
CR Number:   314512
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)
24 Jun 2003 Fixed
12 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CIS: A subset of inserted rows will remain after a 1204 error, "SQL Server has run out of LOCKS...", is reported during the execution of an INSERT <proxy_table> SELECT FROM <local_table>.



CR:314528
CR Number:   314528
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2004 Duplicate
Description
The request is to have status messages be written to errorlog during rollback of large transaction, similar to status messages from recovery process.



CR:314697
CR Number:   314697
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have a way to register a procedure in a database so that it will automatically be run (triggered) every time the database goes through recovery.



CR:314713
CR Number:   314713
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ratio is caused by a high value in "Data page CR count"

We can check the value in column "dpagecrcnt" from table "systabstats". This value is used to calculate the data page cluster ratio.



Solaris% isql -Usa -P -Drepro

1> select dpagecrcnt from systabstats where id = object_id("client_search_100_v2_t")

2> go

dpagecrcnt

----------------

311.000000



(1 row affected)

1>





Also we can see it in the "optdiag" output:





Table name: "client_search_100_v2_t"



Statistics for index: "idx" (clustered)

Index column list: "search_key"

Data page count: 444

Empty data page count: 0

Data row count: 10001.0000000000000000

Forwarded row count: 0.0000000000000000

Deleted row count: 0.0000000000000000

Data page CR count: 311.0000000000000000 <<<<< high value

OAM + allocation page count: 4

First extent leaf pages: 0

Data row size: 0.0000000000000000

Index height: 2



Derived statistics:

Data page cluster ratio: 0.3427835051546392 <<<< poor clustering

Space utilization: 0.0000000000000000

Large I/O efficiency: 1.0000000000000000

==================================================================================

To Reproduce this issue



// creates the table

isql -Usa -P -Drepro -itable.sql



// populates the table

bcp repro..client_search_100_v2_t in x.dat -fimport.fmt -Usa -P



// create the index with the sorted_data option

isql -Usa -P -Drepro -i idx_datasorted.sql -o idx_datasorted.out



// gather statistics

optdiag statistics repro..client_search_100_v2_t -o idx_datasorted.sts -Usa -P



CR:314717
CR Number:   314717
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2003 Fixed
Description
Add columns to the ASE Plugin Locks folder to make the contents useful for troubleshooting blocking processes and locks.



CR:314806
CR Number:   314806
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2003 Fixed
Description
HS crashes during a recording session, with the "Fatal server error: 16151/20/0: Thread '7' has

overflowed or corrupted its stack -- aborting" message in its log



CR:314833
CR Number:   314833
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)
07 Apr 2003 Fixed
17 Apr 2003 Fixed
Description
With this fix, FUNCTION is no longer an ASE reserved word. It can be used as object names.



CR:314862
CR Number:   314862
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2003 Fixed
Description
Internal Development: Sanitized Desc. not required.



CR:314887
CR Number:   314887
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2003 Fixed
30 May 2003 Fixed
Description
During the recovery phase of the LOAD TRAN command an "infected with 11" error

may be hit resulting in the session being terminated. The stack trace in the error

log will report modules 'th_fill_freespaceinfo', 'th__oam_extent_count' and

'pg_oam_extent_count'.
Workaround Description
 Turning on "no free space acctg" through sp_dboption,

and allow this dump tran to be loaded with success.



CR:314897
CR Number:   314897
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)
18 Dec 2003 Fixed
Description
If the reconfiguration of a data cache fails due to 'total logical memory'

exceeding 'max memory', a descriptive error 10879 is printed instead of

the earlier error 5861.



CR:314938
CR Number:   314938
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2004 Fixed
16 Mar 2004 Fixed
20 Jul 2004 Fixed
Description
CIS : Error message 207 "Invalid Column name xxxx" may result when select queries are executed

on a proxy table if the proxy_table's column/s have been renamed using sp_rename.
Workaround Description
 Use create existing table instead of create proxy_table



CR:314946
CR Number:   314946
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Fixed
Description
When conversion errors occur during implicit conversions from unichar to char data types, error 2402 was not being raised.



CR:314951
CR Number:   314951
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2003 Bundled Request
Description
CIS : In a HA environment, proxy database creation fails to import users whose name in the database is different from their server loginame.



CR:314992
CR Number:   314992
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)
07 Apr 2003 Fixed
Description
Support for SQLX standards in ASE 12.5.1 XML engine.



CR:315018
CR Number:   315018
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2003 Fixed
Description
Doc Bug. On TSQL (ASE12.5 ) page 14, it should be:

"You cannot use the modulo operator on smallmoney, money, float,numeric or

real columns."



CR:315026
CR Number:   315026
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2003 Bundled Request
Description
The error 7602, "There is no such audit option", will be raised by the procedure sp_audit

when trying to set up ha_role auditing.



CR:315035
CR Number:   315035
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2004 Fixed
28 Mar 2005 Fixed
Description
Add update statistics feature. User can display/update/delete statistics for tables/columns/indexes.



CR:315040
CR Number:   315040
Product Name:   Adaptive Server Enterprise
Product Component:   diagserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2003 Fixed
Description
dbcc checkdb(<dbid>) when run on a database during failover

may result in Error: 12324, Severity: 21, State 1.



CR:315057
CR Number:   315057
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0.0.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2004 Fixed
Description
References to database names, server names, and replication agent names

in localized (non-English) error messages may be incorrect on 64-bit platforms.
Workaround Description
 Clients should use language "us_english".



CR:315072
CR Number:   315072
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)
07 May 2003 Fixed
06 May 2003 Fixed
13 Jun 2003 Fixed
Description
A 1265 error may be raised following error 540 if the SQL batch being executed contained a DELETE prior to the current statement.
Workaround Description
 Stop other activity on table when reorg rebuild or update statistics is run.



CR:315098
CR Number:   315098
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)
19 May 2003 Fixed
05 Jun 2003 Fixed
Description
A 266 error, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is

missing." will occur when executing a stored procedure in CHAINED transaction mode that contains RETURN <value> statement.



CR:315116
CR Number:   315116
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Fixed
14 Apr 2003 Fixed
Description
With the HA agent scripts provided with ASE 12.5.0.3 ESD#1 for SunCluster3.0, creation of the ASE resource (of type SY.ase) fails.
Workaround Description
 For creation of ASE resource and setup, one should use scripts provided with ASE 12.5.0.3.

This regression is introduced in ASE12.5.0.3 ESD#1

Note that this regression effects only setup time(creation of ASE resource), not any other

operational functio



CR:315182
CR Number:   315182
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)
17 Apr 2003 Fixed
06 May 2003 Fixed
Description
The source text of compiled objects such as views, stored procedures, etc which is stored in the system table syscomments when they are created, may contain rows with less that 255 characters of text when those objects contain statements using "SELECT * FROM ...".



CR:315237
CR Number:   315237
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)
27 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
21 Nov 2003 Fixed
06 Jan 2004 Fixed
Description
The execution of DBCC CHECKTABLE on a Data Only Locked table having fixed length rows may continue to report the message, "The total number of pages which could be garbage collected to free up some space is <number>", even after having run on the given table the REORG RECLAIM_SPACE or REORG COMPACT commands.



CR:315292
CR Number:   315292
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)
17 Apr 2003 Fixed
Description
If the stored procedure, sp_procxmode, is executed without a value for the parameter @tranmode (i.e. sp_procxmode proc1) and then executed again with a value for @tranmode (i.e. sp_procxmode proc1, "chained"), the following error message is generated:

Msg 7981, Level 16, State 1:
Procedure 'sp_procxmode', Line 93:
The new transaction mode must be unchained, chained or anymode.



CR:315335
CR Number:   315335
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Fixed
Description
Create a db through Sybase Central Java version, the size of database field got reset to 0 when go over 9999MB.



CR:315370
CR Number:   315370
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   3.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2007 Insufficient priority to fix
Description
DBXray: DBXray gets "SQLException: JZ0I5: An unrecognized CHARSET property was specified" when connecting to ASE using the roman8 default character set.
Workaround Description
 Avoid using default charset of roman8?



CR:315403
CR Number:   315403
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When Changing ParaWhen Changing Params Via Server Config that require server shutdown(changing Character sets), server config stops the NT service, but then starts up ASE Via RUN_file. The Service indicates that the ASE is not up, but in fact it is Running.



CR:315512
CR Number:   315512
Product Name:   ASE Replicator
Product Component:   Installation
Status:   Closed
OS:   Generic
Original Version:   12.5.0.109P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Request for ASE Replicator to be available on Compaq/HP Tru64 Unix



CR:315516
CR Number:   315516
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)
26 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
18 May 2004 Fixed
Description
In a Warm Standby replication environment, replication of a system stored procedure fails when

issued via execute immediate or from within another user stored procedure.
Workaround Description
 Don't execute system stored procedures that change data and need tobe replictaed

via execute immediate.



CR:315557
CR Number:   315557
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)
11 Apr 2003 Fixed
16 Apr 2003 Fixed
23 Apr 2003 Fixed
23 Apr 2003 Fixed
Description
sp_dbcc_evaluatedb can underestimate the size of the text scan workspace if a database contains a TEXT column. This fix is made available in a new version of sp_dbcc_evaluatedb by the re-execution of the installdbccdb script.



CR:315661
CR Number:   315661
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 2004 Fixed
Description
The server incorrectly sends TDS_DONE instead of TDS_DONEINPROC

packets when the SQL statements are executed using EXECUTE IMMEDIATE

inside a stored procedure.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集,包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


-------------------------------------------------------------------------------------------

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


-------------------------------------------------------------------------------------------

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------