DTP load issue in Process Chain

[fthomazetti_costa]

Hello Experts,

I'm having an issue in some DTPs in my process chain.

I've a huge process chain, that is segregated in several small steps.

The big ones are executed first and the small ones later. I almost have no dependences.

When I made and checked the process chain for the first time, my system warned me that I'll try to execute a lot of processes in parallel, but I don't have backgrounds enough for it, then I organized my process chain and removed the parallel processes. Now it takes more time to execute, but is done one by one.

Every single day at 7am my process chain starts through a Job plan. It takes about a 2 hours and finished. No errors, no issues, everything is green, but when I'll check the result, some DTPs loads 0 records.

I've 4 small process and each one have two DTPs. I don't have a historical issue, I mean, yesterday one of DTPs loads 0 registers, today two DTPs loads 0 registers, tomorrow one DTP again and another day three DTPs and etc... The "error" happens with different DTPs each day.

How I solved this? I execute the step with the "error" manually and the DTPs works normally.

Is not a authorization problem, DTP problem, settings problems or something related, because as I said, today the DTP X have this behavior, tomorrow it works and another DTP have this behavior. Each day I've this issue with some DTP. I don't have a day that all DTPs works. I've this issue everyday.

I've never saw this kind of error before. My basis team neither.

Someone could help me?

Thanks,

Flávio Thomazetti

[fthomazetti_costa · Accepted solution]

Hello All,

I don't know where is the relation, but I've changed again my process chain.

I've segregated a little more the steps and included some "ANDs" to work as a break-point.

Now, my 4 small process that was having issues in the DTPs are working. But, some steps back, I have an ODS that sends data to another ODS with problem.

There are no filters in the DTP or complex rules in the transformation. I've only included one more infoobject in the second ODS. Example, field VALUE sends the original register to another field VALUE and sends a negative value to VALUE2.

I've around 2,5 millions of registers in this ODS. Last monday it worked fine. Yesterday, it sent only 2,3 millions of registers, and today only 2,4 milions.

If I execute manually, I mean start the process chain from the beggining, it sends all the 2,5 millions of registers.

I don't know why these kind of errors are happening...

[RafkeMagic]

is there a locking issue maybe?

[Former Member]

Hello Flávio,

Your issue is not common. I think you can raise a message to SAP.

Regards.