Skip to Content
0
Former Member
Dec 10, 2007 at 07:37 AM

ORA-00001 error

159 Views

Hi all,

After we restarted portal,we cannot start jcontrol,and we get a strange ORA-00001 error,when we check the log:

Here is the log defaulttrace:

Date : 12/10/2007

Time : 15:13:26:500

Message : ORA-00001: unique constraint (SAPSR3DB.SYS_C005260) violated

com.sap.caf.eu.gp.base.exception.EngineException: ORA-00001: unique constraint (SAPSR3DB.SYS_C005260) violated

at com.sap.caf.eu.gp.model.pfw.wfc.local.db.impl.AbstractLocalProcessPersistence.createBlockInputLocal(AbstractLocalProcessPersistence.java:904)

at com.sap.caf.eu.gp.model.pfw.wfc.local.db.impl.LocalProcessPersistence.createBlock(LocalProcessPersistence.java:250)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.startBlock(StatusWriter.java:984)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.startActivity(StatusWriter.java:927)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.changeParentBlockStatus(StatusWriter.java:2710)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.changeParentBlockStatus(StatusWriter.java:2728)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.updateProcessStatusUserDecisionBlock(StatusWriter.java:2574)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.updateProcessStatus(StatusWriter.java:2235)

at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.completeAction(StatusWriter.java:223)

at com.sap.caf.eu.gp.model.pfw.wfc.local.impl.LocalWorkflowConnector.completeAction(LocalWorkflowConnector.java:247)

at com.sap.caf.eu.gp.model.pfw.wfc.local.impl.BackGroundActionProcessorHelper.processAction(BackGroundActionProcessorHelper.java:223)

at com.sap.caf.eu.gp.model.pfw.wfc.local.impl.queue.BackgroundCOQueueProcessor.run(BackgroundCOQueueProcessor.java:269)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C005260) violated

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeUpdate(CommonPreparedStatement.java:259)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:240)

at com.sap.caf.eu.gp.model.pfw.wfc.local.db.impl.AbstractLocalProcessPersistence.createBlockInputLocal(AbstractLocalProcessPersistence.java:901)

... 15 more

And i also check the startlog.It seems ok.

Someone knows what's happening and how to solve this?

Best regards

delma