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

[Matthew Loraditch]

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

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 1:49 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

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/a0af0c91/attachment.html>