Data Integrity Checks

Ant_Snyman · 16 August 2015 06:41

Thanks Lars or your response.
Yes I did clear cache statistics as well as browser cache. How does the app=
lication determine orphaned organisationunits? Organisationunits without a =
parentid? Or a parentid that does not exist?
Regards
Ant
On 16 August 2015 at 07:20=2C Lars Helge =D8verland <larshelge@gmail.com> w=
rote:
Hi Ant=2C=20
after doing SQL against a running DHIS 2 instance you might want to go to d=
ata admin > cache statistics > clear cache. This since the cache might beco=
me stale unknowingly as a result of direct SQL queries.
regards=2C
Lars

Dear All=2C
DHIS2 vesrion 2.20 snapshot=2C build 19527
The data integrity checks showed some "orphaned" org units which should not=
have been on the system.=20
So I wrote scripts to clean out the org units and checked all 37 tables tha=
t either reference organisationunitid or sourceid and cleaned out all those=
tables. I also checked the "reporttable_organisationunits" table and it wa=
s not necessary to renumber as the org units were never in that table (I ch=
ecked before doing any deletes and by the way thanks Jason Pickering for th=
e script you shared with Ferdie).
After that I cleared analytics=2C re-generated resource tables=2C cleared c=
ache and cache statistics and re-ran integrity checks....those org unit uid=
s are still appearing as "orphaned organisation units".

From which table(s) is the integrity check picking these org units up from?=

=20
ThanksAnt Snyman
Cell: 0824910449Landline: 028 2713242
Health Information Systems Program - SA=0A=
=0A=
=0A=

=0A=
This message and any attachments are subject to a disclaimer published=0A=
at Home - HISP-SA. =0A=
Please read the disclaimer before opening any attachment or taking any othe=
r=0A=
action in terms of this electronic transmission. If you cannot access the=
=0A=
disclaimer=2C kindly send an email to disclaimer@hisp.org and a copy will b=
e provided to you. By=0A=
replying to this e-mail or opening any attachment you agree to be bound by =
the=0A=
provisions of the disclaimer.

···

On Sat=2C Aug 15=2C 2015 at 12:05 PM=2C Ant Snyman <ant@hisp.org> wrote:
_______________________________________________
=0A=
Mailing list: DHIS 2 Users in Launchpad
=0A=
Post to : dhis2-users@lists.launchpad.net
=0A=
Unsubscribe : DHIS 2 Users in Launchpad
=0A=
More help : ListHelp - Launchpad Help
=0A=

--=20
Lars Helge =D8verland
Lead developer=2C DHIS 2University of OsloSkype: larshelgeoverland

=0A=
=0A=

--=20

Ant SnymanCell: 0824910449Landline: 028 2713242
Health Information Systems Program - SA=0A=
=0A=
=0A=

=0A=
This message and any attachments are subject to a disclaimer published=0A=
at Home - HISP-SA. =0A=
Please read the disclaimer before opening any attachment or taking any othe=
r=0A=
action in terms of this electronic transmission. If you cannot access the=
=0A=
disclaimer=2C kindly send an email to disclaimer@hisp.org and a copy will b=
e provided to you. By=0A=
replying to this e-mail or opening any attachment you agree to be bound by =
the=0A=
provisions of the disclaimer.
_______________________________________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : ListHelp - Launchpad Help =

--_30ea01b7-c1a7-4ddd-8663-5b0917c695ff_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>Hello<br><br>Can you try=2C to d=
o the something on the another browser ???<br><br>AHIAGNO Aanyo<br><div>HIS=
P WA</div><div>0022890962285</div><br><br><div><hr id=3D"stopSpelling">Date=
: Sun=2C 16 Aug 2015 08:41:13 +0200<br>From: ant@hisp.org<br>To: larshelge@=
gmail.com<br>CC: dhis2-users@lists.launchpad.net=3B dhis2-devs@lists.launch=
pad.net<br>Subject: Re: [Dhis2-users] Data Integrity Checks<br><br><div dir=
=3D"ltr">Thanks Lars or your response.<div><br></div><div>Yes I did clear c=
ache statistics as well as browser cache. How does the application determin=
e orphaned organisationunits? Organisationunits without a parentid? Or a pa=
rentid that does not exist?</div><div><br></div><div>Regards</div><div><br>=
</div><div>Ant</div></div><div class=3D"ecxgmail_extra"><br><div class=3D"e=
cxgmail_quote">On 16 August 2015 at 07:20=2C Lars Helge =D8verland <span di=
r=3D"ltr">&lt=3B<a href=3D"mailto:larshelge@gmail.com" target=3D"_blank">la=
rshelge@gmail.com</a>&gt=3B</span> wrote:<br><blockquote class=3D"ecxgmail_=
quote" style=3D"border-left:1px #ccc solid=3Bpadding-left:1ex=3B"><div dir=
=3D"ltr">Hi Ant=2C&nbsp=3B<div><br></div><div>after doing SQL against a run=
ning DHIS 2 instance you might want to go to data admin &gt=3B cache statis=
tics &gt=3B clear cache. This since the cache might become stale unknowingl=
y as a result of direct SQL queries.</div><div><br></div><div>regards=2C</d=

<div><br></div><div>Lars</div><div><br></div></div><div class=3D"ecxgmai=

l_extra"><br><div class=3D"ecxgmail_quote">On Sat=2C Aug 15=2C 2015 at 12:0=
5 PM=2C Ant Snyman <span dir=3D"ltr">&lt=3B<a href=3D"mailto:ant@hisp.org" =
target=3D"_blank">ant@hisp.org</a>&gt=3B</span> wrote:<br><blockquote class=
=3D"ecxgmail_quote" style=3D"border-left:1px #ccc solid=3Bpadding-left:1ex=
=3B"><div dir=3D"ltr">Dear All=2C<div><br></div><div>DHIS2 vesrion 2.20 sna=
pshot=2C build&nbsp=3B<span style=3D"color:rgb(0=2C0=2C0)=3Bfont-family:Lib=
erationSans=2Carial=2Csans-serif=3Bfont-size:12px=3Bline-height:16.79999923=
70605px=3B">19527</span></div><div><font color=3D"#000000" face=3D"Liberati=
onSans=2C arial=2C sans-serif"><span style=3D"font-size:12px=3Bline-height:=
16.7999992370605px=3B"><br></span></font></div><div><font color=3D"#000000"=
face=3D"LiberationSans=2C arial=2C sans-serif"><span style=3D"font-size:12=
px=3Bline-height:16.7999992370605px=3B">The data integrity checks showed so=
me "orphaned" org units which should not have been on the system.&nbsp=3B</=

</font></div><div><font color=3D"#000000" face=3D"LiberationSans=2C ar=

ial=2C sans-serif"><span style=3D"font-size:12px=3Bline-height:16.799999237=
0605px=3B"><br></span></font></div><div><font color=3D"#000000" face=3D"Lib=
erationSans=2C arial=2C sans-serif"><span style=3D"font-size:12px=3Bline-he=
ight:16.7999992370605px=3B">So I wrote scripts to clean out the org units a=
nd checked all 37 tables that either reference organisationunitid or source=
id and cleaned out all those tables. I also checked the "reporttable_organi=
sationunits" table and it was not necessary to renumber as the org units we=
re never in that table (I checked before doing any deletes and by the way t=
hanks Jason Pickering for the script you shared with Ferdie).</span></font>=
</div><div><font color=3D"#000000" face=3D"LiberationSans=2C arial=2C sans-=
serif"><span style=3D"font-size:12px=3Bline-height:16.7999992370605px=3B"><=

</span></font></div><div><font color=3D"#000000" face=3D"LiberationSans=

=2C arial=2C sans-serif"><span style=3D"font-size:12px=3Bline-height:16.799=
9992370605px=3B">After that I cleared analytics=2C re-generated resource ta=
bles=2C cleared cache and cache statistics and re-ran integrity checks....t=
hose org unit uids are still appearing as "orphaned organisation units".</s=

</font></div><div><font color=3D"#000000" face=3D"LiberationSans=2C ari=

al=2C sans-serif"><span style=3D"font-size:12px=3Bline-height:16.7999992370=
605px=3B"><br></span></font></div><div><font color=3D"#000000" face=3D"Libe=
rationSans=2C arial=2C sans-serif"><span style=3D"font-size:12px=3Bline-hei=
ght:16.7999992370605px=3B">From which table(s) is the integrity check picki=
ng these org units up from?&nbsp=3B</span></font></div><div><font color=3D"=
#000000" face=3D"LiberationSans=2C arial=2C sans-serif"><span style=3D"font=
-size:12px=3Bline-height:16.7999992370605px=3B"><br></span></font></div><di=

<font color=3D"#000000" face=3D"LiberationSans=2C arial=2C sans-serif"><s=

pan style=3D"font-size:12px=3Bline-height:16.7999992370605px=3B">Thanks</sp=

</font></div><div><font color=3D"#000000" face=3D"LiberationSans=2C aria=

l=2C sans-serif"><span style=3D"font-size:12px=3Bline-height:16.79999923706=
05px=3B"><br clear=3D"all"></span></font><div><a name=3D"14f34f4266d14dc3_1=
4f30d25a7e0d794_UNIQUE_ID_SafeHtmlFilter_UNIQUE_ID_SafeHtmlFilter__MailAuto=
Sig" target=3D"_blank"><i>Ant Snyman</i></a><br></div><div><div dir=3D"ltr"=

<div dir=3D"ltr"><p style=3D"font-size:small=3B"><i>Cell: 0824910449</i></=
<p style=3D"font-size:small=3Bbackground-image:initial=3Bbackground-repea=

