远程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:372269
CR Number:   372269
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2004 Fixed
10 Dec 2004 Fixed
Description
DDLGen now supports ASE 11.9.2 and up.



CR:372272
CR Number:   372272
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need better documentation for event 80 proc_role of security option for auditing



CR:372285
CR Number:   372285
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2005 Fixed
13 Dec 2005 Not a Bug
Description
Allow parallel execution of queries selecting from a view with union.
Workaround Description
 create one view for each table and rewite the original query so that the UNION will be pulled out from view (see example in CR desc).



CR:372321
CR Number:   372321
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2005 Fixed
23 Jan 2006 Fixed
17 Jan 2006 Fixed
06 Mar 2006 Fixed
Description
In multi engine environment, if the engine which is running the "disk mirror" is not able to

access the primary device, mirroring succeeds but later ASE fails during the subsequent

operations with the errors such as :



- Error 692: "Uninitialized logical page <page id> was read while accessing object <object id> in database <database id>

or

- Error 822: Could not start I/O for request BLKIO < ...buffer details>



CR:372324
CR Number:   372324
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
Description
In multiprocessor Windows systems with a high rate of process login and logout, ASE encounters a timeslice error in routine ks_closeall



CR:372358
CR Number:   372358
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2006 Fixed
Description
Scheduled Job folder does not display remotely scheduled jobs without a manual refresh by the user.



CR:372422
CR Number:   372422
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
Description
A 702 error, "Memory request for <number_of_bytes> bytes exceeds

the size of single page of 16384 bytes." may be raised together

with a stack trace reported in the error log which includes the

modules 'pll_exec', 'copy__constant' and 'memalloc' when executing

a query statement that uses the CONVERT() function for converting

to TEXT (or IMAGE) datatype and the query is executed in parallel.
Workaround Description
 - Run query in serial.



CR:372435
CR Number:   372435
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2005 Fixed
08 Apr 2005 Duplicate
28 Feb 2005 Fixed
28 Feb 2005 Fixed
Description
When the JS agent unexpectedly loses contact with the JS task (e.g., as a result of ASE shutting down with "nowait") while the agent is running multiple, simultaneous jobs, it attempts to shut itself down and mismanages jobs queues and memory in the process, causing the agent to core dump or hang (and not be able to resume when the JS task is revived). Symptoms include (1) a core file, (2) a freshly started JS task unable to launch and connect to a JS agent, (3) the JS task logging an error such as "Failed to receive communication buff".



CR:372465
CR Number:   372465
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
31 Oct 2005 Fixed
04 Jan 2005 Fixed
Description
A stored procedure will not be found and the error 2812 will be raised if

the procedure name is stored in a variable enclosed in squared brackets,

prefixed with the database name and executed from a different database.



CR:372495
CR Number:   372495
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2005 Fixed
Description
When an external authentication mechanism is configured, and the user is automatically

created in ASE with the aid of sp_maplogin, an audit event for LOGIN COMMAND (103) is

not generated.



CR:372527
CR Number:   372527
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)
25 Jan 2005 Fixed
07 Feb 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The syslogins status bit 0x1 is not set for short passwords.



CR:372533
CR Number:   372533
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
Description
The execution of "SP_SPACEUSED <table_name>" may deadlock with other sessions trying to create/drop tables in the given database.
Workaround Description
 Change sp_spaceused to mimic the same behaviour as when run on the given database globally.



CR:372601
CR Number:   372601
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Open
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
EFTS: Request to support searches where certain character sequences are considered to be equivent such as Muller, Mueller and M<u-umlaut>ller are all considered to match whichever is searched for.
Workaround Description
 Possibly set up theasaurus matches.



CR:372606
CR Number:   372606
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Install Guide-Adaptive Server Enterprise
Status:   Closed
OS:   AIX
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2006 Fixed
Description
1251/1252 Installation Guide Adaptive Server Enterprise for IBM AIX -->

