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:[email protected]] Sent: Thursday, August 24, 2017 2:03 PM To: Matthew Loraditch <[email protected]> Cc: [email protected] 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 <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] Sent: Thursday, August 24, 2017 1:49 PM To: Matthew Loraditch <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
