How to add same vendor name in core_company table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2022 07:58 AM - edited 11-02-2022 08:25 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2022 08:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2022 08:13 AM
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.
Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2022 08:22 AM - edited 11-02-2022 08:24 AM
Unique Key violation detected by database ((conn=978) Duplicate entry '+sA1cK1qA6mJ1gDkGJQ==' for key 'djyeyqzt_canonical_hash_inde')