Skip to main content
July 29, 2024
Question

Query Entity is throwing error while fetching data

  • July 29, 2024
  • 11 replies
  • 0 views

Hi All,

We are facing one issue while fetching data having few filters. For e.g., the filters like to_date, fund etc are working fine but the moment we select from Date, it throws error. And surprisingly when I am selecting from_date after selecting any other filter, it is working fine.

    11 replies

    venkatrea696188
    July 29, 2024

    That was casting error. Have you checked datatype of BalanceData column in your CDT. Validate whether your value data type and Column datatype are same or not

    davidj137213
    Brainy
    July 29, 2024

    But if it is a conversion error, it should fail when using the date filter with another one... and in that case it is working fine (unless in that case the query returns an empty result set)

    stefanhelzle0001
    Brainy
    July 29, 2024

    Typically such an error message indicates a timeout. Did you check the tomcat stdout log file?

    July 30, 2024

    Not yet. Wondering why timeout should happen on only one field when the to date is also mapped to the same column at the backend.

    karumurua531442
    July 29, 2024

    hi [mention:e6a77c526cda4697918a8c5f921f4fa4:e9ed411860ed4f2ba0265705b8793d05]  that could be time out also, or there is a possibility if wrong data is stored in columns

    July 30, 2024

    We have verified the data and the values stored are consistent.

    July 30, 2024

    You can try below alternate option.


    1. Are you executing query entity on each filter?

    2. If Yes, instead of executing on each filter, have a button like "Search" and execute query entity on click of Search