Skip to Content
0
Former Member
Jan 01, 2008 at 05:00 AM

Could not allocate new page for database 'TEMPDB'

387 Views

Dear All,

When I try to fill up the aggregate of a cube, the job is cancelled after 16484 Seconds due to runtime error .

I couldnt do fillup though I tried lot of times. The system log information is given below.

-


Database error 1101 at EXE

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

Database error 1101 at EXE

Perform rollback

Run-time error "UNCAUGHT_EXCEPTION" occurred

Short dump "080101 025044 Eapsapp1 POTARU91" generated

Transaction Canceled 00 671 ( UNCAUGHT_EXCEPTION 20080101025044Eapsapp10021 POTARU91 0011 )

Perform rollback

-


System Details:

BW Version : 3.5

Support Level: 19

Datebase : MS SQL Server 2000

Cube's E Table Details:

Total Rows : 318,230,953

Data Szie(KB) : 121,358,760

Index(KB) : 55,241,264

Min. Row Size: 371

Max Row Size: 393

TEMPDB database information:

DB Size(MB): 139,999

Size Used(MB): 3

Free (MB): 139,996

Log Size(MB): 342

Log Used(MB): 117

TEMPDB is having 9 Database files. Out of nine, three database file information is given below.

Logical File Name: tempdev

File Size(MB): 20,000

Used Space(MB): 0

File Size Limit(MB): 20000

File Growth Step: 250MB

Free on Disk(MB): 459,204

Logical File Name: tempdb_1_Data

File Size(MB): 14,999

Used Space(MB): 0

File Size Limit(MB): 15000

File Growth Step: 550MB

Free on Disk(MB): 2,674

Logical File Name: tempdb_2_Data

File Size(MB): 15,000

Used Space(MB): 0

File Size Limit(MB): 15000

File Growth Step: 0MB

Free on Disk(MB): 2,674

Collectively for all the 9 database file size is 140GB.

Please let me know what has to be changed in above TEMPDB size settings to avoid the issue in future.

Advanced Thanks for your solution for this issue.

Regards

Guna.