Chapter 5 Upgrading Adaptive Server --> Pre-upgrade tasks -->

Step 17:

Copy the following files from earlier versions of Adaptive Server to their corresponding Adaptive Server 12.5.x installation:



The issue is that Step 17 needs a Note specifying that coping the files are not required if the customer uses the SQLUPGRADE program to upgrade there server because SQLUPGRADE will copy these files over automatically, SQLUPGRADE needs these files to start the new server.



CR:372621
CR Number:   372621
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Infected with 11 in st_get_distmap_boundary after enabling sort-merge joins
Workaround Description
 disable sort-merge joins via sp_configure



CR:372628
CR Number:   372628
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2005 Fixed
Description
Scheduled Jobs folder was hidden when user did not have a proper JS role.



CR:372630
CR Number:   372630
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2004 Fixed
19 Oct 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The message "current process infected with 11" in the module 'next_root' together with a stack trace which includes the modules 'vu_call_colnames' or 'clean_vars' may be reported in the error log if a view or a stored procedure using a derived table with a UNION is recompiled.
Workaround Description
 create another view filledPos as

select contract, strategyName, position

from todaysOpeningPositions

union all

select contract, strategyName, lots

from todaysTrades

where price <> 0

and change the FROM clause to "from filledPos" in the view "todaysFilledPositions"



CR:372669
CR Number:   372669
Product Name:   Adaptive Server Enterprise
Product Component:   upgrade
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2005 Not a Bug
Description
If the 11.9.2 server had the optional sybsystemdb database setup, and placed on a seperate device (s), the recovery procedure outlined in techdoc 1012256, will not allow recovery. http://www.sybase.com/detail?id=1012256



techdoc 1012256 needs to include a description of this particular situation and if a customer has this particular situation, describe that this recovery procedure will fail.



CR:372713
CR Number:   372713
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2005 Fixed
06 Jan 2005 Fixed
15 Apr 2005 Fixed
Description
CIS: The message "current process infected with 11" in the module 'memmove_sanity()'

may be reported when a INSERT...SELECT or SELECT INTO with join and CASE

is evaluated to be true and Quickpass disabled.
Workaround Description
 none



CR:372719
CR Number:   372719
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)
19 Jan 2005 Fixed
Description
New feature request to enable the definition of a global login trigger to be executed by every user at login time, before the personal login script is fired. It can be defined using the stored procedure sp_modifylogin with a NULL login name and the option 'login script' or by calling the new procedure sp_logintrigger directly.



CR:372728
CR Number:   372728
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2005 Fixed
18 Apr 2005 Fixed
Description
Automatic lightweight validation of pages physically read from or written to disk will now occur when either a 694 error or some variants of a 697 error are reported. This is indicated by the message "Diagnostic checks have been turned on to report if a corrupted page is read from or written to disk. Use DBCC TRACEOFF(615) to turn these checks off" in the error log. The automatic validation may be permanently turned off by starting Adaptive Server with the 615 trace flag.
Workaround Description
 N/A



CR:372735
CR Number:   372735
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2004 Fixed
Description
Not customer visible



CR:372757
CR Number:   372757
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2004 Fixed
30 Aug 2007 Insufficient priority to fix
Description
Not customer visible



CR:372767
CR Number:   372767
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2005 Duplicate
Description
Customer has to meetDOD requirements and require IPV6 support on HP-UX 64 and 32 Bit.



CR:372880
CR Number:   372880
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Timestamp columns are not updated during bcp operations
Workaround Description
 Do an update of all rows after the bcp in, so all rows get an new timestamp

assigned. Like:



update tab set col1=col1

go



CR:372881
CR Number:   372881
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Open
OS:   NA
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Add Monitoring Table to Report RPC/stored_procedure(stored procedure) Statistics
Target Version
 12.5.4 ESD#4



CR:372930
CR Number:   372930
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)
02 Mar 2005 Presently Not Targeted For Any Future Release Of This Product
14 Apr 2005 Fixed
21 Apr 2005 Fixed
15 Jun 2005 Fixed
Description
A 701 error, "There is not enough procedure cache to run this procedure,

trigger, or SQL batch..." may be reported after running many client or

language cursors in a server configured to use Abstract Plans in "capture"

or "apply" modes.



CR:373027
CR Number:   373027
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2004 Fixed
Description
12323 errors: "Internal error occured during rebuild of index id %d of table '<tabname>'..." together with 2628 errors: "In database '<dbname>', page <pageno1> is linked forward to page <pageno2>, but that page is linked backward to page <pageno3> ..." may be encountered while running concurrent REORG REBUILD <tabname> <indexname> on the same index together with DMLs on a data-only locked table.



CR:373084
CR Number:   373084
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Error 691/696 and 8206 may occur on monCachedObject if a query has object_name() function and order by clause.

In order to avoid this problem, please specify ObjectID > 0 in WHERE clause.
Workaround Description
 Specify where clause that excludes negative object ID from the result set.



select object_name(ObjectID,DBID) from monCachedObject

where ObjectID > 0 order by CachedKB

go



CR:373146
CR Number:   373146
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Solaris
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to enhance installation/configuration guide to include

instructions to do a reserved word check without upgrading

ASE in a non-GUI environment.

The installupgrade script is used to create sp_checkreswords in the

ASE that will be upgraded.



CR:373178
CR Number:   373178
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2004 Fixed
20 Dec 2004 Reservation Made
03 Mar 2005 Fixed
27 Jan 2006 Fixed
23 May 2005 Presently Not Targeted For Any Future Release Of This Product
23 May 2005 Presently Not Targeted For Any Future Release Of This Product
31 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
23 May 2005 Fixed
Description
Two new columns, 'unusedpgcnt' and 'oampagecnt' are added into systabstats, to represent the number of un-used pages and the number of oam pages in the object represented by this systabstats row.



CR:373187
CR Number:   373187
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2004 Fixed
Description
Jobs created from a template or jobs with long (greater than 900 characters) commands are truncated when the job is created from the Scheduled Job Wizard.



CR:373461
CR Number:   373461
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)
21 Jan 2005 Fixed
25 Feb 2005 One-off Provided
Description
In some cases logins will be blocked when a session that is modifying a system table in the 'master' database (eg the sysattributes table through the sp_addengine stored procedure), is itself blocked because the 'master' database has been quiesced.
Workaround Description
 When a QUIESCE DATABASE HOLD operation is performed, ensure that

there is an already logged in session that is able to perform

the QUIESCE DATABASE RELEASE operation.



CR:373573
CR Number:   373573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
Description
In rare cases, a distributed XA transaction will be left in an "In Abort Tran" state after an XA transaction manager (TM) has issued an asynchronous abort request on it and there is at least one pending attach request. A further attempt by the TM to roll back the transaction or an attempt to roll back the transaction using DBCC COMPLETE_XACT will fail.
Workaround Description
 None.



CR:373633
CR Number:   373633
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2010 Fixed
Description
srvbuild created 2MB sybsystemdb but the default populated in the screen is 5MB



CR:373649
CR Number:   373649
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
When the error 1514 is raised in 64 bits platforms, the text "Message too long. Length = 546."

will be printed instead of the actual error message.



CR:373722
CR Number:   373722
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)
13 Dec 2004 Fixed
Description
If the recompilation of an ad-hoc DML command is detected, error 540

"Schema for table '<value>' has changed since compilation of this query.

Please re-execute query." may be followed by a segmentation violation

in module abortcmd() with a stack trace reported in the error log.
Workaround Description
 No workaround.



CR:373723
CR Number:   373723
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for IBM
Status:   Open
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Doc update request for async I/O settings for AIX 5.1/5.2 which needs to follow a rule of thumb different from version 4.3.3



CR:373727
CR Number:   373727
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2004 Fixed
Description
Not customer visible



CR:373751
CR Number:   373751
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Tables
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2007 Fixed
07 Oct 2007 Fixed
14 May 2009 Presently Not Targeted For Any Future Release Of This Product
15 May 2012 Added to user documentation
Description
Sysprocesses table not have a clientport field to identify a perticalar cleint session



CR:373858
CR Number:   373858
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Fixed
29 Sep 2005 Fixed
Description
If a command is sent to ASE which contains a huge number of syntax errors (eg thousands), then the ASE task handling the command may hang in 'send sleep'. This is because the client machine has not yet called ct_results to retrieve input, and the large number of syntax error messages sent back to the client may fill the client's tcp/ip receive buffer. To prevent this, only the first 25 syntax errors in any single command batch will be reported.



CR:373869
CR Number:   373869
Product Name:   Adaptive Server Enterprise
Product Component:   Monitor Client
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2004 Fixed
03 Dec 2004 Fixed
06 Dec 2004 Fixed
03 Dec 2004 Fixed
Description
Not customer visible



CR:373906
CR Number:   373906
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)
01 Aug 2006 Fixed
Description
For an infected process, the signal names are not printed in the error log.



CR:374037
CR Number:   374037
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2012 EOL'd version. Not to be Fixed.
Description
For Srvbuild 12.5, 12.5.2, 12.5.3 under "Edit Advanced Adaptive Server Attributes"

srvbuild created sybsystemdb 2MB on master and 3MB on its own device.



CR:374049
CR Number:   374049
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
Description
In some cases, the sp_displaylogin system stored procedure will incorrectly

repeat the value for the "Current Failed login attempts" property for the

following item "Authenticate with".
Review Status
 In some cases, sp_displaylogin may repeat the value for "Current failed login attempts" in the output of "Authenticate with" instead of the value "NONE".
Workaround Description
 Manually modify sp_displaylogin as described in the main CR.



CR:374086
CR Number:   374086
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Open
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The GUI for srvbuild and sqlupgrade on AIX/LINUX is unclear...checkboxes/radio_buttons looked deselected when selected



1. With AIX and LINUX the initial dialogue in srvbuild and 5 dialogue screens deep within sqlupgrade...checkbox/radio_buttons options are unclear...the customer makes a selection and it appears deselected...the boxes change from gray to white(it may be yellow but it is so small that the open square looks white). The white(it may be yellow but it is so small that the open square looks white) makes them look empty and thus it appears that item is deselected.



2. Solaris and HP use a larger square box and the boxes turn yellow...so there is an inconsistant GraphicalUserInterface between UNIX platforms.



CR:374160
CR Number:   374160
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2005 Fixed
23 Feb 2005 Fixed
23 Feb 2005 Fixed
Description
When migrating only indexes and constraints for a database then the migration can hang and an unhandled exception is printed on the console window:



java.lang.ClassCastException: java.math.BigDecimal

at com.sybase.sybmigration.ObjectSelectForm$NextTask.doWork(ObjectSelect

Form.java:2082)

at com.sybase.sybmigration.MigrationToolThread.run(MigrationToolThread.j

ava:28)
Workaround Description
 Leave out step 3-5 and do instead:

X) Manually deselect every entry except "Index, Index Constraint".

Y) Press "Migrate"



CR:374175
CR Number:   374175
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Fixed
28 Jul 2005 Not a Bug
14 Sep 2005 Presently Not Targeted For Any Future Release Of This Product
14 Sep 2005 Fixed
Description
Few new columns were added to optdiag output for dumping and loading of simulated statistics.



CR:374215
CR Number:   374215
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)
08 May 2009 Insufficient priority to fix
Description
Feature request for the ability to declare synonyms (a way to refer to objects in other databases on the server without using the full dbname.owner.objectname syntax).
Workaround Description
 A view or a proxytable (loopback) may be an acceptable workaround.



CR:374238
CR Number:   374238
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 29 Jun 2007 Bundled Request
Description
For SSL in ASE, user has to use FQDN format server names for the common name in certreq due to their bank requirment, but ASE does not support server name in FQDN format. Request sybase to support this feature.
Workaround Description
 *** Tuesday, December 07, 2004 3:00:34 PM *** cooperg ***

None for this customer.



CR:374269
CR Number:   374269
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2004 Fixed
Description
CIS: A 12974 error, "engine <number> has outstanding ct-lib/java connections and cannot be offlined", may occasionally be reported even without any active/pending CIS connections when sp_engine "offline" is used to offline an engine.



CR:374275
CR Number:   374275
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Fixed
Description
Replication Agent may shutdown with the error 9219, state 29 when trying to process an object using an identifier larger than 64 characters.



CR:374286
CR Number:   374286
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2004 Fixed
Description
A 703, state 2 error, "You cannot run this procedure, trigger, or SQL batch because

it requires more than 24480 pages of memory" may be reported during CREATE INDEX on

a large table with the 12.5.3 server.
Workaround Description
 decrease the configuration parameter "number of sort buffers".



CR:374293
CR Number:   374293
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2004 Fixed
Description
In a Replication environment, configured to replicate DDL, a create index command is incorrectly replicated.



CR:374297
CR Number:   374297
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
On Linux RHAS2.1 and RHEL3.0, the Job Scheduler agent repeatedly crashes,

leaving core files due to SEGV and BUS errors.



CR:374342
CR Number:   374342
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.2.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.0.0 01 Aug 2005 Fixed
Description
ASE Replicator : "ddl in tran" is no longer required to be configured for the tempdb.



CR:374352
CR Number:   374352
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Fixed
13 Jan 2005 Fixed
Description
Large Memory feature will be disabled when used in conjuntion with Posix aio.



CR:374421
CR Number:   374421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Bundled Request
Description
In Replication environments, replicating DDL, Relication Agent sends an additional 'alter table' command when a functional index is created



CR:374596
CR Number:   374596
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2005 Fixed
Description
Error message reported by sp_audit stored procedure corrected to

read '<loginname>' is not a valid login name.



CR:374625
CR Number:   374625
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2004 Fixed
Description
The error 2601, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'" will be raised by the server upgrade item 1412 if a role with password expiration different than zero exists.
Workaround Description
 Identify problematic rows where int_value is not 0

select a.object, s.srid, a.int_value from

sysattributes a, syssrvroles s

where a.object=s.srid

and a.class=14 and a.int_value !=0



Fix the rows so upgrade can complete --update the int_value to 0

update sysattributes set int_value=0 where class=14 and object=xx -- where xx is the object/srid with the non-zero int_value

reboot --master will be upgraded at this point

after the upgrade completes, set int_value back to previous setting

update sysattributes set int_value=<prev_value> where class=14 and object=xx -- where xx is the object/srid with the non-zero int_value



CR:374681
CR Number:   374681
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2005 Fixed
19 Jan 2005 Reservation Made
09 Dec 2005 Bundled Request
07 Feb 2005 Fixed
Description
DBCC ORPHANTABLES enhanced to drop stranded temporary tables holding EX_TAB locks.

These locks may be left around as a result of an ungraceful termination of a connection.



CR:374710
CR Number:   374710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2005 Fixed
25 Jan 2005 Fixed
Description
The message "current process infected with 11" in the module 'set_cast' may be reported in the errorlog together with a stack trace which includes the modules 's_renormalize' and 'execrpc' (or 'exectrig') when a stored procedure was executed as a Remote Procedure Call (or by a trigger) and had to be renormalized because, for example, one of the underlying objects referenced was dropped and recreated.
Workaround Description
 - Recreate the failing object from text.



