提供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:443080
CR Number:   443080
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2006 Fixed
14 Nov 2006 Fixed
14 Nov 2006 Fixed
14 Nov 2006 Fixed
Description
ERROR #30022 DIST: Invalid command encountered in distributor. smd_cmd = 114, status = 8000000 on rollback command issued by RA DB2.
Workaround Description
 Increase sqt_max_cache_size.



Alternatively, use sqm_zap_command to delete the rollback and the oqids that it is

rolling back --OR-- zap the begin to remove the transaction.



CR:443118
CR Number:   443118
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.4.00 04 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
5.4.00 02 Apr 2010 Presently Not Targeted For Any Future Release Of This Product
Description
ORACLE ONLY: RepAgent does not report an error

when user attempts to unmark an unmarked object

(table, procedure, sequence).



CR:443197
CR Number:   443197
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.00 04 Dec 2006 Fixed
5.4.00 04 Dec 2006 Fixed
Description
ORACLE ONLY: Replication Agent fails

with error: LTI unable to process

unsupported operation: -1(UNDEFINED)



CR:443289
CR Number:   443289
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.00 04 Dec 2006 Fixed
Description
ORACLE ONLY: Primary key data is missing

from update to large table.



CR:443777
CR Number:   443777
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2007 Not a Bug
Description
LTMAPI abends with 1403.



CR:443802
CR Number:   443802
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)
04 Feb 2007 Fixed
13 Apr 2007 Fixed
07 Jun 2007 Fixed
Description
RS deadlocks when one thread holds the FSTR_GLOBAL_FSOBJ_MUTEX_C and attempts to access the rs_subscriptions table, while another thread has rs_subscription table locked and attempting to obtain the FSTR_GLOBAL_FSOBJ_MUTEX_C.



CR:444045
CR Number:   444045
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2006 Fixed
07 Dec 2006 Fixed
07 Dec 2006 Fixed
Description
rs_subcmp cores on strcmp when key columns are included in select statement more than once.



CR:444062
CR Number:   444062
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2009 Fixed
Description
hds_msss_funcstrings.sql script missing asterisk for ending a comment.
Workaround Description
 Fix the second to the last insert for rs_batch_end function string in hds_msss_funcstrings.sql as follows:



insert rs_funcstrings

values(

0, /* prsid */

0x0000000001000011, /* msss func class id */

0x000000000400001f, /* rs_batch_end func id*/ <=== insert asterisk for end

'rs_batch_end', /* name */

0x000000000ffff81f, /* fstringid */

16, /* attributes */

0, /* parameters */

0, /* param_hash */

'01-01-4000', /* expiredate */

1, /* rowtype */

0 /* minvers */

)



CR:444311
CR Number:   444311
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
Allow the MSA replication to honor the "send standby all columns" capability available in warm standby.



CR:444312
CR Number:   444312
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
ll_del when customer shuts down target ASE server while RS connections are active.
Workaround Description
 Bring back up RS. It will not core again immediately from this problem.



CR:444460
CR Number:   444460
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.00 04 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
Description
ORACLE ONLY: RepAgent does not correctly read a

certain type of commit log record.



CR:444596
CR Number:   444596
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.00 04 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
Description
ORACLE ONLY: RepAgent does not correctly process the

rename option for an alter table DDL command.



CR:445067
CR Number:   445067
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   NA
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.00 04 Dec 2006 Fixed
Description
RepAgent can lose data when Replication Server

terminates abnormally.



CR:445068
CR Number:   445068
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   NA
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 27 Oct 2008 Fixed
5.5.23 12 Jan 2009 Fixed
5.8.00 27 Oct 2008 Fixed
Description
Replication Agent goes to ADMIN state without

retrying connection after Replication Server

outage.



CR:445204
CR Number:   445204
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.10 15 20 Aug 2007 Fixed
Description
Rep Agent abend, 818-18, when log records for a partitioned table space are being processed.



CR:445206
CR Number:   445206
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.10 15 16 Apr 2007 Fixed
Description
Rep Agent goes into a wait state when a table space that RA is using is stopped.



CR:445287
CR Number:   445287
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5302P13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Fixed
5.3.04 02 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
5.3.08 22 May 2008 Added to user documentation
Description
Added new Replication Agent command

pdb_setreptable.





Description:



Allows one or more tables to be 'disabled' from

replication. Allows previously disabled tables to

be re-enabled, and allows the current status of

existing tables to be listed.



This command can be used to disable replication

of tables whose content need not be replicated.

Disabling replication in the Replication Agent

overrides the marking status established in the

primary Adaptive Server Enterprise database by

ASE commands sp_setreptable and sp_reptostandby.





