Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

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.