OR



- Use traceflag 7710 that disables 344403's fix.



CR:374733
CR Number:   374733
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2004 Fixed
Description
A 12328 error, "The calculated row offset <offset> of an index key on page <page> ... is out of

bounds" together with a stack trace which includes the modules 'srchpage' and 'srchindex' may be

reported in the errorlog of an server with a 8 Kb or 16 Kb page size during a SELECT using an index which includes variable length columns.



CR:374775
CR Number:   374775
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2004 Fixed
Description
When an index creation that is run in parallel mode as opposed to serial

gets interrupted by the end-user, a segmentation violation may be hit in

module 'sortclean' with a stack trace in the error log. The modules

'cri_physbuild', 'sort' and 'sam_gen_distmap' will also be reported.



CR:374785
CR Number:   374785
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Fixed
01 Feb 2005 Fixed
Description
A permission denied error will be raised when executing a stored procedure created by an alias to DBO that contains an OPEN CURSOR statement on a table in a different database.



CR:374815
CR Number:   374815
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2005 Fixed
Description
In rare circumstances, Adaptive Server may hang as a result of an undetected

self deadlock for a process that is trying to flush its user log cache when

the cache replacement policy for the given cache is "relaxed LRU replacement".
Workaround Description
 Use the strict (default) replacement strategy instead of relaxed.



CR:374880
CR Number:   374880
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   4.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.0.0 15 Jun 2005 Fixed
Description
ASE Replicator: ASE Replicator has been updated to use jConnect/jTDS 6.0(JDBC 3.0).



CR:374892
CR Number:   374892
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
15 Jul 2009 Fixed
30 Aug 2009 Fixed
Description
When a user creates a recorded session without enabling "sybase_script", recording into ASE database does not work.
Workaround Description
 create record session with "sybase_script" option.



CR:374902
CR Number:   374902
Product Name:   ASE Replicator
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   4.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.0.0 17 Jun 2005 Fixed
Description
ASE Replicator: ASE Replicator's run scripts have been updated for version 15.0.In addition, the scripts now contain a new environment variable RPL_JAVA_MAX_MEM, that allows you to adjust Java max memory for Replicator instance. Before setting it to a default value, the aserep(aserep_debug) script checks if it has already been set.

This allows you to customize it by setting the RPL_JAVA_MAX_MEM in either the instance RUN script or in your environment.



CR:374907
CR Number:   374907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2005 Duplicate
Description
The message 277 'There was a transaction active when exiting the stored procedure ...' followed by message 631 'The length of <n> passed to delete row routine for the row at offset <x> ..' or message 3478 'During undo the page timestamp value is less than new timestamp from log' together with an stack trace which includes the modules 'tmp_alldrop' and 'xact_rollback' may be reported when an error happens during recompile of a stored procedure while a transaction that modified temporary tables is open.



CR:374917
CR Number:   374917
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2005 Fixed
Description
Remote RPC fails with error 7221, remote server signal 11 in nl_gettrustedhandle() when unfied logins is set up on the ASE servers involved.



CR:374951
CR Number:   374951
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0.0.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2005 Fixed
18 Feb 2005 One-off Provided
01 Jul 2005 Reservation Made
Description
The ASE server process disappears after generating the message "fatal flex scanner internal

error--end of buffer missed" on the ASE console, while executing a query using the Abstract Plan

syntax.



CR:374953
CR Number:   374953
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2004 Fixed
Description
The message "infected with 11 in oh_init()" together with a stacktrace containing

the modules 'oh_init', 'yyparse' and 'sqlpars' is written to the errorlog when executing

an INSERT or UPDATE statement and supplying large amounts of text for a column of type text.
Workaround Description
 don't use " inside a text field



CR:374984
CR Number:   374984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2005 Fixed
Description
An unexpected 208 error, "<object> not found. Specify owner.objectname

