How to add same vendor name in core_company table

rahul16
Giga Guru

we have the same vendor name but a different account number when I try to create a new record with the same name I get this error - Unique Key violation detected by the database.

 

How can I add the new vendor records to core_company table

rahul16_0-1667402692165.png

 

3 REPLIES 3

Mike_R
Kilo Patron
Kilo Patron

Check to see if that field is set to "Unique" in your instance

instance.service-now.com/nav_to.do?uri=sys_db_object.do?sys_id=11adda22a5300110c0a0e1db2cdc95c1

 

Mike_R_0-1667401825666.png

 

AnubhavRitolia
Mega Sage
Mega Sage

Hi @rahul16 

 

I tried to create record in Company table with same Name and Vendor true but I did not got any error.

 

Can you please share screenshot of error you are getting.

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

Unique Key violation detected by database ((conn=978) Duplicate entry '+sA1cK1qA6mJ1gDkGJQ==' for key 'djyeyqzt_canonical_hash_inde')

rahul16_0-1667402638537.png