Sage 100

 View Only
  • 1.  Has anyone been able to properly format Sage alert

    Posted 12-14-2018 06:50
    Has anyone been able to properly format Sage alerts event to run a batch file? I have been working with Vineyardsoft support, no errors-""Successful"" in the monitor and the batch file runs ok outside of SAW. Everything appears set correctly according to Vineyardsoft support, however it won't run either on the desktop service or the regular service. Just wondering if there is some obscure setting that only experience can identify. Thanks!!


  • 2.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 07:45
    @KimberlyDavis can you post your batch file? I am looking for my notes on this, I had one that was REALLY particular on the wording in the batch file. I will post mine as soon as I can find it, but seeing yours might spark a memory of where the heck I stored it!


  • 3.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 07:50
    echo off D: CD D:\Sage\MAS90\Home start """" Pvxwin32.exe .. \Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION user pswd COM VIWI1I AUTO > nul 2> nul exit Thanks Michelle!


  • 4.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 07:57
    still looking for my notes (It was years and years ago), but try this: D: CD /d D:\Sage\MAS90\Home start """" Pvxwin32.exe .. \Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION user pswd COM VIWI1I AUTO > nul 2> nul exit adding the /d makes sure it actually gets the drive letter


  • 5.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 08:06
    I would also set UI to OFF. I am not sure that SAW knows what to do with that since it is running unattended.


  • 6.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 08:38
    Darn, I can't find anything about the solution, but I did find my case with vinyardsoft. This is the last email in the thread, so something in here must have worked? Ticket#201602051202-114448 *** Solution/Response *** : KnowledgeSync can definitely run batch files. However, there are a few limitations because KnowledgeSync runs as a Windows service and Windows Services have no output and have no way of receiving input. Make sure the following items are met: 1) Your batch file does not output anything to the screen. Make sure ECHO is off. 2) Make sure if your batch file errors, that errors are not pushed to the screen or output in any way. Place any errors in a text file if need be. 3) Make sure that if your batch file calls another program, that the programs that is called does not do and of the above items (1 or 2) 4) Make sure that the program being called (if any) does not refer nor use a mapped drive. Mapped drives are not supported under services. 5) Make sure any/all dlls that the called upon program uses has access to those files. The easiest way to test this is to stop the service and run the desktop service. Run your event and see if anything pops-up or errors out. If not, confirm that the batch file was executed by viewing the task manager. You should see your batch file run (if only for a few seconds) and then see the calling program (if any) run also. It must first run successfully this way, then once it runs fine this way, run it again via the normal service (stopping the desktop service first). If it still has trouble, there must be some resource that the batch file needs that isn't available or is not authorized for access when running as a Windows service. We are simple passing off any *.bat, *.exe, SQL Statements, Stored Procedures or Scripts defined off to Windows. Success in the ""Actions Tab"" simply means that the *.bat, *.exe, SQL file has been successfully handed off to Windows without error for processing.. Some things to check: Administrative Tools Event Viewer Application Errors System Errors Task Manager See if you see multiple *.bat, *.exe or whatever you are passing through KnowledgeSync. If you see any - End Process Immediately Make sure you have the proper authorities. Sign on the KnowledgeSync Server as the User running the KnowledgeSync Windows service KnowledgeSync Windows service. Control Panel Administrative Tools Services KnowledgeSync (Right Click) Properties LogOn Submit your *.bat, *.exe from the command line. Verify completion. Verify that the User running the KnowledgeSync Windows service has proper authorities to perform any WRITE, DELETE, INSERT functions to the folder, database or table and that it has the proper authorities to any share/UNC it is utilizing. Bury yourself manually to the share/UNC and verify you can perform the actions the *.bat, *.exe, SQL, stored procedure is performing. Make sure you are not using mapped drives anywhere.


  • 7.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 10:24
    Thanks for looking into this for me. It still didn't run with that batch file change. The response you received from support is the same exact response I received.


  • 8.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 11:54
    We were able to get this working!! The command line parameter file path in the event needed to be in quotes :) Silly me


  • 9.  RE: Has anyone been able to properly format Sage alert

    Posted 12-14-2018 11:55
    Thanks for sharing the solution!!