Sage 100

 View Only

  • 1.  Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 09:33
    Edited by Wayne Schulz 08-10-2023 09:33

    Long time customer of Sage 100 Premium - upgraded about four months ago version 2018 to 2022. They have several enhancements and ScanForce is the first one I'm zeroing in on since it happens to be in the midst of their daily processing.

    Their complaint is that they run the daily sales order sale journal ( they claim they only print though it seems like they're in the midst of update )

    And they receive an Error 0 - Record/file busy

    And then they somehow also receive this ( some of this chain of events is fuzzy because they can't duplicate the issue on demand though it is happening frequently ) 

    Record in Unknown file name is in use by another task

    If we retry we come to 

    Error 28 in program CI234_BMI_UPDATEDETAILTOIM.PVC at line 0403

    Ultimately what happens is they go back to the SO Sales Journal and they do show that the update was interrupted. They restart and it works.

    The problem is that it then doubles one invoice upon restart.

    This is a  pretty big issue because some of the invoices are large in dollars. Luckily it doesn't seem like any credit card payments get doubled.

    Here's what I suggested: 

    1. Only update your batches at night when nobody is in the system ( personally I feel badly recommending this but as a diagnostic step it may be needed )
    2. Ask your IT to follow Sage's files to exclude from AV ( though I'm uncertain this will help with Premium ) 
    3. We've had ScanForce jumping on and off the system at various times - and usually their response has been to let them know when it happens and they'll look - which sounds great in theory but when it happens at 4pm and shipments have to get on a UPS Truck ( stop me if you're familiar with this story ... )
    4. So I'm preparing to open a case with Sage though my sense is that this may not be a pure Sage related issue

    My question - has anyone seen something similar or have any other suggestions on what to try? 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 2.  RE: Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 09:49

    Wayne,

    Are there any SQL Queries or stored procedures access the Sage 100 work tables. We had what appear to be the exactly the same issue, after a lot of troubleshooting we determined that it was SQL queries running. Those queries were only doing read request and not doing any write functionality, but the were putting locks on tables all the same.   We change the queries to use with (NOLOCK) and it resolved the problem (link below).  In the meantime, until you track down the cause, when the program bombs out to the ProvideX command, have the user type RUN and hit enter it should restart the update without duplicating anything.  

     

    What is "with (nolock)" in SQL Server? - Stack Overflow

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 3.  RE: Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 10:05

    Thanks @David Overholt - in this case the customer is doing significant reporting from SQL so it's not out of the question that some query they are running could  be causing this issue. I've forwarded them your suggestions and will see if that is something which helps.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------

    Original Message


  • 4.  RE: Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 10:12

    I had a similar problem (SQL write failed with error 15) due to a 3rd party (FYI Soft) putting SQL triggers on certain tables, essentially blocking the write because the trigger could not write to an external database.



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

    Original Message


  • 5.  RE: Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 09:56

    I'm thinking that since that program is an MD version of the program, Sage will back away so fast it'll pull your face right off.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 6.  RE: Sage 100 2022 Premium with ScanForce (and other ) integrations - Record in Unknown file name is in use by another task

    Posted 08-10-2023 09:58

    @Beth Bowers that's my same thought. - in my mind I walk through the questions Sage is likely to ask and what they are likely to do and I try to diagnose those issues before calling.  For my support plans once I take a Sage case # I consider my portion done except for helping the customer followup with Sage on the case.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------

    Original Message


Related Content