SAP Knowledge Base Article - Preview

2559983 - Trigger Creation Error in SLT: inconsistent datatype: invalid function argument

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.