Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Sales Order error message

  • 1.  Sales Order error message

    Posted 08-27-2019 22:36

    Client is on Sage 100 Premium with SP1 and Production Management with Update 1

    They have several test companies.   Only one company does not have the issue.  below.

     

    When accessing Sales Order entry this message comes up (see attachment with "sales order is referencing another task message".

     

    No users are in the system. There are no stranded Pvxwin32 processes.  Sage and SQL are on the same server and the issue will occur after a reboot when for sure there are no locks or users.  It is a SQL install so there cannot be file locks on the tables.    The issue "follows" the company if it is copied (see second attachment).

    We have tried renaming the Links folder, recreating the session files and turning off error trapping all with no change.   We tried adding a UDF and get this message when accessing SaleOrderDetail:

     

    Neither Sage or Scanco has been able to find why this is happening.

     



    ------------------------------
    Douglas Luchansky
    ACI Consulting
    ------------------------------


  • 2.  RE: Sales Order error message

    Posted 08-27-2019 22:40
    Any services running that might be tying it up? Automatic VI Imports, Web integration, Scanco ConnectIt? I ran into this once with a "home Grown" SQL mirroring program a previous IT guy had written and no one even knew about it!

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------



  • 3.  RE: Sales Order error message

    Posted 08-27-2019 23:48
    Have you checked the permissions on the SQL tables?

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



  • 4.  RE: Sales Order error message

    Posted 08-28-2019 09:01
    Have you checked the SQL Activity monitor to verify there are no blocked processes?  

    If that is the case you will see something like my example below.  We have ran into this a few times in the past with 3rd party applications.



    ------------------------------
    Dan Isaacson
    Bennett Porter
    ------------------------------



  • 5.  RE: Sales Order error message

    Posted 08-30-2019 10:56
    Any update @Douglas Luchansky?​

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 6.  RE: Sales Order error message

    Posted 08-31-2019 12:04
    Hi everyone

    Thanks for the help thus far.  

    There has been no change from the advice given, as it does not appear to be a "normal" issue.  Alnoor is going to help set up a SQL trace to see what is locking the file.

    ------------------------------
    Douglas Luchansky
    ACI Consulting
    ------------------------------

    Original Message


  • 7.  RE: Sales Order error message

    Posted 08-31-2019 12:07
    I will be interested in learning what is locking this for your client.  We have a client with a similar type of an issue and they have "Scanco products"; we can not find the locked file anywhere.  Scanco says "it's not us".  @Venessa Griffin​​  ​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 8.  RE: Sales Order error message

    Posted 08-31-2019 15:13

     

    I will keep everyone posted if (when?) we find a solution.

     

    Thank you,

     

     

     signature_1629495337

    Douglas Luchansky

    ACI Consulting

    p 714.282.0378 ext. 302    f 714.282.0235

     

    douglas@ACIconsulting.com

     

            signature_1881629941            

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     



    ------Original Message------

    I will be interested in learning what is locking this for your client.  We have a client with a similar type of an issue and they have "Scanco products"; we can not find the locked file anywhere.  Scanco says "it's not us".  @Venessa Griffin​​  ​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------


  • 9.  RE: Sales Order error message

    Posted 09-01-2019 21:23
    Edited by Alnoor Cassim 09-01-2019 22:11
    Apparently the problem was in the dictionary. The entry for SO_SalesOrderDetail table did not have the SQL Create Table Flag enabled. @Michelle Forsey and I have both run into this before. 

    This means anytime it tried to open SO_SalesOrderDetail, it was looking for the ProvideX M4T file instead of the SQL table, even though the SQL table did exist. The one company where the errors weren't occurring, actually and erroneously had a SO_SalesOrderDetail.m4t in the \Mas90\MAS_xxx\SOxxx\ folder. Fortunately for all companies this was a test environment. Well mostly. I flipped the flag and now the road to recovery (not to be confused with the Road to Hana) is being traveled.

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

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

    Original Message


  • 10.  RE: Sales Order error message

    Posted 09-01-2019 22:06
    Well done!! @Alnoor Cassim I am seriously debating creating a Ksync event to monitor those fields. They flip when no one is looking. Sneaky little buggers.​​

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------

    Original Message


  • 11.  RE: Sales Order error message

    Posted 09-03-2019 15:43
    Since it's resolved, I'll close this thread out to the Sage 100 group. #Urgent​

    ------------------------------
    Robert Wood
    Consultant
    90 Minds
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


Related Content