CSWEB data configuration setting : Dictionary addition throws error : integrity constant violation

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Post Reply
parthsaha
Posts: 13
Joined: March 8th, 2021, 11:16 am

CSWEB data configuration setting : Dictionary addition throws error : integrity constant violation

Post by parthsaha » June 6th, 2021, 11:31 am

Dear All,

I have added a dictionary in CSWEB data configuration setting to process data to another MySQL database. First dictionary was added and is working fine.

But when I try to add another dictionary using "Add configuration", CSWEB throws error : integrity constant violation.
Failed to add configuration for XXXX_DICT. SQLSTATE[23000]:
Integrity constraint violation: 1062 Duplicate entry 'mysqldbname' for key 'schema_name'
Do we need to add new MySQL database for each dictionary???

I am very new to CSWEB. Please help!!!

Thanks.

Parth Saha

savy
Posts: 68
Joined: December 27th, 2012, 1:36 pm

Re: CSWEB data configuration setting : Dictionary addition throws error : integrity constant violation

Post by savy » June 7th, 2021, 10:52 am

Yes, when configuring dictionary for blob breakout each dictionary should have a different database.

Post Reply