RFC Lookup fails with QUERY_TABLE not active in Dictionary

[former_member187587]

I am using SAP PI 7.1 EHP1.

When performing mapping test with an RFC Lookup usign the RFC_READ_TABLE RFC I am getting the follwoing error.

Also , when performing Display Queue I get 2 response records for each value (one with empty context and one with data) instead of just one.

Did anyone Experiance such case?

1. RFC in SE37 runs correctly with the same values.
2. The table exists in SAP Application.

This is the debug of the mapping:

14:05:37 Start of test 

Compilation of BusinessPartnersPackage_MM successful
Unhandled RFC exception:
<rfc:RFC_READ_TABLE.Exception xmlns:rfc="urn:sap-com:document:sap:rfc:functions"><Name>TABLE_NOT_AVAILABLE</Name><Text>QUERY_TABLE not active in Dictionary</Text><Message><ID>SV</ID><Number>029</Number></Message><Attributes><V1>ZZTAB_COUNTRY</V1></Attributes></rfc:RFC_READ_TABLE.Exception>
com.sap.aii.mapping.api.StreamTransformationException: Unhandled RFC exception:
<rfc:RFC_READ_TABLE.Exception xmlns:rfc="urn:sap-com:document:sap:rfc:functions"><Name>TABLE_NOT_AVAILABLE</Name><Text>QUERY_TABLE not active in Dictionary</Text><Message><ID>SV</ID><Number>029</Number></Message><Attributes><V1>ZZTAB_COUNTRY</V1></Attributes></rfc:RFC_READ_TABLE.Exception>
at com.sap.aii.mappingtool.flib7.RfcLookup.cacheMore(RfcLookup.java:95)
at com.sap.aii.mappingtool.tf7.rt.AMultiResIterator$MultiOutIterator.gotoNextContext(AMultiResIterator.java:103)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:315)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:408)
at com.sap.aii.mappingtool.tf7.AMappingProgram.start(AMappingProgram.java:498)
at com.sap.aii.mappingtool.tf7.Transformer.start(Transformer.java:142)
at com.sap.aii.mappingtool.tf7.AMappingProgram.transform(AMappingProgram.java:631)
at com.sap.aii.ibrep.server.mapping.exec.ExecuteXiMappingCommand.transformInternal(ExecuteXiMappingCommand.java:197)
at com.sap.aii.ibrep.server.mapping.exec.ExecuteXiMappingCommand.execute(ExecuteXiMappingCommand.java:94)
at com.sap.aii.ib.server.mapping.exec.CommandManager.execute(CommandManager.java:43)
at com.sap.aii.ibrep.server.mapping.ServerMapService.execute(ServerMapService.java:40)
at com.sap.aii.ibrep.server.mapping.MapServiceBean.execute(MapServiceBean.java:40)
at sun.reflect.GeneratedMethodAccessor548_10002.invoke(Unknown Source)
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 $Proxy1525_10002.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor547_10002.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:234)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:351)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:70)
at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:62)
at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:37)
at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:872)
at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:53)
at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:58)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:108)
at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:304)
Runtime exception when processing target-field mapping /ZCRMXIF_PARTNER_SAVE_M03/IDOC/E101CRMXIF_PARTNER_COMPLEX/E101BUS_EI_CENTRAL_DATA/E101BUS_EI_ADDRESS/E101BUS_EI_BUPA_ADDRESS/E101US_EI_BUPA_ADDRESS_DATA/E101_EI_BUPA_POSTAL_ADDRESS/E101BUS_EI_STRUC_ADDRESS/COUNTRY; root message: Unhandled RFC exception:
<rfc:RFC_READ_TABLE.Exception xmlns:rfc="urn:sap-com:document:sap:rfc:functions"><Name>TABLE_NOT_AVAILABLE</Name><Text>QUERY_TABLE not active in Dictionary</Text><Message><ID>SV</ID><Number>029</Number></Message><Attributes><V1>ZZTAB_COUNTRY</V1></Attributes></rfc:RFC_READ_TABLE.Exception>

14:05:39 End of test

[Former Member · Accepted solution]

I see you set ZZTAB_COUNTRY as import parameter QUERY_TABLE for your RFC. So you have a database table called ZZTAB_COUNTRY in the backend system/client, and the RFC receiver channel is pointing to the proper backend system/client? Any ABAP transports regarding ZZTAB_COUNTRY required to import in the corresponding backend system/client?

[former_member187587 · Accepted solution]

Martin,

As I mentioned in my post : Running the same RFC on se377 with the same values on the same client

result in sucessfull response.

[Former Member · Accepted solution]

The RFC receiver channel is pointing to the proper backend system/client?

Any ABAP transports containing ZZTAB_COUNTRY required to import in the corresponding backend system/client?

[former_member187587 · Accepted solution]

Had 2 RFC's set in this mapping.

During debugging switched between them.

Trace in the RWB showed both were called so it figured to be ok

But was pointing to a CRM system where table didn't exist.

[iaki_vila]

Hi Nimrod,

Have you checked the consistency table in the ECC?

se11->

It the table active?

Regards.