Syntax:



To return replication enabled status:

pdb_setreptable {tablename|enable|disable}



To enable, or disable all marked tables:

pdb_setreptable all, {enable|disable}



To enable, or disable a specified table:

pdb_setreptable tablename, {enable|disable}





Parameters:



tablename

The name of a user table in the primary database.



The tablename parameter can be owner-qualified to

include the primary table owner name, with each

element separated by a period. For example:

owner.table



This parameter can be delimited with quote

characters to specify the character case.

If mixed character case (both uppercase and

lowercase) is required, the name must be

delimited. For example:

"Owner".table

"Owner"."Table"





all

A keyword that refers to all tables in the

primary database. By using the all keyword you

can apply an enable or disable operation to

all marked tables.





enable

A keyword that refers to enabling replication for

marked tables.





disable

A keyword that refers to disabling replication

for marked tables.





Usage notes:

If pdb_setreptable is invoked with no parameter,

it returns a list of all marked tables in the

primary database for which replication is

enabled. Note this is the same result returned

when the enable keyword is supplied.



If pdb_setreptable is invoked with a table name,

it returns complete marking information about

the specified primary table.



If pdb_setrepable is invoked with the enable

keyword, it returns a list of all marked tables

in the primary database for which replication is

enabled.



If pdb_setrepable is invoked with the disable

keyword, it returns a list of all marked tables

in the primary database for which replication is

disabled.



If pdb_setreptable is invoked with a table name

and the disable keyword, it disables future

replication of activity which occurs against

the specified marked table.



If pdb_setreptable is invoked with a table name

and the enable keyword, replication is re-enabled

for the specified marked table that was

previously disabled.



When pdb_setreptable is invoked with the all

keyword and an action keyword (enable or disable)

the action specified is applied to all marked

tables in the primary database.



If pdb_setreptable is invoked with the all and

disable keywords, it disables replication for all

marked tables in the primary database.



If pdb_setreptable is invoked with the all and

enable keywords, it enables replication for all

marked tables in the primary database that were

previously disabled.



Note that the output from command pdb_setreptable

contains several columns of information,

including the table's owner, name, mark and

enabled status. Only the result of the 'Enabled'

column can be changed using the pdb_setreptable

command. Other column values are only

informational.



Note that the output from command pdb_setreptable

contains some column values which mimic output

from other Replication Agents and their usage is

not applicable to ASE. The results from these

columns are returned as "N/A".





Examples:



pdb_setreptable authors

This command returns replication marking

information for the table named authors in the

primary database.



pdb_setreptable disable

This command returns replication marking

information for all marked tables for which

replication has been disabled.



pdb_setreptable all, enable

This command enables replication for all marked

tables in the primary database.



pdb_setreptable authors, enable

This command enables replication for the marked

table authors in the primary database.



CR:445288
CR Number:   445288
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTM
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5302P13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Fixed
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
Description
If the user configures the RSSD login information

incorrectly then resumes replication, the RepAgent

hangs.



CR:445292
CR Number:   445292
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2006 Fixed
19 Dec 2006 Fixed
Description
When executing "admin stats", RS tries to clear existing stats. If the last statistics run was large, the RS initiates a transaction in the RSSD that will insert rows in the rs_statsdetail table. The RSSD log may suspend causing the RS to hang.



CR:445355
CR Number:   445355
Product Name:   RepAgent for MVS
Product Component:   RepAgent for MVS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2007 Presently Not Targeted For Any Future Release Of This Product
Description
RepAgent for DB2 UDB terminates with user 1402 abend when DB2 returns CCSID zero and the RepAGent's Codepage "force" option is not set on.



CR:445371
CR Number:   445371
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2008 Fixed
28 Oct 2008 Fixed
Description
ORACLE ONLY: Executing quiesce command during

large LOB processing can causes Replication Agent

to hang.



CR:445413
CR Number:   445413
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 Mar 2007 Fixed
06 Mar 2007 Fixed
06 Mar 2007 Fixed
06 Mar 2007 Fixed
Description
Username returned from "get maintenance user" command can be incorrect
Workaround Description
 On RA DB2, use usernames that are 7 characters or more.



CR:445432
CR Number:   445432
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 02 Oct 2007 Fixed
Description
Create trace for maintenance user and parse the maintenance user from RS to get the correct maintenance username.
Workaround Description
 Currently, there are a couple of workarounds, however, these may not be acceptable to the customer since it may violate site standards:

a. For the maintenance user id (and the work that is not supposed to be replicated), make sure that it is 7 characters or more. I am hoping that the RS bug will be fixed by the time that RA DB2 15.0 is released.

