• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 20 replies
  • Subscribers 5 subscribers
  • Views 11227 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Caused by: java.sql.SQLException: Year out of range.

Sikandar Dadan

Export to Excel.

I'm using getdatasubsetdownloadlinkfromrule to get the link to download the excel. The Link work fine if I don't filter the report with Date and Time criteria, if I use ToDate or FromDate in the report Search i get "Error 500 - Internal Server Error".
I have a DateTime field in the Table and my Report has Date field which I'm converting to datetime.

Error detail attached
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
...
...
Caused by: java.sql.SQLException: Year out of range.

OriginalPostID-163797

OriginalPostID-163797

  Discussion posts and replies are publicly visible

Parents
  • 0
    Here whenever I pass the values of type DateTime as JSON and try to access them in child rule, I am getting 500 Error .. Also tried date time conversion (pasted snippet below) as you suggested but no luck ..

    local!exportUri: getdatasubsetdownloadlinkfromrule(
    rule!Report_getExportableDataSubset,
    a!toJson(
    {
    fromDateTime_dtm: todatetime(local!fromDateTime_dtm),
    toDateTime_dtm: todatetime(local!toDateTime_dtm)
    }
    )
    )
Reply
  • 0
    Here whenever I pass the values of type DateTime as JSON and try to access them in child rule, I am getting 500 Error .. Also tried date time conversion (pasted snippet below) as you suggested but no luck ..

    local!exportUri: getdatasubsetdownloadlinkfromrule(
    rule!Report_getExportableDataSubset,
    a!toJson(
    {
    fromDateTime_dtm: todatetime(local!fromDateTime_dtm),
    toDateTime_dtm: todatetime(local!toDateTime_dtm)
    }
    )
    )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.