AnsweredAssumed Answered

Idea XOG is failing after creating and removing a custom attribute in idea object.

Question asked by Ravinder_B on Sep 16, 2014
Latest reply on Sep 18, 2014 by Ravinder_B

we have created a custom attribute for Idea object , later we have removed this ( OPT_OM_WORK) .

now the Idea XOG is failing .

some of the background procdures/queries were refering this removed column in odf_ca_idea table.

 

This is failing so many custom processes we have developed , as these processes were using idea XOG . None of these custom processes were using the removed field/column.

 

why should clarity refering the removed fields which were removed from application . This is not expected behaviour right ?  do we have a case for it  or else i can raise one.

 

1 , error i got from nsa ..

 

WARN  2014-09-12 07:01:18,120 [http-bio-8080-exec-430] com.niku (clarity:admin:5887397__87643DEA-C130-4BAA-BFBC-655B86445B41:XOG::idea::write) Statement Id: omp.dynamic.select-object.map::idea:NIKU.ALL:0:opt_targetstart, opt_erc_lead, opt_feas_decision, opt_capcontrol, opt_bo_decision, opt_execsum, opt_biz_own, opt_desiredel, opt_govreg, opt_cyfcap, opt_busreadydate, opt_busprjmgr, opt_commwork, opt_customer, opt_restr_desc, status, opt_fundsubpool, opt_ext_cust, opt_prg_dir, opt_workexcust, opt_first_use, opt_ocio_decision, opt_portfolio_lead, opt_restr_res_type, opt_it_portfolio_mgr, opt_atrp, opt_cyacap, opt_ucmgid, opt_cc_decision, opt_otherbillapp, opt_it_owner, opt_analydoll, opt_prgm_mgr, opt_addroutelevel, opt_rsa, opt_om_work, opt_fasttrack

WARN  2014-09-12 07:01:18,120 [http-bio-8080-exec-430] com.niku (clarity:admin:5887397__87643DEA-C130-4BAA-BFBC-655B86445B41:XOG::idea::write) SQL statement: SELECT  s0.id odf_pk, u0.opt_targetstart opt_targetstart, u0.opt_erc_lead opt_erc_lead, a0.opt_feas_decision AS opt_feas_decision, u0.opt_capcontrol opt_capcontrol, a0.opt_bo_decision AS opt_bo_decision, u0.opt_execsum opt_execsum, u0.opt_biz_own opt_biz_own, u0.opt_desiredel opt_desiredel, u0.opt_govreg opt_govreg, u0.opt_cyfcap opt_cyfcap, u0.opt_busreadydate opt_busreadydate, u0.opt_busprjmgr opt_busprjmgr, u0.opt_commwork opt_commwork, u0.opt_customer opt_customer, u0.opt_restr_desc opt_restr_desc, s0.STATUS status, u0.opt_fundsubpool opt_fundsubpool, u0.opt_ext_cust opt_ext_cust, u0.opt_prg_dir opt_prg_dir, u0.opt_workexcust opt_workexcust, u0.opt_first_use opt_first_use, a0.opt_ocio_decision AS opt_ocio_decision, u0.opt_portfolio_lead opt_portfolio_lead, u0.opt_restr_res_type opt_restr_res_type, u0.opt_it_portfolio_mgr opt_it_portfolio_mgr, u0.opt_atrp opt_atrp, u0.opt_cyacap opt_cyacap, u0.opt_ucmgid opt_ucmgid, a0.opt_cc_decision AS opt_cc_decision, u0.opt_otherbillapp opt_otherbillapp, u0.opt_it_owner opt_it_owner, u0.opt_analydoll opt_analydoll, u0.opt_prgm_mgr opt_prgm_mgr, u0.opt_addroutelevel opt_addroutelevel, u0.opt_rsa opt_rsa, a0.opt_om_work AS opt_om_work, u0.opt_fasttrack opt_fasttrack FROM   inv_investments s0 , odf_ca_inv u0, odf_ca_idea a0 WHERE (   s0.id=?   AND s0.id = u0.id  AND s0.id = a0.id)

WARN  2014-09-12 07:01:18,120 [http-bio-8080-exec-430] com.niku (clarity:admin:5887397__87643DEA-C130-4BAA-BFBC-655B86445B41:XOG::idea::write) Parameter 1: 5040042

WARN  2014-09-12 07:01:18,198 [http-bio-8080-exec-430] com.niku (clarity:admin:5887397__87643DEA-C130-4BAA-BFBC-655B86445B41:XOG::idea::write) For info only - SQL statement not supported by OMP:

WARN  2014-09-12 07:01:18,198 [http-bio-8080-exec-430] com.niku (clarity:admin:5887397__87643DEA-C130-4BAA-BFBC-655B86445B41:XOG::idea::write) SQL message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "A0"."OPT_OM_WORK": invalid identifier

 

2,  below you can see te error output file from Xogclient....

 

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">

 

<Object type="idea"/>

 

<Records>

 

<Record>

 

<KeyInformation>

 

<column name="ID">5048000</column>

 

<column name="name">Dimensioning Upload Test22</column>

 

<column name="UNIQUE_NAME">IDE000383</column>

 

</KeyInformation>

 

<ErrorInformation>

 

<Severity>FATAL</Severity>

 

<Description>XOG-3656: Investment Object operation failed: update</Description>

 

<Exception><![CDATA[

 

java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "A0"."OPT_OM_WORK": invalid identifier

 

at com.ca.clarity.jdbc.oraclebase.ddcg.b(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.ddcg.a(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.ddcf.b(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.ddcf.a(Unknown Source)

 

at com.ca.clarity.jdbc.oracle.ddn.s(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.ddes.v(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.ddes.r(Unknown Source)

 

at com.ca.clarity.jdbc.oraclebase.dddm.execute(Unknown Source)

 

at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)

 

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

 

at java.lang.reflect.Method.invoke(Method.java:606)

 

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

 

at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$d4cd10f.execute(<generated>)

 

at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutor.executeQuery(OMPSqlExecutor.java:241)

 

at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:254)

 

at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:199)

 

at com.niku.omp.rt.core.service.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:136)

 

at com.niku.omp.rt.core.service.engine.core.OMPSqlExecutorDelegate.selectByCriteria(OMPSqlExecutorDelegate.java:850)

 

at com.niku.omp.rt.core.service.engine.core.OMPSessionImpl.selectByCriteria(OMPSessionImpl.java:139)

 

at com.niku.omp.rt.core.service.engine.core.OMPDbContextImpl.selectByCriteria(OMPDbContextImpl.java:154)

 

at com.niku.omp.rt.core.service.controller.AbstractBaseOperation.readInstance(AbstractBaseOperation.java:53)

 

at com.niku.odf.utils.InterestValueFetchUtil.performValueFetchFromInterests(InterestValueFetchUtil.java:285)

 

at com.niku.odf.utils.InterestValueFetchUtil.performValueFetchFromInterests(InterestValueFetchUtil.java:66)

 

at com.niku.bpm.utilities.BusinessProcessUtilsImpl.interestValueFetch(BusinessProcessUtilsImpl.java:1064)

 

at com.niku.bpm.xbl.handlers.eventmgr.InterestValueFetchHandler.postProcess(InterestValueFetchHandler.java:32)

 

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1411)

 

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.traverse(DOMWalker.java:51)

 

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)

 

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

 

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

 

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

 

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

 

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

 

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

 

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

 

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

 

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

 

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

 

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

 

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

 

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

 

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

 

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

 

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

 

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

 

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

 

at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)

 

at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)

 

at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)

 

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)

 

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

 

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

 

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.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:260)

 

at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

 

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)

 

at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)

 

at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)

 

at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:599)

 

at com.niku.xog.service.XOGSOAPServlet.processIntermediateChunks(XOGSOAPServlet.java:940)

 

at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:301)

 

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

 

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

 

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

 

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

 

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:68)

 

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

 

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

 

at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)

 

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

 

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

 

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

 

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

 

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

 

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

 

at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)

 

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

 

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

 

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

 

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

 

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

 

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

 

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

 

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

 

at java.lang.Thread.run(Thread.java:724)

 

]]></Exception>

 

</ErrorInformation>

 

</Record>

 

</Records>

 

<Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>

 

<Status elapsedTime="0.063 seconds " state="FAILURE"/>

 

</XOGOutput>

 

Outcomes