提供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:477542
CR Number:   477542
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2007 Fixed
Description
After upgrading, extended stored procedures get error 7218
Workaround Description
 Drop and recreate the stored procedures



CR:477544
CR Number:   477544
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
enhance ASE to have seperate permissions/roles for dumping and seperate permissions/roles for loading a db
Workaround Description
 1) create role dump_only_role with passwd "load_prevented"

2) grant role oper_role to dump_only_role

3) grant role dump_only_role to appuserid

4) create stored procedure

create procedure sproc_dump_only

As

begin

set role dump_only_role with passwd "load_prevented_pwd" on

dump dbname1 ...

set role dump_only_role with passwd "load_prevented_pwd" off

end

5) sp_hidetext sproc_dump_only



CR:477555
CR Number:   477555
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for Solaris
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2008 Fixed
Description
Release Builletin ASE15.0.1 for Sun of Japanese.The Japanese manual mistranslates the patch name of Solaris. 8_recommended is a patch name.



CR:477603
CR Number:   477603
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   SunOS
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like ASE to support the XML/WSDL syntax generated by IIS for Web Services.



The following XML request that was generated by Microsoft IIS will not work with our product:



<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://localhost/testservices" xmlns:types="http://localhost/testservices/encodedTypes" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<tns:Echo1 />

</soap:Body>

</soap:Envelope>



Customer would like all MS IIS generated requests to be supported.



CR:477624
CR Number:   477624
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2007 Fixed
Description
Drop function doesn't restraint the user from dropping a function already in use by computed columns.



CR:477671
CR Number:   477671
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2007 Consult Complete
17 Sep 2007 Fixed
Description
On a multi-engine system, sometimes failover operation may get timed out while using ASE-HA on Sun Cluster.
Workaround Description
 configure number of engines to one.



CR:477712
CR Number:   477712
Product Name:   Adaptive Server Generic Docs
Product Component:   EFTS SDS and SFTS SDS
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2009 Added to user documentation
Description
Verity has a limitation of 16million documents per collection



CR:477715
CR Number:   477715
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
Description
Backup server fails to load compressed dumps using named pipe.



CR:477780
CR Number:   477780
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2010 Fixed
Description
logon audit success/failure config option prints the connectivity version along with other useful information about a login connection.



CR:477961
CR Number:   477961
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2007 Added to user documentation
Description
There are some documentation errors regarding "number of open objects" and "number of open partitions"

in page 177 through 179 of ASE 15.0 System Administration Guide Volume 1'.



CR:477962
CR Number:   477962
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Open
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A translation error about "number of open partitions" was found in page 177 of ASE 15.0 System Administration Guide Volume 1 Japanese.



CR:477985
CR Number:   477985
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
16 Sep 2008 Fixed
22 Sep 2008 Fixed
Description
When replicating DML on encrypted columns, the Replication Agent thread might terminate abnormally with error 9219 state 28 ("Internal coding error") or with a stack trace showing the module "ra__equal_images" in the error log.



CR:477999
CR Number:   477999
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
In certain circumstances a query which assigns a value to a variable while using the same variable in the statements where clause, fails to assign correctly if the target table in the query is a proxy table.
Workaround Description
 The work around is to use different variables,



CR:478026
CR Number:   478026
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow images greater than 16KB to be inserted through insert command through ctlib applications.



CR:478030
CR Number:   478030
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2007 Fixed
Description
Under certain conditions, complex queries based on tables with multiple non-clustered indexes can stack trace.
Workaround Description
 The client can workaround this problem by dropping indexes to reduce the overall number of indexes considered, or by specifying an index in the query.



select distinct 'N', 'N', ccal.costCentreCode, 0.00

from tIssuer issr,

tAssetCode asco,

tAsset asst,

tCostCentreAllocation ccal,

tMovement mvmt (index NX_MVMT_selDepotRealignment),

rikcostCentre CC

where issr.issuerType = 'DVLP'

and issr.issuerCurrencyCode = 'EUR'

and issr.issuerCode = asst.issuerCode

and asst.systemDefaultAssetCodeType != 'CU'

and asst.assetId = asco.assetId

and asco.assetCodeType = mvmt.assetCodeType

and asco.assetCode = mvmt.assetCode

and mvmt.transactionId = ccal.transactionId

and mvmt.movementStatus = 'P'

and mvmt.quantity != 0.00

and mvmt.branchCode in (select branchCode from rikbranches)

and ccal.costCentreCode = CC.costCentreCode



CR:478145
CR Number:   478145
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2007 Fixed
Description
Add new columns to syssrvroles catalog for role lock accounting during upgrade and delete them during downgrade.



CR:478165
CR Number:   478165
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Open
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Historical Server does not support CS_LONGCHAR data and will exit

with the following error if ASE sends it LONGCHAR data:

DO NOT SUPPORT CS_LONGCHAR_TYPE
Workaround Description
 Before starting the Historical Server, force it to use

a character set that does not require multiple bytes such

as iso_1 by setting the LC_ALL environment variable:

setenv LC_ALL C



CR:478167
CR Number:   478167
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2007 Fixed
Description
When using sp_password on ASE 15.0.2, it fails with error 3906 if the user's database is read-only. The password change is trying to update the key copy.



CR:478171
CR Number:   478171
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.4 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2009 Insufficient priority to fix
12 Oct 2008 Fixed
08 Jan 2009 Fixed
16 Oct 2008 Fixed
Description
The BatchID column value in the monSysStatement and monSysPlanText MDA tables may be different for statements executed within a single batch for statements using execute immediate or deferred compilation. The monSysStatement and monSysPlanText ContextID value is not set consistently.



CR:478234
CR Number:   478234
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2007 Fixed
21 Sep 2007 Fixed
Description
Error 247 is at times raised incorrectly when using a built-in that requires implicit conversion as a SARG in a union statement.
Workaround Description
 workaround is to use trace flag 15352



CR:478284
CR Number:   478284
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2007 Fixed
Description
Stored procedures queries using runtime compilation ignore abstract plan directives.



CR:478337
CR Number:   478337
Product Name:   Adaptive Server Generic Docs
Product Component:   What's New in Adaptive Server?
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2008 Added to user documentation
Description
The Whats New in 15.0 Guide incorrectly states that a new parititonid field has been added to sp_lock output.



CR:478339
CR Number:   478339
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2007 Fixed
06 Sep 2007 Fixed
Description
Client ssl connections fail to connect to the ASE. The following error is displayed

in the ASE log file:

SSL or Crypto Error Message: 'Error reading the private key. The specified buffer

content is not in the expected format.'.



CR:478425
CR Number:   478425
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2007 Fixed
19 Sep 2007 Fixed
Description
ASE expands a '*' element in a SELECT target list and adds comment to syscomments

system table before saving the SQL text of the procedure, view or trigger to syscomments.

End comment mark (*/) may not be added to syscomments on non-English environment.



CR:478478
CR Number:   478478
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2007 Fixed
16 Oct 2007 Reservation Made
Description
Add support in Cluster's environments, to configure the instance where ASE Replication Agent can be started.



CR:478481
CR Number:   478481
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2009 Fixed
Description
Full support of DBCC LOGTRANSFER commands in cluster environments.
Workaround Description
 No workaround.



CR:478482
CR Number:   478482
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Deferred
Description
request feature which limits tempdb usage by any particular query plan.



CR:478520
CR Number:   478520
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2007 Fixed
Description
In an HA with proxydb configuration, alter table fails attempting to remove encryption from a column.



CR:478530
CR Number:   478530
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2007 Fixed
Description
A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.", is raised when selecting from a simple view in a read-only database.



CR:478577
CR Number:   478577
Product Name:   Sybase ETL
Product Component:   GUI
Status:   Open
OS:   Windows 2003
Original Version:   4.2 EBF #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Failed
Description
Problem: Certain characters can not be used in the project/job name in the Runtime Manager. These characters will generate error messages:

"blank", ":", "/", "\".



Resolution: Change the value you entered in box "name" of the "windows schedule" section. Replace characters like ":","/" with "_" or remove the blank in the name value.



CR:478613
CR Number:   478613
Product Name:   Sybase ETL
Product Component:   Licensing
Status:   Closed
OS:   all
Original Version:   4.2 EBF #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2007 Fixed
Description
Problem: Unable to connect to ASA v10.00 repository.



Resolution: ETL license files were updated to support 'SQL Anywhere', version '10.00.0000'.



CR:478645
CR Number:   478645
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2007 Added to user documentation
Description
remove reference to reserved_pgs from sp_thresholdaction example and replace it with reserved_pages



CR:478663
CR Number:   478663
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
Description
Possible wrong result for aggregate outerjoin query under allrows_dss mode

and the aggregate is on some column from outerjoin inner table and there

is also an equijoin predicate between that column and some column from

outerjoin outer table. This is related to eager aggregate feature.



CR:478687
CR Number:   478687
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2007 Fixed
Description
Within a SQL UDF, calling an Execute immediate command that runs a select into local variables, will raise a syntax error : execute is not allowed within scalare SQL UDF.



CR:478800
CR Number:   478800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2007 Fixed
Description
The error message 14810 will be reported when using the logical tables within a trigger with the FOR XML clause.
Workaround Description
 *** Monday, August 27, 2007 3:15:44 PM *** cooperg ***

Use a copy table to hold the data. I.e.



#!/bin/sh

#

isql -Sase1502_32 -Usa -P <<EOF00 > SimpleTriggerTest.log

drop trigger gac_trigger1

go



drop table gac_table1

go



create table gac_table1(c1 int, c2 char(30))

go



create table copy_gac_table1(c1 int, c2 char(30))

go



create trigger gac_trigger1

on gac_table1

for insert

as

begin

declare

@msgtext java.lang.String

delete copy_gac_table1

insert copy_gac_table1 select * from inserted



set @msgtext = convert (java.lang.String,(select * from copy_gac_table1 for xml))

end

go



insert into gac_table1(c1, c2) values(1, 'Text data here')

go



select * from gac_table1

go



quit

EOF00

#

vi SimpleTriggerTest.log

#



CR:478828
CR Number:   478828
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2007 Fixed
Description
Execution of sp_config_rep_agent may display different information depending on the node from which the stored procedure is executed.



CR:478838
CR Number:   478838
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2007 Fixed
27 Sep 2007 Fixed
27 Nov 2007 One-off Provided
25 Feb 2008 Fixed
Description
Interrupting a query that contains a group by operator and doing a cursor fetch, causes stack overflow and corruption. This also brings down the server.



CR:478872
CR Number:   478872
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2007 Fixed
Description
Under rare circumstances involving multi_db transactions,an explicit rollback tran or any circumstance that may cause the transaction to abort may fail with Error: 623, Severity: 21, State: 1 "Adaptive Server failed to retrieve a row via its RID in database <dbname> because the target page is not a data page. Rid pageid = 0x0; row num = 0x0. Page pointer = <addr>, pageno = 0, status = 0x300, ptnid = 99, indexid = 0, level = 0."
Workaround Description
 Use command line trace flag 12301 to disable tempdb ULC.



CR:478880
CR Number:   478880
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2007 Added to user documentation
Description
Update documentation to reflect password expiration interval expires on the hour

it was set for the given number of days.



CR:478913
CR Number:   478913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2007 Fixed
20 Sep 2007 Fixed
Description
Parallel queries will be using about 2K less procedure cache during parallel execution, regardless of the degree of parallelism of the query.



CR:478928
CR Number:   478928
Product Name:   Adaptive Server Enterprise
Product Component:   auditinit
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2008 Fixed
Description
Auditinit may incorrectly claim that there is not enough free space on the specified device(s).



CR:478951
CR Number:   478951
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2007 Fixed
Description
When a cached statement or a stored procedure tries to access an old

table that has been renamed, it runs with the old plan that references the old

object name.
Workaround Description
 After exec sp_rename, exec dbcc purgesqlcache() with the ssql_id of that particular statement to remove the statement and plan from the cache.



CR:478959
CR Number:   478959
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2007 Fixed
03 Oct 2007 Fixed
28 Sep 2007 Fixed
Description
After changing ASE server character set to utf-8, it'll cause segmentation fault if MDA "SQL batch capture" is enabled in AIX platform.
Workaround Description
 If the stacktrace contains copy_sqltext set "SQL batch capture" = 0, if it contains pipe_sqltext. set "sql test pipe active" off, if it contains audit_sqltext, turn off auditing of cmdtext. Alternatively, changing some memory configurations such as "number of user connection" in the ASE cfg. *may* avoid the problem due to changing the value the invalid pointer is using to enter the loop.



CR:479350
CR Number:   479350
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2007 Fixed
03 Oct 2007 Fixed
Description
When using the statement for queries with numeric literals, if two numeric values differ in precision and scale, two autoparams will be created with different names and declaration, therefore two statements and plans

will be cached. This does not make the best use of the statement cache and literal autoparameters.



CR:479378
CR Number:   479378
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2007 Fixed
15 Oct 2007 Fixed
14 Jul 2008 Fixed
16 Jul 2008 Added to user documentation
Description
To support SQLs UDFs in ASEP.



CR:479389
CR Number:   479389
Product Name:   Adaptive Server Generic Docs
Product Component:   Migration Guide
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2008 Presently Not Targeted For Any Future Release Of This Product
Description
The Migration Guide no longer contains a list of the new reserved keywords, just a pointer to the list in the What's New guide.



CR:479453
CR Number:   479453
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 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Optimize the usage of proc cache in the design of app context for 1254ESD.
Workaround Description
 There is no workaround available.



CR:479472
CR Number:   479472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2007 Fixed
Description
Cursor with query using row_count() builtin may fail producing stack traces. Errorlog

will report in the stack trace modules like LeRun,ptngetrowcount,open_nextvarno.



CR:479563
CR Number:   479563
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
Description
exec query slower in 15.0.2 than 12.5.3



CR:479565
CR Number:   479565
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Dynamic listeners stop working after engine is brought offline.



CR:479631
CR Number:   479631
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2008 Duplicate
23 Jul 2008 Fixed
03 Mar 2009 Fixed
Description
When running jobs using "Job Scheduler", any occurrence of "[gG][oO]" in the text of a job command will be considered as the batch delimiter "go" and hence, the job command will not be correctly parsed, resulting in the job failure.



CR:479710
CR Number:   479710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2007 Fixed
10 Oct 2007 Fixed
22 Oct 2007 One-off Provided
Description
Wrong result could happen when a view with string expression

in the SELECT list is referenced at another outerjoin view inner

side and the outerjoin view is later degenerated into an inner

join when being queried.



CR:479743
CR Number:   479743
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2007 Bundled Request
15 Jan 2008 Fixed
Description
If a table has more than one encrypted column with at least one column declaring a decrypt_default value, and if decrypt permission is granted at the column level to

at least one of the non-decrypt_default columns and withheld from the column with the

decrypt_default value, then any select of the column with the decrypt_default will

correctly return the decrypt default value and also return (incorrectly) Msg 10332.



CR:479763
CR Number:   479763
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2007 Fixed
Description
Messages in errorlog do not show if a login account is locked or not during downgrade.



CR:479786
CR Number:   479786
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
allow use of a wildcard character for sp_tempdb to be able to bind mulitple applications at one time:



e.g. sp_tempdb "bind", "ap", "ABC%", "DB", "tempdb" where '%' is a wildcard character



CR:479810
CR Number:   479810
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
Description
The ASEP 15.0.2 Monitor folder reports complain about the JRE folder due to wrong name.
Workaround Description
 Copy the %SYBASE%\shared\Sun\jre142_013 directory to %SYBASE%\shared\Sun\jre142\



CR:479823
CR Number:   479823
Product Name:   Adaptive Server Generic Docs
Product Component:   P&T: Basics
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2007 Added to user documentation
Description
Memory pool table in Checking I/O size for queries is incorrect



CR:479830
CR Number:   479830
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2008 Fixed
29 Apr 2008 Reservation Made
Description
xmltable() function may not work correctly if statement cache is enabled.



CR:479837
CR Number:   479837
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2008 Fixed
12 Feb 2008 Fixed
Description
In rare circumstances node join will hang while failover recovery is in progress.



CR:479866
CR Number:   479866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2007 Fixed
24 Oct 2007 Fixed
Description
15.0.2 ESD #1 Adaptive Server doesn't support LDAPS.



CR:479885
CR Number:   479885
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2007 Fixed
13 Sep 2007 Reservation Made
Description
When opening insensitive cursor having null value which is returned by convert()

to char type, error 530 will be raised.
Workaround Description
 convert to varchar type instead of char type, no error occurs :-



declare cur_test insensitive cursor for select a, convert(varchar(8), b, 112)

from test

go

open cur_test

go

fetch cur_test

go

a

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

abc NULL



(1 row affected)



CR:479889
CR Number:   479889
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2007 Added to user documentation
Description
The following description of disk init is mistakes.

The default unit of disk init is not MB.



disk init

size

...

If you do not provide a unit specifier, the value provided is presumed to be in megabytes.



CR:479948
CR Number:   479948
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2007 Fixed
Description
When we change sa password ha_companion file doesn't get updated with new

password. This resolution fixes the problem to update the password in

ha_companion.<servername> file when sa(or user in ha_companion file) password is

changed.



CR:480063
CR Number:   480063
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2007 Fixed
Description
When calling a stored procedure from an embedded SQL program, a stack trace can occur if that procedure is provided with a parameter.
Workaround Description
 The workaround is to set traceflag -T7730



CR:480070
CR Number:   480070
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2007 Fixed
02 Oct 2007 Reservation Made
08 Oct 2007 One-off Provided
Description
Warning message 307, "Index <index_name> specified as optimizer hint in the FROM clause of table <table_name> does not exist. Optimizer will choose another index instead." is disabled under Trace Flag 15381.



CR:480111
CR Number:   480111
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Fixed
17 Sep 2007 Fixed
Description
When a sql.ini file contained "win3_master" service entry in the beginning, ASE Plug-in's Connect dialog (and other dialogs showing interfaces entries) would not show any servers. This has been fixed. Note that "win3_master" and "win3_query" are ignored by ASE Plug-in.



CR:480118
CR Number:   480118
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   SunOS
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2011 Fixed
Description
sp_sjobcreate set the target server name is NULL if we don't specify the server name in the command-line



CR:480124
CR Number:   480124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2007 Duplicate
Description
The message "Current process infected with signal 11 (SIGSEGV)" in the module 'ubffree' together with a stack trace including the modules 's_result_const_memfree' and 'memfreeheap' may be reported in the error log when heap memory is prematurely deallocated after executing a statement.



CR:480142
CR Number:   480142
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2007 Fixed
03 Jan 2008 Fixed
Description
Enable ASE Messaging on Solaris x86 64 bit platform



CR:480160
CR Number:   480160
Product Name:   Sybase ETL
Product Component:   GUI
Status:   Closed
OS:   Windows 2003
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2007 Fixed
Description
Problem: ETL Development GUI is blank when connecting to a repository created using a different connection type.



Workaround: ETL currently has the restriction that you need to connect to the repository using the same connection type with which the connection was created. If it was created with ODBC, connect with ODBC. If it was created ctlib, connect with ctlib.



CR:480191
CR Number:   480191
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2007 Added to user documentation
Description
To add more information on what it means by "same version of manifest file" in ASE SAG guide.



CR:480232
CR Number:   480232
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2007 Duplicate
Description
When a procedure uses SELECT INTO to create a table that contains an identity column and then updates other columns in that table, the identity column values are incremented.



