We have implemented jaspersoft in our CA PPM 14.3. For Jaspersoft, we have implemented DWH setup, After that it is noted that one of the OOTB portlet (My Timesheets) got corrupted.
I xogged out the same portlet from higher environment and tried xogged in the environment where the issue reported. But it failed.(Attached the failed xogoutput file also)
Can anyone please help me to sort it out?
I have some more findings on this case.Portlet query is also corrupted.if we remove below 2 lines, query will work properly. Lines are AND tp.prstart BETWEEN ADD_MONTHS(@SYSDATE@,@NVL@(@WHERE:PARAM:USER_DEF:INTEGER:months@,-3))WHERE tp.prstart BETWEEN ADD_MONTHS(@SYSDATE@,(@NVL@(@WHERE:PARAM:USER_DEF:INTEGER:months@,-3))) 2. in the current 'my timesheet' query the preview button is also not working.Thanks,Agin
Implementation of DWH and Jaspersoft has nothing to do with this portlet. It could be a co incidence when the portlet got corrupted while implementation of DWH was undergoing. I believe you have a support case and I will work with the team to see how best we can fix that.
Thanks Suman for the prompt support and help.
sorry, I was bit late to give a reply to your response. I have already opened a CA case(#00359954) for this.