远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:438358
CR Number:   438358
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2006 Duplicate
Description
sp_listener does not supply its subcommands when called without arguments.
Workaround Description
 Rewrite the sproc yourself to do it.



CR:438389
CR Number:   438389
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)
21 Aug 2006 Not a Bug
11 Aug 2006 Fixed
Description
SEGV could happen in LeHashContext when executing a nested outerjoin

query involving remote tables.



CR:438406
CR Number:   438406
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Fixed
Description
Fail to download report log file when the SC client and SYSAM server are on different machines.



CR:438458
CR Number:   438458
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2006 Duplicate
Description
When building server from installer of ASE, installer uses 120MB as a default value of sybsystemprocs as a wrong value.
Workaround Description
 Please select custom installation. As for default value, 132MB is used.



CR:438509
CR Number:   438509
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2006 Fixed
Description
An UPDATE may incorrectly set varchar column to NULL value instead of a single space.

This happens if the UPDATE is executed in the stored procedure and the value

to be set is passed as the procedure parameter and represents a string of spaces.

This problem happens only if the option string_rtruncation is set.
Workaround Description
 Each of the workarounds listed below can be used.

a) When using -G parameter for ESQL, the length of the variable that is

used to update the column should not be bigger than the column size.

b) Use trace flag 7709.

c) Do not use CS_OPT_STR_RTRUNC in ESQL or set string_rtruncation.



CR:438558
CR Number:   438558
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2006 Fixed
Description
The error 678 "Invalid Buffer Cache Access: Could not open object <value> in database <value>"

may be raised followed by the message "Illegal attempt to rollback transaction (xactname

'$chained_transaction') that has already committed" when committing a transaction that has

a select into command followed by a drop of the table just created. The problem is restricted

to use of large page allocation, objects with Data-Only-Locking, databases with "ddl in tran"

active and "set chained on" option.
Workaround Description
 Do not use datarows as the default locking scheme OR

turn off large page allocations with trace flag 1101 OR

make the select into cmd produce an APL vs. DOL table

(into #test lock allpages)



CR:438569
CR Number:   438569
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2006 Fixed
21 Nov 2006 Presently Not Targeted For Any Future Release Of This Product
22 Nov 2006 Fixed
29 Nov 2006 Fixed
20 Nov 2006 Fixed
30 Nov 2006 Presently Not Targeted For Any Future Release Of This Product
29 Nov 2006 Fixed
12 Aug 2007 Fixed
Description
In console mode installation, line up the list of location tidily on Japanese environment.



CR:438621
CR Number:   438621
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Duplicate
Description
Request a compilation option for stored procedures that would optionally convert non-existing static object syntax to dynamic execution for those objects. Prefer that the syntax changes to the stored procedure all be made transparent to the customer with suitable warnings.
Workaround Description
 Use existing static procedures with some dynamic syntax



CR:438656
CR Number:   438656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2006 Fixed
12 Sep 2006 Fixed
12 Sep 2006 Fixed
Description
Configuring ASE15.0.1 for High Availability on IBMAIX/HACMP cluster fails because the haisql binary cannot be loaded properly.
Target Version
 15.0.1 ESD#1



CR:438660
CR Number:   438660
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2006 Fixed
20 Nov 2006 Not a Bug
26 Sep 2007 Not a Bug
Description
SELECT queries may result in getting the system date, causing degradation in query performance.



CR:438703
CR Number:   438703
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2006 Fixed
Description
The option WITH NO_INFO is added to the SET SWITCH command syntax to suppress any informational

warning being sent to the client. This option has only effect on informational warnings, error

messages when necessary are still being raised.
Workaround Description
 n/a



CR:438705
CR Number:   438705
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2006 Fixed
02 Nov 2006 One-off Provided
16 Oct 2006 One-off Provided
25 Oct 2006 One-off Provided
22 Nov 2006 Fixed
22 Nov 2006 Fixed
15 Dec 2006 Fixed
Description
Under very rare circumstances, a 694 error reading "An attempt was made to read logical page '<Page Number',

virtpage '<PageNumber>' from virtual device '<DeviceNumber>' for object '<ObjectId>' in database '<DbId>'. The page

was not read successfully. You may have a device problem or an operating system problem." may be raised

for a page belonging to the log segment.



CR:438707
CR Number:   438707
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 ESD#1 29 Aug 2006 Fixed
Description
Fixed the segment fault(core dump) while discovering the interface from ldap server on sunx64 platform.



CR:438723
CR Number:   438723
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2007 Fixed
Description
ALTER TABLE may raise error 206 when adding or modyfying a column and defining a

complex constrainst in the same statement.
Workaround Description
 Run two ALTER TABLE commands separating DEFAULT and CHECK creation



CR:438732
CR Number:   438732
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2006 Fixed
Description
Comments generated as part of template job commands in lanaguages that don't use spaces will not display properly in Template and Job wizard summarys.



CR:438748
CR Number:   438748
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2006 Fixed
Description
When user select 'No' on the change password option, when 'expire password' option is set, the connection is not released. This fix addresses this issue by closing the 'pre expired login connection'.



CR:438754
CR Number:   438754
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
19 Sep 2006 Fixed
19 Sep 2006 Fixed
Description
Error 806: Severity 21: State 1 may occur in some rare cases due to

exhaustion of time slice during rollback.



CR:438815
CR Number:   438815
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)
16 Aug 2006 Fixed
16 Aug 2006 Fixed
24 Aug 2006 Fixed
30 Aug 2006 One-off Provided
Description
In rare circumstances, The message "current process infected with 11" in the module

'LeHashContext::HashVtuple' together with a stack trace which includes the modules

'LeHashContext::GetNext' and 'LeHashContext::ProcessTuple' may be reported in the error

log when tempdb is bound to a name cache and the ASE is using a HASH operator to execute

the query. Other stack traces including modules like 'LeAlignedDataRow::readRow' and

'LeHashBufferReader::GetNext' are seen as well. The diagserver reports a 685 error.
Workaround Description
 Do not bind tempdb to a cache other than default data cache.



CR:438822
CR Number:   438822
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2006 Fixed
Description
The message "The front end tool you are using does not support the feature

of bulk insert from host, please use the proper tools for this command."

may be raised followed by the message "current process ... infected with 11"

in module bufauxuninstall() during a bulk insert operation.



CR:438848
CR Number:   438848
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2007 Fixed
Description
On servers running multiple engines the data returned by queries on the monIOQueue Monitoring Table may be incomplete.



CR:438854
CR Number:   438854
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)
11 Aug 2006 Fixed
23 Aug 2006 One-off Provided
17 Oct 2006 Fixed
Description
A batch inserting data to the table which has a default referencing global variable may fail if there are some other global variables referenced in the same batch. Stack trace shows module subglobals().
Workaround Description
 use statements accessing global variables ina separate batch :

INSERT t1 (c1) VALUES (1)

go

SELECT @@rowcount

go



CR:438858
CR Number:   438858
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2006 Fixed
Description
Error 14617: Severity 23: State 1, may occur when dbcc checkcatalog is executed due to a mismatch between the master device row location in sysdevices and the the corressponding anchor.



CR:438859
CR Number:   438859
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2009 Fixed
Description
The message "The database page size of 2048 bytes obtained from ASE is different from the database page size of -1024 bytes read from the dump header." appears in error at the end of the output for LOAD with LISTONLY against a remote backupserver.



CR:438941
CR Number:   438941
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2006 Fixed
22 Nov 2006 Fixed
17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
SUBQUERY: Occasionally, a sub-optimal plan is chosen when the query contains a subquery from an IF EXISTS clause. This is resolved under traceflag 15371.
Workaround Description
 There are several work-arounds:

select @c = count(*) ....

if(@c > 0) ....

instead of

if exists (select *...)



The ct is currently using the following workarounds:

Workaround #1



set forceplan on