b. Turn off replication for the table and turn it back on after the maintenance work has completed



CR:445437
CR Number:   445437
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.00 04 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
Description
Some errors during runtime are logged as "Could

not find Resource Bundle containing index: XXX"

where XXX is a message key.



CR:445592
CR Number:   445592
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.00 04 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
Description
Though documented, the 2-parameter version of the

pdb_get_procedure_parms is missing. This version

of the command returns the list of all parameters

for a specific owner and procedure.



CR:445606
CR Number:   445606
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2007 Fixed
13 Apr 2007 Fixed
07 Jun 2007 Fixed
Description
If an RS server user thread (i.e. ISQL) suspends due to locking issues,

interrupting the RS server user thread with Ctrl-C will sometimes cause

the RS server to terminate immediately.



CR:445691
CR Number:   445691
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.10 16 11 Jan 2007 Fixed
Description
Transactions done by the maintenance user are replicated.
Workaround Description
 None that I know of. Somehow trace=calls does not have the deviant behavior, however this trace produces a lot of extra messages.



CR:445759
CR Number:   445759
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)
17 Apr 2007 Fixed
13 Dec 2006 Fixed
17 Jul 2008 Presently Not Targeted For Any Future Release Of This Product
17 Jul 2008 Fixed
17 Jul 2008 Presently Not Targeted For Any Future Release Of This Product
16 Jul 2008 Fixed
Description
In a WS environment, if the active

database is not replicating transactions

at the time a switch active is

initiated, when the switch active

completes, changes to the new standby

(former active) database is incorrectly

written into the inbound queue of the

logical connection.
Workaround Description
 Before switching active, make sure that the Rep Agent of the active database is shutdown. The action to shutdown the RA may not be necessary if the active database is crashed or corrupt. However, one needs to make sure that the RA is down. iIf one cannot shutdown the RA through the sp_stop_rep_agent command, one can do a sp_kill on the RA spid.)



CR:446024
CR Number:   446024
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Java VM
Status:   Closed
OS:   Generic
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.00 04 Dec 2006 Fixed
5.4.00 01 Dec 2006 Fixed
5.3.03 10 Dec 2006 Fixed
12.5.0.305P6 02 Jul 2007 Fixed
Description
New JREs are required in order to correctly support

the USA's change, effective in March 2007, as to

when Daylight Saving Time starts and stops. The

following JREs, which have the Daylight Saving Time

fix, also have a bug related to the use of the

JISAutoDetect character set:



Solaris SPARC, Linux, Windows: 1.4.2_12

HP PA-RISC: 1.4.2_11



As a workaround, RepAgent currently does not

support this character set on *any* platform.

The JISAutoDetect character set "Detects and

converts from Shift-JIS, EUC-JP, ISO 2022 JP

(conversion to Unicode only)".



CR:446030
CR Number:   446030
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   AIX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2007 Fixed
15 Mar 2007 Fixed
15 Mar 2007 Fixed
15 Mar 2007 Fixed
15 Mar 2007 Fixed
Description
rs_subcmp when attempting to reconcile tables with text columns and a the value of the key column include a "%", error messages 105 and 102 are raised reporting "Unclosed quote before the character string '='" and "Incorrect syntax near '='"



CR:446198
CR Number:   446198
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow ASE specific function strings (especially rs_set_ciphertext) to not be triggered or to not send anything (not even a line terminator or blank) to the target server.



CR:446282
CR Number:   446282
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.6.0.5302P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2008 Duplicate
Description
RepAgent for Oracle cannot be worked as Windows Service.

ra.bat cannot be entered into Windows Service.



CR:446289
CR Number:   446289
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When First Segment of SQM moves by one transaction, if Rep is rebooted, Block# of First Seg will be set to 1.

But Block# is returned to the correct position, when new transaction begins.

6146 errors will be caused if quiece_check is executed by the way in this state. But this error is mistake.



CR:446410
CR Number:   446410
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5302P13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.5.00 16 May 2007 Fixed
5.4.01 22 Feb 2007 Fixed
Description
Output for statistic

"Log reposition point locator"

has an invalid hex value indicator.



CR:446705
CR Number:   446705
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.10 18 11 Jan 2007 Fixed
Description
High CPU use when Support_DB2_comp_rec=N on non-datasharing environments.



CR:447261
CR Number:   447261
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   NA
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2007 Not a Bug
Description
When RA is run as a started task, the started task userid must have sysadm authority on DB2.



CR:447265
CR Number:   447265
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
sysadmin sqt_dump_queue produces assertion error and stack.
Workaround Description
 None, bringing back up the RS leaves it in the same condition as before. In other words, after one brings back up the RS, if one issues the sqt_dump_queue command again, the RS will stack again.



CR:447271
CR Number:   447271
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.10 20 29 Nov 2006 Fixed
Description
RA DB2 abends with RS 15.0 and use_repdefs = Y.
Workaround Description
 Use_repdefs = N. The RA DB2 will connect to the RS correctly. At this time, QA has preliminarily reported that there is a corruption of data. However, further investigation is needed on this claim.



CR:447318
CR Number:   447318
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 Dec 2006 Fixed
12 Dec 2006 Fixed
12 Dec 2006 Fixed
27 Jul 2007 Fixed
03 Sep 2007 Fixed
03 Sep 2007 Fixed
03 Sep 2007 Fixed
Description
RS may hang or be non-responsive for a short

interval, due to the incorrect calls to the

non-thread safe routine 'localtime()'. Calls to

this routine are replaced with calls to the

thread safe routine 'localtime_r()'.



CR:447740
CR Number:   447740
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
Define subscription command with dump marker will put message in RS log indicating that data can be replicated prematurely.



CR:447749
CR Number:   447749
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
Define MSA subscription without "use dump marker" clause does not replicate data to target.
Workaround Description
 Drop the subscription and use the create subscription command without materialization



CR:447765
CR Number:   447765
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.5.00 16 May 2007 Fixed
5.4.01 22 Feb 2007 Fixed
Description
ORACLE ONLY: RepAgent incorrectly reads the log

record that is generated when a table is altered

by dropping a column with data rows.



CR:447797
CR Number:   447797
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2006 Workaround
18 Apr 2007 Fixed
Description
This issue appears to be related to CR 396183.

Repository server : MS SQL Server 2000

Target DBMS: DB2 8 common server



Proxy server: PDM with views fails to extract from migrated repository



Customer has upgraded from PD 11.x to PD 12.1.0 EBF2. Via a direct connection to the repository, they can consolidate and extract all models. However, via a proxy server connection, they get the following error message when extracting a PDM:



PowerDesigner Error

A command sent to the repository proxy failed.

22005 (SQLSTATE [Microsoft] [ODBC SQL Server Driver] Invalid character value for cast specification)



When reviewing the proxy server log, the following warning is documented after this ODBC error:

ExtractModel: Failed when extracting OBJT = xxxxx



Upon querying the PMOBJT table, this object id belongs to a view



For repositories created in v12 or 12.1, this error does not occur.



CR:447973
CR Number:   447973
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.01 02 Apr 2010 Insufficient priority to fix
Description
MICROSOFT SQL SERVER ONLY: Trying to replicate an

ntext column results in the following error:

Failed to Open LOB data stream.



CR:447980
CR Number:   447980
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.00 04 Dec 2006 Fixed
5.4.00 02 Apr 2010 Insufficient priority to fix
12.5.0.305P6 02 Jul 2007 Fixed
Description
MICROSOFT SQL SERVER ONLY: When a table that

contains a LOB column is marked for replication

and the LOB column is enabled for replication, a

user other than the pds_username user gets an

error when inserting into the primary table.



IMPORTANT: This fix works only for tables that are

marked AFTER this EBF has been applied to

RepAgent. The WORKAROUND for existing marked

tables is the following:



1 In a text editor, open the mark.sql script for

the desired table. The script will be in:



$SYBASE/rax-12_5/<inst>/scripts/<tbl>/installed



where <inst> is the RepAgent instance name and

<tbl> is the table name



2 Find and copy the text for creating the shadow

row procedure to another file.



3 In the new file, edit the shadow row procedure

by owner-qualifying the name of the blob-shadow

row procedure as this snippet indicates:



BEFORE:

=======

SELECT @opid = @@IDENTITY

IF @dummy > 0

BEGIN

EXEC qa3bsrp_d @tranid,@opid,@intype

END

END -- not = 'a'



AFTER:

======

SELECT @opid = @@IDENTITY

IF @dummy > 0

BEGIN

EXEC <rausr>.qa3bsrp_d @tranid,@opid,@intype

END

END -- not = 'a'



where <rausr> is the name you configured in the

pds_username parameter, or possibly 'dbo' if

the <rausr> was granted full SA permissions.



4 Save this file.



5 In SQL Server, lock the primary table to prevent

any modifications (so replication won't lose any

operations or transactions against this table).



6 In SQL Server, drop the existing shadow row

procedure.



7 In SQL Server, re-create the shadow row

procedure using the saved SQL script you edited.



8 In SQL Server, unlock the primary table.
Workaround Description
 The WORKAROUND for existing marked

tables is the following:



1 In a text editor, open the mark.sql script for

the desired table. The script will be in:



$SYBASE/RAX-12_6/<inst>/scripts/<tbl>/installed



where <inst> is the RepAgent instance name and

<tbl> is the table name



2 Find and copy the text for creating the shadow

row procedure to another file.



3 In the new file, edit the shadow row procedure

by owner-qualifying the name of the blob-shadow

row procedure as this snippet indicates:



BEFORE:

=======

SELECT @opid = @@IDENTITY

IF @dummy > 0

BEGIN

EXEC qa3bsrp_d @tranid,@opid,@intype

END

END -- not = 'a'



AFTER:

======

SELECT @opid = @@IDENTITY

IF @dummy > 0

BEGIN

EXEC <rausr>.qa3bsrp_d @tranid,@opid,@intype

END

END -- not = 'a'



where <rausr> is the name you configured in the

pds_username parameter, or possibly 'dbo' if

the <rausr> was granted full SA permissions.



4 Save this file.



5 In SQL Server, lock the primary table to prevent

any modifications (so replication won't lose any

operations or transactions against this table).



6 In SQL Server, drop the existing shadow row

procedure.



7 In SQL Server, re-create the shadow row

procedure using the saved SQL script you edited.



8 In SQL Server, unlock the primary table.



CR:448358
CR Number:   448358
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
When sending parameters to a trigger script for a route status event, RMS incorrectly sends values in the "thru_type" and "thru_name" fields for a direct route. These fields are only used in indirect routes when there are intermediate Replication Servers.



CR:448370
CR Number:   448370
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)
403 15 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The status of a Replication Agent is not displayed correctly when a route is created between two replication servers that are configured to use embedded RSSDs.



CR:448444
CR Number:   448444
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
08 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Stored procedure executed by WarmStandby is executed also by PrimaryDB of the same sqlserver.



CR:448537
CR Number:   448537
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5302P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 20 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
5.4.01 02 Apr 2010 Presently Not Targeted For Any Future Release Of This Product
5.4.01 22 Feb 2007 Fixed
Description
ORACLE ONLY: The primary key for a table whose

primary key includes more than one column is

incorrectly identified.



CR:448625
CR Number:   448625
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requests some improvements to the consolidation process outside of Proxy



CR:448657
CR Number:   448657
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)
15.0.1 12 Jun 2008 Fixed
15.0.1 12 Jun 2008 Fixed
Description
after ebf1385 sybase central stack trace err when clicking the "connect" button
Workaround Description
 C) /redgiant1/mweaver/scrsrm15ga_rsrm15e1_scrm15e1

1) install RS150_ga...(installed from /c11160147/RS150_image)

2) install ebf13857_RS150_ESD1...(installed from

/c11160147/RS150_ESD1_image/ebf13857)

3) install ebf13619_RM150_ESD1_SC...(installed from

/c11160147/RM150ESD1SybCentImage/ebf13619)

connect works



CR:449198
CR Number:   449198
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)
06 Aug 2007 Fixed
06 Aug 2007 Fixed
06 Aug 2007 Fixed
Description
Replication Server stack traces if bigint datatype is used with the "map to" clause to map to a non-Sybase datatype.



CR:449201
CR Number:   449201
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.5.00 16 May 2007 Fixed
5.4.01 22 Feb 2007 Fixed
Description
ORACLE ONLY: RepAgent does not correctly process

the drop column option for an alter table DDL

command.



CR:449215
CR Number:   449215
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.10 23 11 Jan 2007 Fixed
Description
RA DB2 is not replicating some updates.
Workaround Description
 Customer doesn't know what else is missing. For these updates, problem can be worked around by not having minimal columns set on the replication definition.



CR:449428
CR Number:   449428
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   unknown
Original Version:   5.3.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
12.5.0.305P6 02 Jul 2007 Fixed
Description
When replicating LOB data, if a character type

primary key column contains single quotes,

RepAgent may go to ADMIN state with an error

similar to: Unclosed quotation mark before the

character string ''.



NOTE that to replicate character data that embeds

single quotes, RepAgent must be configured to use

structured tokens:



ra_config structured_tokens, true



CR:449655
CR Number:   449655
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   telemaque EBF4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2006 Not a Bug
Description
In the Repository explorer the refresh of a view column's user-defined name/code

is not correct. The same behavior can be observed with local merging.



CR:449700
CR Number:   449700
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.4.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.01 22 Feb 2007 Fixed
5.3.03 10 Dec 2006 Fixed
5.5.00 16 May 2007 Fixed
Description
ORACLE ONLY: LTI error resulting from error

processing alter table DDL command with rename

option.



CR:449770
CR Number:   449770
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2009 Duplicate
Description
Upgrade from RS 12.6/12.5 to RS 15.0 fails on duplicate interfaces entries and lack of .cfg file in REP-15_0/install directory.
Workaround Description
 a. remove duplicate entries out of the interfaces file after installing the software

b. copy the RS 12.6 config file from the REP-12_6/install directory to the REP-15_0/install directory.



CR:449820
CR Number:   449820
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.3.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.03 10 Dec 2006 Fixed
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
12.5.0.305P6 02 Jul 2007 Fixed
Description
Executing pdb_execute_sql may return a

NullPointerException instead of returning the

database's error message.



CR:449991
CR Number:   449991
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2008 Fixed
Description
Upgrade of RS 12.6 to RS 15.0 may not be able to drop the rs_dump_stats stored procedure if user who created the procedure is not the primary RRSSD user. The upgrade script will be unable to drop the procedure and the upgrade script will fail.The stored procedure will need to be dropped from the RSSD before the upgrade can be restarted.
Workaround Description
 Manually drop the rs_dump_stats procedure before upgrade.



CR:450122
CR Number:   450122
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Adding a database with a long name combined with long maintenance user name will result in core in rs_init



example: when maintenance user > 24 characters and dbname = 21 characters ...... the number of combined characters of the database and the maintenance user id is > 42
Workaround Description
 Since the SEGV happens when rs_init checks to see if the maintenance user is present, one can either shorten the name of the maintenance user or use one of the manual methods to create the desired maintenance user (e.g. manually do the work that rs_init does or create a connection with a smaller maintenance user id and then change the username in the rs_maintusers table).



CR:450318
CR Number:   450318
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   athena
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2007 Fixed
25 Jan 2007 Fixed
Description
If you update the repository even if views are not modified their version numbers are increased



CR:450456
CR Number:   450456
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   telemaque EBF4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Based on CR 449655 - Code / Name Display in Repository.

The display of this info as it is an Internal information, it should not been displayed specially when in Tools --> display preferences, Code is selected.



CR:450485
CR Number:   450485
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)
25 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The parameters panel used on various properties dialogs in the Replication Manager does not update the run value in the parameter table when you press the Apply button. Closing the dialog then re-opening it will display the correct values.



CR:451349
CR Number:   451349
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.10 11 Jan 2007 Fixed
Description
Type(8) update incorrecty identified as compressed.
Workaround Description
 For this specific problem, none. However, in 12.6.9, update(8) records (delete and insert) were not processed at all. If there is another update to the same record, and replicate minimal columns is off in the replication definition, the second update will update the all the columns of the record, therefore minimizing the impact of the missing update.



This problem should not happen if the update(8) is done against a non-compressed tablespace.



CR:451385
CR Number:   451385
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
5.5.00 16 May 2007 Fixed
Description
IBM UDB ONLY: RepAgent for UDB now supports

replication of inserts/updates/deletes from

Multidimensional Clustered Tables.



CR:451440
CR Number:   451440
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5400
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
Description
RepAgent fails to start up under a

non-English(en_US) locale. It fails

with the following message

''Encountered an invalid build date.

Reason: Unparseable date: ''Fri Nov

17 19:08:41 MST 2006''.
Workaround Description
 The fix has been checked into the 15.0 sustaining and the main codeline. It will be available in the next 15.0 ESD. This 15.0 ESD will be available in early Feb 2007.

During this time, if you need the fix, you may be able to download the attachment from this CR. There will be two jar files (rax.jar and rax_debug.jar). You will need

to place these files under $SYBASE/RAX-15_0/classes directory. Save off the two jar files before you update this with the fix.



CR:451504
CR Number:   451504
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Red Hat Linux
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2007 Fixed
10 May 2007 Fixed
10 May 2007 Fixed
Description
DSI does not release memory properly causing Replication Server to consume all allocated memory. Replication Server will stay up longer if the "memory_limit" is increased.
Workaround Description
 None at this time. One can increase memory_limit to increase how long the RS will stay up.



CR:451585
CR Number:   451585
Product Name:   Replication HDS
Product Component:   HDS scripts
Status:   Closed
OS:   Unknown
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Fixed
Description
Add a datetime datatype of format DD MON CCYY hh:mm:ss:ttt to the existing MS SQL udds.
Workaround Description
 See description tab on what to add to the RSSD. After putting it into the RSSD, reboot the RS and use that datatype in the repdef. The datatype can be any desired name that has not been previously used.



CR:451727
CR Number:   451727
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.3.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 03 Oct 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent fails

with a NullPointerException when executing

a pdb_setrepproc command to mark a procedure

that contains no arguments.



CR:452007
CR Number:   452007
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
Repository code for pdb_init.



CR:452313
CR Number:   452313
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)
16 Jan 2007 Fixed
29 Apr 2008 Fixed
08 Jun 2007 Fixed
Description
Emptry transaction processing by Replication Server may cause a single empty transaction to be deleted from the "open" list twice. Replication Server would report a problem in "sqt_delete_tran()".



CR:452354
CR Number:   452354
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5303P14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Fixed
5.4.01 22 Feb 2007 Fixed
5.5.00 16 May 2007 Fixed
Description
Maintenance user transactions may still be

processed the first time a Replication Agent

reaches replicating state.



CR:452528
CR Number:   452528
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When upgrading a repository one version to the next, the customer would like PD to rollback all executed statements if an error occurs during the upgrade process.



CR:452633
CR Number:   452633
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)
11 Jan 2007 Fixed
15.0 12 Jan 2007 Fixed
12.6 12 Jan 2007 Fixed
Description
RS negotiation with OCS for encrypted passwords is not working correctly, SVR_ENCRYPT should be evaluated as an integer not bit value. If both SRV_EXTENDED_ENCRYPT and SRV_ENCRYPT are on, Repserver should allow connections even if RS does not support SRV_EXTENDED_ENCRYPT.



CR:452763
CR Number:   452763
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.00 16 May 2007 Fixed
5.3.04 15 Mar 2007 Fixed
5.5.01 24 Jul 2007 Fixed
Description
Improved system log and trace messaging

performance.



CR:452806
CR Number:   452806
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)
10 May 2013 Insufficient priority to fix
Description
Replication Server may stop replication to a target database due to

an application deadlock with the ASE server when the Replication Server

is configured to use Parallel DSI and is applying transactions to a

table containing TEXT/IMAGE columns.



When this situation occurs, the Replication Server 'admin who' command

will display the Replication Server thread 'DSI EXEC' in either the

thread state 'Awaiting Commit Order' or 'Awaiting Batch Order'. The

thread state of the thread will not change over time.



To correct this issue, suspend and resume the Replication Server DSI

connection. If the Replication Server DSI thread fails to suspend,

re-start the Replication Server.



CR:452894
CR Number:   452894
Product Name:   Rep Server Tests
Product Component:   Rep Server Tests
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2011 Presently Not Targeted For Any Future Release Of This Product
Description
The commands in a mini rollback section of a transaction are filtered out by Repserver

and never applied at databases replicated through subscriptions. They are not applied

at warm standby databases if the transaction is not a large transaction.



For large transaction replicating to warm standby, if the DSI is fast, the commands

in the mini rollback section may be applied at standby and then rolled back. These

commands may cause error at standby and cause DSI to shutdown. Users should resume

connection to clear out the error.



CR:452899
CR Number:   452899
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 using dynamic SQL and Replication Server with warm standby or MSA and the user

creates a repdef which adds columsn to the internal repdef. If the new repdef lists the

columns not in the order listed by the table definition, the column order DSI sends to

the warm standby or MSA will not match the prepared dynamic SQL statement. This could

replicate the data out of column order or suspend the DSI. The problem can be avoided by

suspending the DSI before the repdef is created.



CR:452913
CR Number:   452913
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2007 Fixed
08 May 2007 Fixed
15 Jul 2008 Fixed
11 Sep 2007 Fixed
12 Sep 2007 Fixed
12 Sep 2007 Fixed
15 Jul 2008 Fixed
15 Jul 2008 Fixed
Description
On SUNX86, creating a partition larger

than 2GB may fail depending on the size

of the partition. In some cases, error

6125 is generated after the failure. In

other cases, no error is generated after

the failure.
Workaround Description
 Use one of the numbers that works. For instance, use a file size of 8192 for an 8 GB stable device.



CR:452919
CR Number:   452919
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Option to make stored procedure replication and DDL replication be applied by the maintenance user id, instead of the originating user id.



CR:453158
CR Number:   453158
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)
16 Jan 2007 Fixed
18 Jan 2007 Fixed
Description
RS has small memory leak in DSI module, likely to occur when dropping large number of subscriptions at the same time.



CR:453309
CR Number:   453309
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
rs_helpsub on a MSA subscription returns a display that indicates the subscription is corrupt when it really isn't.
Workaround Description
 None. Use rs_helpdbsub.



CR:453332
CR Number:   453332
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2008 Duplicate
21 May 2008 Not reproducible with latest version of the product available as of Resolution Date
20 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
21 May 2008 Not a Bug
28 May 2008 Duplicate
Description
Uninstall of Replication Server must use the same JVM as was used at install of the release. For instance if -is:javahome JVM was used at installation then the identical JVM must be specified in order to uninstall the release.



