topic Re: ServiceNow data connection issue in Data Movement & Streaming

ServiceNow data connection issue

fhana — Wed, 19 Mar 2025 22:11:20 GMT

Hi

I'm trying to connect ServiceNow data in Qlik cloud,
I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.

Re: ServiceNow data connection issue

David_Friend — Mon, 15 Apr 2024 15:09:22 GMT

@fhana does the account have the permissions to access/view the tables? Are there any logs in ServiceNow showing errors?

Re: ServiceNow data connection issue

Anil_Babu_Samineni — Mon, 15 Apr 2024 15:37:10 GMT

Make sure the engine service is port opened from QS to service now URL. And, sometimes the data you preview using your personal account but in many scenarios we need our service account to be access to the service now instance/api. I have recently experience and the same has done with service account privileges to the table.

Re: ServiceNow data connection issue

fhana — Tue, 16 Apr 2024 17:45:12 GMT

We checked the privileges and created service account with admin rights, but we still see the same issue.
we see we are connected, we see the data is being pulled ( attached ) but the the same error occurs with connection to Sense.
Can this be any of the settings like time out or max string length ?

Re: ServiceNow data connection issue

Anil_Babu_Samineni — Wed, 17 Apr 2024 13:39:42 GMT

Both screenshots from ServiceNow, Can we know the error what it shows in Qlik and is there any logs what it is pointing in driver logs?

Re: ServiceNow data connection issue

fhana — Tue, 23 Apr 2024 12:19:36 GMT

Hey, I opened a support case.
We've found that the data is being pulled in batches from ServiceNow and then stops with the error as in description of this topic.

I used Load editor and saw more detailed issue, dome tables are possible to sync and others are not ... seems like it is a problem with the way the connector parses data - and some escape characters are disrupting the sync for some tables like taks.

when I'll have more info I'll share

Re: ServiceNow data connection issue

RajaDumpa — Fri, 19 Dec 2025 17:09:36 GMT

@Anil_Babu_Samineni : Hi Anil, My question may be a bit late, our cluster is on Feb 2024 SR17 version, but I face the same issue even after re-setting the Qlik Sense dedicated service account privileges in ServiceNow DB tables. It seems to be pickup certain tables with less columns and data fast in the column selector window. But any table related to Incidents are requests is spinning to fetch the metadata. The ports are open as i can see a successful data connection when created.

Can you elaborate on the Engine Service Port opening to Service Now URL? I have whitelisted the URL aswell in the Virtual proxy aswell. The below is a successful connection but it keeps failing when I add a Where clause with In condition. but When i added just = operator, it ran for 5 Hrs and pulled data into this.

Can you advice further

Re: ServiceNow data connection issue

fhana — Mon, 05 Jan 2026 08:33:33 GMT

In our case, increasing the timeout on the ServiceNow side was most helpful.