Failed to add device to WCS Reason: Could not execute JDBC batch update

Unanswered Question
Apr 14th, 2010
User Badges:

Trying to add an autonomous 1231 AP to WCS in preparation for conversion to LWAPP doesn't even start and produces "Failed to add device to WCS Reason: Could not execute JDBC batch update"

IOS is 12.3(7)JA5


Anybody run into this?  Simple fix?

I converted 29 other identical 1231s this past weekend without problems, now this.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
sschmidt Wed, 04/14/2010 - 14:35
User Badges:
  • Cisco Employee,

Please go to Administration > Logging and uncheck Status Polling, Object
Manager, SNMP Mediation, MSE/Location Servers, XML
Mediation, Navigator and Reports and change the
message level to TRACE and click submit.  Go back and recreate the issue
and then go back to the logging area and download and attach at least the wcs0-0.log and wcs1-0.log so I can take a look.

mscherting Mon, 04/26/2010 - 15:06
User Badges:


Thanks for your assistance.  Hopefully I've followed you instructions correctly.  I was offsite last week and am trying to get caught up.

Log files attached.

Lucien Avramov Wed, 04/21/2010 - 11:14
User Badges:
  • Red, 2250 points or more

This could be a few things. run a wcs backup before taking any other action. a dbadmin checkschema, after you stop WCS and try again.

2. If not,  stop WCS, delete the db transaction log file solNNNNN.log, start WCS, run a refresh from controller and try the template again.

mscherting Mon, 04/26/2010 - 15:35
User Badges:


Forgive my ignorance.  Could you be a little more specific on executing these steps?

How do I start a manual backup of WCS?  I have a weekly backup scheduled via Admin > Background tasks.

Is the dbadmin checkschema run at a DOS prompt with WCS stopped?

Where is the db transaction log file solNNNNN.log assuming WCS is installed on D:\?

Thank you.

Lucien Avramov Mon, 04/26/2010 - 15:44
User Badges:
  • Red, 2250 points or more

I looked into your logs.

The first error message you have for your database is :

Caused by: java.sql.BatchUpdateException: SOLID Database Error 10005: Unique constraint (BASEAP_UNIQUEKEY) violation.

Then you get some passwords error messages for connecting to the ap, but I think this is just a consequence.

I would recommend first to follow my previous steps, we can dig in deaper the BASEAP_UNIQUEKEY later if needed.

Manual backup of WCS is :

Start -> program files -> WCS -> backup

Stop WCS:

Start-> program files -> WCS -> StopWCS

dbadmin is under WCSROOT\bin\dbadmin.bat : run as : dbadmin checkschema.

Once this is done, start back WCS : Start-> Program Files -> WCS -> StartWCS

BTW a good troubleshooting of the database is found in this video:

Let me know how it goes.


This Discussion



Trending Topics - Security & Network