AnsweredAssumed Answered

Cannot get a connection, pool error Could not create a validated object, cause: ValidateObject failed

Question asked by onivationgmbh on Oct 13, 2016
Latest reply on Oct 13, 2016 by onivationgmbh

Hello guys

 

I'm nearly new to Dell Boomi and try to setup an connection between SAP and Salesforce.

I followed the following documentation: https://community.boomi.com/docs/DOC-2544#jive_content_id_SAP_Configuration_for_Idoc_Integration

 

But, currently I'm facing the following Exception - Does anybody knows anything about this issue?

 

 

 

13.10.2016 09:49 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler checkTID]

checkTID called for TID=0A65116324A057FF3C83577A

13.10.2016 09:49 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler checkTID] Not handling TID, TID= 0A65116324A057FF3C83577A (Cannot get a connection, pool error Could not create a validated object, cause: ValidateObject failed)
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.boomi.connector.sap.listener.SAPTIDHandler.checkTID(SAPTIDHandler.java:93)
at com.sap.conn.jco.rt.DefaultServerWorker.onCheckTID(DefaultServerWorker.java:202)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.playbackTRfc(MiddlewareJavaRfc.java:2947)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.handletRfcRequest(MiddlewareJavaRfc.java:2880)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.listen(MiddlewareJavaRfc.java:2679)
at com.sap.conn.jco.rt.DefaultServerWorker.dispatch(DefaultServerWorker.java:275)
at com.sap.conn.jco.rt.DefaultServerWorker.loop(DefaultServerWorker.java:356)
at com.sap.conn.jco.rt.DefaultServerWorker.run(DefaultServerWorker.java:232)
at java.lang.Thread.run(Unknown Source)
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1191)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 10 more
13.10.2016 09:49 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler confirmTID] confirmTID called for TID=0A65116324A057FF3C83577A
13.10.2016 09:49 Uhr MESZ SCHWERWIEGEND [com.boomi.connector.sap.listener.SAPTIDHandler updateStatus] Unable to update status of 0A65116324A057FF3C83577A to CONFIRMED
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.boomi.connector.sap.listener.SAPTIDHandler.updateStatus(SAPTIDHandler.java:259)
at com.boomi.connector.sap.listener.SAPTIDHandler.confirmTID(SAPTIDHandler.java:153)
at com.sap.conn.jco.rt.DefaultServerWorker.onConfirmTID(DefaultServerWorker.java:215)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.handletRfcConfirm(MiddlewareJavaRfc.java:3193)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.listen(MiddlewareJavaRfc.java:2689)
at com.sap.conn.jco.rt.DefaultServerWorker.dispatch(DefaultServerWorker.java:275)
at com.sap.conn.jco.rt.DefaultServerWorker.loop(DefaultServerWorker.java:356)
at com.sap.conn.jco.rt.DefaultServerWorker.run(DefaultServerWorker.java:232)
at java.lang.Thread.run(Unknown Source)
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1191)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 10 more

 

 

Best regards,

Chris

 

 

++++++++ UPDATE ++++++++

 

Now i get the following Exception:

 

13.10.2016 13:19 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler checkTID] checkTID called for TID=0A65116319B057FF6DD41E2E
13.10.2016 13:19 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler checkTID] Not handling TID, TID= 0A65116319B057FF6DD41E2E (Cannot create PoolableConnectionFactory (validationQuery didn't return a row))
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (validationQuery didn't return a row)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.boomi.connector.sap.listener.SAPTIDHandler.checkTID(SAPTIDHandler.java:93)
at com.sap.conn.jco.rt.DefaultServerWorker.onCheckTID(DefaultServerWorker.java:202)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.playbackTRfc(MiddlewareJavaRfc.java:2947)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.handletRfcRequest(MiddlewareJavaRfc.java:2880)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.listen(MiddlewareJavaRfc.java:2679)
at com.sap.conn.jco.rt.DefaultServerWorker.dispatch(DefaultServerWorker.java:275)
at com.sap.conn.jco.rt.DefaultServerWorker.loop(DefaultServerWorker.java:356)
at com.sap.conn.jco.rt.DefaultServerWorker.run(DefaultServerWorker.java:232)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: validationQuery didn't return a row
at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:660)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 11 more
13.10.2016 13:19 Uhr MESZ INFORMATION [com.boomi.connector.sap.listener.SAPTIDHandler confirmTID] confirmTID called for TID=0A65116319B057FF6DD41E2E
13.10.2016 13:19 Uhr MESZ SCHWERWIEGEND [com.boomi.connector.sap.listener.SAPTIDHandler updateStatus] Unable to update status of 0A65116319B057FF6DD41E2E to CONFIRMED
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (validationQuery didn't return a row)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.boomi.connector.sap.listener.SAPTIDHandler.updateStatus(SAPTIDHandler.java:259)
at com.boomi.connector.sap.listener.SAPTIDHandler.confirmTID(SAPTIDHandler.java:153)
at com.sap.conn.jco.rt.DefaultServerWorker.onConfirmTID(DefaultServerWorker.java:215)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.handletRfcConfirm(MiddlewareJavaRfc.java:3193)
at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.listen(MiddlewareJavaRfc.java:2689)
at com.sap.conn.jco.rt.DefaultServerWorker.dispatch(DefaultServerWorker.java:275)
at com.sap.conn.jco.rt.DefaultServerWorker.loop(DefaultServerWorker.java:356)
at com.sap.conn.jco.rt.DefaultServerWorker.run(DefaultServerWorker.java:232)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: validationQuery didn't return a row
at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:660)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 11 more

Outcomes