Portlet failing with error 500

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.