Clarify Scenario:

We are trying to translate inbound x12 EDI data using Cleo Clarify, into an iSeries JDEdwards LF (Logical File) for F0101Z1.

Clarify Issue:

In the Clarify Business Process we execute the Clarify Database Adapter to perform a SQL Insert. The SQL insert, to JDEdwards/iSeries table F0101Z2, fails due to the trigger program not being present.

Clarify Business Process Errors:

Step 2: Execute DB Adapter v2: com.abc.core.DatabaseAdapters.JdeF0101z2ProdvdtaDBA$Imported_Insert
Data:

Step Messages:
2020-05-04 10:10:56,478 [PERSISTENT] - Starting com.extol.ebi.runtime.database.adapter.DatabaseAdapter2Task@5fb3599b

2020-05-04 10:10:56,828 [ERROR] - Error executing statement for F0101Z2: [SQL0204] R0101Z1 in EXTOLVRFM type *PGM not found.
statement: INSERT INTO "CRPDTAUNI"."F0101Z2P1" ("SZEDUS", "SZEDBT", "SZEDTN", "SZEDLN", "SZEDCT", "SZTYTN", "SZEDFT", "SZEDDT", "SZDRIN", "SZEDDL", "SZEDSP", "SZPNID", "SZTNAC", "SZAN8", "SZALKY", "SZTAX", "SZALPH", "SZDC", "SZMCU", "SZSIC", "SZLNGP", "SZAT1", "SZCM", "SZTAXC", "SZAT2", "SZAT3", "SZAT4", "SZATR", "SZAT5", "SZATP", "SZATPR", "SZAB3", "SZATE", "SZSBLI", "SZEFTB", "SZAN81", "SZAN82", "SZAN83", "SZAN84", "SZAN86", "SZAN85", "SZAC01", "SZAC02", "SZAC03", "SZAC04", "SZAC05", "SZAC06", "SZAC07", "SZAC08", "SZAC09", "SZAC10", "SZAC11", "SZAC12", "SZAC13", "SZAC14", "SZAC15", "SZAC16", "SZAC17", "SZAC18", "SZAC19", "SZAC20", "SZAC21", "SZAC22", "SZAC23", "SZAC24", "SZAC25", "SZAC26", "SZAC27", "SZAC28", "SZAC29", "SZAC30", "SZGLBA", "SZPTI", "SZPDI", "SZMSGA", "SZRMK", "SZTXCT", "SZTX2", "SZALP1", "SZURCD", "SZURDT", "SZURAT", "SZURAB", "SZURRF", "SZMLNM", "SZMLN1", "SZADD1", "SZADD2", "SZADD3", "SZADD4", "SZADDZ", "SZCTY1", "SZCTR", "SZADDS", "SZCOUN", "SZAR1", "SZPH1", "SZPHT1", "SZAR2", "SZPH2", "SZPHT2", "SZTORG", "SZUSER", "SZPID", "SZJOBN", "SZUPMJ", "SZTDAY", "SZUPMT")

2020-05-04 10:10:56,829 [PERSISTENT] - Completed Task.

Clarify Resolution:

To resolve this issue, we reviewed the iSeries logical file and determined the iSeries logical file was not set-up correctly. Once the LF was fixzed, we were able to run the Clarify process successfully.