UWL Performance issue

[Former Member]

We have recently configured UWL Delta pull mechanism. We got some issues, manual refresh by selecting Refresh action from the tray icon on the UWL inbox, the refresh time is very long and it takes more than 10 mins most times.

Another issue is, we see below error message in the log file

java.lang.Exception: Problem retrieving JCO.Function object object while reading R3 system information.

at com.sap.netweaver.bc.uwl.utils.r3.R3SystemInfo.createJCOFunction(R3SystemInfo.java:88)

at com.sap.netweaver.bc.uwl.core.connect.abap.functions.UwlGetItemsProxy.execute(UwlGetItemsProxy.java:55)

at com.sap.netweaver.bc.uwl.core.connect.abap.OptimizedRetriever.getItems(OptimizedRetriever.java:95)

at com.sap.netweaver.bc.uwl.core.connect.webflow.WebflowConnector.getItems(WebflowConnector.java:2039)

at com.sap.netweaver.bc.uwl.core.pull.PullChannel.getItems(PullChannel.java:52)

at com.sap.netweaver.bc.uwl.core.pull.PullThread.run(PullThread.java:64)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.beforeAssigningUserToChannel(PullChannelManager.java:399)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.assignUserToChannel(PullChannelManager.java:427)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.onUserLoggedIn(PullChannelManager.java:236)

at com.sap.netweaver.bc.uwl.core.session.SessionEventDispatcherThread.run(SessionEventDispatcherThread.java:29)

at com.sap.netweaver.bc.uwl.core.ThreadManager$PoolWorker.run(ThreadManager.java:191)

Could anyone shed some light what possibly could be happening and how to fix it?

We have custom webflow connector XML file to connect to backend system where all task ids are defined.

Thanks

Siva

[pctan]

Also check the UWL destination RFC user's backend authorization profile.

[Former Member]

This is the message we are getting when we do manual refresh, has anyone faced this issue?

java.lang.Exception: Problem retrieving JCO.Function object object while reading R3 system information.

at com.sap.netweaver.bc.uwl.utils.r3.R3SystemInfo.createJCOFunction(R3SystemInfo.java:88)

at com.sap.netweaver.bc.uwl.core.connect.abap.functions.UwlGetItemsProxy.execute(UwlGetItemsProxy.java:55)

at com.sap.netweaver.bc.uwl.core.connect.abap.OptimizedRetriever.getItems(OptimizedRetriever.java:95)

at com.sap.netweaver.bc.uwl.core.connect.webflow.WebflowConnector.getItems(WebflowConnector.java:2039)

at com.sap.netweaver.bc.uwl.core.pull.PullChannel.getItems(PullChannel.java:52)

at com.sap.netweaver.bc.uwl.core.pull.PullThread.run(PullThread.java:64)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.beforeAssigningUserToChannel(PullChannelManager.java:399)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.assignUserToChannel(PullChannelManager.java:427)

at com.sap.netweaver.bc.uwl.core.pull.PullChannelManager.onUserLoggedIn(PullChannelManager.java:236)

at com.sap.netweaver.bc.uwl.core.session.SessionEventDispatcherThread.run(SessionEventDispatcherThread.java:29)

at com.sap.netweaver.bc.uwl.core.ThreadManager$PoolWorker.run(ThreadManager.java:191)

[Former Member]

Hello,

Were you able to find the cause of this issue ? How did you fix it ?

Thanks,

aidan

[Former Member]

The issue was with the version of EP we were using 7 SP14, the issue is fixed in SP21. The manual refresh takes longer due to KM caching if you have more work items in inbox. The KM SQL query needs optimisation on EP database. Once we upgraded to SP21 patch level the issue is resolved.

Hope this helps.