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

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

CR:462732

CR Number:   462732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2007 Fixed 26 Apr 2007 Reservation Made 22 Jul 2007 One-off Provided 19 Feb 2008 Fixed Description Inserting data into a partition other than the last partition of a table which has non-clustered indexes is very slow. Workaround Description  The client is working around the problem by adding a partition each day. This ensures that each day the insert is into the last partition. This is not satisfactory, since the table is unavailable each day, while the new partition is added.

CR:462810

CR Number:   462810 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Mar 2007 Fixed Description If the first parameter passed to the built-in reserved_pages() is an invalid database id, the error 913 will be raised with a fatal severity 22 instead of a user severity 16.

CR:462905

CR Number:   462905 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2007 Fixed 24 May 2010 Presently Not Targeted For Any Future Release Of This Product Description Update srvbuild/srvbuildres and its resource file to handle SDC cluster options

CR:462928

CR Number:   462928 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description enhance EFTS to support complex tags in XML doc and attribute-only zone searches where attribute names and attribute values are treated as zones.

CR:462937

CR Number:   462937 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2007 Fixed Description The HP-UX installer can't remove non-empty temporary directories when user exists the installer.

CR:462943

CR Number:   462943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2007 Fixed 12 Apr 2007 Not reproducible with latest version of the product available as of Resolution Date 08 May 2007 Reservation Made Description In some cases, outer join on view or derived table with CASE expression may return wrong result.

CR:462950

CR Number:   462950 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2007 Fixed 10 Apr 2007 Reservation Made 05 Nov 2007 Fixed Description Wrong result or error 325 (no legal plan found) could happen when a subquery from a view/derived table is referenced in the parent query block's WHERE clause.

CR:462956

CR Number:   462956 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2007 Fixed 11 Apr 2007 Not reproducible with latest version of the product available as of Resolution Date 10 Jun 2007 Fixed 10 Jun 2007 Fixed 02 Nov 2008 Fixed 04 Nov 2008 Fixed Description Queries involving IN clause may perform with high logical reads even if the index covers the query.

CR:462986

CR Number:   462986 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed 08 Oct 2007 Fixed Description Incorrect results may sometimes be returned when executing a query involving more than 2 tables with outer join on a non equality clause and using GROUP BY. Workaround Description  Disable nary nested loop join with traceflag 342

CR:462989

CR Number:   462989 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2007 Fixed 23 Mar 2007 Fixed 03 Aug 2007 Fixed Description Under rare circumstances, if the configuration parameters 'deadlock pipe active' or 'print deadlock information' are enabled or the switch 'print_deadlock_information' (traditionally trace flag 1204) is set, it is possible to get an error when trying to print the deadlock chain. The error text is "ubo_object_from_slot:Pss Invalid slot id <negative number>" followed by a stack trace that includes the modules pss_getunkept_pss() and lock__print_deadlockchain().

CR:463003

CR Number:   463003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2007 Fixed 15 Oct 2007 Fixed 21 Mar 2008 Presently Not Targeted For Any Future Release Of This Product 01 Apr 2008 Presently Not Targeted For Any Future Release Of This Product 01 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description When the result of messaging builtins (eg msgrecv, msgconsume) is obtained as TEXT datatype, and this result is converted to java.lang.String, we hit a stack trace. Workaround Description  None.

CR:463004

CR Number:   463004 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2007 Fixed 20 Apr 2007 Fixed 15 Oct 2007 Bundled Request Description Stack trace may result when the view definition has a group by all clause and the target list has columns which are not in the group by or the user query.

CR:463013

CR Number:   463013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed 01 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description When RTDS is disabled and a messaging built-in is executed, the transcation is left allocated instead of being rollbacked. Later, this lead to error 11068 as the left transaction can be reused but with an expected state.

CR:463040

CR Number:   463040 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Bundled Request Description When using messaging builtins (eg msgrecv, msgconsume) to return java.lang.String, if the return value is larger than 16k we get MEMMOVE error. Workaround Description  instead of using "msgrecv returns java.lang.String" use "msgrecv returns text" and then convert to java.lang.String

CR:463071

CR Number:   463071 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Abstract plan related errors 1024 - 1048 are not documented in the Troubleshooting Guide.

CR:463075

CR Number:   463075 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Installer and srvbuild use different default names for backup server and monitor servers when building new servers.

CR:463111

CR Number:   463111 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2007 Fixed 16 Apr 2007 Fixed 12.5.4 ESD#4 15 May 2007 One-off Provided Description When Q engines are onlined with ASE, messaging tasks and other DBMS tasks may hang. Workaround Description  Avoid onlining Q engines if native ASE messaging feature is not needed.

CR:463176

CR Number:   463176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2007 Fixed 14 Mar 2008 Fixed Description Schema count is not incremented correctly for a table when dropping a foreign key constraint on if a table has multiple foreign key constraints. A stored procedure using this table will not automatically be recompiled yielding a 3601 internal error.

