远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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:368553
CR Number:   368553
Product Name:   Adaptive Server Enterprise
Product Component:   DBXray
Status:   Closed
OS:   Microsoft Windows
Original Version:   3.2.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2006 Fixed
Description
DBXRAY: Several counters show a 0 value when used with ASE 12.5.2



CR:368554
CR Number:   368554
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2004 Fixed
Description
Workaround Description
 N/A



CR:368607
CR Number:   368607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2005 Fixed
04 Aug 2005 Fixed
07 Aug 2005 Fixed
Description
While the ASE is booted with the compressed backup enable (traceflag 4059 on),

attempt to dump on the '/dev/null' device will be successfull.

Ideally any dump on '/dev/null' should fail.



CR:368617
CR Number:   368617
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)
13 Feb 2008 Bundled Request
01 Jul 2008 Fixed
Description
In HA setup, the update to syslogins table is not syncronized between the servers.



CR:368656
CR Number:   368656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2005 Fixed
Description
Enhance DBCC CHECKTABLE for empty ALLPAGES LOCKED, SLICED tables to report error if the root page of the index has extraneous entries pointing to deallocated pages even though the table is empty.



CR:368687
CR Number:   368687
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2004 Fixed
Description
Context menus appear with right click of data tab.



CR:368688
CR Number:   368688
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2004 Fixed
Description
ASE Plug-in shows status of logins as locked in the login list view, even when they are unlocked. The propery sheet of a login shows status as unlocked even when login is locked.



CR:368712
CR Number:   368712
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2004 Fixed
08 Oct 2004 Bundled Request
Description
If recovery attempts to recreate a user tempdb when the Model database

has not been recovered, then when recovery bypasses that step with message 12544,

"Not recovering temporary database ... ", it will print a unpredictable database ID

instead of the database ID of the user tempdb whose recreation is to be bypassed.



CR:368782
CR Number:   368782
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2004 Fixed
Description
Update English ASE Plugin help for 1253



CR:368804
CR Number:   368804
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)
19 Mar 2005 Insufficient priority to fix
Description
dbcc command to view actual alarms in the server



CR:368810
CR Number:   368810
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2008 Fixed
07 Nov 2008 Fixed
Description
The migration tool can report the wrong database size when used to calculate estimated space.
Workaround Description
 The sybmigrate space_est report, lists the pages required per database table. Add up these values, multiply by the new page size, then divide to get the minimum number of Mbytes required. Add extra

space as needed for growth.



CR:368845
CR Number:   368845
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2004 Fixed
Description
Not customer visible



CR:368943
CR Number:   368943
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)
19 Nov 2004 Fixed
Description
SELECT POWER(0,0) returns 'Domain error' in Adaptive Server Enterprise.



CR:368999
CR Number:   368999
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2004 Fixed
07 Feb 2005 Fixed
Description
CIS: select aggregate from a view with CASE will cause signal 11.



CR:369052
CR Number:   369052
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2004 Fixed
Description
In cases where adjacent shared memory segments may not have ascending addresses, the message "process infected with 11" in the module 'buf__unhash_and_keep_grabbed_mass' may be reported on a server that uses a lot of memory (more than 1GB) some time after the creation (and possible destruction) of a buffer pool. In 12.5.1 and above, boot time recovery may automatically create (and later destroy) such a buffer pool. This completes the fix to CR 351965.
Workaround Description
 Boot the server with -T3474 to disable buffer pool tuning during recovery.

Avoid creating or increasing the size of a pool at run-time using a source pool of a lesser

size (for example, avoid creating a 16K pool using buffers from the 2K pool). Modify

these pools either by editing the configuration file, or by rebooting ASE immediately after

the sp_poolconfig has been run.



CR:369088
CR Number:   369088
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2005 Fixed
07 Jul 2005 Fixed
03 Sep 2005 Fixed
Description
Referential integrity and encryption may not apply to the

same column.



CR:369099
CR Number:   369099
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   macosx
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2004 Fixed
20 Mar 2009 Insufficient priority to fix
Description
ASE supports dynamic configuration of various settings. Some of this may require ASE to allocate additonal shared memory. If so, the configuration would fail with a BUS error (signal 10). This problem has been fixed.
Workaround Description
 configure ASE with 'allocate shared memory'.



CR:369121
CR Number:   369121
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)
05 Nov 2004 Fixed
Description
When some serious error is encountered by the server during recompilation of

