4 Replies Latest reply: Jan 16, 2018 2:33 AM by Staffan Johansson RSS

    Script error

    Per-Otto Emilson

      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

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

          • Re: Script error
            Staffan Johansson

            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
              Per-Otto Emilson

              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