Troubleshooting
Problem
When setting up Oracle Capture environment for Q Replication, you might encounter the error in ASNCLP command.
Symptom
ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER CAPTURE TO CONFIG SERVER ORASVR1 FILE "asnservers.ini" ID USER1 PASSWORD "XXXX";
SET SERVER TARGET TO DBALIAS DBTEST ID USER2 PASSWORD "XXXX";
...
...
SET SERVER CAPTURE TO CONFIG SERVER ORASVR1 FILE "asnservers.ini" ID USER1 PASSWORD "XXXX";
SET SERVER TARGET TO DBALIAS DBTEST ID USER2 PASSWORD "XXXX";
...
...
CREATE QSUB SUBTYPE U USING REPLQMAP "QMAP1" (SUBNAME "T10001" "USER1"."T1" OPTIONS ALL CHANGED ROWS N HAS LOAD PHASE N SUPPRESS DELETES N START AUTOMATICALLY NO TARGET NAME "USER2"."T1" TYPE USERTABLE TRGCOLS ALL CONFLICT RULE K CONFLICT ACTION F ERROR ACTION Q );
ASN1956I ASNCLP : Generating SQL script files for action: "CREATE Q SUBSCRIPTION".
ASN1955I ASNCLP : Using the following files: "qreplcap.sql" for the Capture SQL script, "replctl.sql" for the control SQL script, "qreplapp.sql" for the target SQL script, and "adminnode.ASNCLP-replmsg.log" for the log file.
--- ASNCLP Version 11.5 Build date 2020-09-16 04:35:42
ASN1514I The replication action ended at "Thursday, September 17, 2020 3:27:34 PM PDT" with "0" successes, "1" errors, and "0" warnings.
Report =
ASN2003I The action "Create Subscription" started at "Thursday, September 17, 2020 3:27:34 PM PDT". Q subscription name: "T10001". Q Capture server: "ORASVR1". Q Capture schema: "USER1". Q Apply server: "DBTEST". Q Apply schema: "USER2". The source table is "USER1.T1". The target table or stored procedure is "USER2.T1".
ORA-00942: table or view does not exist
ASN1955I ASNCLP : Using the following files: "qreplcap.sql" for the Capture SQL script, "replctl.sql" for the control SQL script, "qreplapp.sql" for the target SQL script, and "adminnode.ASNCLP-replmsg.log" for the log file.
--- ASNCLP Version 11.5 Build date 2020-09-16 04:35:42
ASN1514I The replication action ended at "Thursday, September 17, 2020 3:27:34 PM PDT" with "0" successes, "1" errors, and "0" warnings.
Report =
ASN2003I The action "Create Subscription" started at "Thursday, September 17, 2020 3:27:34 PM PDT". Q subscription name: "T10001". Q Capture server: "ORASVR1". Q Capture schema: "USER1". Q Apply server: "DBTEST". Q Apply schema: "USER2". The source table is "USER1.T1". The target table or stored procedure is "USER2.T1".
ORA-00942: table or view does not exist
ASN1514I The replication action ended at "Thursday, September 17, 2020 3:27:34 PM PDT" with "0" successes, "1" errors, and "0" warnings.
totalSuccess 0
totalErrors 1
totalErrors 1
ASN1954E ASNCLP : Command failed.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PkiAAE","label":"Administrative Tools"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
ibm16335127