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

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
parthsaha
Posts: 15
Joined: March 8th, 2021, 11:16 am

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

Post by parthsaha »

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: 159
Joined: December 27th, 2012, 1:36 pm

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

Post by savy »

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