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

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

CR:658276

CR Number:   658276 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) 25 May 2011 Fixed 05 Jun 2011 One-off Provided 25 May 2011 Fixed 25 May 2011 Fixed 15 Sep 2011 One-off Provided 25 Sep 2012 Fixed Description A "9219, severity 20, state 83" error may occur when a stored procedure with enough wide parameters that the number of bytes necessary to log an invocation would require more than a single log page. The error will only occur if the stored procedure has been previously invoked with null values in the wide parameter(s) and is subsequently invoked with non-null values in those same parameter(s). Workaround Description  No work around, Customer will have to move STP (Secondary Truncation Point) - run "rs_zeroltm" - run "dbcc settrunc (ltm, pageid, <page#>)

CR:658298

CR Number:   658298 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need to have some built-in function or global variable that could be checked by customer written tsql applications so that they might finish processing and let normal ASE shutdown with wait proceed.

CR:658317

CR Number:   658317 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2011 Fixed Description The DBCCLOG command in sybmon is extended to support displaying pre-15.5 ASE transaction log records. Workaround Description  Use a pre-15.5 dataserver binary to display the log records correctly.

CR:658340

CR Number:   658340 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2012 Presently Not Targeted For Any Future Release Of This Product Description test and certify a version of ASE 15.5 for solaris 5.11 Workaround Description  Use solaris 5.10

CR:658430

CR Number:   658430 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) 16 Feb 2011 Fixed 12 Oct 2011 One-off Provided 25 Sep 2012 Fixed 02 Oct 2012 One-off Provided Description The PR_DESCHAIN NHASH sybmon command does not print the right information with regards to the hash by name table of DEScriptors.

CR:658449

CR Number:   658449 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Query Processing and Abstract Plans Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2011 Added to user documentation Description "store_ind" syntax incorrect in AP example in ASE15.5 P&T

CR:658621

CR Number:   658621 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2011 Fixed 05 Apr 2011 Added to user documentation Description Value of Severity columns in monErrorLog is 99 indicates it's a stacktrace.

CR:658661

CR Number:   658661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2011 Workaround Description In some cases, there is certification error between ASE WebService and external webservice. Workaround Description  The user imports the certification for the external webservice into the JRE default keystore for example $JRE/lib/security/cacerts.

CR:658668

CR Number:   658668 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A 692 error on syslogs is sometimes reported when loading a dump taken of a database that was in standby_access mode.

CR:658851

CR Number:   658851 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2013 Added to user documentation Description DOCCR: DDLGEN support password encryption, fixed by CR594606

CR:659042

CR Number:   659042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2011 Fixed 14 Apr 2011 One-off Provided 10 May 2011 Fixed 28 Sep 2012 One-off Provided 25 Sep 2012 Fixed Description When the master database is marked for replication the execution of sp_addlogin does not replicate the login with the correct password expiration interval. Workaround Description  manually change the password interval for the user id where the login was replicated to. --or-- When adding the user, specify the password interval. If both servers are different, replication will use the target server configuration, rather than what was entered.

CR:659124

CR Number:   659124 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 Feb 2011 Not a Bug Description After upgrade from ASE1502 to ASE15.5,any user not SA role can't access archive db which is dumped and loaded from ASE1502 onto ASE15.5

CR:659161

CR Number:   659161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow the output/result set returned by a stored procedure to be handled via a scrollable cursor

CR:659334

CR Number:   659334 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 Need feature request for counter of statement iterations

CR:659335

CR Number:   659335 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 Dec 2013 Fixed Description Msg 9561, Level 20, State 1: Invalid pointer param number 2, pointer value

CR:659485

CR Number:   659485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2011 Fixed 04 Apr 2011 Fixed Description A timelice error together with stack trace which includes module 'idt_value_verify' may occur when several rows are inserted into database, or inserting rows followed by retrieving identity value from the database, if BIGINT datatype is used for the identity column. Workaround Description  1. Without one-off, customer can use "unsigned bigint" or "numeric(20,0)" instead of "bigint" for identity column. 2. Code fix: add special handling for bigint in idt_numetoint(), so that converting numeric to bigint invoke comnb_numtoi8(), and overflow is handled correctly.

