When doing a reload in QlikView Developer/Desktop or utilizing QlikView Distribution Service / Publisher the following symptoms is experienced:
- The error message QVX_UNEXPECTED_END_OF_DATA appears in the Document Script log.
- Typically this happens intermittently e.g. the same script will reload just fine while at some occasions it will fail with the mentioned error message.
- The error message could appear in any script line.
- The error message appears when you have a open ODBC/OLEDB connection
Environment:
QlikView all versions
This error message appear when:
- Usage of CPU and/or RAM have reached their maximum on the Windows machine were the reload was performed
- The database server is heavily loaded and can't provide the requested information
Resolution:
Turn on Windows performance monitor during a period of time and compare the results with reload(s) that fail. You should see a clear trend that tasks are failing when the Windows Server are running out of resources. If you run into these issues because of lack of RAM a quick fix would be to restart the Qlikview server service at a scheduled basis as that would free up resources. Also rescheduling the reload tasks based on the statistics from the Windows Performance Monitor logs would help as most probably there are timeslots during a 24 hour period were there are more resources available.
Another approach would be to consider to split up the QlikView services on two different machines.
If none of the above is feasible, upgrade the Windows Servers RAM and/or CPU.