CR:463216

CR Number:   463216 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Upgrade Notes Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2007 Added to user documentation Description Following upgrade or cross-platform dump and load, procedures are rebuilt from the source code in syscomments the first time they are run. Procedures that drop and then create an object may not upgrade properly and fail with an error that the object already exists. To get around this error, manually drop the object and run the procedure again, or put the CREATE statement within an EXECUTE IMMEDIATE context.

CR:463287

CR Number:   463287 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2007 Fixed 05 Apr 2007 Fixed 26 Mar 2007 Presently Not Targeted For Any Future Release Of This Product Description Error 11775 displays a negative number instead of the command name when encrypted columns is not enabled and an attempt to grant permission on encrypted columns commands is made.

CR:463356

CR Number:   463356 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2007 Fixed 06 Apr 2007 Fixed Description Previously when a table contains unsigned bigint columns, Data panel for the table would not show the data. This has been fixed. (Note Interactive SQL will show the data.)

CR:463374

CR Number:   463374 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2007 Fixed 21 Jun 2007 Fixed 21 Sep 2007 Fixed Description A 10852 message, "ASE is unable to get all the memory requested ...", may be reported when making a large increase to the size of a cache using sp_cacheconfig, despite sufficient memory being available.

CR:463412

CR Number:   463412 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Mar 2007 Fixed 14 May 2007 One-off Provided 02 Aug 2007 Fixed Description An incorrect remote sql statement could be generated for a proxy table when nested convert routines are used that specify a conversion style. The conversion style could be missing on the generated remote statement. Workaround Description  Modify query to avoid nesting of convert functions which set a conversion style.

CR:463456

CR Number:   463456 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 4.2 EBF #1 13 Aug 2007 Fixed Description Problem: When using Character Mapper component with cp932 encoded input and Japanese fonts installed, the multi-byte sequences are not mapped as expected. Resolution: The Character Mapper component requires that Unicode values are specified as <u{Unicode Decimal}> or <0x{Unicode Hexadecimal}> e.g. <u8256> ir<0x20A4>. The User Interface now automatically translates Unicode characters to the <u{Unicode Decimal}> notation.

CR:463465

CR Number:   463465 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2007 Fixed Description In rare circumstances, Adaptive Server may raise a 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later. etc." mistakenly, although one or more engines have local procedure cache available.

CR:463491

CR Number:   463491 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2007 Fixed 23 Nov 2009 Fixed 28 Mar 2008 Added to user documentation 24 Nov 2009 Fixed Description In this CR, a new column EngineNumber is added to the mda table monProcessNetIO. This new column is used to represent which Engine Number is used by a process. If a process need not network operation, this column will be NULL.

CR:463492

CR Number:   463492 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2007 Fixed 19 Jul 2007 Fixed 29 Jun 2007 Fixed 19 Jul 2007 Fixed 26 Jul 2007 Fixed 23 Jul 2007 Fixed Description Times recorded in historical server recording sessions do not properly adjust for DST 2007 changes.

CR:463505

CR Number:   463505 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2007 Fixed 01 Apr 2007 Fixed 05 Sep 2007 Duplicate Description Several new SET optimizer set commands will now be able to used at compile time to affect the optimizer in stored procedures or batches. Previously, the optimizer set commands would not take effect until the stored procedure was executed or recompiled. Note that care must be taken to reset the SET command prior from returning from the stored procedure, otherwise the execution of subsequent stored procedures may be affected. If it is intended that subsequent stored procedures should be affected, then the export_options feature should also be used, since the intention is for a later change to localize the following SET commands unless export_options is used (such as in a login trigger). The following SET commands were affected: DISTINCT_SORTED DISTINCT_SORTING DISTINCT_HASHING GROUP_SORTED GROUP_HASHING BUSHY_SPACE_SEARCH PARALLEL_QUERY ORDER_SORTING NL_JOIN MERGE_JOIN HASH_JOIN APPEND_UNION_ALL MERGE_UNION_ALL MERGE_UNION_DISINCT HASH_UNION_DISTINCT STORE_INDEX INDEX_INTERSECTION INDEX_UNION MULTI_TABLE_STORE_IND OPPORTUNISTIC_DISTINCT_VIEW ADVANCED_AGGREGATION REPLICATED_PARTITION GROUP_INSERTING ASE125_PRIMED AUTO_QUERY_TUNING QUERY_TUNING_MEM_LIMIT QUERY_TUNING_TIME_LIMIT SET PLAN OPTGOAL

CR:463518

CR Number:   463518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2007 Fixed Description A timeslice error may be occur in the module 'th__oam_extent_count' after an 11xx exception has occured. The modules 'ex_reraise_lasterror' and 'ex_raise' will be reported in the stack trace.

CR:463633

CR Number:   463633 Product Name:   Sybase ETL Product Component:   GUI Status:   Closed OS:   Windows XP Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2007 Fixed 08 May 2008 Fixed Description Problem: Data Calculator Java Script is not mapping multi-byte characters. Resolution: To use Unicode characters in a calculation rule, the uUniChr() function must be used for specifying the Unicode character.

