SQL Exception in CUCM with Device Pool Filter to Find Phones

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”

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

Thanks for the feedback…very glad you found that useful.

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]

This was helpful like always:)

You must be logged in to post a comment.

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

Leave a Reply

Related Topics