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

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

CR:708573

CR Number:   708573 Product Name:   Sybase Replication Server Product Component:   rs_init Status:   Closed OS:   Red Hat Linux Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2012 Fixed Description Core dump is encountered in rs_init interactive mode when using an unrecognized character set.

CR:708629

CR Number:   708629 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   HP-UX Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2012 Fixed 15.7.1 17 Aug 2012 Added to user documentation Description ORACLE ONLY: For Oracle 11.2, Replication Agent goes to REPLICATION DOWN state when replicating SecureFile LOB. Workaround Description  Contact the Sybase Tech Support if already enable replication of tables with SecureFile LOB option enabled.

CR:708776

CR Number:   708776 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) 25 May 2012 Fixed Description In a warm standby environment, if the active ASE server is inaccessible to the RS server, then when a warm standby switch is initiated with the execution of the RS command 'switch active', the warm standby switch fails to complete. Workaround Description  Please follow the steps exactly, substitute <...> with the right IDs in your system. Initially, "admin logical_status should return the following: 1> admin logical_status 2> go Logical Connection Name Active Connection Name Active Conn State Standby Connection Name Standby Conn State Controller RS Operation in Progress State of Operation in Progress Spid --------------------------------------------------------------------------- --------------------------------------------------------------------------- ------------------------------------------------------------- --------------------------------------------------------------------------- ------------------------------------------------------------- --------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ----- [102] PDS1.pdb1 [103] ost_replnxb15_23.pdb1 Suspended/ [104] ost_replnxb15_46.pdb1 Suspended/ [16777317] ost_replnxb15_56 Switch Active Connection to ost_replnxb15_46.pdb1 in progress Switch waiting for connection to standby 0073 Note down your logical dbid, old active dbid, new active dbid in the output above. In the example here, logical_dbid=102, old_active_dbid=103, new_active_dbid = 104. Connect to RSSD and ensure that the following returns the value 10: 1> select state from rs_recovery where seqnum = <logical_dbid> and action = 8 2> go state ----------- 10 (1 row affected) Connect to the new active database as sa or maintenance user and issue: 1> rs_syncup_lastcommit <new_active_dbid>, <old_active_dbid> 2> go Set truncation point at the new active database: 1> dbcc settrunc('ltm','end') 2> go Connect to RSSD and issue: 1> select id from rs_recovery where seqnum = <logical_dbid> and action = 8 2> go id ------------------ 0x0100006500000066 (1 row affected) Take the last 4 bytes (00000066) and convert to int (0x66=102). This is the sequence_number Connect to the new active DB and issue: rs_marker "enable replication from <new_active_dbid> to <old_active_dbid> seq <sequence_number>" Connect to RSSD: 1> update rs_recovery set state = 25 where seqnum = <logical_dbid> and action = 8 2> go Restart repserver. Switch should finish in a few minutes. Look for the following in the log: I. 2012/05/22 15:45:40. Resuming LogTransfer for ... I. 2012/05/22 15:45:40. Switch completed : PDS.pdb1 Restart rep agent for the new active if it is down. Look for the following in the log: I. 2012/05/22 16:15:33. Distributor for 'PDS.pdb1' received and proceessed enable marker. Distributing commands to replicates "admin logical_status" should return: [103] PDS.pdb1 [104] ost_replnxb15_01.pdb1 Active/ [105] ost_replnxb15_03.pdb1 Suspended/Waiting for Enable Marker [16777317] ost_replnxb15_60 None None The switch is complete at this point. After the old active is restarted and DSI is started, "admin logical_status" should return: [103] PDS.pdb1 [105] ost_replnxb15_03.pdb1 Active/ [104] ost_replnxb15_01.pdb1 Active/ [16777317] ost_replnxb15_60 None None

CR:708924

CR Number:   708924 Product Name:   Repository Product Component:   Repository Status:   Closed OS:   Microsoft Windows 2003 Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) cheverny 27 Jul 2012 Fixed beauregard EBF7 27 Jul 2012 Fixed Description Product: PD 16.1 EBF#4 Repository on MS SQL Server 2008 Issue description: Our customer is now using PD 16.1 EBF#4. He's using LDAP authentication for the repository connection. They are not using SSL. The issue is: on PD Portal, he connects fine. On PD itself, the connection fails

CR:708933

CR Number:   708933 Product Name:   Repository Product Component:   Repository Status:   Open OS:   all Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add feature to customize how repository contents are displayed in the Browser. Customer's text: In the repository we must to be able to create user VIEW following different perspective. Currently PowerDesigner allows to group objects by Branches and Folders and present them in that form. It would be advantageous to keep the actual physical structure but also provide the ability to group objects and display objects in other VIEWS. We would like create different perspective (outlook, context), examples : view "List of objects associated with a user" view "List of conceptual models" View "List of projects having working on this subject", etc.

CR:709328

CR Number:   709328 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Generic Original Version:   15.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2012 Fixed 20 Dec 2012 Fixed Description High occurrence of direct query to RSSD table rs_databases when "save_interval" is set at replicate and Outbound Queue have Segments saved by this feature.

CR:709379

CR Number:   709379 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Unknown Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2012 Fixed Description When using eRSSD, after altering the RSSD primary/maintenance user password, the RS cores on attempt to restart. (Using RSSD has no such issue)

CR:709381

CR Number:   709381 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Unknown Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2012 Fixed Description After alter primary user password, repserver cannot shutdown or restart dbltm. It will keep trying to start and all attempt will fail. Users have to shutdown repserver, kill the dbltm process, and restart repserver in order to work around this.

CR:709461

CR Number:   709461 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Linux Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jul 2012 Fixed 02 Jul 2012 Fixed 03 Jul 2012 Fixed 28 Aug 2012 Fixed Description RTL: When using RTL to replicate updates to ASE float columns to IQ double columns, precision may be truncated for some values after 8 or 9 significant digits. Workaround Description  Avoid using float datatypes if at all possible. Or, replace Update with delete/insert using: alter connection to IQSRVR.iqdb for replicate table named dbo.'floatTest' set dsi_command_convert to 'u2di'

CR:709623

CR Number:   709623 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   HP-UX Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2012 Fixed Description ORACLE ONLY: Replication Agent fails to replicate a rollback.

CR:709712

CR Number:   709712 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Linux Original Version:   15.6 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2012 Fixed 11 Jul 2012 Fixed Description Suppose there are more than one replication definitions for a primary table. When the repdef marked for standby is altered, the internal replication definition associated with it is also altered. If there is data in the inbound queue for the old internal replication definition version, DSI would go down with something like " ERROR #50 DSI EXEC(700(1) SYBOLTPWS.VBDMASTR) - /nrm/nrm.c(733) 'rs_objects' system table is corrupt." Workaround Description  In the RSSD of the primary repserver, issue, update rs_objects set phys_tablename = deliver_as_name where deliver_as_name = '<the name of the table in question>' and objname like 'rs_indrp%' In the repserver which controls the DSI, issue sysadmin stscache,invalidate,"rs_objects" resume connection to <ds name>.<db name>

CR:709823

CR Number:   709823 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   AIX Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2014 Fixed Description Instrumentation to help determine why block consistency failed in 15.6 Workaround Description  upgrade to rs 15.7.1

CR:710095

CR Number:   710095 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 20 Jun 2013 Fixed Description Resetting the erssd transaction log also requires issuing dblog -t after the dblog -il step

CR:710230

CR Number:   710230 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Unknown Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2012 Fixed Description Repserver stops replication for error 13900. It should be ignored.

CR:710410

CR Number:   710410 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Unknown Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2012 Fixed 16 Aug 2012 Fixed 18 Jul 2012 Fixed Description For a varbinary column, if the data has trailing zeros, the trailing zeros are stripped off when bulk or hvar is on.

CR:710711

CR Number:   710711 Product Name:   Sybase Replication Server Product Component:   rs_subcmp Status:   Closed OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2012 Fixed 24 Jul 2012 Fixed 26 Jul 2012 Fixed Description Utility rs_subcmp pads varbinary values when comparing and does not differentiate between values with different lengths of trailing zeroes.

CR:710943

CR Number:   710943 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2012 Fixed 03 Feb 2013 Fixed Description In warm standby replication, when a table is defined with a identity column and its table replication definition is defined with 'send standby all columns' without the identity column, DSI will shutdown when replicate to standby database as identity insert is not set to 'on' when inserting a row. Workaround Description  *** Wed Jun 13 2012 11:23:29 GMT+0800 (China Standard Time) *** tning *** Add the identity column into repdef.

CR:711274

CR Number:   711274 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) 22 Jun 2012 Not a Bug Description A setting of on for parallel_dsi configures these values: dsi_num_threads to 5 dsi_num_large_xact_threads to 2 dsi_serialization_method to wait_for_commit dsi_sqt_max_cache_size to 1 million bytes (on 32-bit platform)and 20 million bytes (on 64-bit platform). With wait_for_commit, DSI will send the next transaction when the previous transaction is ready to commit, but has not finished commit, it may cause data inconsistency at replicate site. An example is: Step 1. thread 1: begin tran, insert into table A Step 2. thread 2: begin tran, delete the row thread 1 just inserted Step 3. thread 1: commit Step 4. thread 2: commit The delete at step 2 will affect 0 rows, since the insert at step 1 is not committed yet, leaving the row at replicate database. Workaround Description  After setting parallel_dsi to "on", set: - dsi_serialization_method to wait_after_commit - dsi_num_large_xact_threads to 0

CR:711507

CR Number:   711507 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) 30 Jul 2012 Fixed Description In rare circumstances, the error message "(HQ Error) Column 'xxx' is missing in target table" is logged in Replication Server errorlog. This is leading HVAR to retry the transaction. However, as the error is rare and random, the retry attempt succeeds most of the times.

CR:712152

CR Number:   712152 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description HQCPL error pkey display is not accurate to the primary key of the repdef -- cannot tell what the real problem is. Workaround Description  none

CR:712153

CR Number:   712153 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2012 Fixed Description RS stack with ll_first and dsi_validate_row_count Workaround Description  none that we are aware of at this time (dsi_row_count_validation was off on this connection at the time of the signal 10)

CR:712288