t:initial=3B"></p><p style=3D"font-size:small=3B"><i>Landline: 028 2713242<=
/i></p><p style=3D"font-size:small=3B"><br></p><p style=3D"font-size:12.800=
0001907349px=3B"><span style=3D"font-size:11pt=3Bfont-family:Calibri=2Csans=
-serif=3Bcolor:rgb(31=2C73=2C125)=3B"><img src=3D"cid:image002.png@01D0CAE3=
.9117AFE0" height=3D"76" width=3D"77"><u></u><u></u></span></p><p style=3D"=
font-size:12.8000001907349px=3B"><span style=3D"font-size:7pt=3Bfont-family=
:Calibri=2Csans-serif=3Bcolor:rgb(153=2C0=2C51)=3B">Health Information Syst=
ems Program - SA</span></p></div></div></div>=0A=
</div></div>=0A=
=0A=
<br>=0A=
<p style=3D""><i><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BAria=
l&quot=3B=2Csans-serif=3Bbackground:white=3B">This message and any attachme=
nts are subject to a disclaimer published=0A=
at <a href=3D"Home - HISP-SA; target=3D=
"_blank">Home - HISP-SA
Please read the disclaimer before opening any attachment or taking any othe=
r=0A=
action in terms of this electronic transmission.&nbsp=3B If you cannot acce=
ss the=0A=
disclaimer=2C kindly send an email to <a href=3D"mailto:disclaimer@hisp.org=
" target=3D"_blank">disclaimer@hisp.org</a> and a copy will be provided to =
you. By=0A=
replying to this e-mail or opening any attachment you agree to be bound by =
the=0A=
provisions of the disclaimer.</span></i></p><br>___________________________=
____________________<br>=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" rel=3D"norefer=
rer" target=3D"_blank">https://launchpad.net/~dhis2-users</a><br>=0A=
Post to&nbsp=3B &nbsp=3B &nbsp=3B: <a href=3D"mailto:dhis2-users@lists.laun=
chpad.net" target=3D"_blank">dhis2-users@lists.launchpad.net</a><br>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" rel=3D"norefer=
rer" target=3D"_blank">https://launchpad.net/~dhis2-users</a><br>=0A=
More help&nbsp=3B &nbsp=3B: <a href=3D"ListHelp - Launchpad Help"=
rel=3D"noreferrer" target=3D"_blank">https://help.launchpad.net/ListHelp</=

<br>=0A=

<br></blockquote></div><span class=3D"ecxHOEnZb"><font color=3D"#888888"><b=

<br clear=3D"all"><div><br></div>-- <br><div><div dir=3D"ltr"><div><div d=

ir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr=
"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"=
ltr"><div style=3D"font-size:12.8000001907349px=3B"><div style=3D"font-size=
:12.8000001907349px=3B"><font color=3D"#666666"><span style=3D"font-size:12=
.8000001907349px=3B">Lars Helge =D8verland</span><br></font></div><div styl=
e=3D"font-size:12.8000001907349px=3B"><font color=3D"#666666">Lead develope=
r=2C DHIS 2</font></div><div style=3D"font-size:12.8000001907349px=3B"><fon=
t color=3D"#666666">University of Oslo</font></div><div style=3D"font-size:=
12.8000001907349px=3B"><font color=3D"#666666"><span style=3D"font-size:12.=
8000001907349px=3B">Skype: larshelgeoverland</span><br></font></div><div st=
yle=3D"font-size:12.8000001907349px=3B"><span style=3D"font-size:12.8000001=
907349px=3B"><font color=3D"#666666"><a href=3D"https://www.dhis2.org" targ=
et=3D"_blank">http://www.dhis2.org</a></font></span></div><div style=3D"fon=
t-size:12.8000001907349px=3B"><span style=3D"color:rgb(102=2C102=2C102)=3Bf=
ont-size:12.8000001907349px=3B"><br></span></div></div></div></div></div></=

</div></div></div></div></div></div></div></div></div></div></div></div=
=0A=

</font></span></div>=0A=
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"ecxgmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><br><div><p =
style=3D"font-size:small=3B"><a name=3D"UNIQUE_ID_SafeHtmlFilter_UNIQUE_ID_=
SafeHtmlFilter__MailAutoSig" style=3D"color:rgb(17=2C85=2C204)=3B" target=
=3D"_blank"><i>Ant Snyman</i></a></p><p style=3D"font-size:small=3B"><i>Cel=
l: 0824910449</i></p><p style=3D"font-size:small=3Bbackground-image:initial=
=3Bbackground-repeat:initial=3B"></p><p style=3D"font-size:small=3B"><i>Lan=
dline: 028 2713242</i></p><p style=3D"font-size:small=3B"><br></p><p style=
=3D"font-size:12.8000001907349px=3B"><span style=3D"font-size:11pt=3Bfont-f=
amily:Calibri=2Csans-serif=3Bcolor:rgb(31=2C73=2C125)=3B"><img src=3D"cid:i=
mage002.png@01D0CAE3.9117AFE0" height=3D"76" width=3D"77"><u></u><u></u></s=

</p><p style=3D"font-size:12.8000001907349px=3B"><span style=3D"font-si=

ze:7pt=3Bfont-family:Calibri=2Csans-serif=3Bcolor:rgb(153=2C0=2C51)=3B">Hea=
lth Information Systems Program - SA</span></p></div></div></div></div></di=

=0A=

</div>=0A=
=0A=
<br>=0A=
<p style=3D""><i><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BAria=
l&quot=3B=2Csans-serif=3Bbackground:white=3B">This message and any attachme=
nts are subject to a disclaimer published=0A=
at <a href=3D"Home - HISP-SA; target=3D=
"_blank">Home - HISP-SA
=3B=0A=
Please read the disclaimer before opening any attachment or taking any othe=
r=0A=
action in terms of this electronic transmission.&nbsp=3B If you cannot acce=
ss the=0A=
disclaimer=2C kindly send an email to <a href=3D"mailto:disclaimer@hisp.org=
" target=3D"_blank">disclaimer@hisp.org</a> and a copy will be provided to =
you. By=0A=
replying to this e-mail or opening any attachment you agree to be bound by =
the=0A=
provisions of the disclaimer.</span></i></p><br>___________________________=
____________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : https://help.launchpad.net/ListHelp</div> </div></=

</html>=

--_30ea01b7-c1a7-4ddd-8663-5b0917c695ff_--

--_6a40b863-a43f-4011-bfe1-c5a9de2ec81f_
Content-Type: image/png
Content-Transfer-Encoding: base64
Content-ID: <image002.png@01D0CAE3.9117AFE0>
Content-Disposition: inline; filename="image002.png"

iVBORw0KGgoAAAANSUhEUgAAAE0AAABMCAIAAACnN61CAAAAAXNSR0IArs4c6QAAGwRJREFUeF7t
W3l0XHW9/91t9iWZrJM0S9Om0H2xUgoCZUeoClZUZDtPAc8Tj8rBhwuID5UDKvjeUyyuFDyoLSAI
aEHKJmWXFqhd0jRNm6TZl8nsM3d9n+/vN5OmtTCDxT9E75kmN3fu/d3fd/98l0qO47B/gUP+F6CR
SPw3ne8tQUtHY5+w7DxjNmNuxhT8gTOJVAS/ceAUn5IHnsNHxj+LHjBky5EkZtmaLTFFlrBBia/j
yHSfWBd/4Rb+l1LeW45Kb/FGlTGX2OWUO3PIGPCRxMUy3FyBHfSMuF+iQ6W9gZjCMoJt05hXJh8F
o49KngVZCUqm6BHvn07e24q1IKSirEzHNm1LUzRaw4ZsZSFACFUsQ8s7JM8CASUV5t2hEzqKLR7K
6UPILmraW+2Hnub7JrnhsG1VUXTHxqlbLljD37KRNKjUytPfeFR6e5AeWIvETEafgiA55cT1MoQp
yDBg4FBX00mMjjPDVCTJNi3JJssXhoADXC18xLJlGIWg9qjp5JRMEYlN6IZu2yQN/CKxvK1eFb7l
SoFzWHtqNPbrO36WGY2pkiwZNjd07t0sh1nkeg4XZHmkvgt0QmgQo3AYsuNo2Jpu2qZpSo4BTSzH
fvhNQv1jAyOb7390tKuHa6U2tqV798ZXUruHIGvVlhUbbrcoyHK8efHtR0sn+XduWnipRgKB31Bl
yaU4Ms7LcbdEozByfiR7Bo2+0ZHOXpy/uG7DrZ/4zA8uu/pbl36245lXmSopXMCCKQcNpAxWHi2d
4hUFIvFm3dl4591P3vNbCnemzVcvQ6KOiLt0DL2xXU4lK2Xv4Iu7fnnjzfG9Pf6k3v2XLb/65ndT
XcMMAbXgzrGszWC+5R1HS6fYH+xK5TId3tn905tuefDOXxojk5qsuCSlEBbeYjfEg2JYQsQ3Dbt3
554QU6sVz31rf2KNJ5rkcNhgbZ663a++8ebTm4WtiqMcZZl6bWk6YXjwhGRncAT4Bw5aDE4BSIgO
rkjYogBBo6OjME5mWIl0UlIkIl54GP5t76u7tq5/YvcfX7THM/SEZcs2FJ9cal4m32wOT3b/taPG
Xzf+esfEc38NyH6s7XI0nymFbfnZRzZaaXJFgrmc5HJttASdluOYCNe0V8eysTE6BZ3Ydo7i+OFc
9Vb4TVUymK0FPATjLIRD0zYM7OcvGzbddsGV6y760s2rL/3GRVeAHhm2rBsSgIHq5AFYYJydvamR
mG1LW595ye6b8Eu+vKSYTMaiVcwzuLs7PTQKOinMABw6sH9yAeUcJeiENSB8uYFFYAsESTgTOaYk
GXLeAocSk/lKLXNmr7nkU2suvyxYXwsGQUaKJMsubbBj37qv35wbGMozZ+WHzzNyxtov3pAciUka
vBUWJS+Kz96OPUYmZxjGmzu3welojmRZBHOxssqU7ER8/67dBZV9d/UW1tW/u2tgRzccAGIhpAkm
2goRBu9KG+REklxJ/5ga9n76+q+d87E1kDz+RGjBVbD8hUceS3b3+WWlfeWy/7zr9oUr3r/j2Re6
/vwikDrx0LFh4aBzYG+vbemSArcKl+0CfaosAzwYzFKYZGTzg339U3QSDilHlPye0va5f1fn47+4
l+VNkiRJVdI5LwHfyfgK4JPOhekM7t794xtutONJiN6WIQxFT+a2bXo+zDRTcc654hJWpemyHXeS
uUxW7FNhMj7w1cm9fQpkq6nV0fq0mYX1QreBiWA25O0cZubwcu4tiiG3TEpL01nhDb70wKMDr+1S
cACWMUR/HjD5m4QWYwdkK/ydXR0dLzy+qb9zH5K1wnaSeXkyYzE9Ut1YPW8W7jn9o6vPWfOp6vYW
vmcQA0tlznhqsrcPQgpEKurbZwJjaJIMwAH2yRKsR/izoncueMYyySxDnpWhUGxw5PWNm8i1cjst
qEGRToLUAnTyY7RvKDcxNry9kwdVupk8l2XDV7tC/mAkhCutyxfcuG7t7OOXmnC6+I7rbXxkLDsW
B9dC0er6ubMycOqSA/OG3zYckyKUgkgFcykc78DblqO3gWCwtrLq2Ycf0wcmQSdWp2gpRCkOQWfR
VtIjYxozBrd3Qo9hVI5puwLu4MxonOUT6UQ2RREFoJC51ZTCkkBTCrJpUqvERDwXS1DWXhuJLJqX
d8m6Y8EbwWXjBgOeX2Z1M6Jci4hGaFDBF5Yh1NJ666+qrGmMDuza1fX8K4IsWCZeIHIRkmKRYEFp
cmTMx9QDnV1Wljwuy+XlkOf0S9cwb3BwYKhv1x6uDsDEcKQ8BpKO0KOp8Vg6FZeY7K6JVM1rdVVX
6PB6Cvyerahqnlmh+pqZC+cW6eS/yw6gpelUgoFQdURi+l/+9AyWhogUC4GxANxhPMC3ImyTH7KZ
oeeDzD05MKon08R0t2KZ5vtWn3HZN7+aZMZ9379jcku37FYcVVIty8ftDfwgefYPmsxC7I001LYu
OyZ6zKwsvJ+hu2UNyybs5NKTVoRbG0h7BGcF7CvP55amU9W0moYospB9r22L9Q2Tw+DYCKornBCJ
lNNJl/Edkgomp+IJK5HENzmVYijiw3lf/o8v/+i24a79373kc/ue2iK5JLelqDohEMRGOJjB3l5E
ITArVBtR/OpHPnOpLqsTTjJr6UNWzBeMfPCTH5e0aVlueRQKpS5FJwUQKTwj6mbu1O4DvVt3wdmm
uACM4XRs/yhLGRoPoNA96LOUh99Q48xJ5fJ6LM2NV9IliJ9uOPFza2781U9iifj1H//0c7/8Pbys
7HIptgw1dkxnfHwCyyiqO9JCRrhgzann/s+19pKZfVHmOXHuJXf8d8Npy1AfA2eJq0W4UoZtlkMn
Z0WkrUVG9DPi/W90IH65VfXA869/78IrvnzWBeu+fos+miIrg18UukRORbMMKx1P4YLPUlwm6Rm8
CCQ/86MnXvntG5ysccc1X3nqtrs5SubfWnY8Fof79YQD4WgNMUi2V3/hslv/8KvvbvzNTb9bd9xl
H6IIzVenF02ZZnkIt4Q8hWpUtTV7vIgH8r4dHV4QkTY33PLDjs2bne6Rh9b+/KHb7yQBC2fiZZrX
64LuWk4mTfKUEBFMXvugEiXFwKVnn7Zg2RIpmX/wO/+7/d6NtGvLsfJGNpkCI2rq66uqq7mTkVAG
C9XVNC4+xhMO2uk84grw8kFtnQqlZci0FJ2cWxXR6mBdNeLX8J79Ulzv3/xmzwtb26TKGbL/GHft
47/4ddeTr0D5MqBVYeHaGliby6LaAokFJMI+kX1DDhwKyxXeSH2dB6aWzT5058/Tg3HcYCUyE4PD
kGdVc0OorhqFF27wKItZLGdQIdejGbYJ9F6I0+/EOMuwT86q6mhtsKEqx/KxvsHxrv5Yz6Aro/sd
1W07AdNUJhPPrn8QyZtARJG6ao0pquW4UFFATqcyRPnnHnliaO8BUEvRSGb5XF5xHJ/kOTDQ39Pd
TbcheE7EofWVs1uZT0Wc5s6OgAI8swPOkWkQGC5DeEe4pYQ8xdeusC/SFKVyXjYb6x+eHB4jNwsh
OZpLl2qZb8ezLyf2D3o4s+tnNEDySOHE27Dl0Z3d377yiy/+8QmKPQrLjU4kDwzWMs0H+euWbsK1
MSejUw1Tdje0z8SfqKNR7Y+bvaPCVRGRqOXi+j+ETp5VE9SrndWiMrej69CuXAagnuVlOYHQKEk+
pmUHxjpe3krggbFoW7Pq9TmKDDhOCmM52nCyImmw0TiRzdhLjz05sr0jCjtmUjAQqK4ha8zFk0Ym
6woF25csILKBELjkeJpJ2BkbAd1YtUDnlFzLE3CpuEJvJMk0zG5BDAAYHd/fryeSOWYYmppFSq0B
qRiabfbv7BJ4IdhY56urNjXJG0A1gDC4v7JSBfoZmWQT+e6nt/7pB3eFLUm3rAMs2bZyaeOsZtw1
OTaRy2YjrY2VHNwDC+JBZDtUIS1KULhYHqr5UR6F4t5SdOIl3FRqWxocTTYdY7LngJrKuZjL1E3T
ctJIm9yw03wcFTpeSnFHIzVzWvMycF6ANBA+eEHThdd+/jfr7/vayeevvejzuc5eWXHvsOPq0nkX
fO1qyU1iz8QTWTs3e+E8VyQoijNCgDJonUbe4UCvbFJL0clzKxhQKFoXCIfhAq1Y3JpI+iQ3vL6k
G0k9k7HMAPPE9x/QxxPQZ8mnzFmywHarst8nEFLOI62+/urV117VPzo4MtIPpDrklxddduF1v7mz
bkk7WSdjE2NjKlMXnrACeS2JkFytYxkCAxfESJLk3mnqKN9YS9FZYJjjqo6EGupAZzaTBYuzTo5V
+C7+yhevuOUGpakqw8z48Eh8cEQkELXHz3c1VTsBj9giDNwKuC+/8ZrvPfHgt9bf/V/33HH9o3df
87PvNRzbSikZJZhsODHpr6puWrpY0EA5CikS6ZIoqfCrRQLLp6/4RKn4SUqjYPeuoN/fUAsskLHz
CSszytJLL159/K1XHH/dJedff3XaI8djY/l4itAvY+Els2afvdLh1T4onk9VRfGhfnFb6ydObbvs
zJaTF0IhoJpIUF2UB7DBTKp6xeL6xbNJaWXJRqpJpk33vFV/8R0RW1Ke5OuQo8hueUZzk8HMfDYL
UAJQ1HbC+wSzlq8+o33Z4tHMaCpOHhWqW98Q/fAn17j9bqjgVAYuukyU3xTTVdRCQKOt4ZejM3PF
h85gHjJLaDLdWQrBlm2btMmSdOKVBE6gf63t7VTayhmWYQYqQhXROjxvmZZWF5698n1QMz02iSso
8AQ1z6z5c1WfW/QpxYamTiix4h+R0+kwdMNc9oHjTjrrNCSlU41NEhd/5pAlpi/0TjxuCTppQxx/
Yf2q9ja/q0LP5WzJ8UbCwVCQXqqSSTbNnwNgl+F0UsHZQB0bqQehbsr6D/0QACySTYRQZdQ588Pn
RqLVkD8gk6hXkBcuquZUPZFvZtpRtu6WY5+FElekoS7UUItCjy8ckoNe2UulGjHe0DxvtqJ5M3nU
rgmUEzqAoKhrWyzGCwmKtJibHKpKglrHsmTk3AEPXaIMDbUiG5k1TkQhXLhY8ejUSeGPabyYTv7f
npfSWyphoYKFiiILtTVUzW3LO1ZltNYJeizK8guirpzV4quvyqIYIF7MsQWhU8QGjvVITNNiH11n
VOknUwegU6AENnMBGwDukaVQfYyEizU4LppG8NvT81bflqYTno+/yZGCypyTVyhBX3hGPeKE2+Om
VBAVKmha0F83b/akTjUuUkSMUFDdh+SjS9ShyINa4XVI2DxZxaAFg9OVvZKCegIgHfk7mSqkuAMi
R4EMuMM0DTQvyBGKBObvPUrR6SBh4Ikj189jTznODrgDs5qbF84NRirILRnInyXNrTYuOiaJ4i7n
iI2kWkLehc2J/fEaLzGFCtJ0pMzsaDIxMIFPanAiNRRLDoynh2P5WBrEoUbjRvsIyyKyUKscDSyK
pX9/tkIA420zAGESKIhDrVBjTCRSv7/h9lM/doG7MVLf0iih9iOcsSw/fveGHXs7r73pBrhRAySi
gCQ8puBkmqGT2d/dO9o/ONHd19e1NxaL6egvmbbGsxxDslWPO+AP1NRWN849pvXY9lnHzlFnIBcq
GiU2ghyNrJZKCof0j8qIMKXnapDBUwfBttN8oEfa3qeGAp7mSgvQnPwpKLVlVTnQ1dO1t/OkVatQ
Ss5JqBXRbuxYtn/b3l1Pbd72ypaxPfvy43E7mdWdDL4CQoY5Iq+E0KAGujBXhkCqK0x1eQL+uqr2
5UvnnX1C68rF0WNnkT6AH9OHpaa0+F2gEzEOJTkNAMVJc49AwQQ1Il6lQdeQkkYcIBcWiN4WJMsF
mN0/+vKjT2x54pnO51/XJ9MuSfJCu22GnxppMoVP1EZRucwB/zBcA7VYDkkKuSXZ60aZL2eZsQDz
tdSuOOkDp37kvEXLlyoe9O64iglDPXhWwnBLyRMelPfGwGRQB56ia0J6JlgL18KL5WSTmPvhsXR8
x4GX7n9o84ZHxju6USiqUEM0fAI3Jsu6ZWadPCq0KHWiKlxbV+uLRrTGynB1ZVV1VWVVVbi6KlRZ
AWIkt0aRGW7eNlKGnkonQ1UVzdDkIOpT/wA6C6iluDQiZmFySTCSakJoSksBboWpPUOb1q1/cf3D
w/v21sIvO4rioDVi6MzOw5koHl9DTWROS01bS3R+e/3cNhyh+loWeFtfKPQF7wLHKeoQv8SFg973
6PUWnh29OyFGKkzztxZ6gcVzvMVOm8/d88DGtfeM7+gMMDUgu2l+yNGzzNKqItG21qZF8xatfH/T
8iWBGTVK2MXBTgHo4rSIBCnl5Psn+ICfIEgzLHK51F8k6CB8XiESv4v2CSbig2xDLcwHURiEAuNN
pMDcVlHLfeBHd738yONhRw2rnpyRzTHTV1XdsnDOstNWNa5aMnPeHKUqcJgtATVxV08dsSnbKgCo
YrGL6IEPgCFjVEeWaWqAOlkk0Hff31JoFzAXh0YRH1NeHglND2ZOpJ77v/VP3HHX8MRwwBXI6jnN
42lbtmD+6R9YduaqmvmzlAglZCKqEtLg4IbnWXResLSCWIrKR4Lk5/w27mCp/w96OVwmpvwD6CSV
As6k92B5RLk8arOK6pLkwZd33f+NW3c/+RJaEDZT1Yrw4jNPWfGxDy066TgWRdSjfYJC9SASLRiU
iMlF+yro4PS0Zkq8pL7Fz/SLhRLRlOmW8LXcwN8eJxzE3qahKSr1njlXtz3w1L3X3TS0rxNFwJoZ
LcvPPePET57fcNwC5gdkm2qlIepILoLy3OKm4dspUM6lW9BBIdDDnNJ0pDe1xkG/827FFQgE8JWC
o2NpVG1X8PfTP71n7Y0364mJ5XOWHr/m3GUfPbd6yTHCtQB/k18kxAfoAlwK1DhNcofhU9rl4YMx
030nKVMR1B6ByDLEeFALSsiT6v4ck9uIErI9lr7729+/b+3P22bPPu/iT6w6f7V/fjOP+tSYR+OL
DxtgapZGe8iWUBqi4EKbPyQSTCf4MJkcGiRAJw/VB5P1d0LdwXuLejtl/YctQ06IkA5zKxPdg7d/
6bo9r715yVVXnn7Jhf7Z9bg3h4aeBB+MZpjFxymIpgKFYsSC5hkPgTCCbGF4h3iUKU80bQ8HbxMX
D7XJ6Szipe23jKSShbI/t3cIRFEAzAu4nouAsgTipyrvemnLT2+9DSWiy6+6qmYhr1Yh/qs0lgVd
RXOByggY5Co2xUiHQTkO8pEynybidsrZQI/jZqpziaRPsIJeDvAkoicxifI7DOGiKsafIS3n0Eq0
JCi/IH/MeeGYfJ5D07Tpgeqg3qLag0xaUzX8xK5odWS9tC3JtEyX5jJ0441XX3v693847ayzjzvr
FDxp5POym899FLdLZT5SbMxMOOjSAwDi+bxpul0ug+Zw0SLB5Cy2YmLwHXsWxHC68KSMDJd2z3Nq
PqIsOm2UpgqPxe8kaAmW8eZnQW5UlKFWDCUSkBNiD7rvR4RXNOUldN/SLWI9T0qmHxld793TXV9T
W1EboaY0TE4jpypMju4WBkRL8J/EYeI5GkTgrmNYqqbk8zpYho0q09efpnZ8cpCyH9BK6QEopEpD
YSMkNz7/ICKNgalyVYEAMUCPcTGKfKCOfCXVl0SMPexQPnvRFT2d3SP7+sO+oIP+UM6M9Y3s2PLm
YHffgc79lZVVmFQa6h1sam5KDoz9+Y+bfL4AeAYtT00kHIzixbNQLCeZ39+xd6Crx+fyZNNZ9HaT
sbg/6N+3c8/G9Q8hR6mrbzDjOTTFBvf2jQ2MemUP0rD8eNLKYHbGzk0k3F7/zle3PvbAw0jTKgKh
zHicpkKzhp7IOLqFiRzUGaW8lZ1MGJm8x+UG76AYr7/46qbfPdza3LJl8wu6YVbV1wDVELf+5pC2
b9ryp/UbMCQEPrW0tORyuUw6k0ol0TyBGjcf275qzXm/+OGPg6pHNZ3J+GS0uYmgn65jfj05GXcr
atOMGT37ekzDCFWEVbcLZqB6XMOjo6vOOcujuh6+97ezWluRhSTjifGx8VAoODY+HghQ3SWdpoa/
PxIcGRq6+Mqrtr/22rNPPdU8c2bAhzEUlOktqICZByOsysrK/X29wVAonkxA8hdefilydLfX07Fr
1/OPPX7yWWdsuH/D/KWLP/OlL5C+HIlO5aufvQabCAZDmVQagspms9Cx2e3tfp+/deZMX8Bf29A4
3HuguS4a8PtnzGiCxaNL29jQ0FhXX+H1Ryojk7HJZCLRMrMVRs49BIo/SktrK4ipCId6u/fV1Nbu
2b27vb09lUqBoV63J5fNVVRWNjQ0hMJhTVOHh4baFy6QTLN90cJjF8xXuNNC+yyXTvd071swd24g
EOzt6amNorfa6PV5G5qbDRoUk5DNjwwPjY2Nzl+0CD3DmW1t7oCvmJseIlPJnMhDybE7TEMi5TMg
KARKt2aksqoPnVsJbTI7q8uY7aMmgpLLoj1ve0MBG00eEG07pqnDZTG3C2VbPJJJJf2REExI1qjb
m09n7bS+bevrK045gdAU9gcrgsPA/Ui0UFyxLDg2xeOByUmqihYrdA+8hjN75fkX4mPjZ577QeZ1
2xldCyD5pPsx6EpdNpllxxJo20GwLp83n80oLlXxYCjwCPYpoaQs3B6pdRFCw+4pwvBarAHUjifF
XB9HJXTd5BOzKFOhGKcRppluE4SisBvqy9D4Klwo8RFenUbcCg6M3BYv9eBZmhinm2RTB0NlFdTC
byNwo9bJXbcAQyJlwsE3RtOPNM1awJkYspMty4TjPTKdOe7GRYoE1YeBi6os/BeKq1BCvA/7gHsA
YYaNBjb5VxQaIQmETRTiMHmHuR+YK9gFX4dnsQ5nHE+IaWt8SAS1NNtyIYAVS7mCqwiz1KWGnDDY
ixkr/p9fwA6amYSbJe8pgQuwWN7MpkcKvQmChSgvEcwEkXniEXQCHeIjHPRuGiDm4wBELd8rtQt4
UBdhDtTR/0pBtFR5zYRQASFXvB/pI4gn2Rbinwg4JAAQTzZkATFheZuQLqccyo+XilhPZWk+cwFd
xg45O4hN+I1obBkG2QsRTMGT5mK5TomhUZSVCG3yvhq/jOBP2SNqwkfwtwjeBXXgAqHKt7hPVMoB
bwmLiAJzIWLStAAJARl+AbYSIZjUUsFcgg6FwIcTqC5v+6PdhGX4UFyxClvQdVjEtIRzuvYXEp3i
f6ATX5GyieyHT7DDrIC1OHITHMAvnlAcfpSqgx3pmX/Ga29bg/pnJOgt9vxvOt9DwiTn994i5y2p
+Ted7y1B/6vI8/8BR3pdn+/EjxcAAAAASUVORK5CYII=

--_6a40b863-a43f-4011-bfe1-c5a9de2ec81f_--