Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)"
)
;
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.
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?
Is the new computer in the same network as the previous one? Same firewall, proxy...
Yes, computer is in same network and (with TimeMachine) same settings,....