Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem download from PostgreSQL

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.

7 Replies
Not applicable

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

Not applicable

you should install ODBC driver PostgreSQL for connect to qlikview

.

Not applicable

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.

erivera10
Creator
Creator

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

eran_dayan
Contributor III
Contributor III

Thanks...

Worked for me

jananireddy
Partner
Partner

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

erivera10
Creator
Creator

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