topic Re: QVX_UNEXPECTED_END_OF_DATA: in QlikView

QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Tue, 18 Apr 2017 08:40:16 GMT

when i reload in application. it is working fine. but when i ran in qmc task. its failing with following error

qlikss suggest

QVX_UNEXPECTED_END_OF_DATA: The collection has been marked as complete with regards to additions.

Error: Custom read failed

General Script Error

Execution Failed

Execution finished.

Re: QVX_UNEXPECTED_END_OF_DATA:

stabben23 — Thu, 20 Apr 2017 06:19:46 GMT

Hi,

Check Your Connections (ODBC,OLEDB, etc) on serverside.

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 06:34:20 GMT

hi Staffan,

my connection is custom connect to qvsalesforceconnector.exe

i had connection at top of the script like $(connection);

and it failed when it is fetching data from a particular table and converting into qvd

i just added one more connection at the start of this table and its working fine now

and one more thing whenever i run in application it is reloading noramlly. i am getting error only when i run through QMC

i don't know why

Re: QVX_UNEXPECTED_END_OF_DATA:

stabben23 — Thu, 20 Apr 2017 06:44:12 GMT

Hi,

could it be that The service account dont have premission to save qvd to disc/Folder?

What does the document logfile shows?

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 06:55:20 GMT

QVX_UNEXPECTED_END_OF_DATA: The collection has been marked as complete with regards to additions.

Error: Custom read failed

General Script Error

Execution Failed

Execution finished.

this is the log error

no it has permissions. almost we are creating more than 100 qvds for different dashboards daily using same account

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 06:59:04 GMT

revision_SQL:

BUFFER (stale after 1 day)

SQL SELECT

offer,

Id,

Product,

Quantity,

Unit_Price

FROM revision

5 fields found: offer, Id, Product, Quantity, Unit_Price,

2017-04-19 02:31:46

2017-04-19 02:31:46 QVX_UNEXPECTED_END_OF_DATA: The collection has been marked as complete with regards to additions.

2017-04-19 02:31:46 Error: Custom read failed

2017-04-19 02:31:46 General Script Error

2017-04-19 02:31:46 Execution Failed

2017-04-19 02:31:46 Execution finished.

Re: QVX_UNEXPECTED_END_OF_DATA:

stabben23 — Thu, 20 Apr 2017 06:59:22 GMT

Ok, are those who create the othyer 100 qvd's using the same Connect, $(connection);?

Re: QVX_UNEXPECTED_END_OF_DATA:

stabben23 — Thu, 20 Apr 2017 07:10:33 GMT

A Buffer Load, have not used so often

is the location where you have Your Buffer known from Server?

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 07:23:04 GMT

yes we have buffer load like this on 5 other tables also

but its working fine when it fetching data from them

but it failed when it comes to this table, but after adding connection variable at the start of this table, it worked fine

Re: QVX_UNEXPECTED_END_OF_DATA:

stabben23 — Thu, 20 Apr 2017 07:27:29 GMT

Ok, so you have solved it With a workaround that is acceptable?

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 07:31:07 GMT

no for this connection 6 qvds we are generating

Re: QVX_UNEXPECTED_END_OF_DATA:

stonecold111 — Thu, 20 Apr 2017 07:34:50 GMT

if it is acceptable or not, that is secondary

for now it is working fine, based on these qvds other dashboards are running

but i need permanent solution. i checked in this qlik community also, but nobody has permanent fix