if exists (select 10

from SWIFT_PrimDocToDelDoc s (index I_DocID), AddDFMDoc d (index Index_4)

where s.DocID=3227404 and s.IsTransact=1 and s.ID_MESS=d.ID_MESS and

d.DFMDocID!=0)

select 1



set forceplan off





Workaround #2



if exists (select 10

from SWIFT_PrimDocToDelDoc s (index I_DocID), AddDFMDoc d (index Index_4)

where s.DocID=3227404 and s.IsTransact=1 and s.ID_MESS=d.ID_MESS and

(d.DFMDocID>0 OR d.DFMDocID<0))

select 1



CR:438980
CR Number:   438980
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
12 Dec 2006 Fixed
Description
In 15 realeases (15.0.1 and earlier) queries with two or more outer joins may return wrong results (too many rows). This can occur when there is a predicate on the inner member of an outer join that will eliminate all null-supplied rows for that outer join. This predicate effectively "degenerates" the outer join into an inner join. If the predicates for the "degenerating" outer join should in turn degenerate another outer join, then wrong results could occur. For example,



select * from

(t1 left join t2 on t1.a = t2.b) -- OJ #1

left join t3 on t2.b = t3.c -- OJ #2

where t3.c = 5



In this query, the where-clause predicate "t3.c = 5" will eliminate all null-supplied rows from OJ #2. This in turn will result in all null-supplied rows from OJ #1 being eliminated. This problem has been fixed.



CR:439024
CR Number:   439024
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2006 Fixed
Description
When a table with a JAVA ADT computed column is marked for replication using sp_setrpetable, the JAVA ADT columns are internally set to no-computed column, which causes DML on this collumn to be returned with inaccurate results.
Workaround Description
 set the table replicated using sp_setreplicate

sp_setreplicate object_name, {true |false}

Set the text, image, or off-row object column replicated using sp_setrepcol, by entering:sp_setrepcol table_name [, column_name

[, {do_not_replicate | always_replicate |

replicate_if_changed} [, use_index ] ] ]



CR:439123
CR Number:   439123
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)
02 Mar 2010 Fixed
02 Mar 2010 Reservation Made
Description
With low cardinality tables i.e. the number of rows is less than the number of steps in a histogram, then there is a possiblity of having a 1 row range density selectivity, where the range density should be 0.0



optcriteria cr439123 needs to be on to see the change.
Workaround Description
 Edit optdiag statistics



CR:439173
CR Number:   439173
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)
16 Aug 2006 Fixed
Description
An insert into a proxy table that has an identity column and is mapped to an ASE does not set @@identity on the local server.



CR:439198
CR Number:   439198
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
Description
A stacktrace or error 325 (no legal plan found) could happen for a DISTINCT query on a UNION ALL derived table/view and the DISTINCT column is an expression from the UNION ALL.
Workaround Description
 Two suggestions:



select count(distinct convert(varchar, num_seq_autoriz))

from (select ano_autoriz + convert(varchar, num_seq_autoriz), num_seq_autoriz

from tb_xxx

union all

select ano_autoriz + convert(varchar, num_seq_autoriz), num_seq_autoriz

from tb_xxx ) t

go



or



select count(distinct teste)

from (select convert(varchar, num_seq_autoriz) teste

from tb_xxx

union all

select convert(varchar, num_seq_autoriz) teste

from tb_xxx ) t

go



CR:439200
CR Number:   439200
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2007 Duplicate
Description
Delete queries with group by aggregate in correlated subqueries may execute slower as compared to 12.5.



CR:439211
CR Number:   439211
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2006 Fixed
Description
View containing subquery when called in select will cause infected with 11



CR:439236
CR Number:   439236
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2006 Fixed
Description
If statement cache is enabled, the value of the global variable @@error will be reset

if it is accessed in a batch together with a statement that gets cached.
Workaround Description
 Place the select @@error out of the batch.



CR:439269
CR Number:   439269
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)
18 Aug 2006 Fixed
Description
A SELECT with ORDER BY on a bit column may return the rows in descending order if there are more than four columns of bit datatype.



