DTP with full update got failed after long run

[sai_v]

Hi Experts,

We have an DTP with full update targetting to DSO, When I checked this DTP one week log it is taking 6 to 7 hrs to complete successfuly, but for the past 3 days it is getting failed after long run (6hrs) with one of data package in red rest are in green (total 12 data packages) and technical status is red.

We are deleting the red request from target and repaired the DTP and it will get completed after 6 hrs. Can any one help me why this will happend and what needs to check when it get failed.

Thx,

Sai.

[Former Member · Accepted solution]

Sai,

I'll give a simple scenario.

If you set 3 background jobs for this DTP, 3 data packages will be processed at a time.

If your DTP run failed and did a repair load, system will process 1 DTP at a time, instead of 3.

As far as failure is concerned, might be due to many things right from data quality to unavailability of background jobs. Post the error message details to tell you further.

Br, H

[sai_v]

Hi Folks,

This failure due to too many background jobs, I just repeated the step and it got completed successfully.

[john_hawk]

If you hear hoof beats, think horses, not zebras.

If the DTP times out after exactly 6 hours, check the settings on "Set Traffic Light Waiting Time" RSCUSTV2 in RSA1 -> Adminstration -> Administration Cockpit ->  Installation and Customizing -> Automated Processes -> Extraction Monitor Settings -> Set Traffic Light Waiting Time

Maybe you are simply timing out!

[Former Member]

Hi Sai,

Error descp. be more specific.. there will be mesg no.. can you provide it?

regards:

sandeep.

[sai_v]

Hi Folks,

The error is Dump: Internal session terminated with a runtime error. What could be the reason for this termination

[RamanKorrapati]

You need share dump details fro ST22. please go to Tx- ST22, as per the date find the relevant dump and share more details.

[Former Member]

Hi Sai,

We cannot help you much with just the error description.

Check in St22 for complete dump.

Br,

Arpit

[former_member190729]

Hi,

Please provide the ST22 dump screenshot so that we can help you on it.

The dump also has the line where the code failed, if you can track us to that place it will be more of a help to you.

Regards,

Sourabh Deo

[Former Member]

Hi Sai,

Please check if there is code written in the Transformation, try to reduce the packet size of the DTP Load. It might be help.

Thank you.

Regards,

Pradeep

[former_member199691]

did you try running the DTP after reducing the number of parallel processes to 1?

[former_member199691]

If package is failing with SQL error/short dump, reduce the number of parallel processes to 1 for that DTP and execute the DTP again, it should work.

[Former Member]

Hi Sai,

We need to know the error message occuring so that we could provide possible solutions.

A snapshot or text would do.

Did some system activity happened 3 days ago?

Br,

Arpit

[former_member190729]

Hi,

Please help us with the error message.

Regards,

Sourabh Deo

[MGrob]

Hi

As the other said share the log for a better help. Make sure the dtp doesn't time out and gets red before it's actually finished loading data. (check the settings in the dtp).

Are you cleaning the psa table periodically or is the full dtp loading more and more requests that sit in PSA?

hope this helps

Martin

[former_member199691]

what is the error it is showing for failed package?

[RamanKorrapati]

hi,

please explore the failed data packet in detailed. without finding the exact error you can't get rid of it.

pls share error details

thanks