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

SQLTimoutException in uCMDB - SM

Highlighted
Poornima1
Occasional Advisor

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