AnsweredAssumed Answered

How to delete available columns in Manage program View?

Question asked by Nag_cl on Dec 27, 2012
Latest reply on Jan 2, 2013 by Nag_cl
Hi,

We got an issue recently, user was telling us that when he was trying to configure all the columns in manage program view,the user was getting the error(SS1 attached)

>
Edited


Later we analysed and found there are around 6 columns are creating this issue, if the user didn't configure those columns,it works fine.All those columns are of time varying data type.

My guess is values went out of bound(grater than the limit - for ex in C prgramming we cannot put integer datatype into byte datatype)
Now the question is, how to find,how the columns are populated
When i look at the db it was blob datatype (in UI column name - Detailed Budget Cost,DB table name - FIN_FINANCIALS,DB column name - BUDGET_cost) i was nt able to see the values there.how to view the values?


App - niku log
ERROR 2012-12-27 03:28:29,369 [http-8080-7] niku.xql2 (admin:97748141__66D113E4-FBD9-4E6B-BC70-795F5847DDDC:projmgr.programs) Internal Processing exception
java.lang.NumberFormatException: Not a valid char constructor input: [B@733b733b

at java.math.BigDecimal.bad(BigDecimal.java:1842)

at java.math.BigDecimal.charParser(BigDecimal.java:1173)

at java.math.BigDecimal.<init>(BigDecimal.java:905)

at java.math.BigDecimal.<init>(BigDecimal.java:885)

at com.niku.odf.griphendor.dal.XMLCube.getValueFromElement(XMLCube.java:634)

at com.niku.odf.griphendor.dal.XMLCube.getMemberPropertyValue(XMLCube.java:476)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getBodyRowCellValue(DefaultTableDataset.java:1498)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getBodyRowCellValues(DefaultTableDataset.java:1300)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getCellValues(DefaultTableDataset.java:952)

at com.niku.odf.griphendor.grid.Transformer.processCell(Transformer.java:1190)

at com.niku.odf.griphendor.grid.Transformer.processRowCells(Transformer.java:1019)

at com.niku.odf.griphendor.grid.Transformer.processRow(Transformer.java:857)

at com.niku.odf.griphendor.grid.Transformer.processDataSet(Transformer.java:686)

at com.niku.odf.griphendor.grid.Transformer.transform(Transformer.java:219)

at com.niku.odf.griphendor.grid.GridKernel.processRequest(GridKernel.java:245)

at com.niku.odf.griphendor.GriphendorEngine.processGridRequest(GriphendorEngine.java:130)

at com.niku.odf.griphendor.GriphendorEngine.processRequest(GriphendorEngine.java:81)

at com.niku.npt.xblhandlers.GridHandler.getGrid(GridHandler.java:167)

at com.niku.npt.xblhandlers.GridHandler.postProcess(GridHandler.java:94)

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

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:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:412)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:277)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:161)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:760)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:214)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:196)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1371)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:891)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:385)

at com.niku.union.web.PortletController.processRequest(PortletController.java:160)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1090)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:322)

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

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

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

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:121)

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

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

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

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

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

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

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

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

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

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

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Thread.java:736)
ERROR 2012-12-27 03:29:47,353 [http-8080-7] niku.xql2 (admin:97748141__66D113E4-FBD9-4E6B-BC70-795F5847DDDC:projmgr.programs) Internal Processing exception
java.lang.NumberFormatException: Not a valid char constructor input: [B@46b546b5

at java.math.BigDecimal.bad(BigDecimal.java:1842)

at java.math.BigDecimal.charParser(BigDecimal.java:1173)

at java.math.BigDecimal.<init>(BigDecimal.java:905)

at java.math.BigDecimal.<init>(BigDecimal.java:885)

at com.niku.odf.griphendor.dal.XMLCube.getValueFromElement(XMLCube.java:634)

at com.niku.odf.griphendor.dal.XMLCube.getMemberPropertyValue(XMLCube.java:476)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getBodyRowCellValue(DefaultTableDataset.java:1498)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getBodyRowCellValues(DefaultTableDataset.java:1300)

at com.niku.odf.griphendor.grid.DefaultTableDataset.getCellValues(DefaultTableDataset.java:952)

at com.niku.odf.griphendor.grid.Transformer.processCell(Transformer.java:1190)

at com.niku.odf.griphendor.grid.Transformer.processRowCells(Transformer.java:1019)

at com.niku.odf.griphendor.grid.Transformer.processRow(Transformer.java:857)

at com.niku.odf.griphendor.grid.Transformer.processDataSet(Transformer.java:686)

at com.niku.odf.griphendor.grid.Transformer.transform(Transformer.java:219)

at com.niku.odf.griphendor.grid.GridKernel.processRequest(GridKernel.java:245)

at com.niku.odf.griphendor.GriphendorEngine.processGridRequest(GriphendorEngine.java:130)

at com.niku.odf.griphendor.GriphendorEngine.processRequest(GriphendorEngine.java:81)

at com.niku.npt.xblhandlers.GridHandler.getGrid(GridHandler.java:167)

at com.niku.npt.xblhandlers.GridHandler.postProcess(GridHandler.java:94)

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

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:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:412)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:277)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:161)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:760)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:214)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:196)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1371)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:891)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:385)

at com.niku.union.web.PortletController.processRequest(PortletController.java:160)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1090)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:322)

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

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

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

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:121)

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

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

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

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

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

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

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

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

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

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

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Thread.java:736)
regards,
NaG

Attachments

Outcomes