App reload failure - Invalid time(hours)

achakilam1022 — Sat, 16 Nov 2024 19:05:08 GMT

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!

Re: App reload failure - Invalid time(hours)

Fielies — Thu, 18 Jul 2024 08:33:17 GMT

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.

topic App reload failure - Invalid time(hours) in App Development

App reload failure - Invalid time(hours)

Re: App reload failure - Invalid time(hours)