cancel
Showing results for 
Search instead for 
Did you mean: 

while doing data loading from psa to cube getting dump..

Former Member
0 Kudos

Hi Experts,

Actually iam loading data in Production System from psa to cube it will taking lot of time.

Maximum No of Records 3 Crores.

We are maintiang data package size is 2,00,000

Parellel Processing is 1.

Actually we start the job Yesterday 12.00pm. today 12.00pm i saw the requset it's picking only 1 Crore Records.Total Data Packages is 590.

we got a run time error at 225 Data Package.

Please suggest me is there any alternate option for loading the data ..

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member182516
Active Contributor
0 Kudos

Hi Suresh,

Issue is due to the large data packet size.

Decrease the data packet size to max 50,000 and re run the data load. Due to burden on the system you load is getting terminated and taking lot of time to load.

During the load is running there might be other data loads and processes running in the PROD system due to crunch in the system resource load getting terminated.

Decrease the data pack size to 10K or 20K.

Increase the no of parallel processes to 4.

Re-execute the load and check.

Regards

KP

former_member209032
Active Contributor
0 Kudos

Hi,

  Check in ST22 regarding the error. I think it will be mostly DBIF_SQL_ERROR by seeing the amount of data. If you get the above error, then drop the index of the cube and repeat the load. If u got any other error please search the forum for that error and if u r not able to find any info then post it here.

Regards,

Raghavendra.

Former Member
0 Kudos

Hi Raghu,

Tahnsk for the information.

But error is not related short dump. its related to run time error i.e: c_object_..like this error. we got.

i think its taking long time for loading.

i need how we can improve the loading performance.

Former Member
0 Kudos

Hi,

While loading data from source to BI load data based on any selection like monthly load or daily or else in any other way.

Could you please let us know the Datasource name.