CR:659498

CR Number:   659498 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   HP-UNIX Original Version:   2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2011 Fixed Description SySAM requests double the required amount of chip licenses for Itanium 9300 series quad-core chips. When this is the case 'cpuinfo -v' displays the diagnostic messages "Family 32 Model 2" and "Family 32 >= 32. Montecito or newer, so dual-core". Workaround Description  Ask the customer for the output from running the following command on the physical machine: sysamcap MACHINE -v Send this output to help_sysam@sybase.com and refer to CR 659498, i.e. Hi, A customer has hit CR 659498 (cpuinfo detects too many Itanium quad core chips). Please recrypt the following SYBASE_SAM_CAPACITY string to override the chip count. (don't forget to set the override flag) PLACE cpuinfo -v OUTPUT HERE Thanks,

CR:659629

CR Number:   659629 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2011 Fixed 22 Jul 2011 Fixed Description When the RepAgent configuration parameter 'rs password' is set by executing the sp_config_rep_agent system stored procedure, the password is logged encrypted to avoid it from being exposed in clear text in the transaction log and during the replication of this stored procedure execution.

CR:659638

CR Number:   659638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to eliminate the SELECT INTO dboption requirement when using ALTER TABLE to add a NOT MATERIALIZED computed column.

CR:659661

CR Number:   659661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request a new feature which can always display a running process's outermost stored procedure name with parameter value(s).

CR:659709

CR Number:   659709 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2011 Bundled Request 10 Mar 2011 Bundled Request Description A stacktrace may be encountered when executing a MERGE statement involving a DELETE if there is a referential integrity assignment in the source table.

CR:659910

CR Number:   659910 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) 07 Jul 2011 Fixed Description Query with TOP, UNION ALL and ORDER BY clause could return fewer rows.

CR:659912

CR Number:   659912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed Description If a query HASH joins a UNICHAR and UNIVARCHAR column and the joining values differ only by trailing blanks, then the row may not be returned. Workaround Description  Disable hash_joins: set h_join 0

CR:659996

CR Number:   659996 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) 14 Mar 2011 Fixed Description Under very rare circumstances, a task committing its transaction may go into an undetected deadlocked condition with another task which is truncating the transaction log.

CR:660022

CR Number:   660022 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed Description A new system stored procedure is needed to convert the existing inline default objects into sharable inline default objects and drop the remaining duplicate ones.

CR:660060

CR Number:   660060 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sysquerymetrics is not recording information on some aborted commands.

CR:660150

CR Number:   660150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed 24 Mar 2011 Fixed Description Some data rows might be missing from a table following a LOAD TRANSACTION of a transaction log that was dumped after the table was created by SELECT INTO when the "fully logging for select into" database option was turned on.

CR:660152

CR Number:   660152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2011 Bundled Request 10 Mar 2011 Bundled Request Description A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is partitioned.

CR:660173

CR Number:   660173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2011 Bundled Request 10 Mar 2011 Bundled Request Description A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is a VIEW with a GROUPBY clause.

CR:660224

CR Number:   660224 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 ASE/CIS to oracle ... convert function causes subquery performance prblm

CR:660311

CR Number:   660311 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2011 Fixed Description Less rows than expected may be returned when executing a query which joins 3 or more tables with All Pages Locking schema, there are some duplicate conditions in the WHERE clause and the SET SHOWPLAN ON output shows that it used a N-ARY NESTED LOOP JOIN operator. Workaround Description  Use trace flag 342 to disable N-ary NLJ or remove a duplicate SARG if possible or use DOL tables.

CR:660481

CR Number:   660481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2012 Fixed 28 Mar 2012 Reservation Made Description The recovery REDO pass at boot time or during LOAD DATABASE is unnecessarily slow in cases where there is one or more very long running transactions.

CR:660563

