Hi Guys,
We are facing some strange performance issue with one of our Data Manager Manger package.This DM package executes a
Script logic file [No BADI] which does basic currency translation and posts to 3 different Versions.
We have had no prior problems with it, it used to work just fine. Usually takes around 3-4 hours to complete [creates around 2.5 million records].
1) We scheduled the DM few days ago & we had to cancel the job after 40 hours [ created around 1.8 million records].It was just hanging.
2) We dropped the SID Temp tables, recreated around 50 SID temp tables.Ran Light optimize, created indices & Statistics and rerun the DM package.
This time it ran for 4 hours and got completed successfully [created around 2.5 million records].
3) We tried to repeat the same process to make sure the the issue got resolved permanently but job didn't complete even after 14 hours.
so we are back to square one now .
A high priority ticket with SAP has been raised and even they couldn't identify / Solve this issue after 6 days.
Looks like all the OS , DB & BPC application parameter settings are OK. No Locks were found either.
We found this note 2193161, which advises to run Full Optimization & this makes my client very nervous.
also that'll change the Model tech name and mess up the Transport process.
We are in BPC 10.1 SP 08 , BW 7.4 SP 13 & EPM add-in SP 25.
Any suggestion is much appreciated.
Regards,
Nava