search cancel

Portlet failing with error 500


Article ID: 198378


Updated On:


Clarity PPM On Premise


I have created a new portlet. The portlet is a query based. The query runs good. and it is validated when I created the query. however when I add the portlet to the portlet page I get Error 500 - Internal Server Error
I looked in the logs I don't have enough information. How can I increase the log level to log more warning and info? how can I debug my problem?


Release : 15.5

Component : CA PPM STUDIO


Error was caused by NSQL error on the function for date formatting, the floor() function worked well and solved the problem.