WORKLOAD ANALYSIS (INTROSCOPE DATA) - Error when opening an RFC connection

[nicholas_chang]

Hi all SDNers,

Help is needed on error "WORKLOAD ANALYSIS (INTROSCOPE DATA) - Error when opening an RFC connection".

This error occured on RCA -> Extractor FWK administration and go to managed system (PI) and from the log, i can see some extraction failed due to error message " Error when opening an RFC connection"

consequently, JAVA performance data is not appearing in RCA -> workload analysis but work fine for ABAP and adapter engine.

I've followed below notes and perform the troubleshooting step by step by still to no avail:

Note 1332428 - Missing data in service sessions from BI/CCDB

Note 1257308 - FAQ: Using EarlyWatch Alert

Note 1274287 - End-to-End Diagnostics 7.0 EHP1 SP18 to SP27

Note 1265070 - Diagnostics - Setup of Managed Systems

Note 1010428 - End-to-End Diagnostics

http://wiki.sdn.sap.com/wiki/display/SMSETUP/WorkloadAnalysis-Noapplicabledatafound

steps that have performed:

restarted agent

enlarge RFC resource cap for solmandiag and none

delete entire SID in SMSY and pull again from SLD, re-setup managed system

restart PI system

i've spent 2 days on troubleshooting this issue but lack of information in SMP and SDN, even in google.

in table E2E_EFWK_STATUS and extractor E2E_JAVA_EXTRACTOR_IF, i see all WLI_ID ended with RC 96, MESSAGE = Error when opening an RFC connection and LASTRECORDS = 0

I strongly believe this is the issue that causing no applicable data found for JAVA data.

fyi, we are on SOLMAN EHP1 SPS27.

Any kind advise is most welcome.

Thanks,

Nicholas Chang

[nicholas_chang]

the funny part is it failed intermittently but sometimes the status for that specific context is green......

[allam_drebes]

Hello Nicholas,

The return code 96 means that the RFC WEBADMIN or SOLMANDIAG are not working. Check these RFCs in transaction SM59.

Regards,

Allam

[nicholas_chang]

Both connection tested fine in SM59 -> TCP/IP all the while. No problem with the connection, also MPAR*

Any other issue? Will restart of Solman helps?

[nicholas_chang]

Gosh! at last i found the solution!!

I appreciate those who tried to help and i''m sharing the solution as i believe this is the purpose of SDN Forum and help others Netweaver Chap who facing the same problem:

Problem faced:

Extractor failed intermittently for WORKLOAD ANALYSIS (Introscope Data) due to error message "Error when opening an RFC connection"

Due to the above error, performance data is not available in RCA workload analysis for J2EE engine.

Possible Solution:

1) Ensure both webadmin & SOLMANDIAG RFC working fine -> SM59 -> TCP/IP

2) go to SE16 -> E2E_RESOURCES and change the resourcecap to 10 for SOLMANDIAG

3) go to /smd/services -> Diagnostic System -> Advanced Setup -> Abap connectivity -> Connection Configuration and change server count to 10

4) Restart webadmin (step 3 & 4 can perform in VA too)

5) set gw/keepalive & gw/reg_keepalive to value 0 in RZ11 (without reboot of instance)

5) again go to SM59 -> TCP/IP -> SOLMANDIAG and put in the gateway host and gateway service correctly, don't leave this empty!!!! -

---

> This is the main solution to solve intermittent failed RFC for extractor.

Now, go back and monitor the extractor log and you should see no RFC error anymore and wait for 1 hour for the data to populate.

Thanks!

Nicholas Chang,

[guilherme_balbinot]

Hello,

I have included this information on the Wiki.

http://wiki.sdn.sap.com/wiki/display/SM/FAQRootCause+Analysis

Thank you for sharing your solution. In fact we had all these steps on our recommendation list for the customers, but you were very good at summarizing and even by including steps that we didn't consider

Best regards,

Guilherme Balbinot

Support Enginner

[nicholas_chang]

Hi Guilherme Balbinot!

Nice and resourceful WIKI! Thanks for compiling all the info and glad that i can help my bit!

cheers,

Thanks,

Nicholas Chang