Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
i have a simple Qlikview dashboard using a REST connection to pull data from an API.
Manual reload works just fine but fails when using a scheduled reload.
Error:
20210125T152052.970+0000 Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.
20210125T152052.970+0000 Execution Failed
20210125T152052.972+0000 Execution finished.
QVrestconnector is installed on all QDS nodes and i'm testing it with same local user which same as service account running Qlik services
I did try some of suggested solutions for previous questions raised here but without any help.
Many thanks,
Mihai
Hi @mihaicoroi,
Suggest that you review the Qlik REST connector logs for both a successful reload when run from QV Desktop and an unsuccessful reload when run from QV Server/Publisher and look for discrepancies. The Qlik Help has an entry on where to locate the REST Connector log files Locate the Qlik REST Connector log file .
I suspect there is a difference in privileges when the reload task runs as a service (QV Server/Publisher) versus when run as a user (QV Desktop).
Best Regards
Hi @Chip_Matejowsky ,
thank you for your hit.
I did a check on Qvrestconnector logs and i can see a major difference but i can't explain it:
1. when reloaded from QV Desktop log file looks ok
10:59:08,593 [1] - Configuring connector
10:59:08,722 [1] - Running server
10:59:08,866 [1] - Command pipe connected...
10:59:08,898 [1] - RECEIVED: QvxRequest {Command=QVX_CONNECT, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
10:59:08,952 [1] - SENDING: QvxReply {Result=QVX_OK}
10:59:08,965 [1] - RECEIVED: QvxRequest {Command=QVX_EXECUTE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
10:59:09,042 [1] - SENDING: QvxReply {Result=QVX_OK}
10:59:09,130 [4] - HTTP: Final URL ....
10:59:09,130 [4] - HTTP: Final headers ....
2. when reloaded from the QMC job i get only this:
10:08:25,771 [1] - Configuring connector
10:08:25,874 [1] - Running server
10:08:25,979 [1] - Command pipe connected...
10:08:25,996 [1] - RECEIVED: QvxRequest {Command=QVX_GENERIC_COMMAND, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
10:08:26,006 [1] - SENDING: QvxReply {Result=QVX_OK}
10:08:26,009 [1] - RECEIVED: QvxRequest {Command=QVX_GENERIC_COMMAND, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
10:08:26,009 [1] - SENDING: QvxReply {Result=QVX_OK}
10:08:26,009 [1] - RECEIVED: QvxRequest {Command=QVX_TERMINATE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
10:08:26,010 [1] - SENDING: QvxReply {Result=QVX_OK}
10:08:26,010 [1] - TERMINATING
Do you have any idea about what can cause it?
Many thanks!
Mihai