Received transaction fails to load with the following error message ORA-20000: HIG-0547: Invalid geometry.: ORA-13356: adjacent points in a geometry are redundant
This error usually means that the validation has calculated some of the coordinates in the transaction to be incorrect.
Firstly check to see if the same coordinates have been declared at any point within the data you have received. For example are the start and end coordinates of a polyline the same or does a polygon cross itself similar to a figure of 8 formation.
If none of the coordinates are the same then it is possible that your spatial tolerance settings do not allow the coordinates to be as close together as those declared in the transaction. For example if 2 coordinates are less than 50 centimeters apart and you have a spatial tolerance of 0.5, then the above error will be shown as the coordinates will be deemed as redundant. By default we recommend a spatial tolerance of 0.005.
To check the spatial tolerance please try the following:1 – In the highways application on the main menu expand the Exor menu, then GIS Data and open the GIS Layer Tool form2 – In the GIS Layer Tool expand the TMA Manager layer and select the TMA Layer3 – Select the theme you want to check. If the error is complaining about phase coordinates then select Phase and then click the Get Themes button.4 – select the theme at the bottom which is named something similar to TMA_PHASES_TAB5 – click on the expand form button on the right hand side (labelled with >) which should then show you 3 tabs of data on the right, the first of which is SDO Metadata6 – On the SDO metadata tab the spatial tolerance is shown in the last column after the start and end of each spatial dimension.
If you find that your spatial tolerance is set to a lower figure than .005 then you may be able to reset it by refreshing the SDO Metadata as follows:
1 – In the highways application on the main menu expand the Exor menu, then GIS Data and open the GIS Layer Tool form2 – In the GIS Layer Tool expand the Traffic Management Act layer and select the TMA Layer3 – Click the Get Themes button4 – Select the theme at the bottom which is named TMA_PHASES_TAB5 – Click on the Refresh Metadata button6 – On the metadata form tick the Refresh SDO Metadata option and make sure there is not a tick in the Refresh SDE Metadata option7 – Select the ‘Refresh Selected Theme and Child Theme(s)’ option in the Dependency Options8 – Click run9 – Repeat the steps above for any point themes on the same theme type, which for example may be named TMA_PHASES_PT_TAB on the Phases theme.Problem Reference: 68731
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!