When we added values to lookup by XOG it is breaking the lookup

book

Article ID: 213482

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

lookup type - static

it already had 314 values, added 30 more, now there are two issues

1. when user make selection out of 30 new values, value is not getting saved at the screen, old values are still being saved

2. from the admin side, if try to make changes to any of the old values it is OK, changes at any of the new value is throwing contact system admin error, here are the logs

SQL error code: 1403
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "NIKU.NMC_CMN_LOOKUPS_UPD_SP", line 37
ORA-06512: at line 1

Executed:
 {call NMC_CMN_LOOKUPS_UPD_SP (?,?,?,?,?,?,?,?,?,?)} 
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="lookupPMD.xml" id="nmc.updateLUV" batchable="true" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="all">
    <text>{call NMC_CMN_LOOKUPS_UPD_SP (?,?,?,?,?,?,?,?,?,?)}</text>
    <param path="@lookup_type" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@lookup_code" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@name" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@description" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@sort_order" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/>
    <param path="@is_active" type="long" direction="IN" defaultValue="0" expressionListDelimiter=","/>
    <param replace="userId" direction="IN" expressionListDelimiter=","/>
    <param replace="language" direction="IN" expressionListDelimiter=","/>
    <param name="partition_code" path="@partition_code" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/>
    <param name="partition_mode" path="@partition_mode" type="string" direction="IN" defaultValue="PARTITION_AND_ANSTRS_DESDNTS" expressionListDelimiter=","/>
  </sql>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="nmc.updateLUV" inputSource="xml" inputLocation="/data/luv" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>

Using input: 
<?xml version="1.0" encoding="UTF-8"?>
<luv description="test" id="5007978" is_active="1" lookup_code="wf_sub_initi_326"
     lookup_enum="0"
     lookup_type="WF_SUB_INITIATIVE"
     name="670 - Chapter 4 Narrative"
     partition_code="NIKU.ROOT"
     partition_mode="PARTITION_AND_ANSTRS_DESDNTS"
     sort_order="0"/>

 at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2196)
 at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2376)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3063)
 at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:888)
 at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:786)
 at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:588)
 at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
 at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:214)
 at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java:111)
 at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1421)
 at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
 at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:283)
 at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:390)
 at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:273)
 at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:157)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
 at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
 at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1431)
 at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:235)
 at com.niku.union.web.PortletController.processRequest(PortletController.java:162)
 at com.niku.union.web.WebActionController.processAction(WebActionController.java:1470)
 at com.niku.union.web.WebActionController.processRequest(WebActionController.java:193)
 at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:453)
 at com.ca.clarity.uif.UIServlet.service(UIServlet.java:78)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseHeaders.doFilter(ResponseHeaders.java:73)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseSecurityHeaders.doFilter(ResponseSecurityHeaders.java:158)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:153)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.SAMLFilter.doFilter(SAMLFilter.java:81)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:138)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:55)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:89)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:63)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
 at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1620)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1082)
 at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:565)
 at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:543)
 at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:969)
 at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:898)
 at java.base/sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:127)
 at java.base/sun.nio.ch.Invoker$2.run(Invoker.java:219)
 at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "NIKU.NMC_CMN_LOOKUPS_UPD_SP", line 37
ORA-06512: at line 1

 at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dde3.y(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dde3._(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dddz.executeUpdate(Unknown Source)
 at jdk.internal.reflect.GeneratedMethodAccessor420.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
 at com.sun.proxy.$Proxy49.executeUpdate(Unknown Source)
 at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.executeUpdate(SQLTracePreparedStatement.java:240)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2956)
 ... 88 more
ERROR 2021-04-22 11:49:08,319 [https-jsse-nio2-10443-exec-29] niku.xql2 (clarity:A163444:74778012__C14B0CC4-CE71-43A5-AAF4-47BFD289DD39:nmc.updateLookup) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 1403
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "NIKU.NMC_CMN_LOOKUPS_UPD_SP", line 37
ORA-06512: at line 1

Executed:
 {call NMC_CMN_LOOKUPS_UPD_SP (?,?,?,?,?,?,?,?,?,?)} 
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="lookupPMD.xml" id="nmc.updateLUV" batchable="true" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="all">
    <text>{call NMC_CMN_LOOKUPS_UPD_SP (?,?,?,?,?,?,?,?,?,?)}</text>
    <param path="@lookup_type" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@lookup_code" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@name" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@description" type="string" direction="IN" expressionListDelimiter=","/>
    <param path="@sort_order" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/>
    <param path="@is_active" type="long" direction="IN" defaultValue="0" expressionListDelimiter=","/>
    <param replace="userId" direction="IN" expressionListDelimiter=","/>
    <param replace="language" direction="IN" expressionListDelimiter=","/>
    <param name="partition_code" path="@partition_code" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/>
    <param name="partition_mode" path="@partition_mode" type="string" direction="IN" defaultValue="PARTITION_AND_ANSTRS_DESDNTS" expressionListDelimiter=","/>
  </sql>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="nmc.updateLUV" inputSource="xml" inputLocation="/data/luv" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>

Using input: 
<?xml version="1.0" encoding="UTF-8"?>
<luv description="test" id="5007978" is_active="1" lookup_code="wf_sub_initi_326"
     lookup_enum="0"
     lookup_type="WF_SUB_INITIATIVE"
     name="670 - Chapter 4 Narrative"
     partition_code="NIKU.ROOT"
     partition_mode="PARTITION_AND_ANSTRS_DESDNTS"
     sort_order="0"/>

 at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2196)
 at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2376)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3063)
 at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:888)
 at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:786)
 at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:588)
 at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
 at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:214)
 at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java:111)
 at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1421)
 at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
 at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:283)
 at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:390)
 at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:273)
 at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:157)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
 at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
 at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1431)
 at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:235)
 at com.niku.union.web.PortletController.processRequest(PortletController.java:162)
 at com.niku.union.web.WebActionController.processAction(WebActionController.java:1470)
 at com.niku.union.web.WebActionController.processRequest(WebActionController.java:193)
 at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:453)
 at com.ca.clarity.uif.UIServlet.service(UIServlet.java:78)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseHeaders.doFilter(ResponseHeaders.java:73)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseSecurityHeaders.doFilter(ResponseSecurityHeaders.java:158)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:153)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.SAMLFilter.doFilter(SAMLFilter.java:81)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:138)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:55)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:89)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:63)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
 at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1620)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1082)
 at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:565)
 at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:543)
 at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:969)
 at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:898)
 at java.base/sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:127)
 at java.base/sun.nio.ch.Invoker$2.run(Invoker.java:219)
 at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01403: no data found
ORA-06512: at "NIKU.NMC_CMN_LOOKUPS_UPD_SP", line 37
ORA-06512: at line 1

 at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dde3.y(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dde3._(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dddz.executeUpdate(Unknown Source)
 at jdk.internal.reflect.GeneratedMethodAccessor420.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
 at com.sun.proxy.$Proxy49.executeUpdate(Unknown Source)
 at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.executeUpdate(SQLTracePreparedStatement.java:240)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2956)
 ... 88 more

 

Environment

Release : 15.8

Component : CA PPM STUDIO

Resolution

De-activated the newly added 30 values and recreated manually, it is working now.