Guest

Preview Tool

Cisco Bug: CSCus76982 - ILS hits SQL exception when DN has more than 7 URIs

Last Modified

Apr 05, 2018

Products (8)

  • Cisco Unified Communications Manager (CallManager)
  • Cisco Intercompany Media Engine
  • Cisco Unity Connection Version 9.1
  • Cisco Business Edition 5000 Version 9.1
  • Cisco Unified Communications Manager Version 9.1
  • Cisco Business Edition 6000 Version 9.1
  • Cisco Unified Communications Manager Version 10.0
  • Cisco Unified Communications Manager Session Management Edition

Known Affected Releases

10.0(1) 10.5(2.10000.5) 9.1(1) 9.1(2)

Description (partial)

Symptom:
ILS debugs(URIs replaced with 'xxx'):
00000955.007 |11:39:39.788 |AppInfo |DbOperationForGDPR: encountered a SQL exception: Error executing "EXECUTE PROCEDURE RemoteRoutingPattern_UpdatePatternSet('4f06a1e1-29f4-ef16-da6f-6531b10888f3','-1678678053',4167, NULL, NULL, NULL, NULL,'xxx','xxx','xxx','xxx','xxx','xxx','xxx','xxx')": [Informix][Informix ODBC Driver][Informix]Routine (remoteroutingpattern_updatepatternset) can not be resolved.

Some patterns will not be replicated because this exceptions stops the process so not only the directory number which  exceeded the limit is affected.

Conditions:
ILS configured.
More than 7 URIs configured under one DN
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.