Yaniv Dary has uploaded a new change for review. Change subject: etl: fixed etl error when hosts are non-responsive ......................................................................
etl: fixed etl error when hosts are non-responsive Change-Id: Idf69b45204930acb22def0c8309c8ce6dc5a79d0 Bug-Url: https://bugzilla.redhat.com/1008370 Signed-off-by: Yaniv Dary <[email protected]> --- M data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/sampletimekeepingjob_3_3/SampleTimeKeepingJob.java M data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.item M data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.properties M data-warehouse/history_etl/tos_project/talend.project 4 files changed, 139 insertions(+), 85 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/57/20157/1 diff --git a/data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/sampletimekeepingjob_3_3/SampleTimeKeepingJob.java b/data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/sampletimekeepingjob_3_3/SampleTimeKeepingJob.java index ce9788f..2b66d47 100644 --- a/data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/sampletimekeepingjob_3_3/SampleTimeKeepingJob.java +++ b/data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/sampletimekeepingjob_3_3/SampleTimeKeepingJob.java @@ -2318,7 +2318,7 @@ java.sql.Statement stmt_tJDBCInput_5 = conn_tJDBCInput_5 .createStatement(); - String dbquery_tJDBCInput_5 = "SELECT 'lastStatisticsUpdate', coalesce(max(_update_date), now()) FROM vds_statistics"; + String dbquery_tJDBCInput_5 = "SELECT 'lastStatisticsUpdate', var_datetime FROM dwh_history_timekeeping WHERE var_name = 'heartBeat'"; globalMap.put("tJDBCInput_5_QUERY", dbquery_tJDBCInput_5); @@ -9140,6 +9140,6 @@ ResumeUtil resumeUtil = null; } /************************************************************************************************ - * 255375 characters generated by Talend Open Studio for Data Integration on the - * June 23, 2013 12:08:10 PM IDT + * 255392 characters generated by Talend Open Studio for Data Integration on the + * October 14, 2013 1:39:14 PM IDT ************************************************************************************************/ diff --git a/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.item b/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.item index e56fd75..94de983 100644 --- a/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.item +++ b/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.item @@ -30,6 +30,8 @@ <elementParameter field="TEXT" name="OEM_CUSTOM_ATTRIBUTE" value=""/> <elementParameter field="TEXT" name="HADOOP_APP_PATH" value=""/> <elementParameter field="TEXT" name="JOBID_FOR_OOZIE" value=""/> + <elementParameter field="TEXT" name="REPOSITORY_CONNECTION_ID" value=""/> + <elementParameter field="TABLE" name="HADOOP_ADVANCED_PROPERTIES"/> <elementParameter field="CHECK" name="IMPLICITCONTEXT_USE_PROJECT_SETTINGS" value="true"/> <elementParameter field="CHECK" name="STATANDLOG_USE_PROJECT_SETTINGS" value="true"/> <elementParameter field="CHECK" name="MULTI_THREAD_EXECATION" value="true"/> @@ -68,6 +70,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""sample_ovirt_engine_history""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="sample_ovirt_engine_history"/> @@ -89,6 +94,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""engine""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="false"/> <elementParameter field="TEXT" name="LABEL" value="engine"/> @@ -161,6 +169,7 @@ </node> <node componentName="tJDBCInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="384" posY="0"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_2"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_2"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -174,6 +183,9 @@ <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/> <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value=""""/> <elementParameter field="MEMO_SQL" name="QUERY" value=""select distinct 'runTime', CURRENT_TIMESTAMP(6)""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_CURSOR" value="false"/> @@ -191,8 +203,8 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCInput_2"> - <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tMap" componentVersion="2.1" offsetLabelX="0" offsetLabelY="0" posX="384" posY="96"> @@ -209,12 +221,12 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="setRunTime"> - <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="" type="id_Date"/> + <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="" type="id_Date" usefulColumn="true"/> </metadata> <metadata connector="FLOW" name="update_lastSampling"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date" usefulColumn="true"/> </metadata> <nodeData xsi:type="MapperData"> <uiProperties/> @@ -235,6 +247,7 @@ </node> <node componentName="tContextLoad" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="384" posY="192"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tContextLoad_2"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CLOSED_LIST" name="LOAD_NEW_VARIABLE" value="Warning"/> <elementParameter field="CLOSED_LIST" name="NOT_LOAD_OLD_VARIABLE" value="Warning"/> <elementParameter field="CHECK" name="PRINT_OPERATIONS" value="false"/> @@ -247,12 +260,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tContextLoad_2"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tJDBCOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="224" posY="96"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCOutput_5"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -264,6 +278,9 @@ <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="INSERT_OR_UPDATE"/> <elementParameter field="CHECK" name="CLEAR_TABLE" value="false"/> <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/> @@ -289,14 +306,14 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCOutput_5"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date" usefulColumn="true"/> </metadata> <metadata connector="REJECT" name="REJECT"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date"/> - <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""dd-MM-yyyy"" sourceType="" type="id_Date" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tChronometerStop" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-576" posY="640"> @@ -354,6 +371,9 @@ <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_SHARED_CONNECTION" value="true"/> <elementParameter field="TEXT" name="SHARED_CONNECTION_NAME" value=""engine-events""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="CHECK" name="IS_USE_AUTO_COMMIT" value="true"/> <elementParameter field="CHECK" name="AUTO_COMMIT" value="true"/> <elementParameter field="TEXT" name="LABEL" value="engine-events"/> @@ -364,6 +384,7 @@ </node> <node componentName="tJDBCInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-448" posY="0"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_3"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -377,6 +398,9 @@ <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/> <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value=""""/> <elementParameter field="MEMO_SQL" name="QUERY" value=""SELECT var_name, var_datetime
 FROM dwh_history_timekeeping
 WHERE var_name = 'lastErrorSent' OR
 var_name = 'lastSampling'""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_CURSOR" value="false"/> @@ -394,12 +418,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCInput_3"> - <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tContextLoad" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="-448" posY="96"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tContextLoad_3"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CLOSED_LIST" name="LOAD_NEW_VARIABLE" value="Warning"/> <elementParameter field="CLOSED_LIST" name="NOT_LOAD_OLD_VARIABLE" value="Warning"/> <elementParameter field="CHECK" name="PRINT_OPERATIONS" value="false"/> @@ -412,13 +437,14 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tContextLoad_3"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tLogCatcher" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="-704" posY="320"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tLogCatcher_1"/> <elementParameter field="CHECK" name="START" value="true"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="CATCH_JAVA_EXCEPTION" value="true"/> <elementParameter field="CHECK" name="CATCH_TDIE" value="true"/> <elementParameter field="CHECK" name="CATCH_TWARN" value="true"/> @@ -427,18 +453,18 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tLogCatcher_1"> - <column key="false" length="0" name="moment" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss"" precision="0" sourceType="" type="id_Date"/> - <column key="false" length="20" name="pid" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="20" name="root_pid" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="20" name="father_pid" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="50" name="project" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="255" name="job" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="50" name="context" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="3" name="priority" nullable="true" precision="0" sourceType="" type="id_Integer"/> - <column key="false" length="255" name="type" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="255" name="origin" nullable="true" precision="0" sourceType="" type="id_String"/> - <column key="false" length="255" name="message" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="3" name="code" nullable="true" precision="0" sourceType="" type="id_Integer"/> + <column key="false" length="0" name="moment" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss"" precision="0" sourceType="" type="id_Date" usefulColumn="true"/> + <column key="false" length="20" name="pid" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="20" name="root_pid" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="20" name="father_pid" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="50" name="project" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="255" name="job" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="50" name="context" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="3" name="priority" nullable="true" precision="0" sourceType="" type="id_Integer" usefulColumn="true"/> + <column key="false" length="255" name="type" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="255" name="origin" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column key="false" length="255" name="message" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="3" name="code" nullable="true" precision="0" sourceType="" type="id_Integer" usefulColumn="true"/> </metadata> </node> <node componentName="tMap" componentVersion="2.1" offsetLabelX="0" offsetLabelY="0" posX="-704" posY="416"> @@ -455,15 +481,15 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" label="audit_log" name="event_output"> - <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> - <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> + <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> + <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> </metadata> <metadata connector="FLOW" label="audit_log" name="update_lastErrorSent"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> </metadata> <nodeData xsi:type="MapperData"> <uiProperties/> @@ -497,6 +523,7 @@ </node> <node componentName="tJDBCOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-800" posY="544"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCOutput_1"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -508,6 +535,9 @@ <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="INSERT"/> <elementParameter field="CHECK" name="CLEAR_TABLE" value="false"/> <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/> @@ -549,24 +579,25 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" label="audit_log" name="tJDBCOutput_1"> - <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> - <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> + <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> + <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> </metadata> <metadata connector="REJECT" label="audit_log" name="REJECT"> - <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> - <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer"/> - <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String"/> + <column comment="" key="false" length="35" name="log_time" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> + <column comment="" defaultValue="::character varying" key="false" length="100" name="log_type_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="10" name="log_type" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="10" name="severity" nullable="false" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> + <column comment="" key="false" length="2147483647" name="message" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tJDBCOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-544" posY="512"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCOutput_2"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -578,6 +609,9 @@ <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="UPDATE_OR_INSERT"/> <elementParameter field="CHECK" name="CLEAR_TABLE" value="false"/> <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/> @@ -604,18 +638,19 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" label="audit_log" name="tJDBCOutput_2"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> </metadata> <metadata connector="REJECT" label="audit_log" name="REJECT"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String"/> - <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date"/> - <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_datetime" nullable="false" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tRowGenerator" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-160" posY="0"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRowGenerator_2"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="TEXT" name="NB_ROWS" value="1"/> <elementParameter field="TABLE" name="VALUES"> <elementValue elementRef="SCHEMA_COLUMN" value="var_name"/> @@ -629,12 +664,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tRowGenerator_2"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tJDBCOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-160" posY="96"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCOutput_3"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -646,6 +682,9 @@ <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="INSERT_OR_UPDATE"/> <elementParameter field="CHECK" name="CLEAR_TABLE" value="false"/> <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/> @@ -671,18 +710,19 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCOutput_3"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> </metadata> <metadata connector="REJECT" name="REJECT"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tJDBCInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-768" posY="0"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_4"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -696,6 +736,9 @@ <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/> <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value=""""/> <elementParameter field="MEMO_SQL" name="QUERY" value=""SELECT var_name, var_value
 FROM dwh_history_timekeeping
 WHERE var_name = 'timesFailed'""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_CURSOR" value="false"/> @@ -713,12 +756,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCInput_4"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="value" nullable="true" precision="0" sourceType="" type="id_String"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="value" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tContextLoad" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="-768" posY="96"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tContextLoad_4"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CLOSED_LIST" name="LOAD_NEW_VARIABLE" value="Warning"/> <elementParameter field="CLOSED_LIST" name="NOT_LOAD_OLD_VARIABLE" value="Warning"/> <elementParameter field="CHECK" name="PRINT_OPERATIONS" value="false"/> @@ -731,12 +775,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tContextLoad_4"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="value" nullable="true" precision="0" sourceType="" type="id_String"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="value" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tRowGenerator" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-352" posY="320"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tRowGenerator_3"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="TEXT" name="NB_ROWS" value="1"/> <elementParameter field="TABLE" name="VALUES"> <elementValue elementRef="SCHEMA_COLUMN" value="var_name"/> @@ -750,12 +795,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tRowGenerator_3"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tJDBCOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-256" posY="320"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCOutput_4"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -767,6 +813,9 @@ <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="UPDATE_OR_INSERT"/> <elementParameter field="CHECK" name="CLEAR_TABLE" value="false"/> <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/> @@ -792,14 +841,14 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCOutput_4"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> </metadata> <metadata connector="REJECT" name="REJECT"> - <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String"/> - <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String"/> + <column comment="" key="true" name="var_name" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="var_value" nullable="false" pattern="" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> </metadata> </node> <node componentName="tWarn" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="-320" posY="128"> @@ -815,6 +864,7 @@ </node> <node componentName="tJDBCInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="-608" posY="0"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tJDBCInput_5"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/> <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="true"/> <elementParameter field="COMPONENT_LIST" name="CONNECTION" value="tJDBCConnection_3"/> <elementParameter field="TEXT" name="URL" value=""jdbc:""/> @@ -827,7 +877,10 @@ <elementParameter field="TECHNICAL" name="QUERYSTORE:REPOSITORY_QUERYSTORE_TYPE" value=""/> <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/> <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value=""""/> - <elementParameter field="MEMO_SQL" name="QUERY" value=""SELECT 'lastStatisticsUpdate', coalesce(max(_update_date), now())
 FROM vds_statistics""/> + <elementParameter field="MEMO_SQL" name="QUERY" value=""SELECT 'lastStatisticsUpdate', var_datetime
 FROM dwh_history_timekeeping
 WHERE var_name = 'heartBeat'""/> + <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/> + <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/> + <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value=""""/> <elementParameter field="ENCODING_TYPE" name="ENCODING" value=""ISO-8859-15""/> <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/> <elementParameter field="CHECK" name="USE_CURSOR" value="false"/> @@ -845,12 +898,13 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tJDBCInput_5"> - <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column comment="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <node componentName="tContextLoad" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="-608" posY="96"> <elementParameter field="TEXT" name="UNIQUE_NAME" value="tContextLoad_5"/> + <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/> <elementParameter field="CLOSED_LIST" name="LOAD_NEW_VARIABLE" value="Warning"/> <elementParameter field="CLOSED_LIST" name="NOT_LOAD_OLD_VARIABLE" value="Warning"/> <elementParameter field="CHECK" name="PRINT_OPERATIONS" value="false"/> @@ -863,8 +917,8 @@ <elementParameter field="MEMO" name="COMMENT" value=""/> <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/> <metadata connector="FLOW" name="tContextLoad_5"> - <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String"/> - <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date"/> + <column defaultValue="" key="false" length="255" name="key" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/> + <column defaultValue="" key="false" length="35" name="value" nullable="true" pattern=""yyyy-MM-dd HH:mm:ss.SSSSSS"" precision="6" sourceType="DATETIME" type="id_Date" usefulColumn="true"/> </metadata> </node> <connection connectorName="COMPONENT_OK" label="OnComponentOk" lineStyle="3" metaname="tJDBCConnection_1" offsetLabelX="0" offsetLabelY="0" source="tJDBCConnection_1" target="tJDBCInput_2"> diff --git a/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.properties b/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.properties index 8024a0a..7cc9912 100644 --- a/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.properties +++ b/data-warehouse/history_etl/tos_project/process/SampleTimeKeepingJob_3.3.properties @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; xmlns:TalendProperties="http://www.talend.org/properties";> - <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_FvEy8LzqEeCaj-T1n0SCFw" label="SampleTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2013-06-23T12:05:52.648+0300" version="3.3" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="SampleTimeKeepingJob"> + <TalendProperties:Property xmi:id="_FvH2QLzqEeCaj-T1n0SCFw" id="_FvEy8LzqEeCaj-T1n0SCFw" label="SampleTimeKeepingJob" creationDate="2011-08-02T12:30:39.367+0300" modificationDate="2013-10-14T13:38:05.478+0300" version="3.3" statusCode="" item="_FvH2QrzqEeCaj-T1n0SCFw" displayName="SampleTimeKeepingJob"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_FvH2QbzqEeCaj-T1n0SCFw" path=""/> diff --git a/data-warehouse/history_etl/tos_project/talend.project b/data-warehouse/history_etl/tos_project/talend.project index 738b08f..48892d0 100644 --- a/data-warehouse/history_etl/tos_project/talend.project +++ b/data-warehouse/history_etl/tos_project/talend.project @@ -852,7 +852,7 @@ <migrationTask xmi:id="_G1Uu69vkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.ChangePigVersionOfPigLoadMigrationTask" breaks="5.3.0" version="5.3.0" status="ok"/> <migrationTask xmi:id="_G1VV4NvkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.ChangeHadoopVersionsOfReferenceComponentsMigrationTask" breaks="5.3.0" version="5.3.0" status="ok"/> <migrationTask xmi:id="_G1VV4dvkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.AutoUpdateRelationsMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> - <migrationTask xmi:id="_BgGgoTAlEeOuzJh2oQvweg" id="org.talend.repository.model.migration.UpdateExistentMigrationTasksToAdaptNewMigrationSystemMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> + <migrationTask xmi:id="_57PdITS7EeOTfd89-tMnqg" id="org.talend.repository.model.migration.UpdateExistentMigrationTasksToAdaptNewMigrationSystemMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> </TalendProperties:Project> <TalendProperties:User xmi:id="_SapC4EJlEeCWRqOtaF5m-w" login="[email protected]" password="D41D8CD98F00B204E9800998ECF8427E"/> <TalendProperties:User xmi:id="_9rn8MCu-EeGwyfNuL-eF9g" login="[email protected]" password="D41D8CD98F00B204E9800998ECF8427E"/> -- To view, visit http://gerrit.ovirt.org/20157 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Idf69b45204930acb22def0c8309c8ce6dc5a79d0 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