CR:463634

CR Number:   463634 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2007 Fixed 12 Jun 2007 Fixed Description Error 325, "Adaptive Server finds no legal query plan for this statement. ..." when executing a union all with more than 8 union sides in serial. Workaround Description  For this specific query, an AP can be used to force a plan. select datalength(Stream), Stream, ID from MyTable where ID in (3303,3456,3457, 3458,3459,3460,3461,3666,3829,3939,4006,4023,4249,4273,4368,4400,4498,4552,4674, 4811,7621,8338,9219,9437,9809,9855,9878,9952,9959,10303,10919,10923,10943,10948, 10958,10968,10982,11104,11302,11527,11583,11949,12086,12166,12400,12543,12580, 18405,18413,18421,18543,18593,18723,18922,19100,19436,19520,19744,19887,19932, 19978 ,20349,21735,21774) union all select datalength(Stream), Stream, ID from MyTable where ID in (22175,22451,22452,22553,22555,22579,22580,22738,23710,23768,23793, 23797,23833,23851,23859,23879,23942,26072,26094,26336,28252,28575,28626,28639, 28725,28862,28863,28874,28892,29068,29322,29347,29362,29556,29558,29573,30000, 30253,30410,30511,30520,30719,30781,30861,31488,31782,32287,32535,32717,32733,32754, 32764,32863,33913,34013,34014,34072,34126,34195,34224,34243,34255,34286,34391) union all select datalength(Stream), Stream, ID from MyTable where ID in (34432, 34599,34606,34622,34886,34956,34986,34991,35069,35276,35418,35448,35707,35813, 35918,36019,36522,36561,36582,36747,36751,36782,36791,36844,36846,36848,36876, 36877 ,36884,36885,36886,36891,36901,36905,36918,36922,36924,36939,36949,36952,37023, 37044,37045,37048,37051,37056,37058,37059,37064,37068,37069,37072,37078,37084, 37085,37087,37096,37106,37107,37109,37111,37114,37118,37119) union all select datalength(Stream), Stream, ID from MyTable where ID in (37121,37122,37124,37126, 37127,37132,37133,37134,37166, 37167,37168,37169,37171,37172,37173,37179,37180,37182, 37183,37184,37185,37186,37188,37189,37193,37194,37195,37196,37197,37198,37199, 37208,37263,37264,37265,37266,37267,37268,37274,37275,37276,37278,37279,37280, 37281,37282,37283,37284,37285,37286,37287,37292,37293,37294,37308,37330,37333,37355, 37357,37363,37417,37426,37428,37430) union all select datalength(Stream), Stream , ID from MyTable where ID in (37431,37434,37435,37436,37450,37451,37455,37460, 37591,37749,37750,37752,37754,37755,37756,37757,37760,37763,37767,37799,37806, 37807,37826,37837,37839,37849,37850,37851,37854,37863,37963,38111,38173,38175,38288 ,38342,38358,38386,38426,38475,38566,38636,38637,38648,38735,38739,38803,38960, 39396,39502,39683,39790,39793,39895,39938,39965,40042,40292,40300,40642,40716, 40737,40927,40928) union all select datalength(Stream), Stream, ID from MyTable where ID in (41045,41071,41104,49542,49704,49825,49853,49980,50021,50082,50113, 50142,50195,50425,50484,50494,50501,50521,50523,50721,50725,50735,50748,50767,50769, 50774,50825,50838,50876,50893,50917,50918,51038,51049,51089,51153,51197,51233, 51301,51327,51329,51426,51599,51685,51694,51790,51791,51793,51844,51846,51851, 51865,51920,51939,51941,51960,52013,52015,52123,52184,52210,52213,52243,52245) union all select datalength(Stream), Stream, ID from MyTable where ID in (53294,53296 ,53661,53677,53737,53796,53934,54188,54639,54695,54900,54918,54972,54973,55067, 55071,55101,55172,55385,55386,55387,55389,55568,55632,55642,55653,55676,55945, 55968,55979,55981,56129,56138,56139,56173,56201,56278,56370,56387,56389,56519, 56537 ,56551,56620,56660,56721,56899,56928,56963,56986,57105,57139,57211,57422,57432, 57740,58028,58196,58244,58296,58742,59340,59354,59392) union all select datalength(Stream), Stream, ID from MyTable where ID in (59399,59402, 59404,59406,59419, 59763,59879,59906,59908,59913,59914,59948,59955,59965,60053,60103,60152,60210, 61197,61545,61610,61637,61836,61838,61978,62163,62258,62260,62264,62267,62271, 62273, 62276,62277,62285,62287,62289,62491,62633,62769,62857,62946,63023,63060,63094, 63105,63144,63213,63214,63274,63275,63360,63371,63377,63382,63383,63385,63726, 63834,63841,63871,63998,64018,64032) union all select datalength(Stream), Stream, ID from MyTable where ID in (64052,64158,64160,64162,64210,64509,64555,65677,65750 ,65810,65816,65820,65838,66003,66014,66099,66225,66248,66264,67491,67497,67550, 67558,67621,67631,67856,68128,68129,68134,68323,68436,68439,68445,68773,68965, 69209,69222,69237,69253,69259,69392,69494,69573,69575,69679,69855,70286,70783, 70907 ,71128,71841,71849,71852,71862,71866,71870,71875,71878,71890,71902,71908,71910, 71925,71926) plan " ( union_all ( nl_join ( t_scan MyTable@Gtt1 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt3 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt5 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt7 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt9 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt11 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt13 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt15 ) ( values ) ) ( nl_join ( t_scan MyTable@Gtt17 ) ( values ) ) ) ( prop MyTable@Gtt1 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt3 ( parallel 1) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt5 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt7 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt9 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt11 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt13 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) ( prop MyTable@Gtt15 ( parallel 1 ) ( prefetch 2) ( lru ) ) ( prop MyTable@Gtt17 ( parallel 1 ) ( prefetch 2 ) ( lru ) ) " go

