提供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:617011
CR Number:   617011
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)
04 May 2010 Duplicate
Description
When replicating to IQ, Replication Server inexplicably fails to

replicate any and all grouped transactions. In order to replicate them

successfully, Replication Server is forced to ungroup the transactions.



CR:617022
CR Number:   617022
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.24 09 Mar 2010 Fixed
5.8.02 10 Mar 2010 Fixed
5.7.16 10 Mar 2010 Fixed
5.5.24 23 Mar 2010 Fixed
5.8.02 16 Apr 2010 Fixed
Description
ORACLE ONLY: Replication Agent stops replicating

and reports "java.lang.IllegalState Exception:

No applicable system object found" for DDL

commands when processing large create global

temporary table DDL commands in the redo log.



CR:617406
CR Number:   617406
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2010 Fixed
10 Nov 2010 Fixed
07 Jun 2012 Fixed
Description
Signal 11 in function _sqt_check_bulk() when bulk is enabled.
Workaround Description
 turn off dsi_bulk_copy



CR:617445
CR Number:   617445
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   unknown
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2010 Fixed
25 Mar 2010 Fixed
25 Mar 2010 Fixed
24 Mar 2010 Fixed
Description
ORACLE ONLY: Replication Agent fails to replicate

NCHAR data correctly when there is both a database

level and a table level replication definition.



CR:617530
CR Number:   617530
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 04 15 Apr 2010 Fixed
Description
ECSA memory is not freed when RA DB2 shuts down.
Workaround Description
 Manually free it with customer purchased tools. In RA DB2 12.6, we had module called LTMFREE which could be used to release the ECSA memory if you knew where the allocation was (the allocation message is in the jesmsglg of the RA DB2). However, that module is not available in 15.0 RA libraries.



CR:617535
CR Number:   617535
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support_DB2_comp_rec description of options is opposite of how it behaves.



CR:617567
CR Number:   617567
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 04 15 Apr 2010 Fixed
Description
Time portion of column of datatype TIME is zeroed out when minimum_year is invoked on another column.
Workaround Description
 None



CR:618015
CR Number:   618015
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)
05 Feb 2010 Duplicate
Description
Time is not being converted to LTL properly, it is always 00:00:00 when mimimum year is used to add a default date in the datetime field.



CR:618045
CR Number:   618045
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2010 Work as design
Description
Startup fails. Attempting to use RS_charset=cp1251, RS_sortorder=rusnocs. Raising error: INTERNAL ERROR #52 : Failed to map a local name to an object id!
Workaround Description
 In order to use charset cp1251, and sort order rusnocs.srt,

a line must be added to SYBASE/config/objectid.dat

(on WinX86: SYBASE/ini/objectid.dat) in the "[collate]"

section.



Note this info from $SYBASE/charsets/cp1251/rusnocs.srt:



> class = 0x01 ; Class `1' sort order

> id = 0x3B ; Unique ID # (59) for the sort order

> name = rusnocs_cp1251

> menuname = "Russian case-insensitive dictionary ordering."

> charset = cp1251





Based on that, the following row must be added

to objectid.dat [collate]:



> 1.3.6.1.4.1.897.4.9.3.59 = rusnocs



CR:618437
CR Number:   618437
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
rs_lmconfig utility to configure license management-related information



CR:618624
CR Number:   618624
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2010 Added to user documentation
Description
multiple srv_spawn errors will stack RS.
Workaround Description
 Because this is erssd, bring up RS in maintenance mode to start up ERSSD. Increase num_threads, shutdown the RS. Then start up the RS nromally



CR:618812
CR Number:   618812
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is requesting for the ability to control (enlarge) the diagram window size on CMR (more than just zooming in/out)



The customer feels that the SVG option is not enough. They would like the ability to resize the control area where the diagram is viewable.



CR:618835
CR Number:   618835
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2010 Fixed
23 Aug 2010 Fixed
Description
The Replication Server crashes due to a signal 8 in sqt_LoadCache() if Parallel DSI and SMP are enabled.



CR:619049
CR Number:   619049
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 11 Mar 2010 Fixed
TBD 30 Sep 2011 Presently Not Targeted For Any Future Release Of This Product
TBD 08 Oct 2010 Added to user documentation
Description
In an RMP environment that contains multiple warm-standby pairs, if you select multiple logical connections and choose "switch active" so that they all attempt to switch simultaneously, the following error message appears: "Internal Error - Sybase Central".
Workaround Description
 Switch each warm-standby pair individually, waiting until the switch active completes before switching the next warm-standby pair.



CR:619074
CR Number:   619074
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)
01 Mar 2010 Fixed
28 Oct 2010 Fixed
Description
ORACLE ONLY: Replication Agent goes to the ADMIN

state when replicating an insert or update for a

table containing a nested table column.



CR:619161
CR Number:   619161
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
Allow DDL to be applied with a different user id than what was at the primary.



CR:619180
CR Number:   619180
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2010 Fixed
Description
updates on pdb_setrepddl doc include ensuring that the database replication definition with DDL enabled exists if use_rssd is true PRIOR to resuming the Replication Agent, and the disclaimer that the syntax of the DDL command that is being replicated must be compatible with the syntax of the replicate DBMS.



CR:619187
CR Number:   619187
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 25 Feb 2010 Fixed
15.2 ESD #3 25 Feb 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: When the pdb_get_column

command is executed, Replication Agent

fails with a NullPointerException.
Workaround Description
 None



CR:619248
CR Number:   619248
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Solaris
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2010 Fixed
20 Apr 2010 Fixed
16 Mar 2010 Fixed
20 Apr 2010 Fixed
Description
Replication Agent does not properly handle

accumulating SySAM unserved licenses if there is

more than 1 license file with unserved CPU

licenses.



CR:619290
CR Number:   619290
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2010 Duplicate
Description
pdb_setreptable query has incorrect column names in the query against Oracle
Workaround Description
 none



CR:619372
CR Number:   619372
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2010 Fixed
Description
During the check-in or check-out of a document, the Folder list is not sorted in alpha order. Instead, the folders are listed in the order in which they were created.



To reproduce:



1) create a repository

2) create the following folders in this order

a) zeta

b) alpha

c) theta

d) beta



3) refresh the repository browser NOTE: the folders are sorted in alpha order

4) consolidate or extract a model

5) In the Check-In or Check-out window, select a Folder

NOTE: the folders are listed in the order that they were created



CR:619602
CR Number:   619602
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)
27 Feb 2012 Insufficient priority to fix
Description
Update of a text column value to itself causes RepServer to stack and core dump.



CR:619726
CR Number:   619726
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   NA
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.9.00 16 Mar 2010 Fixed
5.9.00 18 Mar 2010 Fixed
Description
ORACLE ONLY: Replication Agent goes to

REPLICATION DOWN state because a table replication

definition is not found. This will occur if both

the column_compression and ltl_send_primary_keys

configurations are enabled and if a database

replication definition does not exist.



CR:619757
CR Number:   619757
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
Dynamic call to turn on RA DB2 traces is traceon= .
Workaround Description
 The Release Bulletin gives the current list and syntax for RA DB2 tracing.



CR:619941
CR Number:   619941
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2010 Fixed
22 Mar 2010 Fixed
Description
The files '%SYBASE%\REP-15_5\doc\errmsg.rs' and

'%SYBASE%\REP-15_5\doc\errmsg.sub' are re-named

'%SYBASE%\REP-15_5\doc\error_messages_rs' and

'%SYBASE%\REP-15_5\doc\error_messages_subcmp',

respectively.



CR:619964
CR Number:   619964
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
create source ... should be changed to ... connect source ...in rs_tvalues tbl



when using rs_helpuser in the RSSD and a user has been granted both ...

connect source

create object

... permissions the one may see the following incorrect result ...



isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

1> rs_helpuser

2> go

Users and Privileges Known at Site rs3x152e11sx

Primary Users



User Name Permission(s) Name

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

...

rs3x152e11sx_rsi create source, create object
Workaround Description
 update the one row in the rs_tvalues table...



******************************************************************************

isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

select * from rs_tvalues where type = 'USR' and value = 6

go

update rs_tvalues set name = "connect source, create object" where type = 'USR' and value = 6

go

select * from rs_tvalues where type = 'USR' and value = 6

go

quit

******************************************************************************

******************************************************************************

C:\oc15e22\OCS-15_0\bin>isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

1> select * from rs_tvalues where type = 'USR' and value = 6

2> go

name type value dv cv status

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

create source, create object USR 6 0



(1 row affected)

1> update rs_tvalues set name = "connect source, create object" where type = 'USR' and value = 6

2> go

(1 row affected)

1> select * from rs_tvalues where type = 'USR' and value = 6

2> go

name type value dv cv status

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

connect source, create object USR 6 0



(1 row affected)

1> quit



C:\oc15e22\OCS-15_0\bin>

******************************************************************************

******************************************************************************

isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

rs_helpuser

go

quit

******************************************************************************

******************************************************************************

C:\oc15e22\OCS-15_0\bin>isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

1> rs_helpuser

2> go



Users and Privileges Known at Site rs3x152e11sx





Primary Users



User Name Permission(s) Name

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

rs3x152e11sx_id_user no grants

sa sa

rs3x152e11sx_ra connect source

rs3x152e11sx_rsi connect source, create object

ra3x155sx connect source, create object

rs3x152e11sx_RSSD_prim connect source, primary subscr



(6 rows affected)





Maintenance Users



User name Destination DS.DB

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

rs3x152e11sx_RSSD_main rs3x152e11sx_erssd.rs3x152e11sx_erssd

rdb3_maint r6x1503e3sx.rdb3

sys prmry_ora__slingx.ox11gsx



(3 rows affected)

(return status = 0)

1> quit



C:\oc15e22\OCS-15_0\bin>

******************************************************************************



CR:620117
CR Number:   620117
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS runs out of memory with dsi_bulk_copy on.
Workaround Description
 Increase the memory_limit to the max or reduce the size of the transactions. Both of these options are not available to the customer since memory_limit is already at the max and reducing the size of the transactions is not within the customer's control.



CR:620213
CR Number:   620213
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)
02 Mar 2010 Fixed
01 Mar 2010 Fixed
01 Mar 2010 Fixed
23 Dec 2010 Fixed
Description
ORACLE ONLY: Replication Agent fails to resume

after moving the truncation point and setting the

value of the LTM Locator stored in both the

Replication Agent and the Replication Server to

zero.
Workaround Description
 pdb_xlog init,force

go

resume

go



CR:620279
CR Number:   620279
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)
01 Sep 2011 Duplicate
Description
Subscription name length extended to 255 characters.



CR:620380
CR Number:   620380
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)
24 Feb 2012 Presently Not Targeted For Any Future Release Of This Product
24 Mar 2010 Added to user documentation
Description
Cannot re-create the RS when RSSD exists and "create RSSD" is no.
Workaround Description
 1) Drop the RSSD database before creating the server...using the drop datbase <rssd_db_name>.



2) create an empty rssd database by either dropping database objects or dropping the database and recreating the database using create database ... then rs_create_rssd = no ... this combination will work.



CR:620657
CR Number:   620657
Product Name:   Replication Management
Product Component:   Agent Plugins
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2010 Fixed
25 Oct 2010 Fixed
Description
The SCC server console occasionally displays the message "JZ0C0: Connection is already closed".



CR:620673
CR Number:   620673
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
Description
Loop on update(2) record
Workaround Description
 None



CR:620759
CR Number:   620759
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)
07 Mar 2010 Fixed
17 Jun 2010 Fixed
14 Mar 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: Updating a text column

value to itself is replicated as partial update.



CR:620844
CR Number:   620844
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
Message number (EG, LTM01011) should always be the first lexical element



CR:620882
CR Number:   620882
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After installing Replication Server 15.2 ESD#1.1 to 15.2, the message "RSSD has been upgraded to support bulk error action mapping." is printed out.

This message should be printed out as an informational message.



CR:620978
CR Number:   620978
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to get a PDes warning before consolidate if object comment > 2000 characters



CR:621036
CR Number:   621036
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2010 Fixed
23 Mar 2010 Fixed
23 Mar 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: "server_xlog init"

fails with Incorrect syntax near '@tabid' error.
Workaround Description
 Add the '@' character to the pdb_xlog_prefix_chars list.



CR:621068
CR Number:   621068
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 30 Mar 2010 Fixed
Description
Activate and validate subscription syntax shows that it can be used with database replication definitions.



CR:621218
CR Number:   621218
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)
15.6 14 Jul 2010 Fixed
Description
When upgrading to Replication Server 15.5 fails, it will fail again if retrying upgrade.
Workaround Description
 This CR is fixed in RS 15.5 ESD#2, which is renamed to RS 1560. For RS 15.5 ESD#1 and RS 15.5GA upgrade, please apply this work around:



Before retry upgrade again, login to RSSD server and issue the following sql statement:

1. If the 'select into' database option for RSSD is FALSE, enable it.



1> use master

2> go

1> sp_dboption RSSD,'select into',true

2> go

Database option 'select into/bulkcopy/pllsort' turned ON for database 'RSSD'.

Running CHECKPOINT on database 'RSSD' for option 'select into/bulkcopy/pllsort'

to take effect.

(return status = 0)



2. Set the column version in table rs_columns nullable



1> use RSSD

2> go

1> alter table rs_columns modify version rs_id NULL

2> go



3. Restore the 'select into' database option for RSSD



CR:621678
CR Number:   621678
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)
09 Dec 2011 Fixed
30 Mar 2010 Fixed
Description
add instructions to Replication Administration Guide to remove secondary trunc point from replicate MSA db log. This is only for the "define subscription ... use dump marker" scenario, involving a dump/load copy of the db from the primary to the new MSA replicate.



customer's who setup MSA replication can possibly encounter the following

situation.



The dsi to the replicate abnormally stops because the ASE log on the replicate

fills up and requires manual intervention to get the secondary trunc point

removed ... the customer wishes they had been alerted to this situation

by the documentation



add instructions to remove secondary trunc point from replicate MSA db log

here is the present documentation...

****************************************************************************************

****************************************************************************************

Replication Server 15.2

Document ID: DC32511-01-1520-01



http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1520/

html/rsadmin_vol_1/rsadmin_vol_1540.htm



Chapter 12: Managing Replicated Objects Using Multisite Availability

Subscription with bulk materialization

...

1.Dump PDS.pdb. The DSI connection to the replicate database is suspended when the dump marker reaches the replicate Replication Server. It is suspended so that no data will be replicated until you finished step 2. Replication Server activates and validates the subscription automatically when the dump marker is replicated.

WARNING! Do not activate subscription or it will override the wait for dump marker at the Replication Server.

2. Load PDS.pdb to RDS.rdb.

3. Resume the DSI connection to the RDS.rdb.

****************************************************************************************

****************************************************************************************

here is a proposed set of instructions for the documentation change...





Chapter 12: Managing Replicated Objects Using Multisite Availability

Subscription with bulk materialization

...

After you define the subscription:

1 Dump PDS.primary_db. The DSI connection to the replicate database is

suspended when the dump marker reaches the replicate Replication

Server. It is suspended so that no data will be replicated until you

have finished step 2. Replication Server activates and validates

the subscription automatically when the dump marker is replicated.

Warning! Do not activate subscription or it will override the wait for dump

marker at the Replication Server.

2 Load PDS.primary_db to RDS.rdb.

3. Online RDS.rdb

4. Prepare the RDS.rdb as a replicate:

release the secondary truncation point with dbcc settrunc ('ltm',ignore)

optionally, disable the Replication Agent

dump the transaction log

5 Resume the DSI connection to the RDS.rdb.



CR:621843
CR Number:   621843
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   15.2.0.5801P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2010 Fixed
Description
ASE ONLY: Mirror Replication Agent goes to ADMIN

state with an error message similar

to 'IllegalArgumentException: Invalid starting

row for page' after resuming.



CR:621876
CR Number:   621876
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repconnector needs Kerberos support



CR:622028
CR Number:   622028
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   HP-UX
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2010 Not reproducible with latest version of the product available as of Resolution Date
24 Mar 2010 Added to user documentation
Description
When trying to upgrade from RS 15.2 to RS 15.5 using rs_init, upgrade can sporadically fail with the following message when it tries to check if rs_updown_status table is available in the rssd database and does not find it there:



Cannot drop the table 'rs_updown_status', because it doesn't exist in the system

catalogs.



To workaround this issue, a dummy table rs_updown_status should be created in the RSSD and upgrade should be re-done.



CR:622155
CR Number:   622155
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Presently Not Targeted For Any Future Release Of This Product
Description
RA DB2 says tablespace not available
Workaround Description
 Change the LTMOBJECTS to not replicate this table. Use logtrace=yes to figure out the table that is having the issue.



CR:622203
CR Number:   622203
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   15.2.0.5801P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2010 Fixed
21 Apr 2010 Fixed
31 Jul 2013 Insufficient priority to fix
Description
ASE ONLY: Replication Agent stops replicating with

"Transaction LogReader received notification of an

unexpected Thread Death ..." error.



CR:622282
CR Number:   622282
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2010 Added to user documentation
Description
In RepServer 15.2 Reference Guide, Chapter 7 "Executable Programs", "rs_subcmp" section:



The "Syntax" part which list a summary of all parameters usable for "rs_subcmp" command, paramter "-h" and "-H" are missing.



Theses 2 parameters are present in the "Parameters" part which describe in detail usage of each parameter.



CR:622542
CR Number:   622542
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 05 08 Jun 2010 Fixed
Description
LTM01014 message contains truncated RS name



CR:622554
CR Number:   622554
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2010 Fixed
29 Oct 2010 Fixed
Description
For a path that includes an indirect route, the Path Dashboard opens but displays a blank screen with an error in the status bar stating "Error retrieving attribute or data: <path_name>".



CR:622583
CR Number:   622583
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide more intelligence in the code, before stopping the RAO.
Workaround Description
 Currently, the user repository must be in-sync with the Oracle users. Currently, the only way to get them both in sync, if they are out-of-sync, is to pdb_xlog init, force.



CR:622586
CR Number:   622586
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Solaris
Original Version:   15.0.0.5522P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
pdb_skip_op command required double quotes instead of single quotes.
Workaround Description
 use double quotes and use the hex representation:



Instead of pdb_skip_op add, '0x0000.1aa83678.0001','0x0001','0x000000cb.0002fe64.0108'



use: pdb_skip_op add, "0x0000.1aa83678.0001","0x0001","0x000000cb.0002fe64.0108"



CR:622588
CR Number:   622588
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.0.0.5522P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include the xid, transaction id, in the error message to the RAO log. This will make one less step in trying to find the begin, or all commands in a transaction.



CR:622738
CR Number:   622738
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5522P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Add extra message about RASD being out-of-syn when doing pdb_xlog init, move_truncpt
Workaround Description
 The Reference Manual states in the Usage section:



(For Oracle and Microsoft SQL Server) If you move the secondary

truncation point to the end of the primary database transaction log using

pdb_xlog init, move_truncpt, you risk skipping over any DDL commands

record in the log. The DDL commands might have been used by the

Replication Agent to update information stored within the Replication

Agent System Database (RASD). If the RASD contents are incorrect due

to skipping processing of some log records, you may force all of the

schema information in the RASD to be refreshed using command pdb_xlog

init, force. If only the schema for a single object stored in the RASD is of

concern, you can unmark and remark just that single object, which will

force the schema of the object to be reread into the RASD.



Note: on the mark of the table, pdb_setreptable, the immediate option will mark the table and make it immediately available to replicate. Without the immediate option, replication for the table will only occur on rows activity that occurred on or after the mark.



Note: Currently, there is no option available to just refresh the user list on the init,force command.



CR:622748
CR Number:   622748
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.8.20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #3 01 Nov 2010 Fixed
15.2 ESD #3 02 Nov 2010 Presently Not Targeted For Any Future Release Of This Product
Description
ORACLE ONLY: DDL transaction which belongs to

maintenance user was not filtered when

filter_maint_id was true.



CR:622904
CR Number:   622904
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement to use the "shortened version" of LTL for a change which includes only primary keys and changed columns



CR:622921
CR Number:   622921
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2010 Fixed
28 Oct 2010 Duplicate
Description
For a path that includes an indirect route, the Path Dashboard opens but displays a blank screen with an error in the status bar stating 'Error retrieving attribute or data'.



CR:622946
CR Number:   622946
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS password containing numerics results is invalid login.
Workaround Description
 Have an "all alphabetic" password. When used the word "settle" instead of the mix of letters and numbers, the RA was able to proceed.



CR:623129
CR Number:   623129
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2010 Fixed
30 Nov 2010 Fixed
Description
Replication latency monitoring does not show any data when the replicate database is IQ.



CR:623424
CR Number:   623424
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like the ability to define/add a comment on a folder in the repository.



CR:623474
CR Number:   623474
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2012 Insufficient priority to fix
21 Apr 2010 Fixed
Description
RS will not accept new connections while the sqt is removing transactions from the DSIE
Workaround Description
 if feasible, increase sqt_max_cache_size



CR:624026
CR Number:   624026
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   15.2.0.5801P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #3 01 Nov 2012 Fixed
Description
ORACLE ONLY:If the supplemental logging is not

turned on until after the Replication Agent is

started up, the error 'Supplemental logging is

not enabled for the primary database <orcl>'

would be complained when the user execute

'ra_admin init' to initialize the Replication

Agent system objects in the primary database.

But actually, the supplemental logging has already

been turned on.
Workaround Description
 shutdown and re-start the Replication Agent after configuring primary database supplemental logging as specified in the Replication Agent Primary Database Guide for Oracle.



CR:624239
CR Number:   624239
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2010 Fixed
06 Apr 2010 Fixed
05 Apr 2010 Fixed
06 Apr 2010 Fixed
Description
rs_ticket stops at distributor with publications



CR:624362
CR Number:   624362
Product Name:   Rep Server Configuration Guide
Product Component:   Rep Server Configuration Guide
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2011 Fixed
19 Apr 2010 Added to user documentation
Description
doc change - erssd_start_cmd for upgrade needs to point to pre-upgrade environment.



CR:624425
CR Number:   624425
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   HP-UX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Method to have commands at DSIE/DSI to use a different repdef than what was determined when the data came into the RS.
Workaround Description
 On RS 15.5, one can do autocorrection at the connection or table level with the dsi_command_convert parameter. However, there is no workaround so that a command can invoke function string processing with a different replication definition than what was used when the command came into RS.



CR:624596
CR Number:   624596
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Open
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2010 Presently Not Targeted For Any Future Release Of This Product
18 Jan 2011 Presently Not Targeted For Any Future Release Of This Product
18 Jan 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Include the letters ESD and identify the EBF number in the RAX and MA version strings.
Workaround Description
 Note in the version string, the following structure:



15.0.0.5517P8



This is RAX 15.0, build 5517, ESD #8



Because there is no 1OFF in the version string, it is not a 1OFF. Access the EBF website to get the actual EBF number.



CR:624604
CR Number:   624604
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)
04 Nov 2014 Fixed
Description
RA DB2 not processing compensation record.
Workaround Description
 None



CR:624717
CR Number:   624717
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2010 Work as design
Description
Customer has created multiple projects. One project contains a shortcut of a 'model' from the other project. When the project with the model shortcut is consolidated, the shortcut model is not listed in the repository.



This is expected behavior. In the Check-in window, only models listed in the <project> directory will be checked-in.



the customer desires to see the reference of the model shortcut in the repository browser.





To reproduce:



In your workspace,



1) create 2 projects, Project_A and Project_B.

2) In Project_A you create a new model, Model_A.

3) In Project_B you create new model, Model_B, and you add Model_A from Project_A.



We will have in Project_B a shortcut to Model_A:



Project_A

Model_A

Project_B

Model_B

shortcut to Model_A



Now we check-in both projects in the repository. If we look in the repository we will see the following :

Project_A :

Model_A

Project_B

Model_B



Note: that we don't see in the Project_B the shortcut to Model_A.



However if we checkout Project_B and select "check out dependencies" we will get :

Project_B

Model_B

shortcut to Model_A



*** Wed May 05 2010 15:14:56 GMT-0400 (Eastern Daylight Time) *** ahill ***



This enhancement request has been reviewed by engineering and will not be implemented.



This is expected behavior

As there is not repository model object for the shortcut, PD cannot display a node in repository browser for it.



CR:624811
CR Number:   624811
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)
04 Nov 2014 Fixed
Description
RA abends with U1403
Workaround Description
 skip around the records



CR:624999
CR Number:   624999
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   NA
Original Version:   15.2.0.5801P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #3 02 Nov 2010 Fixed
6.1.00 23 Dec 2010 Fixed
5.9.02 03 Nov 2010 Fixed
15.6 ESD#1 23 Dec 2010 Fixed
Description
ASE ONLY: Mirror Replication Agent goes into ADMIN

state with IllegalArgumentException error during

resume when Mirror Replication Agent is configured

for multi-block read.
Workaround Description
 Either re-execute the resume command (any time the devices are updated with a log read block count greater than 1):



ra_updatedevices

go

resume

go

# check status ... expecting ADMIN

resume

go



- or -



re-set the log_read_block_count to a value of 1:



ra_config log_read_block_count, 1

go

ra_updatedevices

go

resume

go



CR:625312
CR Number:   625312
Product Name:   Common Metadata Repository
Product Component:   Client/Server
Status:   Closed
OS:   Windows
Original Version:   amboise
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2010 Fixed
Description
CMR is unable to connect to an upgraded repository if all the libraries have not been upgraded.



Customer create a repository in V12.x using Studio Enterprise eval. They later purchased DataArchitect Enterprise. They have upgraded to v 15.1 EBF8. When they attempt to connect to the repository via CMR, they get an error. In the log file, there are errors stating problems loading the OOM, RQM, and BPM metaclass. Upon review of the customer's PMLIBR table, the OOM, RQM, And BPM versions are at 12.1 or 12.5.



Since these libraries have not been migrated to v15, CMR is failing to connect.



Workaround

Upgrade all repository tables/libraries to current build

This was done by using an eval license





To reproduce the issue:



1) create repository in v12.5 using studio enterprise

2) upgrade to 15.1 using DataArchitect enterprise

3) upgrade repository to v15.1

4) attempt to connect to repository via CMR



One of the errors reads:



ERROR Thread-1 2010/04/05 10:18:40 EDT com.sybase.cmr.infra.server.persistence.db.DbMetaPersistenceManagerImpl.createMetaClasses(DbMetaPersistenceManagerImpl.java:826) Exception occurred while loading metaclass(383:Object-Oriented Model)



CR:625324
CR Number:   625324
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)
20 Apr 2010 Fixed
Description
Correct an incorrect spelling found in

ra_status output for

"REPLICATING Transitioning - Stopping

LogReader immediatly" message.



CR:625343
CR Number:   625343
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Request to add "Partitions" information in current RMP 15.5.



CR:625472
CR Number:   625472
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 05 08 Jun 2010 Fixed
Description
Single quote is not handled correctly when certain configurations are used together.



CR:625512
CR Number:   625512
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Not a Bug
Description
Use_repdefs=Y produces LTL for columns that are not in the replication definitions.
Workaround Description
 Use_redefs = N



CR:625514
CR Number:   625514
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 05 08 Jun 2010 Fixed
Description
Suppress_col_names =Y does not suppress column names
Workaround Description
 None



CR:625962
CR Number:   625962
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)
14 Apr 2010 Not a Bug
Description
When replicating to a warm standby, stable device space not released when Replication Agent is not connected.
Workaround Description
 Make sure RA is forwarding LTL to the Replication Server.



CR:626108
CR Number:   626108
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 12 Apr 2011 Fixed
Description
Provide a command/interface

to get RepAgent license

information.



CR:626316
CR Number:   626316
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Master replication using warm standby; changing user's expired password using sp_password does not replicate and causes DSI to go down with error:



ERROR #1028 DSI EXEC(116(1) REL1502_cran2.master) - /dsiexec.c(513)

Message from server: Message: 7742, State 1, Severity 16 -- 'You must change your password using the sp_password system stored procedure before you can continue.
Workaround Description
 Login to the replicate and issue sp_password, using the same password supplied at the primary.



CR:626321
CR Number:   626321
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)
Description
Skipped DDL statement does not show up in RS log.
Workaround Description
 Look at the rs_helpexception for this skip



CR:626443
CR Number:   626443
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   SunOS
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS152ESD11 Signal 6 in err_raise_syb_lib_my_maps ()
Workaround Description
 No Workaround



CR:626632
CR Number:   626632
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)
24 Feb 2012 Not reproducible with latest version of the product available as of Resolution Date
24 Feb 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
RS hangs when ASE target server is unavailable.
Workaround Description
 During the hang, kill the RS with the OS or bring up the server with the ASE targets.



CR:626786
CR Number:   626786
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Replication Server/15.2/EBF 17186 ESD#1.1/Linux Intel/

Linux 2.6.9-42.ELsmp i686/1/OPT/Thu Oct 15 16:15:54 2009



there are two problems here ...

after inserting 500 rows in a table ...

with the connection to the standbyDS.standbyDB suspended ...

*********************************************

isql -S<activeDS> -Usa -P -w2048 -D<activeDB>

declare @var int

select @var=1

while @var<= 500

begin

insert t01 values(@var, 'skip')

select @var=@var+1

end

go

quit

*********************************************

resume connection to standbyDS.standbyDB skip 500 transaction ...



1) failure to record all skipped xacts in rs_excepts* tables

2) failure to actually skip the xacts ..





it appears all 500 are skipped ... by the response to the ...

resume connection to standbyDS.standbyDB skip 500 transaction

****************************************************************

isql -S<rs> -Usa -P -w2048

1> resume connection to <standyDS>.<standyDB> skip 500 transaction

2> go

Connection to '<standyDS>.<standyDB>' is resumed.

1>

****************************************************************

but only 21 are recorded in the RSSD in the rs_excepts* tables ... ??? ...

and more surprising is 479 rows replicated ... !!! ... ??? ...



CR:626798
CR Number:   626798
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Solaris
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Extremely long process time for message containing very big TEXT column.



CR:627386
CR Number:   627386
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2010 Fixed
29 Aug 2010 Fixed
15.7 09 Sep 2011 Fixed
05 Sep 2010 Fixed
Description
Changed defaults for dsi_cmd_prefetch, nrm_thread, and dist_direct_cache_read to "off". This will prevent the license manager from looking for the REP_HVAR_ASE license.
Workaround Description
 Workaround: No workaround. Have to apply ESD#1 and manually modify the replication server setttings, dsi_cmd_prefetch, nrm_thread, and dist_direct_cache_read if the RS was newly created or upgraded without this fix.



CR:627653
CR Number:   627653
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 07 08 Jun 2010 Fixed
Description
Rep Agent is not changing the Oldest Open Transaction this also causes the E,ROOT command to appear as if it does not function.



CR:627809
CR Number:   627809
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Not require length on datatypes of encrypted columns. This could be expanded to not requiring datatype or length on any column and for RS to use what has been stated by the Replication Agent, unless the data needs to be transformed in the Replication Server.



CR:627850
CR Number:   627850
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
separate Repository Administration and Working with Repository Documents.

This is not possible with out current Users Management due the "Manage Users" rights can give all rights to his own User.
Workaround Description
 Give the User Administrator only DB access right to the User Tables of the DB.

PMPERM, PMCMRID, PMRRLM, PMUSER and PMGUSR.



CR:627858
CR Number:   627858
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repository Feature Request: Allow multiple DBMS users for a single repository definition.

Currently, PowerDesigner only allows one DBMS user per repository definition to connect to the repository database.



CR:627860
CR Number:   627860
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repository Feature Request: Allow repository DBMS to handle repository user permissions.

Currently, the permissions are being maintained within the repository database only.



CR:627874
CR Number:   627874
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
config parameter to timeout connecting to license server



CR:627896
CR Number:   627896
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2010 Fixed
05 May 2010 Fixed
13 Dec 2012 EOL'd version. Not to be Fixed.
Description
ASE ONLY: When there are concurrent transactions

active at the same time, a mini-rollback for one

transaction is processed, the rollback operation

send to Replication Server can be 'skipped' as a

duplicate because the rollback operation's

location is too old.



CR:628151
CR Number:   628151
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   5.8.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2010 Fixed
Description
Replication Agent version 15.5 introduces support

to downgrade your Replication Agent instance from

version 15.5 back to version 15.2. Users wishing

to downgrade their Replication Agent instance will

need to make sure their target downgrade

Replication Agent is running 15.2 ESD #2 or later

before attempting to downgrade their Replication

Agent instance.



CR:628422
CR Number:   628422
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)
16 Jul 2010 Fixed
Description
SYSAM lmgrd daemon not installed
Workaround Description
 To install a SySAM Server via the execution of the RS 1550 ESD 01

installer, specify a served license during the installation process.



To install a SySAM Server without executing the RS 1550 ESD 01

installer, invoke the SySAM Server installer directly from the

'archives' directory of the RS 1550 ESD 01 installation media.



For Unix ...



archives/sysam_server/setup.bin LAX_VM ${JAVA_HOME}/bin/java



For Windows ...



archives\sysam_server\setup.exe LAX_VM %JAVA_HOME%\bin\java.exe



If you do not have access to a Java installation, execute the RS 1550

ESD 01 installer and a suitable JRE will be installed which can be

referenced on Unix and Windows by the environment variable

'SYBASE_JRE6'.



CR:628593
CR Number:   628593
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_helpexception display of the generated sql is corrupt.



CR:628672
CR Number:   628672
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2010 Fixed
12 May 2010 Fixed
08 Sep 2010 Fixed
Description
With WINX64 RS 1550 GA, critical scripts under

'%SYBASE%\REP-15_5\ASA11\scripts' are missing.

These scripts support, amongst other things, the

ability to unload a SQL Anywhere database which

is a critical step in upgrading an Embedded

RSSD.



CR:628745
CR Number:   628745
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
After using RepConnector Manager or ratool to Stop Connection to Glassfish JMS, Start Connection fails.



CR:628978
CR Number:   628978
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2010 Fixed
14 May 2010 Fixed
15 Jun 2010 Fixed
03 Aug 2010 Fixed
Description
For NT386 and WINX64 Replication Server, a set

of private copies of critical DLL files used by

Replication Server are stored in

'%SYBASE%\%SYBASE_REP%\bin'. For NT386 and

WINX64 RS 1550 GA, this set is incomplete which

can cause Replication Server to reference

incompatible DLL files that could cause

Replication Server to fail.
Workaround Description
 The work-around is to first install RS 1550 ESD 01 into an empty

'%SYBASE_TEMP%' directory. Then, copy all DLL files from ...



%SYBASE_TEMP%\OCS-15_0\dll\*.dll

%SYBASE_TEMP%\OCS-15_0\lib3p\*.dll (nt386 only)

%SYBASE_TEMP%\OCS-15_0\lib3p64\*.dll (winx64 only)



... to ...



%SYBASE_PROD%\REP-15_5\bin



CR:629048
CR Number:   629048
Product Name:   RepConnector
Product Component:   Misc.
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
RepConnector needs to support Oracle Weblogic 10.3 as an Application Server.
Workaround Description
 Use Weblogic 10.0, EAS, or 'hack' 10.3 to complete installation.



CR:629166
CR Number:   629166
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS does not respond to commands when ASE containing RSSD is down. Also RS log will say queue is purged, when it really wasn't.
Workaround Description
 If the ASE RSSD is down, bring up the ASE RSSD, fix whatever issues need to be fixed (e.g. resume queue if SQM is down).



CR:629246
CR Number:   629246
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 Sep 2010 Fixed
Description
for ORACLE only:

rs_create_repdef will create wrong

repdef for warmstandby,

if RepAgent has not ever been

started for replication.
Workaround Description
 Move the steps of marking 'rs_lastcommit' table and creating repdef to after warm standby is created.

i.e. the steps should be:

1) ra_config pdb_automark_tables, false

2) creating active connection

3) create standby connection

4) resume active, standby connection

5) resume active RAO

6) pdb_setreptable rs_lastcommit,mark,

rs_create_repdef rs_lastcommit





or 1) ra_config pdb_automark_tables,true

2) creating active connection

3) create standby connection

4) resume active, standby connection

5) pdb_setreptable rs_lastcommit,unmark, force(make sure it succeed)

6) resume active RAO

7) pdb_setreptable rs_lastcommit,mark,

rs_create_repdef rs_lastcommit



CR:629268
CR Number:   629268
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer "rs_init" 15.2 GA under Solaris, fail to create a new RepServer instance having first Stable Device to be on a ZFS raw device.



"rs_init" fail with following error:

> Cannot read file '/dev/zvol/rdsk/sybase/rspe10_01'.

> Operating system returned: Invalid argument
Workaround Description
 Work around:

- install new RepServer instance with first Stable Device located on classic file, then add Partition on ZFS raw device from RepServer instance instead of "rs_init".





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------