CR Number:   660563 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2011 Fixed 19 May 2011 Fixed 20 May 2011 Fixed 08 Jun 2011 Fixed 28 Jul 2011 Fixed 02 Aug 2011 Fixed 02 Aug 2011 Fixed 18 Jul 2011 Reservation Made 26 Jul 2011 Fixed 27 Jul 2011 Fixed 09 Aug 2011 Fixed 20 Mar 2012 Presently Not Targeted For Any Future Release Of This Product 23 Apr 2012 Presently Not Targeted For Any Future Release Of This Product 20 Mar 2012 Presently Not Targeted For Any Future Release Of This Product 02 May 2012 Fixed 09 Apr 2012 Fixed 11 Apr 2012 Fixed Description A new interface is provided that enables ALTER TABLE DROP column DDL to optionally execute by deferring the time-consuming data copy path.

CR:660729

CR Number:   660729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 17 Jul 2011 Fixed Description LICENSE HEARTBEAT process down with stacktrace. <environments> Sun Solaris UltraSparc-T / Solaris 10 / Doesn't configure Logical Domains. <WorkAround> Use 1 or 2 1) use SYBASE_SAM_CAPACITY enviroment ( sysamcap DEFAULT ) 2) add solaris.ldoms.read role to sybase user. Workaround Description  <WorkAround> 1) use SYBASE_SAM_CAPACITY enviroment ( sysamcap DEFAULT ) or 2) add solaris.ldoms.read role to sybase user.

CR:660784

CR Number:   660784 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) 17 Mar 2011 Presently Not Targeted For Any Future Release Of This Product 31 Mar 2011 Not reproducible with latest version of the product available as of Resolution Date Description Signal 11 at LeScanOpM_LeOpAcquire6MrnHExeCtxt, LeNaryNLJOp::_LeOpAcquire(ExeCtx Workaround Description  Use traceflag 342 to turn off nary nested loop join.

CR:660820

CR Number:   660820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Nov 2011 Fixed Description sp_helprotect does not consider roles inherited through login profiles when reporting permissions. In addition, on a High Availability environment, when a primary fires a command to CREATE/ALTER/DROP login or login profile and if the command fails on the secondary, the TDS return status of the command on the primary is still a success.

CR:660837

CR Number:   660837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Need an ability to select information from a stored procedure without first having to create a proxy table.

CR:660956

CR Number:   660956 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2011 Workaround Description In some cases, ASE WebService may hang while ASE WebService server is started with JRE6 distributed with ASE on IBM AIX. Workaround Description  The user can download an JRE6 from IBM freely and install it on user machine. And use the installed JRE instead of the JRE6 distributed with ASE

CR:660984

CR Number:   660984 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 When a generated select query contains duplicate column names in the select list, then the query should be executed as occurs in ASE 15.0.3 ESD #1, provided that there can be no resulting ambiguity caused by the inclusion of an order by clause. Workaround Description  There is no workaround for the client other than to stay on a specific version of ASE that permits their generated queries.

CR:661262

CR Number:   661262 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2011 Fixed Description workaround listed for ase1503esd3 on win2008R2 does not always work

CR:661265

CR Number:   661265 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2011 Fixed Description A 7105 error, "TEXT/IMAGE/UNITEXT page <page> does not have a next page" together with a stack trace may be reported when input text string containing partial character at the end is inserted into Adaptive Server which has the same character set as client by BCP...IN.

CR:661425

CR Number:   661425 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2011 Added to user documentation Description Document the contents of the Job Scheduler history table

CR:661452

CR Number:   661452 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Nov 2011 Presently Not Targeted For Any Future Release Of This Product Description Using control-c to terminate a batch that creates a temp table and uses INSERT SELECT to insert rows into that temptable may result in an orphaned temp table. Use DBCC ORPHANTABLES("drop") to clean up the orphaned tables. Workaround Description  DBCC ORPHANTABLES("drop") should clean up the orphaned table(s).

CR:661494

CR Number:   661494 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) 28 Mar 2011 Fixed 14 Mar 2011 Fixed 15 Mar 2011 Reservation Made 11 Apr 2011 Presently Not Targeted For Any Future Release Of This Product 03 Oct 2011 One-off Provided Description Under multi-byte character sets, selecting rows from text columns may cause more IOs comparing to single-byte character set.

CR:661508

CR Number:   661508 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) 10 Jun 2011 Fixed 10 Jun 2011 Fixed Description A 3478 error: "During undo the page timestamp value is less than new timestamp from log ... ", may be reported during reboot if a REORG REBUILD command was active at the time the server was killed.

