Info Package is not fetching data return error IDOC TRFC missing

[Former Member]

Hi Experts,

I am executing info package and it is not fetching any record request is still yellow, returning error is missing IDOC and TRFC. Initially I think it is related to authorization but when I checked I have authorization for SAP_ALL.

Below I am attaching the error I am receiving every time when I execute InfoPack after a long time this request becomes red. I have checked with Basis  he also does not know about it.

Please through some light from your experience I am badly stuck here.

Thanks in Adavnce

Ansh

[former_member590969 · Accepted solution]

Hi,

First check your source system connection check.

Check partner profile (WE20) is active or not with basis help.

Thanks,

Durai

[Former Member · Accepted solution]

Hi Experts,

My problem is still not resolved. Our Basis team has checked in WE20 and IDOCS and SM58 he said nothing is wrong with the connection and they have not done any reconfiguration recently.

We are not able to extract any data from ecc from April but suddenly our requests ran on 11 may automatically and fetched the data anl all the requests are green now, but I try to load now it is stuck in yellow and later it turns to RED with error TRFC and IDOC missing.

Below, I have some screen shot on which i need your expert help, please help me to understand what is this issues related to. If I check these table in SE16 there is no number of entry. What are these table related to?

This is from WE20

This is from sm58

Please help me where to check and what need to check. I have read in SCN that should check ALEREMOTE, I tried to check that also and found Profiles exist in that.

Experts I am really stuck here.

your any input would be great help.

Regards

Ansh

[RamanKorrapati · Accepted solution]

Ask your DB/oracle team help. Some DB tables are not allowing to get the data.

above error clearing saying SQL issue at SM58.

if not solved then raise to SAP.

.

[Former Member · Accepted solution]

Hi All,

The Problem has been resolved now.

This was because of one InfoPack which was running very long period of time and my colleague has not told anything and it was trying to fetch more than 9 figure of data but we do not have that much of data in tables, And in making of view on table she did mistake she has marked everything as key field.

Does this can be a cause of this problem as she has mark everything as key field in table View and created DS on View and executed infopack for full load, Also it was Standard Table?

so what I did I have cleared off all the infopackage related to that view and data source from BW system than try new load with another infopack and ran successful.

I really appreciate your help and your ideas you have provided.

Thanks

Ansh