远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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:684900
CR Number:   684900
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
beauregard 09 Nov 2011 Fixed
Description
Edit comment : update an object should version link attached to it



CR:685119
CR Number:   685119
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 ESD #4 11 Oct 2011 Fixed
22 Jul 2013 Presently Not Targeted For Any Future Release Of This Product
15.7.1 ESD #3 19 Mar 2013 Fixed
12 Oct 2011 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

encounters a java.lang.NullPointerException

when resuming replication after changing the

maintenance user id.



CR:685330
CR Number:   685330
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2012 Fixed
Description
When creating a replication definition, the Replication Manager Plugin incorrectly uses the datatype numeric for identity columns. The default value should remain as an identity datatype.



CR:685331
CR Number:   685331
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2011 Fixed
29 Oct 2011 Fixed
Description
Create subscription with atomic materialization puts text data to incorrect row.
Workaround Description
 Manually materialize the table in IQ.



CR:685438
CR Number:   685438
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is RepServer 15.6 GA under AIX platform.



Customer have installed "rs_install_statreport_v1510_ase.sql".



When Customer populate statistics using "rs_stat_popultae", this store proc call "rs_stat_populate_netspd" which report duplicate key error:



1> rs_stat_populate

2> go

We are going to populate report. Script version 1510. :-)

Msg 2601, Level 14, State 2:

Server 'SYBASE_MEDISREP2', Procedure 'rs_stat_populate_netspd', Line 189:

Attempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'

Command has been aborted.

...