CR Number:   712288 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   AIX Original Version:   15.6 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2012 Fixed 01 Jul 2012 Fixed 03 Jul 2012 Fixed 02 May 2013 Presently Not Targeted For Any Future Release Of This Product Description Turning on dsi_workload counter gives Failed to assert '!((pEntry->obj_stats).statsi_cnt_info[(12)].cnti_status & 0x010)' at 11263, 'eneric/dsi/dsiexec.c'.

CR:712664

CR Number:   712664 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   SunOS Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2012 Fixed Description Status of DSI is "Awaiting Upgr" after connection has completed upgrade.

CR:712718

CR Number:   712718 Product Name:   Replication Management Product Component:   Web UI Status:   Closed OS:   Windows XP Pro Original Version:   3.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2013 Fixed 06 Aug 2012 Added to user documentation 06 Aug 2012 Added to user documentation Description Replication Server collections fail if the server contains no routes

CR:712866

CR Number:   712866 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   AIX Original Version:   15.6 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RS stack with ll_del and sqt_read_from_cache. Workaround Description  run the .diag binary and possibly increase sqt cache.

CR:712913

CR Number:   712913 Product Name:   Sybase Replication Server Product Component:   scripts Status:   Open OS:   Linux Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2012 Fixed Description rs_init may get a duplicate key error "Attempt to insert duplicate key row in object 'rs_profdetail' with unique index 'rs_key_profdetail'" and upgrade fails when you try to upgrade Replication Server 15.7 to 15.7.1. Workaround Description  In rs_ase_to_oracle_eco.sql: Change the line: delete from rs_profdetail where profid = 0x000000000e010000 and pdetailid = 0x000000000e010042 to delete from rs_profdetail where profid = 0x000000000e010000 and sequence = 67

CR:713269

CR Number:   713269 Product Name:   Repository Product Component:   Repository Status:   Closed OS:   XP Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) beauregard EBF9 24 Sep 2012 Fixed Description Using the proxy, the customer is getting intermittent errors when checking in a 40 MB PDM and a 20 MB LDM. PD is currently in a lab environment. The Proxy and SQL Server database are on different hosts. The Proxy is on a VM and the SQL Server instanced is on a shared host. In preparation, they began to perform load and stress testing with the repository and have run into the issue that follows. During a load and stress testing exercise, most models check-in and checkout without issue. However, when performing multiple check-in\outs with their large models, they receive the following errors at different points. fatal - Exception caught in OnReceive OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server. OdbcError: [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. OdbcError: [08S01] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. OdbcError: [24000] [Microsoft][ODBC SQL Server Driver]Invalid cursor state OdbcError: [08S01] [Microsoft][ODBC SQL Server Driver]Communication link failure NOTE: the proxy log includes information for multiple versions of the proxy. When these errors occur, they encounter deadlocks on SQL Server.

CR:713271

CR Number:   713271 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) 20 Mar 2014 Added to user documentation Description LOB information in RS Admin Guide Vol 1 is specific to MS SQL and should go into the Heterogeneous manual.

CR:713453

CR Number:   713453 Product Name:   Sybase Replication Server Product Component:   rsmclient Status:   Open OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RSM - Connection Properties, the Error Class is showing incorrect value

CR:713479

CR Number:   713479 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2012 Fixed Description ORACLE ONLY: When Replication Agent is initialized, issuing 'pdb_xlog deinit, force' returns success when an error message is expected.

CR:713575

CR Number:   713575 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Generic Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2012 Fixed 17 Jul 2012 Fixed Description HVAR: DSI may shutdown when there is non-compilable command which updates text/image to NULL, and the text/image value length is bigger than 32K or it is compressed.

CR:713596

CR Number:   713596 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/MsSQL Status:   Closed OS:   Generic Original Version:   6.0.16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 6.0.18 03 Sep 2012 Fixed 15.7.1 ESD #3 15 Jan 2013 Fixed 22 Jul 2013 Insufficient priority to fix Description MICROSOFT SQL SERVER ONLY: Replication Agent goes down with a NoSuchElementException error when replicating LOB data.

CR:713649

CR Number:   713649 Product Name:   Common Metadata Repository Product Component:   Web UI Status:   Open OS:   Windows Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description the diagram should be "accessible" by the user by - PDF export or - print function which prints the diagram as whole ( which may result in PDF also )

CR:713651

CR Number:   713651 Product Name:   Common Metadata Repository Product Component:   Web UI Status:   Open OS:   Windows Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The bottom line should (including your copyright informations) scale automatically with the hight of the browser window - or should be set by a user parameter to be able to use the full available space

CR:713694

CR Number:   713694 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.6.0.6010ESD01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2012 Presently Not Targeted For Any Future Release Of This Product Description Request better handling of Oracle rebalance in asm diskgroup.

CR:713697

CR Number:   713697 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2012 Fixed 31 Jul 2012 Added to user documentation 12 Sep 2012 Diagnostic Provided Description ORACLE ONLY: Replication Server's duplicate count increases unexpectedly because Replication Agent generates three LTL commands for a single update to an Oracle table with a column of type Object. Workaround Description  For objecttype_rep.tcf{30} in LTL one update in the test has the RAO processing one update as three updates (same update executed 3 times). Not sure if related, in LTL with insert the qauser is prefix with BI, on update it is prefix with BD so the same t_type value has its prefix changed. In RS log looks like the update is not correctly processed: T. 2012/07/06 12:03:43. (31): Command(s) to 'o102rh1b.o102rh1b': T. 2012/07/06 12:03:43. (31): 'update qaquser.qaq_table set t_type=[000000000000 0000000000000000000000000000000000000000000000000000000000] where pkey=2 ' T. 2012/07/06 12:03:43. (31): Last command to 'o102rh1b.o102rh1b': T. 2012/07/06 12:03:43. (31): Output command: update qaquser.qaq_table set t_typ e= I. 2012/07/06 12:03:43. Message from server: Message: 936, State 0, Severity 5 - - '[ statement ][ o102rh1b ] ociStmt::Execute ORA-00936: missing expression '. H. 2012/07/06 12:03:43. THREAD FATAL ERROR #5049 DSI EXEC(104(1) o102rh1b.o102rh 1b) - dsiqmint.c(4413) The DSI thread for database 'o102rh1b.o102rh1b' is being shutdown. DSI r eceived data server error #936 which is mapped to STOP_REPLICATION. See logged d ata server errors for more information. The data server error was caused by outp ut command #0 mapped from input command #2 of the failed transaction. I. 2012/07/06 12:03:43. The DSI thread for database 'o102rh1b.o102rh1b' is shutd own. I. 2012/07/06 12:04:07. The DSI thread for database 'o102rh1b.o102rh1b' is start 1. Versions Instance: RQAV5_21920_RA - Oracle RepAgent: Sybase Replication Agent for Unix & Windows/15.7.1.6120ESD01/P/generic/ JDK 7.0/main/6120ESD01/VM: Sun Microsystems Inc. 1.6.0_33/OPT/Fri Jun 2 2 14:31:22 MDT 2012 JRE: Sun Microsystems Inc. Java(TM) SE Runtime Environment/1.6.0_33-b03/Linu x 2.6.18-53.el5/amd64/64 RASD: SQL Anywhere/12.0.1.3152/UNIX Primary Data Server: Oracle Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi t Production With the Partitioning, OLAP and Data Mining options PDS JDBC Driver: Oracle JDBC driver 11.1.0.6.0-Production RepServer: Replication Server/15.7.1/P/Linux AMD64/Linux 2.6.18-128.el5 x86_64/1/O PT64/Sun May 13 18:22:06 2012 RSSD: SQL Anywhere/12.0.1.3152/UNIX Sybase JDBC Driver: jConnect (TM) for JDBC(TM)/7.07 ESD #3(Build 26728)/P/EBF20021/JDK 1.6. 0/jdbcmain/OPT/Mon Mar 19 09:14:34 PDT 2012 (9 rows affected) 1> 2. LTL 5 begin transaction for ~"(QAQUSER osid 140 distribute @origin_qid=~,A{0x}00000000011e576700000001000017da000000cb0018000001 1e576600000001,@origin_time=~*620120706 12:03:33:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57660006000b00001b5 5 applied owner=~"(qaquser ~"*qaq_table.rs_insert yielding after ~$'t_type=~BIQ AQUSER.QAQ_OBJ(10, 'Leonardo da Vinci'),~$%pkey=~%"2 distribute @origin_qid=~,A{0x}00000000011e576700000001000017da000000cb0018000001 1e576600000002,@origin_time=~*620120706 12:03:33:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57660006000b00001b5 5 commit transaction distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001 1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0 5 begin transaction for ~"(QAQUSER osid 140 distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001 1e576900000001,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0 5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2 after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton') distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001 1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0 5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2 after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton') distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001 1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0 5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2 after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton') distribute @origin_qid=~,A{0x}00000000011e576a00000001000017da000000cd0094000001 1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355 f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0 5 commit transaction 3. Repro: /RAO/cases/ora_type/objecttype_rep.tcf{30}

CR:713908

CR Number:   713908 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/MsSQL Status:   Closed OS:   Microsoft Windows NT Original Version:   6.0.15 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2012 Presently Not Targeted For Any Future Release Of This Product 6.1.21 23 Aug 2012 Fixed To Be Determined 22 Jul 2013 Insufficient priority to fix 15.7.1 ESD #3 08 Mar 2013 Fixed Description MICROSOFT SQL SERVER ONLY: You can encounter deadlocks on the Replication Agent DDL table at the primary database when more than one DDL operation is executed in parallel. Workaround Description  Do not process "update statistics" and "drop table" in parallel.

CR:713962

CR Number:   713962 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2012 Fixed 21 Aug 2012 Fixed Description Replication to IQ not going as fast as expected. In an environment with only one DSI executor thread, the current group algorithm with SQT cache size as a parameter has a defect, which generates single transaction group.

CR:714035

CR Number:   714035 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   NA Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2012 Fixed 26 Jul 2012 Fixed Description When DSI Bulk Copy or HVAR is enabled, the data is always replicated as OFF ROW when it is configured as IN-ROW in the replicate database. Target Version  15.7.1 ESD #1

CR:714114

CR Number:   714114 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Generic Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2012 Fixed 07 Mar 2014 Fixed Description LOB column got incorrectly changed to NULL when applying multiple updates to the non-LOB column of same row. Workaround Description  make the affected table as non-compilable.

