<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Merci Stijn ! </div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Mvg</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Allen Kay</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Van:</b> Goedertier Stijn <stijn.goedertier@vlaanderen.be><br>
<b>Verzonden:</b> vrijdag 11 augustus 2023 9:34<br>
<b>Aan:</b> De Blende Christophe <christophe.deblende@vlaanderen.be>; Bylemans Sander <sander.bylemans@vlaanderen.be>; Schampheleer Willem <willem.schampheleer@vlaanderen.be><br>
<b>CC:</b> codebusters@list.omgevingvlaanderen.be <codebusters@list.omgevingvlaanderen.be><br>
<b>Onderwerp:</b> Re: NIFI Flow BSOS in oefen</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Aptos}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
font-size:10.0pt;
font-family:"Calibri",sans-serif}
span.x_E-mailStijl19
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 70.85pt 70.85pt 70.85pt}
div.x_WordSection1
{}
-->
</style>
<div lang="NL-BE" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt">Dag allen,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">NiFi heeft alles ingeladen in de “landing”. De flowfile is vastgelopen bij het uitvoeren van “b_bsos.sp_load_bronze”
</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> In <b>c_nifi.bulletin </b>
zie ik de error: <span style="color:red">ERROR: Found 7 "Start" rows</span></span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Mss omdat er 7 onverwerkte aanleveringen waren voor BSOS?</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Mss kunnen we landing leegmaken en een nieuwe ingest krijgen van BSOS?</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">mvg,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Stijn</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">NB: Willem is denk ik vandaag en maandag met verlof...</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt">SELECT object_id, platform, bulletin_id, bulletin_category, bulletin_group_id, bulletin_group_name, bulletin_group_path, bulletin_level, bulletin_message, bulletin_node_address, bulletin_node_id,
bulletin_source_id, bulletin_source_name, bulletin_source_type, bulletin_timestamp</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> FROM c_nifi.bulletin</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> WHERE bulletin_group_name LIKE '%bsos%'</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> AND bulletin_timestamp > '2023-08-09'::timestamp</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> ORDER BY bulletin_timestamp DESC</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> LIMIT 100</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt">PutSQL[id=0a60defc-29e8-3edd-910f-ee7c0a683af8] Failed to update database due to a failed batch update, Batch entry 0 CALL b_bsos.sp_load_bronze('a2842f72-40b4-4278-a687-4b48fd7b6aa5','{filename=a2842f72-40b4-4278-a687-4b48fd7b6aa5,
record.count=995}') was aborted: ERROR: Found 7 "Start" rows</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> Where: PL/pgSQL function b_bsos.sp_load_bronze(uuid,text) line 21 at RAISE Call getNextException to see other errors in the batch.. There were a total of 1 FlowFiles that failed, 0 that succeeded,
and 0 that were not execute and will be routed to retry; : java.sql.BatchUpdateException: Batch entry 0 CALL b_bsos.sp_load_bronze('a2842f72-40b4-4278-a687-4b48fd7b6aa5','{filename=a2842f72-40b4-4278-a687-4b48fd7b6aa5, record.count=995}') was aborted:
<span style="color:red">ERROR: Found 7 "Start" rows</span></span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> Where: PL/pgSQL function b_bsos.sp_load_bronze(uuid,text) line 21 at RAISE Call getNextException to see other errors in the batch.</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt">- Caused by: org.postgresql.util.PSQLException: ERROR: Found 7 "Start" rows</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> Where: PL/pgSQL function b_bsos.sp_load_bronze(uuid,text) line 21 at RAISE</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="font-size:11.0pt"> </span></p>
<div id="x_mail-editor-reference-message-container">
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="x_MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt; color:black">Van:
</span></b><span style="font-size:12.0pt; color:black">De Blende Christophe <christophe.deblende@vlaanderen.be><br>
<b>Datum: </b>vrijdag, 11 augustus 2023 om 08:08<br>
<b>Aan: </b>Bylemans Sander <sander.bylemans@vlaanderen.be>, Goedertier Stijn <stijn.goedertier@vlaanderen.be>, Schampheleer Willem <willem.schampheleer@vlaanderen.be><br>
<b>CC: </b>codebusters@list.omgevingvlaanderen.be <codebusters@list.omgevingvlaanderen.be><br>
<b>Onderwerp: </b>NIFI Flow BSOS in oefen</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black">Co's</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black">blijkbaar zou de BSOS NIFI flow in oefen vastgelopen zijn. Kan er iemand naar kijken om die terug in gang te zetten? Dit is de laatste test vooraleer we een prod
fix kunnen uitvoeren. </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black">Mvg</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Aptos",sans-serif; color:black">Christophe</span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>