REST Connector \ Scheduled job fails to run

[mihaicoroi]

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

[Chip_Matejowsky]

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

[mihaicoroi]

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