提供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:477212
CR Number:   477212
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.3.06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.07 17 Oct 2007 Fixed
5.5.04 03 Oct 2007 Fixed
5.6.00 28 Feb 2008 Fixed
Description
ORACLE ONLY: If the ltl_origin_time_required

configuration property is enabled, the origin

time for each LTL command is incorrect.



CR:477217
CR Number:   477217
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
32058 message does not display and RS stacks
Workaround Description
 Find the errant command and do sysadmin sqm_zap_command on the errant command. In this particular case, the RS upon rebooting would not start up after this error. This is because of CR 476859.



CR:477274
CR Number:   477274
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2008 Fixed
07 Jul 2008 Fixed
Description
When upgrading Replication Server 12.6

to Replication 15.0 or higher, the

upgrade may fail due to a failed 'create

index' command. The 'create index'

command fails because the column

'logical_name' in the table

'rs_diskpartitions1500' is incorrectly

declared as 'varchar(20)' rather than

'varchar(30)'.



CR:477363
CR Number:   477363
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.00 28 Feb 2008 Fixed
5.5.04 03 Oct 2007 Fixed
5.5.05 28 Feb 2008 Fixed
Description
UDB ONLY: When the pdb_xlog_device parameter is

set to a tablespace name, pdb_xlog create

command fails to create an index on the xlog

system table. The command generates the

following error: XLog could not be created

in database <db_name> because: Auto execute

failed:[IBM][CLI Driver][DB2/OS] SQL0109N

The "IN" clause is not allowed.



CR:477428
CR Number:   477428
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.6.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.00 28 Feb 2008 Fixed
5.5.04 03 Oct 2007 Fixed
5.5.04 03 Oct 2007 Fixed
Description
The value for parameter 'dbname' for command

ra_dump will not accept a value with a length

of more than 10 characters.



CR:477508
CR Number:   477508
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   NA
Original Version:   5.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 28 Feb 2008 Fixed
5.5.04 03 Oct 2007 Fixed
Description
The Replication Agent license error message "There

is no valid license for 2 CPUs on this machine for

Product <2>. Please install a valid license by

contacting Sybase, Inc." specifies an incorrect

product name in the message.



CR:477713
CR Number:   477713
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When the report template file is consolidated as an external document, error message

The consolidation of the document has been cancelled.
Workaround Description
 Open the template into the workspace, right click on it and consolidate as a model.



CR:477784
CR Number:   477784
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 02 25 Sep 2007 Fixed
Description
Connect to replication server fails.



CR:478005
CR Number:   478005
Product Name:   RepAgent for MVS
Product Component:   RepAgent for MVS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.6.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 04 02 Oct 2007 Fixed
Description
S0C4 abend with reason code 11 in module LTMIFI occurs when started using an ID without the appropriate DB2 permissions granted on TRACE and MONIITOR2.



CR:478029
CR Number:   478029
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
28 Feb 2008 Insufficient priority to fix
Description
ORACLE ONLY: Replication fails with error:

"Transaction context not found for commit

operation"



CR:478327
CR Number:   478327
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)
15.1 24 Sep 2007 Fixed
Description
rs_helpdbrep <dbrepdef>[, data_server[, database ] ] shows incorrect replicate ds.db
Workaround Description
 The new proc that will be going into RS 15.1. Verified correct by a customer who had issues with previous script in this workaround:



if exists (select name from sysobjects

where name = 'rs_helpdbrep' and type = 'P')

begin

drop proc rs_helpdbrep

end

go



/*

** rs_helpdbrep [repdef [, DS [, DB]]]

** repdef: DB replication definition name. Default "%".

** DS: Primary data server. Default "%".

** DB: Primary database. Default "%".

**

** Note: If only one DB repdef satisfies the search condition, this

** script outputs DB filters and related subscriptions.

*/

create procedure rs_helpdbrep

@repdef varchar(255) = "%",

@DS varchar(30) = "%",

@DB varchar(30) = "%"

as



/* ASA server can have only up to 126 bytes in 'like' clause */

declare @max_asa_pattern_size int

select @max_asa_pattern_size = 126



set nocount on



declare @rep_DDL int, /* Check DDL filter */

@rep_func int, /* Check function filter */

@rep_tran int, /* Check transaction filter */

@rep_sys int /* Check system procedure filter */

select @rep_DDL = 256, /* 0x100 */

@rep_func = 4, /* 0x004 */

@rep_tran = 16, /* 0x010 */

