Skip to Content
avatar image
Former Member

Scheduled Query Report Error

Hi,

I am trying to create a scheduled query report that will be emailed out daily with an excel attachment for the data.

I keep getting this error when the report is supposed to run:

Looking for first schedule to be executed before/on 20160412 9:52

Found Scheduled Report ID: 6

Handling schedule

Starting SAP Business One Client with configuration written to its stdin

*** SAP Business One Client Log ***

*** SAP Business One Client Log ***

Process timeout; terminating client process

Process timeout; terminated

SAP Business One Client return code:259

Distributing results

SAP B1 client did not update new scheduyle date and time! Deactivating the schedule to prevent infinite loop.

An error occured while creating report by SAP B1 Client

Schedule processed

Any ideas on what I need to fix or update?

Thank you,

Amanda

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 13, 2016 at 08:05 AM

    Hi Amanda,

    The first thing you may want to try is to run the query manually, and see how much time it takes.

    The next thing is to check the timing:

    • Is another query still running at the that time?
    • Is another query started at the same time?

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      This will be our first scheduled report so when it runs it should be the only query running.

      Also when I have tested it I have not been running any other queries.

      Just ran the query and it takes just under 3 seconds to run.