org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Unknown thread id: 88280

pentaho.com | 2 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    MySql Communications link failure [SOLVED]

    pentaho.com | 2 months ago
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Unknown thread id: 88280
  2. 0

    I am getting exception on step "Symmetric Cryptography" in PDI 4.2.0 stable release. I am using Decrypt operation with DES algorithm. Following is stack trace from linux server (works fine on windows). Following is exception: ERROR 12-07 01:15:14,927 - Staging - password - Error ERROR 12-07 01:15:14,927 - WebService - password - Error ERROR 12-07 01:15:14,928 - Staging - password - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.findSymmetricCryptoInterface(SymmetricCryptoMeta.java:82) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.getSymmetricCryptoInterface(SymmetricCryptoMeta.java:67) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.<init>(SymmetricCryptoMeta.java:53) at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.init(SymmetricCryptoTrans.java:212) at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) at java.lang.Thread.run(Unknown Source) ERROR 12-07 01:15:14,928 - WebService - password - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.findSymmetricCryptoInterface(SymmetricCryptoMeta.java:82) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.getSymmetricCryptoInterface(SymmetricCryptoMeta.java:67) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.<init>(SymmetricCryptoMeta.java:53) at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.init(SymmetricCryptoTrans.java:212) at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) at java.lang.Thread.run(Unknown Source) ERROR 12-07 01:15:14,928 - Staging - password - Error initializing step [Staging - password] ERROR 12-07 01:15:14,928 - WebService - password - Error initializing step [WebService - password] ERROR 12-07 01:15:15,200 - set_config_variables - Step [Staging - password.0] failed to initialize! ERROR 12-07 01:15:15,201 - set_config_variables - Step [WebService - password.0] failed to initialize! ERROR 12-07 01:15:15,202 - Set - Configuration Variables - Unable to open transformation: null ERROR 12-07 01:15:15,202 - Set - Configuration Variables - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.dispose(SymmetricCryptoTrans.java:248) at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:766) at org.pentaho.di.trans.Trans.execute(Trans.java:364) at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1024) at org.pentaho.di.job.Job.execute(Job.java:503) at org.pentaho.di.job.Job.execute(Job.java:642) at org.pentaho.di.job.Job.execute(Job.java:642) at org.pentaho.di.job.Job.execute(Job.java:420) at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:63) at java.lang.Thread.run(Unknown Source) The error does not appear all times, it is random and works fine on executing ETL again. This is the first step for ETL. Is it a bug or something not correctly done?

    Pentaho BI Platform Tracking | 5 years ago | faryal ali
    java.lang.NullPointerException
  3. 0

    I am getting exception on step "Symmetric Cryptography" in PDI 4.2.0 stable release. I am using Decrypt operation with DES algorithm. Following is stack trace from linux server (works fine on windows). Following is exception: ERROR 12-07 01:15:14,927 - Staging - password - Error ERROR 12-07 01:15:14,927 - WebService - password - Error ERROR 12-07 01:15:14,928 - Staging - password - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.findSymmetricCryptoInterface(SymmetricCryptoMeta.java:82) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.getSymmetricCryptoInterface(SymmetricCryptoMeta.java:67) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.<init>(SymmetricCryptoMeta.java:53) at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.init(SymmetricCryptoTrans.java:212) at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) at java.lang.Thread.run(Unknown Source) ERROR 12-07 01:15:14,928 - WebService - password - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.findSymmetricCryptoInterface(SymmetricCryptoMeta.java:82) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.getSymmetricCryptoInterface(SymmetricCryptoMeta.java:67) at org.pentaho.di.trans.steps.symmetriccrypto.symmetricalgorithm.SymmetricCryptoMeta.<init>(SymmetricCryptoMeta.java:53) at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.init(SymmetricCryptoTrans.java:212) at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) at java.lang.Thread.run(Unknown Source) ERROR 12-07 01:15:14,928 - Staging - password - Error initializing step [Staging - password] ERROR 12-07 01:15:14,928 - WebService - password - Error initializing step [WebService - password] ERROR 12-07 01:15:15,200 - set_config_variables - Step [Staging - password.0] failed to initialize! ERROR 12-07 01:15:15,201 - set_config_variables - Step [WebService - password.0] failed to initialize! ERROR 12-07 01:15:15,202 - Set - Configuration Variables - Unable to open transformation: null ERROR 12-07 01:15:15,202 - Set - Configuration Variables - java.lang.NullPointerException at org.pentaho.di.trans.steps.symmetriccrypto.symmetriccryptotrans.SymmetricCryptoTrans.dispose(SymmetricCryptoTrans.java:248) at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:766) at org.pentaho.di.trans.Trans.execute(Trans.java:364) at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1024) at org.pentaho.di.job.Job.execute(Job.java:503) at org.pentaho.di.job.Job.execute(Job.java:642) at org.pentaho.di.job.Job.execute(Job.java:642) at org.pentaho.di.job.Job.execute(Job.java:420) at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:63) at java.lang.Thread.run(Unknown Source) The error does not appear all times, it is random and works fine on executing ETL again. This is the first step for ETL. Is it a bug or something not correctly done?

    Pentaho BI Platform Tracking | 5 years ago | faryal ali
    java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I am using a Mapping (sub-transformation) step in my transformation that has the option "Use a file for the mapping transformation" option selected. That file then points to ///${INSTALL_DIR}/mappings/${ENVIRONMENT}/${TABLENAME}.ktr I have tested the variables are all set and it even shows the correct location when I hover over the location in PDI. However when I run the transformation i get the following: Code: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to load the mapping transformation because of an error : java.lang.NullPointerException 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : java.lang.NullPointerException 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.MappingMeta.loadMappingMeta(MappingMeta.java:638) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:491) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error initializing step [Mapping (sub-transformation)] 2012/08/13 15:47:11 - CURRENCY - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Step [Mapping (sub-transformation).0] failed to initialize! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to load the mapping transformation because of an error : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare (allocate, initialize) the execution of the mapping (sub-transformation) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:284) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.init(Mapping.java:499) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:62) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:823) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.mapping.Mapping.prepareMappingExecution(Mapping.java:282) 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 3 more 2012/08/13 15:47:11 - Mapping (sub-transformation).0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error initializing step [Mapping (sub-transformation)] 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Step [Mapping (sub-transformation).0] failed to initialize! 2012/08/13 15:47:11 - Get all rows to process.0 - Finished reading query, closing connection. 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to prepare for execution of the transformation 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException: 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : We failed to initialize at least one step. Execution can not begin! 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:823) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.Trans.execute(Trans.java:395) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1034) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:528) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:667) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.Job.execute(Job.java:445) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:68) 2012/08/13 15:47:11 - MX - Get Each Row - ORACLE - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) I have since tried to directly reference the file rather than use variables and I get the exact same error. I have also right clicked the step and clicked "Open Mapping (sub-transformation) and it opens successfully from the file directory. Am I allowed to use a transformation outside of the repository with this step? I am given the option to select it fine but then it fails with a null pointer exception. It works no problem within the repository but when pulled out into the file system it causes issues. Our reason for pulling these files out is to allow users without connectivity to the repository to edit these files. We do not want them to have access to the repository.

    Pentaho BI Platform Tracking | 5 years ago | Bill Wallace
    org.pentaho.di.core.exception.KettleException: We failed to initialize at least one step. Execution can not begin!
  6. 0

    Pentaho Spoon OK, Pentaho Kitchen ERROR

    Stack Overflow | 7 months ago | Isabelle
    org.pentaho.di.core.exception.KettleDatabaseException: Unable to get database metadata from this database connection at org.pentaho.di.job.Job.run (Job.java:424) at org.pentaho.di.job.Job.execute (Job.java:532) at org.pentaho.di.job.Job.execute (Job.java:859) at org.pentaho.di.job.Job.execute (Job.java:859) at org.pentaho.di.job.Job.execute (Job.java:859) at org.pentaho.di.job.Job.execute (Job.java:859) at org.pentaho.di.job.Job.execute (Job.java:716) at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:1065) at org.pentaho.di.trans.Trans.execute (Trans.java:607) at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1120) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:610) at org.pentaho.di.core.database.Database.rollback (Database.java:845) at org.pentaho.di.core.database.Database.rollback (Database.java:853) at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2758)

    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. java.sql.SQLException

      Unknown thread id: 88280

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      StatementImpl.cancel
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
      3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
      4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      8. com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
      9. com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:601)
      10. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
      11. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
      12. com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:421)
      12 frames
    3. org.pentaho.di
      JobEntryJobRunner.run
      1. org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
      2. org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
      3. org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293)
      4. org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
      5. org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1036)
      6. org.pentaho.di.job.Job.execute(Job.java:503)
      7. org.pentaho.di.job.Job.execute(Job.java:642)
      8. org.pentaho.di.job.Job.execute(Job.java:642)
      9. org.pentaho.di.job.Job.execute(Job.java:642)
      10. org.pentaho.di.job.Job.execute(Job.java:420)
      11. org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:63)
      11 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:636)
      1 frame