Hi friends,

Please help me to solve the below errors:

I successfully created database connection with tally but when i select the field "Get Sql select statements' in "Table input" it was displaying the below error:


Unable to retrieve database information because of an error

Unable to get list of procedures from database meta-data:

Unable to get list of rows from ResultSet :

Error determining value metadata from SQL resultset metadata
General error


So i want to know the problem is what so i selected the component "Get table names" when i click on preview it was displaying the below error:

2014/12/17 11:31:01 - General - Logging plugin type found with ID: CheckpointLogTable
2014/12/17 11:31:08 - General - Starting agile-bi
2014/12/17 11:31:09 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000
2014/12/17 11:31:09 - Version checker - OK
2014/12/17 11:41:30 - C:\Pentaho\design-tools\data-integration\projects\tally.ktr : tally - Dispatching started for transformation [C:\Pentaho\design-tools\data-integration\projects\tally.ktr : tally]
2014/12/17 11:41:30 - Tally - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Tally
2014/12/17 11:41:39 - Get table names.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected error
2014/12/17 11:41:39 - Get table names.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2014/12/17 11:41:39 - Get table names.0 - Couldn't get field info from [SELECT * FROM LedgerInterestExtractServer]
2014/12/17 11:41:39 - Get table names.0 -
2014/12/17 11:41:39 - Get table names.0 - [Tally][Tally ODBC Driver]No prepared stmt
2014/12/17 11:41:39 - Get table names.0 -
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2198)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2135)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.core.database.Database.getTableFields(Database.java:1808)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:244)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2014/12/17 11:41:39 - Get table names.0 - at java.lang.Thread.run(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - Caused by: java.sql.SQLException: [Tally][Tally ODBC Driver]No prepared stmt
2014/12/17 11:41:39 - Get table names.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source)
2014/12/17 11:41:39 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192)
2014/12/17 11:41:39 - Get table names.0 - ... 6 more
2014/12/17 11:41:39 - Get table names.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2014/12/17 11:41:39 - C:\Pentaho\design-tools\data-integration\projects\tally.ktr : tally - Transformation detected one or more steps with errors.
2014/12/17 11:41:39 - C:\Pentaho\design-tools\data-integration\projects\tally.ktr : tally - Transformation is killing the other steps!