@rep_sys = 64 /* 0x040 */



/* Output DB replication definition information. */

select distinct

"DB Rep.Def. Name" = A.dbrepname,

"Primary DS.DB" = C.dsname + "." + C.dbname,

"Primary RS" = B.name,

"Rep.DDL " =

case

when (A.status & @rep_DDL) = 0 then "Yes"

else "No"

end,

"Rep.Sys. " =

case

when ((A.status/@rep_sys) % 4) = 0 then "All"

when ((A.status/@rep_sys) % 4) = 1 then "In-List"

when ((A.status/@rep_sys) % 4) = 2 then "None"

else "Out-List"

end,

"Rep.Table " =

case

when (A.status % 4) = 0 then "All"

when (A.status % 4) = 1 then "In-List"

when (A.status % 4) = 2 then "None"

else "Out-List"

end,

"Rep.Func. " =

case

when ((A.status/@rep_func) % 4) = 0 then "All"

when ((A.status/@rep_func) % 4) = 1 then "In-List"

when ((A.status/@rep_func) % 4) = 2 then "None"

else "Out-List"

end,

"Rep.Tran. " =

case

when ((A.status/@rep_tran) % 4) = 0 then "All"

when ((A.status/@rep_tran) % 4) = 1 then "In-List"

when ((A.status/@rep_tran) % 4) = 2 then "None"

else "Out-List"

end,

"Creation Date" = A.requestdate

from rs_dbreps A, rs_sites B, rs_databases C



where A.prsid = B.id and A.dbid = C.dbid and

C.dsname like @DS and C.dbname like @DB and

A.dbrepname like @repdef









order by A.dbrepname



/* If it is not a single DB repdef, stop outputing details. */

if (@@rowcount != 1)

return (1)



/* Output details of replication filters. */

print " "

select distinct

"Name" = A.name,

"Rep.Type " =

case

when A.type = 'T' and (B.status % 4) = 1

then "Rep.Table"

when A.type = 'T' and (B.status % 4) = 3

then "Not Rep.Table"

when A.type = 'F' and ((B.status/@rep_func)%4) = 1

then "Rep.Func."

when A.type = 'F' and ((B.status/@rep_func)%4) = 3

then "Not Rep.Func."

when A.type = 'X' and ((B.status/@rep_tran)%4) = 1

then "Rep.Tran."

when A.type = 'X' and ((B.status/@rep_tran)%4) = 3

then "Not Rep.Tran."

when A.type = 'P' and ((B.status/@rep_sys)%4) = 1

then "Rep.Sys."

when A.type = 'P' and ((B.status/@rep_sys)%4) = 3

then "Not Rep.Sys."

end,

"Owner" = A.owner

from rs_dbsubsets A, rs_dbreps B, rs_databases C



where A.dbrepid = B.dbrepid and B.dbid = C.dbid and

C.dsname like @DS and C.dbname like @DB and

B.dbrepname like @repdef









order by A.name



/* Output related DB subscriptions. */

print " "

select distinct

"DB Rep.Def. Name" = B.dbrepname,

"DB Sub. Name" = A.subname,

"Replicate DS.DB" = D.dsname + "." + D.dbname,

"Replicate RS" = C.name,

"Creation Date" = A.requestdate



from rs_subscriptions A, rs_dbreps B, rs_sites C,

rs_databases D, rs_databases E





where (A.type & 64) != 0 and A.objid = B.dbrepid and

A.dbid = D.dbid and D.prsid = C.id and

B.dbid = E.dbid and B.dbrepname like @repdef and

E.dsname like @DS and E.dbname like @DB











order by B.dbrepname



return (0)

go



CR:478366
CR Number:   478366
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5503P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
5.3.07 17 Oct 2007 Fixed
Description
ORACLE ONLY: Timestamp datatype fails to replicate

to Adaptive Server Enterprise database. Error:

"Class Level translation for column/parameter

failed. Source DTID is 'rs_oracle_timestamp9'.

Target DTID is 'datetime'"
Workaround Description
 fix the...

/rao15e1/RAX-15_0/scripts/hds_oracle_new_udds.sql

...or...

C:\rao15e1\RAX-15_0\scripts/hds_oracle_new_udds.sql



...script...by changing...

insert into rs_datatype

values(

0, /* primary rep server ID */

0x0000000001000008, /* classid */

'rs_oracle_timestamp9', /* name */

...

'CHAR', /* mask */

...

)

