Sage 100

 View Only

  • 1.  At one of our premium installation a client is rec

    Posted 01-16-2018 11:47
    At one of our premium installation a client is receiving an error 0 when attempting to run an ap_vendoraudit report. the report works fine in other company codes. It looks like it is attempting to lock the file and can't. Wondering if there could be a SQL lock left from a crash yesterday. Any one see anything like this?


  • 2.  RE: At one of our premium installation a client is rec

    Posted 01-16-2018 11:50
    Good article on tracking locks: https://stackoverflow.com/questions/7139561/best-way-to-find-sql-locks-in-sql-server-2008 Of course this assumes it is actually a SQL able and not once of the pvx files still used by the ""SQL"" version...


  • 3.  RE: At one of our premium installation a client is rec

    Posted 01-17-2018 09:49
    Resolved... Turns out that it was just an unfriendly message cause by user being in Vendor Maintenance. Report couldn't lock the AP_Audit table.


Related Content