提供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:531157
CR Number:   531157
Product Name:   Rep Serv Install Guide
Product Component:   Rep Serv Install Guide
Status:   Open
OS:   NA
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2008 Fixed
Description
The 64-bit version of Redhat Enterprise Linux 5.0 is known to *not* ship

with the Linux 'libXp' package by default. If the Linux 'libXp' package

is missing, the RS 1510 GA and RMP 1510 GA 'setup' installation command

will fail and the following generic message is generated ...



The installer is unable to run in graphical mode. Try running

the installer with the -console or -silent flag.



If the 'setup' installation command is invoked with the following

parameters ...



setup -is:javaconsole -log '#' @ALL



... this additional message is generated ...



Install.product.install,

com.installshield.wizard.StandardWizardListener,

dbg,

java.lang.UnsatisfiedLinkError:

/mnt/cdrom/JVM/bin/libawt.so:

libXp.so.6:

cannot open shared object file:

No such file or directory



To resolve this issue, install the Linux 'libXp' package. This can be

done on Redhat Enterprise Linux with the following command ...



yum install libXp



CR:531261
CR Number:   531261
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 30 Jun 2008 Fixed
5.6.07 30 Jun 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY:

ra_maintid command throws NullPointerException

after Replication Agent is initialized.



CR:531373
CR Number:   531373
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.12 07 10 Aug 2009 Fixed
Description
RA DB2 will not replicate all tables when use_repdef= Y
Workaround Description
 Use_repdefs = Y



CR:531385
CR Number:   531385
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 01 Jul 2008 Fixed
5.6.07 01 Jul 2008 Fixed
Description
ASE ONLY:

pdb_get_tables and pdb_get_procedures

can not recognize table/procedure

with long names having '_' and '%'.

The length of table/procedure name

cannot exceed 255.



CR:531399
CR Number:   531399
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5514P7b-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.15 10 Jun 2008 Fixed
5.6.07 01 Jul 2008 Fixed
5.7.00 01 Jul 2008 Fixed
Description
ORACLE ONLY: Replication Agent fails to

correctly calculate the rollback point for a

"rollback to save point" operation. The failure

to rollback some operations causes an eventual

'duplicate key' violation at the replicate

database.



CR:531426
CR Number:   531426
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin Installer
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 Presently Not Targeted For Any Future Release Of This Product
Description
In environments that include RMP 15.1 and ASEP 15.0.2, uninstalling the RMP 15.1 may cause the jconn3.jar file to be removed. This causes the ASEP to not function correctly.
Workaround Description
 6/20/2008 egarrett:



Jiang Li is correct... I reproduced the problem with ASE 15.0.2 ESD#4 and RMP 15.1. When doing unit testing I used ASE 15.0.2 GA and RMP 15.1 and the jconn3.jar is not removed. There seems to be some problem with uninstall when ASE ESDs and RMP 15.1 are installed.



A workaround might be prior to uninstallation, go to $SYBASE/shared/lib and copy jconn3.jar to jconn3.jar.sav. Then do uninstall of RMP. After uninstall of RMP, go to $SYBASE/shared/lib and copy jconn3.jar.sav back to jconn3.jar.



CR:531606
CR Number:   531606
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin Installer
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The uninstall process may not remove uninstall_RMP.bin when RMP is installed in a multiple Sybase product environment. Running the uninstall_RMP.bin again will produce no results.



CR:531960
CR Number:   531960
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.16 11 Jun 2008 Fixed
5.6.06 11 Jun 2008 Fixed
5.7.00 03 Jul 2008 Fixed
Description
Replication definitions are created with invalid

replicate owner when the replication definition

is created automatically and when it is created

for replicating Oracle to ASE.



A new property "rs_replicate_owner_required"

allows Replication Agent to always supply the

owner in the replicate table name when the

replication definition is generated.



rs_replicate_owner_required



Description:

Determines if the owner should always be supplied

in the replicate table name when the Replication

Agent generates replication definitions, so that

Replication Server can distinguish between

replicate tables of the same name with different

schema/owner, and different schema/owner than the

replicate maintenance user applying the command.



Default:

true



Values:

true The owner will always be included in the

replicate table name of generated replication

definitions.



false The owner will only be included in the

replicate table name of generated replication

definitions if the primary name is also owner

qualified.



Comments:

- When the rs_replicate_owner_required is set

to true, generated replication definitions will

always be created with the replicate owner

and table name in the "with replicate table

named" clause.



Example:

create replication definition ra$0xca61_MyTable

with primary at rao.ora10g

with primary table named 'MyTable'

with replicate table named 'MyOwner'.'MyTable'

(

"QUANTITY" rs_oracle_decimal,

"ORDER_NUMBER" varchar(200)

)

primary key( "QUANTITY","ORDER_NUMBER" )

searchable columns( "QUANTITY","ORDER_NUMBER" )

send standby all columns

replicate minimal columns



- When the rs_replicate_owner_required is set

to false, generated replication definitions will

be created with the replicate owner

and table name in the "with replicate table

named" clause only if the primary table is

owner qualified.



Example:

create replication definition ra$0xca61_MyTable

with primary at rao.ora10g

with primary table named 'MyTable'

with replicate table named 'MyTable'

(

"QUANTITY" rs_oracle_decimal,

"ORDER_NUMBER" varchar(200)

)

primary key( "QUANTITY","ORDER_NUMBER" )

searchable columns( "QUANTITY","ORDER_NUMBER" )

send standby all columns

replicate minimal columns



CR:531968
CR Number:   531968
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 28 Jul 2008 Fixed
5.6.07 04 Aug 2008 Fixed
5.7.00 05 Aug 2008 Fixed
Description
ORACLE ONLY: Replication Agent goes to ADMIN

state with error "Error processing

record with supplemental data whose column index

duplicates other data columns."



CR:531977
CR Number:   531977
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2008 Not a Bug
Description
RAO: Chained Op error: Invalid state error: Op is not part of current chained op



CR:532114
CR Number:   532114
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 01 Jul 2008 Fixed
5.6.07 01 Jul 2008 Fixed
Description
Error messages threw by ma_admin.bat

did not reflect the correct product

catagory 'Mirror Replication Agent'

but always refer to 'Replication Agent'



CR:532153
CR Number:   532153
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 18 Jun 2008 Fixed
5.6.07 18 Jun 2008 Fixed
5.7.00 18 Jun 2008 Fixed
Description
ORACLE ONLY: Replication fails to start against

Oracle 9i because the Replication Agent does not

correctly recognize the desired archive redo log.

The error is similar to "An Archive file was not

found. Reason: Archive log file for LSN <xxx> is

not found. File <archiveLog>.



CR:532157
CR Number:   532157
Product Name:   Replication Agent
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2008 Fixed
Description
Sybase Replication Agent 15.1 is a completely

new version. As a result, there are no fixed

bugs to list in this section.



CR:532297
CR Number:   532297
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Solaris
Original Version:   15.0.0.5514P7b-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.16 11 Jun 2008 Fixed
5.5.16 01 Jul 2008 Fixed
5.6.06 13 Jun 2008 Fixed
22 Sep 2008 Fixed
Description
ORACLE ONLY: An operation that was rolled back at

the primary database can be inappropriately

replicated when a rollback occurs in the middle

of several concurrent transactions.



CR:532509
CR Number:   532509
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2008 Fixed
15 Oct 2008 Fixed
17 Feb 2009 Fixed
Description
ORACLE ONLY: Translation error occurs on

rs_oracle_datetime when a year value exceeds 4712.
Workaround Description
 The maximum boundary needs to be changed from

'01/01/4712 00:00:00', /* max_boundary */

to

'01/01/9999 00:00:00', /* max_boundary */



CR:532510
CR Number:   532510
Product Name:   Replication HDS
Product Component:   UDD scripts
Status:   Closed
OS:   Generic
Original Version:   RS 15.0.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
RS 15.0.1 ESD #4 03 Sep 2008 Fixed
RS 15.1 ESD #1 06 Oct 2008 Fixed
RS 15.2 23 Feb 2009 Fixed
Description
The Replication Server incorrectly fails to

convert an Oracle date value when the year

portion of the date value is larger than 4712.



CR:532570
CR Number:   532570
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin Installer
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The installer for Replication Manager 15.1 does not display a warning when installing into an existing directory unless there is an existing Replication Manager installation.



Also, the installer for Replication Manager 15.1 does not display a confirmation message to create a new directory if the target installation directory does not exist.



CR:532629
CR Number:   532629
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
New Feature Request ... secure (encrypt) all data RepServer maintains on disks(stable device and logs)



CR:532659
CR Number:   532659
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 19 Jun 2008 Fixed
5.6.07 19 Jun 2008 Fixed
5.5.17 19 Jun 2008 Fixed
5.3.08 19 Jun 2008 Fixed
Description
ORACLE ONLY: Re-initializing Replication Agent

with force option causes three Replication Agent

internal tables to be marked for replication and

associated replication definitions are created.

Unexpected replication definitions for rs_marker

and rs_dump are also created when

'rs_create_repdef all' command is issued.



CR:532815
CR Number:   532815
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2008 Fixed
01 Jul 2008 Fixed
03 Jan 2009 Not a Bug
Description
A route cannot be created from a primary

RS using RS 15.0 or higher to a

replicate RS using RS 12.6 or earlier.

This can occur when the primary RS is

upgraded from RS 12.6 or earlier to RS

15.0 or later and the site version for

the primary RS is set to 1500.
Workaround Description
 Create routes BEFORE setting site_version to 1500, then upgrade them.

Upgrade all RSs to 15.x.



11/13/2008 (and also updated on 12.8.2008)



The problem was seen in 15.0.1 ESD #3. There are three scripts that have been published. RS 15.0.1 ESD #4 will contain the fixed rsupgr_ase.sql and rsupgr_asa.sql scripts. However, if the customer has already migrated, they will need to patch their RSSD. As of this writing, we don't know what the distribution of that patch will be. Here is the patch in case anyone needs it (this is if you have already migrated and now are trying to create the route):



12/8/2008 - Confirmation from RS Eng that this script can be used on RS 15.1 also. RS 15.1 ESD #1 has the fixed scripts. The following is the script if you need to patch your RS and you are not at a RS that has the fixed scripts:







begin

if not exists (select * from rs_columns

where objid = 0x0000000000000058 and colname = 'minvers')

begin

insert into rs_columns values(0, 0x0000000000000058, 'minvers',11, 8, col_length('rs_funcstrings','minvers'), 0, 0, 0, 0, 0, 11, 'minvers', 0x0000000000000008, 0x0000000000000008, 8, col_length('rs_funcstrings','minvers'))

end

end

go



if exists (select name

from sysobjects

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

begin

drop procedure rs_materialize

end

go



create proc rs_materialize @subscription_name varchar(30), @version int

as

declare @mySiteID int

declare @msg varchar(255)



select @mySiteID = id

from rs_sites

where name=(select charvalue

from rs_config

where optionname='oserver')



if (@version < 1010)

begin

/* 20010, "Creating a route from a pre-10.1 PRS is not supported" */

exec rs_get_msg 20010, @msg output

print @msg

return -1

end



if (@subscription_name like "rs_objects%")

begin

/*

** Change history for rs_objects:

** 11.0 added 'deliver_as_name' column

** Ulysses added 'phys_objowner', 'repl_objowner' and

** 'has_baserepdef columns' columns,

** changed 'attributes' to type int

** Nellie added column 'minvers'

*/

if (@version < 1100)

begin

select prsid,objname,objid,dbid,objtype,

attributes=convert(tinyint,attributes & 255),

ownertype,crdate,parentid,ownerid,rowtype,

phys_tablename

from rs_objects

where rowtype=1 and prsid=@mySiteID

and (ownertype != 'U'

or objtype != 'R'

or minvers < 1150)

end

/* 1150 == Ulysses threshold */

else if (@version < 1150)

begin

select prsid,objname,objid,dbid,objtype,

attributes=convert(tinyint,attributes & 255),

ownertype,crdate,parentid,ownerid,rowtype,

phys_tablename,

deliver_as_name

from rs_objects

where rowtype=1 and prsid=@mySiteID

and (ownertype != 'U'

or objtype != 'R'

or minvers < 1150)

end

else if (@version < 1200) /* Ulysses */

begin

select prsid,objname,objid,dbid,objtype,

attributes,

ownertype,crdate,parentid,ownerid,rowtype,

phys_tablename,

deliver_as_name,

phys_objowner,repl_objowner,has_baserepdef

from rs_objects

where rowtype=1 and prsid=@mySiteID

and (ownertype != 'U'

or objtype != 'R'

or minvers < 1200)

end

else

/* Nellie and later (incl. maint releases) */

begin

select prsid,objname,objid,dbid,objtype,

attributes,

ownertype,crdate,parentid,ownerid,rowtype,

phys_tablename,

deliver_as_name,

phys_objowner,repl_objowner,has_baserepdef,

minvers

from rs_objects

where rowtype=1 and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_columns%")

begin

/*

** Change history for rs_columns:

** Since this table is linked to rs_objects, we need a join

** with a "where" clause to match the rules coded above.

**

** Ulysses added 'basecolnum' and 'repl_colname'

*/

/* 1150 == Ulysses threshold */

if (@version < 1150)

begin

select c.prsid,c.objid,colname,colnum,coltype,length,searchable,

primary_col,fragmentation,c.rowtype,status

from rs_columns c, rs_objects o

where c.rowtype=1 and c.prsid=@mySiteID and

c.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1150)

end

else if (@version < 1200) /* Ulysses */

begin

select c.prsid,c.objid,colname,colnum,coltype,length,searchable,

primary_col,fragmentation,c.rowtype,status,

basecolnum, repl_colname

from rs_columns c, rs_objects o

where c.rowtype=1 and c.prsid=@mySiteID and

c.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1200)

end

else

/* Nellie and later (incl. maint releases) */

begin