CR:661677

CR Number:   661677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2011 Fixed 14 Jun 2011 Fixed 14 Jun 2011 Insufficient priority to fix Description After a cross-platform dump-load, some of the histogram statistics, used by the optimizer, may be incorrect. Workaround Description  1. Run update statistics after cross platform dump-load. OR 2. Use optdiag: Before the dump save statisitcs in a text file using opdiag. After the load use optdiag to load those states on the other platform.

CR:661716

CR Number:   661716 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Solaris Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2011 Fixed Description The wrong syntax is included in the two following manuals. Installation Guide Adaptive Server Enterprise 15.5 for Sun Solaris Installation Guide Adaptive Server Enterprise 15.5 - Cluster Edition for Sun Solaris Preinstallation Tasks for the Server Installation : wrong: project.max-shm-memory=\(privileged,17179869184,deny) correct: project.max-shm-memory=(privileged,17179869184,deny)

CR:661802

CR Number:   661802 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2011 Fixed Description Sybcluster always performances heartbeat check according to "quorum heartbeat retries" and will not stop even if the check if successful.

CR:661814

CR Number:   661814 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2011 Fixed Description Changing ASE config parameters can cause exception java.lang.NullPointerException at java.lang.String.compareTo(String.java:1168)

CR:661819

CR Number:   661819 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Allow the ASE Web Services to support more than one output parameter

CR:661974

CR Number:   661974 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2011 Fixed 10 Mar 2011 Fixed Description With statement cache is ON and literal parameterization is OFF, when a string literal in a UPDATE/SELECT/INSERT/DELETE statement contains quotes and [ ] inside the quotes, if there are whitespaces after the right ], those whitespaces might be filtered out causing a wrong literal value to be stored in the statement cache text entry. Workaround Description  Turn on literal autoparam.

CR:662014

CR Number:   662014 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) 16 Mar 2011 Fixed Description Signal 11 can occur in the module 'th_curunreservedpgs' when an ALTER DATABASE is run at the same time the curunreservedpgs() builtin function is used. Workaround Description  Don't run curunreservedpages() while an alter database is running

CR:662048

CR Number:   662048 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 ESD#1 12 Jan 2012 Duplicate Description ADO.NET: A Decimal parameter with value of null is sent with Precision = 0, this query fails if ASE statement cache is enabled with message "Length or precision specification 0 is not within the range of 1 to 255.". Workaround Description  Customer currently doing either no statement cache or purging the cache with dbcc purgesqlcache Connectivity PSE also discovers if the client app explicitly sets Precision and Scale for the decimal parameter they'll avoid the problem.

CR:662152

CR Number:   662152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2011 Fixed 11 Apr 2011 Fixed Description ASE WebService will use jConnector-7_0 instead of jConnector-6_0.

CR:662247

CR Number:   662247 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2011 Fixed Description OEMs can now specify the directory used by DBISQL, Sybase Central, DBConsole, and ML Monitor. To do this, you must deploy an OEM.ini file along with DBISQL (et al). The file must contain the following lines: [preferences] directory=preferences_files_directory where "preferences_files_directory" is a fully-qualified directory name, e.g. "c:\work\prefs". The directory name should not end in a separator (backslash on Windows; forward slash on Linux, Unix, and OS X). Preferences files include: .isqlPreferences12_32 .isqlPreferences12_64 .isqlHistory12 .jlogon12 .textCompleter12 .SybaseCentralEditor610 .scUserPreferences610_32 .scUserPreferences610_64 among others.

CR:662338

CR Number:   662338 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2011 Fixed Description IOTime in monIOQueue is incorrect for multiple engines server on Windows platform.

CR:662402

CR Number:   662402 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2011 Fixed Description Running an EXECUTE CURSOR query may hit SIGSEGV in s_compile() in case of recompilation, together with stack trace involving modules s_setupcursor(), curs_execute() and s_recompile().

CR:662410

CR Number:   662410 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2011 One-off Provided 12 Nov 2012 Fixed Description ARIES CE with >1 instance setup hits SIG11 inside function lock__mmaster_processque

