提供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:454506
CR Number:   454506
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2010 Fixed
28 Jul 2010 Fixed
04 Jun 2010 Fixed
28 May 2010 Fixed
Description
upgrade rs_delexception to delete a range of Xact_ID's



CR:454522
CR Number:   454522
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In Replication Server 15.0.1, the following Replication Server

configuration options have a wider valid range ...



exec_sqm_write_request_limit

md_sqm_write_request_limit

sub_sqm_write_request_limit



If you increase any of these configuration options after upgrading to

Replication Server 15.0.1, these configuration options must be decreased

to their former default values before downgrading to Replication Server

15.0 or earlier.



CR:454523
CR Number:   454523
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When upgrading Replication Server 15.0 to Replication Server 15.0.1, the

RSSD stored procedure 'rs_helpfstring' is not properly updated.



CR:454524
CR Number:   454524
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When upgrading from any version of Replication Server to Replication

Server 15.0.1, the RSSD table 'rs_statcounters' is not properly updated.

This results in either missing counters or incorrect counter labels and

descriptions when using the following RSSD stored procedures ...



rs_dump_stats

rs_helpcounter



CR:454600
CR Number:   454600
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.6.00 13 Feb 2008 Fixed
Description
ASE ONLY: Command ra_migrate does not support

automatic upgrades from release 12.6 to 15.0 or

Adaptive Server version upgrades from version

12.5 to 15.0



CR:454759
CR Number:   454759
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2010 Fixed
Description
A synchronization issue within the Replication Manager will intermittently generate a stack trace when the user disconnects from a two tier environment. The problem occurs when monitoring many servers with the monitoring interval set to a low value (e.g. 10 seconds).



CR:454767
CR Number:   454767
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The columns panel in the table replication definition dialog does not match the table's initial datatype with a valid datatype in the replication definition drop down list. If the table's datatype is in uppercase, the dialog does not find the corresponding lowercase datatype in the list. It will default to the first item in the list. This can cause a replication definition to be created with incorrect column datatype fields.
Workaround Description
 Upgrade the Replication Agent or Mirror Replication Agent to version 12.6 ESD #6 or version 15.0.



CR:454798
CR Number:   454798
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2007 DEFER
07 Aug 2007 Presently Not Targeted For Any Future Release Of This Product
30 Oct 2007 Fixed
11 Jun 2007 Fixed
20 Aug 2007 Fixed
23 Oct 2007 Fixed
20 Nov 2007 Fixed
Description
Due to improper synchronization of the SRE,

various internal linked lists may become corrupt

causing a failure in the RS internal routine

'll_del()'.
Workaround Description
 Turn SMP off.



CR:454882
CR Number:   454882
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.3.04 15 Mar 2007 Fixed
Description
ASE ONLY: Fix missing resource bundle key for

ASE_DBCONTEXT_UNAVAILABLE.



CR:454884
CR Number:   454884
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 23 Sep 2007 Fixed
Description
For table rs_datatype, the column named dbname, should be documented as dtname.



CR:455172
CR Number:   455172
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2008 Fixed
Description
In a 3-tier environment the add server wizard incorrectly lists the following server types as being available to add:



Oracle DBMS

Microsoft SQL Server

IBM Universal Database



These types of servers are not possible to add to a Replication Monitoring Services, 3-tier environment. They are not supported in a 3-tier environment.



CR:455337
CR Number:   455337
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   NA
Original Version:   5.3.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 02 Apr 2010 Insufficient priority to fix
5.3.04 15 Mar 2007 Fixed
5.3.04 15 Mar 2007 Fixed
5.3.04 15 Mar 2007 Fixed
5.3.04 15 Mar 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.3.04 15 Mar 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
Description
Improved efficiency in formatting LTL by enabling

the use of table replication definitions when

configuration property use_rssd is set to true

and the Replication Server connection is

configured for warm standby or a database level

replication definition.



Now, in a warm standby or database replication

definition environment and with configuration

property use_rssd set to true, for tables that

have a table replication definition defined in

Replication Server, only the primary key columns

defined in the replication definition will be

used when formatting the LTL before image for

update and delete operations.



Note that this change in behavior could conflict

with any custom Replication Server function

strings that depend on before image column values

for update or delete operations. If custom

Replication Server function strings do have a

dependency on non-primary key columns in the

before image for update or delete operations, the

configuration property use_rssd must be set to

false.



CR:455689
CR Number:   455689
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2007 Fixed
23 Feb 2007 Fixed
Description
"admin config" RCL command needs to be executed using 12.5 isql or later. Repserver will shut down if an earlier isql is used.



CR:455993
CR Number:   455993
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   ramproto
Fixed Version Build Resolution Date Closure Code (If Appropriate)
ramproto 13 Feb 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: 'pdb_xlog init'

command add a new system procedure

'ra_lct_sql_' to support Log Truncation.



CR:456049
CR Number:   456049
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2007 Fixed
Description
PowerDesigner 12.1 will Crash after Consolidate several times to MSSQL 2000 Repository Database. From the Dump file, there is "Stack Overflow" and "Access Violation" exception.



CR:456109
CR Number:   456109
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 13 Feb 2008 Fixed
5.6.00 13 Feb 2008 Fixed
Description
UDB ONLY: RAU initialization procedure has been

updated to support UDB version 9.



CR:456216
CR Number:   456216
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Open
OS:   all
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Description for first occurrence of wait_for_commit is for the value wait_for_start.
Workaround Description
 Use the RS 15.0 manual.



CR:456332
CR Number:   456332
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.3.04 15 Mar 2007 Fixed
Description
ASE ONLY: Reposition point processing might not

wait for refreshed locator from Replication

Server.



CR:456365
CR Number:   456365
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.6.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 24 Jun 2008 Fixed
5.6.07 24 Jun 2008 Fixed
5.5.17 24 Jun 2008 Fixed
Description
ASE ONLY: DDL replication fails after

upgrading ASE from 12.5 to 15.0.



CR:456560
CR Number:   456560
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.5.00 22 May 2008 Added to user documentation
5.5.01 24 Jul 2007 Fixed
Description
Replication of unitext data generates an

invalid LTL exception because unitext LTL

is sometimes sent in little endian byte

order.



There is a new property "ltl_big_endian_unitext"

that controls if "unitext" data should be

converted from little endian to big endian before

sending LTL to Replication Server.



The possible settings are "true" or "false".



When set to "true", unitext data that is little

endian byte order will be changed to big endian

byte order.



When set to "false", unitext data byte order is

not changed.



The default setting is "true".



CR:456631
CR Number:   456631
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.3.04 15 Mar 2007 Fixed
Description
ASE ONLY: Replication of sp_changegroup generates

a NullPointerException.



CR:456697
CR Number:   456697
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.3.04 15 Mar 2007 Fixed
Description
ORACLE ONLY: A deadlock can occur when marking

activity occurs in parallel between log reading

processing and manual pdb_setreptable execution.



CR:456717
CR Number:   456717
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
RM Plugin should default maintenance user password to <dbname>_maint_ps



CR:456739
CR Number:   456739
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 15 Mar 2008 Presently Not Targeted For Any Future Release Of This Product
Description
List the individual paramters in the syntax section of alter logical connection rather than use a generic line.



CR:456762
CR Number:   456762
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.3.04 15 Mar 2007 Fixed
Description
The comment in the instance configuration file

may not indicate the correct product.



CR:456878
CR Number:   456878
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Fixed
15 May 2007 Fixed
Description
Batch on for DCO gets Message from server: Message: 933, State 0, Severity 16 -- 'ORA-00933: SQL command not properly ended



CR:460690
CR Number:   460690
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2007 Not a Bug
Description
Tested and reproduced with PD 12.0.0 EBF#4 and 12.1.0 EBF#6



When extracting a model from a 12.1 migrated repository and consolidating it again, the version is altered from v1 to v2.



CR:460704
CR Number:   460704
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2007 Not reproducible with latest version of the product available as of Resolution Date
15.0.1 09 Mar 2007 Fixed
Description
Replication Manager Plugin: It is not possible to sort the list of Replication Server Queues in size order.
Workaround Description
 None known.