...to...

insert into rs_datatype

values(

0, /* primary rep server ID */

0x0000000001000008, /* classid */

'rs_oracle_timestamp9', /* name */

...

'MM/DD/CCYY hh.mm.ss.ttttttttt', /* mask */

...

)







here is a crumbtrail of this being done...

~ts/cases/11375000s/11375778/pseinfo-12/pse_mweaver/

2007_08_22__workaround_for_CR_478366.txt



CR:478368
CR Number:   478368
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
rs_helpdbrep examples are incorrect.



CR:478490
CR Number:   478490
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
Rollback oqid command displays truncated generation number.
Workaround Description
 None, know that the generation number of the oqid could be missing 0x00. Not having the zeros at the end is supposedly okay.



CR:478526
CR Number:   478526
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   5.6.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 06 Jul 2008 Fixed
5.8.00 06 Jul 2008 Fixed
5.7.00 06 Jul 2008 Fixed
5.5.17 06 Jul 2008 Fixed
Description
"The replication environment is not configured

to allow DDL replication" exception is thrown

when setting configuration properties

pdb_auto_create_repdefs to true and use_rssd

to false.



CR:478528
CR Number:   478528
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)
19 May 2008 Added to user documentation
Description
clearly document all details related to replicating master db with WS and MSA



CR:478585
CR Number:   478585
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Could not consolidate file type .xem. Error message appears: "The source document and the target document do not have the same document type. You should change the source document or the target document"
Workaround Description
 zip file before consolidating



CR:478662
CR Number:   478662
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 26 Sep 2007 Fixed
Description
On resetting QID to earlier values after a batch job completed in udpating tables with replication stopped, RAD 12.6.9 on restart hits 0C4 abend after processing 9 tables in 9 tablespaces in a non-datasharing DB2 subsystem in module LTMIMG at offset 0x6A6.



CR:478804
CR Number:   478804
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
Transactions in outbound queue are not labelled uniquely identified by source.
Workaround Description
 Mark the tables for replication so that a unique transaction, can only come from a single source.



CR:478935
CR Number:   478935
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5503P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
Description
ORACLE ONLY: Replication suspends with error:

OracleDDLException: Failed to create a table.



CR:479048
CR Number:   479048
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)
15.5 08 Aug 2013 Fixed
Description
Enable autocorrection on databases replicated with MSA
Workaround Description
 create table level repdefs and table subscription. Then put autocorrection on the repdef



In 15.5, the DSI parameter dsi_command_convert can be used as a way to get the same effect as autocorrection.



CR:479073
CR Number:   479073
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Java VM
Status:   Closed
OS:   Generic
Original Version:   5.3.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.07 17 Oct 2007 Fixed
5.5.08 30 Jan 2008 Fixed
Description
New JREs are required to fix a Daylight Saving Time

bug in the JRE when using EST, MST and HST abbreviations.



Solaris SPARC, Linux, Windows: 1.4.2_15

HP PA-RISC: 1.4.2_15

IBM AIX: 1.4.2 build ca142-20070317



CR:479087
CR Number:   479087
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5503P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
28 Feb 2008 Insufficient priority to fix
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
Description
ORACLE ONLY: Replication suspends with error:

exception: java.lang.OutOfMemoryError



CR:479256
CR Number:   479256
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
SQT down at startup does not produce message in the Rep Server log
Workaround Description
 Increased num_threads; in our case, we still couldn't get RS up, however all the threads were now started.



CR:479537
CR Number:   479537
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2007 Fixed
12 Dec 2007 Fixed
Description
Missing permissions on newly created packages in repository.

Workarounds:

1.Let the ADMIN give the rights to the package

or

2. developer can do the first consolidation with the package



CR:479701
CR Number:   479701
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.0.0.5503P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.04 03 Oct 2007 Fixed
5.6.02 06 May 2008 Fixed
Description
ORACLE ONLY: When processing several archive log

files that do not contain any data to be

replicated, the archives can not be removed

because no updated locator has been sent to

Replication Server.



CR:479820
CR Number:   479820
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)
21 Feb 2008 Fixed
28 Feb 2008 Fixed
25 Apr 2008 Fixed
27 Mar 2008 Fixed
Description
Upon reboot of Rep Server, the distributor should come up in the same state as what the distributor was when the Server was shutdown (like how DSIs work)
Workaround Description
 None



CR:479854
CR Number:   479854
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)
07 Sep 2007 Fixed
10 Sep 2007 Fixed
Description
Change the default for dynamic_sql_cache_management from "mru" to "fixed" and

default for dynamic_sql_cache_size from 20 to 100 to avoid thrashing in the cache.



"fixed" means once the cache is full, there will be no new prepared statements.

With "fixed", users can always see a performance improvement. With mru, users will

most likely get performance degradation because of thrashing once cache is full.

"mru" is probably only useful in the rare cases where users truly don't have resources

for a larger cache, and they have some tables rarely replicated (so that once these

tables fall off the cache, the most used tables don't get de-allocated).



Cache size 20 has been deemed too small in most customer cases.



CR:479977
CR Number:   479977
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Sep 2007 Fixed
Description
MSA define subscription with dump marker on the second set of databases on RS with routes, does not suspend the DSI connection.
Workaround Description
 Use a method for syncronization that does not require dump marker. For instance, stop all activity on primary, create the subscription, load the replicate, set the secondary truncation point and RA to start at the current point in the log, and start back up replication.



CR:480102
CR Number:   480102
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 27 Sep 2007 Fixed
Description
/f jobname,c,version does not display the version
Workaround Description
 Use the VERSION DD card



CR:480171
CR Number:   480171
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5305P16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.07 17 Oct 2007 Fixed
5.3.07 17 Oct 2007 Fixed
Description
ASE ONLY: A logged writetext of NULL would

generate a DSI error 7130 when the replicate did

not have 'select into/bulkcopy/pllsort' enabled.



CR:480201
CR Number:   480201
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Open
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature is requested to set hostname parameter in rs_subcmp login.
Workaround Description
 In both 12.6 and 15.0 it is possible to set this property using the CT-Library runtime configuration file. An [rs_subcmp] section needs to be added with:



[rs_subcmp]

CS_HOSTNAME = rs_subcmpCFGhost



CR:480231
CR Number:   480231
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 01 25 Sep 2007 Fixed
Description
All replication stops after STOP DATABASE is issued in DB2 V8 and V9.



CR:480320
CR Number:   480320
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 01 18 Sep 2007 Fixed
Description
Replicate fails for Data Sharing option, single.



CR:480325
CR Number:   480325
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 18 Sep 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Occasional S0C4 abend following /P jobname cmd.



CR:480511
CR Number:   480511
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 23 Sep 2007 Fixed
Description
Using an encrypted column in a database replication definition and table replication definition is not completely documented.
Workaround Description
 What is written up in the ASE alter table documentation:



After replicating an alter table to modify an

encrypted column, an update or delete may fail to qualify any rows

at the replicate site. This can happen when

* The replication "key" (defined in the RepDef) includes a

column encrypted by an encryption key using an

initialization vector or random pad

* Alternatively, there is no replication key but at least one

column in the table is encrypted by an EK using an IV or

random pad

AND

* An alter table statement has altered an encrypted column --

either a column that appears in the replication key or, if

there is no replication key, in the rest of the table



The problem behind the failure is the use of an initialization

vector or random pad with encryption. The purpose of an IV or random

padding of data is to randomize the ciphertext such that two like values

encrypted by the same key result in two differing ciphertext strings

If the ciphertext for encrypted data at the source and replicate sites

differs then any attempt by Replication Server to match the before-image

from the source site with data at the target site will fail. If no IV and

no random padding is used, the ciphertext at the source and target will match

exactly. The matching is required because Replication Server issues a WHERE

clause on UPDATE/DELETE statements using the ciphertext of encrypted

columns.



The solution is to to use one of the following strategies if replicating DDL.



* For encrypted columns used in a replication key, make sure

that the column's encryption key specifies INIT_VECTOR NULL

and PAD NULL.

* If no replication key is defined, make sure all encrypted

columns in the table are encrypted by keys defined with

INIT_VECTOR NULL and PAD NULL.

* If data has diverged between source and replicate sites

because of previous encryption using initialization vectors

or random padding, manually sync up data to avoid failures of

UPDATE and DELETE statements.



CR:480657
CR Number:   480657
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 04 27 Sep 2007 Fixed
Description
RA DB2 15.0 allows for longer tablenames.



CR:480687
CR Number:   480687
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Solaris
Original Version:   12.6.0.5305P16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.07 17 Oct 2007 Fixed
5.5.04 03 Oct 2007 Fixed
5.6.02 28 Feb 2008 Fixed
Description
Updating a field from NULL to some value with

column_compression=true can replicate the

incorrect value.



CR:480751
CR Number:   480751
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 19 Nov 2007 Fixed
Description
New message, LTM02013, added to display messages from Replication Server.



CR:480800
CR Number:   480800
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 21 Dec 2007 Fixed
Description
UDB ONLY: the replicate column in pdb_setreptable

command output misses the owner name.



CR:480911
CR Number:   480911
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 25 Aug 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
S0C4 ABEND expanding some compressed images.



CR:480933
CR Number:   480933
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 03 26 Sep 2007 Fixed
Description
Bad compare on replicate table caused occasional 0c4 abend
Workaround Description
 Probably putting more rows into LTMOBJECTS would get around this problem. This solution has not been confirmed on non-data sharing



CR:481065
CR Number:   481065
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   5.6.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 28 Jul 2008 Fixed
rauproto 28 Jul 2008 Fixed
Description
For internal use only(new development):

UDB ONLY:RAU Repository Implementation.



CR:481129
CR Number:   481129
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   telemaque
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PD 12.1 EBF#9 and PD 12.5 EBF#2



Customer would like the option in General Options - Consolidate - "Freeze after Consolidation" to be enabled/disabled only by Repository Administrator users, or at installation moment only. The others would not have the ability to enable such option, .



Customer would like the same for the "Merge Models" option.
Workaround Description
 What customer can do by now is creating a Trigger on Repository Database that sets to 1 the Column IsFrozen (Table PMOBJT) everytime Users consolidate a Model, no matter if Freeze After Consolidation is checked or not.



But this is not a supported way to work with PD repository.



CR:481156
CR Number:   481156
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
disk_affinity to limit connection to only use the identified partitions.



CR:481244
CR Number:   481244
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
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
Not all thread states documented
Workaround Description
 See Thread States in White Paper: SYBASE REPLICATION SERVER 12.6 SMP AND RELATED FEATURES



CR:481412
CR Number:   481412
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)
22 Oct 2007 Fixed
Description
If a table has been replicating through dynamic SQL and it's repdef is dropped and recreated, the prepared statements will be de-allocated and prepared with every statement being sent. The object id was not cleared and the benefits of Dynamic SQL will not be seen. The error handling code for Dynamic SQL is improved to report OCS errors when executing prepared statements.



