I have created a process model that updates a database table with information fr

I have created a process model that updates a database table with information from the Appian user table (email address). It checks each entry in the database table to see if an email address exists and if it does not exist it will retrieve it from the user table and write it to this table. Everything works great in our development environment. I use an index to retrieve each row in the table and check if an email address exists. I promoted the process to our Test environment and the process error-ed out because our table in Test is missing an entry in this table (someone deleted a row). So my index value is at 204 it increments to 205 and row 205 is missing. This should not happen but since I have run into this error I am curious is there a way to check if an entry is missing?...

OriginalPostID-129491

OriginalPostID-129491

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data