OOTB portlet got corrupted after the implementation of DWH setup for Jaspersoft

[Legacy User]

Hi All,

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?

 

Thanks,

Agin

Attachment(s)

cop_invMyTimesheets_out.xml.zip   1 KB 1 version

[Legacy User]

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 

[Suman Pramanik]

Hi 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.

 

Regards

Suman Pramanik

[Legacy User]

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.

 

Thanks,

Agin