topic Re: Script error in Archived Groups

Script error

poen4815 — Tue, 22 Jul 2025 17:59:49 GMT

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

Re: Script error

Anil_Babu_Samineni — Mon, 15 Jan 2018 15:18:31 GMT

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

Re: Script error

stabben23 — Mon, 15 Jan 2018 15:21:15 GMT

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.

Re: Script error

poen4815 — Mon, 15 Jan 2018 16:35:48 GMT

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

Re: Script error

stabben23 — Tue, 16 Jan 2018 07:33:28 GMT

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.