CR:714201

CR Number:   714201 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) 12 Jul 2012 Fixed Description ORACLE ONLY: Two files that are needed for upgrade/downgrade are missing from the Replication Agent installation.

CR:714328

CR Number:   714328 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Open OS:   Generic Original Version:   15.6.0.6000 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When restoring to a previous backup of Oracle, make Replication Agent make the process to start replication from those tables, faster. Workaround Description  If one has a coordinated RASD, one can do the pdb_xlog init, force to update just the user information of the current Oracle. However, if any of the Oracle object ids have changed (e.g. drop or create table, or certain DDL operations), then the only way around this if one doesn't know the tables, would be to pdb_xlog remove,force then pdb_xlog init and then remark all the tables.

CR:714558

CR Number:   714558 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2012 Fixed 21 Aug 2012 Fixed Description RS stack with lll_del_second and mem_free Workaround Description  none

CR:714621

CR Number:   714621 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   AIX Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7.1 ESD #2 29 Aug 2012 Fixed 31 Jul 2012 Added to user documentation Description ORACLE ONLY: Replication Agent becomes unresponsive after execution of the pdb_get_columns command. Workaround Description  Be sure to initialize RepAgent (ra_init) prior to making any of the rsm calls.

CR:714775

CR Number:   714775 Product Name:   Real Time Data Services - RepConnector Product Component:   RepConnector Docs Status:   Closed OS:   Generic Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2013 Added to user documentation Description DOCS: add RepServer DSI parameters not usable with RepConnector: "dynamic_sql", "dsi_bulk_copy", "dsi_row_count_validation".

CR:714854

CR Number:   714854 Product Name:   Repository Product Component:   Repository Status:   Closed OS:   all Original Version:   lelude Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2012 Fixed Description Repository: Order of columns has changed after check out - mapping involved. Workaround Description  When updating the model, check the 'Create baseline version' option.

CR:714901

CR Number:   714901 Product Name:   Repository Product Component:   Repository Status:   Closed OS:   all Original Version:   chambord Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2012 Not a Bug Description Cannot check out glossary anymore -- check in of model has been cancelled

CR:714923

CR Number:   714923 Product Name:   Rep Serv Commands Ref Product Component:   Rep Serv Commands Ref Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2013 Fixed Description value for rs_recovery.action is incomplete

CR:714932

CR Number:   714932 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Generic Original Version:   15.6 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description database repdef with a helping repdef that does not have the image column, will suspend the DSI. Workaround Description  use table replication/subscription on this table or add the clause "send standby all columns" to the repdef.

CR:715056

CR Number:   715056 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   Management Status:   Closed OS:   Generic Original Version:   15.6.0.6010ESD01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7.1 ESD #3 02 Dec 2012 Fixed Description The error message thrown when a user tries to drop a non-existent replication definition for a table or procedure is misleading. Workaround Description  The command uses the tablename or the procedure name.

CR:715061

CR Number:   715061 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   Doc Status:   Closed OS:   Generic Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2012 Added to user documentation Description rs_drop_repdef is not clear on the value for the parameter "name"

CR:715093

CR Number:   715093 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Linux Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description After upgrade process is successfully completed by repserver -upgd, a DSI connection to a replicated database may report the error "EXECUTE permission denied on object rs_update_lastcommit ...." and go down. Workaround Description  Grant EXECUTE permission to procedures manually.

CR:715230

CR Number:   715230 Product Name:   Sybase Replication Server Product Component:   rs_init Status:   Open OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description rs_init flags passwords beginning with rs_ as the first 3 characters, as an error. Workaround Description  Do not use rs_ for the first 3 letters of the password, then using isql to alter the password for the apprropriate user to the desired password.

CR:715327

CR Number:   715327 Product Name:   Sybase Replication Server Product Component:   rs_init Status:   Open OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description if rs.rs_ltm_rs_pass: exists in the resource file and an outbound only connection is created, a value must be put into the line. Workaround Description  comment out the line rs.rs_ltm_rs_pass (by putting a # in the first position of the line)

CR:715374

CR Number:   715374 Product Name:   Other - Docs: Rep Server Product Component:   Other - Docs: Rep Server Status:   Closed OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2013 Added to user documentation Description rs_ltm_rs_pass, if it exists in the resource file, must have a password filled in. Workaround Description  comment out line rs.rs_ltm_rs_pass

CR:715623

CR Number:   715623 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.6 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2013 Fixed Description Null pointer received during resume resync Workaround Description  We think this is due to the fact that the customer did a ra_init force prior to running resume resync. However, the in the resync procedure, this is one of the options. Total workaround is to not use these procedures.

CR:715716

CR Number:   715716 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Open OS:   Generic Original Version:   15.6 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7.1 ESD #3 21 Nov 2012 Fixed 15.6 ESD #2 15.7.1 ESD #3 10 Jun 2013 Added to user documentation Description If the version of Replication Server that connects to Replication Agent is 15.5 or later, Replication Agent no longer addes the 'replicate minimal columns' clause when creating replication definitions. Workaround Description  After the repdef is generated, alter the replication definition to remove the minimal columns override.

CR:715769

CR Number:   715769 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   Management Status:   Closed OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2012 Fixed 20 Sep 2012 Fixed 21 Sep 2012 Fixed Description Replication Agent instance may fail to start up after an in place upgrade from earlier versions to 15.7.1 GA or later release.

CR:715840

CR Number:   715840 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Generic Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2012 Fixed 02 Aug 2012 Fixed Description An off-row compressed lob is replicated compressed however is in-row at replicate.

CR:715845

CR Number:   715845 Product Name:   Rep Serv Commands Ref Product Component:   Rep Serv Commands Ref Status:   Closed OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2013 Fixed Description admin stats,max_mem_use not documented in 15.7.1

CR:715974

CR Number:   715974 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   HP-UX Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Aug 2012 Fixed Description Transactions in outbound queue are re-applied after upgrade

CR:715987

CR Number:   715987 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Solaris Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Sep 2012 Fixed Description Replication Server was not freeing memory used to access repdef during normalization.

CR:716462

CR Number:   716462 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Stack in memcpy, _sqm_read_logical_block Workaround Description  Rollback to previous RS binary

CR:716468

CR Number:   716468 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   RH Linux Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2012 Fixed Description IBM PSeries and IBM AIX64: If an error occurs during seamless upgrade, Replication Server could stack

CR:716499

CR Number:   716499 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Solaris Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2012 Fixed Description After upgrade, rs_funcstrings is not using datarows lock scheme

CR:716558

CR Number:   716558 Product Name:   Sybase Replication Server Product Component:   rs_init Status:   Closed OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2012 Fixed carina 20 Jun 2013 Added to user documentation 21 Aug 2012 Fixed Description Added new documented rs_init trace "SKIP_WINDOWS_SERVICE". When used, rs_init will not create Windows services, or update the Windows registry.

CR:716569

CR Number:   716569 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) Description Provide a method to skip commands for a table in the inbound queue so that the command is not processed by the distributor, yet can process the rest of the commands in the transaction.

CR:716634

CR Number:   716634 Product Name:   Common Metadata Repository Product Component:   Web UI Status:   Open OS:   Windows Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Repository user permissions are incorrect for packages of a model when viewed in the Portal. In the PD client, a repository user has the List permission defined at the package level of a model. When logged into the Portal with this user and accessing the model via the Repository Explorer, the permissions assigned for the packaged are not applied. It appears that the permissions assigned to the model are cascaded down via the packages.

CR:716665

CR Number:   716665 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2012 Fixed Description admin version, "connection" states "Database needs upgrade." when it is already at the correct version. Workaround Description  workaround would be to run the same queries the code is attempting to do in the ds.db to verify the database connection has been upgraded ... select count(*) from sysobjects where name = 'rs_dbversion' and type = 'U' first select should report ... 1 select last_rssd_ver from rs_dbversion second select should report ... rs1571

CR:716735

CR Number:   716735 Product Name:   Repository Product Component:   Repository Status:   Open OS:   all Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When updating models to the repository, shortcuts that only have changes to their name and\or code are not updated to the repository. This occurs for any model type To reproduce: 1) create a CDM 2) create a package 3) add three entities to the package 4) add all three entities as shortcuts on the Model default diagram 5) check in model 6) in the package, change the name of entity_3 to test_3 7) check in the model NOTE: the change is not reflected on the entity_3 shortcut 8) add an attribute to test_3 9) check in the model NOTE: entity_3 shortcut has been changed to test_3

CR:716760

CR Number:   716760 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Solaris Original Version:   15.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance DSI message in MSA that states it has processed the enable marker.

CR:716964

CR Number:   716964 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7.1 ESD #2 28 Aug 2012 Fixed 15.7.1 ESD #3 22 Oct 2012 Presently Not Targeted For Any Future Release Of This Product Description ORACLE ONLY: Replication Agent encounters a NullPointer Exception when replicating SecureFile LOB data.

CR:717234

CR Number:   717234 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Generic Original Version:   15.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sqm_zap_command and sqm_zap_tran do not take effect with only hibernate. One must reboot the RS for the command or transaction to work. Workaround Description  After zapping the command or transaction, reboot the Rep Server.

CR:717386

CR Number:   717386 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 Error 16227 Unknown token TDS stream logged in RS -- shuts down RS Workaround Description  Shutdown Sybase Central or Sybase Control Center or anything that might be monitoring the Replication Server.

CR:717466

CR Number:   717466 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Open OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Would like to replicate Oracle packages

CR:717508

CR Number:   717508 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) 03 Sep 2012 Fixed Description ORACLE ONLY: Replication Agent does not provide an informative error message when initialization fails due to required permissions not being set.

CR:717560

CR Number:   717560 Product Name:   Repository Product Component:   Repository Status:   Open OS:   all Original Version:   beauregard Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The customer would like to have named path _CHECKOUT or something like that, so each time when a model is checked out from repository, the check out path is automatically set to _CHECKOUT value. The customer does not like the fact that PD checks out (extracts) the model to the last saved location that is stored in the model. There attempts at defining a named path variable does not work for them.

CR:717579

