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)

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.

ILS configured.
More than 7 URIs configured under one DN
Bug details contain sensitive information and therefore require a 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.