Sage 100

 View Only

  • 1.  "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-28-2019 15:28
      |   view attached

    "Application is attempting to open more files than allowed. Terminate it?"
    Sage 100c Advanced 2018, PU2
    JobOps 6.00.2.0.2, 10/01/18 build
    AvaTax
    APS CC Processing
    Sage CRM
    JoScan
    GoToMyERP environment

    So, having trouble getting anyone to take responsibility for this one. JobOps says they only have one reported customer that has ever experienced this message. They have no plans to look at it because they feel it is probably an environment issue, but it is a huge problem for my customer. They receive this message when flushing work tickets in Work Ticket Parts Usage. This is causing items on work tickets to issue twice to the work ticket but only once to the SO detail. This is causing numerous validation errors that we have poured hours and hours into over the past couple of weeks.  Screen shot attached.



    ------------------------------
    Liz Ortega
    DeRosa Mangold Consulting, Inc.
    ------------------------------


  • 2.  RE: "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-28-2019 16:21
    Hello Liz,

    Is this always happening, or just certain Tickets?

    ------------------------------
    Gil Ponte
    Professional Software, Inc.
    ------------------------------



  • 3.  RE: "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-28-2019 16:38
    It does not seem to be happening with every ticket.  We are still monitoring the situation in an effort to identify any triggers, but so far, nada.

    ------------------------------
    Liz Ortega
    DeRosa Mangold Consulting, Inc.
    ------------------------------

    Original Message


  • 4.  RE: "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-28-2019 16:54
    Howdy, Liz!

    I can tell you that APS doesn't have any programs in work order.  If this was generate a sales order or invoice, then we might be involved, but no, there are no APS programs in work order.

    Regards,


    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------



  • 5.  RE: "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-28-2019 17:59

    Hey Liz,

    I guarantee this is a ProvideX error (not a Windows error) that's caused by repetitively OPENing file handles in a loop but then not CLOSEing them down then eventually reaching the ProvideX limit for max number of files . I wrote up several bug reports on this error while a Sage employee, seen it while working for an M/D company, and have caused this error myself (oops). It's one of those issues that doesn't manifest unless you have large enough data.

    I don't know JobOps and can barely spell it (Gil may be laughing right now), but all indicators point to the WT Parts Usage code in combination with the right type of data. If you think it will help, here is here is some standard Sage code that causes exact same error.  Maybe you can send it to them so they can review for same issue in their code. That's assuming you can get them to look at it. Maybe Mike can help push them. 

    This snippet is from legacy J/C 4.50 from the Cost Code Detail Report. The error you posted occurs here because the AR_Customer table was being opened over 32k times while iterating through a big old JC2 loop. This was fixed in v2014 I think. 

    JCWRFC

    2595 AR1Fh=%SYS_SS'OpenTable("AR_Customer","COMPANY") ! Used to be Channel 5

    but it should be:

    2595 IF NOT(AR1Fh) {AR1Fh=%SYS_SS'OpenTable("AR_Customer","COMPANY")} ! Used to be Channel 5



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

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



  • 6.  RE: "Application is attempting to open more files than allowed. Terminate it?"

    Posted 03-29-2019 13:56
    Awesome!  Great info, as always, Alnoor.  I'll see what I can do with this!

    ------------------------------
    Liz Ortega
    DeRosa Mangold Consulting, Inc.
    ------------------------------

    Original Message


Related Content