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

Unanswered Question
Apr 14th, 2010

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

WCS 6.0.132.0+

Anybody run into this?  Simple fix?

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

Thanks!

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
sschmidt Wed, 04/14/2010 - 14:35

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

Sschmidt,

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.

Attachment: 
Lucien Avramov Wed, 04/21/2010 - 11:14

This could be a few things. run a wcs backup before taking any other action.

1.run 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

Lucien,

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

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:

http://www.youtube.com/watch?v=0KQUfszmTJg

Let me know how it goes.

Actions

This Discussion

 

 

Trending Topics - Security & Network