Highlighted
Super Contributor.
Super Contributor.
2971 views

Oracle JDBC Driver Execution timeout expired

Hello.

 

In the UCMDB error.log a lot of errors: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.

 

What could be causing this error? How to determine the cause of this error?

Best Regards, Sergy.
0 Likes
6 Replies
Highlighted
Established Member..
Established Member..

Re: Oracle JDBC Driver Execution timeout expired

Sergy,

 

Something is timing out.

Without more information, such as the error message or the RELATED thread that timed out, can't help with more information.

 

Erik

effectualsystems.com
0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: Oracle JDBC Driver Execution timeout expired

Thanks for reply.

 

The errors from UCMDB errors.log:

2014-05-19 06:34:47,913 [TasksDispatchingThread] (DiscoveryDestIPsDAO.java:68) ERROR - Failed to execute query:delete from CCM_DISCOVERY_DEST_IPS where DISCOVERY_DESTS_ID IN (SELECT ID FROM CCM_DISCOVERY_DESTS WHERE CUSTOMER_ID=? AND (STATUS=? OR STATUS=? OR STATUS=?)  AND TRIGGER_CI_ID IN ('7274910c956644480d79a456e0861071','46b5bab5be4a97dc8b19ada60ffca80a','4dd83ee20e1fd6f62b2d8ba8e4cbc8bc','4ce4eb1372003db6ff125ce18bd36168','599721ce49bc82038009
...........................
...........................
,'5fe67559fabfe9d3f8b3b3e8ae61f8d4'))
java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
	at com.mercury.jdbc.oraclebase.ddcr.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcr.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.s(Unknown Source)
	at com.mercury.jdbc.oraclebase.dddz.execute(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddd2.execute(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
	at com.hp.ucmdb.discovery.server.dal.DiscoveryDestIPsDAO.deleteRecordFromTable(DiscoveryDestIPsDAO.java:66)
	at com.hp.ucmdb.discovery.server.dal.DiscoveryDestDAO.deleteNotActiveDestinations(DiscoveryDestDAO.java:939)
	at com.hp.ucmdb.discovery.server.utils.disptach.actions.AbstractUndispatchTriggersActionFlow.undispatchObjectsFromJob(AbstractUndispatchTriggersActionFlow.java:104)
	at com.hp.ucmdb.discovery.server.utils.disptach.actions.AbstractUndispatchTriggersActionFlow.handle(AbstractUndispatchTriggersActionFlow.java:30)
	at com.hp.ucmdb.discovery.server.utils.disptach.DispatchManager$DispatchingThread.authorizedRun(DispatchManager.java:827)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread$1.executeInContext(AbstractAuthorizedThread.java:26)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread$1.executeInContext(AbstractAuthorizedThread.java:23)
	at com.mercury.topaz.cmdb.shared.manage.AuthorizationContextUtils.executeInSystemAuthorizationContext(AuthorizationContextUtils.java:24)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread.run(AbstractAuthorizedThread.java:23)

 

2014-05-19 08:16:19,341 [RequestProcessorAsyncPool-4666] (RequestProcessor.java:452) ERROR - appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : Can't execute callable statement [begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>'UCMDB', options=>'GATHER AUTO', no_invalidate=>false); end;], from connection [55853ed6], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired. : operation com.mercury.topaz.cmdb.shared.manage.customer.operation.update.impl.CmdbCustomerUpdateOptimizeStorage : class com.mercury.topaz.cmdb.shared.base.CmdbException : 
CMDB Internal Error: Error while handling request: {request: ID='f2485d2b3058529ff2f736ce86c54486' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.manage.customer.operation.update.impl.CmdbCustomerUpdateOptimizeStorage@7b2efd46' Customer ID='1' 
Context='CMDB Context: Customer id = '1' , User ID = '911' , Caller Application = 'AutoDiscovery''}
com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [-2147483648] undefined error code]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : Can't execute callable statement [begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>'UCMDB', options=>'GATHER AUTO', no_invalidate=>false); end;], from connection [55853ed6], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired. : operation com.mercury.topaz.cmdb.shared.manage.customer.operation.update.impl.CmdbCustomerUpdateOptimizeStorage
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:161)
	at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.doProcessRequest(RequestProcessor.java:211)
	at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.doProcessRequestWithQueueLimitation(RequestProcessor.java:220)
	at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.processRequest(RequestProcessor.java:184)
	at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.access$300(RequestProcessor.java:43)
	at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor$4.run(RequestProcessor.java:531)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)
	at java.lang.Thread.run(Thread.java:722)
Caused by: appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : Can't execute callable statement [begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>'UCMDB', options=>'GATHER AUTO', no_invalidate=>false); end;], from connection [55853ed6], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired. : operation com.mercury.topaz.cmdb.shared.manage.customer.operation.update.impl.CmdbCustomerUpdateOptimizeStorage
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:113)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:60)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
	at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowDefaultExecutor.execute(OperationInFlowDefaultExecutor.java:23)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:159)
	... 8 more
Caused by: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Can't execute callable statement [begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>'UCMDB', options=>'GATHER AUTO', no_invalidate=>false); end;], from connection [55853ed6], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalConnection.executeCallableStatement(CmdbDalConnection.java:396)
	at com.mercury.topaz.cmdb.server.dal.command.impl.CmdbDalRunStatisticsComplexCommand.executeSql(CmdbDalRunStatisticsComplexCommand.java:77)
	at com.mercury.topaz.cmdb.server.dal.command.impl.CmdbDalRunStatisticsComplexCommand.runStatistics(CmdbDalRunStatisticsComplexCommand.java:54)
	at com.mercury.topaz.cmdb.server.dal.command.impl.CmdbDalRunStatisticsComplexCommand.perform(CmdbDalRunStatisticsComplexCommand.java:48)
	at com.mercury.topaz.cmdb.server.dal.command.impl.CmdbDalRunStatisticsComplexCommand.perform(CmdbDalRunStatisticsComplexCommand.java:35)
	at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand$FlowControlDalCommandExecutor.execute(DalAbstractCommand.java:36)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:222)
	at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand.execute(DalAbstractCommand.java:54)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:120)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:105)
	at com.mercury.topaz.cmdb.shared.util.retry.impl.DefaultRetriableExecutorImpl.doExecute(DefaultRetriableExecutorImpl.java:37)
	at com.mercury.topaz.cmdb.shared.util.retry.impl.AbstractRetriableExecutor.execute(AbstractRetriableExecutor.java:37)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO.execute(CmdbDalJdbcDAO.java:81)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO.execute(CmdbDalJdbcDAO.java:73)
	at com.mercury.topaz.cmdb.server.dal.dao.impl.CmdbDalJdbcDataModelDAO.execute(CmdbDalJdbcDataModelDAO.java:100)
	at com.mercury.topaz.cmdb.server.dal.dao.impl.CmdbDalJdbcDataModelDAO.optimizeStorage(CmdbDalJdbcDataModelDAO.java:321)
	at com.mercury.topaz.cmdb.shared.manage.customer.operation.update.impl.CmdbCustomerUpdateOptimizeStorage.doExecute(CmdbCustomerUpdateOptimizeStorage.java:52)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:87)
	... 12 more

 

2014-05-19 08:55:41,274 [TasksDispatchingThread] (DiscoveryDestIPsDAO.java:68) ERROR - Failed to execute query:delete from CCM_DISCOVERY_DEST_IPS where DISCOVERY_DESTS_ID IN (SELECT ID FROM CCM_DISCOVERY_DESTS WHERE CUSTOMER_ID=? AND (STATUS=? OR STATUS=? OR STATUS=?)  AND TRIGGER_CI_ID IN ('b44e28d7f4453bcf12ce0e1564db477c'))
java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
	at com.mercury.jdbc.oraclebase.ddcr.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcr.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.s(Unknown Source)
	at com.mercury.jdbc.oraclebase.dddz.execute(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddd2.execute(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
	at com.hp.ucmdb.discovery.server.dal.DiscoveryDestIPsDAO.deleteRecordFromTable(DiscoveryDestIPsDAO.java:66)
	at com.hp.ucmdb.discovery.server.dal.DiscoveryDestDAO.deleteNotActiveDestinations(DiscoveryDestDAO.java:987)
	at com.hp.ucmdb.discovery.server.utils.disptach.actions.AbstractUndispatchTriggersActionFlow.undispatchObjects(AbstractUndispatchTriggersActionFlow.java:76)
	at com.hp.ucmdb.discovery.server.utils.disptach.actions.AbstractUndispatchTriggersActionFlow.handle(AbstractUndispatchTriggersActionFlow.java:28)
	at com.hp.ucmdb.discovery.server.utils.disptach.DispatchManager$DispatchingThread.authorizedRun(DispatchManager.java:827)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread$1.executeInContext(AbstractAuthorizedThread.java:26)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread$1.executeInContext(AbstractAuthorizedThread.java:23)
	at com.mercury.topaz.cmdb.shared.manage.AuthorizationContextUtils.executeInSystemAuthorizationContext(AuthorizationContextUtils.java:24)
	at com.hp.ucmdb.discovery.server.utils.AbstractAuthorizedThread.run(AbstractAuthorizedThread.java:23)
2014-05-19 09:01:16,379 [Request processor timer] (RequestProcessor.java:885) ERROR - Interrupting thread UCMDB - scheduler for customer 1, id name: Default Client due to timeout of 3600000 msec for root operation: com.hp.ucmdb.discovery.framework.user.operations.AutoDiscoveryOperationActivateLiveDiscovery@1270e033
2014-05-19 09:06:10,765 [TasksDispatchingThread] (DiscoveryDestIPsDAO.java:68) ERROR - Failed to execute query:delete from CCM_DISCOVERY_DEST_IPS where DISCOVERY_DESTS_ID IN (SELECT ID FROM CCM_DISCOVERY_DESTS WHERE CUSTOMER_ID=? AND (STATUS=? OR STATUS=? OR STATUS=?)  AND TRIGGER_CI_ID IN ('59711cf8e36010b00a1dc1aff77ee08d','ef4c1dab6c958f773517cd074030cd7d'))
java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.

 

Also I have some errors in IntegrationService probe-error.log:

 

<2014-05-18 00:43:36,056> [ERROR] [ProbeGW: DB Tasks Distributor] (DBLog.java:50) - Failed com.hp.ucmdb.discovery.probe.agents.probegw.taskdistributor.threads.DBTaskDistributor:distributeTasks select 1 from dual
java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
	at com.mercury.jdbc.oraclebase.ddcr.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcr.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.v(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.executeQuery(Unknown Source)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at com.hp.ucmdb.discovery.library.dblayer.DBStatement.executeQuery(DBStatement.java:80)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
	at org.apache.commons.dbcp.PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:635)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:991)
	at com.mercury.topaz.cmdb.server.manage.dal.ConnectionPoolManager$ConnectionPoolDecorator.borrowObject(ConnectionPoolManager.java:769)
	at com.mercury.topaz.cmdb.server.manage.dal.ConnectionPoolManager.getNativeConnection(ConnectionPoolManager.java:512)
	at com.hp.ucmdb.discovery.library.dblayer.DBServicesImpl.getConnection(DBServicesImpl.java:213)
	at com.hp.ucmdb.discovery.library.dblayer.DBServicesImpl.getConnection(DBServicesImpl.java:197)
	at com.hp.ucmdb.discovery.probe.agents.common.ProbeDBServices.getConnection(ProbeDBServices.java:22)
	at com.hp.ucmdb.discovery.library.dblayer.AbstractDataAccessObject.getConnection(AbstractDataAccessObject.java:59)
	at com.hp.ucmdb.discovery.probe.agents.probegw.dbservices.ProbeGwDAO.getConnection(ProbeGwDAO.java:873)
	at com.hp.ucmdb.discovery.probe.agents.probegw.dbservices.ProbeGwDAO.getTasks(ProbeGwDAO.java:256)
	at com.hp.ucmdb.discovery.probe.agents.probegw.taskdistributor.threads.DBTaskDistributor.getPendingTasks(DBTaskDistributor.java:74)
	at com.hp.ucmdb.discovery.probe.agents.probegw.taskdistributor.threads.TaskDistributor.distributeTasks(TaskDistributor.java:80)
	at com.hp.ucmdb.discovery.probe.agents.probegw.taskdistributor.threads.TaskDistributor.run(TaskDistributor.java:54)

 

<2014-05-18 00:43:49,961> [ERROR] [JobRunnerThread-DS_AM_PROD_POPULATION_POPPRODAM] - Failed com.hp.ucmdb.discovery.probe.agents.probemgr.dbservices.JobExecutionDAO:getActiveDestinationsRuntimeInfo select 1 from dual
java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.
	at com.mercury.jdbc.oraclebase.ddcr.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcr.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.b(Unknown Source)
	at com.mercury.jdbc.oraclebase.ddcq.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.a(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.v(Unknown Source)
	at com.mercury.jdbc.oraclebase.dde3.executeQuery(Unknown Source)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at com.hp.ucmdb.discovery.library.dblayer.DBStatement.executeQuery(DBStatement.java:80)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
	at org.apache.commons.dbcp.PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:635)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:991)
	at com.mercury.topaz.cmdb.server.manage.dal.ConnectionPoolManager$ConnectionPoolDecorator.borrowObject(ConnectionPoolManager.java:769)
	at com.mercury.topaz.cmdb.server.manage.dal.ConnectionPoolManager.getNativeConnection(ConnectionPoolManager.java:512)
	at com.hp.ucmdb.discovery.library.dblayer.DBServicesImpl.getConnection(DBServicesImpl.java:213)
	at com.hp.ucmdb.discovery.library.dblayer.DBServicesImpl.getConnection(DBServicesImpl.java:197)
	at com.hp.ucmdb.discovery.probe.agents.common.ProbeDBServices.getConnection(ProbeDBServices.java:22)
	at com.hp.ucmdb.discovery.library.dblayer.AbstractDataAccessObject.getConnection(AbstractDataAccessObject.java:59)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.dbservices.WorkflowServiceDAOImpl.getParkingDestinationsRuntimeInfo(WorkflowServiceDAOImpl.java:715)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.dbservices.WorkflowServiceDAOImpl.getActiveDestinationsRuntimeInfo(WorkflowServiceDAOImpl.java:776)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.jobexecuter.WorkflowJobsProvider.getActiveDestJobsToRun(WorkflowJobsProvider.java:36)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobRunnerThread.run(JobExecuter.java:1597)

 

