Discussion board where members can get started with QlikView.
I managed to connect qlikview to firebird database using odbc and loaded some tables. However, on the transactions table, the script errors when the lines fetch is over 8 million and the below error appears.
Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlStateL HY000, ErrorCode: 4294966394, ErrorMsg: [ODBC Firebird Driver][Firebird]database file appears corrupt ()
chechsum error on database page 542519
I have no idea what this means. Has anyone ever experienced this and managed to resolve the issue? Any guidance will be highly appreciated.
database file appears corrupt ()
Check that you're connecting to the right database and if you're sure about that check the database files. The error you receive comes from the firebird odbc driver you installed, not from Qlikview itself.
Further to my original post. Tried to run the script again earlier today. It was successful until the transaction table then Qlikview stopped responding. I ended the process from the task manager and rebooted, but, I can no longer connect to the Firebird database.
I had the drivers re-installed, did a test connection which was successful, but I cannot see the database tables when trying to redo the script?
Please help as this is very frustrating.