Post reply

Query execution failed for data set

  • August 29, 2007 at 5:40 pm

    #176364

    I am trying to run a report in reporting services, I continue getting this error message:

    An Error has occurred during report processing.

    Query execution failed for data set ‘releasedEncasementsSP’

    Could not find stored procedure ‘STSS_ReleasedEncasements’.

    Is there anyway to retrieve this lost data set?

    Thanks ahead of time.

  • August 29, 2007 at 5:51 pm

    #730293

    Alex, check the connection information and ensure that the database you're pointing at has a procedure named STSS_ReleasedEncasements and the authentication you're using to connect has access to execute it.

  • August 29, 2007 at 5:56 pm

    #730294

    Aaron, Thats just the problem, I am pointing at it, but it does not exist. Is there anyway for me to retrieve information that has been deleted in error?

  • August 29, 2007 at 5:58 pm

    #730295

    Ah... someone dropped the stored procedure?

    Then your best bet is to see if you have a backup you can restore to get the procedure or another copy of the procedure code elsewhere.

  • August 30, 2007 at 10:17 am

    #730495

    Where would be the best place to look to stored procedure (back ups) ?

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

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