Error generating report

[rafagirl586]

Good afternoon!

I'm reviewing a report and I can't run it because it has the following message:

The report's main query has a filter similar to the one shown below:

SELECIONE ID, RECEIVEDDATE

DA PURCHASE_ORDER

WHERE RECEIVEDDATE BETWEEN TO_TIMESTAMP('2021-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') 
    AND TO_TIMESTAMP('2023-05-18 23:59:59', 'YYYY- MM-DD HH24:MI:SS')

When I run this query through pgadmin there are no execution failures.

Thanks in advance to anyone who can help.

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Domenico Donofrio]

Hi rafagirl586,

 

according to this link https://stackoverflow.com/questions/60592306/error-invalid-value-for-mi-detail-value-must-be-an-integer, any literal used in  SELECT_TO_TIMESTAMP function should be surrounded by double quotes. Can you check you don't have any literal (T I guess) like this?

 

[rafagirl586]

Hi, thanks for the reply, but I already solved the problem. The message was displayed because the parameter informed by the web interface was formatted differently from the format expected by the parameter created in jasper.