CR:480299
CR Number:   480299
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)
18 Sep 2007 Consult Complete
Description
ASE is leaking objects resulting in poor performance



CR:480329
CR Number:   480329
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2007 Fixed
Description
Previously Connect Dialog gave up reading interfaces file if the first server entry has a syntax error. Now it will try to scan more entries.



CR:480410
CR Number:   480410
Product Name:   Adaptive Server Generic Docs
Product Component:   Encrypted Columns Users Guide
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2007 Added to user documentation
Description
Need to clarify the option for "as default" as exclusive to SSO



CR:480447
CR Number:   480447
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2007 Bundled Request
Description
DBCC latch, DBCC latch("heldby", spid) or the equivalent sybmon commands fail to report latches

held if multiple caches are configured.



CR:480470
CR Number:   480470
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2007 Fixed
Description
-- Previously, DBISQL could become unresponsive immediately after loading a

.SQL file. This problem was very rare, timing-dependent, and more likely to

occur on faster machines. This has been fixed.



-- [QTS-479086 (OTW)] Previously, when importing data into an existing

table, the "Preview" table in the Import Wizard would show values

in BINARY columns as "[B@" followed by up to 8 numbers and letters.

Now, the value from the file is displayed.



-- [QTS-476693] Previously, you could not use the INPUT statement

to populate a GLOBAL TEMPORARY table that did not preserve

rows on commit. The INPUT statement had the unintentional side-

effect of commiting changes. This has been fixed; INPUT no longer

commits changes.



-- [QTS-475259] Previously, if you selected the "@@rowcount"

variable, it was always displayed "1". Now, the actual value

is displayed.



-- If DBISQL is configured to display result sets using text,

and you execute a statement which causes a JConnect "JZ0P9"

error, that error was not being reported. Now it is.



-- If DBISQL is configured to display results in grid mode,

and you execute a statement in a batch which throws an

unrecoverable error, you used to get a "JZ0CU error" message,

but the text of the underlying error was not displayed.

Now, you see the text of the underlying error, and the

"JZ0CU" text is not not displayed.



To reproduce this:

1. Connect to an ASE server using a non-DBA account

2. Execute: use sybsystemproces

2. Execute: sp_hidetext sp_jdbc_getcatalogs



You should see an error message which reads "Could not

execute statement. Object does not exist in this

database."



-- If DBISQL is configured to display results in text mode,

and you execute a statement in a batch which throws a

recoverable error, you used to get a "010P4 error" message,

but the underlying cause of the error was not displayed.

Now the cause is displayed, and you don't see the cryptic

"010P4" message.



To reproduce this, connect to an ASE server using a non-DBA

account, and execute the following as a single batch:



exec sp_helpdb

select * from sysobjects



-- Previously, if connected to a slow server, double-clicking

the database drop-down in the toolbar could crash DBISQL.

This has been fixed.



-- [DBISQL-054] Previously, when executing statements that returned

one or more large result sets, DBISQL could become unresponsive

or could exhibit undefined behavior (e.g. it could close the

database connection, or be unable to stop the statement).

This has been fixed.



-- [DBISQL-054] Previously, if you tried to stop a statement which

returned a large result set, DBISQL could enter a state where

it was unable to execute any further statements this has been fixed.



-- Previously, when executing a batch of statements, DBISQL would

ignore any results returned from statements that followed the

first statement in the batch that caused an error. This has

been fixed for both "text" and "grid" display modes.



-- Previously, when displaying results in "text" mode, it was

possible that DBISQL would not display the results at all due

to an internal race condition. This has been fixed.



-- Previously, when DBISQL executed a batch of statements, it

would not report an error raised by one of the statements if

the preceding statement raised a warning. This has been fixed.

This bug had been reported by JPMC as "dbisql-056".



-- Previously, error messages reported via jConnect did not

include the severity level, (ASE) state, or the transaction

state. Now they do. Also, if the JDBC driver state is "ZZZZZ"

(meaning "no information"), it is now not displayed at all.

This bug had been reported by JPMC as "dbisql-033".





-- OEMs can now disable the "SQL/Execute" & F5 accelerator key by

adding the following line to the ".isqlPreferences9" file:



disableExecuteAll=true



This feature was demanded by J.P. Morgan-Chase.



-- [QTS-472617 (OTW)] Previously, the ISQL window could stop painting

when executing a long-running query. This has been fixed.



CR:480530
CR Number:   480530
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2007 Fixed
Description
DBCC CHECKSTORAGE may report spurious corruptions if the scan and text

workspace are configured to the same object name value. The stored

procedure sp_dbcc_configreport allows the same object name value to

be used for both mistakenly.



CR:480541
CR Number:   480541
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2007 Fixed
11 Oct 2007 Fixed
Description
Query with nested views can run into a signal 11, especially when the innermost nested view has an expression over a grouped aggregation like isnull(sum(...),..).



CR:480561
CR Number:   480561
Product Name:   Adaptive Server Enterprise
Product Component:   sqldbgr
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The sqldbgr step command stops at nested END statements but does not display the statement or line number.



CR:480574
CR Number:   480574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2007 Fixed
20 Sep 2007 Fixed
Description
The execution of DBCC DBREPAIR with option LTMIGNORE when run on an offline database

will mistakenly result in error 12901 being reported "This command is not allowed on

an offline database '<database_name>'."



CR:480620
CR Number:   480620
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2008 Fixed
Description
Some of the information messages that the cluster interconnect puts in the error log are cryptic or misleading.



CR:480627
CR Number:   480627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2007 Fixed
Description
In an "if exists" block, if a table is referenced that does not exist, an error stating that the table is not found is raised even though the block should not have been executed.



CR:480632
CR Number:   480632
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Alter function for SQL UDFs



CR:480633
CR Number:   480633
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2007 Fixed
25 Oct 2007 Fixed
Description
Error 2610 may occur in module 'ncrid_update' resulting in the session

being killed when an UPDATE command is run in the 'deferred_varcol' update mode as shown by SET SHOWPLAN and a data page split occurs. The modules

'xact_endupdate', 'def_insert' and 'linksplit' will also be reported

in the stack trace found in the error log.
Workaround Description
 See Repro section.



CR:480644
CR Number:   480644
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2008 Fixed
19 May 2008 Reservation Made
Description
A new string comparison implementation for GBPINYIN and GBPINYINNOCS sortorders has been

incorporated into ASE to improve query performance on queries involving Simplified Chinese (GB)

characters. This essentially replaces the default string comparison processing which uses the

Unilib APIs. Streamlining the Unilib comparison removes the processing overheads hence improves

performance. The new implementation supports the existing GBPINYIN and GBPINYINNOCS sortorders

for UTF-8, CP936, GB18030 and EUCGB charsets. A boot-time Traceflag 2411 is available to revert

back to the default behaviour.



CR:480652
CR Number:   480652
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1_BetaRefresh
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2012 Fixed
Description
The paths for the cluster devices are not checked to insure they are not reused in the same input session when creating new cluster.



CR:480690
CR Number:   480690
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2007 One-off Provided
24 Dec 2007 Fixed
01 Oct 2007 Fixed
15 Oct 2007 One-off Provided
11 Oct 2007 Fixed
22 Oct 2007 One-off Provided
21 Oct 2007 One-off Provided
13 Mar 2008 Fixed
13 Mar 2008 Presently Not Targeted For Any Future Release Of This Product
Description
ASE version 12.5.4 ESD #5 and 12.5.4 ESD #6 on Solaris may show higher cpu utilization due to a high number of brk system calls.



CR:480744
CR Number:   480744
Product Name:   Sybase ETL
Product Component:   ETL Connectivity
Status:   Closed
OS:   all
Original Version:   4.2 EBF #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2007 Fixed
Description
Problem: ETL developer is unable to connect with an ASA/ASE repository with ODBC when the repository was created with Sybase Open Client(ctlib) native connectivity.



Workaround: ETL currently has the restriction that you need to connect to the repository using the same connection type with which it was created. If it was created with ODBC, connect with ODBC. If it was created with ctlib, connect with ctlib.



CR:480747
CR Number:   480747
Product Name:   Sybase ETL
Product Component:   ETL Connectivity
Status:   Open
OS:   all
Original Version:   4.2 EBF #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2008 Workaround
4.5 27 Aug 2008 Added to user documentation
Description
Problem: ETL Development is unable to connect with an ASA/ASE repository with Sybase Open Client(ctlib) native connectivity when the repository was created using ODBC.



Workaround: ETL currently has the restriction that you need to connect to the repository using the same connection type with which it was created. If it was created with ODBC, connect with ODBC. If it was created with ctlib, connect with ctlib.
Workaround Description
 1) Close the 'ODBC' repository connection

2) Choose the 'Sybase' repository connection, enter Dialog "Edit Repository Connection"

3) Click 'Test Login'

4) Login to the 'Sybase' repository connectiion.



Then you can succeed to open each project.



CR:480789
CR Number:   480789
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2007 Fixed
10 Oct 2007 Fixed
Description
DDLGen does not provide a way of hiding password when it is invoked in an automated fashion from a script file.



CR:480883
CR Number:   480883
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2007 Fixed
Description
When sp_spaceusage is used for the entity-specific help on

the 'display'/'report' action, the error message "Duplicate

position specifier in format string of PRINT command" is

raised.
Workaround Description
 In sysmessages, edit the 'description' column of the

error = 19549 row to replace the substring "1" with "3"

and "2" with "4". The T-SQL to do that would be as follows:



sp_configure 'system table', 1

go



update sysmessages

set description = str_replace(description,"1", "3")

where error = 19549

go



update sysmessages

set description = str_replace(description,"2", "4")

where error = 19549

go



sp_configure 'system table', 0

go



CR:480900
CR Number:   480900
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Job Scheduler installjsdb script fails to meet minimum password length

and fails with errors 10317 and 17720.
Workaround Description
 As long as "minimum password length" is less than the maximum

hardcoded value of 14 for the Job Scheduler, modify the following

line in the installjsdb script to meet your password requirements:

exec sp_addlogin jstask, 'jstask'



CR:480908
CR Number:   480908
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for functionality similar to a login trigger that would run when SET PROXY or SET SESSION AUTHORIZATION command is executed.



CR:480921
CR Number:   480921
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for an externalized rules engine to augment existing ASE permission functionality.



CR:480952
CR Number:   480952
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   S.U.S.E Linux
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2008 Fixed
08 Jan 2008 Fixed
18 Jan 2008 Fixed
21 Jan 2008 Fixed
16 Jun 2009 Bundled Request
Description
ASE 15.0.2 install program does not execute on Redhat Enterprise Linux 5.0 or SuSE Linux Enterprise Server 10 on IBM POWER platform.
Workaround Description
 On Linux SUSE 10, set environment variable "JAVA_COMPILER" to "NONE" before running the installer.



CR:481037
CR Number:   481037
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)
17 Oct 2007 Fixed
17 Oct 2007 Bundled Request
16 Oct 2007 Fixed
Description
12909, 7949 and 7940 errors may be reported by DBCC TABLEALLOC after Adaptive

Server terminated abnormally or DUMP DATABASE was done at a time when a

(fast) bcp command was being used to import data into that table.



CR:481048
CR Number:   481048
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2008 Fixed
Description
Error number 660 will be displayed along with message.



CR:481077
CR Number:   481077
Product Name:   Sybase ETL
Product Component:   Database
Status:   Open
OS:   all
Original Version:   4.2 EBF #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2009 Workaround
Description
Problem: Failure to delete the data in IQ using ETL with connection type Open Client.



Workaround: Set the Database option "Auto Commit" to "1" will insure the transaction is committed.



CR:481124
CR Number:   481124
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1_GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2012 Fixed
Description
After changing the cluster backend server password, many sybcluster commands cannot print messages that indicate the connection authorization issue.





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

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