Symptom
-
After a source refresh or migration, table fails to replicate.
-
View Error for table has error similar to:
- Failed to create triggers for table TABLE_NAME with logging table /1CADMC/0000XXXX
RFC destination: <XYZ>
Database connection: R/3*
inconsistent datatype: invalid function argument: line 1 col 76 (at pos 75) -
Attempting to manually create trigger for table fails
- The following error messages occurred on: DD.MM.YYYY hh:mm:ss
Failed to create triggers for table <Table Name>with logging table /1CADMC/0000XXXX
RFC destination: <SIDCLNTXXX>
Database connection: R/3*
SQL statement: CREATE TRIGGER "/1LT/0000XXXXINS" AFTER INSERT ON "SAPSID"."Table Name" REFERENCING NEW AS NEW FOR EACH ROW MODE DB2
UUC_PROCESSED" , "TABNAME" , "AS4LOCAL" , "AS4VERS " , "IUUC_OPERAT_FLAG" ) VALUES ( GENERATE_UNIQUE (), TIMESTAMP(GENERATE_UNIQ
/1LT/0000XXXXINS trigger creation failed for table <Table Name>
SQL0150N The target fullselect, view, typed table , materialized query table, range-clustered table, or staging table in the I
Read more...
Environment
SLT DMIS
Product
SAP Landscape Transformation replication server 2.0
Keywords
replicate, stuck, hung, fail, status, , KBA , HAN-DP-LTR , Use CA-LT-SLT instead , 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.
SAP Knowledge Base Article - Preview