Why am I unable to delete core_company records

[Mark Wood]

Hello everyone,

I have two records named ServiceNow HelpDesk and ServiceNow Helpdesk. When I try to delete both records, I encounter the following error:
"Deleting ServiceNow HelpDesk is not allowed because it is referenced in the record ServiceNow HelpDesk within the Software Publisher table."

Could anyone please guide me on why this issue is occurring? I have attached a screenshot for reference.

Thank you!

[Runjay Patel]

Hi @Mark Wood ,

This is beacuse there is records associated with same company in table "Software Publisher ". In order to delete it from core_company table you need to remove "ServiceNow HelpDesk and ServiceNow Helpdesk" all reference from "Software Publisher " table.

Navigate to ""Software Publisher" table and look for company name "ServiceNow HelpDesk and ServiceNow Helpdesk" , remove the reference from all record which contains these company and then delete it from company table.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Community Alums]

Hi @Mark Wood ,

To resolve, you will need to go to your records  and remove the reference to the record you are trying to delete.   Once that reference to your record has been removed from ALL locations, you should be able to delete.

[Sohail Khilji]

Hi @Mark Wood ,

Your unable to delete the record because the record that your trying to delete has a reference to may other records, you need to clear or delete the dependency then try to delete the record that must do the job. i hope this 2liner helps..

[Rishi Kendale]

Thank you @Runjay Patel , @Community Alums , @Sohail Khilji  for the solution.

Hi @Mark Wood,

If the record is referring to one or more tables, it is not allowed to delete the record until all the references are removed/deleted.

In your case the record you are trying to delete is referenced only in Software Publisher table. You can do it with 2 approaches :

 1. Kindly change "Manufacturer" field value in software publisher table entry. Make sure that the core company value "ServiceNow Helpdesk" is nowhere used as Manufacturer in Software Publisher table. Then you can delete the core company value.

2. Kindly delete the records in software publisher table which use "ServiceNow Helpdesk' as a Manufacturer field value. Once deleted, it will allow you to delete core company record. Already suggested by others.

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Warm regards,

Rishikesh Kendale