Post reply

"Query execution failed" error with concurrent users

  • March 10, 2009 at 5:18 pm

    #206861

    Hi,

    I have a deployed report that accepts one input parameter and does not seem to have any problems when run by a single user

    However, when three users try to run that report at the same time - with different input parameters, i do not know if that matters - some of them (and sometimes) are getting "Query execution failed for dataset..." error.

    Any advise?

    Thank you

    P.S. It's 2005

  • March 10, 2009 at 8:06 pm

    #957216

    This may depend on the amount of data passed in by each parameter and how many temp tables you are using in the code, you need to check those to see if you could run the report code off a view instead of the tables and avoid temp tables if you can.

    Kind regards,
    Gift Peddie

  • March 11, 2009 at 1:57 pm

    #957853

    Thanks!

    The reason was even simpler, it was using a global temporary table dropping if already exists first, and then recreating etc. Changing to use a local one instead seems to fix the whole thing.

    Thanks again

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply