1) with no variable inscript SQL ===> OK
LOG from execution SQL : SELECT * FROM admapex03.D_FOYER
******************************************************************
2006/11/14 09:11:23 - Foyer - La Transformation est en mode prévisualisation...
2006/11/14 09:11:23 - Foyer - Distribution démarrée pour la tranformation [Foyer]
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
2006/11/14
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:23
09:11:24
09:11:24
09:11:24
09:11:24
09:11:24
09:11:31
-
Foyer - Nombre darguments détectés:{0}
Foyer - Ce n'est pas une transformationThis is not a replay transformation
Foyer - Cette transformation ne peut être ré-éxécutée avec la date de ré-éxécution: 2006/11/14 09:11:23
Foyer - Initialisation de 4 étape(s)...
Fichier PORTEUR.0 - Opening output stream in default encoding
Récupération PSTE.0 - Starting to run...
Récupération POWNER.0 - Starting to run...
Fichier PORTEUR.0 - Starting to run...
Récupération POWNER.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0
D_FOYER.0 - Starting to run...
Récupération PSTE.0 - Finished processing (I=0, O=0, R=150, W=149, U=0, E=0
D_FOYER.0 - Finished reading query, closing connection.
Fichier PORTEUR.0 - Finished processing (I=0, O=35, R=34, W=0, U=0, E=0
D_FOYER.0 - Finished processing (I=171, O=0, R=0, W=169, U=0, E=0
Spoon - Etapes: D_FOYER --> 100 lignes
Spoon - La transformation s'est achevée!!
2) with variable in script SQL ==> NOK
LOG from execution SQL : SELECT * FROM ${OWNER}.D_FOYER
******************************************************************
2006/11/14 09:04:05 - Foyer - La Transformation est en mode prévisualisation...
2006/11/14 09:04:05 - Foyer - Distribution démarrée pour la tranformation [Foyer]
2006/11/14 09:04:05 - Foyer - Nombre darguments détectés:{0}
2006/11/14 09:04:05 - Foyer - Ce n'est pas une transformationThis is not a replay transformation
2006/11/14 09:04:05 - Foyer - Cette transformation ne peut être ré-éxécutée avec la date de ré-éxécution: 2006/11/14 09:04:05
2006/11/14 09:04:05 - Foyer - Initialisation de 4 étape(s)...
2006/11/14 09:04:05 - Fichier PORTEUR.0 - Opening output stream in default encoding
2006/11/14 09:04:05 - Récupération PSTE.0 - Starting to run...
2006/11/14 09:04:05 - Récupération POWNER.0 - Starting to run...
2006/11/14 09:04:05 - Récupération POWNER.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0
2006/11/14 09:04:05 - Fichier PORTEUR.0 - Starting to run...
2006/11/14 09:04:05 - D_FOYER.0 - Starting to run...
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : ERROR executing query:
be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : offending row : [POWNER=admapex03]
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Error setting value #1 [admapex03] on
prepared statement (String)
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : java.sql.SQLException: Index de colonne
non valide
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Index de colonne non valide
2006/11/14 09:04:05 - axdi_read - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : ERROR in part: P Set values
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Unexpected error :
be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : An error occurred executing SQL in part
[P Set values]:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : SELECT * FROM admapex03.D_FOYER
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : offending row : [POWNER=admapex03]
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Error setting value #1 [admapex03] on
prepared statement (String)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : java.sql.SQLException: Index de colonne
non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Index de colonne non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : An error occurred executing SQL in part
[P Set values]:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : SELECT * FROM admapex03.D_FOYER
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : offending row : [POWNER=admapex03]
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Error setting value #1 [admapex03] on
prepared statement (String)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : java.sql.SQLException: Index de colonne
non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Index de colonne non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) :
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.openQuery(Database.java:1900)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.openQuery(Database.java:1818)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.trans.step.tableinput.TableInput.doQuery(TableInput.java:180)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.trans.step.tableinput.TableInput.processRow(TableInput.java:106)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.trans.step.tableinput.TableInput.run(TableInput.java:272)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
prepared statement (String)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.setValues(Database.java:775)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.setValues(Database.java:529)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.openQuery(Database.java:1834)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
prepared statement (String)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.setValue(Database.java:749)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
be.ibridge.kettle.core.database.Database.setValues(Database.java:771)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
de colonne non valide
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @
oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4596)
null) :
null) :
at
null) :
at
null) :
at
null) :
at
null) :
at
null) : Caused by:
null) : offending row : [POWNER=admapex03]
null) :
null) : Error setting value #1 [admapex03] on
null) : java.sql.SQLException: Index de colonne
null)
null)
null)
null)
: Index de colonne non valide
:
:
: at
null) :
at
null) :
at
null) : ... 4 more
null) : Caused by:
null) : Error setting value #1 [admapex03] on
null) : java.sql.SQLException: Index de colonne
null) : Index de colonne non valide
null) :
null) : at
null) :
at
null) : ... 6 more
null) : Caused by: java.sql.SQLException: Index
null) :
at
null) :
at
null) :
at
null) :
at
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : at
oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4559)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : at
be.ibridge.kettle.core.database.Database.setValue(Database.java:626)
2006/11/14 09:04:05 - D_FOYER.0 - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : ... 7 more
2006/11/14 09:04:06 - D_FOYER.0 - Finished reading query, closing connection.
2006/11/14 09:04:06 - Foyer - ERROR (version 2.3.2-dev, build 89 from 2006/10/04 12:07:48 @ null) : Erreurs détectées!
2006/11/14 09:04:06 - D_FOYER.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1
2006/11/14 09:04:06 - Foyer - Recherche étape: Récupération PSTE
2006/11/14 09:04:06 - Récupération PSTE.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0
2006/11/14 09:04:06 - Fichier PORTEUR.0 - Finished processing (I=0, O=1, R=0, W=0, U=0, E=0
2006/11/14 09:04:06 - Foyer - Recherche étape: Fichier PORTEUR
2006/11/14 09:04:06 - Foyer - Recherche étape: Récupération POWNER
2006/11/14 09:04:06 - Foyer - Recherche étape: D_FOYER
2006/11/14 09:04:06 - Spoon - Etapes: D_FOYER --> 0 lignes
2006/11/14 09:04:08 - Spoon - La transformation s'est achevée!!
