JDEAT
Active Member
Hi List,
we are trying to synchronize certain tables from one EOne instance to another. To get to know which records in instance A has been modified, we are using SQL Triggers on the database side (AS400 V5R4). For each table I have created three triggers. (Update, Insert and Delete).
Every time a record gets changed, I write the primary key infos from this Record into a tracking table (F998SM – Sync Master File).
Later, I am using XPI to poll the Sync Master File, fetch the Record in the original table and transfer the record to an inbound or Z- File in EOne instance B.
In my test environments everything was perfect in this scenario, but when I activate the DB2 Triggers on my PROD Environment I get strange effects in Oneworld. Some apps (eg. P4312)
are having sometimes problems completing their transactions.
I have triggers on those Tables: (See attachment for sample trigger)
F4101
F4102
F4104
F4105
F43090
F41061
Any Idea what could cause these problems?
we are trying to synchronize certain tables from one EOne instance to another. To get to know which records in instance A has been modified, we are using SQL Triggers on the database side (AS400 V5R4). For each table I have created three triggers. (Update, Insert and Delete).
Every time a record gets changed, I write the primary key infos from this Record into a tracking table (F998SM – Sync Master File).
Later, I am using XPI to poll the Sync Master File, fetch the Record in the original table and transfer the record to an inbound or Z- File in EOne instance B.
In my test environments everything was perfect in this scenario, but when I activate the DB2 Triggers on my PROD Environment I get strange effects in Oneworld. Some apps (eg. P4312)
are having sometimes problems completing their transactions.
I have triggers on those Tables: (See attachment for sample trigger)
F4101
F4102
F4104
F4105
F43090
F41061
Any Idea what could cause these problems?