ecrin-github / MDR_Aggregator

MIT License
1 stars 0 forks source link

[1 September] Phase 1: ***ERROR*** In ExecuteSQL; Exception while reading from stream, SQL was: Insert into ad.study_iec_null (source_id, sd_sid, seq_num, iec_type_id, split_type, leader, indent_level, sequence_string, iec_text ) #13

Open michelescarlato opened 1 month ago

michelescarlato commented 1 month ago
01/09/2024 : 07:03 :   ----------------------------------------------------------------------
01/09/2024 : 07:03 :   AGGREGATING CTG DATA
01/09/2024 : 07:03 :   ----------------------------------------------------------------------

+++++++++++++++++++++++++++++++++++++++
01/09/2024 : 07:03 :   ***ERROR*** In ExecuteSQL; Exception while reading from stream, 
SQL was:  Insert into ad.study_iec_null (source_id, sd_sid, seq_num, iec_type_id, split_type, leader, indent_level,
        sequence_string, iec_text )
                             select 100120, t.sd_sid, seq_num, iec_type_id, split_type, leader, indent_level,
        sequence_string, iec_text   
                             from ctg_ad.study_iec_null t 
                             inner join ctg_ad.studies s
                             on t.sd_sid = s.sd_sid 
+++++++++++++++++++++++++++++++++++++++

01/09/2024 : 07:03 :   Transferred 0 IEC records, from ctg_ad.study_iec_null to study_iec_null, as a single batch
01/09/2024 : 07:03 :   Transferred 99604 IEC records, from ctg_ad.study_iec_pre06 to study_iec_pre06, ids 1 to 100000
01/09/2024 : 07:03 :   Transferred 99502 IEC records, from ctg_ad.study_iec_pre06 to study_iec_pre06, ids 100001 to 200000
michelescarlato commented 1 month ago

logs loaded here