Post reply

Reporting Services & Tempdb problem

  • May 2, 2006 at 4:27 am

    #111940

    I have a report use SP with Dynamic SQL.

    When execute the report on a long period the Report crush saying the tempdb is full:

    • An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    • Cannot read the next data row for the data set AmgatMES. (rsErrorReadingNextDataRow) Get Online Help

    • Could not allocate space for object '(SYSTEM table id: -375803370)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.

    When i use SP with no Dynamic sql it works grate

    1) why it happen?

    2)How can i resolve it?I want 2 use Dynamic SQL!!!

     

  • May 2, 2006 at 7:21 am

    #635290

    Firstly shrink your tempdb and then restart your sql server once and run your stored procedure having dynamic sql that is being used by your report and see if it works, the dynamic sql should be writing to tempdb which is already full and resulting in the error mentioned by you.

     

     

    Prasad Bhogadi
    www.inforaise.com

  • May 3, 2006 at 10:37 am

    #635708

    dynamic sql is not good for a number of reasons. stay away from it if you can. sounds like the dynamic sql is different then the working non-dynamic sql. I would guess there is a problem like a missing join in the dynamic sql.

    Cheers,

    Todd

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

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