提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:581813
CR Number:   581813
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2010 Not a Bug
Description
trace tracepool causes resource chain error message in RS log.
Workaround Description
 unknown at this time



CR:582192
CR Number:   582192
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   NA
Original Version:   5.7.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15 21 Jul 2009 Fixed
5.8.01 27 Jul 2009 Fixed
5.9.00 21 Jul 2009 Fixed
Description
ASE ONLY: CacheStoreException may be thrown when

user executes sp_recompile in primary database.



CR:582326
CR Number:   582326
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
amboise EBF1 05 Oct 2009 Fixed
Description
followup of 580985

Stereotype should be visible on general tab of repository property sheet



CR:582352
CR Number:   582352
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2009 Fixed
18 Aug 2009 Fixed
20 Aug 2009 Fixed
26 Aug 2009 Fixed
26 Aug 2009 Fixed
14 Sep 2009 Fixed
Description
When bulk copy feature is used and tempdb is full, transaction does not retry and is missed in replicate database.



CR:582386
CR Number:   582386
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In PowerDesigner, end users have the option to display the Name or Code for objects in the Browser. The customer is requesting that this same option be available in the Web Repository.



CR:582388
CR Number:   582388
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Show/display the column's datatype when I click on the <<Columns>> item under a table object instead of having to drill down into the Attributes tab page to get to the data type information.



For quick lists, it would be more useful/helpful to see simple details of a column at the column list level of the table (name, code, datatype). We realize that viewing this same metadata connected to the repository in the PD Client interface also presents the same behavior. However, having name, code, datatype and possibly the domain is certainly more useful when seeing the (quick) list of columns on a table than having to drill down into the attributes tab to see even more details of the column object.



CR:582641
CR Number:   582641
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 23 Mar 2010 Added to user documentation
Description
Request to add info/link on setting the ReturnNativeError in ECDA to work with RepServer's Native Error Code handling.



CR:582768
CR Number:   582768
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Some characters could not be converted into client character set during check in.

Unconverted bytes changed to 'inverted question mark ( U+00BF).



CR:582831
CR Number:   582831
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 28 05 Aug 2009 Fixed
Description
Any IP address whose first node > 127 will fail IP syntax.
Workaround Description
 None. Fix is in minimum 15.0 ESD #3 build #28.



IP address has to be less than or equal to 127. If using hostname option, hostname has to be less than 24 characters.



CR:582948
CR Number:   582948
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2009 Fixed
21 Sep 2009 Fixed
01 Oct 2009 Fixed
Description
When definition of procedure is modified and model is updated in the repository, the extended dependency between that procedure and a table is removed from the repository database.

The Check In window does not show deletion.



CR:583144
CR Number:   583144
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2009 Fixed
16 Aug 2009 Fixed
Description
Replication Agent is unable to start up

when LD_LIBRARY_PATH_64 environment setting

is defined in the environment.



CR:583240
CR Number:   583240
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2009 Fixed
Description
6025 re-occurred with sqm first_read = next_read ptr



CR:583404
CR Number:   583404
Product Name:   Common Metadata Repository
Product Component:   Documentation
Status:   Open
OS:   Windows
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the instructions to install the EBF are incomplete.

Step 6 states the following:



6. Restore any 3rd party class libraries from the backup in Step 3.



The problem is that the CMR directory does not exist in the webapps directory.



In order to rebuild the cmr directory, you must first restart the server.





Step 5a should be something like:



restart the application server which will rebuild the cmr directory structure.



This would then be followed by step 6.



CR:583459
CR Number:   583459
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2009 Fixed
05 Nov 2010 Fixed
08 Nov 2010 Fixed
Description
Some Japanese messages are displayed in utf8 code.



CR:583496
CR Number:   583496
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2009 Fixed
30 Jul 2009 Fixed
Description
ORACLE ONLY: After restarting Replication Agent,

the mirrored device path information set by the

ra_devicepath command is not retained.



CR:583567
CR Number:   583567
Product Name:   Replication Management
Product Component:   Access Library
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2009 Fixed
Description
Replication:

Authenticating a Replication Sever before its ASE servers have been authenticated causes a Null Pointer Exception to occur.



CR:583737
CR Number:   583737
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2012 Insufficient priority to fix
Description
rs_subcmp is incorrectly reporting inconsistent rows on text/image columns.



CR:583844
CR Number:   583844
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2009 Fixed
13 Aug 2009 Fixed
22 Oct 2009 Fixed
Description
When Replication Server is not available,

executing 'ra_locator update' causes Replication

Agent to throw an exception.



CR:584130
CR Number:   584130
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2010 Fixed
Description
Provide support for SySAM sub-capacity.



CR:584138
CR Number:   584138
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
RS 15.2 ESD #1 needs updated OCS to complete the fix for 556327 that was delivered in 15.1 EBF 16814
Workaround Description
 none....do not upgrade



CR:584350
CR Number:   584350
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New counter to track number of CLR's (compensating log records) processed.



CR:584351
CR Number:   584351
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request to make RS more robust so that even if it is short on memory or heavily loaded, that it will break out of it's loop to service a login request.



CR:584357
CR Number:   584357
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for engineering supported, QA'd, and documented procedure on moving the ID server to a new server.



CR:584418
CR Number:   584418
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2009 Fixed
14 Oct 2009 Fixed
Description
ORACLE ONLY: rs_create_repdef fails to create

replication definition for a table containing

an OBJECT column.
Workaround Description
 Create table replication defination manually by Rep Server command.



CR:584477
CR Number:   584477
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS error 6025 - Block consistency failed - in RS 12.6 EBF 15502 Instrumented binary.



CR:584529
CR Number:   584529
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2009 Fixed
14 Sep 2009 Fixed
03 Mar 2010 Fixed
Description
rs_segments table is corrupted and Replication Server can not process queue.



CR:584548
CR Number:   584548
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2012 Fixed
Description
sqm_cache_enable and sqm_seg_prealloc not added in upgrade to 15.1 or 15.2
Workaround Description
 Add the values manually. The default, if the values do not exist, is equal to on.



insert into rs_tvalues values ("sqm_cache_enable", "CF", 1, "on", "on", 0)

insert into rs_tvalues values ("sqm_seg_prealloc", "CF", 1, "on", "on", 0)



insert into rs_config(optionname, objid, charvalue, status, comments)

values("sqm_cache_enable", 0x0000000000000000, "on", 0,

"'on' enables SQM caching option.")

insert into rs_config(optionname, objid, charvalue, status, comments)

values("sqm_seg_prealloc", 0x0000000000000000, "on", 0,

"'on' enables SQM segment prealloc option.")



akirkpat - January 15, 2010



insert into rs_tvalues values ("sqm_cache_size", "CF", 1, "16", "16", 0)

insert into rs_tvalues values ("sqm_page_size", "CF", 1, "4", "4", 0)





insert into rs_config(optionname, objid, charvalue, status, comments)

values ("sqm_cache_size", 0x0000000000000000, "16", 0,

"Size of SQM cache in number of pages.")

insert into rs_config(optionname, objid, charvalue, status, comments)

values ("sqm_page_size", 0x0000000000000000, "4", 0,

"Size of SQM page in number of 16KB blocks.")

go



CR:585278
CR Number:   585278
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5522P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2009 Fixed
18 Aug 2009 Fixed
19 Aug 2009 Fixed
19 Aug 2009 Fixed
Description
ASE ONLY: Transactions made by maintainace user

are replicated to replicate database when primary

data base is in warmstandy mode and

Replication Agent "filter_maint_userid" property

is set true.



CR:585307
CR Number:   585307
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2010 Fixed
08 Nov 2010 Fixed
23 Feb 2012 Insufficient priority to fix
08 Nov 2010 Fixed
12 May 2011 Fixed
Description
Replication Server does not open the partition in DIO mode even though the sqm_write_flush is set to 'dio' on RHEL 5.3 LVM raw block devices.



CR:585332
CR Number:   585332
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2009 Fixed
Description
The timestamp in the

name backup directory

name does not match

backup timestamp.



CR:585476
CR Number:   585476
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 23 Mar 2010 Added to user documentation
Description
erssd defrag details need to be documented in Admin Guide



CR:585513
CR Number:   585513
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 18 Aug 2009 Fixed
Description
ORACLE ONLY:

RepAgent initialization fails

in Oralce RAC environment.
Workaround Description
 Workrouand 1:

set the value of hidden property pdb_support_serializable to false.

Note. without setting isolation level to serializable, no DDL is allowed d

uring initialization, or it will cause repository inconsistent with the primary.



Workrouand 2:

This is Oracle bug #5695610 - ORA-600 [kxfpgsg] can occur using ISOLATION_LEVEL set to SERIALIZABLE in a RAC environment. It has been fixed in patch #5695610, Server Patch Set 10.2.0.4 and 11.1.0.6 (Base Release).



CR:585802
CR Number:   585802
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
capability to override stable device processing errors using rows in rs_segments.



CR:585987
CR Number:   585987
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
Description
TRUNCPT doesn't move and coincides with not getting results from e,status e,logingo and e,showrba console commands.
Workaround Description
 Reboot after moving the truncpt to something more valid



CR:586049
CR Number:   586049
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2009 Fixed
Description
Added new trace flag RSTICKETTRC to trace

rs_ticket processing in the Replication Agent

system log.



CR:586297
CR Number:   586297
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The sp_reptostandby db_name, NONE" isn't executed when db repdef is dropped via Central, then replication setting remains. It should be set to NONE.
Workaround Description
 execute sp_reptostandby db_name, 'NONE' from isql.



CR:586538
CR Number:   586538
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 20 Aug 2009 Fixed
5.8.01 25 Aug 2009 Fixed
Description
ORACLE ONLY: Replication Agent de-initialization