Because Customer have setting up a Warm/Standby configuration after he have create the Primary (Active) Connection, the Logical-Connection have the same name ("dsname" and same "dbname") but as well the same Database-ID ("dbid).



In the following example, see Connection-ID 144, but as well as Connection-ID 170:



1> select dbid, dsname, dbname, ltype, ptype, ldbid from rs_databases order by dbid

2> go

dbid dsname dbname ltype ptype ldbid

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

101 SYBASE_MEDISREP2 rssd P A 101

144 SYBASE_MEDISPRD1 facets221ar P A 144

144 SYBASE_MEDISPRD1 facets221ar L L 144

145 SYBASE_MEDISREP2 facets221ar P S 144

170 SYBASE_MEDISPRD1 facets221 P A 170

170 SYBASE_MEDISPRD1 facets221 L L 170

171 SYBASE_MEDISREP2 facets221 P S 170



(7 rows affected)



Such configuration cause "rs_stat_populate" to report "Attempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'".
Workaround Description
 In "rs_install_statreport_v1510_ase.sql", when creating store procedure "rs_stat_rs_stat_populate_netspd", a list of connections is build and populate a temporary table:



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

...

-- get a list of the connections, their names, etc.



select dbid,

connection=dsname+'.'+dbname+' ('+convert(varchar(7),dbid)+')',

type=convert(char(1),'D'), ltype, ptype

into #connections_netspeed

from rs_databases

where prsid=@rs_id

union all

select r.through_rsid,

s.name + ' ('+convert(varchar(10),r.through_rsid)+')',

type=convert(char(1),'R'), null, null

from rs_routes r, rs_sites s

where r.source_rsid=@rs_id

and r.through_rsid=s.id

...

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



This could be change by :



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

...

-- get a list of the connections, their names, etc.



select dbid,

connection=dsname+'.'+dbname+' ('+convert(varchar(7),dbid)+')',

type=convert(char(1),'D'), ltype, ptype

into #connections_netspeed

from rs_databases

where prsid=@rs_id

--

and ltype = 'P'

union all

select dbid,

connection=dsname+'.'+dbname+' ('+convert(varchar(7),dbid)+')',

type=convert(char(1),'D'), ltype, ptype

from rs_databases

where prsid=@rs_id

and ltype = 'L' and not exists ( select '*' from rs_databases t_db where t_db.dbid = rs_databases.dbid and t_db.ltype = 'P')

--

union all

select r.through_rsid,

s.name + ' ('+convert(varchar(10),r.through_rsid)+')',

type=convert(char(1),'R'), null, null

from rs_routes r, rs_sites s

where r.source_rsid=@rs_id

and r.through_rsid=s.id

...

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



CR:685596
CR Number:   685596
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2011 Fixed
Description
A new configuration property, dsi_escape_newline, has been defined at the Replication Server and

DSI (connection) levels. This property controls when newline characters, contained as a part of the

data, are escaped in order to preserve them. Originally, these characters were escaped such that

replicate databases similar to Sybase ASE would not remove them. This behavior resulted in

duplicated newline characters in some non-ASE databases.



"dsi_newline_escape" valid values are "on"|"off".

The default value is "on" to match current Replication Server behavior.



"dsi_newline_escape" may be set through the following Replication Server syntax:



configure replication server set dsi_newline_escape to ["on"|"off"]

alter connection to <connection> set dsi_newline_escape to ["on"|"off"]



For replication to MS SQL and ASE, dsi_newline_escape should be "on". For replication to Oracle and

DB2 LAN, dsi_newline_escape should be "off". This new property has not been verified for any other

replication targets.



CR:685758
CR Number:   685758
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
sysadmin hibernate_on crashes RepServer if target IQ is down.



CR:685911
CR Number:   685911
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 Fixed
28 Oct 2011 Fixed
Description
Memory leak in row count validation mechanism not releasing memory for error message when RS error 5185 is mapped to ignore.
Workaround Description
 Currently for 32 bit RS, use GA. For 64 bit, increase memory_limit. This does not get around the issue, just makes the issue not crash the RS.



CR:686037
CR Number:   686037
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
Image columns will utilize bulk copy.



CR:686143
CR Number:   686143
Product Name:   Rep Serv What's New
Product Component:   Rep Serv What's New
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 Dec 2011 Fixed
Description
'max number of replication paths' is supposed to be 'max number replication paths'
Workaround Description
 Use 'max number replication paths'



CR:686179
CR Number:   686179
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
10 Oct 2011 Fixed
Description
Runtime errors observed with NULL text/image in a specific scenario. The error is not fatal due to the HVAR/RTL retry mechanism but may affect the performance seriously.



CR:686258
CR Number:   686258
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2011 Fixed
27 Oct 2011 Fixed
08 Nov 2011 Fixed
19 Dec 2011 Fixed
15 Nov 2011 Fixed
07 Dec 2011 Added to user documentation
21 Dec 2011 Fixed
Description
Due to an inconsistent use of owner qualification for replicated objects, when using the HVAR feature (dsi_compile_enable set to "on") customers may see the Replication Server process abnormally end on a Signal 11.



CR:686277
CR Number:   686277
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
Description
RS 15.7 CTP reports many Internal error. Attempted to free a resource chain with resources.



CR:686285
CR Number:   686285
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Duplicate
Description
Connection with ID = 0 is not defined to the Replication Server. is not a clear message as to what the issue is with the create route command.
Workaround Description
 Put in the correct names for the route, and primary connections



CR:686286
CR Number:   686286
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2011 Fixed
Description
rs_helproute erroneously says that a site is not found, when it really does exist.
Workaround Description
 Use the admin who listing to see connection number is referred to. In the following example:



1> rs_helproute

2> go

route

route_status

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

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

no site name for 113 ---- ( Next site: RS1 ) ----> RS2

Active.

route

route_status

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

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

RS1 --------> RS2

Active.

(return status = 0)



Site 113 = ase157i.mprpri2



1> admin who

2> go

Spid Name State Info

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

21 DSI EXEC Awaiting Command 101(1) ase157rssd.RS1_RSSD

13 DSI Awaiting Message 101 ase157rssd.RS1_RSSD

16 DIST Awaiting Wakeup 101 ase157rssd.RS1_RSSD

20 SQT Awaiting Wakeup 101:1 DIST ase157rssd.RS1_RSSD

10 SQM Awaiting Message 101:1 ase157rssd.RS1_RSSD

9 SQM Awaiting Message 101:0 ase157rssd.RS1_RSSD

22 REP AGENT Awaiting Command ase157rssd.RS1_RSSD

35 DSI EXEC Awaiting Command 111(1) ase157i.mprpri

30 DSI Awaiting Message 111 ase157i.mprpri

32 DIST Awaiting Wakeup 111 ase157i.mprpri

34 SQT Awaiting Wakeup 111:1 DIST ase157i.mprpri

31 SQM Awaiting Message 111:1 ase157i.mprpri

29 SQM Awaiting Message 111:0 ase157i.mprpri

45 REP AGENT Awaiting Command ase157i.mprpri

43 DIST Awaiting Wakeup 113 ase157i.mprpri2

44 SQT Awaiting Wakeup 113:1 DIST ase157i.mprpri2

42 SQM Awaiting Message 113:1 ase157i.mprpri2

46 REP AGENT Awaiting Command ase157i.mprpri2

12 RSI Awaiting Wakeup RS2

11 SQM Awaiting Message 16777318:0 RS2

14 dSUB Sleeping

6 dCM Awaiting Message

7 dAIO Awaiting Message

17 dREC Sleeping dREC

8 dDELSEG Awaiting Message

48 USER Active sa

5 dALARM Awaiting Wakeup

18 dSYSAM Sleeping



CR:686507
CR Number:   686507
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Replication Server 15.x: arithmetic overflow during implicit conversion errors executing rs_stat_populate:



1> rs_stat_populate

2> go

We are going to populate report. Script version 1510. :-)

Msg 247, Level 16, State 1:

Server 'PRIM', Procedure 'rs_stat_populate_sqt', Line 260:

Arithmetic overflow during implicit conversion of NUMERIC value '4.524371180900952110274264601392638908625' to a NUMERIC field .

(return status = -6)





=> Tested using different RS releases including RS 15.6 "rs_install_statreport_v1510_ase.sql" script.



=> This issue is different that CR #609448, WA of CR #609448 was already implemented during this testing and the error message is different.



=> ASE hosting RSSD does not hit ASE CR #579925:



1> select @@version

2> go

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

Adaptive Server Enterprise/15.5/EBF 18160 SMP ESD#2/P/Sun_svr4/OS 5.8/asear155/2514/64-bit/FBO/Wed Aug 25 16:52:39 2010



1> select (-8646682.3 - 2078078.4 - 177488.80) as AAA

2> go

AAA

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

-10902249.50
Workaround Description
 In "rs_install_statreport_v1510_ase.sql" script, all divide operation must be surrounded by an explicit conversion to "numeric(22,3)" when populating temporary table or "rs_statreport" table.



CR:686520
CR Number:   686520
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
Customer is running with RS 12.6 esd#8 under Solaris platform:



Customer is hitting RepServer error #8039:



E. 2011/09/02 17:41:29. ERROR #8039 SQM(1126:0 LON_GDS_PROD1.gds_rep) - tr/mdext.c(2009)

