SSRS 2000 TEMPDB errors

Posted on 2009-05-01
Last Modified: 2012-08-14
Hi there:
  I am running a report and report manger gives the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot read the next data row for the data set dataset1. (rsErrorReadingNextDataRow) Get Online Help
Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Can someone tell me how to fix that?


Question by:HuiShi
    LVL 60

    Accepted Solution

    restarting sql server will fix it...but the underlying problem is likely that you have a few transactions open or a few really large temp tables out there.  regardless, restarting the sql server is an immediate fix.
    LVL 57

    Assisted Solution

    by:Raja Jegan R
    Your temp db is not allowed to grow at all and that is the problem.
    Right Click your tempdb in Enterprise Manager and enable Autogrowth properties to fix out this issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now