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 Member · Accepted solution]

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!

[vivek_ankit]

Hello,

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

Thanks,

VA

[KodandaPani_KV]

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]

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]

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]

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

Regards
Sourav