without the force option can be executed

successfully even if marked user tables and

procedures still exists.



CR:586567
CR Number:   586567
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Fixed
13 Oct 2009 Fixed
08 Sep 2009 Fixed
Description
Improved the error message returned from executing

rs_create_repdef when Replication Server is not

accessible.



CR:586589
CR Number:   586589
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #2 12 Oct 2009 Fixed
15.5 15 Sep 2009 Fixed
Description
ORACLE ONLY: The ra_updatedevices command does not

load ASM disk mappings from the property file into

the repository.
Workaround Description
 1.After RASD is initialized, issue pdb_asmdiskmap to generate asm disk map file



2.To solve ra_updatedevices does not update mirrored asm path:

First, issue pdb_asmdiskmap to generate asm disk map file after ra_init; set the asm mirror path. ra_deinit and ra_init again so that the asm disk map is set to ASM device during initialization.



CR:586675
CR Number:   586675
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 23 Mar 2010 Fixed
Description
Replication Server 15.2 > Replication Server 15.2 Configuration Guide for UNIX >

Upgrading or Downgrading an Existing Replication Server



Replication Server 15.2 for UNIX

Document ID: DC35817-01-1520-01

Last revised: February 2009



...



5.

If the Replication Server uses embedded RSSD, edit the rs_name.cfg file,

where rs_name is your Replication Server:



Add the erssd_release_dir parameter to specify the location of the pre-

upgrade SQL Anywhere. For example:



erssd_release_dir=/work1/sybase/REP-15_1/ASA9

Add the erssd_start_cmd parameter to specify the command to start ERSSD.



Obtain the name and location of the Replication Server you are upgrading,

and the port number of the Replication Server RSSD, from the interfaces

file. You can find an example of the parameter in the Replication Server

log file by searching for ERSSD start command. For example:



erssd_start_cmd=/work1/sybase/REP-15_1/ASA9/bin/dbspawn

-f -q /work1/sybase/REP-15_1/ASA9/bin/dbsrv9

-ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO"

-o /work1/sybase/REP-15_1/samp_repserver/errorlog/SAMP_REPSERVER.out

/work1/sybase/REP-15_1/samp_repserver/dbfile/SAMP_REPSERVER.db



...



the following line should have a closing parenthesis...



-ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO)"



CR:586684
CR Number:   586684
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer upgraded from RS 12.6 EBF 15273 to RS 15.2 and they misspelled the two config tokens at the bottom of the config file...



they added the following...



errsd_release_dir=...

errsd_start_cmd=...



they should have added the following spelling...



erssd_release_dir=...

erssd_start_cmd=...



the upgrade process proceeded and gave an error...



CONNECTIVITY ERROR: CT-Library error: 'ct_connect(): network packet layer: inte

rnal net library error: Net-Lib protocol driver call to connect two endpoints f

ailed'.

Press <return> to continue.



CR:586694
CR Number:   586694
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2011 Fixed
24 Feb 2012 Insufficient priority to fix
Description
Error message in ERSSD server log like "Cannot set a temporary option for user 'rstest_RSSD_prim'".
Workaround Description
 isql -S<rsname>_erssd -U<rsname>_RSSD_prim -P<rsname>_RSSD_prim_ps -w2048

if exists (select proc_name from SYS.SYSPROCEDURE

where proc_name = 'rs_startup_procedure' and creator = 3)

then

drop procedure dbo.rs_startup_procedure

end if

go



/*

** We need to recreate this startup procedure to remove the

** set temporary option TSQL_HEX_CONSTANT = 'ON';

** set temporary option FLOAT_AS_DOUBLE = 'ON';

** set temporary option PERCENT_AS_COMMENT = 'OFF';

** because these cause the following errors in the new version of SQLAnywhere

**

** isql -S<rsname>_erssd -U<rsname>_RSSD_prim -P<rsname>_RSSD_prim_ps -w2048

** 1> select @@version

** 2> go

** @@version

** -----------

** 11.0.0.1266

** (1 row affected)

** 1> set temporary option TSQL_HEX_CONSTANT = 'ON';

** 2> go

** Msg 13687, Level 16, State 0:

** SQL Anywhere Error -203: Cannot set a temporary option for user 'rstest_RSSD_prim'

** 1> set temporary option FLOAT_AS_DOUBLE = 'ON';

** 2> go

** Msg 13687, Level 16, State 0:

** SQL Anywhere Error -203: Cannot set a temporary option for user 'rstest_RSSD_prim'

** 1> set temporary option PERCENT_AS_COMMENT = 'OFF';

** 2> go

** Msg 13687, Level 16, State 0:

** SQL Anywhere Error -203: Cannot set a temporary option for user 'rstest_RSSD_prim'

** 1> quit

**

*/



create procedure dbo.rs_startup_procedure()

begin

