12-15-2012 12:27 PM - edited 03-16-2019 02:45 PM
Customer has a system with 500 to 1000 phones spread over 4 locations. In attempting to do mass updates using BAT, we are having problems selecting all phones to update.
We find that if we select all phones, and advance to the page where we should be able to set the options we want to update, we don't get that page, we get a page that says: Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred.
If we add further filters, we can sometimes make it work, but we have to make multiple passes, and then when it shows the page where the list of devices is displayed, all the images down the left side of the page (showing the phone types) doesn't retreive the image, and instead returns a red X with a long url naming what the image was supposed to be.
I've seen this on multiple systems lately, but hadn't opened a case on it yet. Anyone else seen this?
Cliff
Solved! Go to Solution.
12-15-2012 12:51 PM
I have seen this, check out this bug
CUCM 8.6.2.22900-9 BULK update of Phones triggers java exception error.
http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCub85460
Chris
12-15-2012 12:51 PM
I have seen this, check out this bug
CUCM 8.6.2.22900-9 BULK update of Phones triggers java exception error.
http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCub85460
Chris
12-15-2012 01:00 PM
That's it! 5 points for you!
12-15-2012 01:06 PM
Thank you for nice rating.
Chris
12-18-2012 04:20 AM
The bug has been removed, any idea why?
By the way, I am having this issue of CUCM 8.6.
Has any one found a solution yet?
01-22-2013 04:26 AM
I opened a TAC case and the solution is as ingenious as it seems stupid.
You just have to insert a blank filter by clicking on the + sign and then on the second line input your query.
P.S- I checked, The bug ID has well been removed.
04-15-2013 10:52 PM
Hi
This is correct.
Cheers !!!
04-16-2013 04:11 AM
Hi Fernando.
Please rate useful posts.
BR
06-10-2013 12:01 PM
Thank you Sadaseeven, adding the blank filter fixed me up too.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide