远程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:628876
CR Number:   628876
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2010 Fixed
28 May 2010 Fixed
25 Aug 2010 Fixed
25 Aug 2010 Fixed
28 Sep 2010 Fixed
29 Sep 2010 Fixed
14 Mar 2011 Fixed
28 Sep 2010 Fixed
Description
A new script "registerASEIP" is available under $SYBROOT/DBISQL/bin. Execute this script to register ASE DBISQL Plug-in with DBISQL. Normally the plug-in is registered by the installer. The script is useful when DBISQL's registration file ($SYBROOT/DBISQL/bin/dbisql.rep) contains invalid paths when, for example, when user copied the release directory into a different location.



CR:628878
CR Number:   628878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer attempts query with 57 count(distinct ... ) & group by ... error exceed 46 work table limit



Unable to allocate work table for processing group by or distinct clause during query optimization. Maximum limit (46) of work tables is exceeded. Simplify the query and retry.



the workaround is relatively complicated ...
Workaround Description
 split the query horizontally and store sub results in temp tables and then query all the temp tables and put the result set back together from selecting from the temp tables.



see ~ts/cases/11604000s/11604883/pseinfo-11/pse_mweaver/

2010_06_14__11604883-11__NFR_more_than_46_work_table_limit__workaround.txt



Malcolm Weaver/SYBASE

06/16/2010 03:05 PM

To Somdev Sharma/SYBASE

Subject 11604883-11 ... NFR CR 628878 ... query with 57 count(distinct ... ) & group by ... err exceed 46 wrk table limit



Somdev,



OK ... the customer's original query has 241 columns of output.



To simplify the explanation of the workaround let's say there original query had only 14 columns of output.



select

cs_book, NULL,

sum(cs_1186_irdeltasequenti_57), min(cs_1186_irdeltasequenti_2), min(cs_1186_irdeltasequenti_3), count( distinct cs_1186_irdeltasequenti_4),

sum(cs_1186_irdeltasequenti_67), min(cs_1186_irdeltasequenti_32), min(cs_1186_irdeltasequenti_33), count( distinct cs_1186_irdeltasequenti_34),

sum(cs_1186_irdeltasequenti_73), min(cs_1186_irdeltasequenti_50), min(cs_1186_irdeltasequenti_51), count( distinct cs_1186_irdeltasequenti_52)

from cs_1222_scenarioanal_0

where visibility='yes' and is_deleted='no'

group by cs_book

order by outputrowid asc





The work around takes their original query and splits it up into 3 seperate queries that do a select into a temporary table that look like the following first three queries ... each one of these queries is able to succeed because they each use less than 46 work tables ... notice how these 3 queries divide the original query horizontally ... each sub divided query has approximately 1/3rd of the actual output columns and 2/3rds of column place holders ... the zero's(0) are the column place holders ... also notice all the columns are given uniform names ... col### ... and an indentity column is added at the beginning to uniquely identify each row ... the uniform column names and identity column are needed for the last query in the workaround that reunites the divided rows back into a single result row ... another thing to notice is the group by clause is included in the 3 sub divided queries and absent from the query that combines all the rows at the end ...



query 1

select

col000=identity(11), col001=cs_book, col002=NULL,

col003=sum(cs_1186_irdeltasequenti_57), col004=min(cs_1186_irdeltasequenti_2), col005=min(cs_1186_irdeltasequenti_3), col006=count( distinct cs_1186_irdeltasequenti_4),

0, 0, 0, 0,

0, 0, 0, 0

into tempdb.dbo.tmp01

from cs_1222_scenarioanal_0

where visibility='yes' and is_deleted='no'

group by cs_book

order by outputrowid asc



query 2

select

col000=identity(11), col001=cs_book, col002=NULL,

0, 0, 0, 0,

col007=sum(cs_1186_irdeltasequenti_67), col008=min(cs_1186_irdeltasequenti_32), col009=min(cs_1186_irdeltasequenti_33), col010=count( distinct cs_1186_irdeltasequenti_34),

0, 0, 0, 0

into tempdb.dbo.tmp02

from cs_1222_scenarioanal_0

where visibility='yes' and is_deleted='no'

group by cs_book

order by outputrowid asc



query 3

select

col000=identity(11), col001=cs_book, col002=NULL,

0, 0, 0, 0,

0, 0, 0, 0,

col011=sum(cs_1186_irdeltasequenti_73), col012=min(cs_1186_irdeltasequenti_50), col013=min(cs_1186_irdeltasequenti_51), col014=count( distinct cs_1186_irdeltasequenti_52),

into tempdb.dbo.tmp03

from cs_1222_scenarioanal_0

where visibility='yes' and is_deleted='no'

group by cs_book

order by outputrowid asc



Then the last step ,,, query 4 ... of the work around is to concatinate the 3 temp tables back into one conglomeraate result set ...



query 4

select

t1.col001, t1.col002,

t1.col003, t1.col004, t1.col005, t1.col006,

t2.col007, t2.col008, t2.col009, t2.col010,

t3.col011, t3.col012, t3.col013, t3.col014,

from

tempdb.dbo.tmp1 t1,

tempdb.dbo.tmp2 t2,

tempdb.dbo.tmp3 t3

where t1.col000=t2.col000 and t2.col000=t3.col000

order by t1.col000 asc



Sincerely,

Malcolm



CR:628880
CR Number:   628880
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide database option so that only replication would be allowed to update it. ISUG replication enhancement 3258.
Workaround Description
 Manipulate access through roles and permission. However, part of the issue is that RS applies DDL and runs stored procedures with the user id and password of the user that did it on the primary. Hence, these same user ids would have that same type of access at the standby or replicate site and ASE makes no distinction between the rep user and any other user.



CR:628916
CR Number:   628916
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2010 Fixed
17 May 2010 Fixed
17 May 2010 Bundled Request
Description
ASE running on windows may fail to start if Performance registry subkey is not present



CR:628996
CR Number:   628996
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2010 Fixed
25 Jun 2010 Fixed
Description
monSysStatement table report incorrect CpuTime and WaitTime when nested procs are used



CR:628997
CR Number:   628997
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2010 Fixed
Description
Sometimes a 605/696 error "An attempt was made to fetch

logical page <page> belongs to object with id ..."

may be falsely reported during INSERT. The modules

pg_allocate() and pg_latchoam() will be reported in

the stack.



CR:629046
CR Number:   629046
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OMNI: proxy table as a RPC call get Msg 207 cause is the quoted_identifier this is

on for the CIS connection wish mean double quotes is not allowed.
Workaround Description
 remove the double quotes in this repro sample.



select @s = 'select "'+ rtrim(@objname)+ '" objname, ' +convert(varchar(20),@SrcSystemID)+' srcsystemid, count(*) row_count from dia'+rtrim(@objname)+' where SrcsystemID='+convert(varchar(20),@SrcSystemID)



should be change to



