Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

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

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?

2 REPLIES
New Member

Re: CallManager 7.1.2a java.sql.SQLException on Route Pattern en

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

New Member

Re: CallManager 7.1.2a java.sql.SQLException on Route Pattern en

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

254
Views
0
Helpful
2
Replies