2009/08/04 08:31:12 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation ouverte. 2009/08/04 08:31:12 - Pentaho Data Integration - Chargement transformation [TeacherActive]... 2009/08/04 08:31:12 - Pentaho Data Integration - Exécution de la transformation démarrée. 2009/08/04 08:31:12 - TeacherActive - Distribution démarrée pour la tranformation [TeacherActive] 2009/08/04 08:31:12 - TeacherActive - Cette transformation ne peut être ré-éxécutée avec la date de ré-exécution: 2009/08/04 08:31:12 2009/08/04 08:31:12 - st_Teacher.0 - Connected to database [Integration] (commit=1000) 2009/08/04 08:31:13 - Teacher_pent.0 - Finished reading query, closing connection. 2009/08/04 08:31:13 - Teacher_pent.0 - Fin exécution étape (Entrées=3405, Sorties=0, Lues=0, Ecrites=3405, Maj=3405, Erreurs=0) 2009/08/04 08:31:13 - Select values.0 - Fin exécution étape (Entrées=0, Sorties=0, Lues=3405, Ecrites=3405, Maj=3405, Erreurs=0) 2009/08/04 08:31:13 - Add constants.0 - Fin exécution étape (Entrées=0, Sorties=0, Lues=3405, Ecrites=3405, Maj=3405, Erreurs=0) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Erreur inattendue : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : org.pentaho.di.core.exception.KettleDatabaseException: 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Error inserting 'unknown' row in dimension [dbo.DimTeacherActive_pent] : insert into dbo.DimTeacherActive_pent(version) values (1) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Couldn't execute SQL: insert into dbo.DimTeacherActive_pent(version) values (1) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Cannot insert the value NULL into column 'pk_Teacher', table 'LRDS_Distribution_fbs.dbo.DimTeacherActive_pent'; column does not allow nulls. INSERT fails. 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1190) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:176) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2677) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1271) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Couldn't execute SQL: insert into dbo.DimTeacherActive_pent(version) values (1) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Cannot insert the value NULL into column 'pk_Teacher', table 'LRDS_Distribution_fbs.dbo.DimTeacherActive_pent'; column does not allow nulls. INSERT fails. 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1557) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1503) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1186) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : ... 3 more 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : Caused by: java.sql.SQLException: Cannot insert the value NULL into column 'pk_Teacher', table 'LRDS_Distribution_fbs.dbo.DimTeacherActive_pent'; column does not allow nulls. INSERT fails. 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1526) 2009/08/04 08:31:13 - DimTeacher.0 - ERROR (version 3.1.2, build 10064 from 2009/01/26 14:16:40) : ... 5 more 2009/08/04 08:31:13 - DimTeacher.0 - Fin exécution étape (Entrées=0, Sorties=0, Lues=1, Ecrites=0, Maj=0, Erreurs=1) 2009/08/04 08:31:13 - TeacherActive - Transformation détectée 2009/08/04 08:31:13 - TeacherActive - Transformation est en train de tuer les autres étapes! 2009/08/04 08:31:13 - st_Teacher.0 - Fin exécution étape (Entrées=0, Sorties=2002, Lues=2002, Ecrites=1001, Maj=1001, Erreurs=0) 2009/08/04 08:31:13 - Pentaho Data Integration - L'exécution de la transformation a été achevée!