the stored procedure the session may be killed with the stack trace and error 216:

"Attempt to automatically drop temporary table failed." This error is spurious

and no temporary object will remain in the temporaray database. This problem may

happen only if a stored procedure creates non temporary table.



CR:369201
CR Number:   369201
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2005 Fixed
07 Nov 2005 Bundled Request
Description
In rare circumstances, 3223 and 3208 error is returned when ASE reads the dump header

for cross-platform database load, if the database has many disk fragments in Sysusages.

The message "current process infected with 11" in the module 'lddb__stat_translate'

together with a stack trace which includes the modules 'lddb__unscr_stat_page'

may be reported in the error log, when loading a database across platform,

if the database has an orphan row in Sysstatistics.



CR:369217
CR Number:   369217
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2005 Fixed
Description
sp_sysmon may show us wrong "Total Cache Turnover" if sort order is case insensitive, such as nocase_iso_1.
Workaround Description
 Calculate "Total Cache Turnover" - SUM("Pages Used" of all Pools of Large I/O Detail) manually



CR:369222
CR Number:   369222
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)
17 Jan 2005 Fixed
17 Jan 2005 Fixed
23 Jun 2005 Fixed
Description
Feature request to have alphabatical sort ability on indexes/tables in cache Component



CR:369253
CR Number:   369253
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)
19 May 2005 Fixed
26 May 2005 Fixed
Description
Improve ASE's network infrastructure to prevent an inability to connect to ASE resulting from a hung engine.



CR:369254
CR Number:   369254
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)
27 Nov 2004 Fixed
Description
Enable message "secleanup: time to live expired" to be configurable for sybmon dump.



CR:369269
CR Number:   369269
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2004 Fixed
19 Oct 2004 Fixed
Description
The message 'Current process (<value>) infected with 11' may be hit in

the module 'proc_invalidate_plans' with a stack trace in the error log

when the value of the configuration parameter 'max parallel degree'

or 'max scan parallel degree' is reset to its default value of 1.

This will result in an implicit shut down of ASE. The modules

'cfg_notify_max_plldeg' or 'cfg_notify_max_scanplldeg' will also

be reported.
Workaround Description
 Avoid changing 'max parallel degree' or 'max scan parallel degree' on the fly.



CR:369368
CR Number:   369368
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2004 Fixed
16 Nov 2004 Bundled Request
11 Nov 2004 Fixed
15 Dec 2004 One-off Provided
Description
ASE encounters a timeslice error in function kscloseall



CR:369417
CR Number:   369417
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2006 Fixed
Description
1> In stored procedure 'modifylogin' , a new value 'kerberos' for option 'authenticate with',

is added. A user can specify authentication mechanism as 'kerberos' as follows,

sp_modifylogin 'user1', 'authenticate with','KERBEROS'

2> a user can get authenticated against specified mechanism, even if configuration options 'use security services','unified login required' are set to 1.
Workaround Description
 *** Friday, October 15, 2004 2:46:01 PM *** cooperg ***

N/A



CR:369457
CR Number:   369457
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2005 Fixed
Description
CIS: Executing sp_addlogin command may result in Msg 102 error when a user-defined role

with password has been activated.
Workaround Description
 Created a new row without a password ( eg ha_tester)

grant role J_Role to ha_tester (role J_Role has the password)

grant role ha_tester to username

and then tried adding a new login. ! Works



CR:369469
CR Number:   369469
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)
29 Oct 2004 Fixed
Description
When INSERT or DELETE privileges are granted to PUBLIC, it is not possible

to GRANT the same privilege WITH GRANT OPTION to an individual user.
Workaround Description
 add the user to public group then grant permission and then remove this user from public OR grant all to user first & then grant all to public.



CR:369473
CR Number:   369473
Product Name:   Adaptive Server Generic Docs
Product Component:   What's New in Adaptive Server?
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2004 Fixed
Description
Currently it says "The length of a unchar/univarchar column is limited by the size of a data page in Adaptive Server, just as in char/varchar columns"



It should be "The length of a unichar/univarchar ....."



CR:369493
CR Number:   369493
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
09 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Message 2843, "The dynamic statement '*<name>' could not be found. This may be due to insufficient

metadata descriptors for the number of tables and procedures in use by Adaptive Server. Configure

