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

Error while creating allocations

Highlighted
shaheer sulaima
Occasional Advisor

Error while creating allocations

Hi,

I am currently in the process of upgrading Mercury ITG 6.0 from oracle 9i to 10g.After migration to 10g,if is noticed that the following error is thrown while creating work allocations.

This page had the following error:
A Mercury internal error has occurred. Please contact Mercury IT Governance support if the problem persists. (KNTA-10023)
A Mercury internal error has occurred. Please contact Mercury IT Governance support if the problem persists. (KNTA-10023)
nested detail:DB Package error:

User-Defined Exception {KTMG_WORK_ALLOCATIONS_TH-300} (KNTA-10498)



A Mercury internal error has occurred. Please contact Mercury IT Governance support if the problem persists. (KNTA-10023)
at com.kintana.tmg.server.AllocationAgent.processAllocationRow(AllocationAgent.java:256)
at com.kintana.tmg.server.AllocationAgent.saveSingleWorkAllocation(AllocationAgent.java:212)
at com.kintana.tmg.server.AllocationAgent.saveWorkAllocations(AllocationAgent.java:90)
at com.kintana.tmg.web.ctrl.AllocationsSaveController.saveAllocations(AllocationsSaveController.java:54)
at org.apache.jsp.WorkAllocationsSave_jsp._jspService(WorkAllocationsSave_jsp.java:94)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.ResponseCompressionFilter.applyFilter(ResponseCompressionFilter.java:68)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:52)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:673)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:52)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:1


Any clues on how to resolve this?
1 REPLY
Celil
Esteemed Contributor

Re: Error while creating allocations

Hi Shaheer,

First of all you opened two same case, please close other case.

Do you compile all db objects in spite of invalid objects ?
You can list invalid objects with this query:

SELECT OBJECT_NAME, OBJECT_TYPE, owner
FROM all_objects
WHERE 1=1
AND owner='PPM Scheme User Here'
AND status='INVALID'
order by owner

Celil
Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event