or use sp_help to check whether the object exists (sp_help may produce

lots of output)" maybe be raised when executing a stored procedure that

creates inside that object and it has been executed and recompiled

concurrently by several sessions.



Under the same circumstances sometimes a 3703 error is reported following by

one or several 216 errors and resulting in the termination of the session

executing that stored procedure.



CR:375071
CR Number:   375071
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Open
OS:   all
Original Version:   12.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Job Scheduler User's Guide Doc issues, customer has listed 3 issues.

1- Startime typo should be starttime

2- missing quote in sp_sjobcreate

3- Create a job the from step 1 to step 2 the jobname does not follow



CR:375231
CR Number:   375231
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2010 Presently Not Targeted For Any Future Release Of This Product
18 Jan 2006 Bundled Request
Description
sybsystemdb transaction log may fill when selecting data from the MDA tables into a permanent table if "enable xact coordination" is set to 1 or "trunc log on chkpt" is not turned on for sybsystemdb.
Workaround Description
 set "enable xact coordination" to 0

or

set "trunc log on chkpt" for sybsystemdb



CR:375289
CR Number:   375289
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2004 Fixed
10 Feb 2005 Fixed
Description
Auto update statistics feature added to ASEP



CR:375331
CR Number:   375331
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2013 Fixed
Description
ASE 12.5.3 Coverletter should remove reference to EBF 12305 or reference an available EBF



CR:375559
CR Number:   375559
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   macosx
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2005 Fixed
Description
On MacOS X, if JAVA_HOME environment is not set, sqldbgr reports "Unknown platform!" error.



CR:375564
CR Number:   375564
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2005 Fixed
Description
DB-Lib clients may crash or get errors: "Unknown fixed-length datatype encountered." or "Bad token from SQL Server: Datastream processing out of sync." when executing Extended Procedures such as xp_cmdshell.
Workaround Description
 None found.



CR:375566
CR Number:   375566
Product Name:   Adaptive Server Generic Docs
Product Component:   XA Guide for CICS Encina and Tuxedo
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has pointed out these issues with our 12.5.1 Component Integration Services User's Guide.



In Chapter 2 Understanding Component Integration Services under "Proxy databases".

This statement below, is misleading, the last "." in the string identifier >>servername.dbname.owner.<< maybe confused as the end of sentence not rquired for proper syntax. it maybe better to quote the string

Example: >>"servername.dbname.owner.".<<



CR:375567
CR Number:   375567
Product Name:   Adaptive Server Generic Docs
Product Component:   Commands Reference
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Fixed
Description
Customer reported a typo in Reference Manual: Commands, Chapter 1 Commands, under "Examples" section, as you can see in the statement below there are to "ands"

(and,and).......



Creates a proxy database named proxydb and,and brings over all remote tables from a remote database regardless of who created them:



CR:375569
CR Number:   375569
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Database Tools Interface
Status:   Closed
OS:   Generic
Original Version:   9.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 3024 28 Jan 2005 Fixed
9.0.1 1979 28 Jan 2005 Fixed
8.0.3 5211 28 Jan 2005 Fixed
8.0.2 4516 28 Jan 2005 Fixed
7.0.4 3538 28 Jan 2005 Fixed
Description
If ASE 11.9.2.5 or higher (including ASE v12.x) was used as the server for the consolidated database, it was possible that the log scan phase of the Message Agent for ASE (ssremote) could have used a log_received value from the wrong user. The most likely symptom of this problem would be the error message "This message does not belong to me". This has now been fixed.



CR:375576
CR Number:   375576
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2004 Fixed
Description
When the configuration file is backed up after any configuration options is changed,

the name of the previous file is truncated to the first 3 characters of the actual file name.



CR:375578
CR Number:   375578
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Dec 2004 Fixed
Description
Reduce the number of calls to mutex lock and unlock in kaengdowork.



