BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

Filenet current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active error

  • 1.  Filenet current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active error

    Posted Tue June 02, 2020 03:57 AM
    I was trying to remove a old solution from icmadmin and from Dev-environment , which i have done many times, but sadly icmadmin got bit frozen and i got a timeout error , now when i am trying to remove it again it says The document is already checked out.

    System error log

    [XX/XX/XX XX:XX:XX:343 GMT+05:30] 00000162 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XA_RBROLLBACK (100). Exception is: [jcc][t4][10401][12066][4.19.49] XA exception: XA_RBROLLBACK ERRORCODE=-4228, SQLSTATE=null [XX/XX/XX XX:XX:XX:347 GMT+05:30] 00000162 api W com.ibm.casemgmt.intgimpl.messages.CaseMgmtLogger warn FNRPA0284W A deployment error stopped the deployment. The continuation level was NEXT_ANY_STEP. com.ibm.casemgmt.intgimpl.deploy.handlers.ContinuableStepException: FNRPA0596E The pages could not be deployed because of the following error: A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active

    AND

    000002f9 SystemErr R CIWEB.ICMAdminClientPlugin Error: [XXXXX(unknown) @ 10.XX.XX.XX] [REQUEST 62] com.ibm.ecm.icm.accm.services.DeleteAssetService.execute() ACCM service is throwing exception com.ibm.ecm.icm.accm.util.AccmException: The document is already checked out. at com.ibm.ecm.icm.accm.repository.GetSolutionsOrTemplates.deleteDesignSolution(GetSolutionsOrTemplates.java:784) at com.ibm.ecm.icm.accm.services.DeleteAssetService.doExecute(DeleteAssetService.java:80) at com.ibm.ecm.icm.accm.services.BaseService.execute(BaseService.java:130) at com.ibm.ecm.util.PluginUtil.invokeService(PluginUtil.java:1294)

    ...........................................................
    Caused by: com.filenet.api.exception.EngineRuntimeException: FNRCE0059E: E_RESERVATION_EXISTS: The document is already checked out. failedBatchItem=0 errorStack={ at com.filenet.engine.persist.VersionablePersister.validateCheckout(VersionablePersister.java:573) at com.filenet.engine.persist.VersionablePersister.validateCurPendingAction(VersionablePersister.java:527) at com.filenet.engine.persist.IndependentPersister.executeChange(IndependentPersister.java:325) at com.filenet.engine.persist.SubscribablePersister.executeChange(SubscribablePersister.java:177) at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1487) at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1345) at com.filenet.engine.ejb.EngineCoreBean._executeChanges(EngineCoreBean.java:619) at com.filenet.engine.ejb.EngineCoreBean.executeChanges(EngineCoreBean.java:586) at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeChanges(Unknown Source) at com.filenet.engine.ejb.EngineBean.executeChanges(EngineBean.java:913) at com.filenet.apiimpl.transport.ejbstubs.EJSRemoteStatelessEngine_2e64c374.executeChanges(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)

    system out log

    [X/XX/XX XX:XX:55:364 GMT+05:30] 000002f9 SystemOut O CIWEB.ICMAdminClientPlugin Entry: [XXXXXX(unknown) @ 10.XX.XX.XX] [REQUEST 62] com.ibm.ecm.icm.accm.repository.GetSolutionsOrTemplates.deleteDesignSolution() [X/XX/XX XX:XX:55:373 GMT+05:30] 000002f9 SystemOut O CIWEB.ICMAdminClientPlugin Entry: [XXXXXX(unknown) @ 10.XX.XX.XX] [REQUEST 62] com.ibm.casemgmt.config.ContentEngineHelper.isDevelopmentEnvironment()() [X/XX/XX XX:XX:55:956 GMT+05:30] 000002f9 SystemOut O CIWEB.ICMAdminClientPlugin Exit : [XXXXXX(unknown) @ 10.XX.XX.XX] [REQUEST 62] com.ibm.casemgmt.config.ContentEngineHelper.isDevelopmentEnvironment()() [X/XX/XX XX:XX:56:457 GMT+05:30] 000002f9 SystemOut O CIWEB.ICMAdminClientPlugin Error: [XXXXXX(unknown) @ 10.XX.XX.XX] [REQUEST 62] com.ibm.ecm.icm.accm.repository.GetSolutionsOrTemplates.deleteDesignSolution() com.filenet.api.exception.EngineRuntimeException: FNRCE0059E: E_RESERVATION_EXISTS: The document is already checked out. failedBatchItem=0 errorStack={ at com.filenet.engine.persist.VersionablePersister.validateCheckout(VersionablePersister.java:573) at com.filenet.engine.persist.VersionablePersister.validateCurPendingAction(VersionablePersister.java:527) at com.filenet.engine.persist.IndependentPersister.executeChange(IndependentPersister.java:325) at com.filenet.engine.persist.SubscribablePersister.executeChange(SubscribablePersister.java:177) at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1487) at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestBrokerImpl.java:1345) at com.filenet.engine.ejb.EngineCoreBean._executeChanges(EngineCoreBean.java:619) at com.filenet.engine.ejb.EngineCoreBean.executeChanges(EngineCoreBean.java:586) at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeChanges(Unknown Source) at com.filenet.engine.ejb.EngineBean.executeChanges(EngineBean.java:913) at com.filenet.apiimpl.transport.ejbstubs.EJSRemoteStatelessEngine_2e64c374.executeChanges(Unknown Source)

    If i try to re deploy it I am getting,

    ERROR FNRPA0596E The pages could not be deployed because of the following error: A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active ERROR FNRPA0093E The previous error was caused by: A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active

    The solution deployment log shows,

    X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0123I The Content Engine property definitions are being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0124I The Content Platform Engine property definition for the YYYY_SchemeCode property is being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0124I The Content Platform Engine property definition for the YYYY_DocumentId property is being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0124I The Content Platform Engine property definition for the YYYY_DocumentName property is being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0119I The YYYY_CheckListMaster solution pages are being checked. The case creation page is YYYY_Checklist Master Add Case. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0111I The following document class is being checked: YYYY_DemoSupportDocument (YYYY Support Document). X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0123I The Content Engine property definitions are being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0124I The Content Platform Engine property definition for the YYYY_SupportDocumentType property is being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0115I The latest version of the Process Engine configuration document with a version series ID of {30399364-0000-CABC-YYYY-47C5057DYYYY} is being checked. X/XX/XX XX:XX:56 PM GMT+05:30 FNRPA0207I The Content Platform Engine process services prerequisites to deploy the solution are being validated. X/XX/XX XX:XX:57 PM GMT+05:30 FNRPA0120I The solution YYYY Solution pages are being deployed. X/XX/XX XX:XX:21 PM GMT+05:30 ERROR FNRPA0596E The pages could not be deployed because of the following error: A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active X/XX/XX XX:XX:21 PM GMT+05:30 ERROR FNRPA0093E The previous error was caused by: A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active

    I have try,

    1. Reset Test environment - same error when deploy
    2. Importing backup

    but non-succeeded

    in target object store , solution's all

    1. PE Configuration

    2. Workflow Definitions

    3. Solution Definition

    4. Solution Workflow Collection

    files of Lates major version have "version status" to "Released" and "object's version" and "Is Current Version" ticked in one line and "isReserved" Not clicked. like ,

    enter image description here

    in TOS's connection definition is checked out , and i am getting error "A transaction failure has occurred due to an invalid state or timeout. The current transaction state is STATUS_MARKED_ROLLBACK and it was expected to be active" if i try to cancel it

    enter image description here

    .How can i fix this issue? If i can just get this solution deployed for now it will be ok.

    My CaseManager Version is 5.2.1

    My stack



    ------------------------------
    Arch A
    ------------------------------