Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3088

Exception with unclear message

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7
    • Misc. Connectors
    • None
    • Hide

      How reproducible:
      Source databse - Ingres
      VDB view model - BQT2
      tables: smallb -
      `INTKEY` integer primary key,
      `STRINGKEY` varchar(10),
      `INTNUM` integer,
      `STRINGNUM` varchar(10),
      `FLOATNUM` real,
      `LONGNUM` bigint,
      `DOUBLENUM` double,
      `BYTENUM` tinyint,
      `DATEVALUE` date,
      `TIMEVALUE` time,
      `TIMESTAMPVALUE` timestamp,
      `BOOLEANVALUE` boolean,
      `CHARVALUE` character(1),
      `SHORTVALUE` smallint,
      `BIGINTEGERVALUE` bigint,
      `BIGDECIMALVALUE` decimal(10,0),
      `OBJECTVALUE` byte

      SQL query - SELECT intkey FROM BQT1.SmallA AS A WHERE stringkey = (SELECT stringkey FROM BQT1.SmallA AS B WHERE b.intnum = a.intnum ) ORDER BY intkey

      Show
      How reproducible: Source databse - Ingres VDB view model - BQT2 tables: smallb - `INTKEY` integer primary key, `STRINGKEY` varchar(10), `INTNUM` integer, `STRINGNUM` varchar(10), `FLOATNUM` real, `LONGNUM` bigint, `DOUBLENUM` double, `BYTENUM` tinyint, `DATEVALUE` date, `TIMEVALUE` time, `TIMESTAMPVALUE` timestamp, `BOOLEANVALUE` boolean, `CHARVALUE` character(1), `SHORTVALUE` smallint, `BIGINTEGERVALUE` bigint, `BIGDECIMALVALUE` decimal(10,0), `OBJECTVALUE` byte SQL query - SELECT intkey FROM BQT1.SmallA AS A WHERE stringkey = (SELECT stringkey FROM BQT1.SmallA AS B WHERE b.intnum = a.intnum ) ORDER BY intkey

      Description of problem:
      Unexpected exception. Returned exception indicates that query failed but there is no reason in message.

      Actual results:
      TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4502 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.stringkey = (SELECT g_1.stringkey FROM smalla AS g_1 WHERE g_1.intnum = g_0.intnum) ORDER BY c_0]

      Additional info:
      server log and exception stack trace in attachment

        1. exception-stack-trace
          6 kB
        2. full-server.log
          2.52 MB
        3. server.log
          16 kB

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: