on 03-13-2013 10:36 AM
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 ..
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.