CallManager 7.1.2a java.sql.SQLException on Route Pattern entry

Unanswered Question
Jul 22nd, 2009
User Badges:
  • Bronze, 100 points or more

I am unable to make the required Route Pattern changes due to the following error within CCM administration. "Error occurred during find. java.sql.SQLException: Ambiguous column (tkproduct).

Have you run into this issue yet?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
ldardon Tue, 07/28/2009 - 14:37
User Badges:

Check the similar bug: CSCsq74372: find button for Calling Search Space in DNA does not work

kking2008 Wed, 07/29/2009 - 13:05
User Badges:

I had a simiar issue, this is what the TAC engineer did to resolve it for us.

Login in publisher as administrator


admin:run sql update device set internationalprefix = 'Default', internationalstripdigits = null, nationalprefix = 'Default', nationalstripdigits = null, subscriberprefix = 'Default', subscriberstripdigits = null where tkproduct = 95

Rows: 6


admin:run sql update device set internationalprefix = 'Default', internationalstripdigits = null, nationalprefix = 'Default', nationalstripdigits = null, subscriberprefix = 'Default', subscriberstripdigits = null where tkproduct = 95 and (internationalprefix <> 'Default' or nationalprefix <> 'Default' or subscriberprefix <> 'Default')

Rows: 0



restart the CM service



Actions

This Discussion