Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

VI perform logic and SQL Script

Posted By mdavis over 5 years ago

We are using Sage 100 Advanced v2017 and have created a new VI job to import AP Invoices from DocLink SQL tables. We have a SQL script that we can run manually on the server to update the Doc link SQL tables. However, when we run it under the perform logic of the VI job, it does not executed. I have tried using both ~ and * as well as placed the script in the VI folder. I have tried both full path and ..\vi\.

Also, I created a batch file that can run the sql script as well, but it too does not run the perform logic of the VI job. Both the batch file and SQL script run outside of Sage, just not as a piece of perform logic on the VI job.

I have tried running Sage in MAS90 mode as well, with same results of the perform logic

Any thoughts?

0 Kevin M over 5 years ago

Change your Perform Logic batch file to do something super simple like create a txt file. When that works (but the same PL batch file starting SQL commands does not) you know the problem is the way you run the SQL, not that the Perform Logic is not being triggered.

Remember, PL is running through the service, so things like mapped drives are not available.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mdavis over 5 years ago in reply to Kevin M

Thanks for the tip. The perform logic was executing the simple batch file with no problems. The issue turn out to be permissions in SQL for the advanced sage service account. Thanks again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

VI perform logic and SQL Script

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING