Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poen4815
Contributor
Contributor

Script error

Vid laddning av data erhåller jag felmeddelandet nedan. Vid laddning kompletteras tabellnamnet med användarnamnet i ODBC-källan). Vad kan detta bero på?

SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "UFORU01.BI_BETYGSGRADER" is an undefined name.  SQLSTATE=42704

SQL SELECT *
FROM BI_BETYGSGRADER

P-O

4 Replies
Anil_Babu_Samineni

Looks like this error comes from data source. Does that tables are there?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
stabben23
Partner - Master
Partner - Master

Hi Per-Otto,

Write in English will increase Your chances to get an answer.

Have you tick Generate Logfile here? You find below Settings-->Document Properties.

It much easier to see whats happens in that logfile.

Is it a reload from desktop or server? Have it ever work before?

Does Your user have read authorization to the database?

But first give us some more info from logfile.

poen4815
Contributor
Contributor
Author

Hi and thank you för your help!

I get table information to Excel using MS Query and same ODBC source ...

Here is the end of my log file:

2018-01-15 15:14:12 0026 LET StartTime=Now()

2018-01-15 15:14:12 0031 ODBC CONNECT TO ***

2018-01-15 15:14:14 0044 BETYGSGRADER:

2018-01-15 15:14:14 0045 LOAD

2018-01-15 15:14:14 0046 *

2018-01-15 15:14:14 0047 SQL SELECT *

2018-01-15 15:14:14 0048 FROM BI_BETYGSGRADER

2018-01-15 15:14:14      Error: SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "UFORU01.BI_BETYGSGRADER" is an undefined name.  SQLSTATE=42704

2018-01-15 15:14:14     

2018-01-15 15:28:00      SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "UFORU01.BI_BETYGSGRADER" is an undefined name.  SQLSTATE=42704

2018-01-15 15:28:00     

2018-01-15 15:28:00      Execution Failed

stabben23
Partner - Master
Partner - Master

Ok, looks like you dont get any Connect to DB by using ODBC.

Create a New Connect with a OLE DB for SQL server instead.