topic Re: Data not loading completely in Data Movement & Streaming

Data not loading completely

Inge1 — Wed, 19 Mar 2025 23:06:21 GMT

Dear,

Recently our Qlik account has been transfered from one user to another user in the company.

We lost all reports, but managed to transfer the reports back from the original to the new user.

However, the SQL connection was lost and we had to recreate it.

This worked partially. The connection is there but data always stops loading all of a sudden and we haven't been able to load the full report ever since.

Still loading nicely...

Suddenly, without apparent reason, it stops.. claiming the data connection has been lost.

The connection is ODBC to a SQL Server.

Any help on this issue would be appreciated, thanks.

Re: Data not loading completely

MendyS — Wed, 28 Sep 2022 11:36:18 GMT

Hi @Inge1

please check if the new user has permission to this connector (via QMC)

Re: Data not loading completely

Inge1 — Wed, 28 Sep 2022 14:11:19 GMT

Dear @MendyS

Where can we find this QMC?

It seems strange that the user would not have permission, since it starts loading for a while and then just stops.

In the screenshots you can see that 87K rows already were processed.

Re: Data not loading completely

MendyS — Wed, 28 Sep 2022 14:21:49 GMT

@Inge1

It looks like you have a couple of connections, Is that correct?
if yes, please check if you have access to this connector
for example - create Test App and load only 1 field from this connector
also, you can check in logs file where exactly the error happen,

let me know if that help, or its something else

Re: Data not loading completely

Albert_Candelario — Wed, 05 Oct 2022 10:43:27 GMT

Hello @Inge1 ,

I do think @MendyS approach can help to narrow down the issue.

Keep us posted.

Cheers,

Albert

Re: Data not loading completely

Inge1 — Wed, 05 Oct 2022 11:37:39 GMT

Hi everybody,

Thanks for the insights so far.

I also tested retrieving a smaller dataset (few days), and this works - most of the time. This means that the query and connection are correct.

However, for the report we need to retrieve 4 years of data, while even 1 month doesn't work.

Any ideas?

Re: Data not loading completely

MendyS — Thu, 06 Oct 2022 06:17:54 GMT

@Inge1
Hi
can you send the screenshot of where the script falls? or the logs file?

Re: Data not loading completely

Albert_Candelario — Thu, 06 Oct 2022 19:37:48 GMT

Hello @Inge1 ,

I would suggest to edit the tcp keep alive value on the SQL server and see if it helps:
https://learn.microsoft.com/en-us/sql/tools/configuration-manager/client-protocols-tcp-ip-properties-protocol-tab?view=sql-server-ver16

This error basically means that it was unable to connect to the target database. Is always happening after a certain period of time or loading specific tables? or is random?

Cheers,

Albert

Re: Data not loading completely

Inge1 — Thu, 13 Oct 2022 12:14:04 GMT

Hi,

I think you mean this one?

Re: Data not loading completely

Inge1 — Thu, 13 Oct 2022 12:16:34 GMT

Hi Albert,

The error is always happening after a certain period of time, for a specific query.

The strange thing is the report used to work for another user. That user left the company and the report was transferred to another user, and now it doesn't work anymore.

ON DB level nothing has changed.

Re: Data not loading completely

Albert_Candelario — Sun, 16 Oct 2022 18:39:10 GMT

Hello @Inge1 ,

Would it be possible to recreate the connection and copy/paste the code on a new application and see if the outcome is the same or not? I would expect the same, but still would be good to know, unless the connection was using the old user credentials or anything similar.

Is always failing on the same table?

can you query only that table if is the case on a new app and see the outcome?

Cheers,

Albert

Re: Data not loading completely

Inge1 — Tue, 18 Oct 2022 10:35:31 GMT

Hi,

I duplicated the report, commented all other queries, and recreated the connection.

It did seem to retrieve a little more, but still not enough for reporting purposes since they need multiple years.

It is always the same table / query giving problems.

Cheers