the serverwide 'number of open objects' parameter to accommodate more objects." is raised when

a procedure is executed using a name like "*<name>".
Workaround Description
 n/a



CR:369510
CR Number:   369510
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   Digital UNIX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2005 Fixed
23 Feb 2005 Fixed
29 Apr 2005 One-off Provided
28 Apr 2005 Fixed
Description
The backup of database dumps taken on Tru64 platform does not load on other platforms

such as Linux 32 on Intel, Solaris 32 or 64bit, etc.



As a side effect of this fix, compatibility from older dump on Tru64 is not kept. To

workaround incompatibility issue, you could use trace flag -D128 with the backupserver

binary. This way you would be able to load older dumps.



CR:369595
CR Number:   369595
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2009 Fixed
Description
Sybmigrate doesn't check server's configuration before actually start sybmigrate.



CR:369627
CR Number:   369627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2004 Fixed
Description
The stored procedure sp_logiosize may display strange characters following the database names.



CR:369675
CR Number:   369675
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2004 Fixed
Description
The error 5850 will be incorrectly raised when the configuration parameter 'enable ldap auth' is set to zero in those platforms where LDAP is not supported.



CR:369767
CR Number:   369767
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The proxy table wizard now forces you to create CIS mapping before one can select remote table, therefore no longer making it optional.



CR:369861
CR Number:   369861
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2004 Fixed
26 Oct 2004 Fixed
02 Nov 2004 Fixed
Description
Under JS Task shutdown invoked due to a normal Job Scheduler shutdown or an implicit exception request the JS Task could be caught in a SPINLOCK order violation finally resulting in a SIGBUS with a chance that ASE needs a reboot before the Job Scheduler can be started again.
Workaround Description
 There is no workaround for this bug.



CR:369933
CR Number:   369933
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)
25 Oct 2004 Presently Not Targeted For Any Future Release Of This Product
05 Nov 2004 Fixed
Description
The error "ct_fetch(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received." will be raised if updating a table with a timestamp field results in a duplicate key error.



CR:369961
CR Number:   369961
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2004 Fixed
Description
When using sqldebugger utility some warning messages and messages

sent via PRINT statement are silently ignored without printing.



CR:369966
CR Number:   369966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2004 Fixed
Description
In the case of fatal errors occuring at online time during the recovery

process, Adaptiver Server error handling may not be graceful and may fail to recover

subsequent databases.
Workaround Description
 None.



CR:369969
CR Number:   369969
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Bundled Request
Description
Not customer visible



CR:369970
CR Number:   369970
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Not customer visible



CR:369971
CR Number:   369971
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Not customer visible



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



CR:369973
CR Number:   369973
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2005 Bundled Request
Description
Not customer visible



CR:369974
CR Number:   369974
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2005 Fixed
Description
Not customer visible



CR:370015
CR Number:   370015
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2005 Fixed
Description
Memory to track a job which has a timeout value remains allocated even after the job instance has completed or been terminated (without having expired its timeout value), causing memory usage to steadily grow.



CR:370028
CR Number:   370028
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2004 Fixed
05 Nov 2004 Fixed
Description
On HP Itanium 64 platform only, sp_sysmon reports that Spinlock Contention is always 100%.



CR:370033
CR Number:   370033
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2005 Fixed
23 Jun 2005 Fixed
09 Jan 2006 Fixed
Description
Enhance the buffer manager to remove certain racing conditions when recycling buffers

in the LRU/MRU chain in data caches using "strict lru" strategy.



CR:370039
CR Number:   370039
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)
04 Jan 2005 Fixed
Description
If a call to xp_cmdshell is coded within a sp_thresholdaction procedure, the parameters to xp_cmdshell will be truncated to 255 characters



CR:370055
CR Number:   370055
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2004 Fixed
Description
The message "current process infected with 11" in the module 'ex_doprint' together with a stack trace which includes the modules 'lddb_chkrolename' will be reported when loading a database that has a user or group that matches an existing role name.



CR:370067
CR Number:   370067
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
Customer wants built-in function to calculate entire row length



CR:370073
CR Number:   370073
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)
19 Jun 2005 Fixed
Description
CIS: Query hangs or runs poorly with join against proxy table column. Costing for certain

join order might have been underestimated.
Workaround Description
 Do not run update statistics on the proxy table

Use "set forceplan on" to force the join order using the order in

