Page 1 of 1

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

Posted: June 6th, 2021, 11:31 am
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

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

Posted: June 7th, 2021, 10:52 am
by savy
Yes, when configuring dictionary for blob breakout each dictionary should have a different database.