CR:453418
CR Number:   453418
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)
26 Feb 2007 Fixed
Description
Example 1 in admin translate command shows incorrect time format



CR:453752
CR Number:   453752
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
For internal use only (new development):

MICROSOFT SQL SERVER ONLY:

Repository code for mark/unmark.



CR:453813
CR Number:   453813
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: Implement RAMLogAdmin

Module(pdb_setreptable and related pdb_xxx

properties ,ra_helparticle,ra_helpfield...)



CR:453844
CR Number:   453844
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)
15.0.1 404 23 Jan 2007 Fixed
15.0.1 404 27 Jan 2007 Fixed
Description
A connection deadlock occurs when shutting down Sybase Central when there are more then 2 environments open. The problem only occurs if monitoring an envirnment where at least one of the servers is down. The problem only occurs when the total number of server connections is greater then 10.



CR:453878
CR Number:   453878
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)
15.0.1 404 24 Jan 2007 Fixed
15.0.1 404 27 Jan 2007 Fixed
Description
The subscription wizard attempts to display all table replication definitions associated with a primary table. The wizard retrieves the replication definitions and filters out those that do not match the current replicate table and owner name. The wizard is not filtering the list correctly.



CR:453898
CR Number:   453898
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Compile HP RS executeables with SHMEM_MAGIC



CR:453986
CR Number:   453986
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.3.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Workaround
5.4.01 22 Feb 2007 Workaround
Description
MICROSOFT SQL SERVER ONLY: WORKAROUND:

In SQL Server 2005, the sys.syslockinfo system

table is now presented as a denormalized view. To

allow user access to this system table, which is

needed when the RepAgent "ra_get_tx_info_" stored

procedure is called during change data capture,

you must grant VIEW SERVER STATE permission to

PUBLIC.
Workaround Description
 grant "view server state" permission to public on MS-SQL Server 2005 primary dataserver :



SQL> grant view server state to public



CR:454006
CR Number:   454006
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Duplicate
Description
Enhancement for 64-bit executeables in RS.



CR:454224
CR Number:   454224
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.0.5400
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.04 15 Mar 2007 Fixed
5.4.01 22 Feb 2007 Fixed
5.5.00 22 May 2007 Fixed
Description
MICROSOFT SQL SERVER ONLY: During unmark

processing, triggers for tables owned by owner

other than 'dbo' may not be removed.



CR:454228
CR Number:   454228
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.4.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.00 22 May 2007 Fixed
5.5.00 22 May 2007 Fixed
5.5.01 24 Jul 2007 Fixed
5.5.01 24 Jul 2007 Fixed
Description
UDB ONLY: RepAgent can now replicate

individual rollback

operations(insert/update/delete).



CR:454346
CR Number:   454346
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
upgrade rs_helpexception with order by to list rows sequentially by "Xact ID"(sys_trans_id)...the following order by statement should be added to the rs_helpexection stored procedure...order by #tab1.sys_trans_id asc



CR:454375
CR Number:   454375
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)
28 Jan 2010 Fixed
Description
The Replication Manager Plug-in does not display the parameters for non-ASE stored procedures if the interface server is a Replication Agent or Mirror Replication Agent from a version before 12.6 ESD #6. The parameters for a stored procedure are displayed in the stored procedure properties dialog and the create function replication definition dialog.
Workaround Description
 Upgrade the Replication Agent or Mirror Replication Agent to version 12.6 ESD #6 or version 15.0.



CR:454404
CR Number:   454404
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
Description
ASE ONLY:

complete the implementation of

repdef generation automatically



CR:454472
CR Number:   454472
Product Name:   RepAgent/ASA
Product Component:   Replication Agent
Status:   Closed
OS:   Generic
Original Version:   10.0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0.1 3390 23 Feb 2007 Fixed
10.0.0 2809 27 Feb 2007 Fixed
Description
When installing the Replication Agent, the installer updated the system path with the incorrect location of Open Server. This has been fixed.



CR:454484
CR Number:   454484
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Signal 11 with stack and no core, when grouped transaction is rolled back and commands will be applied individually.
Workaround Description
 This appears to be a timing issue with data in the stable device. Both purging the queue or starting the RS with the diag binary are workarounds.



CR:454491
CR Number:   454491
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 02 19 Feb 2008 Fixed
Description
If TRACE(MON) is shutdown while RA DB2 is active, RA should stay up.
Workaround Description
 Start up the RA DB2 again. At startup, RA DB2 checks for the presence of the trace and will start it up, if it doesn't find an active trace.





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

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