"from" clause, or force the index



CR:370092
CR Number:   370092
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
07 Dec 2004 Fixed
10 Feb 2005 Fixed
10 Feb 2005 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstances a deserialized Object attempts to validate on an incomplete read. In this case the read may be retried with an expectation of success so a retry mechanism was incorporated in the deserialization mechanism.



CR:370120
CR Number:   370120
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 Intl
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2004 Fixed
Description
Simplified dynamic memory tracking and management for Job Scheduler Agent.



CR:370170
CR Number:   370170
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)
09 Nov 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Feature request to support MOUNT DATABASE command on HA systems



CR:370233
CR Number:   370233
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2004 Fixed
16 Nov 2004 Fixed
23 Jun 2005 Fixed
Description
ASE 12.5.2 ESD#2 reports "kernel hbc_ninit: No sockets available for HBC" on boot because of

the bug fix 354768. This is an informational message only and can be safely ignored if EJB

is not configured. ASE 12.5.3 alters this behavior so that this message appears only when

"enable enterprise java beans" parameter is set to 1 in the config file.
Workaround Description
 This error is not displayed if ASE is started with traceflag 1642

However this takes the bahavior of ASE back to pre 12.5.2 ESD#2 release



CR:370295
CR Number:   370295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2005 Fixed
Description
CIS: SELECT COUNT(*) FROM an EXTERNAL FILE without any search arguments gives timeslice errors for large files.
Workaround Description
 Increasing the cpu grace time can help but needs to be increased in proportion to the size of

the external file.



Putting a search argument on the select statement avoids the problem completly but does give a

performance hit as it must be evaluated for each row.



CR:370329
CR Number:   370329
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2004 Fixed
02 Nov 2004 Fixed
Description
This fix affects the Scheduled Job wizard in the ASE Plugin. The plugin will no longer display a NullPointerException when an invalid Schedule name is entered while creating a Scheduled Job; now the user will get an error saying the name is invalid.



Also, this fix prevents the creation of a Scheduled Job when a duplicate Job name is provided in the first page of the wizard. Previously, it may have looked like the user created a new Job and a new Scheduled Job when what actually happened is that a new Scheduled Job was created using an existing Job. To create a Scheduled Job using an existing Job, the user should use the Job Scheduler wizard.



CR:370364
CR Number:   370364
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2004 Fixed
16 Nov 2004 Fixed
20 Oct 2005 Fixed
09 Jan 2006 Fixed
23 May 2006 Fixed
Description
Make SQLDBGR to be JDBC3.0 compliant.



CR:370369
CR Number:   370369
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2005 Fixed
Description
A CREATE TABLE statement using a constant MS in the DEFAULT clause for a column succeeds without

raising the expected message "Msg. 128, The name 'MS' is illegal in this context. Only constants,

constant expressions, or variables allowed here. Column names are illegal.".
Workaround Description
 Default for c1 column requires quotes around the value.



CR:370427
CR Number:   370427
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2004 Fixed
03 Nov 2004 Fixed
02 Nov 2004 Fixed
Description
The Job Scheduler Task from ASE 12.5.2 could freeze ASE under Job Scheduler Agent exceptional behavior.



CR:370520
CR Number:   370520
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)
06 Feb 2006 Fixed
Description
The functionality implemented under CR 316222 and extended under CR 400907

to improve the performance of DROP TABLE in temporary databases was active

by trace flag 3706 at boot time or via DBCC TRACEON(3706). This enhancement

now become the default ASE behaviour. Consequently by default ASE will release

during the drop of user tables in tempdb the system catalog locks when not

in DDL-IN-TRAN mode after the commit of the transaction but before post commit

work started. The trace flag 3706 is therefore obsoleted. Should there be a need

to turn off this enhancement then trace flag 3708 can be used.



CR:370530
CR Number:   370530
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
Description
Renormalization of stored procedures may consume too much stack space

leading to stack overflow errors. Module name qremap__tree is printed

in the errorlog.

The problem is generic but is likely to happen more frequently on linux platform.



CR:370533
CR Number:   370533
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)
23 Nov 2004 Fixed
07 Feb 2005 Fixed
Description
A 12301 error, "Internal error: the index (id = <indid>) and the data for row (<pageid>, <rnum>) in table '<tablename>', database <dbid> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported while running a lot of concurrent DMLs on a Data Only Locked table having one or more indices.



CR:370633
CR Number:   370633
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2006 Fixed
16 Jan 2006 Fixed
15 May 2006 Fixed
Description
Wrong page errors might occur while accessing tables after a server crash

mid-way through an ALTER TABLE UNPARTITION operation. These errors can also

occur while accessing tables after loading a transaction dump containing

uncommited changes for an UNPARTITION operation to such tables.

(Fixes issues raised in 400988.)



CR:370711
CR Number:   370711
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2004 Fixed
Description
Query with a builtin function which takes as the argument user name may fail to

return correct result if the statement cache option is turned on and the parameter

passed to to the builtin is host variable.



CR:370760
CR Number:   370760
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2004 Fixed
11 Nov 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Select into or Insert select with text/image columns and order by may stacktrace, if the source table is a proxy_table and remote server is a direct_connect.



CR:370870
CR Number:   370870
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)
17 Nov 2005 Fixed
Description
The message "current process infected with 11" in the module 'kbfalloc' may be reported in the error log when using network packet size greater than the configured value of "default network packet size".



CR:370932
CR Number:   370932
Product Name:   Adaptive Server Enterprise
Product Component:   Component Drop
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Fixed
12.5.3 24 Nov 2004 Bundled Request
Description
The following cp1252 sort order files are missing from $SYBASE/charsets/cp1252 directory:

dictionary.srt, espdict.srt, espnoac.srt, espnocs.srt, nocase.srt, noaccents.srt and nocasepref.srt.



CR:370957
CR Number:   370957
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2006 Fixed
14 Jan 2007 Reservation Made
25 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
SELECT from a proxy table which is mapped to a remote table containing unsupported datatype will give error.



CR:370981
CR Number:   370981
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Open
OS:   NA
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A feature request to be able to specify in the sp_audit procedure to allow an 'all' option for objects and users. eg "sp_audit 'all','all','all" and then remove some selected options from specific users.
Workaround Description
 Some instances of this problem can be solved by generating a script that does an object-level sp_audit for every applicable object in the database.



For instance, to turn off SELECT auditing for all tables in a database:



select 'execute sp_audit "select", "all", "'

+ name + '", "off" '

from sysobjects

where audflags & 48 > 0

go



CR:371136
CR Number:   371136
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2004 Fixed
Description
DBCC CHECKTABLE may fail to report error 2510: "Key mismatch between index page <index pno>, at offset <indoffset> and data page <data pno> (row ID <rnum>) in database '<dbname>'. Drop and re-create index id <indid> of table '<tabname>'" and abort silently.



CR:371154
CR Number:   371154
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2004 Fixed
Description
Error message number 216 : "Attempt to automatically drop temporary table failed." and

the stack trace may be written to the errorlog when the server encounters an error during

the recompilation of the stored procedure using cursor on the temporary table.



CR:371162
CR Number:   371162
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Advantage
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2005 Fixed
11 Jan 2005 Fixed
Description
SQL Advantage 12.5.1 has significant performance degradation versus 11.5
Workaround Description
 Use SQL Advantage 11.5.



CR:371192
CR Number:   371192
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.3.303
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3.304P1 13 Dec 2004 Fixed
4.0.0 13 Sep 2005 Fixed
Description
ASE Replicator: Replicator no longer requires a password on the process startup command line. If the "-p" option is omitted, Replicator will prompt you for the password.



CR:371223
CR Number:   371223
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)
08 May 2009 Duplicate
Description
In some cases, displaying the value of memory used is more than the memory used for

statement cache configuration expectation.



CR:371288
CR Number:   371288
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature: customer wants to be able to use sp_audit with all logins except certain logins



The way the customer describes this it would possibly take a two step process...

1. exec sp_audit to start auditing for all logins

2. exec sp_audit to exclude individual logins
Workaround Description
 laborously enter all the

sp_audit requests for each of the included logins and not do the excluded logins



CR:371302
CR Number:   371302
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
Description
A 2511 error, "Keys of index id <indid> for table '<tabname>' in data page not in correct order. Drop and re-create the index.(index page <pgid>)" may be reported by DBCC CHECKTABLE after doing an UPDATE to an ALLPAGES_LOCKED table having a clustered index with a one or more descending key columns.



CR:371310
CR Number:   371310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2005 Fixed
Description
On 64 bit platforms "sp_configure 'additional network memory' ,2147481600" silently fails.



CR:371323
CR Number:   371323
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Fixed
Description
CIS: When a proxy table is updated via ct_dynamic in a client application, error 7732

may occur indicating that the cursor is READONLY.



With this change, remote tables may need to be created with a unique index for table

scans on updatable cursor.



CR:371350
CR Number:   371350
Product Name:   Adaptive Server Enterprise
Product Component:   SQL Advantage
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2006 Insufficient priority to fix
Description
After upgrading SqlAdvantage to 12.5.1 and Open Client to 12.5.1

the grid tool does not support a char column with over 256 characters. Only a portion of the data is displayed. The issue is if you have results large then the window there is no way to scroll to see that data off the Window.
Workaround Description
 If you double click on a large grid view column this will bring up a

new scrollable window that can be used to show all the data.



CR:371388
CR Number:   371388
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Requested higher audit granularity to allow any reasonable combination



CR:371454
CR Number:   371454
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2004 Fixed
08 Nov 2004 Fixed
Description
When ASE is configured for High Availability with HACMP5.1 Cluster,
failover fails with the error "SYBASE HA MONITOR: ***ERROR: Dbcc takeover may have
failed. Please check the errorlog of <secondary_companion_name> and
manually execute 'dbcc takeover' from <secondary_companion_name> if
necessary." in the hacmp.out log file.



CR:371554
CR Number:   371554
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2004 Fixed
10 Nov 2004 Fixed
23 Jun 2005 Fixed
Description
ASE message 1608 has been enhanced with a supplementary informational message including

the host and login name relating to the lost connection. for example,

"extended error information: hostname: TONYI-XP login: sa".



CR:371687
CR Number:   371687
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
Description
Error 3475 may be raised if sessions currenlty suspended on the LCT of a mixed log and data database are interrupted. DBCC checkalloc may raise multiple 12909 errors : "Table with object id=0 (name = 0) inconsistent after Large Scale Allocation. 8 pages in extent <XXX> were found reserved."
Workaround Description
 Set the "abort tran on log full" database option, so that transactions

do not get suspended on the LCT but aborted instead.



CR:371703
CR Number:   371703
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2004 Fixed
Description
If SET PROXY is executed in a batch where one of the commands fail, the

security context will be partially lost and the user will not be able

to revert its identity. The output of sp_who will show that both the

original name and the current name are set to the faked user's name.



CR:371715
CR Number:   371715
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2006 Fixed
Description
Improve the performance of object statistics collection when 'per object statistics' and 'object lockwait timing' are enabled.
Workaround Description
 Set 'per object statistics enabled' configuration parameter to 0. This is done with sp_configure 'per object statistics enabled', 0.



CR:371757
CR Number:   371757
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.3 ESD#2 04 Feb 2005 Fixed
Description
At times, the Job scheduler may not calculate time intervals correctly, if the job is scheduled to run past midnight.



The next callout calculations were not correctly handling cases where the schedule starttime was after the schedule endtime, that is a schedule that wraps over midnight. The net effect of this error was that the schedule was being offset from the starttime when it passed midnight. The current fix handles this case correctly so schedules are rolled over midnight properly. The fix in effect recognizes that midnight, which is stored as a 0 in a CS_DATETIME, effectively needs to be viewed as the largest allowable value when approached clockwise during an operational schedule rather than as a 0.



In addition to the direct fix there are a couple side effects to this fix that users may see:



1) End times are now enforced correctly. This means that when a recurrence interval falls on the end time the job will not run. The current situation is that a job can actually run past the endtime because the next callout calculation was allowing the next callout time to be outside the endtime boundary so the job would be run past the endtime and then the following callout time would move up to the next starttime. This was clearly incorrect and has been fixed, however this represents a change in current behavior.



2) Schedules where starttime equals endtime, either as default values or explicitly set are treated correctly. That is the schedule will run in continuous intervals without interruption unless constraints (day of week/date of month) are set.



CR:371818
CR Number:   371818
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2007 EOL'd version. Not to be Fixed.
13 Dec 2007 Fixed
04 Jan 2008 Fixed
29 Oct 2007 Reservation Made
Description
Sometimes the internal Adaptive Server clock might differ from Operating System clock (as returned by GETDATE()). A new built in function called GET_INTERNAL_DATE() has been introduced to return the Adaptive Server internal clock value. The internal clock value is used for assigning dates to internal objects and only ever increments to ensure that time moves in one direction only. Over time, the internal clock synchronizes closely with the OS clock. Discrepancies between the clocks tend to arise when the OS time is abruptly changed or if being used, when daylight saving transitions happen.