select prsid,objid,colname,colnum,coltype,length,searchable,

primary_col, fragmentation,rowtype,status,

basecolnum,repl_colname,declared_dtid,publ_dtid,publ_base_coltype,publ_length

from rs_columns

where rowtype=1 and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_classes%")

begin

/*

** Change history for rs_classes

** Ulysses added 'attributes' and 'parent_classid' columns

*/

if (@version < 1150)

begin

select classname,classid,classtype,prsid

from rs_classes

where parent_classid=0 and prsid=@mySiteID

end

else

/* Ulysses and later (incl. maint releases) */

begin

select classname,classid,classtype,prsid,

attributes,parent_classid

from rs_classes

where prsid=@mySiteID

end

end

else if (@subscription_name like "rs_functions%")

begin

/*

** Change history for rs_functions:

** Ulysses filter out user functions of projections not marked

** for use by pre-Ulysses sites.

*/

if (@version < 1150)

begin

select prsid,funcname,funcid,objid,conflicting,userdefined,

rowtype

from rs_functions

where rowtype=1 and prsid=@mySiteID and

objid not in (select objid from rs_objects

where ownertype = 'U'

and objtype = 'R'

and minvers >= 1150)

end

else if (@version < 1200)

begin

select prsid,funcname,funcid,objid,conflicting,userdefined,

rowtype

from rs_functions

where rowtype=1 and prsid=@mySiteID and

objid not in (select objid from rs_objects

where ownertype = 'U'

and objtype = 'R'

and minvers >= 1200)

end

else

begin

select prsid,funcname,funcid,objid,conflicting,userdefined,

rowtype

from rs_functions

where rowtype=1 and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_funcstrings%")

begin

/*

** Change history for rs_funcstrings:

** No changes (since 10.1). However, this table is linked with

** rs_classes and rs_functions, above.

*/

if (@version < 1150)

begin

select f.prsid,f.classid,funcid,name,fstringid,f.attributes,

parameters,param_hash,expiredate,rowtype

from rs_funcstrings f, rs_classes c

where rowtype=1 and f.prsid=@mySiteID and

f.classid=c.classid and parent_classid=0

and f.funcid in

(select funcid from rs_functions

where objid = 0)

union

select fs.prsid,classid,fs.funcid,name,fstringid,fs.attributes,

parameters,param_hash,expiredate,fs.rowtype

from rs_funcstrings fs, rs_functions f, rs_objects o

where fs.rowtype=1 and fs.prsid=@mySiteID and

fs.funcid=f.funcid and f.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1150)

end

else if (@version < 1200)

/* Ulysses */

begin

select f.prsid,f.classid,funcid,name,fstringid,f.attributes,

parameters,param_hash,expiredate,rowtype

from rs_funcstrings f, rs_classes c

where rowtype=1 and f.prsid=@mySiteID and

f.classid=c.classid and parent_classid=0

and f.funcid in

(select funcid from rs_functions

where objid = 0)

union

select fs.prsid,classid,fs.funcid,name,fstringid,fs.attributes,

parameters,param_hash,expiredate,fs.rowtype

from rs_funcstrings fs, rs_functions f, rs_objects o

where fs.rowtype=1 and fs.prsid=@mySiteID and

fs.funcid=f.funcid and f.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1200)

end

else

/* Nellie and later (incl. maint releases) */

begin

select prsid,classid,funcid,name,fstringid,attributes,

parameters,param_hash,expiredate,rowtype

from rs_funcstrings

where rowtype=1 and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_routes%")

begin

/*

** Change history for rs_routes:

** No changes (since 10.1)

*/

select dest_rsid,through_rsid,source_rsid,status,suspended,src_version

from rs_routes

where source_rsid=@mySiteID

end

else if (@subscription_name like "rs_databases%")

begin

/*

** Change history for rs_databases:

** 11.0 added 'ltype', 'ptype', 'ldbid', 'enable_seq' columns

*/

if (@version < 1100)

begin

select dsname,dbname,dbid,dist_status,src_status,attributes,

errorclassid,funcclassid,prsid,rowtype,sorto_status

from rs_databases

where rowtype=1 and prsid=@mySiteID

end

else

begin

select dsname,dbname,dbid,dist_status,src_status,attributes,

errorclassid,funcclassid,prsid,rowtype,sorto_status,ltype,

ptype,ldbid,enable_seq

from rs_databases

where rowtype=1 and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_systext7%")

begin

/*

** Change history for rs_systext:

** No changes (since 10.1). However, this table is linked with

** rs_funcstrings, above.

*/

if (@version < 1150)

begin

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings f, rs_classes c

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

f.classid=c.classid and parent_classid=0

and f.funcid in

(select funcid from rs_functions

where objid = 0)

union

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings fs,

rs_functions f, rs_objects o

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

fs.funcid=f.funcid and f.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1150)

end

else if (@version < 1200)

begin

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings f, rs_classes c

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

f.classid=c.classid and parent_classid=0

and f.funcid in

(select funcid from rs_functions

where objid = 0)

union

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings fs,

rs_functions f, rs_objects o

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

fs.funcid=f.funcid and f.objid=o.objid

and (o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1200)

end

else

/* Ulysses and later (incl. maint releases) */

begin

select prsid,parentid,texttype,sequence,textval

from rs_systext

where texttype='O' and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_systext8%")

begin

/*

** Change history for rs_systext:

** No changes (since 10.1). However, this table is linked with

** rs_funcstrings, above.

*/

if (@version < 1150)

begin

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings f, rs_classes c

where texttype='S' and s.prsid=@mySiteID and

s.parentid=fstringid and

f.classid=c.classid and parent_classid=0

union

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings fs,

rs_functions f, rs_objects o

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

fs.funcid=f.funcid and f.objid=o.objid and

(o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1150)

end

else if (@version < 1200)

/* Ulysses */

begin

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings f, rs_classes c

where texttype='S' and s.prsid=@mySiteID and

s.parentid=fstringid and

f.classid=c.classid and parent_classid=0

union

select s.prsid,s.parentid,texttype,sequence,textval

from rs_systext s, rs_funcstrings fs,

rs_functions f, rs_objects o

where texttype='O' and s.prsid=@mySiteID and

s.parentid=fstringid and

fs.funcid=f.funcid and f.objid=o.objid and

(o.ownertype != 'U'

or o.objtype != 'R'

or o.minvers < 1200)

end

else

/* Nellie and later (incl. maint releases) */

begin

select prsid,parentid,texttype,sequence,textval

from rs_systext

where texttype='S' and prsid=@mySiteID

end

end

else if (@subscription_name like "rs_erroractions%")

begin

/*

** Change history for rs_erroractions:

** No changes (since 10.1)

*/

select ds_errorid,errorclassid,action,prsid

from rs_erroractions

where prsid=@mySiteID

end

else if (@subscription_name like "rs_dbreps%")

begin

/*

** Change history for rs_dbreps:

** No changes in column list (since 12.6)

*/

select dbrepid, dbrepname, prsid, dbid, ownerid, requestdate,

