SAP Knowledge Base Article - Preview

2060046 - Several tables aren't replicaing to IQ targets - SAP RS 15.7

Symptom

  • Several primary ASE tables are NOT replicating to two IQ targets only while they are successfully replicating to a warmstandby database and two Mutisite Availability (MSA) databases.
  • DSI threads for database connections to both IQ targets have NEVER been ‘down’ due to an error.
  • The names of the primary and replicate tables match, and all tables are owned by the dbo user in every database.
  • Replication definitions include the owner name 'dbo' with the primary and replicate table names, like in:

 create replication definition ipdbo_TEST2_def
 with primary at lc_DS.lc_DB
 with primary table named dbo.'TEST2'
 with replicate table named dbo.'TEST2'
 (
 a  int,
 b  char(10)
 )
 primary key ( "a", "b"  )
 send standby all columns
 replicate all columns


Read more...

Environment

  • SAP Replication Server 15.7
  • SAP Adaptive Server enterprise 15.x
  • SAP IQ 15.4

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7 ; SAP Sybase IQ 15.4 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

RepServer , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.