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

[Community Alums]

Perhaps it's a business rule running on insert? Check if it's against the company table.

Check if your other instances are doing the same to isolate the issue. 

[Snow909]

I dont see any business rules and most of them are OOB.

[HIROSHI SATOH]

ServiceNow's MID Server acts as an agent to transfer data between on-premises environments and the ServiceNow cloud. If records in the core_company table are being created or updated under the MID Server's username, there are several potential causes and solutions to consider.

Possible Causes

1. Integrations or Scripts:

   • The MID Server is often used for integrations with external systems, so it's possible that data ingestion or synchronization processes are updating the core_company table.
   • Check if integration scripts or ETL (Extract, Transform, Load) processes are targeting the core_company table.

2. Business Rules:

   • Business rules or flows that trigger updates to the core_company table might be set up.
   • Verify these rules or scripts to ensure that none are using the MID Server user.

3. Data Policies and Transform Maps:

   • Transform maps and data policies used during data imports might be adding or updating records in the core_company table.
   • Review these settings to ensure unnecessary records are not being created.

4. Scheduled Jobs on MID Server:

   • Scheduled jobs run by the MID Server might be updating the core_company table.
   • Check the settings of these jobs to understand what operations are being performed.

Solutions

1. Review Integration Settings:

   • Check the integration settings within the ServiceNow instance to see if the core_company table is being updated by any external systems.
   • Adjust the integration settings to prevent unnecessary updates.

2. Check Business Rules:

   • Review business rules related to the core_company table to understand the conditions under which updates are made.
   • Disable or modify these rules as needed.

3. Review Data Policies and Transform Maps:

   • Verify transform maps and data policies used during data imports to prevent unnecessary data creation or updates.
   • Adjust the settings to ensure they do not affect the core_company table undesirably.

4. Examine Scheduled Jobs:

   • Check scheduled jobs run by the MID Server to see if any target the core_company table.
   • Disable or modify unnecessary jobs.

[Slava Savitsky]

May I ask you where you got this information from?