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

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

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