CR:460730
CR Number:   460730
Product Name:   RepAgent/ASA
Product Component:   Replication Agent
Status:   Closed
OS:   Generic
Original Version:   5.5.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0.1 3391 27 Feb 2007 Fixed
10.0.0 2810 27 Feb 2007 Fixed
9.0.2 3455 27 Feb 2007 Fixed
Description
RepAgent may have sent duplicate transactions to RepServer, if an online transaction log was truncated when the RepAgent was still busy scanning it. In normal situations, these duplicate transactions should not cause any problems, because the QIDs for the duplicate transactions should be identical to the ones that had already been sent to the RepServer. However, it could create extra network traffic, and delay data replication. This has now been corrected.



CR:460749
CR Number:   460749
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 23 Sep 2007 Fixed
Description
A database replication definition without table repdef or function replication definition, will use default function strings, perform minimal column replication and will not transform data.



CR:460757
CR Number:   460757
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 23 Sep 2007 Fixed
Description
Explanation of warm standby repdefs and the send standby clause is confusing.



CR:460764
CR Number:   460764
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 23 Sep 2007 Fixed
Description
Minimal columns behavior is influenced by the replicate_minimal_columns setting of the logical connection when a table repdef is used for a warm standby and send standby is off.



CR:460769
CR Number:   460769
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
With logical connection set with "replicate_minimal_columns" = off, database repdef to a second database still defaults to replicating minimal columns with a warm standby.
Workaround Description
 Explicitly set replicate minimal columns or replicate all columns in the table repdef replication definition. Do not rely on "default" behavior.



CR:460778
CR Number:   460778
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   ramproto
Fixed Version Build Resolution Date Closure Code (If Appropriate)
ramproto 13 Feb 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY:enable/disable DDL

replication (pdb_setrepddl [all signatures])



CR:460900
CR Number:   460900
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 13 Feb 2008 Fixed
Description
ORACLE ONLY: A failure to find an archive device

produces an error message similar to: "An Archive

file was not found. Reason:<Could not find

Resource Bundle ...". The correct error message

should be similar to: "An Archive file was not

found. Reason: Archive log file for LSN 1030 is

not found. File C:\sybase\ARC01030_05999892.001".



CR:461031
CR Number:   461031
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 13 May 2008 Fixed
Description
Add quiesce as a keyword in the Reference Manual index



CR:461055
CR Number:   461055
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 13 Feb 2008 Fixed
Description
Little endian unitext data was converted to big

endian without providing trace information

indicating the conversion occurred.



CR:461238
CR Number:   461238
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2007 Fixed
13 Mar 2007 Fixed
Description
Using the access mode "List" on a Document requires that the Parent Node (folder) must have

at least "Read" access permission. That means if Parent folder with "List" access mode will

hide all the Documents inside the folder. However, it is reported that Repository function

"Find Objects" does not care the access mode. Though the "Find Objects" function does not

allow to search the Content of Documents, the function can expose the name of hidden

documents of the folder.



CR:461298
CR Number:   461298
Product Name:   RepAgent/ASA
Product Component:   Replication Agent
Status:   Closed
OS:   Generic
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0.1 3397 02 Mar 2007 Fixed
10.0.0 2815 02 Mar 2007 Fixed
9.0.2 3460 02 Mar 2007 Fixed
Description
The Replication Agent may have crashed if it was not able to start. A global structure was being freed too early. This has been fixed.



CR:461301
CR Number:   461301
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.4.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 13 Feb 2008 Fixed
Description
UDB ONLY: marking of a table with a large CLOB

column fails with the error message

"Could not get column meta data for primary

table <XYZ>."



CR:461420
CR Number:   461420
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.08 30 Aug 2008 Fixed
5.6.00 13 Feb 2008 Fixed
Description
Issuing 'rasd_restore' prior to ever issuing

'rasd_backup' prevents the RASD from functioning

properly.



CR:461521
CR Number:   461521
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   ramproto
Fixed Version Build Resolution Date Closure Code (If Appropriate)
ramproto 14 Feb 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Implement

enable/disable LOB columns (pdb_setrepcol

[all signatures])



CR:461612
CR Number:   461612
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2008 Fixed
11 Feb 2008 Fixed
25 Feb 2008 Fixed
11 Feb 2008 Fixed
Description
If the NULL attributes of a replication

definition does not match those of the

asscociated replicated table, error 32050 will

be raised and prevent the truncation of the

inbound queue. However, warm standby

replication will continue to behave correctly.

If the RS is used exclusively for a warm standby

topology, the error may go un-noticed until the

stabel queue is full.



CR:461700
CR Number:   461700
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
5.3.05 14 May 2007 Fixed
Description
ORACLE ONLY: A synonym passed to command

"pdb_setreptable" fails to identify the

underlying table name.



CR:461729
CR Number:   461729
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2007 Fixed
18 Jan 2008 Fixed
Description
admin stats, "all", save command reports an error in the Replication Server error long, reporting that the "TRUNCATE TABLE command not allowed within multi-statement transaction."
Workaround Description
 set the config parameter "stats_reset_rssd" to 'off',

and manually truncate the rs_statdetail and rs_statrun

tables as needed.



CR:461963
CR Number:   461963
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
send standby clause changes table owner qualification and insert text with nulls than without the send standby clause.
Workaround Description
 Do not use the send standby clause in this case. In this case, the same replication definition can be used for both warm standby and MSA.



If the problem is only with overriding the table name, using a warm standby and table repdef (sp_setreptable, repdef with table override, and subscription) with the MSA will work. However, the text column null problem will still exist.



CR:462032
CR Number:   462032
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)
12 Apr 2007 Fixed
09 Aug 2007 Fixed
09 Aug 2007 Fixed
09 Aug 2007 Fixed
16 Aug 2007 Fixed
16 Aug 2007 Fixed
16 Aug 2007 Fixed
16 Aug 2007 Fixed
Description
RS will generate warning message 32020 when a

database replication definition exists but the

corresponding database subscription is not yet

valid. If the database subscription takes a

long time to become valid, the RS may generate

excessive numbers of warning message 32020.



CR:462157
CR Number:   462157
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)
12 Apr 2007 Fixed
09 Aug 2007 Fixed
09 Aug 2007 Fixed
09 Aug 2007 Fixed
Description
In an MSA environmvert the rs_subscriptions.materializing bit won't clear on PRS_RSSD even though the corresponding subscription has promoted to VALID. This residue will cause problems with "sysadmin hibernate_on" issued at the PRS, and will cause problems when one attempts to upgrade the PRS to a subsequent version of Repserver.



CR:462183
CR Number:   462183
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)
12 Apr 2007 Fixed
14 Aug 2007 Fixed
01 Nov 2007 Fixed
14 Aug 2007 Fixed
Description
After performing a "drop database subscription" in an Multi Site Availablity environment, a drop subscription directive can persist indefinitely in the target database's outbound queue and can report that the subscription can not be found.



CR:462220
CR Number:   462220
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
Description
Fail to migrate an instance from version 12.6

to 15.0 using the *_admin utility.



CR:462339
CR Number:   462339
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)
12 Apr 2007 Fixed
01 Nov 2007 Fixed
01 Nov 2007 Fixed
14 Aug 2007 Fixed
14 Sep 2007 Fixed
Description
Defining a database subscription using the dump marker, the subscription should not be limited by the num_concurrent_subs, triggers rs_subscriptions_ins and rs_subscriptions_upd values. When the subscription is activated by the dump marker, the repserver will set site id of activation marker to the rs id, this will cause the activation marker to be treated as a duplicate by SQM and discarded.



CR:462358
CR Number:   462358
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Failed to add a row to RSSD 'rs_statdetail' table due to duplicate rows.
Workaround Description
 None at this time. Cannot get M & C data for multiple RSI users on the same RS. If the RSI USER data is not needed, one can drop the rs_statdetail.rs_key_statdetail index. All other counters will count, however, data for RSI user will be lumped under one instance.



CR:462392
CR Number:   462392
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.4.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
UDB ONLY: when pdb_convert_datetime is set to

true and UDB timestamp column is converted to

SYBASE datetime column, the milliseconds

precision is lost.



CR:462451
CR Number:   462451
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
In some cases, the Replication Agent does not

include the table owner in the LTL sent to

Replication Server.



CR:462468
CR Number:   462468
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
ORACLE ONLY: Replication Agent encounters

OracleDDLException: Failed to create a procedure

while modifying or compiling a Package.



CR:462470
CR Number:   462470
Product Name:   Rep Server Configuration Guide
Product Component:   Rep Server Configuration Guide
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2007 Fixed
Description
15.0 to 15.0.1 upgrade instructions missing.
Workaround Description
 Since the upgrade from 15.0 to 15.0.l is a minor upgrade, it was documented in the Release Bulletin. Please see chapter on Special Upgrade and Downgrade Instructions in the Release Bulleting for 15.0.1.