MD failed to wake someone waiting for memory from source=LON_GDS_PROD5.gds_live.





As Customer claim this does not make SQM thread going down, Customer would like this error been reported as only a "Warning" instead of as an "Error" (Customer is having some scanning tool that look for "ERROR" keyword and ping DBA)



CR:686565
CR Number:   686565
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
During the repository check in process, toggling between Simplified and Advanced views allows the 'save diagrams for PowerDesigner Portal' option to be selected when the 'check out after check in' option is unchecked. This should not be allowed (see CR 575544 for explanation)



1) connect to a repository

2) check-in project.pdm model

(check in options - 'check out after check in' and 'save diagram for Portal' are selected)

3) model checks in correctly and diagram is visible in portal

4) in PD, add new table to the diagram

5) check in model

5a) uncheck 'check out after check in' - by default 'save diagram for Portal' is disabled

5b) click simplified

5c) click advanced

5d) click 'save diagram for Portal' but do not select 'check out after check in'

5e) click OK to check in the model



Messages state that the diagram has been saved.



However, in the Portal, the diagram is updated with the new objects, but the html links for the new objects are not created.



CR:686656
CR Number:   686656
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
beauregard EBF1 23 Mar 2012 Fixed
Description
Customer is requesting that PD support the 'ldaps' protocol as part of the Provider URL attribute.



CR:686681
CR Number:   686681
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 04 19 Jan 2012 Fixed
Description
A Begin tran with Same LRSN as the compressed log record caused an abend when restarting the read during a reorg or alter table.



CR:686683
CR Number:   686683
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 04 10 Nov 2011 Fixed
Description
The wrong table was being stopped due to an error because the table's object ID was not being saved properly.



CR:686686
CR Number:   686686
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Not a Bug
Description
Research showed that IBM DB2 program DSNIDLGR log reader was using to much CPU which also caused poor performance. This occured after DB2 maintenance level PUT1010, IBM has been notified they recognized and fixed the problem and we are waiting for the customers to install the fix. The PTF is UK70009. This CR just exists for monitoring purposes.



CR:686692
CR Number:   686692
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 04 10 Nov 2011 Fixed
Description
The APICOM trace is causing the user exit to apear to be getting an S0C4. The trace needs to be fixed.



CR:686694
CR Number:   686694
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 04 10 Nov 2011 Fixed
Description
The timestamp_in_char configuration now accepts 3 values Yes, No, and ISO. The addition of ISO allows the DB2 ISO format to be sent in the LTL.



CR:686966
CR Number:   686966
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2011 Fixed
Description
The Upgrade route process in the Replication Manager Plug-in does not replicate data for existing 15.7 replication definitions to the replicate RSSD.
Workaround Description
 Work-around: At the primary, drop and recreate any repdefs utilizing 15.5 functionality that were created prior to the route upgrade.



CR:687241
CR Number:   687241
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support for data compression in MSSQL 2008 in RA15.5



CR:687280
CR Number:   687280
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2011 Fixed
04 Nov 2011 Fixed
14 Nov 2011 Fixed
06 Jan 2012 Fixed
14 Feb 2012 Fixed
07 Dec 2011 Added to user documentation
09 Jan 2012 Fixed
Description
HVAR/RTL processing may crash the server when a replication definition is having more columns than source table and when the option "replicate minimal columns" is set on the replication definition. The issue happens when an update or a delete is compiled first into the in-memory database (CDB), prior to an insert statement. Current resolution addresses the problem only for HVAR.
Workaround Description
 remove "replicate minimal column" in the repdef.



CR:687725
CR Number:   687725
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2011 Fixed
Description
The Replication Monitoring Services generates an error stating that a file is missing when SCC starts.



CR:687762
CR Number:   687762
Product Name:   Rep Serv Troubleshoot Guide
Product Component:   Rep Serv Troubleshoot Guide
Status:   Closed
OS:   all
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Fixed
Description
Real-time signals 32-64 will terminate the RS process without any error message in the log.



CR:687823
CR Number:   687823
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2012 Fixed
Description
The exceptions log purge feature in the Replication Manager Plug-in does not work correctly because the transaction ID displayed are incorrect.
Workaround Description
 Use the command line (isql) to the RSSD to list the exception(s) and purge the desired one(s).



*** Thu Feb 9 15:26:25 MST 2012 *** wbeck ***

Alternately, use the attached script to correct the RMP_EXCEPTIONS_LOG stored procedure in the RSSD.



CR:688006
CR Number:   688006
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2011 Fixed
Description
Tested and reproduced with:



- Power Designer 15.3 EBF#10

- Oracle 10g Repository

- Native Connection Profile for Oracle 10g



Once a model in repository is locked (even if performed by ADMIN user), no user is able to unlock it any longer, if using Oracle Native Connection Profile.
Workaround Description
 To keep using PD 15.3 EBF#10, the tech workaround is to use ODBC Connection instead of native connection to Oracle 10g.



CR:688021
CR Number:   688021
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2011 Fixed
Description
Tested and reproduced with:



- Power Designer 15.3 EBF#10

- Oracle 10g Repository

- Connection Profile Native connection Oracle 10g



Permission settings not being saved in 15.3 EBF#10 with Oracle native profile. If using ODBC Connection instead, it works. This is a regression from previous PD 15.3 EBF#9, where native Oracle connection profile worked ok.
Workaround Description
 To keep using PD 15.3 EBF#10, workaround is to use ODBC connection profile instead of native one.



CR:688114
CR Number:   688114
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is running RepServer 15.2 esd#3 under Windows 2008 Service-Pack 2.



Customer have configured his RepServer using Embedded RSSD (eRSSD) and is starting RepServer instance as a Windows service.

RepServer service is started using "Local Account".



When requesting an eRSSD backup using "admin erssd, backup" command or when RepServer issue automatically the backup, the backup process hang and lead eRSSD un-accessible (ASE engine is hanging) and eRSSD transaction log is not truncated.



This cause RepServer not able to access to its RSSD:



E. 2011/09/26 17:42:45. ERROR #11060 USER(sa) - s\stscol.c(2079)

CT/CS Lib function 'ct_results' failed. Retcode = 0.

E. 2011/09/26 17:42:45. ERROR #1027 USER(sa) - s\stscol.c(2079)

Open Client Client-Library error: Error: 84083974, Severity 5 -- 'ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.

I. 2011/09/26 17:42:48. Command failed: D:\sybase\REP-15_2\ASA11\win32\dbping.exe -q -c "eng=SYB_PRD1_RS_ASA;Language=us_english;CommLinks=tcpip(DOBROAD=NONE;HOST=localhost;PORT=8810)". Operating System returned: Unknown system error '0'

I. 2011/09/26 17:42:48. Starting embedded RSSD: D:\sybase\REP-15_2\ASA11\win32\dbspawn.exe -f -q D:\sybase\REP-15_2\ASA11\win32\dbsrv11.exe -ti 0 -x "tcpip(PORT=8810;DOBROAD=NO;BLISTENER=NO)" -o D:\sybase\REP-15_2\install\SYB_PRD1_RS_ASA.out D:\SYB_PRD1_RS_ASA\SYB_PRD1_RS_ASA.db





This may be due to some permission issue on eRSSD backup-ed file, even Windows setting report correct permission setting.



But, RepServer or ASA "dbbackup" may report an error message or warning message instead of way indefinitely or hanging.



CR:688127
CR Number:   688127
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
chambord EBF3 Fixed
beauregard 07 Dec 2011 Fixed
lelude EBF11 07 Nov 2011 Fixed
Description
The repository cannot use direct driver (DCP) for Oracle 8 and 11.

It only supports 9 and 10.

But users can select Oracle 8 and 11.



CR:688161
CR Number:   688161
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
chambord EBF3 18 Nov 2011 Fixed
beauregard 07 Dec 2011 Fixed
lelude EBF11 07 Nov 2011 Fixed
usse EBF12 Fixed
Description
When creating new repository, we need to create unique clustered index for all unique PK indexes.

When updating an existing repository, we need to change all PK indexes to unique clustered index.



CR:688173
CR Number:   688173
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Fixed
Description
Corrected error message to include the last command processed before error occurred.



CR:688567
CR Number:   688567
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2011 Fixed
16 Nov 2011 Fixed
Description
When a user issues create, alter or drop relication definition command, some memory is not freed at the primary replication server. This can be a problem if large number of create, alter or drop replication definition commands are issued.
Workaround Description
 As suggested in the user doc, when creating/dropping/altering a large number of repdefs, turn off sts_full_cache for rs_objects, rs_columns and rs_objfunctions. This is not for the memory leak issue, but just to make sure the STS cache for a RSSD table is not invalidated for every update to a tables.



Keep the sts_cachesize small (e.g. 100), and set memory_limit to a big number. For creating 17000 repdefs, setting memory_limit to 750 would do. When memory limit is reached, the user has to add more memory or restart RS.



CR:688593
CR Number:   688593
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When creating a new Rep Server and the ASE RSSD already exists, the rs_init panels will hang.
Workaround Description
 Multiple workarounds:

1. Drop the RSSD database prior to doing this work -OR--

2. Use a resource file to rebuild the RS. Here is a sample of my resource file:

sybinit.charset: iso_1

sybinit.language: us_english

sybinit.component_directory: /data/rs1571025/REP-15_5

sybinit.release_directory: /data/rs1571025

sybinit.boot_directory: /data/rs1571025

sybinit.product: rs

sqlsrv.sa_password: USE_DEFAULT

sqlsrv.sa_login: USE_DEFAULT

sqlsrv.master_device_size: USE_DEFAULT

sqlsrv.master_device_physical_name: USE_DEFAULT

sqlsrv.server_name: USE_DEFAULT

sqlsrv.new_config: USE_DEFAULT

rs.rs_operation: rs_install

rs.rs_diskp_lname: p1

rs.rs_diskp_name: /data/rsdev/RS6p1.dat

rs.rs_rssd_log_device_name: RS6_RSSD

rs.rs_create_rssd_log_dev: no

rs.rs_create_rssd_database_dev: no

rs.rs_rssd_db_device_name: RS6_RSSD

rs.rs_create_rssd: yes

rs.rs_rsdddb_size: 40

rs.rs_rssd_log_size: 32

rs.rs_rssd_sqlsrvr: ase157rssd

rs.rs_needs_repagent: yes

rs.rs_requires_ltm: no

rs.rs_idserver_name: RS6

rs.rs_id_server_is_rs_server: yes

rs.do_add_ltm: no

rs.rs_name: RS6

# -END_ATTRIBUTES-



CR:688627
CR Number:   688627
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2011 Fixed
Description
Drop connection does not check for dedicated route using that connection.
Workaround Description
 *** Tue Nov 1 16:18:51 UTC+0800 2011 *** tning ***



User has to manually verify if there is no dedicated route for this connection before dropping it.



select * from rs_routes where source_rsid = <the connection ID as showed in 'admin who'>



CR:688782
CR Number:   688782
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
5126, 5127 and 5128 have the same value for display_name



CR:688969
CR Number:   688969
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2011 Fixed
31 Oct 2011 Fixed
Description
ORACLE ONLY: When Oracle is configured with

duplex online redo log, Replication Agent may

go into the REPLICATION DOWN state due to a

log scanner error stating 'Invalid record

offset with block id <XXX,XXX> and block

offset <XXX> specific on log device <XXX>'

after switching from one redo log member to

another.



CR:689184
CR Number:   689184
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbStream environment="null.null" and dbEvent eventId="0:null" when primary and replication table owners are different.



CR:689260
CR Number:   689260
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2011 Fixed
22 Dec 2011 Fixed
07 Dec 2011 Added to user documentation
Description
dsi_command_convert for table on warm standby does not work.
Workaround Description
 *** Tue Nov 8 22:07:50 UTC+0800 2011 *** tning ***



put owner name in the alter connection command.



{for replicate table named alpha} --> {for replicate table named dbo.alpha}



CR:689318
CR Number:   689318
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2011 Duplicate
Description
Checking in a model containing bullet chars leads to error in Proxy log file:

OdbcError: [S1000] [Oracle][ODBC][Ora]ORA-12899: value too large for column "SYSTEM"."PMXATV"."VALE" (actual: 256, maximum: 254)



CR:689446
CR Number:   689446
Product Name:   Repository
Product Component:   Viewer
Status:   Open
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
Viewer: Unable to view content of repository



conneting as "normal" user (without "Manage all Documents" rights)

-> can not see any documents in Repository Browser



Worked fine with PD 15.3 Viewer



CR:689498
CR Number:   689498
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2012 Fixed
23 Dec 2011 Fixed
09 Jan 2012 Fixed
Description
RSSD stored procedure rs_helpclassfstring returns function string in incorrect order.
Workaround Description
 None



CR:689555
CR Number:   689555
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2012 Fixed
15.7.1 09 Jan 2012 Fixed
08 Jan 2012 Fixed
Description
Subscription materialization from ASE to Oracle fail for numeric datatype column when turning on dynamic_sql or dsi_bulk_copy.
Workaround Description
 alter connection to orcl.orcl set dsi_bulk_copy to 'off'

alter connection to ox11gsdx.ox11gsdx set dynamic_sql to 'off'



CR:689631
CR Number:   689631
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude EBF12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
lelude EBF12 17 Nov 2011 Fixed
usse EBF12 Fixed
chambord EBF3 18 Nov 2011 Fixed
beauregard 07 Dec 2011 Fixed
Description
When using a native driver for repository and there is an error, the error is not handle properly, there is no error message and the checkin is not stopped.



CR:689916
CR Number:   689916
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance rs_delexception processing to prevent filling up the RSSD log when deleting a large transaction.



CR:690069
CR Number:   690069
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add 'find in diagram' functionality for the Portal



customer is asking for a "find object" feature to be added, so that the users who view diagrams through PD Portal can easily locate the objects in the diagram, especially if the diagram is large



CR:690901
CR Number:   690901
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2011 Fixed
16 Dec 2011 Fixed
28 Nov 2011 Fixed
Description
High occurrence of direct query to RSSD table rs_objects when primary and replicate table name are different.



CR:691052
CR Number:   691052
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2012 Insufficient priority to fix
Description
Create connection to Oracle using the rs_ase_to_oracle profile fails.
Workaround Description
 1. Drop the "incomplete" connection

2. Using the maintenance user and maintenance user's password, initialize the Oracle tables by running the $SYBASE/REP-15_2/scripts/legacy/rs1510/hds_oracle_setup_for_replicate.sql against the Oracle database.

3. Create the connection again



The following is correct (even with the error messages):

[sybase@redeye rs1510]$ isql -Uakmaint2 -Psybase -Sox11gsdx -ihds_oracle_setup_for_replicate.sql

Msg 942, Level 16, State 0:

Server 'o3x15e3sdx':

ORA-00942: table or view does not exist

(0 rows affected)

(0 rows affected)

(0 rows affected)

(1 row affected)

