Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
zadravecm
New Contributor III

Trouble with the connecting to the service: QVX_UNEXPECTED_END_OF_DATA

Hi,

I have trouble with connecting to a external server.

I keep getting the:

11 fields found: ....

Error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 403 (Forbidden):

on server side I get a log that it serve the result but (if I understand this error) it seams to me that Qlik Sense doesn't get it.

If I mock the result and call it with mocky then it is working,...

I call service with:

SQL SELECT

    "__KEY_root",

    (SELECT

        "orderId",

        "orderSequence",

        "machineId",

        "priority",

        "__KEY_operations",

        "__FK_operations",

        (SELECT

            "start",

            "end",

            "__FK_operationInterval"

        FROM "operationInterval" FK "__FK_operationInterval")

    FROM "operations" PK "__KEY_operations" FK "__FK_operations")

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION(

        Url "$(Url)/solution/$(RequestId)",

        HTTPHEADER "customer" "$(User)",

        HTTPHEADER "signature" "$(my_signature)",

        HTTPHEADER "request_time" "$(my_time)"

)

;

4 Replies

Re: Trouble with the connecting to the service: QVX_UNEXPECTED_END_OF_DATA

That "Forbidden" seems quite explicit. Does the remote server allow the user you are connecting with, IP address of Qlik Sense, etc.? If it's a service for which you have to register, you will have to include a token or a code or similar so the service knows it's you.

zadravecm
New Contributor III

Re: Trouble with the connecting to the service: QVX_UNEXPECTED_END_OF_DATA

Yes I authenticate with

HTTPHEADER "customer" "$(User)",

HTTPHEADER "signature" "$(my_signature)",

As I say, the server (at least his logs) report that server return result.

I guess that if server reject user, then server will not log that he return result.

The problem is that this was working, then I change computer, download new Qlik Sense, copy app to it, and now it doesn't work... Is there any Qlik Sense think to not receive some https responses?

Re: Trouble with the connecting to the service: QVX_UNEXPECTED_END_OF_DATA

Is the new computer in the same network as the previous one? Same firewall, proxy...

zadravecm
New Contributor III

Re: Trouble with the connecting to the service: QVX_UNEXPECTED_END_OF_DATA

Yes, computer is in same network and (with TimeMachine) same settings,....