CR:462603
CR Number:   462603
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2007 Not a Bug
Description
RMS: The Replication Monitoring Services plugin com.sybase.rms cannot be started by the Unified Agent (UA) when it has been installed into a directory that also has ASE 15.0 installed.
Workaround Description
 When installing RMS it is possible to over-write the existing files. However, that reverts UA to version 1.5 (from ASEs 2.0) which may cause other problems so is NOT recommended.

Alteratively, install the UA in a separate directory.



CR:462618
CR Number:   462618
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
5.3.05 14 May 2007 Fixed
Description
ORACLE ONLY: An IndexOutOfBounds exception

processing an update operation sends RAO to

ADMIN state.



CR:462973
CR Number:   462973
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Fixed
Description
QIDs do not always increase in the inbound queue.
Workaround Description
 sqm_zap_commands ALL the commands in the duplicate (second) transaction. If you do not zap them all, you may be a parser error and a corrupted queue.



CR:463076
CR Number:   463076
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.05 14 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
ASE ONLY: Processing the system stored procedure

'sp_setrepcol' with the value "null" for column

name, the Replication Agent generates a

FieldNotFoundException.



CR:463086
CR Number:   463086
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
5.3.05 14 May 2007 Fixed
Description
ASE ONLY: Replication of 'sp_export_qpgroup'

halts replication with an AricleNotFoundException.



CR:463099
CR Number:   463099
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   unknown
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.01 14 Feb 2008 Fixed
Description
ORACLE ONLY: The Replication Agent has been

enhanced to support Replication Server's

"subscribe to truncate table" option.



Previously, the truncate table command was only

replicated from Oracle when DDL replication was

enabled. Now, the truncate table command can be

replicated whether DDL replication is enabled

or not.



With this change in behavior, the truncate table

command is replicated to databases which

explicitly subscribe to truncate table.



For replication environments with table level

replication definitions and subscriptions, each

subscription must be altered to "subscribe to

truncate table."



For replication environments with a database

replication definition, but no table level

subscriptions, the database subscription must be

altered to "subscribe to truncate table."



If the database subscription does include the

"subscribe to truncate table" clause, then any

table level subscriptions that exist must also

include the "subscribe to truncate table" clause.



Please refer to Sybase Replication Server

documentation for more information on subscribing

to truncate table.



CR:463205
CR Number:   463205
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 14 Feb 2008 Fixed
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
Description
When LOB columns are enabled for replication,

issuing the pdb_setrepcol command with no

parameters results in redundant rows in the

result set.



CR:463209
CR Number:   463209
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.4.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 14 Feb 2008 Fixed
Description
UDB ONLY: Replication Agent for UDB now supports

DB2 UDB version 9.



CR:463367
CR Number:   463367
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 14 Feb 2008 Fixed
5.5.01 24 Jul 2007 Fixed
5.6.00 08 Feb 2008 Fixed
Description
ORACLE ONLY: A NullPointerException in

LTLFormatter.compareFields() is encountered on

an update to a table with over 200 columns



CR:463486
CR Number:   463486
Product Name:   Rep Serv Design Guide
Product Component:   Rep Serv Design Guide
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 13 May 2008 Fixed
Description
Document replication of the master database in the Design Guide.



CR:463554
CR Number:   463554
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2007 Fixed
Description
When an oom is including a shortcut of another diagram, during the repository update : Unexpected error while updated an OOM with a shortcut of the diagram

The consolidation of the document has been cancelled



CR:463577
CR Number:   463577
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2007 Fixed
20 Apr 2007 Fixed
20 Apr 2007 Fixed
Description
During a second update, the changes made by another user are checked by default in the merge even if the current user didn't modified the objects. Due to that during one update, an user can cancel all the work done by another one.



CR:463756
CR Number:   463756
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5500
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
ASE ONLY: Mirror Replication Agent now supports

the "interval" type of truncation, in addition to

the already-supported "locator_update" and

"command" types. The two configuration parameters,

truncation_type and truncation_interval, govern

how often truncation automatically occurs.





truncation_type - Configures transaction log

truncation behavior of the Mirror Replication

Agent.



Default: locator_update



