CUCM 8.6.2 - Error BAT update

[wilsonsant]

Hi Guys,

I created in my lab, a one template to include the specific details (specific parameters: DN, Alerting Name, Display, etc...). Now I am trying create the same parameters, but, with another values and when try to do update appear the error message:

Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred.

Any have idea about this?

Thanks,

Wilson

[Rob Huffman]

Hi Wilson,

A couple of questions

What is the exact CUCM version?

Does this happen at this point?

Cisco Unified CM Administration page > Bulk Administration > Phones > Update phones >Query

Cheers!

Rob

"I don't know how, I don't know when
But you and I will meet again " 

- Tom Petty

[wilsonsant]

Hi Rob,

The Callmanager is in the  version 8.6.2. The error message is: Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred

Thanks,

Wilson

[Rob Huffman · Accepted solution]

Hi Wilson;

It could be this bug;

CSCub67519 Bug Details	Bug #4 of 43 | < Previous | Next >

CUCM 8.6.2.22900-9 BULK update of Phones triggers java exception error.

Symptom: When updating phones with bulk, the phone configuration options page doesn't load and the following error appear "Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred." Conditions: CUCM version 8.6.2.22900-9 Cisco Unified CM Administration page > Bulk Administration > Phones > Update phones >Query Find (doesn't matter what filter you use, or even if you left it empty) - the phone list page appear and right after clicking next (to Choose the phones you want to edit) - the phone configuration options page doesn't load and the following error appear "Error occurred while retrieving information from database. java.sql.SQLException: A syntax error has occurred." Workaround: Add  a working filter (e.g. Description - null value) with the affected  filter like 'Device Name' which lets us search by Device Name, CSS, etc.  bypassing the error. This was introduced in ES 8.6.2.22039.1 due to CSCtx96255 You can also revert back to CUCM ES versions prior to 8.6.2.22039.1 or SU1.

Status Fixed  Severity 2 - severe Last Modified In Last 2 weeks   Product Cisco Unified Communications Manager (CallManager)     Technology 1st Found-In 8.6(0) 8.6(2.22900.9)   Fixed-In 9.0(1.98000.204) 8.6(2.23047.1) 9.0(1.98000.48) 9.0(1.11004.1) 1.0(0.98000.16) 1.0(0.98000.42) 9.1(1.10000.11) 8.6(2.23900.10)

Cheers!

Rob

"I don't know how, I don't know when
But you and I will meet again " 

- Tom Petty

[fullermichael]

I think Rob nailed it (as usual).  We ran into this and loaded SU3 and it seemed to do the trick!

[wilsonsant]

Hi Rob,

Thansk a lot. I will apply the release 8.6.2 SU3

Wilson