The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to create Enhancement Request in PPM

SOLVED
Go to solution
Highlighted
Pachi
Collector

Unable to create Enhancement Request in PPM

Hi team,

 

I get the below error, when we try to create an enhancement request, which we were able to create earlier, could you please advice.

 

Thanks,

Pachi

 

    <script type="text/javascript" language="JavaScript" src="/itg/js/common/ComLib.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/ComLibIframe.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/ComLibXmlHttp.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/CommonUtil.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/HiddenConsole.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/Dialog.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/DialogUtil.js"></script>
<script type="text/javascript" language="JavaScript" src="/itg/js/common/DialogSet.js"></script> <script type="text/javascript" language="javascript">// // This helps us avoid hard-coding the context path in image URL's embedded in JavaScript code. window.contextPath = "/itg"; // </script>
<script type="text/javascript" language="javascript">// // portlet-safe URLs to resources referenced from common JS code var mercuryItg70CloseDialogImgUrl = '/itg/images/pm/close_dialog.gif'; var mercuryItg70CloseDialogHoverImgUrl = '/itg/images/pm/close_dialog_hover.gif'; var mercuryItg70CloseDialogPressImgUrl = '/itg/images/pm/close_dialog_press.gif'; var mercuryItg70ConfirmationDialogUrl = '/itg/core/ConfirmationDialog.do?&LOAD_PAGE_URL=%2Fitg%2Fweb%2Fknta%2Fcrt%2FRequestCreate.jsp%3FNAV_PATH_LINK%3DY%26REQUEST_TYPE_CREATE%3D5.11.31284.Enhancement%26title%3DCreate%2BNew%2BEnhancement%26NEED_FOCUS%3Dtrue%26DISPLAY_MENU_FLAG%3DY%26IS_WINDOID%3DN%26NAV_SEQ%3D2'; var mercuryItg70HandleErrorUrl = '/itg/core/HandleError.do?&LOAD_PAGE_URL=%2Fitg%2Fweb%2Fknta%2Fcrt%2FRequestCreate.jsp%3FNAV_PATH_LINK%3DY%26REQUEST_TYPE_CREATE%3D5.11.31284.Enhancement%26title%3DCreate%2BNew%2BEnhancement%26NEED_FOCUS%3Dtrue%26DISPLAY_MENU_FLAG%3DY%26IS_WINDOID%3DN%26NAV_SEQ%3D2'; // </script> This page had the following error:

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
 
An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023) nested detail:An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023) An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023) nested detail:DB Package error:
ORA-01400: cannot insert NULL into ("PMS"."KWFL_WORKFLOW_INSTANCES"."WORKFLOW_ID") {KWFL_REQUEST_HOOKS-1010} (KNTA-10498)

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023) at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1740) at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1563) at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1528) at com.kintana.wf.server.WorkflowEngineAgent.handleWorkflowEngineEvent(WorkflowEngineAgent.java:180) at com.kintana.crt.web.ctrl.RequestCreateConfirmController.create(RequestCreateConfirmController.java:754) at com.kintana.crt.web.ctrl.RequestCreateConfirmController.create(RequestCreateConfirmController.java:106) at org.apache.jsp.web.knta.crt.RequestCreateAction_jsp._jspService(RequestCreateAction_jsp.java:82) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.ajaxa
Regards,
Pachi
8 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Unable to create Enhancement Request in PPM

Hi Pachi,

 

Replicate the issue, ans then share the server logs.

 

From the above post what I can get is workflow_id ("PMS"."KWFL_WORKFLOW_INSTANCES"."WORKFLOW_ID) is not getting generated/inserted properly.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Pachi
Collector

Re: Unable to create Enhancement Request in PPM

Can you please guide me, how to get the server log

Regards,
Pachi
Pachi
Collector

Re: Unable to create Enhancement Request in PPM

Hi,

 

Only One PPM ID is having the problem, have cross check with other ID's and we are able create the request.

Have checked the permission and granted alll the permission as per the ID, who is able to create the request.

I am still getting the error only for one ID.Please advice.

Regards,
Pachi
Utkarsh_Mishra
Honored Contributor

Re: Unable to create Enhancement Request in PPM

server logs can be found at

 

<ppm installation>/server/<server_name>/logs/server.log

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Utkarsh_Mishra
Honored Contributor
Solution

Re: Unable to create Enhancement Request in PPM

Hi Pachi,

 

Tyr to manually add this particular user id in "Enhancement Request" request type -- then  "User access" and add create+delete/edit grants.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Pachi
Collector

Re: Unable to create Enhancement Request in PPM

Thank for your help,

We usually create enhancement request by,

Create a new request-->thn select the enhancement request from drop down and create it.

Is there any other way of creating the same?

Regards,
Pachi
dirkf
Honored Contributor

Re: Unable to create Enhancement Request in PPM

Hi Pachi,

 

on the fly I found the following, reportedas follows:

 

SYMPTOM DESCRIPTION in customer terms:

We are receiving this error when submitting one of our requests.

An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=1B26B6EA-CB84-4E13-6003-D5D92529CA56

I am uploading the kSupport to this case. Please let us know what to do about this.

ORA-01400: cannot insert NULL into ("KINUSER"."KWFL_WORKFLOW_INSTANCES"."WORKFLOW_ID") {KWFL_REQUEST_HOOKS-1010}

 

 

 

This seems to be a random issue happening, so it might help you.

 

 

[root cause]
the limitation of default value mechanism. it only supports the variables that P=VP, like standard number, flat Text, etc
so, when DIA-Order (example for the workflow, see solution) tries to set a default value for the workflow, it fails.

[solution]
create an advanced rule triggered on creation and with no dependency.
using the SQL:
SELECT WORKFLOW_ID, WORKFLOW_NAME FROM KWFL_WORKFLOWS WF WHERE WF.WORKFLOW_NAME='DIA - Order' --please double check the name

[conclusion]
so, I don't think this is a code defect, maybe it can be an enhancement in PPM future release, so that all variable can set default value.

 

Best regards,

Dirk

 

- Kudos always welcome -

Pachi
Collector

Re: Unable to create Enhancement Request in PPM

Thanks Drik:)
Regards,
Pachi
//Add this to "OnDomLoad" event