UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

SQLTimoutException in uCMDB - SM

Occasional Contributor

SQLTimoutException in uCMDB - SM

When trying to push the data into SM from uCMDB, we are getting the below error.

 

java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
at com.mercury.jdbc.oraclebase.ddb7.b(Unknown Source)
at com.mercury.jdbc.oraclebase.ddb7.a(Unknown Source)
at com.mercury.jdbc.oraclebase.ddb6.b(Unknown Source)
at com.mercury.jdbc.oraclebase.ddb6.a(Unknown Source)
at com.mercury.jdbc.oraclebase.ddej.a(Unknown Source)
at com.mercury.jdbc.oraclebase.ddej.r(Unknown Source)
at com.mercury.jdbc.oraclebase.ddej.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalStatementImpl.executeQuery(CmdbDalStatementImpl.java:249)
... 65 more

at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessCommunicationException(ExceptionConverter.java:146)
at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:29)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:57)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:42)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:62)
... 21 more

 

And we are able to execute the query manually in DB and it is happening for only one table and others are working fine in the integration job.

Kindly help to resolve this.

//Add this to "OnDomLoad" event