Could not allocate new page for database 'TEMPDB'

[Former Member]

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.

[Former Member]

Hello Guna,

The issue seems to be about space in the TEMPDB DB.

Can you add one more data file and re run the process?

Regards,

SAT

[Former Member]

Hi,

Thanks for your reply.

The solution to the issue is to do set 'No Limit' for File Size limit in default database file.

Regards

Guna.

[clas_hortien]

Hello,

as the message stated correctly is the tempdb full:

Logical File Name: tempdev

File Size(MB): 20,000

File Size Limit(MB): 20000

Logical File Name: tempdb_1_Data

File Size(MB): 14,999

File Size Limit(MB): 15000

Logical File Name: tempdb_2_Data

File Size(MB): 15,000

File Size Limit(MB): 15000

All files of the tempdb are restricted in size and already expanded to their maximum size. You now can either

- add another file on a disk with free space and let the file grow

- let the existing files grow to an higher amount

Best regards

Clas