VERIFIED SOLUTION i
X

Resolve Confirm - Mapping - "An error occured while creating the Confirm Database Map Layer, updating the Map Catalog Failed. Please refer to the Feature Group Help Page For more information." error when trying to set up the Confirm Database Map Layer

Issue

 "An error occured while creating the Confirm Database Map Layer,  updating the Map Catalog Failed. Please refer to the Feature Group Help page for more information." error when trying to set up the Confirm Database Map Layer in a Feature Group.

Cause

The problem may be caused by invalid geometry data in the sp_geography column of the Confirm Feature table in the database.

Invalid data can be identified by running the following SQL against a Confirm SQL Server database :

SELECT site_code, plot_number, sp_geography.STAsText()
  FROM feature
WHERE feature.sp_geography.STIsValid ( ) = 0;

Any rows returned indicate invalid geometry.

Resolution

UPDATED: April 18, 2017


Contact Pitney Bowes Technical Support who will supply the update SQL to fix the invalid geometry. 

Note: This may make minor adjustments/corrections to the positions of some Feature geometries, so backing up the contents of the Feature table before running the update statement would be recommended

Environment Details

Product Feature: mapping


 

Downloads

  • No Downloads