CR:463675

CR Number:   463675 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 IP Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2007 Fixed 06 Apr 2007 Reservation Made 06 Apr 2007 Fixed 06 Apr 2007 Fixed 26 Jun 2009 One-off Provided 15 Oct 2007 Fixed Description A query like the following may get error 137 (Must declare variable '@@@V0_VARCHARorder'.) if statement cache and literal auto parameterization are enabled. For example: select b2 from t1 where a1 = 'TEST'order by b2 There is no blank between a literal value surrounded by single/double quote marks and a SQL keyword. Workaround Description  (1) Add a blank into between a literal value and a SQL keyword manually. (2) set literal_autoparam off (3) set statement_cache off (4) dbcc purgesqlcache (to clean up a wrong parameterized statement after this error occurs) (5) Trace flag 7722 (if it is acceptable to parameterize and cache only insert statements)

CR:463716

CR Number:   463716 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2007 Fixed 06 Jun 2007 Fixed 02 Apr 2007 Reservation Made Description Under rare circumstances, a query using views and nested aggregates results in a Signal 11.

CR:463735

CR Number:   463735 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed 08 Oct 2007 Fixed Description In some cases, queries containing aggregation with GROUP BY and a mixture of nullable and non-nullable columns can lead to wrong results or divide-by-zero errors (if the AVG aggregate is present). The error will only occur if the optimizer chooses a query plan that contains a materialization step for the aggregation results (This can be seen from the showplan output by the presence of a STORE operator).

CR:463752

CR Number:   463752 Product Name:   Adaptive Server Generic Docs Product Component:   Java in Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2009 Added to user documentation Description Document deterministic behavior of Java functions in expressions

CR:463772

CR Number:   463772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2007 One-off Provided 23 Apr 2007 Fixed 16 Jul 2007 Fixed 30 Apr 2007 Fixed Description DUMP TRANSACTION <db> WITH STANDBY_ACCESS is not forwarded to Replication Server. This command allows a database that has been loaded with that transaction log dump, to be brought online between loads. This is possible because this command only dumps completed transactions. In a replication environment using coordinated dumps, a dump tran with standby_access that was successfuly run on the primary may fail when RS attemps to apply it into the replicated database as it may not find a quiesce point in the transaction log of the replicated database. Workaround Description  None at this time; cannot use the standby_access option

CR:463795

CR Number:   463795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2007 Fixed 18 Nov 2007 Fixed Description Using tsequal() builtin function within stored procedure could caused stacktrace.

CR:463837

CR Number:   463837 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2007 Fixed Description In some situations, a query with outer join between a view and derived table might return wrong result.

CR:463885

CR Number:   463885 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed 18 Jan 2008 One-off Provided 05 Nov 2007 Fixed Description sig11 could happen in LeSarg::mapSarg() during execution when there is a vector aggregate operaor (GroupBy) or union operaor under a three-way or more nested loop join (NaryNlJoin).

CR:463895

CR Number:   463895 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2007 Fixed Description Signal 11 could happen in CgEvals::_CgCompVcol() for an outerjoin whose's ON clause contains a joining expression and the expression involves a column which also participates in another equijoin predicate. For example, (t1.c1=t2.c1 and t1.c2=t2.c1+5). Workaround Description  turn off merge join.

CR:463898

CR Number:   463898 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed Description Error 442 might be hit for a query plan which uses a local index with more than 512 partitions if the ordering from the local index is considered useful (e.g. for min() aggregate or OrderBy). Workaround Description  There are two possible workaround: 1. create a global index instead of the local index. Even after the fix, the local index won't be useful for the min() handling in a serial plan. 2. configure enough worker threads (> 514) and parallel degree (> 514) so that a parallel plan with xchg above the indscan can be used.

CR:463908

