Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
6 subscribers
Views
965 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I have created a process model that updates a database table with information fr
helmuta
over 10 years ago
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
0
helmuta
over 10 years ago
Found the answer: I needed to test my query rule that I was using to retrieve the information for the entry that I wanted to update to see if it contained a valid key value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel