App reload failure - Invalid time(hours)

[achakilam1022]

Hi,

We are facing Qlik sense application reload failure. We had no issues with this app's reload in the past and we are suddenly seeing this. The query runs in MySQL workbench with no errors. 

Here is the error message

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22007, ErrorCode: 0, ErrorMsg: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.11]Invalid time(hours) format. Use interval types instead

Any help with this is appreciated. Thanks!

[Fielies]

We just had the same problem. I asked our MySQL guy to run the query directly on the DB and he found rows that had an end time of 24:00:00 which as a string is fine but as time is illegal. He updated those and that solved the issue.