org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"]

Pentaho BI Platform Tracking | Kurtis Cruzada | 1 year ago
  1. 0

    Here is the simple query created with the Query Designer which fails to execute. {code} SELECT "Kettle"."344DataService"."PRODUCTLINE", sum("Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code} {noformat} org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:183) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: Unable to execute query: at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:123) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) ... 3 more Caused by: java.sql.SQLException: Unable to get open query for SQL: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:127) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) ... 5 more Caused by: org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) ... 6 more {noformat} Removing "Kettle." from the column name in the SELECT, the query will run. {code} SELECT "344DataService"."PRODUCTLINE", sum("344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code}

    Pentaho BI Platform Tracking | 1 year ago | Kurtis Cruzada
    org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"]
  2. 0

    Here is the simple query created with the Query Designer which fails to execute. {code} SELECT "Kettle"."344DataService"."PRODUCTLINE", sum("Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code} {noformat} org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:183) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: Unable to execute query: at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:123) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) ... 3 more Caused by: java.sql.SQLException: Unable to get open query for SQL: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:127) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) ... 5 more Caused by: org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) ... 6 more {noformat} Removing "Kettle." from the column name in the SELECT, the query will run. {code} SELECT "344DataService"."PRODUCTLINE", sum("344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code}

    Pentaho BI Platform Tracking | 1 year ago | Kurtis Cruzada
    org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"]
  3. 0

    Issue is not regression. Steps to reproduce: 1) Create new "MS SQL Server" repository from the beginning and connect. Actual result: org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:160) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:191) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:180) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:269) at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:218) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleException: The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:219) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:146) ... 5 more Expected result: Able to connect to repository.

    Pentaho BI Platform Tracking | 2 years ago | Aliaksandr Bialkevich
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hi, I'm new to this forum and the product. I've installed mysql 5.5.37. I've installed Java Ive installed Kettle -Spoon General Availability Release - 5.0.1-stable I've copied JDBC driver(mysql-connector-java-5.1.30-bin.jar) into the lib directory. I've created a sql account, schema and Repository and set the bind-address to 0.0.0.0 The problem lies with when I try and connect to a repository. My very first time I've added a repository, I was able to do a "Dry run". During the Dry Run Execution, some of the scripts came back with errors. After the script, I tried to log in but I'm not able to. The User Name and Password I'm using is admin, admin and an Error comes up saying Repository login failed. Detailed error follows: __________________________________________________________________________ org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:165) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:194) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:180) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:249) at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:216) at java.lang.Thread.run(Thread.java:701) Caused by: org.pentaho.di.core.exception.KettleException: The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:217) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:145) ... 5 more ____________________________________________________________________________ When I try and use the Create or Upgrade button again, It comes back to "Confirm the password" - "Give the password of the admin user!". I've tried to use admin as the password, but no luck.

    Pentaho BI Platform Tracking | 3 years ago | Lunen
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version.
  6. 0

    created slave server, pointed to DI server shared it saved it ran transform on it, remotely status of transform in DI server is Stopped. got following exception: org.pentaho.di.core.exception.KettleException: org.pentaho.di.core.exception.KettleException: There was an error preparing the transformation for excution on the remote server: Initialisation of transformation failed: 2010/10/04 15:42:14 - Carte - Installing timer to purge stale objects after 240 minutes. 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:07 - test this - Dispatching started for transformation [test this] 2010/10/04 15:43:07 - test this - This transformation can be replayed with replay date: 2010/10/04 15:43:07 2010/10/04 15:43:07 - test this - ERROR (version 4.1.0-RC1, build 14049 from 2010-10-01 13.55.22 by buildguy) : Step [Table output.0] failed to initialize! We failed to initialize at least one step. Execution can not begin! There was an error preparing the transformation for excution on the remote server: Initialisation of transformation failed: 2010/10/04 15:42:14 - Carte - Installing timer to purge stale objects after 240 minutes. 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:07 - test this - Dispatching started for transformation [test this] 2010/10/04 15:43:07 - test this - This transformation can be replayed with replay date: 2010/10/04 15:43:07 2010/10/04 15:43:07 - test this - ERROR (version 4.1.0-RC1, build 14049 from 2010-10-01 13.55.22 by buildguy) : Step [Table output.0] failed to initialize! We failed to initialize at least one step. Execution can not begin! at org.pentaho.di.trans.Trans.sendToSlaveServer(Trans.java:3036) at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:919) at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:7204) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1157) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6658) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545) 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:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: org.pentaho.di.core.exception.KettleException: There was an error preparing the transformation for excution on the remote server: Initialisation of transformation failed: 2010/10/04 15:42:14 - Carte - Installing timer to purge stale objects after 240 minutes. 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:07 - test this - Dispatching started for transformation [test this] 2010/10/04 15:43:07 - test this - This transformation can be replayed with replay date: 2010/10/04 15:43:07 2010/10/04 15:43:07 - test this - ERROR (version 4.1.0-RC1, build 14049 from 2010-10-01 13.55.22 by buildguy) : Step [Table output.0] failed to initialize! We failed to initialize at least one step. Execution can not begin! at org.pentaho.di.trans.Trans.sendToSlaveServer(Trans.java:3019) ... 14 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    org.pentaho.di.core.exception.KettleException: There was an error preparing the transformation for excution on the remote server: Initialisation of transformation failed: 2010/10/04 15:42:14 - Carte - Installing timer to purge stale objects after 240 minutes. 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:07 - test this - Dispatching started for transformation [test this] 2010/10/04 15:43:07 - test this - This transformation can be replayed with replay date: 2010/10/04 15:43:07 2010/10/04 15:43:07 - test this - ERROR (version 4.1.0-RC1, build 14049 from 2010-10-01 13.55.22 by buildguy) : Step [Table output.0] failed to initialize! We failed to initialize at least one step. Execution can not begin! There was an error preparing the transformation for excution on the remote server: Initialisation of transformation failed: 2010/10/04 15:42:14 - Carte - Installing timer to purge stale objects after 240 minutes. 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:06 - RepositoriesMeta - Reading repositories XML file: C:\Users\rfellows\.kettle\repositories.xml 2010/10/04 15:43:07 - test this - Dispatching started for transformation [test this] 2010/10/04 15:43:07 - test this - This transformation can be replayed with replay date: 2010/10/04 15:43:07 2010/10/04 15:43:07 - test this - ERROR (version 4.1.0-RC1, build 14049 from 2010-10-01 13.55.22 by buildguy) : Step [Table output.0] failed to initialize! We failed to initialize at least one step. Execution can not begin!

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettleException

      No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"]

      at org.pentaho.di.cluster.HttpUtil.execMethod()
    2. org.pentaho.di
      ThinResultSet.<init>
      1. org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138)
      2. org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95)
      3. org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144)
      4. org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107)
      4 frames
    3. org.pentaho.reporting
      JdbcPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178)
      2. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139)
      3. org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95)
      3 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame
    5. org.pentaho.di
      ThinStatement.executeQuery
      1. org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:127)
      2. org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120)
      2 frames