(1 row affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

Msg 942, Level 16, State 0:

Server 'o3x15e3sdx':

ORA-00942: table or view does not exist

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

Msg 2289, Level 16, State 0:

Server 'o3x15e3sdx':

ORA-02289: sequence does not exist

(0 rows affected)

Msg 942, Level 16, State 0:

Server 'o3x15e3sdx':

ORA-00942: table or view does not exist

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

(0 rows affected)

[sybase@redeye rs1510]$



CR:691066
CR Number:   691066
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer upgrade doesn't update reigstry entry.



CR:691319
CR Number:   691319
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2011 Fixed
Description
ORACLE ONLY: Replication Agent may suspend with

a log operation sorting error when the Oracle

System Change Number(SCN) rolls over the

n * 0xffffffff boundary.



CR:691494
CR Number:   691494
Product Name:   Rep Serv Troubleshoot Guide
Product Component:   Rep Serv Troubleshoot Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2012 Added to user documentation
Description
Add entry in the Replication Troubleshooting Guide for message when ase_binary_display is set to "on". The setting for replication to IQ should be "off".



CR:691502
CR Number:   691502
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
Prompt does not return when suspending connection after receiving connection is not suspended message.
Workaround Description
 Use another session. The connection is suspended.



CR:692148
CR Number:   692148
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2012 Fixed
03 Aug 2012 Fixed
19 Nov 2012 Fixed
14 Jan 2013 Fixed
14 Jan 2013 Fixed
Description
Better handling of error messages from stored procedures and DDL for error action handling.



CR:692451
CR Number:   692451
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide message in the RS log that says when transaction is removed from sqt cache
Workaround Description
 Monitor and Counter



CR:692606
CR Number:   692606
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DSI error doesn't report actual error 2601 message from ASE



CR:692608
CR Number:   692608
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer is requesting to view the full name of a login in Portal's Group Member page. In their implementation, the logins consist of initials and numbers(cryptic). When attempting to add logins\users to a group, it is difficult to identify a specific login\user.



The page that customer is referring to can be accessed via

1) Log into Portal

2) Click Users and Groups from Portal menu

3) Click Groups from the the tree on left pane

4) Click on a Group name (i.e. ADMN)

5) Click on Members tab within the Group

6) The Members pane only shows Name (login) and Realm



CR:692609
CR Number:   692609
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 13 Dec 2011 Fixed
15.6 ESD #2 18 Dec 2011 Fixed
5.8.30 18 Dec 2011 Fixed
Description
Null value is replicated

for LOB that is not enabled for replication.



CR:692621
CR Number:   692621
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2012 Duplicate
Description
RS stack with dsi_command_convert on with replicate minimal columns on the replication definition
Workaround Description
 alter replication definition to replicate all columns instead of replicate minimal columns

--or--

remove the row for the dsi_command_convert from the rs_config file

--or--

bring up the RS in single user mode, alter the connection to set dsi_command_convert to none, bring down the RS and bring up RS in normal mode.

--or--

purge the queue (bring up RS in standalone mode, either zap the command or purge the queue, then take down RS and bring back up in normal mode)



CR:692722
CR Number:   692722
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   usse EBF11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with:



PD 15.2 EBF#11

MS SQL Server 2008 as backend

PD using Native SQL connection to Repository (SQL Native Client)



This is a consult CR from Itau-Unibanco



Currently, customer delays around 50 seconds to connect to Repository. We confirmed all patches, indexes recreations etc. (from previous cases) were applied successfully into Repository.

Customer is asking if there's any extra recommendations to improve this connection time to repository.



CR:692723
CR Number:   692723
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   usse EBF11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2012 Fixed
Description
Tested and reproduced with:



PD 15.2 EBF#11

MS SQL Server 2008 as backend

PD using Native SQL connection to Repository (SQL Native Client)



This is a consult CR from Itau-Unibanco



Currently, customer delays around 50 seconds to connect to Repository. We confirmed all patches, indexes recreations etc. (from previous cases) were applied successfully into Repository.

Customer is asking if there are any extra recommendations to improve this connection time to repository.



CR:692764
CR Number:   692764
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In a warmstandby with no other replicate db's, the drop connection should go as fast as possible. At a minimum, it should happen faster than the time it takes to purge the queue.



CR:692807
CR Number:   692807
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
Description
This EBF replaces Replication Server 15.6 with Replication Server 15.7 in

Replication Server - Real Time Loading Edition 15.6 and Replication Server Heterogeneous Edition 15.6.



CR:692893
CR Number:   692893
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2012 Fixed
23 May 2012 Added to user documentation
Description
RS does not pad zeros in microseconds when the primary is in milliseconds
Workaround Description
 Never update timestamps on IQ side directly.

Materialize manually affected tables with insert-location, asking for proper varchar conversion as described in CR description.



CR:692900
CR Number:   692900
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2012 Fixed
Description
When encryp on in ASE and RS trans not getting executed causing DSI down

see the select statement

A0157 04utf8distribute 2 ~"!,3 5 sqlddl append first last ~#"Zselect s

et_enc_password(0xc007caaa89d95f60fd20ac92a3c03206e48e9aeb7912465b7aafb

752babaa42de30bc66af414bc2817c8, 'jstask')



CR:693105
CR Number:   693105
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2012 Fixed
15.7.1 09 Jan 2012 Fixed
Description
Translation from rs_rs_datetime with mask 'CCYYMMDD hh:mm:ss:ttt' to datetime will crash RS.



CR:693202
CR Number:   693202
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
Description
This CR is opened to serve as a place holder in the STAR release system for posting the Replication Manager 15.7 as an ESD release for Replication Server - Real Time Loading Edition 15.6 and Replication Server Heterogeneous Edition 15.6.



CR:693388
CR Number:   693388
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 18 Dec 2011 Fixed
15.6 ESD #2 18 Dec 2011 Fixed
15.2 ESD #4 19 Dec 2011 Fixed
Description
ORACLE ONLY:

Replication Agent 15.7

for Oracle allows user

to mark table contains UROWID

column through 'force' option,

but UROWID column itself

will always be filtered.

This functionality is also

merged to 15.6 and 15.2.



CR:693676
CR Number:   693676
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2012 Fixed
21 Feb 2012 Fixed
10 Jan 2012 Fixed
08 Mar 2012 Fixed
13 Apr 2012 Fixed
Description
With the combination of minimal columns in the replication definition and HVAR on replicate connection, if within the same compile, an update to a row not including a change to a column is followed by another update to the same row setting the column to null, the column will not be set to null. This issue also exists for IQ replicate connections.
Workaround Description
 Alter the replication definition to replicate all columns.