CR Number:   463908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed Description Update installmaster script to include fixes for the following ODBC, OLE DB and jConnect Driver CRs fixed: CR 438735 - ODBC Driver by Sybase: Unexpected behavior in Crystal Reports when connecting using ODBC Driver, because SQLProcedureColumns returns ?NO? for IS_NULLABLE. CR 416248 - ODBC Driver by Sybase: SQLColumns returns type name varchar for timestamp data type. CR 416250 - ODBC Driver by Sybase: SQLColumns returns type names varchar and char for nvarchar and nchar data types respectively. CR 438423 - ODBC Driver by Sybase: Accessing ASE using ODBC Driver from Microsoft Access 2003 causes reserved error (-7707). CR 420176 - OLE DB Provider by Sybase: Unable to execute queries from Microsoft SQL Server using a Sybase ASE linked server. CR 427244 - jConnect: Calling DatabaseMetaData.getProcedureColumns when auto-commit mode is off raises SybSQLException: SELECT INTO command not allowed within multi-statement transaction. CR 442470 - jConnect: DatabaseMetaData.getTypeInfo call no longer returns ASE Local type of "double precision". CR 443327 - jConnect: DatabaseMetaData.getTypeInfo returns internal ASE system user types (like longsysname) which should not be returned.

CR:463919

CR Number:   463919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2007 Fixed 18 Nov 2007 Fixed Description The problem occurs for complex queries which contain many composite joins as well as equi-sargs on joining columns, and descending index columns. The failure occurs due to incorrect handling of composite orderings when a descending attribute is in the composite ordering, and an equi-sarg exists on another attribute of the composite ordering. Workaround Description  Disable merge join via 'set merge_join 0'. ------------------------------------------------------------------------------------------ Tested this workaround inhouse, the customer's feedback regarding the workaround: ---------------------- >Yes this allows the query to execute without terminating however when >I run the query with the GROUP BY clause it returns no rows. If I >take the GROUP BY clause out it returns 39 rows. I'm not sure this >is correct - how can a group by alter the number of rows returned? > >I'm not sure we could use this as a workaround as our PeopleSoft >applications are written generically for multiple database vendor >platforms and we don't have a facility to fire a sybase-specific 'set >merge_join 0' statement on a per-query basis. We would have to turn >this on globally for all sybase sql statements and I'm uneasy about >making a global performance change. (please see subcase notes for more info) -------------------

CR:463959

CR Number:   463959 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2007 Fixed Description sp_dbcc_recommendations gives incorrect recommendation for error 100028. This error results when checkstorage finds data on a different segment than that of the table to which it belongs.

CR:463988

CR Number:   463988 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2007 Fixed 10 Apr 2007 Bundled Request Description On AIX platform, a 19608 error, "no such parameter 'directio' " reported when changing directio parameter with deviceattr stored procedure

CR:464036

CR Number:   464036 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed 08 Oct 2007 Fixed Description Wrong result could happen if there is an OR predicate and one OR term appears in all the disjuncts of the OR predicate (in other words, the OR term can be extracted out as the common predicate and the origial OR predicate can be removed). For example, ((t1a.c1a = 9 AND t1a.c1a > t1b.c1a) OR t1a.c1a > t1b.c1a).

CR:464049

CR Number:   464049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2007 Fixed Description Signal 11 could be hit in CgEvals::_CgCompLogOp() if there is an OR predicate and one OR term appears in all the disjuncts of the OR predicate (in other words, the OR term can be extracted out as the common predicate and the origial OR predicate can be removed). For example, ((t1a.c1a = t4a.c3 AND 0 > t4a.c3) OR t1a.c1a = t4a.c3 )).

CR:464150

CR Number:   464150 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 May 2007 Fixed Description Disallow user from changing the default database if login trigger is active.

CR:464171

CR Number:   464171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2007 Fixed 05 Apr 2007 Reservation Made Description Deleting system table rows is not enough for downgrade; the anchors pointing to those rows must also be deleted. Otherwise subsequent upgrade will fail because the booting server can still find the deleted rows, so ASE will think the table still exists.

CR:464186

CR Number:   464186 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2012 Fixed 09 Nov 2011 Reservation Made 20 Dec 2011 Fixed Description A new MDA table, monSpinlockActivity, is introduced to track spinlock activity.

CR:464192

CR Number:   464192 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2007 Fixed 24 Jun 2008 Fixed 25 Jul 2008 Fixed Description In some circumstances, the message "current process infected with 11" together with a stack trace that includes the modules "fdpr_glue_tramp_align__fdpr", "conn_hdlr__fdpr", may be reported when using XML features on IBM Linux Pseries platform.

CR:464435

CR Number:   464435 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2007 Fixed Description During replication of element, simpletype and complextype, Annotation object is not longer synchronized

CR:464456

CR Number:   464456 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2007 Fixed Description Server may give error# 325 (finds no legal query plan for this statement) when group_hashing is off and the query has GROUP BY on an expression.

