[cisco-voip] Upgrade from 11.5SU2 to SU3 External Databases for IM&P No longer work

[Matthew Loraditch]

Just a comment for the Cisco folks since Ryan had been asking about related topics, but this was literally the bottom entry on a long list of new information. I feel like stuff that works but WILL break and need manual intervention should be the top of the release notes.

I’d also like if the upgrade just did it.
Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA
Network Engineer
Direct Voice: 443.541.1518

Facebook<https://www.facebook.com/heliontech?ref=hl> | Twitter<https://twitter.com/HelionTech> | LinkedIn<https://www.linkedin.com/company/helion-technologies?trk=top_nav_home> | G+<https://plus.google.com/+Heliontechnologies/posts>

From: Dave Goodwin [mailto:dave.goodwin at december.net]
Sent: Thursday, August 24, 2017 2:03 PM
To: Matthew Loraditch <MLoraditch at heliontechnologies.com>
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Upgrade from 11.5SU2 to SU3 External Databases for IM&P No longer work

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.

On Thu, Aug 24, 2017 at 1:52 PM, Matthew Loraditch <MLoraditch at heliontechnologies.com<mailto:MLoraditch at heliontechnologies.com>> wrote:
Darn you and your eagle eyes
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

You  have to run a script! (Which you have to get from tac, because heaven forbid it could be publicly available)

Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA
Network Engineer
Direct Voice: 443.541.1518<tel:(443)%20541-1518>
Facebook<https://www.facebook.com/heliontech?ref=hl> | Twitter<https://twitter.com/HelionTech> | LinkedIn<https://www.linkedin.com/company/helion-technologies?trk=top_nav_home> | G+<https://plus.google.com/+Heliontechnologies/posts>

From: Dave Goodwin [mailto:dave.goodwin at december.net<mailto:dave.goodwin at december.net>]
Sent: Thursday, August 24, 2017 1:49 PM
To: Matthew Loraditch <MLoraditch at heliontechnologies.com<mailto:MLoraditch at heliontechnologies.com>>
Cc: cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: Re: [cisco-voip] Upgrade from 11.5SU2 to SU3 External Databases for IM&P No longer work

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.
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

On Thu, Aug 24, 2017 at 1:41 PM, Matthew Loraditch <MLoraditch at heliontechnologies.com<mailto:MLoraditch at heliontechnologies.com>> wrote:
Patched our internal servers and got this one issue
Database schema mismatch
Errors like this the relevant service logs:
18:07:28.487 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_messages mismatches column msg
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
18:07:28.494 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_msgarchive mismatches column body_text
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
18:07:28.494 |f763fb70| error| SchemaTable.cpp:220 schema mismatch: database table tc_msgarchive mismatches column message_text

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.
Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA
Network Engineer
Direct Voice: 443.541.1518<tel:(443)%20541-1518>
Facebook<https://www.facebook.com/heliontech?ref=hl> | Twitter<https://twitter.com/HelionTech> | LinkedIn<https://www.linkedin.com/company/helion-technologies?trk=top_nav_home> | G+<https://plus.google.com/+Heliontechnologies/posts>
, bu

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170824/3cf14f4a/attachment.html>