topic Re: Problem download from PostgreSQL in QlikView

Problem download from PostgreSQL

Fri, 18 Nov 2011 09:12:08 GMT

Hi.

I can't download data from PostgreSQL30 database (I'm using ODBC). QlikView gives me a such error:

Script error

SQL##f - SqlState: 0A000, ErrorCode: 7, ErrorMsg: ERROR: cross-database references are not implemented: "tabl.public.moron";

Error while executing the query

SQL SELECT *

FROM Tabl."public".moron

Connecting test to PostgreSQL30 is succesful and I can see all tables in my db.

Also, I can import data from PostgreSQL db in MS Excel and MS Access files with out any problem.

Does anybody know, how this problem is solved?

Thank you.

Problem download from PostgreSQL

Fri, 23 Dec 2011 08:27:24 GMT

I found solution of my problem. I had to upgrade my PostgreSQL from ver.8 to ver.9.

Re: Problem download from PostgreSQL

Fri, 23 Dec 2011 09:07:56 GMT

you should install ODBC driver PostgreSQL for connect to qlikview

Re: Problem download from PostgreSQL

Fri, 23 Dec 2011 10:14:13 GMT

I had already reinstalled ODBC driver PostgreSQL three times and I had always got the same error. but when I installed ver.9, my problem was solved.

Re: Problem download from PostgreSQL

erivera10 — Fri, 26 Sep 2014 22:48:58 GMT

@billknilton

I found a solution for this error, reinstall, reboot, did many things and many assumptions methods, but what worked for me after analyzing the code I found the error.

When you load a table shows you the code by default.

SQL SELECT *

FROM testing."public"."sale_order_line";

The solution is as follows:

SQL SELECT *

FROM "public"."sale_order_line";

Good luck.

Encontré una solución para este error, reinstale, reinicie, hice muchas cosas y muchos supuestos metodos, pero lo que me funcionó después de analizar el código encontre el error.

Cuando tu cargas una tabla te muestra este código por default.

SQL SELECT *

FROM testing."public"."sale_order_line";

La solución esta así:

SQL SELECT *

FROM "public"."sale_order_line";

Buena suerte.

Re: Problem download from PostgreSQL

Anonymous — Sun, 14 Feb 2016 11:09:38 GMT

Thanks...

Worked for me

Re: Problem download from PostgreSQL

jananireddy — Thu, 07 Apr 2016 07:15:08 GMT

Hi, i am using postgreSQL 9.4 and i am getting the following error when i run load data

The following error occurred:

SQL##f - SqlState: 0A000, ErrorCode: 7, ErrorMsg: ERROR: cross-database references are not implemented: "fincluez.fincluez.casanonod";

Error while executing the query

Query for the same table (casanonod) from postgreSQL editior works fine, it give me an error only when it is called from qlik sense

Any suggestion for this??

Re: Problem download from PostgreSQL

erivera10 — Thu, 07 Apr 2016 15:21:31 GMT

You can send a example query and ole db or odbc conection?