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.