|
I was recently working on a CUCM 8.5(1) system and encountered a bug that reminded me of  something similar from back in the days of ye' olde CUCM 6.x. Now let me say upfront that this is certainly not a critical issue. In fact, it is basically just a cosmetic bug and doesn't impact the system at all. Bugs are always interesting to me so I thought I'd share.
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.
|
 |
Subscribe to this comment's feed
