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

Exception with unclear message

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 8.7
    • Misc. Connectors
    • None

    • OS: Fedora 20
      architecture: x86_64

    • 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 ShortValue, ABS(ShortValue) AS ABSShortValue FROM BQT2.SmallB ORDER BY ShortValue

      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 ShortValue, ABS(ShortValue) AS ABSShortValue FROM BQT2.SmallB ORDER BY ShortValue

      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: 4200 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_0.shortvalue AS smallint) AS c_0, abs(cast(g_0.shortvalue AS smallint)) AS c_1 FROM smallb AS g_0 ORDER BY c_0]

      Expected results:
      Remote java.sql.SQLException: Specified cursor is not known to the server.

      Additional info:
      server log and exception stack trace in attachment

        1. exception-stack-trace
          6 kB
          Juraj Duráni
        2. full-server.log
          2.52 MB
          Juraj Duráni
        3. server.log
          19 kB
          Juraj Duráni

              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: