Database SQL exit code -100

Dissuss issues not related to other forums

Database SQL exit code -100

Postby Tech Support » Thu Dec 17, 2015 3:16 pm

We have quite some database tasks being used and most of the time these tasks return an exit code of 0 when the database task is successful. But sometimes (and this happens intermittently), a database task returns -100.

I looked at the help documentation and forum/support notes on the Automize website and most of it mention that -100 is used for file related operations. Can you please explain when would a database task return -100? We had coded our Automize chains to look for exit code of 0 for Automize database task success condition. With the task returning -100 at times, the chain is triggering a false failure notification.
Tech Support
Site Admin
 
Posts: 1234
Joined: Thu May 25, 2006 11:12 am

Re: Database SQL exit code -100

Postby Tech Support » Thu Dec 17, 2015 3:16 pm

Exit code –100 is thrown if task detects that resultset has changed since last run.
If you are looking for an error notification use exit code > 0 , instead of exit code != 0. (exit code > 0 when error occurs)
Tech Support
Site Admin
 
Posts: 1234
Joined: Thu May 25, 2006 11:12 am


Return to Other

Who is online

Users browsing this forum: No registered users and 0 guests

cron