Dont select data from sql dbo tables..

[Liudas]

In Qlik Cloud version we can't connect to sql (.dbo) database. We have successfully connected to the server. we can extract data from sys or information schema tables, but not from dbo table. Error: „Error connecting to the Sense service“. In desktop version works and microsoft sql managament studio works perfectly. Does anyone have any ideas?

[NadiaB]

Hi @Liudas 

That error looks misleading, if you are able to connect to the DB and read from sys tables, the only think that occurs to me is that the user is not able to read from that table, are you using the same user when testing in the different tools mentioned above?

Since you are trying to use "from  dbo.tablename "to trigger the query, if you try with "from databasename.dbo.tablename", does it work ? Other think would be to use the preview and let Qlik Sense generate the query (from the connection select "select data" and use the tool to autogenerate the query).

Let us know the outcome of the test mentioned above. 

[Liudas]

Hi Nadia

I use the same user when im testing.

When i manually write the login script and program code:

LIB CONNECT TO 'Connection name';

SQL SELECT

       ...

FROM databasename.dbo.tablename;

It works perfectly.

But in preview mode im getting an error:

Why Qlik Sense cant generate query automatically?

Thank you for you help.

[NadiaB]

Hi @Liudas 

That information is very helpful, so basically you can query dbo tables directly in the script but not  select anything from the preview window.

Do you see any errors in the Network tab browser tools ? 

Sometimes that information has more details than the error presented in the window. 

Save network web traffic (HAR/XML file) and console logs from the browser's developer tools

https://community.qlik.com/t5/Knowledge/Save-network-web-traffic-HAR-XML-file-and-console-logs-from-...

Kind Regards. 

[Liudas]

Hi NadiaB,

Thank for you help.

Can you explain where the problem might be?