Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while request creation

SOLVED
Go to solution
Highlighted
sevcan
Collector

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.

6 REPLIES
TurboMan
Member
Solution

Re: Error while request creation

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.

 

 

 

 

Alexander (Sua)
Regular Collector

Re: Error while request creation

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

sevcan
Collector

Re: Error while request creation

Thanks TurboMan, it was the case.

sevcan
Collector

Re: Error while request creation

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


TurboMan
Member

Re: Error while request creation

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.

 

imeireles
Acclaimed Contributor

Re: Error while request creation

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.

 

 

//Add this to "OnDomLoad" event