status, minvers

from rs_dbreps

where prsid=@mySiteID

end

else if (@subscription_name like "rs_dbsubsets%")

begin

/*

** Change history for rs_dbsubsets:

** No changes in column list (since 12.6)

*/

select dbrepid, type, owner, name, prsid

from rs_dbsubsets

where prsid=@mySiteID

end

else

return 1

go



grant execute on rs_materialize to rs_systabgroup

go



CR:532854
CR Number:   532854
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 05 05 Aug 2009 Fixed
Description
Input line on the JCL(RECEIVE) is incorrect
Workaround Description
 Modify the JCL as follows:



//RECV EXEC PGM=IKJEFT01,DYNAMNBR=20

//SYSTSPRT DD SYSOUT=*

//SYSTSIN DD *

RECEIVE INDATASET('TECH.DB2.V15002A.ESD2.RA150.XMIT.LINKLIB')

DATASET('TECH.DB2.V15002A.ESD2.RA150.LINKLIB') +

UNIT(SYSDA) VOLUME(TSO003)

RECEIVE INDATASET('TECH.DB2.V15002A.ESD2.RA150.XMIT.DBRM')

DATASET('TECH.DB2.V15002A.ESD2.RA150.DBRM') +

UNIT(SYSDA) VOLUME(TSO003)

RECEIVE INDATASET('TECH.DB2.V15002A.ESD2.RA150.XMIT.LTMLOC')

DATASET('TECH.DB2.V15002A.ESD2.RA150.LTMLOC') +

UNIT(SYSDA) VOLUME(TSO003)

/*

//



Note that there is only one + in the command line, not two as the distributed JCL.



CR:532856
CR Number:   532856
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
admin config command displays configuration parameter send_timestamp_to_standby to be "on" by default. This is incorrect. The default value of this parameter is "off".



CR:532965
CR Number:   532965
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin Installer
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Due to inconsistencies with InstallShield, the uninstall process may not remove the same files on different platforms.



CR:532994
CR Number:   532994
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2008 Fixed
Description
Repository proxy crashes after reaching a connection user limit (approx 10 users).



the debug-log file shows following just before the proxy crashes

2008-06-03.15:24:30.000719 warning - SClient::OnAccept: too many clients



CR:533063
CR Number:   533063
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.1.0.5602
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.06 13 Jun 2008 Fixed
5.7.00 01 Jul 2008 Fixed
5.5.17 01 Jul 2008 Fixed
Description
ORACLE ONLY: Replication Agent fails to process

a DDL command that recompiles a procedure. The

error is similar to "Failed to handle the DDL

operations because there is no object

information in the LogRecord."



CR:533069
CR Number:   533069
Product Name:   Rep Serv Online Help
Product Component:   rmp
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2008 Fixed
Description
The Online-help section labeled "Preparing to manage a replication environment" should include the item: "$SYBASE/RMP-15_x/lib/callback.jar" in the list of items to manually enter when using an external class loader.



CR:533092
CR Number:   533092
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.1.0.5602
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 08 Jul 2008 Fixed
5.7.00 08 Jul 2008 Fixed
Description
ORACLE ONLY: Operations in the pdb_skip_op list

are not skipped because the pdb_skip_op command

interface does not take into account Oracle

SUBSCN field values.





Description



This command is available only for Oracle and

Microsoft SQL Server.



Returns, adds, or removes record identifiers from

a list of records to skip in processing. The

format of the identifier is database-specific.



To support RAC, log location and truncation is

done by System Change Number (SCN) instead of

Record Address (RBA). The skip operations feature

must be familiar with SCNs and thread numbers to

truncate the skip operations list and to skip the

correct operation across multiple threads.



Syntax



pdb_skip_op [ add , identifier ]

pdb_skip_op [ remove, { identifier | all } ]



Parameters



add



Adds a specified ID to the list of

identifiers of records to skip.



remove



Removes a specified ID from the list of

identifiers to skip.



identifier



Identifies the log record to skip. The syntax

allows for either an operation locator or a

database-specific identifier.



all



Allows you to remove all IDs in the

list of identifiers to skip.



Examples



Example 1



pdb_skip_op



This command with no parameters returns a list of

the identifiers for the records you want to skip.



Example 2



pdb_skip_op add, id



This command adds an ID to the list of identifiers

you want to skip.



Example 3



pdb_skip_op remove, id



To remove an ID to the list of identifiers you

want to skip.



Example 4



pdb_skip_op remove, all



This command removes all the IDs from the list of

identifiers you want to skip.



Usage



- The pdb_skip_op command allows you to skip

problem records, thereby avoid having to

re-initialize the Replication Agent.

- Skipped records are written to the system log

as a warning message.

- The pdb_skip_op command is valid when the

Replication Agent is in Admin state.

- The format of the generic identifier

is the 64 character LTM locator representing the

operation to skip.

- The format of the database-specific identifier:



- For Microsoft SQL Server, the identifier is

Log Sequence Number (LSN) and it has the

following form:



virtualfileseqno:pageid:operationsseqno



where:

- virtualfileseqno is the virtual

log sequence number.

- pageid is the page number.

- operationsseqno is the sequence

number of the operation.



You can get the LSN using the Microsoft

SQL Server DBCC command, or you can parse

it from the locator. For example:

- LSN in decimal format: 489:112:27

- LSN in hexadecimal format:

0x00000489:00000112:0027



- For Oracle, the identifier contains, SCN

(System Change Number), redo log thread, and

Record Byte Address (RBA) and it has the

following form:



wrap.base.sub, thread, lsn.blknum.blkoffset



where:

- wrap is the SCN wrap number.

- base is the SCN base number.

- sub is the SCN sub index.

- thread is the redo log thread number

that the operation occurred on.

- lsn is the RBA log sequence number.

- blknum is the RBA block number.

- blkoffset is the RBA offset into the

block where this record resides.



The values must be specified in the

pdb_skip_op command together, enclosed in

quotes, each item separated by a period.



For example:



'0000.012345678.0001', '1',

'0012.0000444.0000123'



All values can be described as a hexadecimal

by prefixing the identifier with an 0x as

follows:



'0x000c.00001bc.000007b'



or



'0x0000.00BC614E.000A'



See also



ra_helplocator, ra_locator
Workaround Description
 Undocumented, pdb_skip_op for Oracle supports passing a locator value.

Passing a locator value that includes the subSCN value works as desired.



CR:533483
CR Number:   533483
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 13 Aug 2008 Fixed
5.6.07 11 Aug 2008 Fixed
5.7.00 11 Aug 2008 Fixed
5.6.07 12 Aug 2008 Fixed
5.7.00 12 Aug 2008 Fixed
Description
ORACLE ONLY: Replication Agent fails with an

error similar to "Oracle log scanner error ...

log record <> was not correctly sorted - locator

is not greater than previous log record locator".



CR:533571
CR Number:   533571
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 30 Jun 2008 Fixed
5.6.07 30 Jun 2008 Fixed
5.5.17 30 Jun 2008 Fixed
5.7.00 27 Jun 2008 Fixed
Description
ASE ONLY: NullPointerException error occurs

during resume when the maintenance user specified

in Replication Server is not a valid user in

primary database.



CR:533997
CR Number:   533997
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 01 Jul 2008 Fixed
5.6.07 01 Jul 2008 Fixed
5.7.00 01 Jul 2008 Fixed
Description
ORACLE ONLY: Replication Agent stops replicating

with an error similar to: "Could not concatenate

chained operation because: Error processing

record with supplemental data whose column index

duplicates other data columns".



CR:534184
CR Number:   534184
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
"drop logical connection" crashes repserver, infected with signal 11, if num_threads underconfigured.
Workaround Description
 Increase number of threads:

configure replication server set num_threads to "a_higher_value"



CR:534253
CR Number:   534253
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 03 Jul 2008 Fixed
5.6.07 04 Jul 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: When DDL replication is

enabled, the operation issued by the maintenance

user may not be filtered by the Replication Agent.



CR:534312
CR Number:   534312
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 25 Jun 2008 Fixed
5.6.07 25 Jun 2008 Fixed
5.7.00 25 Jun 2008 Fixed
Description
Replication Agent generates replication definition

containing column names that are not quoted on the

"replicate if changed" clause.



CR:534317
CR Number:   534317
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 03 Jul 2008 Fixed
5.6.07 03 Jul 2008 Fixed
5.7.00 08 Jul 2008 Fixed
5.8.00 03 Jul 2008 Fixed
Description
Replication Agent incorrectly throws an invalid

LTL command exception when the connection

to the Replication Server is lost.



CR:534597
CR Number:   534597
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
admin translate does not show further information about the error in the RS log
Workaround Description
 None



CR:534766
CR Number:   534766
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 05 Feb 2009 Fixed
Description
Alter connection can be used to change maintenance passwords of all DSIs and is not restricted to RS using ERSSD



CR:534773
CR Number:   534773
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 02 Jul 2008 Fixed
5.6.07 02 Jul 2008 Fixed
5.5.17 02 Jul 2008 Fixed
Description
When using the admin utility

to delete an instance, entering

'n' to cancel the delete operation

will display an incorrect message

"Successfully deleted instance

<Instance Name>."



CR:534806
CR Number:   534806
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 03 Mar 2009 Fixed
5.8.00 03 Mar 2009 Fixed
5.5.17 10 Nov 2008 Fixed
12 Jun 2009 Fixed
Description
doc steps when ddl is skipped in oracle log with pdb_xlog init, move_trunc



if a customer moves the truncation point with pdb_xlog init, move_truncpt and the truncation point is moved past ddl...alter table...for example, then there are two options.



1) pdb_xlog init, force ... this will update the RASD in a wholesale manner

2) unmark and mark the individual table if the user knows they only changed one table



CR:534845
CR Number:   534845
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 09 Jul 2008 Fixed
5.5.17 09 Jul 2008 Fixed
5.6.07 05 Aug 2008 Bundled Request
Description
ORACLE ONLY: An exception is thrown the second

time the Replication Agent is de-initialized with

the force option.



CR:535076
CR Number:   535076
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 17 Jul 2008 Fixed
5.6.07 17 Jul 2008 Fixed
Description
ORACLE ONLY: Issuing the 'ra_init force' command

repeatly will display a different error message

each time.



CR:535342
CR Number:   535342
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)
23 Oct 2008 Fixed
23 Sep 2008 Fixed
22 Oct 2008 Fixed
Description
A route cannot be created from a primary

RS using RS 15.0.1 to a replicate RS

using RS 12.6. This can occur when the

primary RS is upgraded from RS 12.1.



CR:535498
CR Number:   535498
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 24 Jul 2008 Fixed
5.6.07 09 Jul 2008 Fixed
Description
MICROSOFT SQLSERVER ONLY: NullPointerException is

thrown when resuming Replication Agent and the

'pdb_auto_create_repdefs' configuration property

is set to true.



CR:535635
CR Number:   535635
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.1.0.5606P1c-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 18 Jul 2008 Fixed
5.7.00 18 Jul 2008 Fixed
Description
ORACLE ONLY: NoSuchElementException on resume

sends the Replication Agent to ADMIN state.
Workaround Description
 Stop and restart the Replication Agent to clear any cached information



CR:535675
CR Number:   535675
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5514P7b-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 16 Jul 2008 Fixed
5.5.17 24 Jul 2008 Fixed
5.7.00 17 Jul 2008 Fixed
5.6.07 17 Jul 2008 Fixed
Description
ORACLE ONLY: Replication Agent may throw

an OutOfMemory exception if there are large

transactions done by the maintenance user.



CR:535712
CR Number:   535712
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)
11 Jul 2008 Fixed
11 Jul 2008 Fixed
11 Jul 2008 Fixed
11 Jul 2008 Fixed
Description
In an MSA environment, if a table

contains TEXT columns that allows NULL

values, these columns will be missing

from an UPDATE statement's WHERE clause

if these UPDATE statements are applied

at the primary database by an RS

maintenance user.
Workaround Description
 Put on a table replication definition over the msa that has the correct columns



CR:536128
CR Number:   536128
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#3 07 05 Aug 2009 Fixed
Description
Show the version string in ltmlog and jesmsglog.
Workaround Description
 Always get the full JES log for the RA DB2 task.



CR:536397
CR Number:   536397
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 27 Jul 2008 Fixed
5.7.00 27 Jul 2008 Fixed
5.5.17 27 Jul 2008 Fixed
Description
ORACLE ONLY: NullPointerException sends the

Replication Agent to ADMIN state while reading a

log record without any supplemental metadata.

The error is known to occur with an Oracle

database configurations DB_2K_CACHE_SIZE=16M and

undo_tablespace equal to a tablespace with block

size 2048.



CR:536398
CR Number:   536398
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 16 Jul 2008 Fixed
5.7.00 16 Jul 2008 Fixed
5.5.17 16 Jul 2008 Fixed
Description
ORACLE ONLY: An IllegalStateException during

Oracle DDL command processing sends the

Replication Agent to ADMIN state.



CR:536403
CR Number:   536403
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
Provide command that would display the connection information of a running server.



CR:536744
CR Number:   536744
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 14 Jul 2008 Fixed
5.6.07 14 Jul 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication fails with

"No replication definition found" error after a

unmarking a table which is previously marked

with a different replicate name.



CR:536766
CR Number:   536766
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2008 Fixed
Description
Cannot add partition of all sizes and types.
Workaround Description
 Use a file system and only use certain numbers.



Another potential workaround (not verified by the author of the CR):



Check if /lib/i686 env is set if it is then take it out from $LD_LIBRARY_PATH. After removing /lib/i686 from LD_LIBRARY_PATH we were able to add partition



CR:536785
CR Number:   536785
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.1.0.5606P1c-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 17 Jul 2008 Fixed
5.7.00 17 Jul 2008 Fixed
Description
ORACLE ONLY: Issuing the ra_statistics command

directly after the Replication Agent is changed

to replicating state results in a

NullPointerException. The error is limited to a

RAC replication environment.



CR:536814
CR Number:   536814
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.1.0.5606P1c-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 21 Jul 2008 Fixed
5.7.00 21 Jul 2008 Fixed
5.5.17 22 Aug 2008 Fixed
Description
ORACLE ONLY: An IndexOutOfBoundsException

occurred during initialization of a change vector

sends the Replication Agent to ADMIN state.



CR:536887
CR Number:   536887
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2008 Fixed
Description
It is not possible for a standard user (connection rights to repository and read-rights on model) to extract a model in a specific model-version which is also in a configuration.



CR:536953
CR Number:   536953
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)
10 Aug 2009 Fixed
Description
"Replication table LTMOBJECTS has ErrorCode= n" is inadequately documented.
Workaround Description
 Use the RA DB2 15.0 User and Troubleshooting manual.



CR:537036
CR Number:   537036
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 01 Aug 2008 Fixed
5.6.07 01 Aug 2008 Fixed
Description
ORACLE ONLY: When replicating Oracle RAC, the

Replication Agent doesn't enter the admin state

when the quiesce command is issued.



CR:537398
CR Number:   537398
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Open
OS:   NA
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a parameter to rs_subcmp that automatically tells rs_subcmp to compare trimmed values.
Workaround Description
 Use the select clause to modify the results being compared.



CR:537412
CR Number:   537412
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 13 Nov 2008 Fixed
5.6.07 13 Aug 2008 Fixed
5.7.00 13 Aug 2008 Fixed
Description
ORACLE ONLY: Truncate table replication failure

results in replicate database constraint

violation.



CR:537427
CR Number:   537427
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 04 Aug 2008 Fixed
5.7.00 04 Aug 2008 Fixed
5.5.17 04 Aug 2008 Fixed
Description
ORACLE ONLY: If a middle column in a table is

dropped via an alter table, a subsequent insert

on the table will fail to replicate because of

a column mismatch.



CR:537549
CR Number:   537549
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Enhance the "Consolidate Multiple Documents" Window so it adds to the consolidation list all the documents modified in the workspace compared to its version in the current branch of the repository.

"Add Modified Documents in Workspace" is not reliable enough because model(s) may have already been saved locally prior to consolidation.



CR:537607
CR Number:   537607
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   SunOS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2008 Fixed
22 Sep 2008 Fixed
22 Sep 2008 Fixed
22 Sep 2008 Fixed
Description
If, for the same database replication

definition, two database subscriptions are

created using the 'with dump marker' clause, the

process of creating the second database

subscription will incorrectly not suspend the

associated DSI connection.



CR:537629
CR Number:   537629
Product Name:   Replication Server
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2008 Not a Bug
Description
Sybase Replication Server 15.1 is a completely

new version. As a result, there are no fixed

bugs to list in this section.



CR:537824
CR Number:   537824
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 Nov 2009 Fixed
24 Nov 2009 Fixed
25 Nov 2009 Fixed
24 Nov 2009 Fixed
26 Nov 2009 Fixed
05 Jan 2010 Fixed
Description
In an MSA environment, Replication Server failed with DSI error 29023 when multiple replication definitions were defined on the same table.
Workaround Description
 Mark primary table for replication and create table subscription at MSA site to avoid error.



CR:537884
CR Number:   537884
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 23 Jul 2008 Fixed
5.6.07 23 Jul 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: ra_truncateusers command

truncate all versions of the user.



CR:537928
CR Number:   537928
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2008 Fixed
30 Jul 2008 Not a Bug
30 Jul 2008 Not a Bug
30 Jul 2008 Fixed
Description
ORACLE ONLY: Log truncation fails with error

message "The value '4290772992' can not be

converted into a signed integer."



CR:537934
CR Number:   537934
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Closed
OS:   Generic
Original Version:   15.1.0.5602
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2009 Fixed
Description
Quick Install: isql to the Direct Connect Service, no server, to verify connection to MS SQL



CR:537961
CR Number:   537961
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   NA
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 30 Jul 2008 Fixed
5.7.00 30 Jul 2008 Fixed
Description
MICROSOFT SQL SERVER and ORACLE ONLY:



There are new Replication Agent System Database

backup features for saving and restoring the

ASA database.



The Replication Agent System Database is now

automatically backed up when the transaction log

is re-initialized, so in the event an error

occurs while the transaction log is being

re-initialized, it can be restored to the state

it was before re-initialization started.



When the Replication Agent System Database is

backed up, the most recent database backup is now

saved in a repository backup directory with a

time-stamped name in the format

"yyyy-MM-dd_HH.mm.ss" before the ASA database is

backed up. The ASA database is still backed up in

the location specified by the "rasd_backup_dir".

In addition, the database backup files are not

automatically removed. A new feature is provided

for backup maintenance.



Example backup directory:



<INSTALL_DIR>\RAX-15_1\myRAO\repository\backup\

2008-07-24_15.41.10



Note:

The Replication Agent System Database can be

backed up manually using the "rasd_backup"

command, or will be backed up automatically

when the transaction log is re-initialized.



The "rasd_restore" command has been enhanced to

take advantage of the new backup features. In

addition to having the ability to restore from

the most recent ASA database backup, individual

backups can be selected for restore.



Command Description



rasd_restore



Description



This command is available only for Oracle and

Microsoft SQL Server.



Restores the RASD.



Syntax



rasd_restore [backup_name]



Parameters



backup_name



The name of the backup to restore from. If the

backup name is ommited, the most recent backup

is restored.



Examples



rasd_restore



This command with no parameters restores the RASD

from the most recent backup.



rasd_restore 2008-07-24_15.41.10



This command restores the RASD from the

2008-07-24_15.41.10 backup.





Usage



When rasd_restore is invoked, it starts the

restore process for the RASD.



Sybase Replication Agent looks for the most

recent RASD backup files in the directory

identified by the rasd_backup_dir configuration

parameter when no parameters are input.



Sybase Replication Agent restores from the

specified backup in the directory identified by

the rasd_backup_dir configuration parameter

a backup name is provided as a parameter



When you create a Sybase Replication Agent

instance, a RASD backup directory is created

automatically as part of the instance directory

structure. The default value of the

rasd_backup_dir parameter points to that

directory.



If you invoke rasd_restore when the Sybase

Replication Agent instance is in Replicating

state, it returns an error.



The rasd_restore command is valid only when the

Sybase Replication Agent instance is in Admin

state.



See also

rasd_backup, rasd_helpbackup, rasd_removebackup



There are two new Replication Agent commands for

managing Replication Agent System Database

backups. They are rasd_helpbackup and

rasd_removebackup.





rasd_helpbackup



Description



This command is available only for Oracle and

Microsoft SQL Server.



Displays a list of RASD backups



Syntax



rasd_helpbackup



Example:



1> rasd_helpbackup

2> go

RASD Backups

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

2008-07-24_15.41.10

2008-07-28_10.08.27

2008-07-28_10.09.29

2008-07-28_10.11.31



(4 rows affected)



Usage



When rasd_helpbackup is invoked, it displays a

list of RASD backups stored in the directory

identified by the rasd_backup_dir configuration

parameter when no parameters are input.



The RASD backups are named with the date and time

at which the backup was created.



See also

rasd_backup, rasd_restore, rasd_removebackup



rasd_removebackup



Description



This command is available only for Oracle and

Microsoft SQL Server.



Removes RASD backups



Syntax



rasd_removebackup [backup_name | all]



Parameters



backup_name



The name of the backup to remove.



all



A keyword that allows you to remove all

RASD backups.





Examples:



rasd_removebackup 2008-07-24_15.41.10



This command causes the backup named

2008-07-24_15.41.10 to be removed



1> rasd_removebackup 2008-07-24_15.41.10

2> go

RASD Backups removed

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

2008-07-24_15.41.10



(1 row affected)



rasd_removebackup all



This command causes all of the backups to be

removed.



1> rasd_removebackup all

2> go

RASD Backups removed

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

2008-07-28_10.08.27

2008-07-28_10.09.29

2008-07-28_10.11.31

2008-07-28_10.20.55



(4 rows affected)



Usage



When rasd_removebackup is invoked, it removes a

RASD backup stored in the directory identified by

the rasd_backup_dir configuration parameter.



When rasd_removebackup is invoked with the 'all'

keyword, it removes all RASD backup stored in the

directory identified by the rasd_backup_dir

configuration parameter.



When rasd_backup is invoked, the names of all

backups removed is displayed.



The RASD backups are named with the date and time

at which the backup was created.



See also

rasd_backup, rasd_restore, rasd_helpbackup



CR:538032
CR Number:   538032
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 27 Jul 2008 Fixed
5.7.00 27 Jul 2008 Fixed
Description
ORACLE ONLY: ra_helpuser returns STATUS and

VERSION info with NULL value.



CR:538036
CR Number:   538036
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 29 Jul 2008 Fixed
5.7.00 29 Jul 2008 Fixed
5.5.17 06 Aug 2008 Fixed
Description
ORACLE ONLY: ra_truncatearticles can not truncate

old versioned articles.



CR:538108
CR Number:   538108
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 05 Feb 2009 Fixed
Description
In Reference Manual, dsi_commit_check_locks_log parameter is referenced as dsi_commit_check_locks_logs
Workaround Description
 Use parameter named dsi_commit_check_locks_log (without the "s")



CR:538154
CR Number:   538154
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2010 Fixed
Description
Review and recommend/implement RSSD tables that would go to DOL to reduce RSSD contention between tables.



CR:538162
CR Number:   538162
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   AIX
Original Version:   15.1.0.5606P1c-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2009 Diagnostic Provided
5.7.02 13 Jan 2009 Fixed
5.7.02 23 Feb 2009 Fixed
5.5.23 11 May 2010 Presently Not Targeted For Any Future Release Of This Product
5.7.02 12 Mar 2009 Diagnostic Provided
5.8.00 30 Jan 2009 Fixed
5.8.00 04 May 2009 DEFER
5.8.00
04 May 2009 One-off Provided
04 May 2009 One-off Provided
Description
ORACLE RAC ONLY: Replication performance is slow

when only one of the cluster instances is active.



CR:538211
CR Number:   538211
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 31 Jul 2008 Fixed
5.7.00 31 Jul 2008 Fixed
31 Jul 2008 Fixed
Description
ORACLE ONLY: If the directory identified by the

Replication Agent pdb_archive_path configuration

parameter contains no Oracle archive logs,

Replication Agent will go to ADMIN state with an

unexpected thread death exception.



CR:538254
CR Number:   538254
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 05 Aug 2008 Fixed
5.7.00 07 Aug 2008 Fixed
11 Aug 2008 Fixed
Description
ORACLE ONLY: Data is not correctly replicated for

parallel transactions with random rollback on

a table containing LOB column.



CR:538449
CR Number:   538449
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
closluce EBF2 17 Nov 2008 Fixed
Description
Build 0411



Attribute in CDM is a special small object that is related to a data item

In all places in PD, Attribute properties inherits from Data item

properties (data type, length, comment, etc...)

Currently CMR is not showing anything for Attribute.



CR:538540
CR Number:   538540
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.12 09 10 Aug 2009 Fixed
Description
Abend, S0C4 REASON CODE=00000011 in PACKASM$(PACKASM),offset 001710.
Workaround Description
 Used logtrace=yes to identify the record that was having the problem. Then started up RA just past it.



CR:538640
CR Number:   538640
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 30 Jul 2008 Fixed
5.7.00 30 Jul 2008 Fixed
5.5.17 06 Aug 2008 Fixed
Description
ORACLE ONLY: ra_truncateusers can not truncate

old versioned users.



CR:538791
CR Number:   538791
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.1.0.5606P1c-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 31 Jul 2008 Fixed
5.7.00 31 Jul 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Issuing the ra_helpuser

command with a username that doesn't exist in the

primary database fails with error "Command

<ra_helpuser> failed - Could not list metadata

for user <XXX> because: null".



CR:539054
CR Number:   539054
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2010 Fixed
Description
Version name is missing the dot sign separating version and branch# from 10th branch.

As an example,

version 1 / branch 10/ branching version 1

is displayed 110.1 where you should read 1.10.1



CR:539141
CR Number:   539141
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 10 Oct 2008 Fixed
5.5.17
5.5.17
5.5.17
5.5.17 08 Jan 2009 One-off Provided
5.5.17
5.7.02
5.8.00
Description
ORACLE ONLY: Replication Agent falls behind

in processing Oracle archive log files when

customer's batch application runs and creates

40+ gigabytes of archive log files.



CR:539271
CR Number:   539271
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)
30 Jul 2008 Fixed
Description
If a DSI connection to an Oracle database is

configured to use Dynamic SQL, the DSI

connection will fail and shutdown when

attempting to replicate the UNIVARCHAR datatype.



CR:539307
CR Number:   539307
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
change repserver to use the ... starting at 2 ... by default for AIX when a stable device is created on a raw partition. ASE does this by default.



stable device ... 0516-622 synclvodm: Warning, cannot write lv control block...



on AIX only when a stable device is created on a raw partition using just the minimum default syntax of...



create partition repro_part on '/dev/r11445073e' with size 60



..., then the unix commands of exportvg and importvg are attempted...this causes the following problem...



0516-622 synclvodm: Warning, cannot write lv control block data.

synclvodm: Logical volume 11445073d updated.



... and then the stable device fails to come back online and the customer had to call IBM to get it rebuilt...
Workaround Description
 use the ... starting at 2 ... when creating the stable device on a raw partition on AIX



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

isql -Srs3a1501e3bs2 -Usa -P -w2048

admin who_is_down

go

admin who

go

admin disk_space

go

create partition repro_part on '/dev/r11445073e' with size 60 starting at 2

go

admin disk_space

go

quit

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

bluesky2 12:59# varyoffvg sanvg

bluesky2 14:50# exportvg sanvg

bluesky2 14:50# importvg sanvg

0516-082 lqueryvg: Unable to access a special device file.

Execute redefinevg and synclvodm to build correct environment.

0516-082 lqueryvg: Unable to access a special device file.

Execute redefinevg and synclvodm to build correct environment.

0516-1140 importvg: Unable to read the volume group descriptor area

on specified physical volume.

bluesky2 14:50# redefinevg -d hdisk3 sanvg

bluesky2 14:51# varyonvg sanvg

bluesky2 14:51# synclvodm -P -v sanvg

synclvodm: Physical volume data updated.

synclvodm: Logical volume 11445073e updated.

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



CR:539378
CR Number:   539378
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 16 Oct 2008 Fixed
5.8.00 26 Oct 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

fails to replicate empty text/image values.



CR:539588
CR Number:   539588
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5512P7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

upgrade fails due to Replication Agent

ra_xlog_system_ system table failing to

find dbo.ra_truncate_logs table.
Workaround Description
 Edit the migration.sql file and remove the dbo. reference to ra_truncate_logs from the script. The migration.sql script resides under the RAX-15_0/scripts/xlog directory.



Here are the lines highlighted by Lisa:



The change would be for the following lines:



-- DROP PROCEDURE dbo.ra_truncate_logs_

DROP PROCEDURE dbo.ra_truncate_logs_

DELETE FROM ra_xlog_system_ WHERE ravalue = 'dbo.ra_truncate_logs_'

CREATE PROCEDURE dbo.ra_truncate_logs_

/** USAGE: dbo.ra_truncate_logs_([@TRUNC_POINT=<NUM>]; **/

GRANT EXECUTE ON dbo.ra_truncate_logs_ TO PUBLIC

INSERT INTO ra_xlog_system_ VALUES ('trunc_log_proc', 'dbo.ra_truncate_logs_')



However, in the migrate.sql script, there are also some select and delete statements that have the dbo reference and I suspect that those dbo references should be removed also. As a sanity check, look at the user of these system tables and ensure that they are owned by dbo (or look at the existing ra_truncate_logs_ script). Modify the migrate.sql appropriately.



Then, manually, logging on as the same user as the config value pds_username, execute the script. Note that the last item that the script executes is to update the installed_buildnum . This is the key that lets the RAM know that upon the next startup of RAM, do not rebuild migrate.sql file.



CR:539711
CR Number:   539711
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 05 Aug 2008 Fixed
5.7.00 05 Aug 2008 Fixed
5.5.17 07 Aug 2008 Fixed
Description
ORACLE ONLY: Replication Agent sends the wrong LTM

locator value to Replication Server when

replicating DDL commands and the pdb_gen_id

configuration parameter is set to a non-zero value.



CR:539826
CR Number:   539826
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Closed
OS:   HP-UX
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
When the HP800 RS 15.1 GA installer is executed as the Unix user 'root',

the installer will terminate prematurely with the following message ...



Assertion failed: so->so_hard_contents, file softobj.c, line 363

sh: 11794 Abort(coredump)
Workaround Description
 Execute the HP800 RS 15.1 installer as a Unix user other than the Unix

user 'root'. Then, change the ownership of all the resulting directories

and files to the Unix user 'root'



CR:540059
CR Number:   540059
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2008 Duplicate
Description
Request for Replication Server Manager Plugin to support partition management RCL commands.
Workaround Description
 Use RCL commands directly.



CR:540099
CR Number:   540099
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)
15.5 28 Oct 2009 Duplicate
Description
Non-applicable function strings to heterogeneous targets send empty commands or useless commits to target DBMS
Workaround Description
 None, maybe use CIS?



CR:540168
CR Number:   540168
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 07 Aug 2008 Fixed
5.7.00 07 Aug 2008 Fixed
Description
ORACLE ONLY: Replication Agent may throw an

exception "Invalid state encountered processing

commit operation" when applying DML commands

to Oracle system table MGMT_* if they are

for an Index Organized Table.



CR:540234
CR Number:   540234
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.6.07 13 Aug 2008 Fixed
5.7.00 13 Aug 2008 Fixed
5.5.17 15 Aug 2008 Fixed
5.5.17 22 Aug 2008 Fixed
5.7.02
Description
ORACLE ONLY: Replication Agent will go into ADMIN

state with the following OracleRuntimeException

error "The operation is not the first operation

in a chain and a chained operation is not active."

replicating a table that has an after update trigger

and the update trigger contains some DML operation

that is applied to another table.



CR:540245
CR Number:   540245
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2008 Fixed
19 Aug 2008 Fixed
19 Aug 2008 Fixed
Description
When a DSI connection is configured with

the option 'dsi_alt_writetext' set to

'dcany', the Replication Server may

terminate unexpectedly. This can occur

when the Replication Server processes a

system transaction.



CR:540359
CR Number:   540359
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2008 Fixed
Description
When extracting a model into a local model which has been changed with "merge" and "open" checked, the resulting model misses the symbols on the diagram which are part of the model change. The objects themselves however are still existing.



CR:540389
CR Number:   540389
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_init, create a new rep server, shows shutdown message instead of erroring out that the port is already in use.
Workaround Description
 use a port number that is not in use on the machine.



CR:540649
CR Number:   540649
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2008 Fixed
16 Dec 2008 Fixed
Description
When an invalid value is passed to "trace all"

command, the command returns successfully.



CR:540716
CR Number:   540716
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Not a Bug
Description
"Bind the log extract plan" help invoked through the Installer, has not been updated for DB2 V 8.



CR:540766
CR Number:   540766
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2008 Fixed
29 Oct 2008 Fixed
Description
ORACLE ONLY: Using an 'opaque' datatype

to create a table level replication

definition results in incorrect data

being sent to Replication Server. The

incorrect data causes the Replication

Server DSI to go down.



CR:540891
CR Number:   540891
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.00 13 Aug 2008 Fixed
5.6.07 13 Aug 2008 Fixed
5.5.17 13 Aug 2008 Fixed
Description
ORACLE ONLY: Replication definition is not created

correctly for a table with no replicate columns.



CR:540987
CR Number:   540987
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 13 Nov 2008 Fixed
5.8.00 14 Nov 2008 Fixed
Description
ORACLE ONLY: pdb_setreptable command shows

an incorrect error message when the owner

value passed to it is invalid.



CR:540988
CR Number:   540988
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 14 Aug 2008 Fixed
5.7.00 17 Aug 2008 Fixed
5.6.07 17 Aug 2008 Fixed
5.7.00 15 Aug 2008 Fixed
5.6.07 15 Aug 2008 Fixed
Description
ORACLE ONLY: Replication Agent may throw

an OutOfMemory exception if there are large

transactions done by the maintenance user.



CR:541223
CR Number:   541223
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2009 Fixed
05 Feb 2009 Fixed
05 Feb 2009 Fixed
05 Feb 2009 Fixed
Description
The 'suspend connection' command

inadvertently changes the case of data server name or database name in RSSD if the

case of names specified in the command do not match the case of names in RSSD.





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

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