Sage 100

 View Only
  • 1.  Sage Intelligence Timing Out

    Posted 03-19-2019 14:15
    Customer started getting "ProvideX ODBC Driver Timeout Expired error.  SI KB yields no hits.

    We have rebooted the workstation.  Shut off the CS ODBC driver service at the server and restarted (this did speed up crystal reports).  Verified the DLL's (Bi Generator, Report Designer Add in 1.2.0 and Report Designer Add in 1.2.0 Custom Task Pane helper) appear in Excel.

    Have NOT rebooted the server (too many users).

    This seems like a network speed issue.  Do I ping the server and look for slow response time?  Something else?  Need something to point the IT folks to.

    TIA

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


  • 2.  RE: Sage Intelligence Timing Out

    Posted 03-20-2019 11:43
    Everything is working fine today.  Go figure.

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



  • 3.  RE: Sage Intelligence Timing Out

    Posted 03-20-2019 12:29
    Jeff - did you see KB 30054?  It's in the Sage 100 (vs SI KB).  It indicates modifying the registry for Timeout Settings for ODBC.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 4.  RE: Sage Intelligence Timing Out

    Posted 03-20-2019 13:37
    Just read it.  Wile interesting and probably relevant, the issue is that the SI normally takes 4 minutes to chug through.  Yesterday, it timeout blew at 10+ minutes.  Something was happening on the network that cleared up (fingers crossed) overnight.  The server may have rebooted, still waiting for IT response.

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