CR:375635
CR Number:   375635
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2004 Fixed
Description
SybProtect Utility to improve ASE security on Windows platform.



CR:375706
CR Number:   375706
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
06 Feb 2006 Fixed
29 Jan 2006 Fixed
Description
A user account set to use LDAP authentication exclusively using 'sp_modifylogin loginname, "authenticate with", LDAP' fails over to ASE syslogins authentication when "enable ldap user auth" = 1 and either the password is wrong, or the LDAP server is unavailable.



CR:375751
CR Number:   375751
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2005 Fixed
Description
Database Check Consistency wizard will not has preview and scheduler buttons



CR:375755
CR Number:   375755
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Fixed
27 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
08 Jun 2005 Fixed
Description
hpia64 : If "maxfiles" (soft maximum number of file descriptors per process) kernel paramter is greater than 32767, ASE could go down due to infected with 11 with a stack trace including kadefer().
Workaround Description
 Set "maxfiles" (initial (soft) maximum number of file descriptors per process) less than 32767.



CR:375794
CR Number:   375794
Product Name:   Adaptive Server Enterprise
Product Component:   charsets
Status:   Closed
OS:   all
Original Version:   12.5.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 Insufficient priority to fix
Description
Please adapt new sort order to enable "case-insensitive " for SJIS/EUCJIS charset.



CR:375795
CR Number:   375795
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2005 Fixed
Description
When dropping a role, any external login mappings it might have, are left orphan in sysattributes.



CR:375799
CR Number:   375799
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Fixed
Description
HA VCS: Possible corner case error in detection of host details belonging to a service group



CR:375812
CR Number:   375812
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: GRANT SELECT ON ALL TO whoever



CR:375871
CR Number:   375871
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2005 Fixed
11 Oct 2005 Fixed
03 Aug 2005 Fixed
Description
HA IBM HACMP: When configuring ASE for High Availability with IBM HACMP, username and password of the user with sa_role and ha_role is stored in ASE_HA.sh script in clear text format.



CR:375883
CR Number:   375883
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2006 Fixed
Description
The error msg 11294 "The remote server <server name> class <class id> is not supported by UPDATE STATISTICS in import mode..." should be displayed with Level 10 instead of 16 severity.



CR:375914
CR Number:   375914
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2005 Fixed
02 Jun 2005 Fixed
02 Jun 2005 Fixed
Description
When UPDATE STATISTICS is run on a proxy table that maps to a non-ASE remote

server, the warning messages 11294 "The remote server ('server_name') class

<id> is not supported by UPDATE STATISTICS in import mode." and "UPDATE

STATISTICS will not run in import mode." will be displayed. This causes

sp_text_notify on EFTS text index table to produce an error "RMTQUERY,

Execution of query 'update statistics <dbname>.<owner>.<text_index>' failed."

in the EFTS log.



CR:375984
CR Number:   375984
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2005 Bundled Request
Description
Query assigning local variable may return incorrect result if the same local variable

is used in the constant expression being a part of OR clause. An example of such

statement would be :

select @var = value from tab where (@var is NULL and col = value ) OR (expression)
Workaround Description
 Use distinct sets of variables for the where clause and the target list

as shown in the repro.



CR:376063
CR Number:   376063
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2005 Fixed
30 Sep 2005 Presently Not Targeted For Any Future Release Of This Product
Description
UNION query will not be executed in a parallel mode if at least one side of the UNION statement

is accessing system table.



CR:376069
CR Number:   376069
Product Name:   Adaptive Server Enterprise
Product Component:   DDLGen
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2005 Fixed
24 Jan 2007 Fixed
Description
DDLGen puts in "null" for "not null" columns in table DDL when "allow nulls by default" is true for a database.



CR:376125
CR Number:   376125
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2006 Fixed
Description
Previously when user opened Data panel for a table or view and sort the data, columns with duplicate values would not sort correctly, with Nulls replacing the duplicate values. This has been corrected.





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