org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM ingres.iso_country_dim] Client at level 65 is attempting to retrieve unsupported data type 'ansidate'

Pentaho BI Platform Tracking | Chris Deptula | 4 years ago
  1. 0

    If I use the Get Table Names step against a Vectorwise database and one of the tables has the Vectorwise datatype ansidate the Get Table Names step fails with the following error. Ansidate is a valid Vectorwise datatype and the Table Input and other steps work with it. {noformat} 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Couldn't get field info from [SELECT * FROM ingres.iso_country_dim] 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Client at level 65 is attempting to retrieve unsupported data type 'ansidate' 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2396) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2330) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getTableFields(Database.java:2000) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: com.ingres.gcf.util.SqlEx: Client at level 65 is attempting to retrieve unsupported data type 'ansidate' 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:768) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:624) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvPrep.<init>(DrvPrep.java:132) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvConn.getPrepStmt(DrvConn.java:788) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcPrep.<init>(JdbcPrep.java:363) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcConn.createPrep(JdbcConn.java:1591) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcConn.prepareStatement(JdbcConn.java:1421) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2377) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 6 more {noformat}

    Pentaho BI Platform Tracking | 4 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM ingres.iso_country_dim] Client at level 65 is attempting to retrieve unsupported data type 'ansidate'
  2. 0

    If I use the Get Table Names step against a Vectorwise database and one of the tables has the Vectorwise datatype ansidate the Get Table Names step fails with the following error. Ansidate is a valid Vectorwise datatype and the Table Input and other steps work with it. {noformat} 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Couldn't get field info from [SELECT * FROM ingres.iso_country_dim] 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Client at level 65 is attempting to retrieve unsupported data type 'ansidate' 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2396) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2330) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getTableFields(Database.java:2000) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: com.ingres.gcf.util.SqlEx: Client at level 65 is attempting to retrieve unsupported data type 'ansidate' 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:768) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:624) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvPrep.<init>(DrvPrep.java:132) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.DrvConn.getPrepStmt(DrvConn.java:788) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcPrep.<init>(JdbcPrep.java:363) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcConn.createPrep(JdbcConn.java:1591) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.ingres.gcf.jdbc.JdbcConn.prepareStatement(JdbcConn.java:1421) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2377) 2012/10/18 09:33:23 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 6 more {noformat}

    Pentaho BI Platform Tracking | 4 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM ingres.iso_country_dim] Client at level 65 is attempting to retrieve unsupported data type 'ansidate'
  3. 0

    testMultiTable(org.hibernate.test.legacy.MultiTableTest) testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest) ------------------------- 20:37:55,892 WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A 20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. 20:37:55,895 INFO DefaultLoadEventListener:160 - Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadEntity(Loader.java:1921) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036) at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at junit.framework.TestCase.runTest(TestCase.java:154) at org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125) at junit.framework.TestCase.runBare(TestCase.java:127) at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source) at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1832) at org.hibernate.loader.Loader.doQuery(Loader.java:719) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271) at org.hibernate.loader.Loader.loadEntity(Loader.java:1907) ... 30 more

    Hibernate JIRA | 7 years ago | Strong Liu
    org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    testMultiTable(org.hibernate.test.legacy.MultiTableTest) testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest) ------------------------- 20:37:55,892 WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A 20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. 20:37:55,895 INFO DefaultLoadEventListener:160 - Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadEntity(Loader.java:1921) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036) at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at junit.framework.TestCase.runTest(TestCase.java:154) at org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125) at junit.framework.TestCase.runBare(TestCase.java:127) at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source) at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1832) at org.hibernate.loader.Loader.doQuery(Loader.java:719) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271) at org.hibernate.loader.Loader.loadEntity(Loader.java:1907) ... 30 more

    Hibernate JIRA | 7 years ago | Strong Liu
    org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]
  6. 0

    CachedRowSetWriter bug ?

    Oracle Community | 10 years ago | 843859
    com.ingres.gcf.util.SqlEx: Request is not supported.

    Root Cause Analysis

    1. com.ingres.gcf.util.SqlEx

      Client at level 65 is attempting to retrieve unsupported data type 'ansidate'

      at com.ingres.gcf.jdbc.DrvObj.readError()
    2. com.ingres.gcf
      JdbcConn.prepareStatement
      1. com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:768)
      2. com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:624)
      3. com.ingres.gcf.jdbc.DrvPrep.<init>(DrvPrep.java:132)
      4. com.ingres.gcf.jdbc.DrvConn.getPrepStmt(DrvConn.java:788)
      5. com.ingres.gcf.jdbc.JdbcPrep.<init>(JdbcPrep.java:363)
      6. com.ingres.gcf.jdbc.JdbcConn.createPrep(JdbcConn.java:1591)
      7. com.ingres.gcf.jdbc.JdbcConn.prepareStatement(JdbcConn.java:1421)
      7 frames
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2377)
      2. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2330)
      3. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005)
      4. org.pentaho.di.core.database.Database.getTableFields(Database.java:2000)
      5. org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242)
      6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      6 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame