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

Saved Search showing error

Highlighted
Bharath_Kumar
Super Collector

Saved Search showing error

Hi Team,

 

We are currently using HP PPM 7.5 SP6, and recently we had a data refresh from production instance.

 

Data refresh was complete and we were able to perform most of all of the operations except saving the Search results. The search works fine howeve when trying to save, we get an error message stating 

 

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023) .

 

The saved search entry appears under the Saved Search option in Navigation bar, however when clicked there are no field values used for search. if anybody have encountered this error and fixed it already please share the same to get rid of this.

 

the detailed error log is enclosed below for reference:

  
 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:DB Package error:

ORA-00001: unique constraint (ITG.KNTA_SAVED_SEARCH_FILTERS_U1) violated {KNTA_SAVED_SEARCH_FILTERS_TH-300} (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.server.SavedSearchesAgent.processSearchFilterRow(SavedSearchesAgent.java:456)
at com.kintana.core.server.SavedSearchesAgent.saveSearchFilterCapsules(SavedSearchesAgent.java:413)
at com.kintana.core.server.BasePluginImpl.saveSearchFilterCapsules(BasePluginImpl.java:3498)
at com.kintana.core.web.ctrl.SavedSearchesController.saveSearch(SavedSearchesController.java:213)
at org.apache.jsp.web.knta.global.SaveSearch_jsp._jspService(SaveSearch_jsp.java:76)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.cor 

2 REPLIES
Mohit_Agrawal
Frequent Visitor

Re: Saved Search showing error

Hi Bharath,

 

Please check once the sequence KNTA_SAVED_SEARCH_FILTERS_S in both instances. Whether it stores the same value or not. In case it does not, then run KNTA_SAVED_SEARCH_FILTERS_S.NEXTVAL on the instance having lower value and make it same in both instances.

 

 

Thanks!!

Mohit Agrawal

 

cotocald
Regular Collector

Re: Saved Search showing error

I agreed with Mohit.

Also, there could be a repeated id where it shouldn't, so check the KNTA_SAVED_SEARCH_FILTERS table in bothe instances.

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event