cancel
Showing results for 
Search instead for 
Did you mean: 

Job Terminated in source system

Former Member
0 Kudos

Hello Experts,

I have tried loading a COPA cube end to end. The load went success till first level ODS. When i scheduled the load from cube to ODS.I got an error message 'Job terminated in the source system'. Please advice if anybody has come across the same load issue.

Thanks in advance,

DP.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

are you loading from the ods to cube or from cube to ods? is ur load is delta load or full load?

trying deleting the request from target and trigger again and chk. the issue might be an momentary problem in BW system.

Ramesh

Former Member
0 Kudos

Hi Ramesh,

I was trying to load from ODS to Cube. The load type is Repair full, the load is failing only for a particular selection.

Thanks,

Priya.D

Former Member
0 Kudos

Hi Priya,

Generally BW we didn't consider loading from cube to ODS.

BW means loading finally to cube and do reporting on that.

OK in your case may be their is some requirement to do loading from cube to ods.

Do check once again running this. OR

If deltas run for this or not

Or this is First time loading from Cube to ODs.

If first time ReINIT the load and see

Please let me know if the problem still exists.

Regards,

Anand Tej,

Former Member
0 Kudos

SInce your load is a Full Repair and also the load is failing for a particular selection, the load with this selection could be huge than the other selections for this reason the load shud be failing.

Check in SM37 for the failed Job Log, mostly error related to PAGE_ALLOC could be there.

To resolve this you need to reduce the data package size.

Go to Infopackage --> Main Menu --> Scheduler --> Data S. Default data transfer --> and reduce the following settings:

Maximum size of a data packet in kByte

Number of data packets per Info-IDoc

and then try exectuing the load. If it fails again this time it would have picked more records than the last time, reduce the settings further and load again.

Cheers,

Neelesh Jain

Answers (2)

Answers (2)

Former Member
0 Kudos

HI

generally this error comes if this job has been cancelled manually or job itself was cancelled if required amount of resources were not available at the time of job execution.

Former Member
0 Kudos

I thnik you are loading from ODS to Cube.

Check in BW side in SM37 why the job has terminated.

There could be number of reasonf for this. Make the requ. red and delete it from the cube, and start the load again. Hopefully, it will go fine this time.

Thanks...

Shambhu

Former Member
0 Kudos

In COPA you generally load from COPA ODS to the various InfoCubes.

Since you mentioned that you are loading end to end and the job failed while loading data from ODS to Cube, I am guessing that the load from R/3 to your COPA ODS went through.

Next step is to Initialize delta with data transfer from COPA ODS to Cube.

For the InfoPackage used, ensure that you have the correcty setting. You can use PSA in between if you are not using the nee BI7.0 Dataflow already. Check the Menu "Scheduler > Timeout Time" & "Scheduler > DataS. Default Data Transfer" settings as well.

Regards

Anujit Ghosh