In the past couple of week the process seems to be randomly stopping without updating all the records. E.g. there will be 2500 rows in the SQL database but after the process has run there will only be 2140 that have loaded in to the AwareIM database. The data set I’m using is clean and has no duplicate values that could potentially confuse the process and weirdly if I run the process again manually, it will complete to the full amount of records.
Does anyone know why this might be happening or how I can troubleshoot this issue?
Thanks.
Process 1
Code: Select all
FIND ALL INFO1
CreateRecordsINFO1
Step 1. Find all the records where the primary key matches
Code: Select all
FIND Main_Planning_Data WHERE Main_Planning_Data.MPD_ID=INFO1.EKANBANid
Step 2. If it doesnt find it, create a new record
Code: Select all
If SEARCH_COUNT=0 Then
CREATE Main_Planning_Data WITH Main_Planning_Data.MPD_ID=INFO1.EKANBANid …..
Step 3. if it does find if, update certian fields of the record
Code: Select all
If SEARCH_COUNT>0 Then
Main_Planning_Data.STRIKE_DATE=INFO1.StrikeDate….