CR:464489

CR Number:   464489 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2009 Fixed Description The error 'Error while parsing ASE version string 12.5.3a' would be reported when migrating ASE 12.5.3a to other versions with migration tool. Workaround Description  using the 12.5.3a sybmigrate to migrate

CR:464491

CR Number:   464491 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2007 Fixed 21 Apr 2007 Fixed 03 Jul 2007 Fixed 28 Aug 2007 Fixed Description When a resource governor limit is detected and causes a query to abort while that query is creating a work table for the benefit of a hash operator, then a stack trace may be produced.

CR:464504

CR Number:   464504 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2007 Fixed Description Error message 403 (Invalid operator for datatype op: = type: VOID TYPE.) could be raised when a DISTINCT view is used and one of the view projection is a constant.

CR:464605

CR Number:   464605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   carina Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 09 Aug 2013 Fixed 15.7 SP121 29 Oct 2013 Fixed 09 Aug 2013 Reservation Made 02 Dec 2013 Fixed Description The "enable large pool for load" configuration parameter is added to configure the use of large buffer pools during the recovery phase for LOAD DATABASE and LOAD TRANSACTION commands execution. This configuration parameter will default to 0 if "enable functionality group" is set to 0, and to 1 if "enable functionality group" is set to 1.

CR:464614

CR Number:   464614 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE 12.5.3 ESD#4 64-bit on Solaris hits signal 11 in ind__sysides_grab+0x4c() due to null pointer in allocated IDES buffer returned by uboalloc() from the rsysides_mempool: > (ind__sysides_grab+0x4c), siginfo (code, address) = (1, 0x0000000000000028)

CR:464630

CR Number:   464630 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.2 02 Apr 2007 Fixed Description When an expirable license is obtained on grace the date of expiry of the license is reported instead of the date of expiry of the grace period. The expiry of grace periods for permanent licenses is reported correctly.

CR:464647

CR Number:   464647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2007 Fixed 13 Oct 2007 Fixed Description Wrong result could happen for mergejoin/hashjoin which contains a joining expression and the expression involves a column which also participates in another equijoin predicate. For example, (t1.c1=t2.c1 and t1.c1=t2.c2+t1.c2). Workaround Description  Turn off mergejoin or hashjoin.

CR:464667

CR Number:   464667 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2007 Fixed 12 Oct 2007 Reservation Made 11 Dec 2007 Presently Not Targeted For Any Future Release Of This Product Description 701 errors may be raised and/or procedure cache thrashing for queries containing hash and/or sort operators with large estimated input sets. Buffer requirements increase as the operator's estimated input set size does. This had a secondary impact on contiguous memory requirements in the procedure cache. Contiguous memory requirements to manage hash and sort operator buffers has been eliminated.

CR:464683

CR Number:   464683 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2007 Fixed 01 Aug 2007 Fixed 21 Aug 2007 Fixed 23 Aug 2007 Fixed Description When permission is granted to a user to alter an encryption key, which is not a grantable command, Adaptive Server fails to report Msg. 4607.

CR:464698

CR Number:   464698 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2007 Fixed 27 Jun 2007 Reservation Made Description The user can enable/disable rtds provider separately. When the user enables or disables one rtms provider, the other enabled providers are not affected.

CR:464711

CR Number:   464711 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2008 Duplicate Description DBIQL for ASE Edition cannot execute an output statement in non-gui mode. So as to output a result to HTML or Excel, please choose an export menu in gui mode.

CR:464715

CR Number:   464715 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Open OS:   Solaris Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The ASE management tool of a Web base does not exist in ASE. The user wishes to have the management tool of a Web base.

CR:464760

CR Number:   464760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2007 Consult Complete 11 Apr 2007 Not a Bug 03 May 2007 Fixed 14 May 2007 Fixed 26 May 2007 One-off Provided 16 Mar 2008 Fixed 04 Sep 2008 One-off Provided Description Login to ASE using LDAP may hang with the message "Waiting for native threads to be released, or for 'max number of ldapua native threads' to be increased." even after increasing value of 'set_max_ldapua_native_threads'.

CR:464790

CR Number:   464790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2007 Fixed Description On IBMAIX64 systems, a 5846 error, "Illegal value <value> specified for configuration option 'max async i/os per engine'" will be reported when trying to set the value to its default using sp_configure. Workaround Description  Find out the default value and use that in sp_configure. sample. sp_configure "max async i/os per engine" , 4096

CR:464797

CR Number:   464797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Digital UNIX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed 10 Apr 2007 Fixed 28 Jun 2007 Fixed Description The error "Current process infected with signal 11 (SIGSEGV)" followed by the text 'Error at address 0x0000000000000000' will be raised in DEC AXP when trying load or drop an archive database.

CR:464803

