Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Visual Integrator Hangs when run from a prompt

  • 1.  Visual Integrator Hangs when run from a prompt

    Posted 01-22-2019 23:03
    Sage100 2018 Standard, MS Server 2016. Customer has 2 simple VI jobs (Import AP addresses and Export AP Addresses) that used to run perfectly fine every night via an automated task in a batch file. They upgraded from MS Server 2003 (i think) to server 2016 and now these 2 jobs hang and never finish. Each time they start again they occupy a license until eventually all licenses are used. IT has to logon to the server and End Task all Sage100 processes. The jobs run fine when started in Visual Integrator directly. Sage folders are excluded from  AV and permissions in Sage for running the VI is admin user. Not sure what else to look for. TIA.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------


  • 2.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 07:03
    ​Kenny,
    I had this issue with a Sage 100 advanced client.  Their VI jobs hung and used licenses just as you described. There was a Windows task scheduler job that ran every hour to import a file.  Once the file was imported it was renamed and moved.  as long as their was a file for the VI job to pickup, the import ran and ended gracefully.  If there was not a file present, the VI job would run and not end gracefully, i.e. continue to take up licenses until all licenses were used up.  Solution was to keep a file in the directory that would remain so the VI job wouldn't "dry fire".

    Hope that helps.
    Scotia

    ------------------------------
    Scotia Saunders
    Keystone Business Solutions
    ------------------------------



  • 3.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 07:58
    Scotia, I am not a scripter.  Isn't it possible to add a line or two to the batch file running the VI to check for the existence of the file before firing up the VI?  No file, terminate the batch.  It appears you are doing the same thing at the end when you create the empty file for next time.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 09:48
    Open a command prompt and type:
    if /?
    When concerned I put an IF EXISTS inputfilenameandpath ... line to ensure VI is only triggered when the input file is there.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst, Munjal-White Consulting
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 10:37
    Does either job uses a Cycle? It's that rarely used deprecated field in VI. That's what it turned out to be for  @Shannon Stanley ​when it happened to her.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 6.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 11:21
    I apologize in advance.  Cycle??

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 12:26
    Thank you all. @Scotia Saunders The file is always there . It's never deleted and is overwritten every night with a file from another system. It's just addresses so I am not concerned about importing the same file twice. @Alnoor Cassim It's not on a Cycle. It is run via a batch file activayed by the task scheduler on the server. Job runs fine when I run it via Sage or if I click on the batch file myself.  ​

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------

    Original Message


  • 8.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-23-2019 13:05
    Look for perform logic.  We had one upgrade add weird Perform settings (to existing VI jobs) during an upgrade, which needed to be deleted before the jobs would work without error.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst, Munjal-White Consulting
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 9.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-24-2019 11:30
    Kenny - Couple of things:

    1- I assume you have a single BAT file that auto-runs both the import and export job. Problems can occur if 1st job doesn't finish and 2nd job kicks off. Do you have a command like this below between the job executions:

    TIMEOUT /T 60

    The 60 means wait 60 seconds. Change it to whatever you need.

    2. Just to clarify, I mentioned Cycle because when I remoted into @Shannon Stanley to troubleshoot, her import was also setup to run with a BAT file​ and also worked without issue when running directly through Import Job Maintenance. Not the case with your client but apparently if any of the 4 Cycle fields are populated, they are guaranteed to hang an auto-run V/I import. She didn't need it so we got rid of it but it's possible in older versions Cycle wouldn't hang BAT files.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 10.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-24-2019 12:01
    @Alnoor Cassim. The BAT files are separate. The  ​export goes out at night. The other system picks it up, process and send a file back. The import happens first thing in the morning. I'll look at the Cycle again but last time I looked it was all greyed out so I assume nothing is there. I don't ever use the Cycle so I'm not sure what, if anything should or should not be there. Thanks again.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------

    Original Message


  • 11.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-24-2019 15:17
    Does the vi job run successfully when you execute the .bat file manually?  Have you tried changing any of he command line parameters?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 12.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-24-2019 15:23
    Yes, the job executes perfectly when I click on the batch file.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------

    Original Message


  • 13.  RE: Visual Integrator Hangs when run from a prompt

    Posted 01-24-2019 15:30
    You may try putting the bat file in the root of C on the server.  I have had some issues with task scheduler running bat files that have been solved by copying the bat file to the root of C.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content