Skip to Content
0
Mar 27, 2015 at 03:28 AM

Large Volumein DSO not activate.

75 Views

Hi Gurus,

I have a DSO with large amount of data , about 65 million records.


I can not activate the data in DSO..


Below is the error log in ST22:

Database error text: "Could not allocate space for object 'dbo.SORT temporary

run storage: 140768237322240' in database 'tempdb' because the 'PRIMARY'

filegroup is full. Create disk space by deleting unneeded files, dropping

objects in the filegroup, adding additional files t"

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "ACTIVATE_DATA_FROM_QUEUE" "(METHOD)", nor was it propagated by a

RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

Database error text: "Could not allocate space for object 'dbo.SORT temporary

run storage: 140768237322240' in database 'tempdb' because the 'PRIMARY'

filegroup is full. Create disk space by deleting unneeded files, dropping

objects in the filegroup, adding additional files t"

Thanks.

Message was edited by: Pravender Kumar