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: