SAP Knowledge Base Article - Preview

2614016 - com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported

Symptom

You would like to import a table structure from a database to use it as external definition when developing a new scenario in Enterprise Services Builder. You have created a JDBC receiver channel to connect to the database. When you try to display the tables from the database in the Enterprise Services Builder you get the following error:

tableimport.png

In the default traces you notice the following error:

Thrown:
com.sap.aii.utilxi.hmi.api.HmiMethodFault: Exception during processing the payload. Error when calling an adapter by using the communication channel Informix_JDBC (Party: *, Service: COMPONENTNAME, Object ID: objectID) XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported'.
com.sap.aii.mapping.lookup.LookupException: Error when calling an adapter by using the communication channel Informix_JDBC (Party: *, Service: COMPONENTNAME, Object ID: objectID) XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported'.
at com.sap.aii.ibrun.server.lookup.AdapterProxyLocal.process(AdapterProxyLocal.java:92)
at com.sap.aii.ibrun.server.lookup.SystemAccessorInternal.call(SystemAccessorInternal.java:55)
at com.sap.aii.ibrun.server.lookup.SystemAccessorHmiServer.process(SystemAccessorHmiServer.java:140)
at com.sap.aii.ibrun.server.lookup.SystemAccessorHmiServer.process(SystemAccessorHmiServer.java:73)
at com.sap.aii.utilxi.hmis.server.HmisServiceImpl.invokeMethod(HmisServiceImpl.java:139)
at com.sap.aii.utilxi.hmis.server.HmisServer.process(HmisServer.java:224)
at com.sap.aii.utilxi.hmis.web.HmisServletImpl.processRequestByHmiServer(HmisServletImpl.java:371)
at com.sap.aii.utilxi.hmis.web.HmisServletImpl.processRequestByHmiServer(HmisServletImpl.java:272)
at com.sap.aii.utilxi.hmis.web.workers.HmisInternalClient.doWork(HmisInternalClient.java:70)
at com.sap.aii.utilxi.hmis.web.HmisServletImpl.doWork(HmisServletImpl.java:571)
at com.sap.aii.utilxi.hmis.web.HmisServletImpl.doPost(HmisServletImpl.java:712)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

Caused by: com.sap.aii.af.service.api.AFException: XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported'.
at com.sap.aii.af.service.api.AdapterAccess.call(AdapterAccess.java:122)
at com.sap.aii.ibrun.server.lookup.AdapterProxyLocal.process(AdapterProxyLocal.java:83)
... 53 more
Caused by: com.sap.aii.af.service.api.AFException: XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported'.
at com.sap.aii.af.service.api.AdapterAccess.sendMsg(AdapterAccess.java:216)
at com.sap.aii.af.service.api.AdapterAccess.call(AdapterAccess.java:101)
... 54 more
Caused by: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: SQLException: Transactions not supported
at com.sap.aii.adapter.jdbc.util.ExceptionUtil.throwRecoverModuleException(ExceptionUtil.java:49)
at com.sap.aii.adapter.jdbc.XI2JDBC.processMessage(XI2JDBC.java:813)
at com.sap.aii.adapter.jdbc.XI2JDBC.dispatchMessage(XI2JDBC.java:258)
at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:215)
at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:258)
at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:179)
at sun.reflect.GeneratedMethodAccessor528.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)


Read more...

Environment

  • PI Release Independent
  • SAP NetWeaver
  • SAP Process Integration

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP NetWeaver Process Integration 7.1 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 1 for SAP NetWeaver Process Integration 7.1 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

com.sap.aii.af.lib.util.concurrent.ResourcePoolException, ResourcePoolException, Unable to create new pooled resource, Transactions not supported, SQLException, Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.40, PI 7.40, PO 7.40, Process Orchestration 7.50, PI 7.50, PO 7.50, NetWeaver, XI , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.