<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi Jeremiah<br></div><div><br data-mce-bogus="1"></div><div>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: <a href="https://github.com/Evolveum/midpoint/blob/support-4.4/config/sql/native-new/postgres-new-upgrade-audit.sql">https://github.com/Evolveum/midpoint/blob/support-4.4/config/sql/native-new/postgres-new-upgrade-audit.sql</a><br data-mce-bogus="1"></div><div>I also check unlikely possibility of some wrong build, but my local extracted build has the file <strong>...\midpoint-4.4.1\doc\config\sql\native-new\postgres-new-upgrade-audit.sql</strong> - also without any <strong>apply_change</strong>, only <strong>apply_audit_change</strong>.<br data-mce-bogus="1"></div><div><strong>m_org</strong> upgrade is in the main upgrade script, so it seems like it was run against the audit database.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>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.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Regards<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Richard Richter<br data-mce-bogus="1"></div><div>Software Developer<br data-mce-bogus="1"></div><div>Evolveum<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>To: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Cc: </b>"Jeremiah Haywood" <jhaywo1@ilstu.edu><br><b>Sent: </b>Tuesday, February 22, 2022 5:41:27 PM<br><b>Subject: </b>[midPoint] Midpoint Separate Audit Database Issues<br></div><div><br><style>/*<![CDATA[*/p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin: 0.0in;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {
margin-top: 0.0in;
margin-right: 0.0in;
margin-bottom: 0.0in;
margin-left: 0.5in;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
span.EmailStyle19 {
font-family: Calibri , sans-serif;
color: windowtext;
}
*.MsoChpDefault {
font-family: Calibri , sans-serif;
}
div.WordSection1 {
page: WordSection1;
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
* {
}
ol {
margin-bottom: 0.0in;
}
ul {
margin-bottom: 0.0in;
}
/*]]>*/</style></div><div data-marker="__QUOTED_TEXT__"><div class="WordSection1"><p class="MsoNormal">Hello all,</p><p class="MsoNormal"> </p><p class="MsoNormal">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?</p><p class="MsoNormal"> </p><p class="MsoNormal">Steps taken so far:</p><p class="MsoNormal"> </p><p class="MsoNormal">4.4:</p><ul style="margin-top:0in" type="disc"><li class="MsoListParagraph" style="margin-left:0in">postgres-new.sql on main db</li><li class="MsoListParagraph" style="margin-left:0in">postgres-new-quartz.sql on main db</li><li class="MsoListParagraph" style="margin-left:0in">postgres-new-audit.sql on audit db</li></ul><p class="MsoNormal"> </p><p class="MsoNormal">4.4.1:</p><ul style="margin-top:0in" type="disc"><li class="MsoListParagraph" style="margin-left:0in">postgres-new-upgrade.sql on main db</li><li class="MsoListParagraph" style="margin-left:0in">postgres-new-upgrade-audit.sql on audit db</li><li><ul style="margin-top:0in" type="circle"><li class="MsoListParagraph" style="margin-left:0in">Ran into issues with procedure apply_change() not existing and relation "m_org" does not exist</li></ul></li></ul><p class="MsoNormal"> </p><p class="MsoNormal">Thank you,</p><p class="MsoNormal"> </p><p class="MsoNormal">Jeremiah Haywood</p><p class="MsoNormal">Lead IAM Administrator</p><p class="MsoNormal">Office of Technology Solutions | Illinois State University</p><p class="MsoNormal">Phone Number (309) 438-3829</p><p class="MsoNormal"> </p></div><br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>https://lists.evolveum.com/mailman/listinfo/midpoint<br></div></div></body></html>