if (connection_property('CommProtocol') = 'TDS') then

set temporary option TSQL_VARIABLES = 'ON';

set temporary option CHAINED = 'OFF';

set temporary option QUOTED_IDENTIFIER = 'OFF';

set temporary option ALLOW_NULLS_BY_DEFAULT = 'OFF';

set temporary option ON_TSQL_ERROR = 'CONTINUE';

set temporary option ISOLATION_LEVEL = '1';

set temporary option DATE_ORDER = 'MDY';

set temporary option ANSINULL='OFF';

set temporary option ANSI_BLANKS='ON';

set temporary option DATE_FORMAT='YYYY-MM-DD';

set temporary option TIMESTAMP_FORMAT='YYYY-MM-DD HH:NN:SS.SSS';

set temporary option TIME_FORMAT='HH:NN:SS.SSS';

set temporary option ESCAPE_CHARACTER='OFF'

end if

end

go

grant execute on dbo.rs_startup_procedure to public

go

set option PUBLIC.LOGIN_PROCEDURE = 'dbo.rs_startup_procedure'

go



CR:587237
CR Number:   587237
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
RS15.2 ESD1 Solaris: silent install does not work
Workaround Description
 (1) Use console mode



(2) Specify the flag ...



-W SybaseLicense.agreeToLicense=true



CR:587254
CR Number:   587254
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.12 15 11 Sep 2009 Fixed
Description
JCL(SQLINIT) and JC:(PINGRS) are empty.
Workaround Description
 Use the GA versions of these two members.



CR:587261
CR Number:   587261
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Open
OS:   Microsoft Windows
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Connection property "Error class" always defaults to rs_db2_error_class.



CR:587383
CR Number:   587383
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2010 Fixed
29 Nov 2010 Fixed
21 Jun 2011 Fixed
Description
In RS 15.x still need to increase size for subscription name; repdef can be 255 chars but subscription only 30.
Workaround Description
 None known.



CR:587405
CR Number:   587405
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Not a Bug
Description
15.0 software has .tgz extension instead of .zip extension.
Workaround Description
 Ignore the extension. Download software to PC and unzip on the PC and proceed to install the software.



CR:587412
CR Number:   587412
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Presently Not Targeted For Any Future Release Of This Product
Description
FTP to mainframe does not complete and cannot find the .docs file.
Workaround Description
 When un-zipping the file, complete the unzip by putting the files somewhere on disk. Then click to run the setupwin32.exe. Do not start the RA DB2 installation from the Winzip box.



CR:587537
CR Number:   587537
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2009 Fixed
13 Oct 2009 Fixed
08 Sep 2009 Fixed
Description
ORACLE ONLY: Replication Agent sends an incorrect

LTL-formatted string to Replication Server for a

timestamp in a user-defined datatype when

pdb_convert_datetime is set to true. This causes

the Replication Server DSI to go down.



CR:587655
CR Number:   587655
Product Name:   Rep Server Configuration Guide
Product Component:   Rep Server Configuration Guide
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 25 Mar 2010 Added to user documentation
Description
add note that user can revoke sa_role of primary_user after RSSD upgrade is complete.



CR:587679
CR Number:   587679
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15 02 Sep 2009 Fixed
15.2 ESD #2 10 Oct 2009 Fixed
5.9.00 02 Sep 2009 Fixed
Description
ASE ONLY: Mirror Replication Agent initialization

fails with error "No entry exists for id <XXX>".
Workaround Description
 Shutdown and restart the Mirror Rep Agent to clear the corrupt information from memory.



CR:587731
CR Number:   587731
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 26 Mar 2010 Fixed
Description
The parameter, dsi_bulk_threshold, is typed as dis_bulk_threshold



CR:587757
CR Number:   587757
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2009 Duplicate
Description
After the execution of the 'drop replication definition' command, the

execution of additional commands such as 'create replication

definition', 'drop subscription', etc. may result in a deadlock in the

RSSD. To recover from this behavior, restart the Replication Server.



CR:587816
CR Number:   587816
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 31 Aug 2009 Fixed
5.8.02 12 Oct 2009 Fixed
5.7.15 01 Sep 2009 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

throws a NullPointerException when the

ra_truncatearticles or rasd_trunc_schedule 'force'

command is executed twice.



CR:587910
CR Number:   587910
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Additional information on load utility and compressed records.



CR:587913
CR Number:   587913
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 23 Mar 2010 Not a Bug
26 Jan 2010 Fixed
Description
There is no documentation on the new fucntion class rs_asa_function_class.



CR:587926
CR Number:   587926
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 23 Mar 2010 Added to user documentation
Description
no documentation on dist_sqt_max_cache_size.



CR:587931
CR Number:   587931
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15 10 Sep 2009 Fixed
15.2 ESD #2 10 Oct 2009 Fixed
15.5 28 Sep 2009 Fixed
Description
ASE ONLY: Mirror Replication Agent initialization

fails due to insufficient privilege attempting

to select on the audflags,deftabaud,defvwaud,

defpraud columns against the master..sysdatabases

table and the password column against the

master..syslogins table.
Workaround Description
 Grant the MA (pds_username) user sso role



CR:588030
CR Number:   588030
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 31 Aug 2009 Fixed
15.2 ESD #2 12 Oct 2009 Fixed
5.7.15 01 Sep 2009 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

returns an unformatted error message "The last

saved truncation point <{0}> is less than database

truncation point <{1}>." when attempting to save

the truncation point that is less than the

database truncation point.



CR:588206
CR Number:   588206
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2009 Fixed
03 Feb 2010 Fixed
Description
reproduce:

1.go to search after login

2.click any model and input "AnyMetaClass:AnyMetaAttribute LIKE *a*" to search

no result return and there is an error in the tomcat as follows:



CR:588225
CR Number:   588225
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 14 Oct 2009 Fixed
5.8.02 27 Oct 2009 Fixed
Description
ORACLE ONLY: Automatically generated replication

definition is not automtically dropped when table

is unmarked for replication or table is dropped.



CR:588281
CR Number:   588281
Product Name:   Rep Serv What's New
Product Component:   Rep Serv What's New
Status:   Closed
OS:   all
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 22 Mar 2010 Fixed
Description
Replication Server error class and row count validation for non-SQL Statement replication is not documented in 15.2 NFG



CR:588398
CR Number:   588398
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #1 08 Jun 2010 Not reproducible with latest version of the product available as of Resolution Date
15.2 ESD #1 16 Sep 2009 Fixed
5.9.00 16 Sep 2009 Fixed
Description
ORACLE ONLY: Replication Agent throws

NullPointerException when trying to dump detail

information of problem log record.



CR:588492
CR Number:   588492
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   closluce EBF7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Requesting change behavior, when a User has Read_only access to a Repository Document only.



-> A Prompt for Overwrite if document exists as read-only Version locally.

-> A popup Error Message, when Write to File fails.

-> Clean up the different behavior of Treelist and Menu Options

-> Do not offer Merge Document if User has read-only authorization.



CR:588695
CR Number:   588695
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_asa_function_class doesn't provide proper rs_raw_object_serialization function string implementation for ASA.
Workaround Description
 1> create function string class asa_test_class

2> set parent to rs_asa_function_class

3> go

Function string class 'asa_test_class' is created.



1> create function string rs_raw_object_serialization

2> for asa_test_class output language ''

3> go

Function string 'rs_raw_object_serialization' is created.



- alter connection

- resume connection



CR:589012
CR Number:   589012
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15 13 Sep 2009 Fixed
5.8.01 13 Sep 2009 Fixed
5.9.00 13 Sep 2009 Fixed
Description
ASE ONLY: Mirror Replication Agent causes

Replication Server to fail with error

"Failed to convert from char type to

numeric type" when replicating with Dynamic

SQL option enabled. It may also cause error

"No value or default value available and

NULL not allowed" when DSI Bulk Option

is enabled.



CR:589328
CR Number:   589328
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2009 Fixed
09 Sep 2009 Fixed
13 Oct 2009 Fixed
Description
ORACLE ONLY: National character in user defined

type is not processed correctly.



CR:589841
CR Number:   589841
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2010 Consult Complete
06 Jan 2010 Fixed
Description
change rs_ticket_report function string to ANSI standard SQL
Workaround Description
 Here is the workaround:



create function string class db2_function_class_2 set parent rs_db2_function_class



create function string rs_ticket_report for db2_function_class_2

output language '

insert into rs_ticket_history(h1,h2,h3,h4,pdb,prs,rrs,rdb,pdb_t,

exec_t,dist_t,rsi_t,dsi_t,exec_b,rsi_b,dsi_tnx,

dsi_cmd,ticket) values(?h1!param?, ?h2!param?, ?h3!param?,

?h4!param?,?rs_origin_db!sys?, ?prs!param?, ?rrs!param?, ?rs_destination_db!sys?, ?pdb!param?, ?exec!param?, ?dist!param?,

?rsi!param?, ?dsi!param?, ?b!param?,

?rsi_b!param?, ?dsi_t!param?, ?dsi_c!param?,

?rs_ticket_param!param?)'



suspend connection to dataserver.database

go



alter connection to dataserver.database

set function string classs to db2_function_class_2

go



resume connection to dataserver.database

go



CR:590047
CR Number:   590047
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE dataserver error 323 should be mapped to warn.
Workaround Description
 Set 323 to warning:

insert rs_erroractions (ds_errorid, errorclassid, action, prsid) values (323, 0

x0000000001000002, 3, 0)



To set 323 to ignore:

insert rs_erroractions (ds_errorid, errorclassid, action, prsid) values (323, 0

x0000000001000002, 1, 0)



This is the default rs_sqlserver_error_class