CR:439273
CR Number:   439273
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)
05 Mar 2012 Not a Bug
Description
CREATE INDEX w/ SET STATISTICS IO on does not display logical reads only display write



CR:439391
CR Number:   439391
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2007 Fixed
Description
The message "Msg 701, Level 17, State 3: Server 'XXXX', Line 1: There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache." can be generated by queries involving UNION of a large number of tables.
Workaround Description
 session level



set parallel_query off

or

set ase125_primed on



server level

dbcc traceon(15305)



CR:439399
CR Number:   439399
Product Name:   Adaptive Server Generic Docs
Product Component:   To Be Determined
Status:   Open
OS:   all
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request for SPDC FAQ on Sybase Software Asset Management section:

"How do I save multiple licenses to a single file"



CR:439445
CR Number:   439445
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2006 Not a Bug
Description
Process hang in pg_oamscan_nextpage() and dol_oamscan_getnext() when using large data cache configuration.



CR:439457
CR Number:   439457
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2006 Fixed
21 Aug 2006 Fixed
Description
Excessive character '&n' is included in starting message of backupserver.



CR:439503
CR Number:   439503
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)
17 Aug 2006 Fixed
25 Aug 2006 Fixed
Description
Procedure cache memory allocation may fail in certain boundary cases,

if procedure cache request results in a procedure cache pool growth after

a new shared memory segment allocation.



CR:439537
CR Number:   439537
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)
30 Aug 2006 Fixed
Description
When unit specification is used with sp_configure to configure 搒yb_sendmsg port number, the unit specification parameter is ignored and 搒yb_sendmsg port number is set to zero.



CR:439573
CR Number:   439573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
Description
sp_deviceattr accepts directio=true even if the platform does not support directio.

sp_helpdevice shows "directio on" for the device as if ASE supported directio on the platform,

but ASE will activate the device using dsync on and deactivate using directio at startup.
Workaround Description
 Please ignore output from sp_helpdevice and check your ASE's errorlog.



CR:439603
CR Number:   439603
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2006 Fixed
06 Oct 2006 Fixed
Description
When estimating the selectivity for a local index, the qualifying pages is incorrect.



CR:439619
CR Number:   439619
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2006 Bundled Request
Description
Previously on Connect dialog, if previously-connected server entry had been removed from interfaces file, OK button would not be enabled, even though the server name was filled in. The has been changed so that if previously-connected server entry no longer exists in the interfaces file, Connect dialog will leave the server name as blank.



CR:439804
CR Number:   439804
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)
18 Aug 2006 Fixed
Description
Wrong result could happen when a subquery is correlated to

an outerjoin inner table.



CR:439836
CR Number:   439836
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2006 Fixed
Description
UI: segment policy page format inconsistent



CR:439857
CR Number:   439857
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)
12 Sep 2006 Fixed
12 Sep 2006 Fixed
Description
Error 102 and 105 may occur when inserting a single or double-byte single quotation mark

into a unicode character column on a proxy table.



CR:439895
CR Number:   439895
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)
31 Aug 2006 Fixed
29 Aug 2005 Bundled Request
Description
The error 1105, "Can't allocate space for object ..." may be incorrectly reported, if the "greedy allocation scheme" is enabled on a table that has text/image columns and non-clustered indexes that are affiniated to distinct user defined segments.
Workaround Description
 Turn off greedy allocation:

dbcc tune(des_greedyalloc, dbid, tabname, 'off)

To check if the greedy allocation caused any problem, verify the GAM by running:

dbcc gam(dbid or dbname, 0, 0, 'fix')

in single user mode.



CR:439908
CR Number:   439908
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Provide an uninstall script for sp_dbextend



CR:439942
CR Number:   439942
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)
21 Aug 2006 Fixed
Description
QP metrics is enabled for the statements inside triggers



CR:439945
CR Number:   439945
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)
20 Sep 2012 Insufficient priority to fix
Description
enhancement request to remove the limit number of work table for derived tables



