Hi
Good Morning.
We are using snapshot in 2 different Processes.
Each Process is in different Job.
Do we need to use different names for the snapshot in each process,though the source of snapshot is same to avoid below error?
Every time whenever snapshot executes will there be any table creation happening in the background which will create this error?
Please help.
We are getting below error:
*************
Snapshot executing: <snapshotname>
[EDQ-07907] Error while dropping table {0} : A database error has occurred : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. (Code: 200,302)
com.datanomic.director.results.database.exception.sql.ResultsSQLException: A database error has occurred : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. (Code: 200,302)
at com.datanomic.director.results.database.translator.MapErrorCodes.mapException(MapErrorCodes.java:71)
at com.datanomic.director.results.database.AbstractTableDAO.executeTransactionalSQL(AbstractTableDAO.java:113)
at com.datanomic.director.results.database.AbstractTableDAO.executeTransactionalSQL(AbstractTableDAO.java:86)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropTableByName(TableCreateAndDeleteDao.java:533)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropTable(TableCreateAndDeleteDao.java:259)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropAndCreateTable(TableCreateAndDeleteDao.java:558)
at com.datanomic.director.dataupload.DataUploader.initiateUpload(DataUploader.java:100)
at com.datanomic.director.dataupload.UploaderClient.startUpload(UploaderClient.java:49)
at com.datanomic.director.snapshot.SnapshotExecutor.uploadData(SnapshotExecutor.java:567)
at com.datanomic.director.snapshot.SnapshotExecutor.executeSnapshot(SnapshotExecutor.java:200)
at com.datanomic.director.snapshot.SnapshotExecutor.runTask(SnapshotExecutor.java:802)
at com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:425)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
at com.datanomic.director.results.database.AbstractTableDAO.executeTransactionalSQL(AbstractTableDAO.java:108)
... 11 more
SEVERE: 27-Feb-2018 15:33:24: [EDQ-09017] Error uploading snapshot data
com.datanomic.director.dataupload.DataLoadException: A database error has occurred : ORA-00955: name is already used by an existing object. (Code: 200,302)
at com.datanomic.director.dataupload.DataUploader.initiateUpload(DataUploader.java:102)
at com.datanomic.director.dataupload.UploaderClient.startUpload(UploaderClient.java:49)
at com.datanomic.director.snapshot.SnapshotExecutor.uploadData(SnapshotExecutor.java:567)
at com.datanomic.director.snapshot.SnapshotExecutor.executeSnapshot(SnapshotExecutor.java:200)
at com.datanomic.director.snapshot.SnapshotExecutor.runTask(SnapshotExecutor.java:802)
at com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:425)
at java.lang.Thread.run(Thread.java:745)
SEVERE: 27-Feb-2018 15:33:24: [EDQ-09019] Error during snapshot execution: A database error has occurred : ORA-00955: name is already used by an existing object. (Code: 203,006)
INFO: 27-Feb-2018 15:33:24: [EDQ-09020] Snapshot <snapshot> finished execution in 0.48s
SEVERE: 27-Feb-2018 15:33:24: [EDQ-05727] EDQ-05727
com.datanomic.director.missionmanager.exceptions.MissionExecutionException: An error has occurred with one of the tasks. Please check the logs for more details. (Code: 207,117)
at com.datanomic.director.missionlieutenant.plan.MissionExecutionPlan.cleanup(MissionExecutionPlan.java:1338)
at com.datanomic.director.missionlieutenant.plan.MissionExecutionPlan.execute(MissionExecutionPlan.java:1297)
at com.datanomic.director.missionlieutenant.executor.MissionExecutor.runMissionNow(MissionExecutor.java:448)
at com.datanomic.director.missionlieutenant.executor.MissionExecutor.access$900(MissionExecutor.java:97)
at com.datanomic.director.missionlieutenant.executor.MissionExecutor$RunnerInvoker$1.run(MissionExecutor.java:1296)
at java.lang.Thread.run(Thread.java:745)