CR:590248
CR Number:   590248
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
create a config option in RepServer to suppress messages like the following from showing up in the RepServer log ...



I. 2009/04/01 14:16:43. Replication Agent version (710) for 'ds.db' does not match the default LTI version for this Replication Server 700 using version 700.

...



CR:590307
CR Number:   590307
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   XP
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2009 Not a Bug
Description
Error from upgrading repository MS SQL database From 15.0 EBF 8 to version 15.1

*** Executing SQL statement 20:

alter table PMBPMS add AVSN varchar(254) null



[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

SQLSTATE = 37000

*** Executing SQL statement 27:

alter table PMDVTL add AVSN varchar(254) null



[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

SQLSTATE = 37000



CR:590417
CR Number:   590417
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2009 Fixed
Description
ORACLE ONLY: A new option has been added to

'ra_dumptran' that allows the user to obtain

detailed information about database operations

and database operations in a transaction by

specifying the Oracle transaction ID.



Command ra_dumptran



Description:



Command ra_dumptran dumps all operations for a

specified transaction to an exclusive log file

in order to help trouble shoot a failed

operation, or transaction. The time the

transaction was executed, the user that executed

the transaction, the name of the log the

transaction was dumped to, and additional

database specific information is displayed as a

result set.



If the Oracle script



$ORACLE_HOME/rdbms/admin/dbmslm.sql



has not been installed at the primary database,

an error will be reported indicating it must be

installed in order for the ra_ dumptran command

to properly operate.



If the new permissions that must be granted to

the "pds_username" are not granted at the time

ra_ dumptran is executed, an error will be

reported indicating the following permission's

must be granted before the ra_ dumptran command

will properly work:



EXECUTE_CATALOG_ROLE TO PDS$USER;

SELECT ON V$LOGMNR_CONTENTS TO PDS$USER;

SELECT ON V$LOGMNR_LOGS TO PDS$USER;

SELECT ANY TRANSACTION TO PDS$USER;



If a public synonym that must be created for

"SYS.DBMS_LOGMNR" is not created, an error will

be reported indicating that "DBMS_LOGMNR" does

not exist.



CREATE PUBLIC SYNONYM DBMS_LOGMNR FOR SYS.DBMS_LOGMNR;





Syntax: ra_dumptran "opid | locator | xid"



Opid - The Replication Agent operation id for a

database operation



Locator - The Replication Agent locator for a

database operation



Xid - The Oracle transaction ID for the

transaction



Example 1:



ra_dumptran

0x0000.01542e48.0001:0001.000002dc.00000004.0010



This command returns information for the begin

operation in the transaction specified by an

operation ID.



Information for every operation in the transaction

is written to a file in the Replication Agent log

directory. The file is named with the prefix

"XID" followed by the transaction ID and ".log".



Example:



$RAX_DIR/<INSTANCE_NAME>/log/

XID0005.002c.0000002c.log



Example 2:



ra_dumptran

0000000001544ada00060001000002de00000008001000000

000000000000000



This command returns information for the begin

operation in the transaction specified by an

locator.



Example 3:



ra_dumptran 0x0007.002a.000032f0





This command returns information for the begin

operation in the transaction specified by a

transaction Id.



Usage:



The ra_dumptran command returns the following

information for the begin operation specified by a

locator or operatin ID:



- The Replication Agent operation id for the

transactions begin operation in the format:



wrap.scn.subscn.thread.lsn.block.offset



- The Oracle SCN for the transactions begin

operation as logged in a redo log file



- The Oracle id for the transactions begin

operation



- The name of the user that executed the

transaction



- The date and time the transaction executed



- The Oracle thread that transaction was executed

on



- The Replication Agent command that will cause

the transaction to be skipped by the Replication

Agent while replicating



- The name of the file the transaction is written

to



The ra_dumptran command wtites the following

information for for all operations in

the transaction specified by a locator or

operation ID:



- The Oracle SCN for the operation as logged in a

redo log file



- The Oracle thread that operation was executed

on



- The Replication Agent operation id for the

transaction begin operation in the format:



wrap.scn.subscn.thread.lsn.block.offset



- The Oracle id for the object the operation

affected



- The Oracle name of the object the operation

affected



- YES if the object in the operation is marked

for replication by the Replication Agent, No

if it is not marked for replication



- The operation type, i.e. INSERT, UPDATE, DELETE



- The Oracle SQL statement for the operation



CR:590677
CR Number:   590677
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2009 Not a Bug
Description
rs_init with "Initialize standby using dump and load" = yes, does not create the maintenance user on the standby server.
Workaround Description
 Create the user id manually with sp_addlogin



--or--



when creating the connection to the standby database, use the option "Initialize standby using dump and load" = no



CR:590802
CR Number:   590802
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   NA
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
New Feature ..edit server event trigger script to change location/name instead of drop and re-add
Workaround Description
 be sure to make a good copy/backup of any file before manually editing it



edit the ...

{$SYBASE_UA}/plugins/com.sybase.rms/config/rms-config.xml

for example {$SYBASE} = /sy/rs3x152e1

{$SYBASE_UA} = {$SYBASE}/UAF-2_0

...so the fully qualified file location would be ...

/sy/rs3x152e1}/UAF-2_0/plugins/com.sybase.rms/config/rms-config.xml

... to change the event trigger locations and script names rather than deleting each event then re-entering



CR:590833
CR Number:   590833
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 17 Jul 2011 Fixed
Description
ORACLE ONLY:

Replication Agent supports

replication from Oracle

archive logs only (no online).



CR:590908
CR Number:   590908
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Open
OS:   Generic
Original Version:   5.7.13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15
Description
FOR ASE ONLY:

Add new LTL trace to trace

begin/commit/rollback only.

The trace name is LTITRACETRAN.



CR:591008
CR Number:   591008
Product Name:   RepAgent for MVS
Product Component:   RepAgent for MVS - DOC
Status:   Open
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DB2 DBRMLIB library name no longer needed for installation and configuration.
Workaround Description
 leave line blank



CR:591251
CR Number:   591251
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTM
Status:   Open
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2009 Fixed
Description
A new state Replication Down has been added

that will be entered whenever an error occurs

during Replication. In addition, all commands

and properties that were restricted to ADMIN

state are now also editable in Replication Down

state.



CR:591679
CR Number:   591679
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Bundled Request
Description
ASE ONLY: Replication Agent provides two new API

command, ra_deviceoffset and ra_helpdeviceoffset

to set the raw device offset and provide help on

the raw device offset setting.



CR:591804
CR Number:   591804
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Fixed
Description
ORACLE AND MICROSOFT SQL SERVER ONLY:

rasd_restore sometimes fails to restores the

Replication Agent System Data Repository.



CR:591805
CR Number:   591805
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Fixed
Description
ASE AND ORACLE ONLY:

rasd_restore sometimes fails to restores the

Replication Agent System Data Repository.



CR:591806
CR Number:   591806
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Fixed
Description
ORACLE AND MICROSOFT SQL SERVER ONLY:

Invoking 'rasd_trunc_schedule' command with an

invalid date in months does not return an error.



CR:591808
CR Number:   591808
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Fixed
Description
ASE AND ORACLE ONLY:

Invoking 'rasd_trunc_schedule' command with an

invalid date in months does not return an error.



CR:591823
CR Number:   591823
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
admin config "connection" does not display results unless the connection has been resumed (not necessarily successful) since last reboot
Workaround Description
 resume the connection and suspend the connection

--OR--

select the configuration parameters out of rs_config table.



CR:591888
CR Number:   591888
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2009 Fixed
Description
ORACLE ONLY: Marking a table with

securefile LOB and LOB fragment

defined in encrypted tablespace

is successful when it should not

be allowed.



CR:592227
CR Number:   592227
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2009 Fixed
19 Oct 2009 Fixed
Description
The rasd_trunc_schedule command does not return

after attempting to add a schedule date for every

31st day. The schedule looks like "* * 31 * Mon".



CR:592270
CR Number:   592270
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 01 15 Apr 2010 Fixed
Description
After DB2 crash, transactions started before the crash are still open, when DB2 has them either aborted or committed.
Workaround Description
 Currently, RA DB2 sends these log records to RS, however, since no commit or abort is sent for them, the transactions are in the open queue of the RS.



Display the commands created:

on the RS, sysadmin sqt_dump_tran or dump_queue



To eliminate the transaction on the RS:

sysadmin sqm_zap_command --or --

since this is typically the first transaction in the queue, if there is not a lot of data in the inbound queue, can do sysadmin purge_first_open



To eliminate the transaction from the in-flight list in RA DB2:

/f jobname,e,root --or--

start up the RA DB2 from the RBA just after the crash.



CR:592359
CR Number:   592359
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #2 20 Oct 2009 Fixed
15.5 20 Oct 2009 Fixed
Description
The rasd_trunc_schedule add command sets the next

execution time to the next hours/minutes beyond

the current hours/minutes if the hours and minutes

fields in the schedule have multiple values. When

the schedule time is not the current date, and

the smallest value contained in the schedule is

smaller than the current time, the next execution

time picked up by Replication Agent is not the

earlier time in the schedule.



CR:592441
CR Number:   592441
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2009 Fixed
Description
With dynamic SQL, Replication Server stacks when inserting into a table that does not exist.
Workaround Description
 a. do not use dynamic SQL --or--

b. make sure table exists



To get the RS up and going:

1. bring the RS up in standalone mode

2. suspend the outbound connection (and it will say it is already suspended)

3. shutdown the RS

4. Bring up RS in normal mode

5. resume connection, skip transaction



--or--

1. bring up the RS in standalone mode

2. purge the queue or zap the command containing the insert

3. bring down the RS

4. Start up the RS in normal mode



CR:592471
CR Number:   592471
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2009 Fixed
13 Oct 2009 Fixed
Description
ASE ONLY: 'suspend' command in Replication Agent

may take a long time to complete.



CR:592746
CR Number:   592746
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2009 Fixed
Description
In testing this issue, I executed verify Repository data and I get the following result:

PowerDesigner Error:

Missing Parent Relationships (Object without parent): 6344



CR:592898
CR Number:   592898
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ENH: Offer more meaningful error messages to PD client when a check-in (consolidation) fails with "The check in of the document has been cancelled."



There is very little to go by to troubleshoot and address such a problem. Especially, when the ct. cannot provide their model or repository database to us.



Here is the full message presented to their PD client in the Output windowpane:



Checking in the document

'D:\Documents\DataModeling\PD15test.oom'

- Freezing the repository document before check in...

- Checking out the repository document 'PD15test'...

The check in of the document has been cancelled.



CR:592961
CR Number:   592961
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce EBF7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Power Designer has to be killed from task Manager, if there is a Problem in communication with an Oracle Repository either due to a connectivity issue or becaue of the try to check in a corrupt modell. In this case a Modell was corrupted and for somewhat reason had 2 identintical unique key values.

Checking in the corrupt model in a connection to the Repository without using the Proxy throws and Error and Powerdesigner keeps on reacting



CR:593037
CR Number:   593037
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2009 Fixed
28 Dec 2009 Fixed
Description
After adding subscription, Replication Server crashes.
Workaround Description
 Looking at the code, the core dump may happen when all of the following are true,



1. There is a database subscription for the primary database

2. The primary table in question has at least one text/ image/unitext column, and some database application is updating the column through writetext, something like this,

declare @val varbinary (16)

select @val=textptr(the_text_column) from the_primary_table where a_primary_column = 1

writetext the_primary_table.the_text_column @val with log "hello,world"

3. A repdef for the primary table is marked 'send standby'



Therefore, the simplest work around is to issue

alter replication definition <repdef_name> send standby off

for all the primary table/repdefs described above.



This work around does not have performance impact. When there are one or more repdefs for a primary table, and none of them is marked send standby, repserver uses the union of the primary key of all repdef as the primary key. However, this is not an option if the customer has to use a particular repdef for some other reasons (e.g. the target column or table name is not the same as the primary ones) . In that case, the customer can either replace the writetext command with update (case 2), or drop database subscription and use table repdefs only (case 1).



CR:593151
CR Number:   593151
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2009 Fixed
08 Dec 2009 Fixed
11 Oct 2009 Fixed
07 Jan 2010 Not a Bug
Description
When dynamic SQL and minimal columns are used together, Replication Server reports 'Incorrect syntax near 'FAILED' on update command with only identity column in the set clause.
Workaround Description
 turn dynamic sql off, there is no need to skip transaction....just resume connection after turning dynamic sql off.



CR:593249
CR Number:   593249
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2009 Fixed
07 Dec 2009 Fixed
09 Oct 2009 Fixed
11 Oct 2009 Fixed
28 Dec 2009 Fixed
28 Dec 2009 Not a Bug
Description
When using dynamic SQL to ASE and there is a deadlock at the replicate, the command(s) prior to the deadlock within the same transaction are not applied.
Workaround Description
 language works fine; dsql doesn't. Don't use dsql where there is a possibility to get deadlocks.



CR:594039
CR Number:   594039
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2009 Fixed
13 Jan 2010 Fixed
07 Jan 2010 Fixed
Description
The SAMPLE_RS cannot be created by 'rs_init' if the environment variable

LD_LIBRARY_PATH_64 is set and does not contain the correct pathnames.

To work around this issue, prior to starting 'rs_init', merge the values

of the environment variables LD_LIBRARY_PATH and LD_LIBRARY_PATH_64 and

set both environment variables to this merged value.
Workaround Description
 Prior to starting 'rs_init', merge the values of the environment

variables LD_LIBRARY_PATH and LD_LIBRARY_PATH_64 and set both

environment variables to this merged value.



CR:594062
CR Number:   594062
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2010 Fixed
Description
If the Replication Server 15.5 Installer response file is created to

indicate that the installer should start the SAMPLE_RS during a silent

install, the installer fails to do so.



CR:594341
CR Number:   594341
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
deadlock of rs_oqid and resume queue, results in un-applied transactions as duplicates.
Workaround Description
 To prevent the deadlock, change the RSSD to row level locking. Once the deadlock has occurred and SQM is down, reboot the RS. Do not resume the queue.



CR:594417
CR Number:   594417
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After the Replication Server 15.5 Installer has completed the creation

of the SAMPLE_RS, the subsequent installer panel incorrectly enables the

'Previous' button and allows the user to navigate to the previous panel

to create the SAMPLE_RS again.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


-------------------------------------------------------------------------------------------

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


-------------------------------------------------------------------------------------------

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------