Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: Sql Server Error (urgent)

    How can i solve this problem ???

    Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
    [37000:1101: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]Could
    not allocate new page for database 'TEMPDB'. There are no more pages
    available in filegroup DEFAULT. Space can be created by dropping objects,
    adding additional files, or allowing file growth.

    Error in Process method of Component: QueryEngineServer, Project 11, Job
    14797, Error Code= -2147212544.

    I already saw the growth and it is correct, i have already set it to 96%.
    I have disk space.

    How can i solve this problem

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's your primary allocation in space, and do you allow for auto grow on the file...

    How big is your hard drive, and how much free space do you have?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    48

    Re: Sql Server Error (urgent)

    Originally posted by morsinho
    How can i solve this problem ???

    Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
    [37000:1101: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]Could
    not allocate new page for database 'TEMPDB'. There are no more pages
    available in filegroup DEFAULT. Space can be created by dropping objects,
    adding additional files, or allowing file growth.

    Error in Process method of Component: QueryEngineServer, Project 11, Job
    14797, Error Code= -2147212544.

    I already saw the growth and it is correct, i have already set it to 96%.
    I have disk space.

    How can i solve this problem

    Thanks.
    What do you mean by "already set it to 96%" ?

    It's possible the query you run will use a lot of temporary table spece and the data file of the tempdb is on a hard drive that doesn't have enough space for it to grow.
    Shianmiin

  4. #4
    Join Date
    Jan 2004
    Posts
    6
    My harddisk has 10GB free space, more than suficient.

    The Query is being done by MIcrostrategy

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Whatever...you're blowing out tempdb....

    Maybe you could answer the questions so we can "see" (hey, where's blindman) what's going on...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jan 2004
    Posts
    6
    What's your primary allocation in space, and do you allow for auto grow on the file...

    How big is your hard drive, and how much free space do you have?

    Automatic growth

    by 10%

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by morsinho
    How big is your hard drive, and how much free space do you have?
    Next

    Also, is the box dedicated to you?

    You do know that tempdb is utilized a lot for sorts and temp tables...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Do you have restrict file growth enabled ? Also, watch your tempdb size as this query runs.

  9. #9
    Join Date
    Jan 2004
    Posts
    6
    The growth is unristricted.

    i have saq that but it gives me this error before it uses all the free space

  10. #10
    Join Date
    Jan 2004
    Posts
    6
    Now i have the disk full.

    Can I delete the the tempdb, so that i can have free space.

  11. #11
    Join Date
    Jan 2004
    Posts
    6
    How can i clean the tempdb file??

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You should be able to do

    dbcc shrinkfile (1, 100)

    Make sure you issue this in query analyzer only in tempdb. This will try to shrink your tempdb back down to 100 MB. Before you do that, however, you should make sure that there is nothing in tempdb that will get in the way. Issue this command, and post the results:

    select name
    from tempdb..sysobjects
    where type = 'U'

    That will tell you what tables are still in tempdb (either waiting to be dropped, or waiting for their respective connections to drop).

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by morsinho
    How can i delete the tempdb file??
    DANGER.....DANGER Wil Robinson!

    You should restrict the growth of tempdb...AND I would go look and see what's "lion" around...

    And get rid of any huge unrequired files...

    I guess 10gb wasn't enough...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Take a close look at the SQL code for the query that is blowing up.

    Is this a new process? If not, does it take a long time to run? Is this a test or development system?

    blindman

  15. #15
    Join Date
    Feb 2002
    Posts
    2,232
    I would examine the query and why is needs +10 gig to process.
    Brett - How old are you children ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •