Knowledge Base Other (Database ..)

Database SQL exit code -100

User support request
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
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)

As always, it is a pleasure doing business with you. We are very happy with the capabilities of the new version of Automize and are looking forward with moving ahead with our first production system based on this software. –Automize Enterprise User

Thanks for your timely response. You make a great product, and we're integrating it more and more into our daily production activities. I will try out these FTP suggestions as you've outlined. –JaSFTP User

Just wanted to compliment you folks on a great product. your product is working flawlessly! I'll definitely be purchasing it, and telling every other "IT type" I know about it! Thanks so much. –Automize User

Your program was exactly what I was looking for...you have all the features that I require; all in one program!!–AbleFTP user