Best Regards, Sergy.
0 Likes
Highlighted
Established Member..
Established Member..

Re: Oracle JDBC Driver Execution timeout expired

Sergy,

 

I will need more information:

 

1. Your topology (how the systems are setup) and versions of systems and databases

2. The number of CI's in your AM Prod Population result size

3. The number of CI's in your UCMDB

4. The number of objects in AM Natures

 

What I'm seeing there is:

1. When you start your full sync, if the data already exists from a previous run on the probe, the longest running part of initial populations is the selecting from and the deleting of the results in the probe. After our tuning of the 10.01 probes, the delete statement was still several minutes in duration. It's a weak and antiquated approach that most developers would never use in a modern design (alter, drop, etc).

2. That very long operation in an untuned and large scale environment can take 40-45 minutest to execute, which can cause downstream operations like connections to the database to fill and fail. Before the probe tuning, our largest jobs would sometimes fail after 60 minutes. If there was no other load on the Probe it would sometimes partially run and then fail most of the time after some number of hours. Infrequently they would succeed 25-30 hours later. This is why we went after the Probe tuning so aggressively.

3. I doubt the Oracle gather error is anything but a symptom. The Probe  PostgreSQL error indicates a Probe GW/Manager downstream impact and is likely the source of the bottleneck. Can you please describe the environment and history of the AM population? We do a lot of work with this AM generic database adapter for version 9.4.

We aren't on 10.10 yet, the failure to get dual is a sure sign that the version 10.10 probes are murdering themselves a lot like the MySQL probes were. Based on that, I would think that allowing your probe dispatched jobs more time to fail with lead to a MUCH longer wait before the error you're describing.

You may want to shut down other workload going to that probe, restart it and see if the population can even kick off. I suspect you're running into the same type of problem that we experience with 10.01.

 

Erik

effectualsystems.com
Highlighted
Super Contributor.
Super Contributor.

Re: Oracle JDBC Driver Execution timeout expired

Thank for reply.  Also I read your article about optimizing DFP.

 

I have UCMDB 10.10 with 3 DFP logical cluster (2 DFP in each cluster) and standalone oracle server.

In my case the problem was on the server side oracle database. I moved the UCMDB database to a new server with oracle instance.

After that all my problems (with UCMDB and DFP) disappeared.

 


PS: for DFP with PostgreSQL I scheduled  vacuum full job every night:

 

c:\hp\UCMDB\DataFlowProbe\pgsql\bin\vacuumdb.exe -U postgres -d dataflowprobe --analyze --full

 

Best Regards, Sergy.
0 Likes
Highlighted
Established Member..
Established Member..

Re: Oracle JDBC Driver Execution timeout expired

Glad you worked it out. The select from dual was a good indicator. I don't understand though how you setup the system to encounter that problem. Can you please describe the topology or share a sanitized image for future people to avoid?

Thanks,

Erik
effectualsystems.com
0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: Oracle JDBC Driver Execution timeout expired

This error (JDBC Driver Execution timeout expired) has been linked to the database server. The oracle instance has a lot of specific options. Our DBA team is investigating what of these instance options have affected to UCMDB. Other applications what use this oracle instace work well. Now UCMDB is working with DB on another oracle instance.

Best Regards, Sergy.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.