Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros 3700 5.4 - Autosequence Still Running

Status
Not open for further replies.

VR247

Programmer
Oct 18, 2017
2
US
I've created an Autosequence that is scheduled to run every 15 minutes. It dumps Dashboard data into a .txt file which is used to update In-House displays with real-time POS data.

The 3700d.log shows that every 15 minutes the autosequence tries to run, but shows that "Autosequence #20505 is still running!"

The Autosequence has 1 step. It calls an External Program (.bat). The batch file calls a sql file with the following statement:

Select getdate() as "DateTime", rest_name, net_sales_ttl, labor_dollars, cover_count, check_count, discount_ttl, void_ttl, (labor_dollars/net_sales_ttl) from micros.rest_def, micros.dashboard_system_ttl where (labor_dollars/net_sales_ttl)>0;

output to U:\Reach54\reach015.txt;

EXIT​


I have other external programs that run the same way, and work fine. Only difference is that they are run once a day, not every 15 minutes.

Any help is appreciated!!


 
Is the destination a local file or a shared file elsewhere?
 
This turned out to be a permissions issue writing to mapped U drive. It ran fine manually, and when initiated from Autosequences, but failed when run via the scheduler.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top