Clarity

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

If the attribute is in the program list view and it is also in the view configuration so that the user can try to delete it then it should be in the Attribute list and in the Studio Program list view configuration available columns.

If the attribute has been earlier active and been placed in the Program list view it would remain there even if it is made inactive later on.

If it is made inactive it will not display in the list of attributes if the filter is set to Active.
If it is made inactive is should not display in the Available columns, but it should display in the Selected columns if it has been placed in the list view while it was still active.

Can go back to the app-niku.log and see what the error message is there.


Martti K.

-
SAFETY STEP >>> I would first recommend performing a COPY from PROD to DEV or TEST and verify the steps and results before trying this in the production environment. :-)
-
This happen to me once ...
-
Check the attribute in the VIEW list and to see of the values in the attribute fields are populated.
-
When this occured to me - the values in the attribute fields (on the View list) had "fallen out" - which is not suppose to happen as the fields on the Attribute List view are required.
-
If the attribute fields are populated with values >>> Then look at the field from the Attribtue link/list and see if the values in the attribute fields (on the Attribtue list) had "fallen out".
-
I have seen this occur in two situations. (1) When installing a Add-IN package and (2) after a "hot-database" backup was attempted.
-
I had to RESTORE DEFAULTS for the entire object to correct the issues. BUT BEFORE YOU DO THAT - taks screens shots of the Project Screen as well as the Program Screens so the views can be re-configured.
-
Stephen Forney

thnks for sharing your thoughts,edited my post ...pls review...

I don't think

values went out of bound

can happen with a Time varying attribute, or at lest it has not happened to me.
If you have a time varying attribute of type number typically you would have the total value in a field in the GUI and the timescaled values when you have placed them in a timescaled field.
If the time scale is beyond the time range of you values you would get blanks.
In the database you would see blobs unless you have created timeslices for the time varying attribute. Then you would see the values in the time slices.
The difference with the timescaled field and time slices is that the values for the timescaled view are created in the fly by the blob cracker and you can't see them in the dabase.
While you can see the values in the time slices as plain numbers in the the database, but you are limited to your slice definitons.

For some small illustrations see.
Copying blob fields
97591249

where I was looking for a way to copy allocations to a timevarying attribute. The interest was because the allocations are displayed as percentage in the Staff member view and in hours/days in some other views while some users would prefer hours/days everywhere.
For time varying attributes that is always the same once you choose the type.


Martti K.

when ever we use the TSV values, when the page of the view is executed, it run the java code for the page with the i/p from the columns in the backend and when the ' ' values are passed as an i/p from the tsv field
this error occured...this happened in our environment too...

either the periodical data in the tsv fields need to be changed to avaoid this kind of issue else user must be educated to retrieve the values with in the limit...

IT would be interesting to see some screenshots of

either the periodical data in the tsv fields need to be changed to avaoid this kind of issue else user must be educated to retrieve the values with in the limit...

Martti K.

I do get the same error when try to configure those fields in sandbox environments as well.

I tried to configure "Detailed budget benefit" column i got the same error in CA sandbox environment like the error which i got in our env.See the attached Screen shots

Is it a bug in clarity itself?

Got the error message for the fields highlighted (SS3.jpeg) in my env.

Regards,
NaG

Kesaven,
Thanks for sharing your thoughts...I didn't find any TSV values related to these fields in data administration-> time slices.
And also inside the view layout i didn't find those fields.The fields are mentioned in the screen shots.

Sorry if i am wrong and correct me as well.

Regards,
NaG

After seeing the screenshot tried to add one of the fields in the program list in the Sandbox and that gave the error immediately.
The log entry was

ERROR 2012-12-31 14:12:36,681 [http-14001-26] niku.xql2 (clarity:mkinnunen:6286709__50A41E6B-7717-4060-9AAD-F332E1233ADF:projmgr.programUnpurgeSelitemCheckConfirm) Internal Processing exception
java.lang.NumberFormatException

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

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

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

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

which really does not hep much.

Sounds like a bug.

After establishing the error I was faced with another problem: Ho to recover from that. In pre v13 you could go directly to the config view if you established what the URL was.
in V13 configure is a pop up and can't be accessed via an URl.
So I had to restore defaults (for everybody) in studio just to get mine view back.

Martti K.

Yes martti.It looks like a bug.

As a temperory workaround, we can reconfigure(remove) the problematic columns by going the configure link dierectly in Clarity v12 and Clarity 13


For clarity v12
https://cppm1109.ondemand.ca.com/niku/app?action=npt.filterUserLayoutEntry&ui.page.space=projmgr.programs&ui.page.template=union.appPage&url=%2Fniku%2Fapp%3Faction%3Dprojmgr.programs&pageId=projmgr.programs&portletInstanceId=projmgr.programList_odf&object=project&component=projmgr&id=projmgr.programList&view_code=programList&filter_view_code=programList&isFilter=true


For clarity V13
Just edit the first part of URL in clarity v12 (i.e)

https://cppm1109.ondemand.ca.com/niku/app?action=

Eventhough it appears to be a pop up in clarity v13 the direct link works
For clarity V13 sandbox
https://cppm1109-test.ondemand.ca.com/niku/nu#action:npt.filterUserLayoutEntry&ui.page.space=projmgr.programs&ui.page.template=union.appPage&url=%2Fniku%2Fapp%3Faction%3Dprojmgr.programs&pageId=projmgr.programs&portletInstanceId=projmgr.programList_odf&object=project&component=projmgr&id=projmgr.programList&view_code=programList&filter_view_code=programList&isFilter=true


Sometimes using the direct link for configure page doesn't work (Sometimes i get the page with no columns at all in avilable/selected columns in cofigure page), trying 2nd and 3rd time with the same URL,should work.


Adding few more details about the issue.In programs view, it looks like the few characters (apart from decimal numbers) are being passed as parameters in programs view,but in projects the values are passed correctly in a defined format.(Attaching the Screen shots)