Error while request creation

Hey all,

 

We get the below error when a request is created. DO you have any idea?

 

ERROR JSESSIONID=86499D20B690F15BD7FB2ED259121725.HP_PPM,USERNAME=vb52389 server:http-0.0.0.0-80-Processor17:com.kintana.web:2012/11/20-09:33:12.667 EET: An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0ED85C5F-00D6-D076-93B9-29CEF06739BD
nested detail:DB Package error:

ORA-00001: unique constraint (PPM.KWFL_STEP_TRANSACTION_HISTO_U1) violated {KWFL_EXECUTION-} (KNTA-10498)



An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0ED85C5F-00D6-D076-93B9-29CEF06739BD
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1625)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1472)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1440)
    at com.kintana.wf.server.WorkflowEngineAgent.handleWorkflowEngineEvent(WorkflowEngineAgent.java:173)
    at com.kintana.crt.web.ctrl.RequestCreateConfirmController.create(RequestCreateConfirmController.java:1434)
    at com.kintana.crt.web.ctrl.RequestCreateConfirmController.create(RequestCreateConfirmController.java:142)
    at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:87)
    at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:97)
    at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115)
    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
    at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:178)
    at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:104)
    at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:94)
    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
    at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:904)
    at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1462)
    at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:46)
    at com.kintana.core.web.filter.SchemeBasedRedirectFilter.doFilter(SchemeBasedRedirectFilter.java:64)
    at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:56)
    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
    at com.kintana.core.web.filter.PerformanceFilter.applyFilter(PerformanceFilter.java:60)
    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)

    Filtered Out 51 Stack Trace Lines.

  • Verified Answer

    Hi,

     

    Make sure the sequence kwfl_step_txn_history_s value is greater than the column value step_transaction_history_id for table  kwfl_step_transaction_history.

     

     

     

     

  • Hello

     

    We had something like this error when uncheck edit security options to request type and|or workflow name request data fields for all users

     

    BR, Alexander

  • Hey again,

    This was solved the issue.But now, I am having something else. THere is an execiton in the first step of the request. Now, the execition stay In progress and log smt like below.


    ERROR server:com.kintana.crt.server.CRTExecutionManager Batch ID: 209071:com.kintana.wf:2012/11/20-17:35:10.943 EET:
    Filtered Out 1 Stack Trace Lines.
    ERROR server:com.kintana.crt.server.CRTExecutionManager Batch ID: 209071:com.kintana.wf:2012/11/20-17:35:10.943 EET: Exception while running execution callback event:
    An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
    GUID=CFA7038E-2662-6AA0-CCA7-617DF7137D8C
    nested detail:DB Package error:

    ORA-00001: unique constraint (PPM.KWFL_STEP_TRANSACTIONS_U1) violated {KWFL_WORKFLOW_INSTANCE_STEP-4020} (KNTA-10498)



    An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
    GUID=CFA7038E-2662-6AA0-CCA7-617DF7137D8C
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1625)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1514)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1492)
    at com.kintana.wf.server.WorkflowEngineAgent.handleWorkflowEngineEvent(WorkflowEngineAgent.java:343)
    at com.kintana.wf.server.WFExecutionListener.handleExecutionResults(WFExecutionListener.java:132)
    at com.kintana.wf.server.WFExecutionListener.handleExecutionResults(WFExecutionListener.java:118)
    at com.kintana.core.server.execution.BaseExecutionManager.notifyExecutionListeners(BaseExecutionManager.java:725)
    at com.kintana.core.server.execution.CommandExecutionAgent.doExecuteCommands(CommandExecutionAgent.java:915)
    at com.kintana.core.server.execution.CommandExecutionAgent.executeCommands(CommandExecutionAgent.java:723)
    at com.kintana.core.server.execution.BaseExecutionManager.executeBatchForRegularExecution(BaseExecutionManager.java:1161)
    at com.kintana.core.server.execution.BaseExecutionManager.executeBatch(BaseExecutionManager.java:1095)
    at com.kintana.core.server.execution.BaseExecutionManager.run(BaseExecutionManager.java:840)
    ERROR server:com.kintana.crt.server.CRTExecutionManager Batch ID: 209071:com.kintana.wf:2012/11/20-17:35:10.959 EET: Execution callback event details:
    ERROR server:com.kintana.crt.server.CRTExecutionManager Batch ID: 209071:com.kintana.wf:2012/11/20-17:35:10.959 EET: com.kintana.wf.capsule.EngineEventPseudoCapsule
    update = false
    dirty = false
    deleted = false
    EVENT = EXECUTION_CALLBACK
    LAST_UPDATED_BY = 1
    USR_DBG = 10
    INSTANCE_SOURCE_TYPE_CODE = IR
    INSTANCE_SOURCE_SET_ID = 110763
    ENTITY_LAST_UPDATED_DATE = null
    INSTANCE_SOURCE_ID = null
    STEP_TXN_GROUP_IN_LIST = 809341
    WORKFLOW_STEP_ID = 38406
    RESULT_VALUE = SUCCESS
    VISIBLE_RESULT_VALUE = Succeeded
    ERROR_VALUE = null
    VISIBLE_ERROR_VALUE = null
    ERROR_MESSAGE = null
    VISIBLE_USER_STATUS_VALUE = Succeeded
    USER_COMMENT = null
    APPROVALS_REQUIRED_CODE = null
    DELEGATED_TO_USER_ID = null
    SCHEDULED_DATE = null
    SCHEDULE_PRIORITY_SEQUENCE = null
    EXECUTION_BATCH_ID = 209071
    CONCURRENT_REQUEST_ID = null
    TO_WORKFLOW_STEP_ID = null
    CHILD_PACKAGE_ID = null
    FIRST_WORKFLOW_STEP_ID = null
    SOURCE_ENVIRONMENT_ID = null
    DEST_ENVIRONMENT_ID = null
    SERVER_NAME = null
    PARAMETERS_EXIST_FLAG = N
    PARAMETER_SET_CONTEXT_ID = null
    PARAMETER1 = null
    VISIBLE_PARAMETER1 = null
    PARAMETER2 = null
    VISIBLE_PARAMETER2 = null
    PARAMETER3 = null
    VISIBLE_PARAMETER3 = null
    PARAMETER4 = null
    VISIBLE_PARAMETER4 = null
    PARAMETER5 = null
    VISIBLE_PARAMETER5 = null
    PARAMETER6 = null
    VISIBLE_PARAMETER6 = null
    PARAMETER7 = null
    VISIBLE_PARAMETER7 = null
    PARAMETER8 = null
    VISIBLE_PARAMETER8 = null
    PARAMETER9 = null
    VISIBLE_PARAMETER9 = null
    PARAMETER10 = null
    VISIBLE_PARAMETER10 = null
    PARAMETER11 = null
    VISIBLE_PARAMETER11 = null
    PARAMETER12 = null
    VISIBLE_PARAMETER12 = null
    PARAMETER13 = null
    VISIBLE_PARAMETER13 = null
    PARAMETER14 = null
    VISIBLE_PARAMETER14 = null
    PARAMETER15 = null
    VISIBLE_PARAMETER15 = null
    PARAMETER16 = null
    VISIBLE_PARAMETER16 = null
    PARAMETER17 = null
    VISIBLE_PARAMETER17 = null
    PARAMETER18 = null
    VISIBLE_PARAMETER18 = null
    PARAMETER19 = null
    VISIBLE_PARAMETER19 = null
    PARAMETER20 = null
    VISIBLE_PARAMETER20 = null
    PARAMETER21 = null
    VISIBLE_PARAMETER21 = null
    PARAMETER22 = null
    VISIBLE_PARAMETER22 = null
    PARAMETER23 = null
    VISIBLE_PARAMETER23 = null
    PARAMETER24 = null
    VISIBLE_PARAMETER24 = null
    PARAMETER25 = null
    VISIBLE_PARAMETER25 = null


  • Hi Sevcan,

     

    Same thing happened for KWFL_STEP_TRANSACTIONS table.

    Do the same thing for kwfl_step_transitions_s SEQUENCE.

    Make sure it is greater than select max(step_transaction_id) from KWFL_STEP_TRANSACTIONS.

     

    I am guessing you imported DB from other system.

    If so, something went wrong, you might check if there are invalid objects.

    You can check with the following SQL statement.

    SELECT * FROM user_objects
    WHERE status <> 'VALID'

     

    Hope it helps.

     

    T.M.

     

  • I have got the same problem. I already followed the previous steps, but still getting an error.

    Besides the error "ORA-00001: restrição exclusiva (PPM.KWFL_STEP_TRANSACTIONS_U1) violada {KWFL_WORKFLOW_INSTANCE_STEP-4020} (KNTA-10498)", I can not attach a file in any request or project. When i try to do that, I got the error "nested detail:Error while inserting data into DB".

    I appreciate if someone help me.

    Thank you.