<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">Ah - glad you found that guide which I couldn't for some reason. At first glance, that seems likely to be your fix. Agreed - that script seems like the kind of thing that should be published in the UTILS area of the IM&P 11.5 downloads.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Aug 24, 2017 at 1:52 PM, Matthew Loraditch <span dir="ltr"><<a href="mailto:MLoraditch@heliontechnologies.com" target="_blank">MLoraditch@heliontechnologies.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="EN-US" link="blue" vlink="purple">
<div class="m_4153909306178529427WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Darn you and your eagle eyes<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/11_5_1/cup0_b_database-setup-guide-1151su3/cup0_b_database-setup-guide-1151su3_chapter_011.html" target="_blank">https://www.cisco.com/c/en/us/<wbr>td/docs/voice_ip_comm/cucm/im_<wbr>presence/database_setup/11_5_<wbr>1/cup0_b_database-setup-guide-<wbr>1151su3/cup0_b_database-setup-<wbr>guide-1151su3_chapter_011.html</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">You  have to run a script! (Which you have to get from tac, because heaven forbid it could be publicly available)<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA<br>
Network Engineer<br>
Direct Voice: <a href="tel:(443)%20541-1518" value="+14435411518" target="_blank">443.541.1518</a></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><br>
<br>
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://www.facebook.com/heliontech?ref=hl" target="_blank"><span style="font-size:8.0pt">Facebook</span></a></span><span style="font-size:8.0pt;font-family:"Calibri",sans-serif;color:#1f497d">
 | </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://twitter.com/HelionTech" target="_blank"><span style="font-size:8.0pt">Twitter</span></a></span><span style="font-size:8.0pt;font-family:"Calibri",sans-serif;color:#1f497d">
 | </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://www.linkedin.com/company/helion-technologies?trk=top_nav_home" target="_blank"><span style="font-size:8.0pt">LinkedIn</span></a></span><span style="font-size:8.0pt;font-family:"Calibri",sans-serif;color:#1f497d">
 | </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="https://plus.google.com/+Heliontechnologies/posts" target="_blank"><span style="font-size:8.0pt">G+</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
</span><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Dave Goodwin [mailto:<a href="mailto:dave.goodwin@december.net" target="_blank">dave.goodwin@december.<wbr>net</a>]
<br>
<b>Sent:</b> Thursday, August 24, 2017 1:49 PM<br>
<b>To:</b> Matthew Loraditch <<a href="mailto:MLoraditch@heliontechnologies.com" target="_blank">MLoraditch@<wbr>heliontechnologies.com</a>><br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] Upgrade from 11.5SU2 to SU3 External Databases for IM&P No longer work<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">The very last item in the SU3 release notes mentions some new datatype values for MSSQL. This is not something I'm well-versed in, but could this be related to the errors you are seeing? The
 document mentioned on Database Setup doesn't seem to be published in an SU3-specific format as suggested. In any case, consulting TAC on this problem is a great place to start.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><a href="https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/rel_notes/11_5_1/SU3/cucm_b_release-notes-cucm-imp-1151su3/cucm_b_release-notes-cucm-imp-1151su3_chapter_00.html#concept_9B72D61BBD1E9D1DEEFE08C6A87C2EF8" target="_blank">https://www.cisco.com/c/en/us/<wbr>td/docs/voice_ip_comm/cucm/<wbr>rel_notes/11_5_1/SU3/cucm_b_<wbr>release-notes-cucm-imp-<wbr>1151su3/cucm_b_release-notes-<wbr>cucm-imp-1151su3_chapter_00.<wbr>html#concept_<wbr>9B72D61BBD1E9D1DEEFE08C6A87C2E<wbr>F8</a></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Thu, Aug 24, 2017 at 1:41 PM, Matthew Loraditch <<a href="mailto:MLoraditch@heliontechnologies.com" target="_blank">MLoraditch@<wbr>heliontechnologies.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">Patched our internal servers and got this one issue<u></u><u></u></p>
<p class="MsoNormal">Database schema mismatch<u></u><u></u></p>
<p class="MsoNormal">Errors like this the relevant service logs:<u></u><u></u></p>
<p class="MsoNormal">18:07:28.487 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_messages mismatches column msg<u></u><u></u></p>
<p class="MsoNormal">18:07:28.493 |f763fb70| error| SchemaColumn.cpp:189 column mismatch columns body_text:body_text type 1:4 primary key 0:0 length 4000:0<u></u><u></u></p>
<p class="MsoNormal">18:07:28.494 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_msgarchive mismatches column body_text<u></u><u></u></p>
<p class="MsoNormal">18:07:28.494 |f763fb70| error| SchemaColumn.cpp:189 column mismatch columns message_text:message_text type 1:4 primary key 0:0 length 4000:0<u></u><u></u></p>
<p class="MsoNormal">18:07:28.494 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_msgarchive mismatches column message_text<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">MS SQL Database. I’m opening a TAC case as I didn’t see anything in the release notes or readme and can’t find any current relevant bugs. Just figured I’d point it out for others.<u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;color:#1f497d">Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA<br>
Network Engineer<br>
Direct Voice: <a href="tel:(443)%20541-1518" target="_blank">443.541.1518</a></span><u></u><u></u></p>
<p class="MsoNormal"><a href="https://www.facebook.com/heliontech?ref=hl" target="_blank"><span style="font-size:8.0pt">Facebook</span></a><span style="font-size:8.0pt;color:#1f497d"> |
</span><a href="https://twitter.com/HelionTech" target="_blank"><span style="font-size:8.0pt">Twitter</span></a><span style="font-size:8.0pt;color:#1f497d"> |
</span><a href="https://www.linkedin.com/company/helion-technologies?trk=top_nav_home" target="_blank"><span style="font-size:8.0pt">LinkedIn</span></a><span style="font-size:8.0pt;color:#1f497d"> |
</span><a href="https://plus.google.com/+Heliontechnologies/posts" target="_blank"><span style="font-size:8.0pt">G+</span></a><u></u><u></u></p>
<p class="MsoNormal">, bu<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/<wbr>mailman/listinfo/cisco-voip</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
</div>

</blockquote></div><br></div>