CR Number:   464803 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2008 Fixed Description Problem: When inserting multi-byte characters into a UTF-8 collation DB, it can appear inserted data is missing. For example: If the target column is defined as CHAR(10) and you have 5 characters that you believe are 2 byte characters but you notice some are missing. (2 bytes * 5 characters = 10 bytes). Resolution: UTF-8 can represent 1-3 byte characters. If some characters are 3 byte characters the total length calculations will need to take this into account.

CR:464805

CR Number:   464805 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2007 Fixed 06 Feb 2008 Fixed Description After loading a database that requires upgrade, a user who is DBO but does not have sa_role or oper_role will not be able to bring that database online. ASE reports Msg 968 'Database [name] is not upgraded and hence is not available for access'.

CR:464813

CR Number:   464813 Product Name:   Sybase ETL Product Component:   pEngine Status:   Closed OS:   Windows 2003 Original Version:   4.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2008 Not a Bug Description Problem: The following ETL error occurs when updating multi-bytes data (932JPN) on IQ (EUC_JAPAN) database: Unable to execute project: Unable to execute component: DB Data Sink Update: Unable to write data to destination: Executing prepared statement failed. Unknown error during code page conversion. Resolution: The source data, when interpreted as the specified encoding windows-932, contains code points which are not convertible to the eucjis encoding used by an IQ server configured with the EUC_JAPAN collation. To resolve this, use code points that are mapped in both encodings.

CR:464843

CR Number:   464843 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2007 Fixed 18 Apr 2007 Fixed 07 Sep 2007 Duplicate Description Use of SET FORCEPLAN in 15.0.1 ESD 1 and ESD 2 can result in AP errors

CR:464847

CR Number:   464847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed Description A 675 error, "Invalid Buffer Cache Access: Attempt to locate page <pageno>, database <dbid> in cache failed because no object id was specified. scan_context={objid <objid>, indid <indid>, cid <cid>}. Contact Technical Support for Assistance." with 2 assertions prior to it may be reported when creating global nonclustered index on partitioned APL table whose first non-empty data partitions is not its first data partition. Workaround Description  Use alter table <tabname> drop partition <partition_name> to drop empty partitions and retry the create index command.

CR:464860

CR Number:   464860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2007 Fixed 11 Jul 2007 Fixed Description HP-UX uninstaller can't remove softlinks.

CR:464977

CR Number:   464977 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2010 Insufficient priority to fix Description Currently ASE versions, 12.5.x and 15.x, do not release any unused shared memory - known as the "unshrinking memory" feature. It would be an advantage for future ASE design to implement "shrinking memory" function and global shared memory pool for multiple ASE instances to even out their flunctuating workloads through optimal load balancing.

CR:465008

CR Number:   465008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2010 Not a Bug Description Feature request for a formal SET option that would allow assignment to a variable using SELECT to operate on every every row in the result set rather than just the last. This behavior is currently available using traceflag 7703, or by using UPDATE SET (although UPDATE will fire the update trigger).

CR:465014

CR Number:   465014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2007 Fixed 03 May 2007 Not reproducible with latest version of the product available as of Resolution Date Description ASE may send incorrect SQL to the remote server resulting in syntax error when a local table is joined with a proxy table and the WHERE clause contains IN or OR clauses on 'date' or 'time' columns. Workaround Description  Customer reported that a convert(date, proxy_date_col) stops the error. In my tests this prevented the bad WHERE clause from being sent to the IQ server but also caused the join to return no rows.

CR:465023

CR Number:   465023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2007 Fixed 15 Jun 2007 Fixed Description Various "out of locks" conditions can prevent the 'sa' user from logging in ASE. As the 'sa' user cannot login, steps cannot be taken to terminate users who are consuming too many locks, or attempt to increase the "number of locks" configuration parameter.

CR:465027

CR Number:   465027 Product Name:   Sybase ETL Product Component:   other Status:   Closed OS:   Windows 2003 Original Version:   4.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2008 Workaround Description Problem: ETL will allow the user to register Grid Nodes that are not properly licensed. Workaround: Some Grid Nodes are only allowed to be used with the packaged Development UI. Do not register them as they will not be able to run jobs outside the appropriate license restrictions.

CR:465145

CR Number:   465145 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2007 Fixed 27 Jul 2007 Fixed Description When FMTONLY option is on, queries run slower than 12.5 and some execution status are shown as if the query is executed. When cursor FETCH statements are run with FMTONLY option on, the queries may 'hang' as the end of scan for the FETCH is never reached.

CR:465159

CR Number:   465159 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2007 Fixed Description After a successful upgrade via syconfig, a lot of tmp files are left in the SYBASE/ASE-15_0/init/logs directory (tmp1, tmp11, tmp111, tmp1111, etc.)

CR:465174

CR Number:   465174 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2007 Fixed Description Message 584 "Explicit value specified for identity field in table '%.*' when 'SET IDENTITY_INSERT' is OFF." displays the wrong table name in some cases. Similarly Message 585 "Explicit value must be specified for identity field in table '%.*s' when IDENTITY_INSERT or IDENTITY_UPDATE is ON." displays the wrong table name in some cases.

CR:465184

CR Number:   465184 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2007 Fixed 30 Oct 2009 Fixed 30 Oct 2009 Fixed Description Failed to get permission error in a cluster environment when the permission is revoked on one node.

CR:465196

CR Number:   465196 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2007 Fixed 15 Sep 2008 Fixed Description The execution of some store procedures may result in "infected with 11" errors and stack traces that include proc_replace and s_recrtproc after upgrading.

CR:465198

CR Number:   465198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2008 Fixed Description infected with 11 in OptGlobal::_GblInitPopRules due to size of 0

CR:465229

CR Number:   465229 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2007 Fixed Description Queries with large IN-lists (i.e. where col1 in (1,2,3,...10000)) would generate error 3626 (Stack overflow) with the default stack size and would require reconfiguring the stack size to as much as several MB to run successfully. With this fix, the default stack size is sufficient to run queries with several thousand elements in the IN-list.

CR:465234

CR Number:   465234 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed 19 Apr 2007 Fixed 02 Aug 2007 Fixed Description Put fix for CR 445676 under trace flag 1236 to remove undetected deadlocks.

CR:465255

CR Number:   465255 Product Name:   Adaptive Server Enterprise Product Component:   syconfig Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2007 Fixed 26 Jul 2007 Fixed Description AS options screen shown along with Finished screen when configurating a new sqlserver successfully using syconfig.

CR:465266

CR Number:   465266 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2007 Insufficient priority to fix Description ASE allows direct insert of IDENTITY values in some circumstances although SET IDENTITY_INSERT is not set ON.

CR:465288

CR Number:   465288 Product Name:   Adaptive Server Enterprise Product Component:   sybconfig Status:   Closed OS:   Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2007 Fixed Description Sybase Unified Agent is not added to the Windows service on Windows 64-bit.

CR:465293

CR Number:   465293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2007 Fixed 18 Apr 2007 Fixed Description A SQL statement that contains an expression subquery which returns a non-nullable result datatype can lead to a 530 error. The error will occur if the expression subquery qualifies no rows and thus returns NULL and the query plan requires the subquery result to be stored in a worktable (The worktable can be seen by the presence of a STORE operator in the showplan output). Workaround Description  Use trace flag 7721.

CR:465296

CR Number:   465296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2007 Fixed 10 Apr 2007 Reservation Made Description A new configuration parameter has been added to limit the maximum number of buffers that can be allocated per lava operator. It is called "maximum buffers per lava operator". It is analagous to the "number of sort buffers" parameter. However, it is applicable to hash operators and sort operators used in Lava query plans. The "number of sort buffers" parameter is now only applicable to sorts used in "create index" processing. Because the number of buffers allocated can have a second order effect on the amount of contiguous memory required to track them, this parameter can be lowered to alleviate "out-of-memory" (701) errors. The default is 2000.

CR:465301

CR Number:   465301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2007 Fixed 13 Jun 2007 Fixed 13 Jun 2007 Fixed Description With "max parallel degree" configured to more than 1, statements that reference encrypted columns with the decrypt default property can cause ASE to stacktrace with a "Worker Process internal plan copy error for EVAL E_DECRYPT_PERM" message.

CR:465306

CR Number:   465306 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Apr 2007 Fixed 11 Apr 2007 Reservation Made 18 Jan 2008 Fixed Description When upgrading an installation that has Job Scheduler enabled, the booting (new) server can report error 11031. After this occurs, upgrade will hang in database 'sybmgmtdb', waiting for a lock that cannot be granted.

CR:465375

CR Number:   465375 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2007 Fixed 15 Jun 2007 Fixed Description Under some circumstances a complex query can timeout in the optimizer while searching for the best plan before it looks at the kind of plans that 12.5 would have generated. The result is a poor plan. In addition no message was displayed to indicate that the optimizer had timed out while searching for the best plan.

CR:465377

CR Number:   465377 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 May 2007 Fixed 15 May 2007 Reservation Made 31 May 2007 Fixed Description Follow on with issues raised with respect to performing an asynchronous I/O after an APL split.

CR:465382

CR Number:   465382 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2007 Bundled Request Description When trace flag 2511 is active, ASE will suppress reporting the message 15082 during DBCC checks.

CR:465389

CR Number:   465389 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2008 Bundled Request Description In rare circumstances ASE may infinitely print the same PROC_KPSCKPIDBADSTAT messages.

CR:465438

CR Number:   465438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2007 Fixed Description The REORG REBUILD command run on a replicated database with DDL on should not be replicated, either, the internal SQL such as ALTER TABLE generated during its processing.

CR:465440

CR Number:   465440 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2007 Fixed 19 Apr 2007 Fixed Description Error message 530 (Attempt to insert NULL value into column 0 in work table; column does not allow NULLS. UPDATE fails) could be raised when there is a join predicate with an expression and each column in the expression is involved in another equijoin predicate with some other column.