Data not loading completely

[Inge1]

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.

[MendyS]

Hi @Inge1 

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

[Inge1]

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.

[MendyS]

@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

[Albert_Candelario]

Hello @Inge1 ,

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

Keep us posted.

Cheers,

Albert

[Inge1]

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?

[MendyS]

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

[Albert_Candelario]

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...

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

[Inge1]

Hi,

I think you mean this one?

[Inge1]

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.