SQL Exception in CUCM with Device Pool Filter to Find Phones

NetCraftsmen®

When searching for phones in CUCM by specifying a filter on Device Pool, the CUCM returned the following error:

Error occurred during find. java.sql.SQLException: A syntax error has occurred.

Having seen something similar in a previous version, I tried the same search again but this time I specified two search filters – one using specific Device Pool criteria and another with a blank filter on Device Name.  Voila!  The search completed successfully.  A quick bug scrub confirmed the following:

CSCtw47561 Bug Details

Device Search using Device Pool as filter results in SQLException Error
Symptom:
go to Devices > Phone page and do a search : Device pool ‘Contains’. Get the following error:”Error occurred during find. java.sql.SQLException: A syntax error has occurred.”

The error also occurs if you leave the field blank or use any variation of the Device Pool filter such as ‘Begins with’ or ‘Ends with’. Conditions:
Issue only seems to occur when searching using the Device Pool as a filter. Workaround:
Add a bogus second filter (like Device Name – begins with – leave text box blank)
This should not cause any syntax exception when it checks for the result count.

4 responses to “SQL Exception in CUCM with Device Pool Filter to Find Phones

  1. Thanks. This was driving us crazy. We have this problem in an CUCM 8.0.3 patch. We are now able to search phones by Device Pool

  2. If you are a watch fan, wearing a watch can know some information about you, so you should not miss the [url=http://www.rolexinstock.com/datejust-29mm-pearlmaster-c-31.html]Rolex Pearlmaster replica[/url]

Leave a Reply

 

Nick Kelly

Cybersecurity Engineer, Cisco

Nick has over 20 years of experience in Security Operations and Security Sales. He is an avid student of cybersecurity and regularly engages with the Infosec community at events like BSides, RVASec, Derbycon and more. The son of an FBI forensics director, Nick holds a B.S. in Criminal Justice and is one of Cisco’s Fire Jumper Elite members. When he’s not working, he writes cyberpunk and punches aliens on his Playstation.

 

Virgilio “BONG” dela Cruz Jr.

CCDP, CCNA V, CCNP, Cisco IPS Express Security for AM/EE
Field Solutions Architect, Tech Data

Virgilio “Bong” has sixteen years of professional experience in IT industry from academe, technical and customer support, pre-sales, post sales, project management, training and enablement. He has worked in Cisco Technical Assistance Center (TAC) as a member of the WAN and LAN Switching team. Bong now works for Tech Data as the Field Solutions Architect with a focus on Cisco Security and holds a few Cisco certifications including Fire Jumper Elite.

 

John Cavanaugh

CCIE #1066, CCDE #20070002, CCAr
Chief Technology Officer, Practice Lead Security Services, NetCraftsmen

John is our CTO and the practice lead for a talented team of consultants focused on designing and delivering scalable and secure infrastructure solutions to customers across multiple industry verticals and technologies. Previously he has held several positions including Executive Director/Chief Architect for Global Network Services at JPMorgan Chase. In that capacity, he led a team managing network architecture and services.  Prior to his role at JPMorgan Chase, John was a Distinguished Engineer at Cisco working across a number of verticals including Higher Education, Finance, Retail, Government, and Health Care.

He is an expert in working with groups to identify business needs, and align technology strategies to enable business strategies, building in agility and scalability to allow for future changes. John is experienced in the architecture and design of highly available, secure, network infrastructure and data centers, and has worked on projects worldwide. He has worked in both the business and regulatory environments for the design and deployment of complex IT infrastructures.