CR:440030
CR Number:   440030
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)
31 Aug 2006 Fixed
Description
When complex password policy option "disallow simple passwords" is set, ASE checks for login name contained in the password are case sensitive. With this fix, ASE will do a case insensitive

comparision to avoid the use of login name with mixed upper and lower case letters in the password.



CR:440031
CR Number:   440031
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)
23 Aug 2006 Bundled Request
Description
When complex password policy options are set using sp_passwordpolicy, installmaster may fail with 9578, 17720 and 17231 error messages.



CR:440046
CR Number:   440046
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2006 Fixed
Description
When there are two different local variables used in both select list and order by list, query may generate wrong ordering based on select expression.



CR:440052
CR Number:   440052
Product Name:   Adaptive Server Enterprise
Product Component:   langinstall
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2006 Fixed
20 Mar 2007 Fixed
07 Aug 2007 Added to user documentation
03 Aug 2007 Fixed
15 Oct 2007 Fixed
10 Oct 2007 Fixed
Description
ASE localization files are moved from $SYBASE/locales/{language}/{charset} directory

to $SYBASE/$SYBASE_ASE/locales/{language}/{charset} directory in ASE 15.0.2 release.



CR:440065
CR Number:   440065
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Insufficient priority to fix
Description
Currently it is extremely difficult to determine how much procedure cache should be configured on any particular system. There is a rule of thumb equation to calculate it but it does not cover all types of allocations from that area, neither is it very accurate. The customer wants a simple way to determine how large the procedure cache should be and how many other items should be increased/reduced, i.e. sort buffers, for this to be tuned properly. What I recommend is a stored procedure similar to sp_sysmon that can be run to collect the following information:



1) Current usage, maximum usage, minimum usage

2) Number of allocations

3) Type of allocation

4) Who/what made the allocations (including size, date/time, spid, user name and command name).

5) Average size (mean) of the allocations

6) Standard deviation from the mean



The stored procedure should be called sp_procmon with the following parameters:



sp_procmon <duration> [sample rate] [output table]



Duration is required and represents time in minutes.

Sample Rate is optional and by default would be one tenth of the Duration time so that only ten samples would be taken.

Output Table is optional and is for the raw data collected by sp_procmon.



This is just a suggestion and as log as the outcome for the customer is a simple way to monitor and configure procedure cache size I don't think they would care how we implement this feature.
Workaround Description
 *** Saturday, August 19, 2006 4:01:59 PM *** cooperg ***

Too cumbersome for customer as a lot is trial and error.



CR:440091
CR Number:   440091
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)
23 Aug 2006 Fixed
Description
Creation of jpubs database hangs due to running out of log space.
Workaround Description
 Change jpubs database size from 3MB to 4MB.



CR:440107
CR Number:   440107
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2006 Not a Bug
Description
DBISQL the print statement do not work after a select 1.

DBISQL do not pickup the 2 Print in a batch like this.



print "Print test 1"

select "Select test 1"+

print "Print test 2"

go



CR:440127
CR Number:   440127
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)
28 Aug 2006 Fixed
Description
When an external login is mapped to an ASE login with a different name, if the external login password is changed, it should be updated in the mapped login if there is a one-to-one relation, but this is not happenening.
Workaround Description
 Add each LDAP user to ASE and update all the permissions - this is a major administration effort for big shops.



CR:440142
CR Number:   440142
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   HP-UX
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2007 Fixed
06 Apr 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Backupserver hangs when accept() returns an unexpected return value such as ENETRESET or ENOBUFS.



CR:440159
CR Number:   440159
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig - PC
Status:   Closed
OS:   Windows W2k
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2007 Fixed
21 Apr 2008 Fixed
Description
syconfig.exe utility shows corrupted Chinese characters when the default language is set to Traditional Chinese.



CR:440172
CR Number:   440172
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   Windows XP
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2006 Fixed
01 Sep 2006 Fixed
Description
Select object doesn抰 show complex type either from same model or another model



CR:440175
CR Number:   440175
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)
30 Aug 2006 Fixed
Description
LDAP or PAM logins that were added using ASE older than 12.5.4 will not allow

external authentications to failover to ASE logins, if authenticated by ASE 12.5.4 or later



CR:440204
CR Number:   440204
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 Sep 2006 Fixed
Description
There is no password related audit option.



CR:440232
CR Number:   440232
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
Description
In 12.5.4, ASE Plug-in failed to re-open "Add Trigger (Template)", after a trigger has been created using the template. This problem is seen for all compiled objects - defaults, rules, procedures etc. when a template is used for creation of these objects.



CR:440252
CR Number:   440252
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2006 Fixed
Description
ASEP used to show no ASEs in the drop down box on Connect dialog if user's interfaces file contains any line that has white characters between "query" and "=". This has been fixed.



CR:440272
CR Number:   440272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2006 Fixed
Description
DBCC LOGTRANSFER may interrupt scanning the transaction log, or report the error "Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter." when it skips a log record with object identifiers larger than 30 characters.



CR:440278
CR Number:   440278
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)
31 Aug 2006 Fixed
Description
sp_droplogin fails to delete related Sysresourcelimits row when

the configuration option 'enable ldap user auth' is on.



CR:440282
CR Number:   440282
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
Description
The minimum expansion size of Automatic Database Expansion is 4MB.



CR:440382
CR Number:   440382
Product Name:   SySAM
Product Component:   FLEXlm
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2008 Insufficient priority to fix
Description
Contents written to "Provides" of StartupParameters.plist file are wrong.
Workaround Description
 Please rewrite Provides name to "SybaseLicenseManager".



CR:440393
CR Number:   440393
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)
31 Aug 2006 Fixed
Description
Wrong result may be returned from a select when unsigned bigints are

compared in a where clause.



CR:440401
CR Number:   440401
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2006 Fixed
29 Aug 2006 Fixed
Description
Lack of disk buffers, in some rare cases, may result in a segmentation violation

during a create database command.



CR:440464
CR Number:   440464
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.2 12 Jan 2007 Fixed
Description
The ASE-15_0/SC-3_0/log directory is created as an empty directory in the release area.



CR:440486
CR Number:   440486
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.0.1 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2006 Fixed
Description
Stored procedure sp_datatype_info does not report correct 'create_params' information on nchar and nvarchar.



CR:440492
CR Number:   440492
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2006 Fixed
14 Sep 2006 Fixed
Description
ASE Plug-in, through component 'dsparser.jar', was not able to process server entries in a interface file that has multiple 'query' services, or services with filters (e.g. 'ssl'). This has been fixed.



CR:440501
CR Number:   440501
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)
24 Oct 2006 Fixed
25 Oct 2006 Fixed
Description
SSL: isql sessions hang when doing a select query and the negotiated packet size is

4096 or greater.



CR:440567
CR Number:   440567
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2006 Duplicate
Description
Fully support custom packages and classes from JVM 1.4.x



CR:440572
CR Number:   440572
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
expand xml capabilitiesin ASE 15 to do updates in addition to query



CR:440573
CR Number:   440573
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)
26 Aug 2006 Fixed
Description
When a union view or union derived table is used within

a correlated subquery and the correlation involves some

join between the union projection and an expression,

following compilation error could happen:

Msg 403, Level 16, State 2 Invalid operator for datatype op: type: VARCHAR.



CR:440600
CR Number:   440600
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2010 Fixed
20 May 2010 Fixed
Description
Feature Request: Add support for encrypting coumns of type Text/Image/Unitext



CR:440624
CR Number:   440624
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)
20 Sep 2006 Bundled Request
Description
When literal autoparameterization is on, SELECT with FOR BROWSE may fail with TDS error if

there are literals in the where clause.



CR:440654
CR Number:   440654
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Insufficient priority to fix
08 May 2007 Insufficient priority to fix
22 May 2009 Fixed
06 Oct 2009 Added to user documentation
Description
Customer needs way to identify ASE spid in a network trace/TDS



CR:440757
CR Number:   440757
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2006 Fixed
Description
A new builtin switchprop() is added. Passing a switch-name or -number to the switchprop() builtin

