Why midserver username is updating and creating a record in core_company table

[Snow909]

Hello All,

I have an issue where mid- server username is creating/updating a record  in company (core_company) table. We dont want that record to be there. after deleting its getting created and updated and not sure from, where this record is loaded from.

checked the below places.

1. I don't see that record is being brought from import sets , scheduled jobs, scheduled loads and data sources.

2. The record is having the crated and updated timestamp and username(mid server username) same.

3. Even i delete ,next day it is getting added up, not sure where this data is coming from.

4. Checked the normalized company names, dint see that record.

5. Checked the cmdbi_ci table with manufacturer and company  fields, No luck.

Please let me know are there any places where to check or open a support case with Servicenow.

Thanks

[HIROSHI SATOH]

There are no specific sources. I understand that the response is rather vague, making it difficult to resolve the issue. However, I posted this with the hope that it could serve as a reference to investigate the cause more specifically.

[Snow909]

Hello @HIROSHI SATOH  Checked all the above places but no luck in resolving the issue. Any other places to check?

[HIROSHI SATOH]

If there is no explicit setting, it is likely created automatically.

If new/updated entries are being created daily, can you identify the tables that are being imported from the MID Server and look up the company table by created by, created time, updated by, and updated time to identify which table is causing the issue?

Or can you identify the target table from the logs?

I think you should also contact NOW Support at the same time.

[Sumanth16]

Hi @Snow909 ,

Please refer to below thread:

https://www.servicenow.com/community/now-platform-articles/deploying-normalization-data-services/ta-...

Plz mark my solution as Accept, If you find it helpful.

Thanks & Regards,

Sumanth meda

[Selva Arun]

Hi,

Also, please check the below links too:

https://www.servicenow.com/community/itom-forum/updating-manufacture-vendor-table/m-p/957631

https://www.servicenow.com/community/itom-forum/many-records-getting-created-in-core-company-table/m...

https://www.servicenow.com/community/now-platform-articles/deploying-normalization-data-services/ta-...

If you believe the solution provided has adequately addressed your query, could you please **mark it as 'Helpful'** and **'Accept it as a Solution'**? This will help other community members who might have the same question find the answer more easily.

Thank you for your consideration.

Selva