Infopackage fails first time in PC but runs fine when restarted

[former_member420526]

Hi all,

Our COPA Infopackage has been failing the last several days (no changes have been made recently). This infopackage is scheduled through a process chain that runs several times a day. The infopackage fails pretty much immediately after only 7s. The error message in BI only says that there's an error in the source system. However, I see no short dumps or failed jobs in ERP. The corresponding job in SAP actually finishes successfully. When restarting the infopackage step again in the Process Chain monitor the infopackage runs successfully. This isn't a source system issue connection issue, otherwise it would affect other datasources as well. I've tried replicating and reactivating the datasource but that didn't help. We are running SAP_BW 701 Support Package 7

Thank you for your help.

Anthony

[navinash]

Hi All, I am also facing this issue (i.e. one run of IP is failing and 2nd run or repeat of it is getting successful) now in my system, anyone know how this can be resolved.

[navinash]

Hi All, I am also facing this issue now in my system, anyone know how this can be resolved.

[navinash]

I am able to resolve issue I am facing by performing an initialization without data transfer which inserted the entry into the table ROOSGENDLM in ECC system. Later I modify the entry or timestamp for that entry using a custom report program to get all the missing delta data pulled as a delta from ECC to BW.

[john_hawk]

Hi Anthony,

If these SAP Notes don't provide a solution, it's time to open an SAP Incident

1136930 - 71SP06: Static COUNTER not reset

https://launchpad.support.sap.com/#/notes/1136930

2143942 - BW fetched double data from ECC for COPA datasource

https://launchpad.support.sap.com/#/notes/2143942/E

2130158 - SAPI - duplicate data for parallel extraction from several BW systems

https://launchpad.support.sap.com/#/notes/2130158

Don't forget to record the final answer!

John Hawk

[former_member420526]

I did some more troubleshooting in RSA3 in ERP as I am also getting an error in this transaction - "Error occurred during the extraction". No other details.

I debugged and found that the issue is because table ROOSGENDLM is missing an entry to my COPA datasource. My understanding is that this table manages the delta flag for generic datasources so this makes sense why there is an error now. However, I've tried re-initializing my datasource several times and tried again replicating and activating it but I can't get the system to add an entry to that table.

[john_hawk]

Please provide screen shot of error as seen in both the process chain log and in the data load monitor.

[former_member420526]

Hi John,

There are no meaningful details in either the process chain log or data load monitor. I've determined that the issue is on the ERP side due to missing entries in table ROOSGENDLM.

Here are the screenshots of the BI logs so you can see.

pic1.png