CR:662451

CR Number:   662451 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Issue a warning/error when SELECT INTO EXISTING is used on a local table

CR:662458

CR Number:   662458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for an xmlextract text() option to extract de-entitized string data from xml source. Currently, text() only extracts entitized strings. Workaround Description  create function de_entitize (@input varchar(16000)) returns varchar(16000) as -- second parameter should be entitized string for the symbol. -- browser may be interpreting it. i.e. -- second paramter on the next line is really &-amp; without hyphen select @input = str_replace(@input, "&", "&") select @input = str_replace(@input, '"', '"') -- &-quot; without hyphen select @input = str_replace(@input, "'", "'") -- &-apos; without hyphen select @input = str_replace(@input, "<", "<") -- &-lt; without hyphen select @input = str_replace(@input, ">", ">") -- &-gt; without hyphen return @input go

CR:662522

CR Number:   662522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description timeslice in function pgos_nextpgidsmap when doing create index in parallel

CR:662586

CR Number:   662586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed Description ASE dataserver does not give page or dbid information with error 290024.

CR:662591

CR Number:   662591 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Signal 11 at void LeSargArray::setupSargArray(proc_hdr*) Workaround Description  No workaround

CR:662923

CR Number:   662923 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) 10 Apr 2011 Duplicate 08 Oct 2012 Fixed Description sp_monitorconfig 'procedure cache size' can become inaccurate. Fixed via CR 644156.

CR:662937

CR Number:   662937 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2011 Fixed 18 Mar 2011 Reservation Made Description Provide global variable @@sbssav and ASE command line option --sbssav, returning a short standardized ASE version string.

CR:663005

CR Number:   663005 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2011 Fixed 01 Apr 2011 One-off Provided 04 Apr 2011 Fixed 29 Mar 2011 Fixed Description A cluster setup with more than 1 instance may encountered a signal 11 with a stacktrace involving the function 'lock__mmaster_processque'.

CR:663109

CR Number:   663109 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2011 Fixed 04 Aug 2011 One-off Provided Description Under some very rare circumstances, one of the cluster instances may abort with an infected with 11 message together with a stack trace showing module name 'dbt_rdump_action_pcm_callback'. This may happen after a DUMP DATABASE command was interrupted or hit an exception.

CR:663156

CR Number:   663156 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to have except action option for "sp_audit 'all','all','all"

CR:663203

CR Number:   663203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2011 Fixed Description Error 2502, "Table Corrupt: A page is linked in more than one chain; check this page:page number=<page number> allocation status=<status value>", followed by error 7968, "The object allocation map for tabid <object id> indid <index id> partition <partition nid> is corrupt, therefore the optimized report cannot be generated. Contact Technical Support for assistance.", will be reported when running "dbcc textalloc" with "noreport" option multiple times.

CR:663224

CR Number:   663224 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2011 Bundled Request 05 Apr 2011 Fixed 30 Mar 2011 Fixed 28 Apr 2011 Bundled Request Description In some cases, ASE WebService cannot consume the WebService which has SOAP datatype parameters including soapenc:byte, soapenc:boolean, soapenc:long and soapenc:int.

CR:663304

CR Number:   663304 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2011 Fixed 23 Mar 2011 Reservation Made 01 Apr 2011 Fixed 11 Apr 2011 Fixed 31 Mar 2011 Fixed Description If an APL table has a unique CLUSTERED INDEX with all keys specified by constants and a non CLUSTERED INDEX is forced, then the join order will place this table at the beginning of the join order, bypassing costing, which could result in a performance problem. This behavior is fixed by optcriteria cr663304 or trace flag 16926. Workaround Description  There are a few workarounds for the query: 1) compatibility mode (12.5 optimizer checks all 6 permutations as the customer pointed out) or 2) new 15 trace flag -T15308 to ignore index/prefetch/parallel/replacement forcings as engineering pointed out or 3) avoid index forcing for the query so that the 15 optimizer can pick up a different index for the join order or 4) alter table ext_instr_ref_p2k lock datarows

CR:663342

