cancel
Showing results for 
Search instead for 
Did you mean: 

CPQ - Duplicate Entry .. for key 'PRIMARY'

Former Member
0 Kudos

Hello all,

I did a CPQ Product Configuration Initial Load and I am getting errors like this...

 com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '700-PRODUCT_R3' for key 'PRIMARY'

.......

   INFO  [data loader requester] [conn_jdbc] Try to reconnect due to:
     com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'cpq.cnav__a_sap109'

What is wrong here?

hybris version - 5.7.0.8 hybris CPQ - 2.3.3

See attached log file..

[1]: /storage/temp/5111-cpq-errors.txt

former_member623616
Contributor
0 Kudos

Hi Jay,

were you able to resolve this issue ? we are also facing the same issue. it would be really helpful if you can share the solution, if it's resolved for you.

Thanks, Yaten

Accepted Solutions (0)

Answers (2)

Answers (2)

VinayKumarS
Active Contributor
0 Kudos

Yes this issue will occur when we create a database with default collation. Please update the database collation to utf8_general_ci or any other Case Insensitive to fix the issue.

I have faced the same problem. After I modified the collation it fixed the issue.

Former Member
0 Kudos

Hi,

it could be a sorting problem in your database collation. Which SQL Server are you using do you use a collation like utf8_general_ci?