Script error

[poen4815]

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

[Anil_Babu_Samineni]

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

[stabben23]

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]

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]

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.