CR Number:   663342 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2011 Fixed 02 Jun 2011 Fixed 17 Aug 2011 Fixed Description There could be a memory corruption during page allocation either in case of a MLD database when another task is doing the allocation on the same allocation page or with any database if the buffer for the new page could not be allocated.

CR:663359

CR Number:   663359 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2011 Fixed Description A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified." may be reported when running SP_HELP_REP_AGENT with no parameter values.

CR:663436

CR Number:   663436 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An infected with 11 with a stacktrace containing functions infected fm_unlink_frame fm_free_frame fm_free_list if the server if the sp_configure setting for open databases is lower than the actual number of databases on the server. Workaround Description  Increase the sp_configure setting for "open databases". This should be set at least as high as the actual number of databases on the server. If this CR is not yet fixed, please try to get a memdump (no data cache needed) before applying the workaround.

CR:663457

CR Number:   663457 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2012 Not a Bug Description UPDATE STATISTICS actually executes when SET SORT RESOURCES is ON rather than just providing resource usage estimates.

CR:663537

CR Number:   663537 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Mar 2011 Fixed Description Create table with compressed LOB in imdb should fail but not now.

CR:663600

CR Number:   663600 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) 29 Mar 2011 Fixed 25 Apr 2011 Duplicate 03 Oct 2011 One-off Provided 26 Sep 2012 Fixed Description Updating identity columns gives error 586: Illegal identity value specified for identity Workaround Description  use compatibility mode Roll back to 15.5 ESD #2

CR:663606

CR Number:   663606 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2011 Fixed 11 May 2011 One-off Provided 01 Jun 2011 One-off Provided 16 May 2011 Reservation Made 23 May 2011 Fixed 01 Jun 2011 Fixed Description BCP-in performance on a large table having many indices is significantly worse than the performance achieved using 12.5.4

CR:663628

CR Number:   663628 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) 12 May 2011 Fixed Description Worktables will not be shown in monProcessObject.

CR:663651

CR Number:   663651 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2011 Fixed 20 Apr 2011 Fixed Description Two new fields (ssql_optgoal and ssql_optlevel) are added to statement cache entry, and two new columns (OptimizationGoal and OptimizerLevel) are added to table monCachedStatement.

CR:663778

CR Number:   663778 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) 25 Mar 2011 Duplicate Description Make the statement cache maximum sql size user configurable.

CR:663926

CR Number:   663926 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description An INSERT into a table that contains computed columns which has been upgraded from ASE 15.0.3 may give Signal 11 (Access Violation) in norm3_expr(). Workaround Description  Drop & recreate the table. Drop computed columns before upgrade and restore afterwards.

CR:663945

CR Number:   663945 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 Apr 2011 Fixed Description When creating a functional based index, data may get truncated when using CONVERT().

CR:663967

CR Number:   663967 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 CGA Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2011 Fixed Description Running a dynamic sql query may hit SIGSEGV in s_normalize() in case of recompilation, together with stack trace involving modules s_reinstall_lwp_tree(), s_procinstall_lwp(), s_recompile() and tdsrecv__dynexec_xoltp().

CR:663977

CR Number:   663977 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Windows 2008 Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2011 Not a Bug Description syconfig from 15.5 ESDs fails with side-by-side error. Workaround Description  Use the 15.5 GA syconfig.

CR:663994

CR Number:   663994 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2011 Fixed Description Signal 11 could occur in CgEvals::_CgCompVcol(tree*) during DistinctHashing operator code generation when there are two distinct expression columns and one is becoming dependent on the other through equijoin transitive closure. Using diagserver, the assertion "Assertion (GcvIsVirtualColumn(pNode))" could fail in cgevals.cpp line 202. Workaround Description  set distinct_hashing off

CR:664112

CR Number:   664112 Product Name:   Adaptive Server Enterprise Product Component:   sqlloc Status:   Closed OS:   Solaris 11 Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2011 Fixed 30 Mar 2011 Fixed Description sqllocres does not check for valid default language/character set/sort order attributes in the resource file. Workaround Description  Use sort order file name: "sqlsrv.sort_order: binary.srt" Or sort order name: "sqlsrv.sort_order: bin_iso_1"

CR:664161

