QVX_UNEXPECTED_END_OF_DATA:

[stonecold111]

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.

[stabben23]

Hi,

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

[stonecold111]

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

[stabben23]

Hi,

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

What does the document logfile shows?

[stonecold111]

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

[stonecold111]

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.

[stabben23]

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

[stabben23]

A Buffer Load, have not used so often

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

[stonecold111]

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

[stabben23]

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