<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:284966041;
mso-list-template-ids:-782337056;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:1112167800;
mso-list-template-ids:1410901556;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:2120298592;
mso-list-template-ids:496774954;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Hi Richard, <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>After further review and testing the same upgrade process with a clean database we saw the same results. Further inspection showed that it was in fact a file overwrite issue. Upgrade to 4.4.1 has been completed successfully without any errors. Thank you for your quick responses.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Than you for your time,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Jeremiah Haywood<o:p></o:p></p><p class=MsoNormal>Lead IAM Administrator<o:p></o:p></p><p class=MsoNormal>Office of Technology Solutions | Illinois State University<o:p></o:p></p><p class=MsoNormal>Phone Number (309) 438-3829<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Richard Richter <virgo@evolveum.com> <br><b>Sent:</b> Tuesday, February 22, 2022 5:11 PM<br><b>To:</b> Haywood, Jeremiah <jhaywo1@ilstu.edu><br><b>Cc:</b> midPoint General Discussion <midpoint@lists.evolveum.com><br><b>Subject:</b> Re: [midPoint] Midpoint Separate Audit Database Issues<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left width="100%" style='width:100.0%'><tr><td style='background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt'></td><td width="100%" style='width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt'><div><p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly'><span style='font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121'>You don't often get email from <a href="mailto:virgo@evolveum.com">virgo@evolveum.com</a>. <a href="http://aka.ms/LearnAboutSenderIdentification">Learn why this is important</a><o:p></o:p></span></p></div></td><td width=75 style='width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left'></td></tr></table><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.5pt;font-family:"Arial",sans-serif;color:#EB0000'>[This message came from an external source. If suspicious, report to <a href="mailto:abuse@ilstu.edu">abuse@ilstu.edu</a>] <o:p></o:p></span></b></p></div><div><div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Hi Jeremiah<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><br>I found one harmless problem with the audit upgrade script - which is the first call:<o:p></o:p></span></p></div><div><p class=MsoNormal><strong><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>call apply_audit_change(0, $$ SELECT 1 $$, true);</span></strong><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>The line was somehow forgotten there - but, luckily, this is something that does not hurt the upgrade process now, because the only change there (#1, support for partitions in the past) is <strong><span style='font-family:"Arial",sans-serif'>create or replace</span></strong> - hence repeatable.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>I tried to create fresh DB, initialized PUBLIC schema with only the content of <strong><span style='font-family:"Arial",sans-serif'>postgres-new-audit.sql</span></strong> from version 4.4 (original LTS release) and then tried to apply the upgrade script <strong><span style='font-family:"Arial",sans-serif'>postgres-new-upgrade-audit.sql</span></strong> from 4.4.1.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>I observed no error and the change was applied.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Also, trying to call harmless call <strong><span style='font-family:"Arial",sans-serif'>apply_change(0, $$ SELECT 1 $$);</span></strong> on that DB resulted in error - the procedure is not there, which is expected.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>But there was no such error running the upgrade script for audit only.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>How do you apply the script? What tools do you use?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Regards<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Richard<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Software Developer</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Evolveum</span><span style='color:black'><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><hr size=2 width="100%" align=center id=zwchr></span></div><div><p class=MsoNormal><b><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>From: </span></b><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>"Jeremiah Haywood" <<a href="mailto:jhaywo1@ilstu.edu">jhaywo1@ilstu.edu</a>><br><b>To: </b>"Richard Richter" <<a href="mailto:virgo@evolveum.com">virgo@evolveum.com</a>>, "midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>><br><b>Sent: </b>Tuesday, February 22, 2022 7:23:06 PM<br><b>Subject: </b>RE: [midPoint] Midpoint Separate Audit Database Issues<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Hi Richard,<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Working with our DBA team they have stated that apply_audit_change() makes a call to the apply_change() procedure. Running the script against the audit table returned with the following:<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>ERROR: procedure apply_change(integer, unknown, Boolean) does not exist<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>LINE 13: call apply_change(0, $$ SELECT 1 $$, true);<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>HINT: No procedure matches the given name and argument types. You might need to add explicit type casts.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>ERROR: procedure apply_change(integer, unknown) does not exist<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>LINE 1: call apply_change(1, $aa<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>HINT: No procedure matches the given name and argument types. You might need to add explicit type casts.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Please disregard the “m_org” error, this appeared after attempting to add the apply_change() procedure to the audit table.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Thank you,<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Jeremiah Haywood<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Lead IAM Administrator<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Office of Technology Solutions | Illinois State University<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Phone Number (309) 438-3829<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='color:black'>From:</span></b><span style='color:black'> Richard Richter <<a href="mailto:virgo@evolveum.com">virgo@evolveum.com</a>> <br><b>Sent:</b> Tuesday, February 22, 2022 11:09 AM<br><b>To:</b> midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>><br><b>Cc:</b> Haywood, Jeremiah <<a href="mailto:jhaywo1@ilstu.edu">jhaywo1@ilstu.edu</a>><br><b>Subject:</b> Re: [midPoint] Midpoint Separate Audit Database Issues<o:p></o:p></span></p></div></div><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left width="100%" style='width:100.0%'><tr><td style='background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt'></td><td width="100%" style='width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt'><div><p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly'><span style='font-size:9.0pt;color:#212121'>You don't often get email from </span><span style='color:black'><a href="mailto:virgo@evolveum.com" target="_blank"><span style='font-size:9.0pt'>virgo@evolveum.com</span></a></span><span style='font-size:9.0pt;color:#212121'>. </span><span style='color:black'><a href="http://aka.ms/LearnAboutSenderIdentification" target="_blank"><span style='font-size:9.0pt'>Learn why this is important</span></a></span><o:p></o:p></p></div></td><td width=75 style='width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt'></td></tr></table><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.5pt;font-family:"Arial",sans-serif;color:#EB0000'>[This message came from an external source. If suspicious, report to </span></b><span style='color:black'><a href="mailto:abuse@ilstu.edu" target="_blank"><b><span style='font-size:10.5pt;font-family:"Arial",sans-serif'>abuse@ilstu.edu</span></b></a></span><b><span style='font-size:10.5pt;font-family:"Arial",sans-serif;color:#EB0000'>] </span></b><span style='color:black'><o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Hi Jeremiah</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>This sounds more like running the wrong script on the wrong DB. There is no apply_change() in the audit upgrade script as seen here: </span><span style='color:black'><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FEvolveum%2Fmidpoint%2Fblob%2Fsupport-4.4%2Fconfig%2Fsql%2Fnative-new%2Fpostgres-new-upgrade-audit.sql&data=04%7C01%7C%7Cf1512151f6b54877beba08d9f658a0e9%7C085f983a0b694270b71d10695076bafe%7C1%7C0%7C637811683793749275%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=6kc94IKafm9t97oQy%2BQR3id5HKPPnZOovhGIXtyn590%3D&reserved=0" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>https://github.com/Evolveum/midpoint/blob/support-4.4/config/sql/native-new/postgres-new-upgrade-audit.sql</span></a><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>I also check unlikely possibility of some wrong build, but my local extracted build has the file <strong><span style='font-family:"Arial",sans-serif'>...\midpoint-4.4.1\doc\config\sql\native-new\postgres-new-upgrade-audit.sql</span></strong> - also without any <strong><span style='font-family:"Arial",sans-serif'>apply_change</span></strong>, only <strong><span style='font-family:"Arial",sans-serif'>apply_audit_change</span></strong>.</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><strong><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>m_org</span></strong><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> upgrade is in the main upgrade script, so it seems like it was run against the audit database.</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Weren't the scripts overwritten accidentally with one another? Please, check their content as well, and compare them with the original files from the distribution package - of course, just the beginning and end is more than enough.</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Regards</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Richard Richter</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Software Developer</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>Evolveum</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><hr size=2 width="100%" align=center></span></div><div><p class=MsoNormal><b><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>From: </span></b><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>"midPoint General Discussion" <</span><span style='color:black'><a href="mailto:midpoint@lists.evolveum.com" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>midpoint@lists.evolveum.com</span></a></span><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>><br><b>To: </b>"midPoint General Discussion" <</span><span style='color:black'><a href="mailto:midpoint@lists.evolveum.com" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>midpoint@lists.evolveum.com</span></a></span><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>><br><b>Cc: </b>"Jeremiah Haywood" <</span><span style='color:black'><a href="mailto:jhaywo1@ilstu.edu" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>jhaywo1@ilstu.edu</span></a></span><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'>><br><b>Sent: </b>Tuesday, February 22, 2022 5:41:27 PM<br><b>Subject: </b>[midPoint] Midpoint Separate Audit Database Issues</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Hello all,<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>At ISU we have been pursuing the implementation of auditing to a separate database with Midpoint. We are running into some issues when upgrading from 4.4 to 4.4.1 where it seems that there are procedures referenced in postgres-new-upgrade-audit.sql that only exist in the main database. Has anyone come across similar issues?<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Steps taken so far:<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>4.4:<o:p></o:p></span></p><ul style='margin-top:0in' type=disc><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l2 level1 lfo1'>postgres-new.sql on main db<o:p></o:p></li><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l2 level1 lfo1'>postgres-new-quartz.sql on main db<o:p></o:p></li><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l2 level1 lfo1'>postgres-new-audit.sql on audit db<o:p></o:p></li></ul><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>4.4.1:<o:p></o:p></span></p><ul style='margin-top:0in' type=disc><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l1 level1 lfo2'>postgres-new-upgrade.sql on main db<o:p></o:p></li><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l1 level1 lfo2'>postgres-new-upgrade-audit.sql on audit db<o:p></o:p></li></ul><p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><span style='font-size:10.0pt;font-family:Symbol;color:black'>·</span><span style='font-size:7.0pt;font-family:"Times New Roman",serif;color:black'> </span><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in;mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:10.0pt;font-family:Symbol;color:black'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p><ul style='margin-top:0in' type=disc><ul style='margin-top:0in' type=circle><li class=MsoListParagraph style='color:black;margin-left:0in;mso-list:l0 level2 lfo3'>Ran into issues with procedure apply_change() not existing and relation "m_org" does not exist<o:p></o:p></li></ul></ul><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Thank you,<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Jeremiah Haywood<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Lead IAM Administrator<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Office of Technology Solutions | Illinois State University<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>Phone Number (309) 438-3829<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><br>_______________________________________________<br>midPoint mailing list<br></span><span style='color:black'><a href="mailto:midPoint@lists.evolveum.com" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>midPoint@lists.evolveum.com</span></a></span><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><br></span><span style='color:black'><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.evolveum.com%2Fmailman%2Flistinfo%2Fmidpoint&data=04%7C01%7C%7Cf1512151f6b54877beba08d9f658a0e9%7C085f983a0b694270b71d10695076bafe%7C1%7C0%7C637811683793749275%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=6KMk%2FFy3fWXNtTOFcaRAjCISWkaM3NvfUdvqQW4mNw4%3D&reserved=0" target="_blank"><span style='font-size:12.0pt;font-family:"Arial",sans-serif'>https://lists.evolveum.com/mailman/listinfo/midpoint</span></a><o:p></o:p></span></p></div></div></div></div></div></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial",sans-serif;color:black'><o:p> </o:p></span></p></div></div></div></div></div></body></html>