CR Number:   664161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2011 Fixed Description The message "current process infected with 11" in the module 'fglk__send_prom_attn' together with a stack trace which includes the modules 'fglk__promote' and 'getnext' may be reported in the error log and may bring the server down if a query involving a big number of tables (more than 50) was being executed in parallel and due to the number of locks acquired it attempted to promote the locks to a lock of a higher level. Workaround Description  Run the query in serial mode, for example, using SET PARALLEL_DEGREE 1.

CR:664218

CR Number:   664218 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2011 Fixed 05 Apr 2011 Fixed Description When sp_showoptstats is called with cross database objects, optimizer stats for that object is not returned and no error message is raised.

CR:664266

CR Number:   664266 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) 24 Oct 2011 Duplicate 10 Nov 2011 Duplicate Description Error: 8203 DES expected in DROP state in ssql__rmplans() Workaround Description  None known.

CR:664291

CR Number:   664291 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) 29 Aug 2011 Not a Bug Description Value of an empty string in date calculations is context sensitive Workaround Description  Don't use empty strings, specify dates precisly.

CR:664361

CR Number:   664361 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Guide for Windows Status:   Closed OS:   Microsoft Windows NT Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2011 Added to user documentation Description Docs: clarify "sybase" user account is not literally "sybase"

CR:664620

CR Number:   664620 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2011 Duplicate Description Suboptimal plan when use NOT in Subquery. Workaround Description  force the other plan. or use compatibility mode.

CR:664621

CR Number:   664621 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2013 Insufficient priority to fix Description Wrong result set in 1503 compatility mode with statement cache disabled Workaround Description  1) Change query to use: is null 2) Disable compatibility mode 3) Enable statement cache 4) Enable TF 304

CR:664703

CR Number:   664703 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) 07 Apr 2011 Fixed 20 Apr 2011 Fixed Description A query against an MDA table such as monLocks may encounter a timeslice error in VTABRemoteAccess::getNext() during a period of heavy user activity.

CR:664714

CR Number:   664714 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) 03 Mar 2014 Fixed Description Increase the limit on the number of historical configuration files saved from 999 to 999999999.

CR:664830

CR Number:   664830 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Currently one can bind tables or indices to a cache. Partitioned tables can have very active partitions which one might bind to specific caches. Workaround Description  none.

CR:664833

CR Number:   664833 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) 07 Apr 2011 Fixed 07 Apr 2011 Reservation Made 08 Apr 2011 Fixed Description Normally, if an attribute from a table inner to an outer join is referenced in a higher scope outer join or in the WHERE clause, it would cause the outer join to degenerate into an inner join since all null extended rows would be eliminated. The exception occurs with "null preserving" predicates such as IS NULL which would not eliminate the row. If a nested outer join exists where a table is inner to an outer join and an attribute of the table is referenced in second higher scope outer join ON clause in a "null preserving" predicate then a wrong answer could result when a mergejoin/hashjoin is chosen for the higher scope outer join. Workaround Description  Use 'set plan optgoal allrows_oltp' to avoid the merge join plan for the query. The customer uses 'set plan optlevel ase_default' for the query and get a different plan which works for them.

CR:664848

CR Number:   664848 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2014 Insufficient priority to fix 07 May 2014 One-off Provided 27 Apr 2014 Fixed 08 May 2014 Fixed 27 Oct 2014 Consult Complete 01 Jul 2014 Fixed 08 Jan 2015 Fixed Description In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 'ind__get_sysindrow()' together with a stack trace which includes the modules 'getindexname()' and 'CgGenLava::CGConsScanOp()' may be reported in the SAP ASE error log. This may happen when a statement, using temporary user tables or tables created in the same batch or stored procedure and with indexes defined, is being compiled before execution.

CR:664877

CR Number:   664877 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2011 Fixed 06 Oct 2011 Reservation Made 18 Oct 2011 One-off Provided 03 May 2012 Presently Not Targeted For Any Future Release Of This Product 11 Sep 2012 Presently Not Targeted For Any Future Release Of This Product Description CREATE INDEX on a large partitioned table may generate an excessive number of steps in sysstatistics. A subsequent UPDATE STATS reduces the number of steps to an expected value.