- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Error while processing large file using RFC lookup...
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Error while processing large file using RFC lookup.
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 05-07-2012 6:00 AM
Hello Friends,
I am working on file to Proxy scenario. I have done RFC lookup to fetch values from tables which is maintained in PI abap stack. If the file contains 200-250 records then lookup works fine but if fie size is large (250 records or more then that) then it gives error as can not perform rfc lookup.
Error when calling an adapter by using the communication channel CC_MAP_RFC_RCV (Party: , Service: PPI, Object ID: 8325d87b2b743e7883abb3dfec24c6c7) Connection to system af.ppi.sdbnpi using application AF lost. Detailed information: Error accessing "http://SPNPI2:56700/AdapterFramework/adapteraccess/int?container=web" with user "PIISUSER". Response code is 500, response message is "Internal Server Error" at com.sap.aii.ibrun.server.lookup.AdapterProxyRemote.<
The receiver RFC channel has configured correctly and is active. It is working fine for other scenarios.
I have done the cache refresh couple of time and have restarted the java server too.
have anybody faced the same problem.Your valuable suggetions will be appritiated.
Thanks,
Jayesh.
The details error log is as
RuntimeException during appliction Java mapping com/sap/xi/tf/_MM_PVAS_To_SAPCRM_ Thrown: com.sap.aii.mappingtool.tf7.MessageMappingException: Runtime exception when processing target-field mapping /ns0:MT_PVASRgcs_RCV/Recordset/Details[501]/PcardType; root message: Cannot perform RFC lookup at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:456) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:407) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:407) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:407) at com.sap.aii.mappingtool.tf7.AMappingProgram.start(AMappingProgram.java:496) at com.sap.aii.mappingtool.tf7.Transformer.start(Transformer.java:133) at com.sap.aii.mappingtool.tf7.AMappingProgram.transform(AMappingProgram.java:626) at com.sap.aii.ib.server.mapping.execution.JavaMapping.executeStep(JavaMapping.java:92) at com.sap.aii.ib.server.mapping.execution.Mapping.execute(Mapping.java:60) at com.sap.aii.ib.server.mapping.execution.MappingHandler.map(MappingHandler.java:87) at com.sap.aii.ib.server.mapping.execution.MappingHandler.map(MappingHandler.java:71) at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleMappingRequest(MappingRequestHandler.java:119) at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleRequest(MappingRequestHandler.java:72) at com.sap.aii.ibrun.sbeans.mapping.MappingServiceImpl.processFunction(MappingServiceImpl.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:43) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177) at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133) at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164) at $Proxy695_10000.processFunction(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:183) at com.sap.engine.services.rfcengine.RFCJCOServer$J2EEApplicationRunnable.run(RFCJCOServer.java:269) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:152) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:247) Caused by: com.sap.aii.mapping.api.StreamTransformationException: Cannot perform RFC lookup at com.sap.aii.mappingtool.flib7.RfcLookup.cacheMore(RfcLookup.java:105) at com.sap.aii.mappingtool.tf7.rt.AMultiResIterator$MultiOutIterator.gotoNextContext(AMultiResIterator.java:105) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:315) ... 46 more Caused by: com.sap.aii.mapping.lookup.LookupException: Error when calling an adapter by using the communication channel CC_MAP_RFC_RCV (Party: , Service: PPI, Object ID: 8325d87b2b743e7883abb3dfec24c6c7) Connection to system af.ppi.sdbnpi using application AF lost. Detailed information: Error accessing "http://SPNPI2:56700/AdapterFramework/adapteraccess/int?container=web" with user "PIISUSER". Response code is 500, response message is "Internal Server Error" at com.sap.aii.ibrun.server.lookup.AdapterProxyRemote.<init>(AdapterProxyRemote.java:40) at com.sap.aii.ibrun.server.lookup.SystemAccessorInternal.getProxy(SystemAccessorInternal.java:122) at com.sap.aii.ibrun.server.lookup.SystemAccessorInternal.<init>(SystemAccessorInternal.java:46) at com.sap.aii.ibrun.server.lookup.LookupRegistration$LocalClient.getSystemAccessor(LookupRegistration.java:72) at com.sap.aii.mapping.lookup.LookupService.getRfcAccessor(LookupService.java:258) at com.sap.aii.mappingtool.flib7.RfcLookup.cacheMore(RfcLookup.java:78) ... 48 more Caused by: com.sap.aii.utilxi.hmi.api.HmiCoreException: Connection to system af.ppi.sdbnpi using application AF lost. Detailed information: Error accessing "http://SPNPI2:56700/AdapterFramework/adapteraccess/int?container=web" with user "PIISUSER". Response code is 500, response message is "Internal Server Error" at com.sap.aii.utilxi.hmi.api.HmiCoreException.newCommunicationError(HmiCoreException.java:85) at com.sap.aii.utilxi.hmi.api.HmiHttpJDKClient.sendRequestAndReceiveResponse(HmiHttpJDKClient.java:183) at com.sap.aii.utilxi.hmi.api.HmiClientAdapter.invokeMethod(HmiClientAdapter.java:92) at com.sap.aii.ibrun.server.lookup.AdapterAccessHmiClient.<init>(AdapterAccessHmiClient.java:95) at com.sap.aii.ibrun.server.lookup.AdapterAccessHmiClient.getInstance(AdapterAccessHmiClient.java:150) at com.sap.aii.ibrun.server.lookup.AdapterProxyRemote.<init>(AdapterProxyRemote.java:32) ... 53 more</Trace>
- SAP Managed Tags:
- SAP Process Integration
Accepted Solutions (0)
Answers (1)
Answers (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
>>>If the file contains 200-250 records then lookup works fine but if fie size is large (250 records or more then that) then it gives error as can not perform rfc lookup.
but you're doing one lookup for the whole file right ? and not 200-250 RFC calls (one per each record) ?
please make sure you're doing one call and not one per each record
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- SAP Build Process Automation Pre-built content for Finance Use cases in Technology Blogs by SAP
- Start page of SAP Signavio Process Insights, discovery edition, the 4 pillars and documentation in Technology Blogs by SAP
- Making an API call and unzipping a file in Datasphere in Technology Q&A
- Exploring Integration Options in SAP Datasphere with the focus on using SAP extractors - Part II in Technology Blogs by SAP
- SAP Datasphere インテリジェントルックアップ : 名寄せ機能のご紹介 in Technology Blogs by SAP
| User | Count |
|---|---|
| 83 | |
| 10 | |
| 10 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.