I did the 2020 upgrade and most of my custom reports time out.

SUGGESTED

Called tech support and they said custom reports are not in their scope and they cannot help me.  I cannot run my reports I've developed over the last couple years.  Need Help Please.  I even tried starting over and Sales Analysis works but when I strip it down to the fields I need the same timeout happens:

Description : [PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine]S1T00Timeout expired.
Number : -2147217871
Source :
Driver Error : Unknown
SQL State : S1T00

Parents
  • 0
    SUGGESTED

    Hi Bill,  If you have been developing reports, you should have the Connector module.  While in the connector module, select your report and place a check in the Show Advanced box at the bottom left corner of the Properties window.  Once you have done that, the 7th field down from the top says Timeout Enquiries After (Seconds) and will be defaulted to 5 minutes or 300 seconds.  Just raise the number of seconds to the desired level and select Apply.  That will increase the time before your report times out.

Reply
  • 0
    SUGGESTED

    Hi Bill,  If you have been developing reports, you should have the Connector module.  While in the connector module, select your report and place a check in the Show Advanced box at the bottom left corner of the Properties window.  Once you have done that, the 7th field down from the top says Timeout Enquiries After (Seconds) and will be defaulted to 5 minutes or 300 seconds.  Just raise the number of seconds to the desired level and select Apply.  That will increase the time before your report times out.

Children
  • 0 in reply to DaveNDarlene

    They have tried that and no luck.  David Bryant has been trying to help me and he has concluded our database is way to large.  My reports work with the sample company that comes with Sage so he says it must be the data.  It is 1.8M where the max is supposed to be 250-300K. We are currently getting a rebuild done as I have not been able to get the size down on my own.  I will keep everyone posted if this works or not.

  • 0 in reply to Bill Fowler

    So when they did the rebuild it did not bring any history so technically my reports run but there is no data.  I know we need to clean up our database but now wondering the best way to do it.  Accounting does not want to change to a database with no history until the end of our fiscal year so I still need to come up with something until then.  Even then if I strip down my database to clean it up, my reports show comparisons to YTD last year so I would rather find an alternate solution to retain at least 2 years worth of data.