Portlet failing with error 500

book

Article ID: 198378

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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?

Environment

Release : 15.5

Component : CA PPM STUDIO

Resolution

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