cancel
Showing results for 
Search instead for 
Did you mean: 

Large Volumein DSO not activate.

rogerio_vazdesouza2
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Rogerio, ask your SQL Server DBA to verify data and log files of TEMPDB database.

The suggestion of loadsmall chunks is also valid.

Best Regards!

Answers (5)

Answers (5)

vivek_ankit
Explorer
0 Kudos

Hello,

Please split the loads via DTP filter, and try loading that.IF not please ask basis to increase the memory allocation.

Thanks,

VA

former_member976
Active Contributor
0 Kudos

Hi,

it was the memory issue of system and pelase check witht he basis team.

are you using which data base SQL or ORCLE?

how you loaded the data to DSO using the using year wise or fisical year?

first actvate the 1 reqest and note done time for once activation done - do same steps some requests.

-Phani.

Former Member
0 Kudos

As Raman suggested it would be a good idea to load data into DSO using DTP filter.

Also, Is it a single request that you are trying to activate?

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Why your trying activate huge data at a time?

Better load small chunks thru dtp filter and activate requests once you loaded.

Other wise if you have multiple request at dso level to activate. please try to activate 2 or 3 requests once instead of all.

if need memory/space increment take basis/db team help.

Thanks

former_member209202
Participant
0 Kudos

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

Regards
Sourav