org.pentaho.di.core.exception.KettleValueException: Unknown column 'LOG_FIELD'

Pentaho BI Platform Tracking | Jens Bleuel | 8 years ago
  1. 0

    I just got pentaho data-integration and installed it on my PC for evaluation purpose. After installation I started by creating the repository. I encountered no error during this process. I connected my self to the repository and started to create a simple transformation (copy of a table into another). For this I created two connections called "voxreflex" (source of the copy) and "dwh" (destination). Then I inserted two steps in this transformation (one for reading the source table, the other to load rows in the destination table). When I tried to run the transformation, I got the following errors : PDI encountered an error reading the shared objects file... Impossible to read databases from repository... Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - Recherche de la transformation [Chargement des comptes] dans le dossier [/] 2011/11/19 00:17:07 - repository - Chargement transformation [Chargement des comptes] depuis le référentiel... 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : PDI a rencontré une erreur durant la lecture du fichier de partage d'objets (poursuite du chargement) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible de lire les bases de données depuis le référentiel: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible de lire les bases de données depuis le référentiel: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readDatabases(KettleDatabaseRepositoryTransDelegate.java:760) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readTransSharedObjects(KettleDatabaseRepositoryTransDelegate.java:1198) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:386) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:245) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.<init>(Trans.java:333) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3327) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:912) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon$32$1.run(Spoon.java:7512) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.reflect.Method.invoke(Method.java:601) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.core.RowMetaAndData.getInteger(RowMetaAndData.java:152) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getDatabaseAttributes(KettleDatabaseRepositoryConnectionDelegate.java:1746) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDatabaseDelegate.loadDatabaseMeta(KettleDatabaseRepositoryDatabaseDelegate.java:131) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadDatabaseMeta(KettleDatabaseRepository.java:394) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readDatabases(KettleDatabaseRepositoryTransDelegate.java:739) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : ... 19 more 2011/11/19 00:17:07 - repository - Chargement de l'étape avec l'ID: 1 2011/11/19 00:17:07 - repository - Chargement de l'étape avec l'ID: 2 2011/11/19 00:17:07 - repository - ID_DIRECTORY=0 2011/11/19 00:17:08 - repository - La transformation [Chargement des comptes] a été chargée , répertoire == null : false 2011/11/19 00:17:08 - repository - Chargement de la transformation [Chargement des comptes] dans le répertoire / 2011/11/19 00:17:08 - Pentaho Data Integration - Transformation ouverte. 2011/11/19 00:17:08 - Pentaho Data Integration - Chargement transformation [Chargement des comptes]... 2011/11/19 00:17:08 - Pentaho Data Integration - Exécution de la transformation démarrée. 2011/11/19 00:17:08 - Chargement des comptes - Distribution démarrée pour la tranformation [Chargement des comptes] 2011/11/19 00:17:08 - Transformation metadata - Tri naturel des etapes execute en 0 ms (2) 2011/11/19 00:17:08 - Extraction depuis table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Vous devez spécifier une connexion à une base de données. 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreur lors de l'initialisation de l'étape [Insertion dans table] 2011/11/19 00:17:08 - Extraction depuis table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreur lors de l'initialisation de l'étape [Extraction depuis table] 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NullPointerException 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:548) 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:722) 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : L'initialisation de l'étape [Extraction depuis table.0] a échoué! 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : L'initialisation de l'étape [Insertion dans table.0] a échoué! 2011/11/19 00:17:08 - Extraction depuis table.0 - Finished reading query, closing connection. 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Chargement des comptes: preparing transformation execution failed 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible d'initialiser toutes les étapes. L'exécution ne peut démarrer! 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:792) 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3659) 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:722) 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreurs détectées! 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreurs détectées! I saved the transformation, closed the tool and restarted it. After reloading the transformation from repository, all the connections had vanished. They did not appeera anymore in the navigator nor in the steps themselves. I opened the repository explorer to check, but I got the following error when clicking on the connections tab: Error during initialization of te "security" tab: org.pentaho.di.core.exception.KettleValueException: Unknown column 'ID_DATABASE_ATTRIBUTE'. The connections tab was empty. When I tried to recreate the connection, I got an error message telling that the connectins already exist. I opened the r_database table in the repository and found all the connections. Hence they were correctly created, but Kettle is unable to retrieve them. I also found the 'ID_DATABASE_ATTRIBUTE' in the r_database_attribute table. I tried to recreate the repository by dropping its database and running the installation process again, but with no effect. The error remains. Thanks for your help.

    Pentaho BI Platform Tracking | 5 years ago | André Mornard
    org.pentaho.di.core.exception.KettleException: Impossible de lire les bases de données depuis le référentiel: Unknown column '`ID_DATABASE_ATTRIBUTE`'
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    I just got pentaho data-integration and installed it on my PC for evaluation purpose. After installation I started by creating the repository. I encountered no error during this process. I connected my self to the repository and started to create a simple transformation (copy of a table into another). For this I created two connections called "voxreflex" (source of the copy) and "dwh" (destination). Then I inserted two steps in this transformation (one for reading the source table, the other to load rows in the destination table). When I tried to run the transformation, I got the following errors : PDI encountered an error reading the shared objects file... Impossible to read databases from repository... Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - Recherche de la transformation [Chargement des comptes] dans le dossier [/] 2011/11/19 00:17:07 - repository - Chargement transformation [Chargement des comptes] depuis le référentiel... 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : PDI a rencontré une erreur durant la lecture du fichier de partage d'objets (poursuite du chargement) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible de lire les bases de données depuis le référentiel: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible de lire les bases de données depuis le référentiel: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readDatabases(KettleDatabaseRepositoryTransDelegate.java:760) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readTransSharedObjects(KettleDatabaseRepositoryTransDelegate.java:1198) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:386) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:245) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.<init>(Trans.java:333) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3327) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:912) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon$32$1.run(Spoon.java:7512) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.reflect.Method.invoke(Method.java:601) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unknown column '`ID_DATABASE_ATTRIBUTE`' 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.core.RowMetaAndData.getInteger(RowMetaAndData.java:152) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getDatabaseAttributes(KettleDatabaseRepositoryConnectionDelegate.java:1746) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDatabaseDelegate.loadDatabaseMeta(KettleDatabaseRepositoryDatabaseDelegate.java:131) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadDatabaseMeta(KettleDatabaseRepository.java:394) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.readDatabases(KettleDatabaseRepositoryTransDelegate.java:739) 2011/11/19 00:17:07 - repository - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : ... 19 more 2011/11/19 00:17:07 - repository - Chargement de l'étape avec l'ID: 1 2011/11/19 00:17:07 - repository - Chargement de l'étape avec l'ID: 2 2011/11/19 00:17:07 - repository - ID_DIRECTORY=0 2011/11/19 00:17:08 - repository - La transformation [Chargement des comptes] a été chargée , répertoire == null : false 2011/11/19 00:17:08 - repository - Chargement de la transformation [Chargement des comptes] dans le répertoire / 2011/11/19 00:17:08 - Pentaho Data Integration - Transformation ouverte. 2011/11/19 00:17:08 - Pentaho Data Integration - Chargement transformation [Chargement des comptes]... 2011/11/19 00:17:08 - Pentaho Data Integration - Exécution de la transformation démarrée. 2011/11/19 00:17:08 - Chargement des comptes - Distribution démarrée pour la tranformation [Chargement des comptes] 2011/11/19 00:17:08 - Transformation metadata - Tri naturel des etapes execute en 0 ms (2) 2011/11/19 00:17:08 - Extraction depuis table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Vous devez spécifier une connexion à une base de données. 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreur lors de l'initialisation de l'étape [Insertion dans table] 2011/11/19 00:17:08 - Extraction depuis table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreur lors de l'initialisation de l'étape [Extraction depuis table] 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NullPointerException 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:548) 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52) 2011/11/19 00:17:08 - Insertion dans table.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:722) 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : L'initialisation de l'étape [Extraction depuis table.0] a échoué! 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : L'initialisation de l'étape [Insertion dans table.0] a échoué! 2011/11/19 00:17:08 - Extraction depuis table.0 - Finished reading query, closing connection. 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Chargement des comptes: preparing transformation execution failed 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException: 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Impossible d'initialiser toutes les étapes. L'exécution ne peut démarrer! 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:792) 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3659) 2011/11/19 00:17:08 - Pentaho Data Integration - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Thread.java:722) 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreurs détectées! 2011/11/19 00:17:08 - Chargement des comptes - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Erreurs détectées! I saved the transformation, closed the tool and restarted it. After reloading the transformation from repository, all the connections had vanished. They did not appeera anymore in the navigator nor in the steps themselves. I opened the repository explorer to check, but I got the following error when clicking on the connections tab: Error during initialization of te "security" tab: org.pentaho.di.core.exception.KettleValueException: Unknown column 'ID_DATABASE_ATTRIBUTE'. The connections tab was empty. When I tried to recreate the connection, I got an error message telling that the connectins already exist. I opened the r_database table in the repository and found all the connections. Hence they were correctly created, but Kettle is unable to retrieve them. I also found the 'ID_DATABASE_ATTRIBUTE' in the r_database_attribute table. I tried to recreate the repository by dropping its database and running the installation process again, but with no effect. The error remains. Thanks for your help.

    Pentaho BI Platform Tracking | 5 years ago | André Mornard
    org.pentaho.di.core.exception.KettleException: Impossible de lire les bases de données depuis le référentiel: Unknown column '`ID_DATABASE_ATTRIBUTE`'
  4. 0

    [PDI-795] Unexpected conversion error while converting value - Pentaho BI Platform Tracking

    pentaho.com | 12 months ago
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [updated_time Date] to an Integer Unexpected conversion error while converting value [updated_time Date] to an Integer

    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.KettleValueException

      Unknown column 'LOG_FIELD'

      at org.pentaho.di.core.RowMetaAndData.getString()
    2. org.pentaho.di
      JobHistoryDelegate$3$1.run
      1. org.pentaho.di.core.RowMetaAndData.getString(RowMetaAndData.java:229)
      2. org.pentaho.di.ui.spoon.job.JobHistoryDelegate.showLogEntry(JobHistoryDelegate.java:519)
      3. org.pentaho.di.ui.spoon.job.JobHistoryDelegate.refreshHistory(JobHistoryDelegate.java:472)
      4. org.pentaho.di.ui.spoon.job.JobHistoryDelegate$3$1.run(JobHistoryDelegate.java:220)
      4 frames
    3. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
      2. org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
      3. org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
      4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      4 frames
    4. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1008)
      2. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6109)
      3. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:426)
      3 frames