CR:693754
CR Number:   693754
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2012 Fixed
Description
ORACLE ONLY: Replication Agent fails to support

configuration parameter lr_ntext_byte_order.



CR:693901
CR Number:   693901
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2012 Fixed
Description
Model with re-arranged synbols is updated into the repository.

New values of Position, Relation Position and Size have not been saved.

Compare local model with Repository keeps detecting differences.



CR:694429
CR Number:   694429
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 10 Jan 2012 Fixed
15.7.1 15 Feb 2012 Fixed
15.7.1 13 Mar 2012 Fixed
Description
FOR ORACLE AND IBM DB2 ONLY:

Prevention for

1)Oracle compressed table

prior to Oracle 11gR2;

2)Oracle encrypted column and

tablesapce prior to Oracle

11gR1;

3)Oracle secure file LOB prior

to Oracle 11gR2;

4)DB2 row compressed table prior

to DB2 v9.7.



CR:694510
CR Number:   694510
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2012 Fixed
09 Feb 2012 Fixed
13 Apr 2012 Fixed
27 Apr 2012 Fixed
08 Jun 2012 Fixed
Description
Introduce randomization in TDS login protocol



CR:694580
CR Number:   694580
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2012 Fixed
Description
admin config does not display values for dist_sqt_max_cache_size.
Workaround Description
 read the value off the rs_config file in the RSSD



CR:694583
CR Number:   694583
Product Name:   RepAgent for MVS
Product Component:   RepAgent for MVS - DOC
Status:   Open
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Document the License_Key parameter in the LTMCFG manual.



CR:694733
CR Number:   694733
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2013 Fixed
Description
S0C4 with some operator commands.



CR:694844
CR Number:   694844
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2012 Fixed
09 Jan 2012 Fixed
Description
When HVAR is turned on and tempdb is full on replicate connection, some data can be lost.



CR:695313
CR Number:   695313
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
beauregard EBF1 17 Jan 2012 Fixed
Description
Setup repository with ASA, PMTEMP, PMTEMP2... are temporary table, cmr can not detect;

Repository can not be shown, can not create user.

Setup repository with other databases, PMTEMP, PMTEMP2... are not temporary table, it works OK.
Workaround Description
 run the following script on the database



drop table "PMTEMP";

drop table "PMTMP2";

drop table "PMTMP3";

drop table "PMTMP4";



create table PMTEMP

(

SESS int not null,

NUM1 int null,

NUM2 int null,

NUM3 int null,

NUM4 int null,

NUM5 int null,

NUM6 int null,

NUM7 int null,

STR1 varchar(254) null,

STR2 varchar(254) null

)

;



create index PMTEMP_SESS on PMTEMP (SESS, NUM1)

;



create index PMTEMP_NUM2 on PMTEMP (SESS, NUM2)

;



create index PMTEMP_NUM3 on PMTEMP (SESS, NUM3)

;



create table PMTMP2

(

SESS int not null,

NUM1 int null,

NUM2 int null,

NUM3 int null,

NUM4 int null,

NUM5 int null,

NUM6 int null,

NUM7 int null,

STR1 varchar(254) null,

STR2 varchar(254) null

)

;



create index PMTMP2_SESS on PMTMP2 (SESS, NUM1)

;



create index PMTMP2_NUM2 on PMTMP2 (SESS, NUM2)

;



create index PMTMP2_NUM3 on PMTMP2 (SESS, NUM3)

;



create table PMTMP3

(

SESS int not null,

NUM1 int null,

NUM2 int null,

NUM3 int null,

NUM4 int null,

NUM5 int null,

NUM6 int null,

NUM7 int null,

STR1 varchar(254) null,

STR2 varchar(254) null

)

;



create index PMTMP3_SESS on PMTMP3 (SESS, NUM1)

;



create index PMTMP3_NUM2 on PMTMP3 (SESS, NUM2)

;



create index PMTMP3_NUM3 on PMTMP3 (SESS, NUM3)

;



create table PMTMP4

(

SESS int not null,

NUM1 int null,

NUM2 int null,

NUM3 int null,

NUM4 int null,

NUM5 int null,

NUM6 int null,

NUM7 int null,

STR1 varchar(254) null,

STR2 varchar(254) null

)

;



create index PMTMP4_SESS on PMTMP4 (SESS, NUM1)

;



create index PMTMP4_NUM2 on PMTMP4 (SESS, NUM2)

;



create index PMTMP4_NUM3 on PMTMP4 (SESS, NUM3)



CR:695690
CR Number:   695690
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2012 Fixed
09 Mar 2012 Fixed
18 Apr 2012 Fixed
Description
With hvar and RTL, the server can hang or the DSI can stop if there are two repdefs to the same replicate table and the list of columns is different.
Workaround Description
 Check if there are multiple repdefs defined for a table and if the columns are consistent in the repdefs.



CR:695845
CR Number:   695845
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Fixed
Description
ref_objowner and ref_objname are used for RI constraints on columns in the replication definition.



CR:695876
CR Number:   695876
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2012 Fixed
Description
Customize Comparison Options while merging models and save them by clicking ' Set as Default'.

Update a document version, 'Check out after check in' does not check out recent objects so the local version is not up-to-date.

This does not happen if custom Comparison Options are not set by default.



CR:696035
CR Number:   696035
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2012 Fixed
23 May 2012 Added to user documentation
15.7.1 14 May 2012 Added to user documentation
16 May 2013 Fixed
04 Jun 2013 Added to user documentation
Description
With the 1571sp101 release seamless upgrade for oracle is now supported. To accomplish this upgrade follow these steps. 1) After you upgrade the Replication Server to v1571SP101 or later, the server will suspend the replicate connections to the Oracle replicate databases. At this point, you will see a "Awaiting Upgr" status when you use admin who. 2) You can then upgrade the Oracle database using one of these two methods:

2a) Issue "repserver -upgr" will upgrade Replication Server at the same time or

2b) Issue "sysadmin upgrade,'database'" after upgrading Replication Server with rs_init or repserver with the -nodb option.
Workaround Description
 Workaround for CR696035-4:

exclude your oracle user databases from seamless upgrade command by "repserver -upgr -nodb <oracle_user_db_id>" and load the oracle upgrade scripts manually, for details please refer to "configuration guide-> Upgrading Replication Server-> Upgrading Non-ASE User Databases and User Databases Not Supported by sysadmin upgrade".



CR:696238
CR Number:   696238
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Fixed
23 May 2012 Added to user documentation
Description
since "block_size" feature was introduce, the size of a Partition (Stable Device) may use the unite of "Number of Segment" instead of "megabytes".



CR:696282
CR Number:   696282
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2012 Duplicate
Description
RS stack on fstr__pak_no_repdef with multiple table replication definitions.
Workaround Description
 drop "duplicate" replication definitions. In this case it was possible as the only difference was send sendby clause.



CR:696324
CR Number:   696324
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Running concurrent 'resume connection' commands for 2 different DSIs causes a deadlock in the RSSD.



CR:696363
CR Number:   696363
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Microsoft Windows
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Attempting to add database connection with name greater than 20 characters causes rs_init to crash.
Workaround Description
 use isql and 'create connection' command



CR:696368
CR Number:   696368
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 18 Jun 2013 Added to user documentation
Description
For HVAR and RTL, if there are multiple unique keys at the replicate, the replication definition should contain all columns which are named in the unique indexes.



CR:696379
CR Number:   696379
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2012 Fixed
Description
Confusion between the word "type" and "platform". RAX needs to be on the same platform as the Oracle log.



CR:696489
CR Number:   696489
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Not a Bug
Description
admin config does not display dsi_cdb_max_size
Workaround Description
 select the information out of the RSSD:



1> connect to rssd

2> go

Gateway connection to 'spotak1503i.spotak1560rep_RSSD' is created.

1> select * from rs_config where optionname like "%dsi_cdb_max_size%"

2> go

optionname objid

charvalue



status

comments



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

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

---------

------

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

---------

dsi_cdb_max_size 0x0000000000000000

1024



0





dsi_cdb_max_size 0x0000008a00000000

1024



0







(2 rows affected)



CR:696620
CR Number:   696620
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2013 Fixed
01 Jul 2013 Fixed
Description
A function string error is displayed in RS log when logging a rs_ticket transaction.
Workaround Description
 None for the RS log. Look in rs_helpexception for the properly displayed command.



CR:696675
CR Number:   696675
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2012 Fixed
08 Mar 2012 Fixed
14 Apr 2012 Fixed
Description
Constraint violation at replicate DB and HVAR retried transaction in language mode,

giving the following situation (with replicate minimal column and groupid is not a primary key column on the child table):



parent table:

insert into groupid values (1)

insert into groupid values (2)



Child table (groupid column on child table has RI on the groupid table)



update locid set groupid = 2 where groupid = 1



Parent table:

delete groupid = 1



This will work at the primnary. However, with hvar, update locid will continue to be a update due to minimal columns and the fact that groupid is not named as a primary key column. Since HVAR always applies deletes before updates, the delete fails with constraint violation, which therefore makes the entire transaction to be applied by language.
Workaround Description
 Include the foreign key column as primary key in repdef.



CR:696792
CR Number:   696792
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2012 Fixed
28 Sep 2012 Fixed
Description
Provide capability to capture data from either queue or cdb before the DSI reverts to language mode for hvar or rtl.



CR:696925
CR Number:   696925
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ ticket_history_table has incorrect table definition for exec_b, rsi_b, dsi_tnx, dsi_cmd.
Workaround Description
 change the declaraction of columns exec_b, rsi_b, dsi_tnx, dsi_cmd from integer to numeric (22,0)



CR:697071
CR Number:   697071
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For inserts made by the source (versus dsi_command_convert), allow option to ignore constraint checking.



CR:697545
CR Number:   697545
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2012 Fixed
23 Mar 2012 Fixed
11 Mar 2012 Fixed
15.6 ESD#2 11 Mar 2012 Fixed
Description
The CR fixed the memory leak when transactions are selected for bulk copy when hvar and RTL are not used.
Workaround Description
 Reboot the Replication Server



CR:698023
CR Number:   698023
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 31 Mar 2012 Fixed
Description
For internal use only (developer finded):

ORACLE ONLY: Replication Agent sent

duplicated locator to Replication server

when handle insert with LOB/long data type.



CR:698062
CR Number:   698062
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2012 Fixed
Description
Monitor Latency for Paths (rs_ticket) only allows 7 days.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复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
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

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