will return a status which contains the switch properties.
Workaround Description
 n/a



CR:440766
CR Number:   440766
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2006 Fixed
18 Jan 2007 Fixed
13 Feb 2007 Fixed
27 Feb 2007 Fixed
Description
A new stored procedure sp_helpapptrace has been added for application tracing feature. This procdure lists all the sessions that are being traced, the sessions tracing them and the names of the tracefile.



CR:440821
CR Number:   440821
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2008 Fixed
Description
Add to installmaster a new system stored procedure (sp_tab_suspectptn) to list table(s) with suspect partitioning.



CR:440832
CR Number:   440832
Product Name:   SySAM
Product Component:   SAMreport
Status:   Closed
OS:   all
Original Version:   3.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2011 EOL'd version. Not to be Fixed.
Description
Excessive character is included in Japanese of Japanese vertical line label of Summary Barchart Report.



CR:440855
CR Number:   440855
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
10 Oct 2006 Fixed
Description
Query using multiple worktables to resolve aggregates or provide distinctness or the order

and performing dynamic index strategy to resolve OR predicate may fail with different

errors related to sort operations including error 1509 "Internal error encountered in merging rows;

resubmit query batch." Sometimes query execution may fail with stack trace logged in the errorlog.

The module shown in the backtrace is bld_dynindex.



CR:440874
CR Number:   440874
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2006 Fixed
07 Nov 2006 Fixed
Description
When a spid is killed on the remote ASE, the local ASE may be infected with signal 11

in ksct_startio when accessing proxy table mapped to the remote ASE.



CR:440876
CR Number:   440876
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2006 Fixed
Description
sp_help and sp_helpartition show the row count as zero for proxy tables



CR:440880
CR Number:   440880
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation and Configuration Guide-ASE
Status:   Closed
OS:   HP-UX
Original Version:   12.5.4 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Documentation of Pre-Installation tasks for Adaptive Server Enterprise version 12.5.4 on HP Tru64 Unix is incorrect.

The document needs to be updated to reflect the installation advice for Tru64 Unix.



CR:440923
CR Number:   440923
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.4 ESD#3 31 Aug 2006 Fixed
08 Sep 2006 One-off Provided
08 Sep 2006 One-off Provided
17 Oct 2006 Fixed
Description
The message "current process infected with 11 in the module sendtext()" together with a

stacktrace which includes the modules 's_execute', 'exec_eop' and 'run' maybe reported in the

errorlog when running a SELECT with a UNION ALL clause and ORDERBY selecting text or image columns

from a table.



CR:440924
CR Number:   440924
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)
18 Aug 2008 Fixed
20 Aug 2008 Fixed
Description
ASE prints the User Connection Report at the 24hr interval irrespective of the license type.



CR:440932
CR Number:   440932
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 Sep 2006 Fixed
13 Sep 2006 Fixed
12 Sep 2006 Fixed
12 Sep 2006 Fixed
Description
In rare circumstances, the message "current process infected with 10" in the module

'lddb__stat_translate' together with a stacktrace which includes the modules

'lddb__unscr_stat_page' and 'lddb__unscr_usro' may be reported in the errorlog

when running LOAD DATABASE across platform where the endian type is different.

Other errors, like 'Invalid column length' error, 1142, 692, or 12315 error may be

reported.
Workaround Description
 Delete statistics on sysindexes before DUMP DATABASE by following command:



1> delete statistics sysindexes

2> go



CR:440969
CR Number:   440969
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 Nov 2006 Fixed
Description
Adding a built-in password_admin for password administration related operations.



CR:441012
CR Number:   441012
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2006 Fixed
07 Sep 2006 Fixed
07 Sep 2006 Fixed
Description
Enable the input parameter column size used in a web service proxy table to be automatically generated based on the ASE page size.
Workaround Description
 *** Thursday, August 31, 2006 12:17:55 PM *** cooperg ***

None. Attempted to modify sp_webservices to change 2048 values to some larger size but the column was always 2048.



