Inserting data into the database 0 / - 2017/09/04 15:16:46.027 - 2017/09/04 15:16:46.027 additional_description '' USE ' ' AROUND THE TEXT! Text which will be filled in in the additional description column. database Name of the database host host for database password reason_change '' USE ' ' AROUND THE TEXT! Text which will be filled in in the additional description column. schema_name dump user_name Name of the user of the database ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID N START SPECIAL Y N N 0 0 60 12 0 1 1 N Y 0 64 192 Success SUCCESS N Y 0 1040 384 Inserting Monitoring objects TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_monitoring_object.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 224 192 Inserting observed property types TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_observed_property_types.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 624 192 Inserting observations TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_observation.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 832 192 Inserting sample TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_sample.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 1408 192 Inserting bio observations TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_bio_observation.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 832 384 Inserting sampling process TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_sampling_proces.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 1248 192 Inserting compartiment TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_compartiment.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 416 192 Inserting Observing capability TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_observing_capability.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 1040 192 Inserting Observing capability sample TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_observing_capability_sample.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 1408 384 Inserting Observing capability observation TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Input_database/Insert_observing_capability_observation.ktr N N N N N N N N Basic N N Y N N N Y N Y 0 1040 288 START Inserting Monitoring objects 0 0 Y Y Y Inserting observed property types Inserting observations 0 0 Y Y N Inserting observations Inserting bio observations 0 0 Y Y N Inserting bio observations Success 0 0 Y Y N Inserting sampling process Inserting sample 0 0 Y Y N Inserting sample Success 0 0 Y Y N Inserting Monitoring objects Inserting compartiment 0 0 Y Y N Inserting compartiment Inserting observed property types 0 0 Y Y N Inserting Observing capability observation Success 0 0 Y Y N Inserting sample Inserting Observing capability sample 0 0 Y Y N Inserting Observing capability sample Success 0 0 Y Y N Inserting observations Inserting Observing capability 0 0 Y Y N Inserting Observing capability Inserting sampling process 0 0 Y Y N Inserting Observing capability Inserting Observing capability observation 0 0 Y Y N Deze Job is afhankelijk van de database connectie en daarbij ook de tabellen/schema's 192 96 586 50 Segoe UI 9 N N 0 0 0 255 205 112 100 100 100 Y