The internal date is used for things such as the crdate field in sysobjects and sysindexes, the loggedindatetime in syslogins, WAITFOR commands, and the datetime stamps in begin tran and commit tran log records.



CR:371839
CR Number:   371839
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2006 Fixed
Description
Need to document bitmask values assigned to systhresholds.currauth



IN ASE 12.5.1 Doc "Reference Manual Tables"

This is the current description for the currauth column:



A bit mask that indicates which roles were active for suid at the time

the threshold was added or most recently modified. When the threshold

is crossed, proc_name executes with this set of roles, less any that

have been deactivated since the threshold was added or last modified.



Determining which roles were active based on the systhresholds.currauth

is not clear. Customer requests a documented explanation in the ASE user

reference manual for the bitmask values assigned to systhresholds.currauth.



CR:371861
CR Number:   371861
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)
28 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Provide option to write messages on client end when using login triggers



CR:371907
CR Number:   371907
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
14 Dec 2004 Presently Not Targeted For Any Future Release Of This Product
07 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Quickly repeated requests to abort or stop and then restart the Job Scheduler task

leads to a variety of problems related to communication between the ASE Job Scheduler task

and its agent. Symptoms include a Job Scheduler hang (no response), ct lib connection

failures (as noted in the Job Scheduler agent log file), the Job Scheduler task error

'spurious states from jsagent', and log messages indicating a failure to receive a

communication buffer from either the Job Scheduler task or agent.



CR:371913
CR Number:   371913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2004 Fixed
11 Nov 2004 Fixed
17 Nov 2004 Fixed
Description
In some circumstances, a 695 error, "An attempt was made to read logical page '<pageno>' for object '<objid>' in database '<dbid>' from disk. Wrong logical page '<pageno>' was brought into cache '<cachename>'" or other 69x error may be reported in the error log some time after using sp_poolconfig to increase the size of a memory pool in a data cache that is using the relaxed LRU cache replacement policy.
Workaround Description
 Avoid running sp_poolconfig. To modify pool sizes, shutdown ASE, modify the configuration

file to adjust the pool sizes and then restart. Alternatively, do not use a "relaxed LRU"

strategy for any caches.



CR:371920
CR Number:   371920
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2004 Fixed
24 Nov 2004 Fixed
Description
Sybase Central ASE Plug-in generates a DDLBaseException stacktrace with the following error code,

when trying to generate the DDL on a Unique Constraint object:

"DGP1 The Object type is invalid null.".
Workaround Description
 This works fine when choosing 'table' -> 'generate table objects'.



CR:371921
CR Number:   371921
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A feature request to report committed transactions within a specificed time frame



CR:371993
CR Number:   371993
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)
07 Jan 2005 Fixed
Description
In some rare cases, ALTER TABLE on a DOL table may corrupt the clustered index so that entries for some rows are missing, resulting in a lower rowcount. DBCC checktable will report a 7928 error.



CR:372034
CR Number:   372034
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2006 Fixed
14 Jun 2007 Fixed
Description
Migration fails during setup when source server has a password and target does not



CR:372062
CR Number:   372062
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to switch On/off numeric logins



CR:372191
CR Number:   372191
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)
29 Nov 2004 Fixed
Description
Add diagnostics to capture CSMD for sddone "not within virtual disk range" errors



CR:372200
CR Number:   372200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Customer issue is that with increasing DB auditing needs, the ability to audit user activity at either the group level or user-defined role level would greatly simplify administering Sybase's Auditing features.



Add Option Types of: group, role



Examples:

sp_audit @option="group", @login_name="all", @group_name="mygroup", @object_name="all", @setting="on"

Turn on auditing for all users in all databases that are in group "mygroup"



sp_audit @option="role", @login_name="all", @role_name="myrole", @object_name="all", @setting="on"

Turn on auditing for all users in all databases that have the role "myrole" active.



These are suggestions not necessarily how to implement the feature.
Workaround Description
 *** Monday, November 15, 2004 10:06:03 AM *** cooperg ***

N/A





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复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
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------