select @s = 'select '''+ rtrim(@objname)+ ''' objname, ' +convert(varchar(20),@SrcSystemID)+' srcsystemid, count(*) row_count from dia'+rtrim(@objname)+' where SrcsystemID='+convert(varchar(20),@SrcSystemID)



CR:629134
CR Number:   629134
Product Name:   Sybase ETL
Product Component:   pEngine
Status:   Open
OS:   Windows 2003
Original Version:   4.9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Row delimiter of generated Load Script is incorrect.



Environment:

Sybase ETL 4.9

Windows 2003 Server



Problem Description:





Row delimiter of generated Load Script is incorrect.



Description of the problem:



Customer tried to use IQ Loader File via Load Table component, and they set 2 properties like following.

- Line Delimiter of Text Source Definition : CRLF

- Row Delimiter of Properties : CRLF



Next, run "Generate Load Script" from IQ Loader File via Load Table comtext menu.

And Pushed Load Script Button.

Then generated load script is....



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



LOAD TABLE DBA.test3

(

[col1] ',',

[col2] 0x0d

,FILLER(1)

)

FROM 'D:/work/crlf_test2.txt'

QUOTES OFF

ESCAPES OFF

BYTE ORDER NATIVE

BLOCK SIZE 10000

WORD SKIP 0



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



"0x0d / FILLER(1)" was generated insted of CRLF (0x0d0a).

If "0x0d" is included in source data, above load script doesn't work correctly.



f for IQ performance, I think that using "row delimited by" load table command gets more better performance, like following.



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



LOAD TABLE DBA.test3

(

[col1] ',',

[col2] 0x0d

)

FROM 'D:/work/crlf_test2.txt'

Row delimited by '\n' <-----

QUOTES OFF

ESCAPES OFF

BYTE ORDER NATIVE

BLOCK SIZE 10000

WORD SKIP 0



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



Because if use "row delimited by" statement, IQ tries to load table as multithread.

Results of my test, using "row delimited by" situation is very good performance than original generated load script.



CR:629156
CR Number:   629156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
xmlextract is slower on the Windows 32 bites platform and other platforms.



CR:629164
CR Number:   629164
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2010 Fixed
27 May 2010 Fixed
24 Jun 2010 Fixed
Description
Fix 832 error when reorg rebuild a lot of index partitions.



CR:629301
CR Number:   629301
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2010 Fixed
Description
Sometimes the PCM handler raises an error 941 complaining about illegal database context operation.



CR:629322
CR Number:   629322
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2010 Fixed
25 May 2010 Fixed
Description
In queries with EXISTS or IN subqueries that get flattened and a CIS table is referenced in the main query (not the subquery), then there is a possibility for a stack trace if a unique index exists on the CIS table, if not all the columns in the unique CIS index are referenced.



CR:629423
CR Number:   629423
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A delete statement which joins tables together, can result in a stack trace on a server configured with an optimisation goal of allrows_mixed or allrows_dss.
Workaround Description
 Disable merge joins by issuing set merge_join off before executing the query or configure the optimization goal allrows_oltp.



CR:629430
CR Number:   629430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
10 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Poor performance when proxy table is mapped to remote procedure via CIS on ASE15.
Workaround Description
 Do not use LOOPBACK server but call the procedure directly.



CR:629471
CR Number:   629471
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 One-off Provided
05 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Instrumentation to catch the cause of SIG11 seen inside function lock__mmaster_processque at FNA. Traceflag 16899 needs to be switched on to enabled this instrumentation.



CR:629475
CR Number:   629475
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
30 Mar 2011 Reservation Made
Description
A 225 error, "Cannot run query--referenced object (name NAME NOT

RECOVERABLE) dropped during query optimization." may be reported

when running a SELECT INTO from a view that had to be internally

recreated from its source text, for example, because the database

was upgraded from a previous version.
Workaround Description
 After upgrading the database run DBCC UPGRADEOBJECT("dbname")

to upgrade from source text all the objects in the database

before running the SELECT INTO query.



CR:629579
CR Number:   629579
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 3606, Level 16, State 0:

Server '<SERVER>', Procedure 'sp_sysmon_netio', Line 260:

Arithmetic overflow occurred.



May be seen when running sp_sysmon.



It is caused by a sum aggregation on an int column (that is required to be int to be in

line with system tables) exceeding max int.
Workaround Description
 To workaround it, re-create sp_sysmon_netio with a slightly modified variable declaration

and convert to bigint prior to the sum(). Could also use numeric, which would be

necessary on 12.5.x.



declare @tmp_total bigint



Change line 260 to:-



select @tmp_total = SUM(convert(bigint,value))

from #tempmonitors

where group_name like "engine_%" and

field_name = "no_bytes_sent"



CR:629634
CR Number:   629634
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2010 Fixed
23 Jun 2010 Fixed
Description
Backup servers are not roundrobin'd in a cluster after an error at one of the backupservers.



CR:629642
CR Number:   629642
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2010 Fixed
Description
When running a large number of dynamic sql statements, it could raise 8210 error with stacktrace followed by 2012 or 1780 or both 2012 and 1780 errors.



CR:629833
CR Number:   629833
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE xmlservice as xmlextract() xmltest() is slow compare to other vendors.



CR:629846
CR Number:   629846
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2011 Fixed
09 May 2011 Fixed
Description
Executing CIS queries concurrently accessing external files on a multi-engine server may

crash the server with signal 10 (SIGBUS).



CR:630051
CR Number:   630051
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2010 Duplicate
Description
The query plan for stored procedures that do not contain any table references is not recompiled when the caller has a different ANSINULL setting than what was used to compile the existing plan.
Workaround Description
 Create the procedure "WITH RECOMPILE" option or

execute the procedure "WITH RECOMPILE" clause or

write the procedure using ANSI syntax only or

use SET ANSINULL in the procedure code to determine desired behavior.



CR:630052
CR Number:   630052
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2010 Fixed
29 Feb 2012 Fixed
Description
In Japanese locale, the "Configure PCI" window of syconfig is not localized.



CR:630107
CR Number:   630107
Product Name:   Adaptive Server Enterprise
Product Component:   preupgrade
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have preupgrade generate a script of executable sql commands for all required configuration changes.



CR:630202
CR Number:   630202
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2011 Fixed
Description
In rare circumstances, stale log pages might be cached after node failure in a shared

disk cluster such that two or more surviving nodes are left and failover recovery was

needed for a multi-database transaction that was found in a prepared state. If the

database is replicated, it is possible that the stale log pages will result in errors

during replication.



CR:630246
CR Number:   630246
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2010 Fixed
02 Jun 2010 Fixed
Description
In 15.0.3 ESD #3 and 15.5 ESD #1 there may be incorrect answers or stack traces in queries

involving OR predicates (i.e. IN lists) with equi-sargs on the same column, and joins to columns

on differing datatypes

e.g. r.intcol in (6,10, ...) AND r.intcol = s.numericcol

This should only happen if constants are used without literal parameterization,

i.e. using variables in the OR predicate should avoid this error.
Workaround Description
 use literal parameterization or local variables in the OR predicate / IN list



CR:630362
CR Number:   630362
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2010 Fixed
Description
Server Properties Configuration page would not allow value to be changed when the configuration parameters are filtered. The workaround is to use up/down arrows of the table cell spin box to change values.



CR:630377
CR Number:   630377
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Fixed
30 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
20 Sep 2012 Added to user documentation
23 May 2011 Fixed
Description
If user creates a table with round robin partition or hash partition, and the user does not specify partition name, DDLGen can not generate a system generated partition name.



CR:630425
CR Number:   630425
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3 CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2010 Fixed
Description
In rare circumstances, the message "kernel timeslice -1001, current process infected at

0x<value>" together with a stack trace which includes the modules 'rep_agent_thread',

'ra_process_lr', 'ra_trace', 'scerrlog' maybe be reported in the errorlog when RepAgent

thread tracing is active.



CR:630510
CR Number:   630510
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2010 Not a Bug
Description
Poor performance on minimal stored procedures
Workaround Description
 No workaround



CR:631049
CR Number:   631049
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2010 Fixed
22 Dec 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Implement creating tables with compressed LOB columns



CR:631077
CR Number:   631077
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request covering the addition of parameters for srvbuild\syconfig to enable

specification of separate log\data devices for tempdb.



Currently we only have these parameters available:-



sqlsrv.tempdb_device_physical_name

sqlsrv.tempdb_device_size



CR:631082
CR Number:   631082
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Solaris
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2012 Added to user documentation
Description
Request to document IATEMPDIR environment variable that can be used to specify the

temporary directory used by InstallShield (equivalent to setting -is:tempdir on the

command line for the installer).



CR:631130
CR Number:   631130
Product Name:   Sybase SQL Server
Product Component:   preupgrade
Status:   Closed
OS:   NA
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Duplicate
Description
sqlupgrade finds deprecated functions but stored procedure name absent in msg



$SYBASE/ASE-15_0/init/logs>

find . -name "*" | xargs grep depre

...

./sqlupgrade0601.001: Stored Procedure '' uses deprecated builtin functions as:

...
Workaround Description
 search through the <dbname>.dbo.syscomments table looking for the deprecated function similar to the following ...



C:\oc15e22\OCS-15_0\bin>isql -Sp6s1503e3ss -Usa -P -w2048 -Drepro

1> select * from repro.dbo.syscomments where text like "%rowcnt%"

2> go

id number colid texttype language text colid2 status partitionid

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

48000171 1 1 0 0 create procedure all256rowcntfunc

as

select "select rowcnt(sysindexes.doampg) from sysindexes where name = 'all256' = " + convert(varchar(10), (select rowcnt(sysindexes.doampg) from sysindexes where name = 'all256'))

0 0 NULL

64000228 1 1 0 0 create procedure all256atrowcntvar

as

declare @rowcnt int

select @rowcnt = count(*) from all256

select "@rowcnt = " + convert(varchar(10), @rowcnt)

0 0 NULL



(2 rows affected)

1> quit



C:\oc15e22\OCS-15_0\bin>



CR:631133
CR Number:   631133
Product Name:   Sybase SQL Server
Product Component:   preupgrade
Status:   Closed
OS:   NA
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2011 Fixed
27 Nov 2011 Fixed
Description
The stored procedure name may not be displayed correctly in message, "Stored Procedure <stored proc name> uses deprecated builtin functions as", when running the preupgrade tool.
Workaround Description
 search through the <dbname>.dbo.syscomments table looking for the stored procedures that actually contain the deprecated function similar to the following ...



C:\oc15e22\OCS-15_0\bin>isql -Sp6s1503e3ss -Usa -P -w2048 -Drepro

1> select * from repro.dbo.syscomments where text like "%rowcnt%"

2> go

id number colid texttype language text colid2 status partitionid

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

48000171 1 1 0 0 create procedure all256rowcntfunc

as

select "select rowcnt(sysindexes.doampg) from sysindexes where name = 'all256' = " + convert(varchar(10), (select rowcnt(sysindexes.doampg) from sysindexes where name = 'all256'))

0 0 NULL

64000228 1 1 0 0 create procedure all256atrowcntvar

as

declare @rowcnt int

select @rowcnt = count(*) from all256

select "@rowcnt = " + convert(varchar(10), @rowcnt)

0 0 NULL



(2 rows affected)

1> quit



CR:631156
CR Number:   631156
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)
16 Aug 2010 Fixed
Description
CIS optimizer ignores sending index hint to the remote server if the proxy table is in a subquery.



CR:631179
CR Number:   631179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2010 Fixed
07 Jun 2010 Fixed
01 Jul 2010 Fixed
Description
A 14108 error, "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>" may be reported when creating a huge non-clustered index on an allpage-locked table using parallel sort.



CR:631204
CR Number:   631204
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2010 Fixed
28 Jun 2010 Fixed
19 Jul 2010 One-off Provided
21 Jun 2010 Reservation Made
30 Jun 2010 Fixed
12 Aug 2010 Fixed
12 Aug 2010 Fixed
12 Aug 2010 Fixed
Description
The message "Native thread (ThreadID <value>) infected with 6", OR

"PCI(T1): -> PCA_JVM: JVMLOG 'FATAL ERROR in native method: Bad global or local ref

passed to JNI'" followed by "PCI(T1): JVM_ABORT called - ignore", OR

"PCI(T1): DEBUG: pci_command_stop; Request to stop slot 1" may be reported

in the error log during the execution of a query involving UDF/ADT constructions.

This error is caused because the COTS JavaVM integrated PCA/JavaVM cache gets corrupted.

This will result in either the current session terminating or ASE shutting down itself.

In order for the current fix to be effective and prior to start the COTS JavaVM,

the PCA/JavaVM cache needs to be disabled by the SA user by running in the sybpcidb

database the command: sp_jreconfig "disable", "pca_jvm_sigcache_enabled"
Workaround Description
 There is no workaround to this problem. A fix under this CR is required to overcome this problem.



CR:631308
CR Number:   631308
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2010 Fixed
19 Jul 2010 Reservation Made
20 Jul 2010 Fixed
21 Jul 2010 Fixed
21 Jul 2010 Fixed
21 Jul 2010 Fixed
Description
If a scalaragg is projected from a view (or derived table) and

the scalaragg is subsequenctly used in a group-by clause and the

result of the scalaragg grouping column is is subsequently

joined to itself, then a SEGV could occur in _CgReplaceVars().

Note extended column semantics will create an implicit join between the

grouping instance of the scalaragg and another instance of the scalaragg.

The following extended column query is an example of the problem:



select s.c3

from (select count(r.c1) cntem, r.c2, r.c3 from r) s

group by s.cntem, s.c2
Workaround Description
 compatibility mode works for the query



CR:631379
CR Number:   631379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2010 Added to user documentation
Description
Latest PC Client for the ASE 15.5 ESD#1 release.



CR:631382
CR Number:   631382
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2010 Fixed
12 Jul 2010 Fixed
12 Jul 2010 Fixed
30 Aug 2010 One-off Provided
Description
Possible 712 error and stack trace when using reserve_identity for many reservations over a long lived session.



CR:631398
CR Number:   631398
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2010 Insufficient priority to fix
Description
15.5 "null" function adds spaces to the result set



CR:631416
CR Number:   631416
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)
09 Sep 2010 Fixed
03 Sep 2010 Reservation Made
Description
Semi join costing estimates are inaccurate (these are the flatten correlated EXISTS subqueries, or some multi-table delete queries, or some cases of DISTINCT queries). The semi join row estimate should not be greater than the outer subplan estimate. Also some cases of semi-join underestimates are corrected in cases where the inner join estimate is fairly selective already. Use optcriteria cr631416 to turn on this change, or trace flag 16918, or use optlevel ase_current



CR:631485
CR Number:   631485
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Linux
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
The request is to document SuSE 9 bug 165140 in our Linux install guides for ASE 15.0.x.

It is believed to be fixed in kernel version 2.6.5-7.322

Without the fix:-



kernel BUG at fs/aio.c:733!



may be seen in the messages file during an async i/o operation.



CR:631531
CR Number:   631531
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2010 Fixed
30 Aug 2010 One-off Provided
06 Jul 2010 Fixed
06 Jul 2010 Fixed
Description
Renormalization of stored procedure or triggeres may fail with error 208

(Object not found) if the procedure was created by the user with 'sa' authorization

under impersonated user with setuser 'username' command and the execution is done by the

real connection with 'username'.
Workaround Description
 When creating objects under 'sa' autohotity and setuser command

do:

set role sa_role off

before creating procedures or triggers.



CR:631695
CR Number:   631695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2010 Fixed
Description
It is possible to define an in-memory or other low durability database as a scratch database for an archive database.



CR:631758
CR Number:   631758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2011 Fixed
Description
The value1 and value2 fields in sp_dbcc_run_differentialreport have insufficent length, thus causes conversion error.
Workaround Description
 Temporary change the varchar(12) to varchar(14)

*

** 18486, "Generating 'Differential Report' for object %1! in database %2!."

*/

exec sp_getmessage 18486, @msg output

print @msg, @objname, @dbname

print ""

select "Parameter Name" = convert(varchar(50), t.type_name),

"Index Id" = convert(varchar(3), st1.indid),

"Partition Id" = convert(varchar(10), st1.partitionid),

"Value1" = convert(varchar(14), value1),

"Value2" = convert(varchar(14), value2)

from #stat_info1 st1, #temp_dbcc_types t

where st1.objid = @objid and st1.type_code = t.type_code

order by indid, partitionid



CR:631769
CR Number:   631769
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Solaris
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 Fixed
Description
In all the 15.5 Installation guides under 'Installing Server Components', the link for

'Creating a Response File' actually points to the PC Client 'Creating a Response File' page

not the server page, as such it contains references to setupConsole as oppose to setup.bin



CR:631782
CR Number:   631782
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for Try / Catch error handling in ASE TSQL.



CR:631785
CR Number:   631785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for DIFFERENCE / EXCEPT / INTERSECT operators



CR:631887
CR Number:   631887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Need to stop sub-ordinate transactions being created in master database as they may prevent recover in the event of a failure between the commit prepare and the final commit.



CR:631903
CR Number:   631903
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2010 Bundled Request
Description
A 3172 error, "Adaptive Server cannot load this dump because its version is incompatible with the version of this server..." is reported when loading a future ASE 155* version in a ASE 155 server.



CR:631913
CR Number:   631913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Writetext give you error 207 this is a race condition.
Workaround Description
 set compatibility_mode on



CR:631915
CR Number:   631915
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2011 Fixed
23 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
Description
A signal 11 followed by a stacktrace involving CgpSort::_cgpInit() may occur when a VIEW or derived table with a non-correlated scalar aggregate subquery expression SELECT column is participating in some equijoin over the VIEW column.



CR:631963
CR Number:   631963
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Execution of DBCC CHECKCATALOG against a database in which a row for a trigger exists in sysobjects and references a table for which there is no corresponding row in sysobjects causes a signal 10 stack trace after errors 2513, 15018 and 15010.

We may see routines endscan() and trigger__target_confirm() on the stack trace.



CR:632021
CR Number:   632021
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2010 Fixed
Description
sp_companion "<servername>", do_advisory, "allow password downgrade" throws a usage error.



CR:632023
CR Number:   632023
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2010 Fixed
01 Oct 2010 Reservation Made
30 Nov 2010 Fixed
30 Nov 2010 Reservation Made
Description
Under very specific circumstances a query that has been cached in the statement cache appears to be cached a second time according to the output of showplan, but the query has actually reused a cached plan.
Workaround Description
 No work around has been identified for this issue



CR:632041
CR Number:   632041
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Under certain circumstances a stored procedure that contains a query which mixes ANSI and Transact-SQL outer joins does not report an error upon creation or execution as expected. If the database containing the procedure is dumped and reloaded. The first execution of that procedure may then report error 11041.
Workaround Description
 Avoid mixing ANSI and Transact-SQL style joins in the same query.



CR:632055
CR Number:   632055
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
06 Sep 2010 Bundled Request
Description
When large Java classes using nested methods causing deep recursions are run concurrently

by multiple sessions, ASE may run into a situation where the signature cache of the

PCI integrated JavaVM gets corrupted causing the report of inconsistent error messages.

In some cases this may result in the JVM aborting or ASE shutting down itself.
Workaround Description
 Assign more memory to the pci memory pool.



CR:632076
CR Number:   632076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2010 Fixed
15 Aug 2011 Fixed
15 Aug 2011 Fixed
Description
Executing ALTER TABLE with a MODIFY clause together with a clause for addition of a table level constraint may result in signal 11 followed by a stacktrace involving the module 'palt__build_insert_forusertable'.



CR:632164
CR Number:   632164
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to add message indicating broken sysroles\syssrvroles mappings

during an online database which contains sysroles.id equal to -1

(due to a prior load at some point that didn't have the server roles in syssrvroles.)



CR:632207
CR Number:   632207
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2010 One-off Provided
30 Jul 2010 Fixed
23 Sep 2012 Fixed
Description
In some circumstances, query on MDA table monCachedObject may affect ASE system performance.



CR:632244
CR Number:   632244
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2011 Fixed
Description
Create table hits error 1791 if 'not compressed' is specified on timestamp column.



CR:632285
CR Number:   632285
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2010 Fixed
Description
The replication of text/image columns may not work correctly in case of bulk copy program.



CR:632330
CR Number:   632330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2010 Fixed
Description
Need to migrate option "builtin_date_strings" for cluster edition.



CR:632360
CR Number:   632360
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
Description
sp_spaceusage may fail with error 247 arithmetic overflow if systabstats contains inconsistent allocation values for the table.



CR:632456
CR Number:   632456
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2010 Fixed
Description
Sybase Central 6.0.0.4765 display of indexes index_keys lacks delimiters between each column involved in the index keys.

e.g. if you try to distinguish what columns are involved in the index keys from the

index list in Sybase Central then when there are multiple columns involved in the

index, they are all concatinated into one long meaningless name ... ??? ...

for example there is the index ... nc2syspartitions on ... master.dbo.syspartions

with index_keys of ... id, indid, name -- but in Sybase Central this information is displayed as idindidname ... ??? ...
Workaround Description
 one is able to right click on the index name in the right pane ... choose properties ... select the columns tab ... for a legible breakdown but this obviously many unnecessary steps if the first display of the info was formated with delimiters.



CR:632482
CR Number:   632482
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2010 Diagnostic Provided
31 Aug 2010 Fixed
28 Sep 2010 One-off Provided
29 Sep 2010 One-off Provided
30 Sep 2010 One-off Provided
15 Oct 2010 One-off Provided
25 Feb 2011 One-off Provided
25 Feb 2011 One-off Provided
29 Mar 2011 One-off Provided
07 Apr 2012 Insufficient priority to fix
27 Jun 2012 Fixed
Description
ASE reports "Protocol <XXXXX> not supported within soc_nopen()" error in errorlog.

This may be followed by SIGSEGV, SIGBUS or timeslice error and lead to ASE hang.



CR:632510
CR Number:   632510
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2010 EOL'd version. Not to be Fixed.
23 Jun 2010 Fixed
Description
Using a resource file to run sybmigrate allows the user to specify queries to produce lists of objects to migrate.

When this method is used and one of the queries that has been included in the resource file returns no rows,

Migration tool will report an error and the migration process stops.
Workaround Description
 Modify queries such that none return zero rows.



CR:632515
CR Number:   632515
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2010 Fixed
05 Jul 2010 Fixed
09 Jul 2010 Fixed
02 Jul 2010 One-off Provided
25 Jun 2010 Fixed
25 Jun 2010 Reservation Made
28 Jun 2010 Fixed
07 Jul 2010 Fixed
09 Jul 2010 Fixed
23 Mar 2012 Fixed
Description
alter table with 256 length encrypted column and init_vector is 30x slower on 15.0.3 than it is on 12.5.4 and windows.



CR:632532
CR Number:   632532
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
feature request: unique index on the sysaudits tables



CR:632556
CR Number:   632556
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)
16 Sep 2010 Fixed
10 Sep 2010 Reservation Made
Description
Trace flag 16919 was added to turn off the optcriteria conserve_tempdb_space for all sessions and not require a login trigger. This trace flag will turn off conserve_tempdb_space whether or not this optcriteria is set.
Workaround Description
 turning off ase_current or

turning off conserve_tempdb_space or

increasing the "resource granularity" to a high enough percentage (35 in this case)

fixes the problem



CR:632572
CR Number:   632572
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2010 Fixed
22 Jun 2010 Reservation Made
25 Jun 2010 Fixed
01 Jul 2010 Fixed
Description
comparison of metadata names sometimes ignores the sort order

character semantics for comparisons of table names, correlation names

index names, work table names, disk names, view names, node names.

This could result in name mismatches with mixed case for nocase installations.



CR:632617
CR Number:   632617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new feature to enable doneinproc tokens to be turned off at session level.
Workaround Description
 Turn off doneinproc for all connections



CR:632623
CR Number:   632623
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)
25 Jun 2010 Fixed
25 Jun 2010 Fixed
25 Jun 2010 Fixed
01 Jul 2010 One-off Provided
26 Jun 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
Trace 299 has no effect on queries with outer joins if the temporary table

has the outer position in the join.
Workaround Description
 use compat mode



CR:632694
CR Number:   632694
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   Aries CE
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2010 Fixed
22 Jun 2010 Fixed
22 Jun 2010 Fixed
Description
891 error along with stacktrace may be reported when creating placement index on empty non-partitioned DOL table

to which a named cache is bound implicitly or explicitly.



CR:632695
CR Number:   632695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2010 Fixed
28 Jun 2010 Fixed
Description
Error 603 might be seen if server runs out of system session descriptors.



CR:632760
CR Number:   632760
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2010 Fixed
24 Jun 2010 Fixed
Description
When reconfiguring the option "optimizer level", the new value is shown as

INT instead of STRING in the config file, which may cause server boot failure.



CR:632800
CR Number:   632800
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
At first dbcc checkstorage may report temporary inconsistencies in a target database loaded a pre-15.0 database dump.

These inconsistencies should not be reported and may disappear on the second attempt of dbcc checkstorage.
Workaround Description
 run checkstorage on the database again



CR:632983
CR Number:   632983
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2010 Fixed
Description
Extended column aggregate views (sybase extension which allows

columns in the select list of a GROUP BY aggregate

which are not in the GROUP BY list) which in turn

reference union views can lead to a signal 11 in

markColForStat or ind_get_ides.



CR:632999
CR Number:   632999
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2010 Duplicate
Description
During an upgrade of ASE 15.0.2 ESD<X> to ASE 15.5, you may receive

a dbisql dialogue box stating:-



"The runtime environment could not be found in ."



This is due to a call made by the installer to terminate the dbisql fast-launcher.

The error message is raised as it runs the 15.0.2 DBISQL (which is version
Workaround Description
 Rename %SYBASE%\DBISQL\bin\dbisql.exe to %SYBASE%\DBISQL\bin\dbisql_old.exe before running the ASE 15.5 installer.



CR:633043
CR Number:   633043
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
readpast having problems getting nextid in 15.x
Workaround Description
 Do not use 'readpast'



CR:633074
CR Number:   633074
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2010 Duplicate
Description
Duplicate of CR 610496
Workaround Description
 SQL rewrite or



sp_recompile chao_debt_detail

dbcc traceon(15370)

go

The query should work now.



CR:633087
CR Number:   633087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2010 Fixed
29 Jun 2010 Fixed
29 Jun 2010 Fixed
Description
After a placement index column of empty DOL table is changed using ALTER TABLE cmd, error 2583 may be reported when running "dbcc checktable" on this empty DOL table.



CR:633149
CR Number:   633149
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2010 Fixed
08 Jul 2010 Fixed
Description
Using DDLGen to create ddl for all the objects in the database such as:

ddlgen -Usa -Sservername -Ppw -Ddbname -TDB

DDLGen generates the following info for system view: sysquerymetrics

"-- Cannot Generate DDL for system view(s)."
Workaround Description
 Current workarounds:

1. do not ask ddl extractions for the views if there is no user view in the database

2. create a dummy user view in a database



CR:633168
CR Number:   633168
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2010 Fixed
21 Jul 2010 Fixed
22 Jul 2010 Fixed
07 Sep 2010 One-off Provided
Description
A client which can not understand a BIGINT data type may get a tds protocol error when trying to retrieve a signed 8-byte integer value in compatibility mode.
Workaround Description
 (1) Upgrade your client version to at least 15.0 (which can recognize BIGINT data type).

(2) Turn off compatibility mode.

(3) Convert a BIGINT value to a NUMERIC value using convert() function.



CR:633287
CR Number:   633287
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2010 Fixed
03 Aug 2010 Fixed
03 Aug 2010 Fixed
Description
Error 100016 will occur when doing dbcc checkstorage after create placement index on unpartitioned DOL table using parallel sort and not explicitly requesting multiple consumers.



CR:633295
CR Number:   633295
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   150 winx64
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2013 Fixed
Description
Feature request to support single sign-on with ASE 64bit on Winx64.



CR:633447
CR Number:   633447
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)
01 Jul 2010 Workaround
08 Sep 2010 Fixed
Description
Using ASE 15.0.2 or 15.0.3, for all platform, when RepAgent connect to RepServer (the first time), following message occurs:



00:00000:00013:2010/06/25 16:31:42.39 server Started Rep Agent on database, 'prim' (dbid = 4).

Unable to retrieve localized message for ID 1





This message is reported even nor SSL nor LDAP is used.

Even this message is reported, RepAgent thread connection to RepServer succeed and replication works as expected.



This message is raised by CSI layer.

CSI layer is not able to find its localized file to report a warning.



The message that should be report is the following:



00:00000:00011:2010/06/25 16:28:19.20 server Started Rep Agent on database, 'prim' (dbid = 4).

Sybase CSI Error Message: OpenSSL provider instances cannot be loaded concurrently with multiple, distinct, system policies due to limitations within OpenSSL.





CSI layer can't find its localized files because localized files are installed in directory "$SYBASE/locales/unicode/csi/en_us"

instead of "$SYBASE/locales/unicode/csi/en_US" (note the "US" in upper case)
Workaround Description
 create a symbolic name "$SYBASE/locales/unicode/csi/en_US" pointing on "$SYBASE/locales/unicode/csi/en_us" (note the "US"/"us" in upper/lower case)

(or rename directory)



CR:633522
CR Number:   633522
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2010 Duplicate
Description
des_bind is still broken for DOL tables. Error 8242 on reorg compact
Workaround Description
 do not use dbcc tune des_bind on dol tables if you intend to run reorg compact



CR:633656
CR Number:   633656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sysam status -a not showing all ASE servers that checked out ASE_CORE licenses



CR:633698
CR Number:   633698
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2010 Fixed
Description
In shared disk cluster system, LOAD TRAN might report a 692 error and a stack trace due to improper sequencing of events between Adaptive Server and Backup Server while accessing database devices.



CR:633776
CR Number:   633776
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 Jun 2010 Fixed
Description
sp_options shows the incorrect default setting for "optimizer level", it should be ase_default instead of ase_current



CR:633788
CR Number:   633788
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2010 Fixed
20 Oct 2010 Fixed
10 Nov 2010 One-off Provided
12 Apr 2011 Fixed
Description
On ASE CE for platform IBM AIX, resolved issue of multi-path access to SAN not working when devices were I/O fenced.



CR:633797
CR Number:   633797
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
semantically partitioned large table hits deadlocks on sysstatistics when create index

concurrently
Workaround Description
 create index one by one. The problem only appear when create multiple indexes concurrently



or



step 1.

create index command with statistics using 0 values

(the 0 steps indicates that statistics should not be written.)



step 2.

update statistics command on the table after all the indexes have been created



CR:633882
CR Number:   633882
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If a table is altered to be partitioned and then sp_chgattribute is executed immediately

after to modify the 'plldegree', then the attribute change may be lost the next time the

housekeeper flushes the in-memory statistics.
Workaround Description
 --call sp_flushstats after having partitioned the table



create table t1(c1 int)

go

alter table test partition 2

go

sp_flushstats --here

go



CR:633897
CR Number:   633897
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Signal 11 at memset when ASE fails to allocate free fragment pool.



CR:633942
CR Number:   633942
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2010 Fixed
15 Jul 2010 Fixed
15 Jul 2010 Fixed
Description
When an expression contains the string concatenation operator "+" that references a column in the

inner table of an outer join and that expression is in the WHERE clause, then the outer join

can degenerate into an inner join (as seen in showplan) resulting in

an incorrect answer with null-supplied rows

being eliminated.
Workaround Description
 Add a rtrim() (or any other string operator except +) on top

of the string + concat operation to the WHERE clause



select C3 from V1 WHERE rtrim( C3 ) = (select C3 from V1 )



CR:634054
CR Number:   634054
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under certain conditions a system stored procedure querying a system view may return unexpected results as a result of compilation of that procedure.
Workaround Description
 The client has worked around the problem by using execute immediate.



CR:634144
CR Number:   634144
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2010 Fixed
22 Dec 2010 Presently Not Targeted For Any Future Release Of This Product
22 Dec 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Support querying on the compressed LOB columns in ase 15.6





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------