VERIFIED SOLUTION i

Resolve "Error while updating entity key: 'xxxxxxxxx' in map. Exception: 'Unable to insert new map feature" in Confirm

Product Feature: Mapping


 

Issue

The following error is encountered when running the Referential Integrity Agent:

2015-07-03 14:56:27.1092 : : 6212 : 20 : Find in transaction 7453346 (EntityTransactionWithConnection) SQL: SELECT central_enquiry.enquiry_number, central_enquiry.enquiry_desc, central_enquiry.enquiry_time, central_enquiry.enquiry_name, central_enquiry.enquiry_address, central_enquiry.service_code, central_enquiry.subject_code, central_enquiry.enq_class_code, central_enquiry.site_code, central_enquiry.enquiry_log_number, central_enquiry.printed_flag, central_enquiry.enquiry_phone, central_enquiry.property_ref, central_enquiry.enquiry_phone_2, central_enquiry.enquiry_fax, central_enquiry.email_address, central_enquiry.logged_date, central_enquiry.login_name, central_enquiry.officer_code, central_enquiry.enq_status_code, central_enquiry.follow_up_date, central_enquiry.log_text, central_enquiry.follow_up_code, central_enquiry.log_effective_date, central_enquiry.outstanding_flag, central_enquiry.commit_log_number, central_enquiry.ext_system_number, central_enquiry.ext_system_ref, central_enquiry.enquiry_reference, central_enquiry.enquiry_easting, central_enquiry.enquiry_northing, central_enquiry.urgent_flag FROM central_enquiry WHERE central_enquiry.enquiry_number = xxxxxxxxx
2015-07-03 14:56:27.1092 : : 6212 : 20 : Find took 15 ms
2015-07-03 14:56:27.1248 : : 6212 : 20 : Find item took 31 ms to load 1 objects
2015-07-03 14:56:27.1248 : : 6212 : 20 : Commit transaction: 7453346
2015-07-03 14:56:27.1717 : : 6212 : 20 : No coordinates supplied.
2015-07-03 14:56:27.1873 : : 6212 : 20 : [User ID:SBS; Licence:CONF03098A; Tenant ID:taskprocessorlive]Error while updating entity key: 'xxxxxxxxx' in map. Exception: 'Unable to insert new map feature'. Stack Trace: at MapInfo.Confirm.Application.ReferentialIntegrity.CoreMapping`1.InsertMapFeature(T entity)
at MapInfo.Confirm.Business.Mapping.ReferentialIntegrity.ModifiedEntityProcessor.UpdateEntity(IEntityModify entity)
at MapInfo.Confirm.Business.Mapping.ReferentialIntegrity.ModifiedEntityProcessor.ProcessEntity(IEntityModify entityModify)

Cause

The error message will contain the reason for the error, the example above says '2015-07-03 14:56:27.1717 : : 6212 : 20 : No coordinates supplied.' which indicates the entity reported has no coordinates to map.

Resolution

UPDATED: October 4, 2017
Check the entity type for the entity key reported and then check whether the entity has coordinates.

In the example above the entity is an enquiry so the entity key maps to the enquiry number. Check the enquiry to make sure it has coordinates and has been mapped. If no coordinates then map the enquiry and rerun the RI agent. This will resolve the error.