CR:481525
CR Number:   481525
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: Replication Agent does

not check for 'IMPLICIT' when verifying

Oracle supplemental logging.



CR:481531
CR Number:   481531
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
Destination user incorrect when logging DDL command to exceptions log.
Workaround Description
 Look at the verbose listing. The name of the user who applied the command is part of the distribute command:



In the below example, the userid who performed the create table command is annie:



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

A0150 05iso_1distribute 1 ~";Sep 26 2007 3:39:06:190PM,2 ~"!,3 1 begin system



transaction ~"._CREATE_TABLE for ~"&annie-~#"#0x010661d6726c95616125525



246f40f38b8753ef13620de134b4b393d35faaac2 osid 43



begin transaction



CR:481762
CR Number:   481762
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 06 28 Sep 2007 Fixed
Description
Occasional ABEND when replace_null_in_char is used and the last character in a column is null.



CR:481809
CR Number:   481809
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2007 Fixed
23 Jan 2008 Fixed
Description
The Find Objects option shows a bad performance searching an object in the Repository.



CR:481916
CR Number:   481916
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.06 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
Description
ORACLE ONLY: Error initializing change vector

during log record processing sends the

Replication Agent to ADMIN state.



CR:481991
CR Number:   481991
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 05 Dec 2007 Fixed
Description
e,root uses wrong QIDs, causing RA DB2 to shutdown.



CR:482429
CR Number:   482429
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.5.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent may

truncate the accuracy of float/real data.



CR:482430
CR Number:   482430
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)
13 Nov 2007 Fixed
24 Jul 2008 Fixed
Description
The Replication Server can terminate

unexpectedly when a 'drop subscription'

command is issued with the 'with purge'

clause. This is caused by the mis-use

of the synchronization element used to

govern DSI threads.



CR:482438
CR Number:   482438
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.6.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
Description
Microsoft SQLSERVER ONLY: If a table containing

persisted computed columns is marked, RepAgent

will not send the values of these columns to

RepServer.



CR:482528
CR Number:   482528
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
async I/O request completed with error and RS stacked.
Workaround Description
 Start back up the RS. In this case, nothing was done after the crash and before startup. RS started up and ran past this problem.



CR:482532
CR Number:   482532
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)
24 Jan 2008 Not a Bug
Description
Incorrect syntax near 'where' after creating repdef for a table in warm-standby



CR:482992
CR Number:   482992
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
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
The use of the word "function" is ambiguous in the create database replication definition and alter database replication definition commands.



CR:482994
CR Number:   482994
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2008 Added to user documentation
Description
Another reason to use table subscriptions is to apply autocorrection to a table.



CR:483056
CR Number:   483056
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   5.5.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.07 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
Description
ORACLE ONLY: A mini rollback of the first

operation in a transaction causes Replication

Server to fail with error number 9022.
Workaround Description
 If the whole transaction is rollbacked, just zap the mini-rollback message (message "rollback to 0x...")



If the rest of the transaction is committed, there is no WA.

=> just zap the "begin transaction" and re-apply the transaction.



CR:483099
CR Number:   483099
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)
07 Dec 2007 Fixed
07 Dec 2007 Fixed
20 Feb 2008 Fixed
20 Feb 2008 Fixed
Description
The "admin stats" command running as a background process may hang and cannot be cancelled.



CR:483102
CR Number:   483102
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)
21 Dec 2007 Fixed
04 Jan 2008 Fixed
Description
The "admin stats" command can produce skewed data, for instance, the command "admin stats, "all", save, 60, "00:05:00" is supposed to generate M&C counters at 60 seconds intervals. But when rep server is loaded and busy, the results will be skewed and unreliable.



CR:483344
CR Number:   483344
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5504P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.07 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
5.5.07 01 Feb 2008 Fixed
Description
ORACLE ONLY: A truncate command against a table

whose owner is listed in the Replication Agent's

owner filter list causes the Replication Agent

to fail with a TransactionException: Article not

found.



CR:483479
CR Number:   483479
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.0.0.5504P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: A change to an Oracle system table

may cause Replication Agent to go to ADMIN

state with a TransactionException similar to:

Could not concatenate chained operation

<OP:[0x05010b10 CHGMD...(0033)}> because

it is not related to the unprocessed

split operation

<[com.sybase.ds.oracle.log.op.ChainedUpdateImage

@1d1ed471]>.



CR:483556
CR Number:   483556
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Integrating a version into another version does not increase document version if you previously created a baseline version in the branch.

More, the 'Update' consolidation mode is not available anymore.



CR:483584
CR Number:   483584
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.11 19 12 Dec 2007 Fixed
15.0 ESD#2 01 04 Dec 2007 Fixed
Description
STATUS command is displaying incorrect information for some log files.



CR:483641
CR Number:   483641
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
RS should be more backend aware. RS should send correct statement to the TARGET for the parameter that are configurable on the DSI.



CR:483722
CR Number:   483722
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If two users change the same property of an object, the 'Consolidate Model' dialog box only allows to apply the changes or to cancel the update.

Cust would like to be able to edit and change the value, not only to compare property values.



CR:483741
CR Number:   483741
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
Java Column Replication under MSA fails with Msg 206 "Operand type clash: VARCHAR is incompatible with Address" unless table-level repdef provided.
Workaround Description
 Create a table-level repdef for each table containing a Java column.



CR:483745
CR Number:   483745
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 03 Jul 2008 Fixed
5.7.00 03 Jul 2008 Fixed
5.7.00 28 Jul 2008 Fixed
Description
ORACLE ONLY: The system log references a database

name of <<not_configured>> when the Replication

Agent is configured to use a tns connection name.



CR:483756
CR Number:   483756
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 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
UDB ONLY: Replication of a long vargraphic column

from UDB to ASE, using Replication Server 15.0 or

later fails with the following error message in

the log: "The value given for <column> cannot be

translated from datatype 'text' to the required

datatype 'unitext'".



CR:483820
CR Number:   483820
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.0.5504P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: LOB data inserted by

Delphi ADO Control with a length greater

than 4K bytes is not replicated.



CR:483850
CR Number:   483850
Product Name:   Replication Server
Product Component:   RepServer Install
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2008 Fixed
31 Oct 2007 Fixed
Description
Replication Server installer may hang on some machines due to missing InstallShield patches.



CR:483905
CR Number:   483905
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Specifying a maintenance user who has been aliased, will stop rs_init from successfully creating the connection
Workaround Description
 First find the user and who it is aliased to:



1> sp_helpuser dbo

2> go

Users_name ID_in_db Group_name Login_name

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

dbo 1 public sa

Users aliased to user.

Login_name

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

mono1251urep_maint

(return status = 0)



Drop the user from the alias:



1> sp_dropalias mono1251urep_maint

2> go

Alias user dropped.

(return status = 0)



Retry rs_init work



CR:483977
CR Number:   483977
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5504P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: The Replication Agent fails with an

error similar to "LTI unable to process

unsupported operation: <-1(UNDEFINED)>".



CR:484044
CR Number:   484044
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2007 Fixed
Description
Inconsistent versioning when consolidate with reports.

Ongoing consolidation after having merged reports into repository. Hitting "Cancel" inside the merge dialog increments the version for model root, package root



CR:484148
CR Number:   484148
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2007 Fixed
11 Dec 2007 Fixed
Description
Closely related to CR 484044, but work with closed models instead of open models and generates a wrong message "This repository model will be frozen automatically before consolidation as it needs to be upgraded from version 12.0.2199 to current version"



CR:484210
CR Number:   484210
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)
11 Jan 2008 Fixed
11 Jan 2008 Fixed
11 Jan 2008 Fixed
Description
RS has a severe memory leak when replicating a

column having the type 'varchar(15000)'.
Workaround Description
 In both cases, sysadmin sqm_zap_command the command with the varchar(15000) value.



CR:484491
CR Number:   484491
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Command that can be issued on RRS to prevent PRS to connect to it.
Workaround Description
 Not a viable workaround, however these options would work:



a. Change the rsi password on the RRS, temporarily

b. Have an isql session that would log into the RRS of the route.



CR:484593
CR Number:   484593
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2007 Fixed
09 Nov 2007 Fixed
13 Nov 2007 Fixed
Description
New counters added to provide amount of time

spent in RSI and Repagent User Threads as

scheduled by OCS.



CR:484669
CR Number:   484669
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2007 Fixed
Description
When searching in the repository, search criterias are ignored in "advanced" tab. All models are retourned, without critearia selection.



CR:484690
CR Number:   484690
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.08 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
Description
ORACLE ONLY: Error "Invalid rollback metadata

locator encountered" is seen for an update to a

LOB column that is stored off-row.



CR:484796
CR Number:   484796
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)
14 Jan 2009 Fixed
16 Jan 2009 Fixed
14 Jan 2009 Fixed
16 Jan 2009 Fixed
Description
Improve the error messages that RS generates

when RS processes incorrect LTL such that the

offending LTL command is displayed.
Workaround Description
 Because this error is transient, there is no way to capture the problem after the problem is reported.



CR:484809
CR Number:   484809
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 10 Aug 2009 Not a Bug
Description



CR:484885
CR Number:   484885
Product Name:   Real Time Data Services - RepConnector
Product Component:   RepConnector Base Product
Status:   Open
OS:   Linux - RHES 2.1
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request capablity to populate, via paramater ie, without recourse to coding a custom message formatter, the "environment" property of the <dbStream> element with the source connection name.



CR:484893
CR Number:   484893
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5504P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.08 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
Description
ORACLE ONLY: The primary key columns identified

in a Replication Definition created by the

Replication Agent may be incorrect if the column

is defined in more than one constraint.
Workaround Description
 alter the repdef to add any missing primary key



The problem is only for tables whose primary key is also a foriegn key.



Customers may determine which tables support both primary and foreign keys with the following query:

select obj# from sys.cdef$ where type#=2 and obj# in (select obj# from sys.cdef$ where type# = 4);





For those objects returned, customers may then query each object to see if a column is used as both 'P'rimary and 'R'eferential (foreign) key.



select DBA_CONS_COLUMNS.OWNER,

DBA_CONS_COLUMNS.COLUMN_NAME ,

DBA_CONSTRAINTS.CONSTRAINT_TYPE,

SYSCDEF.OBJ#

from DBA_CONS_COLUMNS, DBA_CONSTRAINTS, SYS.CON$ SYSCONST, SYS.CDEF$ SYSCDEF

where DBA_CONS_COLUMNS.OWNER=DBA_CONSTRAINTS.OWNER

and DBA_CONS_COLUMNS.TABLE_NAME=DBA_CONSTRAINTS.TABLE_NAME

and DBA_CONS_COLUMNS.CONSTRAINT_NAME=DBA_CONSTRAINTS.CONSTRAINT_NAME

and SYSCONST.NAME=DBA_CONS_COLUMNS.CONSTRAINT_NAME

and SYSCONST.CON#=SYSCDEF.CON#

and SYSCDEF.OBJ#=9657

ORDER BY DBA_CONS_COLUMNS.COLUMN_NAME;





For those tables that contain columns that act as both primary and foreign key, customers should query the Rep Server RSSD, using command rs_helprep, to verify primary keys defined in replication definiitons match the table. Thos that do not match may have their primary keys changed using the Replication Server "alter repdef" command.



CR:484998
CR Number:   484998
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Better diagnostic message when SQL Server message: msg 203, level 16, state 2 "The name '' is not a valid identifie
Workaround Description
 Use a resource file, make sure use the proper entry for the sa password for the RSSD It is rs.rs_rssd_sa_pass



CR:485165
CR Number:   485165
Product Name:   Real Time Data Services - RepConnector
Product Component:   RepConnector Base Product
Status:   Open
OS:   Linux - RHES 2.1
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently, after an MQ queue-full condition has been raised causing the reconnector to disconnect, manual intervention to restart the connection must be performed after the queue-full condition has been resolved. We'd like to see repconnector automatically restart the connection when it somehow determines that the queue-full condition has been resolved.
Workaround Description
 There are 2 methods:

1) login out and then login to ASE.

2) disable rtds and then enable it again. This method is only valid for jms.



CR:485246
CR Number:   485246
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias EBF4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2008 Fixed
Description
On the repository for CR#464366, on database server sql server 2000 on VMJULIETTE, I did a search on all objects from folder "Z3 - Model Samples"

This stops before end and increase log of more than 6Go, this is huge compared to the database size (8OOMo)



CR:485353
CR Number:   485353
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
consolidating a model containing a replication in update mode, adding another object / replication, the replication breaks in a way that the Source Object is shown as "unknown".



CR:485385
CR Number:   485385
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2008 Fixed
15.1 13 May 2008 Fixed
15 May 2008 Fixed
24 Jan 2008 Fixed
25 Feb 2008 Fixed
15 Mar 2008 Fixed
15.1 02 Apr 2008 Fixed
26 Jun 2008 Fixed
15.1 ESD #1 26 Jun 2008 Fixed
22 Dec 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Enhance the 'rs_ticket' feature to use

the new Version 2 format.



CR:485673
CR Number:   485673
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
ORACLE ONLY: LOB data with a length greater than

4K bytes is not replicated a second time.



CR:485706
CR Number:   485706
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2008 Fixed
31 Jan 2008 Fixed
Description
If you create a repository using the MS SQL Server native driver, the repository is not created in the database specified in the connection profile.

Instead, the repository is created in the default database associated with the user/login. However, when you view the connection information in PD, the displayed information shows that PD is connected to the database listed in the connection profile.



CR:485722
CR Number:   485722
Product Name:   RepConnector
Product Component:   Misc.
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2012 Duplicate
Description
include date in timestamp in repra.log.



CR:485773
CR Number:   485773
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   5.6.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.02 04 Mar 2008 Fixed
5.5.08 01 Feb 2008 Fixed
Description
WINDOWS ONLY: Double byte CLOB data is not

replicated correctly.
Workaround Description
 If do not set pdb_auto_create_repdefs to be false before ra_init, everything will be OK.



CR:486102
CR Number:   486102
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5507P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.08 01 Feb 2008 Fixed
06 May 2008 Bundled Request
Description
ORACLE ONLY: Replication Agent fails with a

ClassCastException during LOB processing.



CR:486109
CR Number:   486109
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5507P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.08 01 Feb 2008 Fixed
5.6.02 04 Mar 2008 Fixed
Description
ORACLE ONLY: The Replication Agent fails with an

error similar to "OracleArticleException: The

position [12] is out of bound for the article.

The right range of the field position is

[1 - 11]".



CR:486297
CR Number:   486297
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)
20 Aug 2009 Not a Bug
Description
Heterogeneous Data Source names not visible in Rep Manager Plug-in's Exception Queue filter combo box pulldown list
Workaround Description
 This dialog acts as a filter for the exceptions to be displayed. Any server name may be entered in the Origin Data Server combobox to have it's exceptions listed. Or, the box can be left blank (no filter) to bring back exceptions of all servers.



CR:486337
CR Number:   486337
Product Name:   RepConnector
Product Component:   Documentation
Status:   Open
OS:   Generic
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
DEFER
Description
Document logging properties for RepConnector.





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

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