Valid Value:



command - Mirror Replication Agent truncates

the transaction log only when the

'pdb_truncate_xlog' command is invoked.



interval - Mirror Replication Agent truncates the

transaction log automatically at the intervals

specified by the 'truncation_interval'

configuration parameter.



locator_update - Mirror Replication Agent

truncates the transaction log automatically

whenever it receives a new LTM Locator value

from Replication Server. The frequency of

these locator updates is specified by the

'lti_update_trunc_point' configuration

parameter.





truncation_interval - Specifies a time interval,

in minutes, between automatic truncations of

the transaction log.



Default: 0



Valid Value: an integer from 0 to 720



Comments:



* If the value of truncation_interval is 0 (zero)

and the value of truncation_type is "interval",

then automatic truncation is disabled.



* The maximum truncation interval is 720 minutes,

or 12 hours.



CR:463813
CR Number:   463813
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5304P15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 14 Feb 2008 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 14 Feb 2008 Fixed
Description
When there is a lot of activity in the database

log, but none of it is for replication, the

database log will fill up because RepAgent

does not update the truncation point to the end

of log.



CR:463942
CR Number:   463942
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 01 16 Apr 2007 Fixed
Description
Rows lost when table is dropped from the LTMOBJECTs



CR:463943
CR Number:   463943
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 13 06 Sep 2007 Fixed
Description
Abend, S80A, with table of 32k



CR:464188
CR Number:   464188
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)
06 Apr 2009 Duplicate
Description
Provide a mechanism in RS so that switch active does not hang when many switch actives are requested within the RS at the same time.
Workaround Description
 Using the rs_recovery table, remove the rows dealing with the switch active, then reboot the RS with the switch active rows a few at a time, adding the rest of the rows and rebooting the RS each time between adds.



CR:464190
CR Number:   464190
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 27 Feb 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: The underlying table can not be

replicated if materialized view is created with

"for update" option.
Workaround Description
 After the materialized view is created, mark the materialized view's underlying table manually using the pdb_setreptable command.



CR:464311
CR Number:   464311
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2009 Work as design
Description
Invoking the RM plugin on Windows, should start up the .bat file, not a shortcut on the .exe file (which uses the "current settings" for the environment variables.
Workaround Description
 Change the shortcut to call the .bat file



CR:464496
CR Number:   464496
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2007 Fixed
10 May 2007 Fixed
10 May 2007 Fixed
03 Jan 2009 Presently Not Targeted For Any Future Release Of This Product
22 Aug 2007 Presently Not Targeted For Any Future Release Of This Product
13 Jun 2007 Fixed
05 Jan 2009 Fixed
12 Sep 2007 Fixed
12 Sep 2007 Fixed
12 Sep 2007 Fixed
12 Sep 2007 Fixed
14 Nov 2007 Fixed
Description
If RS is enabled for SMP, the RS will appear to

be unresponsive during heavy work loads. This

behavior is caused by improper synchronization

of the asynchronous disk I/O notification

mechanism.



CR:464639
CR Number:   464639
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   NA
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.06 09 Aug 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
Under certain conditions, a NullPointerException

is generated on an attempt to start replication.



CR:464675
CR Number:   464675
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: Replication Agent incorrectly

assigns "identity" for column data types when

creating replication definitions if the column

is named "COLUMN_NAME", "TABLE_NAME", or

"OWNER".



CR:464686
CR Number:   464686
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: An update to a large table whose

last column value was previously NULL failed with

an error: "OracleArticleException: The position

is out of bound for the article"



CR:464895
CR Number:   464895
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2008 Fixed
Description
new RS function invoked by dump tran with standby_access for use with coordiated dumps.



CR:464910
CR Number:   464910
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 03 Sep 2008 Fixed
Description
ASE ONLY: Issuing the pdb_setrepddl command

multiple times returns inconsistent results.



CR:465031
CR Number:   465031
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.06 09 Aug 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: Transaction Origin Time is

incorrectly calculated.



CR:465033
CR Number:   465033
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5401P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: When replicating from Oracle 10g,

the LTL has the incorrect origin time for

the operations.



CR:465135
CR Number:   465135
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
RSM Plugin: New Feature Request to extend support to function string classes, partitions & datatype classes.
Workaround Description
 None known.



CR:465186
CR Number:   465186
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.09 22 Feb 2008 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: Replication Agent failed to

correctly execute all transactions executed in

parallel.



This correction changes the format of the origin

queue ID value used to uniquely identify each

operation to be replicated. The existing format

of the origin queue ID is described in the

Sybase Replication Agent 15.0 Primary Database

Guide, Chapter 3, under section "Format of

origin queue ID".



The new format of the origin queue ID is:

Character Bytes Description

0-3 2 Database generation ID

4-15 6 System change number

16-19 2 System change number sub-index

20-27 4 Log sequence number

28-35 4 Block number

36-39 2 Block offset, relative to the

start of the block

40-47 4 Oldest active transaction begin

log sequence number

48-55 4 Oldest active transaction begin

block number

57-59 2 Oldest active transaction begin

block offset

60-63 2 Available for specifying

uniqueness





In order to correctly implement the change in

origin queue ID format, specific migration

procedures must be followed. Failure to follow

these procedures during installation of this EBF

may result in the sending of duplicate data to

replicate databases.



Migration prerequisites:



1) The primary database environment must be

quiesced during implementation of this EBF.

There should be no database activity generating

data to be replicated.



2) All prior data to be replicated must have

been successful. There should be no

transactions in Replication Server that are 'in

progress' from the primary connection supported

by this Replication Agent.



Migration Steps:



Step 1.



Verify the existing Replication Agent is in a

Replicating state. Use command "ra_status"

to verify:



> ra_status

> go

State Action

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

REPLICATING Ready to replicate data.



If the Replication Agent is not in a replicating

state, issue the 'resume' command to place the

Replication Agent back in replicating state.



Step 2.



Issue Replication Agent command "quiesce" to

force the Replication Agent to process any

remaining log data and suspend replication once

the end of the Oracle online redo log has been

reached.



Step 3.



Shutdown the Replication Agent using command

'shutdown'.



Step 4.



Verify Replication Server has no outstanding

(un-applied) activity for this Primary database

connection, or its Replicate connections.

If the only Primary and Replicate connections

defined to your Replication Server are for this

Oracle Primary connection and replicates, you

can use Replication Server command

"admin quiesce_check" to verify all activity has

been processed.



> admin quiesce_check

> go

Replication Server prs1 is Quiesced



If the Replication Server is not quiesced, verify

all Replicate database connections are active,

and repeat the command until Replication Server

is quiesced.



If the Replication Server supports multiple

Primary database connections and the Replication

Server can not obtain a quiesced state due to

activity on these other connections, you must

manually verify the inbound queue for this Oracle

Primary connection has been read out, and all

outbound queues for Replicate databases for this

Oracle primary have been read out.



Contact Sybase Technical Support if you require

assistance in determining if all data for your

Primary database has been processed by

Replication Server.



Step 5.



Apply the EBF for this replication agent as

described in the "Loading Instructions" of this

EBF letter.



Step 6,



Start the Replication Agent.



Step 7.



Issue Replication Agent command "ra_migrate".

This command will convert all origin queue IDs

stored within the Replication Agent to the new

format.



> ra_migrate

> go

Server 'my_ra', Procedure 'ra_migrate', Line 1:

successful



Step 8.



Migration is complete. You may now resume

replication in the Replication Agent.



CR:465393
CR Number:   465393
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.6.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 27 Feb 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
UDB ONLY: If replicating state has never been

initialized, log truncation fails with the following

error message:

An error occurred getting transaction log file for

LSN <number>, in log path <path>. Offending

SQL <CALL <prefix>get_log_name_(?, ?, ?, ?)>,

SQL execution failed.
Workaround Description
 *** Monday, April 09, 2007 1:33:13 PM *** blopez ***

The problem is easily fixed by starting replication before invoking "pdb_truncate_xlog". After starting replication, the repagend can be suspend if desired, or necessary.



C:\LanRep\run scripts>isql -S UDB_RA -U sa -P ""

1> resume

2> go

State Action

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

REPLICATING Ready to replicate data.



(1 row affected)

1>pdb_truncate_xlog

2>go

Msg 0, Level 20, State 0:

Server 'rau', Procedure 'pdb_truncate_xlog', Line 1:

successful

(0 rows affected)

1>



CR:465399
CR Number:   465399
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2007 Fixed
16 Jul 2007 Fixed
Description
RRS DSI does not release memory after DSI has finished applying transactions.
Workaround Description
 Monitor the Rep Server and when mem_in_use approaches memory_limit, reboot the Replication Server



-- or --



increase the memory_limit to some increment and reboot RS on specific interval



CR:465738
CR Number:   465738
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   ramproto
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 27 Feb 2008 Fixed
Description
MICROSOFT SQLSERVER ONLY:Support RSM commands

(pdb_get_xxx ,pdb_execute_sql) and support

ra_marker,ra_dump commands and fix some

pdb_xlog command bugs .



CR:466026
CR Number:   466026
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5304P15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.05 14 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ASE ONLY: When the system stored procedure

"sp_rename" is replicated, an error occurs at

Replication Server when the next DML is executed

against the renamed object.



CR:466098
CR Number:   466098
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 07 02 Oct 2007 Fixed
Description
User ids on the mainframe of 7 characters will always be replicated in RA DB2
Workaround Description
 Change the maintenance user on the RA DB2 connection to be less than 7 characters.



CR:466199
CR Number:   466199
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2007 Fixed
26 Apr 2007 Fixed
Description
When attempting to turn on Dynamic SQL using an "alter connection" command the Replication Server may crash.



CR:466206
CR Number:   466206
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 06 27 Sep 2007 Fixed
Description
Replace_null_in_char cannot be set to replace a low value to a space.
Workaround Description
 None if you want to replace X'00' with a space (X'40'). Other characters (e.g. underscore, letter) work.



CR:466452
CR Number:   466452
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 25 Sep 2008 Fixed
5.7.01 20 Oct 2008 Fixed
5.8.00 25 Nov 2008 Fixed
Description
ASE ONLY: The command

"pdb_setrepproc qai_proc,rep_name,mark"

sets the replicate name incorrectly.



CR:466475
CR Number:   466475
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_rename is wrapped within a transaction.
Workaround Description
 Resume the DSI and skip transaction, and manually do the sp_rename



CR:466547
CR Number:   466547
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   telemaque EBF9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerDesigner allows RichText format in some areas(Attributes Note's description & annotation).

However, there is no corresponding data type allow to hold the format in Extended Model Definition.



The request here is to allow user to extend PD meta model using Extend Model Definition to

store attribute with RTF format.

With current PD version, user can create Extended Attribute to store text value.

There is only two data type for characters which is 'string' and 'text'.

Neither of these 2 give PD user RTF palatte

like in Description and Annotation) to enter and store formatted text.



CR:466568
CR Number:   466568
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2007 Fixed
Description
RM Plugin: Because Windows is case in-sensitive, if the sql.ini contains wrong ASE server name, RM plugin can report or display erroneous and odd results.



CR:466596
CR Number:   466596
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2010 Fixed
Description
rs_upgrdb.sql script needs to be reviewed for correctness. At a minimum, rs_initialize_threads and rs_update_threads is not valid for row level locking and > 2K page size in the upgrade script. It appears that the rs_threads table and index and rs_check_repl_stat are correct.
Workaround Description
 Looks like the table structure and index for rs_threads in upgrdb is okay (same as what is in scripts/rs_install_replicate.sql ) It also appears that rs_check_repl_stat is also the same as what is found in rs_install_primary.sql However, the rs_initialize_threads and rs_update_threads stored procedures should be pulled in from the REP-12_6/scripts/rs_install_replicate.sql procedure.



CR:466686
CR Number:   466686
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to drop a subscription while DSI is down or suspended.
Workaround Description
 Currently, one has to have a running DSI to drop a subscription. There are two workarounds for this problem:



a. purge the queue or zap the commands to get the DSI up and then drop the subscription.

b. Manually delete the subscription from the RSSDs.



CR:466703
CR Number:   466703
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: Error "OracleRuntimeException:

Off-row LOB leaf update contains unexpected

values...unexpected cvdatasize <2> for op type 2"

causes the Replication Agent to suspend

replication.



CR:466859
CR Number:   466859
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.01 24 Jul 2007 Fixed
5.3.05 14 May 2007 Fixed
5.6.00 27 Feb 2008 Fixed
Description
ORACLE ONLY: Replication Agent fails to

correctly replicate a table that

contains a virtual column.





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

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