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|
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:
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:)