Large Volumein DSO not activate.

[rogerio_vazdesouza2]

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

[former_member209202]

Hi Regerio,
Please follow up with Basis to allocate more space.

Regards
Sourav