Post reply

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

  • November 18, 2005 at 5:06 am

    #364174

    I am trying to Input around 45k records using SQL Server with RAM configoration of 1GB [2 slot]. But I am getting thread on the execution of my program as follows in ERRORLOG :-

    Error: 1105, Severity: 17,

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

    During runtime of my java program I am getting the following ERROR on command prompt saying,"----[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not allocate space for object '(SYSTEM table id: -7658640)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.----"

    Please help me to rectify this THREAD

  • November 18, 2005 at 5:38 am

    #604607

    This is not a threading problem.

    'TEMPDB' is the work space for SQL Server and as your process needs more work space than is currently available, the size of the tempdb must be increased.

    The increase is size fails.

    Do you have enough disk space ?

    SQL = Scarcely Qualifies as a Language

  • November 21, 2005 at 10:47 pm

    #605136

     

    Ya thanks for your massage...

    I have free diskspace of 16.1 GB out of 19.5GB total C: Drive space. My HDD Capacity is 80 GB.

    So hope you tell me good solutions for the same.

        Following is the PROBLEM :-

            I am trying to Input around 45k records using SQL Server with RAM configoration of 1GB [2 slot]. But I am getting thread on the execution of my program as follows in ERRORLOG :-

    Error: 1105, Severity: 17,

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

    During runtime of my java program I am getting the following ERROR on command prompt saying,"----[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not allocate space for object '(SYSTEM table id: -7658640)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.----"

  • November 22, 2005 at 3:23 am

    #605174

    In the interests of keeping all relevent info in one thread, see

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=238067

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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