CR Number:   717579 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2012 Fixed Description ORACLE ONLY: Replication Agent returns an incorrect error message when querying a LOB value against the primary database fails. Workaround Description  The actual error message can be found only if tracing is enabled T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead LOB: Failed to execute query for LOB Reader. Caught exception <SQL execution failed. T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead SQL ERROR -- T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Message: ORA-01031: insufficient privileges T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead SQLState: 42000 T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Remote Code: 1031 T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Message: SQL execution failed.> . SQL <select FIELD_RAWSTRING from SAPSR3.ZEB_BLOB WHERE MANDT='000' AND FIELD_CHAR='1_KEY_123'> for operation ID <0x0000.00f53d39.0000:0001.0000069c.000117e4.0018> and article <SAPSR3.ZEB_BLOB, ID=[201715], NAME=[ZEB_BLOB], TYPE=[0], STATUS=[Current], VERSION=[[GENID=0][SCN=16038630][SCNGENID=0][THREAD=1][LSN=1691][BLK=0][OFF=0][OATSCN=16038630][UNIQUE=0]], Columns=[MANDT(VARCHAR2), FIELD_CHAR(VARCHAR2), FIELD_RAWSTRING(BLOB), FIELD_STRING(CLOB)]> T. 2012/08/23 15:59:04.016 LRTRACE com.sybase.ds.oracle.logmnr.lob.SeparatedLobC Lob processing fail with exception <Could not connect to PDB for direct query for operation ID <0000.00f53d39.0000:0001.0000069c.000117e4.0018> and article <SAPSR3.ZEB_BLOB, ID=[201715], NAME=[ZEB_BLOB], TYPE=[0], STATUS=[Current], VERSION=[[GENID=0][SCN=16038630][SCNGENID=0][THREAD=1][LSN=1691][BLK=0][OFF=0][OATSCN=16038630][UNIQUE=0]], Columns=[MANDT(VARCHAR2), FIELD_CHAR(VARCHAR2), FIELD_RAWSTRING(BLOB), FIELD_STRING(CLOB)]> because: SQL execution failed.>. T. 2012/08/23 15:59:04.026 LRTRACE com.sybase.ds.oracle.logmnr.lob.SeparatedLobC priorSQL: [NULL] postSQL: [NULL] state: [com.sybase.ds.oracle.logmnr.lob.state.OffRowLobQueryFromPDBState@1e3380c5] article: [ZEB_BLOB]

CR:717595

CR Number:   717595 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RS stacks when getting memory for the parser.

CR:717668

CR Number:   717668 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Generic Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2012 Added to user documentation Description Insufficient licenses message in Replication Server log reports incorrect available number of CPUs when CPU is added. Workaround Description  The message is reported twice in the Replication Server log. The message reports incorrect number of CPUs the first time and correct number of CPUs the second time.

CR:717914

CR Number:   717914 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) 29 Oct 2012 Fixed Description ORACLE ONLY: Replication Agent encounters a Null Pointer Exception when replication is suspending.

CR:717919

CR Number:   717919 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) 29 Aug 2012 Fixed Description The replication for row changes on rs_databases may fail upon downgrade to pre155

CR:717925

CR Number:   717925 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   AIX Original Version:   15.7.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2012 Fixed Description ORACLE ONLY: If two Oracle procedures have the same name but different owners, and if we have already marked one of them for replication and attempt to mark the other, the second mark operation will fail.

CR:717932

CR Number:   717932 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Solaris Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2013 Fixed 25 Mar 2013 Fixed 24 Jul 2013 Fixed 07 Mar 2014 Fixed Description Wrong date and time values may be replicated or DSI thread may go down due to a 3814 error (The parameter of type 111 did not have a valid value.) if both "dynamic_sql" and "dsi_bulk_copy" parameters for the connection are ON and RS_language is not us_english.

CR:717954

CR Number:   717954 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.6 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2012 Fixed 04 Sep 2012 Fixed Description FOR ORACLE:When Rep Agent drops replication definition by rs_drop_repdef, the action is not put into the log. Workaround Description  Validate that the repdef was dropped by looking for the repdef in the RSSD: select objname from rs_objects where phys_tablename = '<tablename>'

CR:718072

CR Number:   718072 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) Description New admin command to report which trace flags are currently enabled in the server.

CR:718107

CR Number:   718107 Product Name:   Rep Serv Commands Ref Product Component:   Rep Serv Commands Ref Status:   Closed OS:   all Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2013 Added to user documentation Description Table rs_dbversion is not documented in the Commands Reference Manual. Workaround Description  1> sp_help rs_dbversion 2> go Name Owner Object_type Object_status Create_date ------------------------ ---------- ---------------------- -------------------------- -------------------------------------- rs_dbversion dbo user table -- none -- Aug 10 2012 2:50PM (1 row affected) Column_name Type Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity ---------------------------- -------- ------------ -------- ---------- ---------- ---------------------------- ------------------------ ------------------ -------------------------------- -------------------------------------------- -------------------- last_rssd_ver int 4 NULL NULL 0 0 NULL NULL NULL NULL 0 min_compat_ver int 4 NULL NULL 0 0 NULL NULL NULL NULL 0 Object does not have any indexes. No defined keys for this object. name type partition_type partitions partition_keys ------------------------ -------------------- ---------------------------- -------------------- ---------------------------- rs_dbversion base table roundrobin 1 NULL partition_name partition_id compression_level pages row_count segment create_date -------------------------------------------- ------------------------ ---------------------------------- ---------- ------------------ -------------- -------------------------------------- rs_dbversion_912003249 912003249 none 1 1 default Aug 10 2012 2:50PM Partition_Conditions ---------------------------------------- NULL Avg_pages Max_pages Min_pages Ratio(Max/Avg) Ratio(Min/Avg) ----------- ----------- ----------- --------------------------- --------------------------- 1 1 1 1.000000 1.000000 Table LOB compression level 0 Lock scheme Allpages The attribute 'exp_row_size' is not applicable to tables with allpages lock scheme. The attribute 'concurrency_opt_threshold' is not applicable to tables with allpages lock scheme. exp_row_size reservepagegap fillfactor max_rows_per_page identity_gap ascinserts ------------ -------------- ---------- ----------------- ------------ ----------- 1 0 0 0 0 0 (1 row affected) concurrency_opt_threshold optimistic_index_lock dealloc_first_txtpg ------------------------- --------------------- ------------------- 0 0 0 (return status = 0) 1>

CR:718153

CR Number:   718153 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Linux Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2012 Duplicate Description ERROR #60021 USER( ) - i_thread.c(160) Open Server failed to create the 'csimutex017485186' mutex. (160)

CR:718159

CR Number:   718159 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Sep 2012 Fixed Description ORACLE ONLY: If Replication Agent replicates a table with more than one LOB column and if more than 1MB of data is inserted into any of the LOB columns, replication will fail.

CR:718205

CR Number:   718205 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   NA Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RepServer DSI will fail with error #5038 or #5213 if it uses a function string to call a stored procedure that returns a status value of -1. Workaround Description  Don't return -1 from RS invoked stored procedures.

CR:718342

CR Number:   718342 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   HP-UX Original Version:   15.7.1 N-Off Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Aug 2013 Fixed 04 Jun 2013 Added to user documentation Description Reference Implementation fails because rs_init requires a non-NULL password for Replication server initialization. Workaround Description  Provide not-null password for sa user in the config file

CR:718442

CR Number:   718442 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   Linux Original Version:   15.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description stack in distributor with "A bad switch value" Workaround Description  instead of purging queue like what was done, we brought up diag RS with distributor suspended....then started up RA....(which added to the inbound queue), then resumed distributor. Unfortunately, RS crashed again when turned off trace, however, it did run successfully for 3 hours prior to the second crash.

CR:718445

CR Number:   718445 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Open OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support geospatial datatypes in Oracle

CR:718451

CR Number:   718451 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Open OS:   NA Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Replicate Oracle geospatial datatypes

CR:718452

CR Number:   718452 Product Name:   Rep Server Connectors Product Component:   Oracle OCI Connector Status:   Open OS:   Generic Original Version:   15.7.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request to replicate geospatial datatypes

CR:718476

CR Number:   718476 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2012 Fixed Description Stack trace occurs when no queue type is provided in "sysadmin issue_ticket" command.

CR:718540

CR Number:   718540 Product Name:   Sybase Replication Server Product Component:   repserver Status:   Closed OS:   Linux Original Version:   15.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 May 2013 Presently Not Targeted For Any Future Release Of This Product 19 Oct 2012 Fixed 03 Feb 2013 Fixed Description Oracle RDB reports "SQL command not properly ended" when using dbresync with ECO. Workaround Description  1. If the DSI is using oracle function string class, apply the following scripts directly in the Repserver system database and then restart RS. delete rs_systext where parentid= 0x000000000ffffd2a insert into rs_systext values(0, 0x000000000ffffd2a,'O',1,'delete from rs_lastcommit where origin = ?rs_origin!sys? ; insert into rs_lastcommit values (?rs_origin!sys?, HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''),') insert into rs_systext values(0, 0x000000000ffffd2a,'O',2,'HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''), sysdate, sysdate) ; commit') 2. If the DSI is using a user created function string class, then we can use 'create function string' to update the function string for rs_reset_lastcommit: create function string rs_reset_lastcommit for private_function_class with overwrite output language 'delete from rs_lastcommit where origin = ?rs_origin!sys? ; insert into rs_lastcommit values (?rs_origin!sys?, HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''),HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''), sysdate, sysdate) ; commit'

CR:718566

CR Number:   718566 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) 06 Nov 2012 Fixed 26 Feb 2013 Fixed 27 Feb 2013 Fixed Description ORACLE ONLY: Replication Agent goes down with error "Replication Server refused the following invalid LTL command" when replicating a table containing a NUMBER column and the value contains an incorrect number of digits.

CR:718647

CR Number:   718647 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Closed OS:   Generic Original Version:   15.7.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2012 Fixed Description ORACLE ONLY: Replication Agent may hang during LOB processing.

CR:718659

CR Number:   718659 Product Name:   Sybase Replication Agents for Unix and Windows Product Component:   RepAgent/Oracle Status:   Open OS:   Generic Original Version:   15.6.0.6010ESD01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide option to create all or drop all repdefs. Workaround Description  Build a script to do it. Nothing available in Replication Server or in Replication Agent.