CR:441015
CR Number:   441015
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)
17 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Feature request to enhance dbcc tablealloc / checkalloc to report and fix a condition that results in dbcc checkstorage fault 100016.



CR:441020
CR Number:   441020
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2006 Fixed
09 Oct 2006 Fixed
12 Oct 2006 Fixed
Description
The minimum password length of system encryption password does not match the minimum password set in sp_configure.
Workaround Description
 Adaptive Server Enterprise/12.5.4/EBF 13731 ESD#1/P/Sun_svr4/OS 5.8/ase1254/2013/32-bit/FBO/Sat Jul 22 07:56:48 2006

Sybase Central ASE Plug-in/12.5.4/GA Build 1/S/1.4/ase1254dev/Sat Jul 22 09:31:39 PDT 2006



Setting the configuration option for 'minimum password length', both the old version in Server Configuration tab of Server Properties, and the new Login Password Configuration tab, should control the behavior of any dialogs for creating or changing passwords. There have been a few problems found and fixed for the dialogs for logins (e.g 422217). Now it is found that the dialogs for System Encryption Password have some similar problems.





Repro



Make sure "enable encrypted columns" is set to 1 in Server Configuration (restart server if you have to change it to get to 1)



Scenario 1

1. Server Config value = 6, Login Password Config = OFF

2. Select menu option <database>/System Encryption Key/Create System Encryption Password

3. Message says "Password must be at least 6 characters long"

4. Enter password and confirm password

5. OK button not enabled until passwords match and are at least 6 characters.



Scenario 2

1. Server Config value = 6, Login Password Config = 9 ( new option should override old option)

2. Select menu option <database>/System Encryption Key/Create System Encryption Password

3. Message says "Password must be at least 6 characters long"

4. Enter password and confirm password

5. OK button not enabled until passwords match and are at least 6 characters.



Scenario 3

1. Server Config value = 9, Login Password Config = 9 ( new option should override old option)

2. Select menu option <database>/System Encryption Key/Create System Encryption Password

3. Message says "Password must be at least 6 characters long"

4. Enter password of 6 characters and confirm password

5. OK button is enabled when passwords match and are at least 6 characters.

6. A password of 6 characters gets an error message - password must be at least 9 characters



Scenario 4

1. Server Config value = 4, Login Password Config = 9 ( new option should override old option)

2. Select menu option <database>/System Encryption Key/Create System Encryption Password

3. Message says "Password must be at least 6 characters long"

4. Enter password of 4 characters and confirm password

5. OK button not enabled since passwords are not at least 6 characters.

6. Go into isql and call sp_encryption system_encr_passwd, 'abcd'

7. password accepted



The same things happen in the Alter System Encryption Password dialog.



So it appears that there are a couple of problems

1. Whatever the option value is, the dialogs are not adjusting their message and text length requirements

2. Setting the Login Password Configuration option which should override the Server Config option, is not doing so.



CR:441029
CR Number:   441029
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)
27 Sep 2006 Fixed
27 Sep 2006 Fixed
Description
In rare circumstances, server might not boot up reporting 'max repartition degree' > 'max parallel degree'.
Workaround Description
 workaround is to manually edit the configuration file and set "max repartition degree" to something <= "max parallel degree"



CR:441060
CR Number:   441060
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2006 Fixed
Description
Missing using a correlated predicate as a sarg underneath

a subquery when the predicate involves an expression with

correlated column(s). This could cause less performing

plan.



CR:441070
CR Number:   441070
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)
17 Sep 2006 Fixed
19 Sep 2006 Fixed
19 Sep 2006 Fixed
25 Sep 2006 Fixed
Description
A sort failure may occur while rebuilding clustered/placement index as part of AMC operation.

This may lead to improper rollback of AMC operation

(In our case, the partition rootpage is not rolled back properly).

A wrongpage error (605/696) will be thrown upon subsequent access of the table



CR:441107
CR Number:   441107
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
AUDIT: Request for login audit records to include 'programe_name' and 'clientapplname' information in it's extra information field.
Workaround Description
 None known.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------