4 Replies Latest reply on Jan 14, 2019 9:07 AM by Nico Heinze

    Workflow Manager 9.6 | DB2 | ERROR

    Venkat CM New Member

      Is there an known bug that where we having difficulties in running a fetching data thru workflow manager from DB2..I can preview data using ODBC {Source Analyzer - DataDirect 7.1 DB2 Wire Protocol} but when i run as a task thru WM i am having an error..

       

      any help is appreciated?

       

      thx

        • 1. Re: Workflow Manager 9.6 | DB2 | ERROR
          Venkat CM New Member

          Error

           

          ############3

           

          Severity Timestamp Node Thread Message Code Message

          ERROR 1/10/2019 10:35:40 PM Node01_on000100 READER_1_1_1 RR_4035 SQL Error [

          [IBM][CLI Driver][AS] SQL0204N  "<Owner>.<TableName>" is an undefined name.  SQLSTATE=42704

          sqlstate = 42S02

           

           

          Database driver error...

          Function Name : Execute

          SQL Stmt : SELECT <TableName>DEPT, <TableName>.TDPT FROM <TableName>

          Native error code = -204

          DB2 Fatal Error].

          • 2. Re: Workflow Manager 9.6 | DB2 | ERROR
            Venkat CM New Member

            Severity Timestamp Node Thread Message Code Message

            ERROR 1/11/2019 9:40:26 AM Node01_on000100 READER_1_1_1 RR_4035 SQL Error [

            [IBM][CLI Driver][AS] SQL0204N  "INFORMATIC.AEORDEPT" is an undefined name.  SQLSTATE=42704

            sqlstate = 42S02

             

             

            Database driver error...

            Function Name : Execute

            SQL Stmt : SELECT AEORDEPT.DEPTSKU, AEORDEPT.DEPTDPT FROM AEORDEPT

            Native error code = -204

            DB2 Fatal Error].

            • 3. Re: Workflow Manager 9.6 | DB2 | ERROR
              Syed Aziz Active Member
              Cause

              This issue occurs because there is a double quotes missing at the SELECT query.

              There are some tables that have been created such as the follows in the DB2 database:

              CREATE TABLE "SCHEMANAME"."TABLENAME" (
                      "Column1" DOUBLE NOT NULL
                  )
                  DATA CAPTURE NONE
                  DISTRIBUTE BY HASH ("Column1")
                  COMPRESS NO;

              ALTER TABLE "SCHEMA"."TABLENAME" ADD CONSTRAINT "SQL170117221918360" PRIMARY KEY
                  ("Column1");

              Solution

               

              To resolve this issue, do the following:

               

              1. Get the Table DDL from the DDL database.
              2. If the table name contains double quotes in the DDL, then make the following adjustments in the SQL Override.
              3. In the SQL Override in the SQ transformation, add the following in the SQL.
                2017-05-05 01_15_34-.jpg
              More Information

               

              It can be observed that connecting to the DB2 database with the same SQL using DB2 client utility is not possible.

               


              db2 => select * from TABLENAME
              SQL0204N  "SCHEMANAME.TABLENAME" is an undefined name.  SQLSTATE=42704
              db2 =>
              db2 =>

              If the same SQL Query is adjusted with double quotes, it is possible to access the record.

              db2 => select * from "TABLENAME"
              Column1
              ------------------------
                +1.00000000000000E-006
                1 record(s) selected.
              • 4. Re: Workflow Manager 9.6 | DB2 | ERROR
                Nico Heinze Guru

                Venkat,

                 

                could you please check whether the relational connection you're using has some environment SQL like "SET SCHEMA = xxx"?

                Do those table exist in the default schema of the DB2 user which you use for the connection or in some other schema?

                 

                Regards,

                Nico