Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA 13356 adjacent points in a geometry are redundant
    • Sign in
    • -Exor - Wiki
      • +ALIM Document Manager
      • +AWLRS
      • Exor Accidents Manager
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • +Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • +Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA API and Web Service
      • -Exor TMA Noticing Manager
        • Add new promoter or contractor contact
        • Additional Notice Date Validation
        • Agreement Tab not active
        • Application freezes when sending notices
        • Attachments in work reference cannot be seen
        • Change contact number in works form
        • Check an Inspection Batch has sent
        • Click in heading blanks other fields
        • Closed notice phase status at in progress
        • Constraint Error Sending Notice TNSC_TNSI_FK Violated
        • Daily Failed Transactions Alert
        • Defective Apparatus Notice
        • Differing values in drop down list - Apex
        • Error changing report parameter or opening TMA1000
        • Error Entering Parameters for TMA5110 Report
        • Error in send notice BPEL process
        • Error loading notice
        • Error opening locator from TMA1000 Works Form
        • Error Opening Locator from TMA1110 Restrictions Form
        • Error opening TMA1000 Works form
        • Error reported on TMA Works Phase Master Refresh process
        • Error Running Inspection Scheduler
        • Error running reports
        • Error sending inspection file
        • EToN6 inspections - checking for duplicates
        • Exor TMA How to create Next years Sample inspection Profile
        • Exor TMA Inspection Received at Error
        • Exor TMA unable to view street in Works
        • Failure accessing WMS theme.
        • FRM 41035 error when select notice type
        • FTP Anonymous Server Access
        • Getting error ORA 02290 check constraint
        • HIG-0169: Database constraint violated: TNSW_UK
        • How to add to the 'NON SWA Type' Drop down
        • How To Allow Different Date Formats To Be Entered In Any Form
        • How to check if a notice was sent / received
        • How to configure TMA Attachments
        • How to Delete a notice
        • How to fetch results on Review Notices form(TMA1030)
        • How to issue a Non Notifiable Phase – For Core Sampling
        • How to locate the .net wsdl file
        • How to remove and add recipients from S58s
        • How To Respond To A Temporary Traffic Signal Application
        • How to retrieve count of notices
        • HTTP transport error sending notices
        • Incoming inspections fail to load
        • Incorrect Section 74 Charge
        • Inspection Private Comments Overwritten
        • +Inspections - Exor TMA Noticing Manager
        • Interim Construction Method Warning Missing
        • Invalid enumeration value 0
        • Invalid XML error when sending notice
        • Issue with number of phases in new activity
        • Issuing FPNs
        • Java soap error when sending notices
        • MAI TMA Interface
        • Major Works 3 Months Notice FPN
        • Many Inspection Records Updated
        • Missing Phase Data
        • New Street Group Using List of NE_IDs
        • New User Cannot Send Notices
        • No Domains Available After Server Restart
        • No notice type for informal overrun warning
        • Non SWA diversion route notice warning
        • Notice issued but cannot find in Monitor Form
        • Notice Sent OK but Not Received
        • Notice sequence number repeated error
        • Notice went out of sequence in TMA3000
        • +Notices - Exor TMA Noticing Manager
        • Opening the EXOR Application Directly to TMA1000 Works Form
        • ORA 13356 adjacent points in a geometry are redundant
        • ORA-20001 error performing TMA upgrade
        • +Other - Exor Noticing Manager
        • +Other - Exor TMA Noticing Manager
        • PAA permit application has deemed early
        • Proximity Validation warning
        • Raise works on type 3 or 4 street
        • Received Transaction at Pending Processing status
        • Received Transactions stuck at Web Service Complete
        • Report not returning all records
        • Report not returning enough records
        • Report Not Shown
        • +Reports - Exor Noticing Manager
        • +Reports - Exor TMA Noticing Manager
        • +Restrictions - Exor Noticing Manager
        • Restrictions error so unable to send updates
        • Restrictions not sending to a Utility
        • Revoke Cancel FPN
        • Sample Inspection Quotas Report Figures Too Low
        • Scheduler only assigns to 1 inspector
        • Sender Does not Exist in NSG Error
        • Sent Transaction stuck at Pending Send status
        • Some DCD Inspections Not Downloaded
        • Start date for Major Notices
        • +Street Groups - Exor Noticing Manager
        • Street of Interest or Lane Rental Check Box
        • Telephone number in inspection batch file
        • The XML page cannot be displayed Cannot view XML input using XSL style sheet
        • TMA 0101 error opening tma1000 or tma3000 forms
        • Tma error issuing notice in TMA1001
        • TMA Non Categorised Inspection - No Inspection Items
        • TMA Proximity Validation Warning
        • TMA Receive Transactions process stuck
        • TMA Version 4.5.10 Functionality
        • TMA Works Phase Master refresh: error in materialized view path
        • TMA-0085 Error Opening TMA1000 Works Form
        • TMA-0093 Invalid Enumeration Value "15" Error
        • TMA-0139 Error not found in NM_ERRORS during category changes in Works form
        • TMA1001 error. TMA-0093
        • Transaction at Error status instead of Copy Recipient Fail
        • +Transactions - Exor Noticing Manager
        • +Transactions - Exor TMA Noticing Manager
        • Type 4 Street Used On Works
        • Unable to change one type of issued Direction notice type to another
        • Unable to create TMA housekeeping process
        • Unable to find inspection
        • Unable To Issue A Notice To A Particular Recipient
        • Unable to issue FPN on cancelled notice
        • Unable To Issue Permit Response
        • Unable to Query a Specific Works or Inspection Record
        • Unable to select street
        • Unable to select the Promoter/Contractor contact on Phase Details tab
        • Unable to send notice
        • Unable to send notice for phase
        • Unable to use Links->Works function
        • Warning not shown as expected
        • Web Help not working
        • What is the difference between created and modified dates
        • Where to enter Skips scaffolding Events or Diversion
        • +Works - Exor Noticing Manager
        • +Works - Exor TMA Noticing Manager
        • Works not shown in conflicts tab
        • Works On Private Streets
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • +Transportation Intelligence Gateway
      • +Video Series for Exor
      • Working From Home with Exor

     
     Questions about this article, topic, or product? Click here. 

    ORA 13356 adjacent points in a geometry are redundant

       
      Applies To 
       
      Product(s): Exor TMA Manager
      Version(s): 4300
      Environment:  N/A
      Area:  N/A
      Subarea:  N/A
      Original Author: Bentley Technical Support Group
       

     

     

     

     

     

     

     

     

    Problem

     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

    Solution

     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 form
    2 – In the GIS Layer Tool expand the TMA Manager layer and select the TMA Layer
    3 – 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_TAB
    5 – 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 Metadata
    6 – 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 form
    2 – In the GIS Layer Tool expand the Traffic Management Act layer and select the TMA Layer
    3 – Click the Get Themes button
    4 – Select the theme at the bottom which is named TMA_PHASES_TAB
    5 – Click on the Refresh Metadata button
    6 – On the metadata form tick the Refresh SDO Metadata option and make sure there is not a tick in the Refresh SDE Metadata option
    7 – Select the ‘Refresh Selected Theme and Child Theme(s)’ option in the Dependency Options
    8 – Click run
    9 – 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

    See Also

    Product TechNotes and FAQs

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    Comments or Corrections?

    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!

     

    • EXOR TMA API AND WEB
    • Monitor Transactions
    • 68731
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Wed, Sep 25 2013 4:16 PM
    • EdvinasP Last revision by Bentley Colleague EdvinasP
    • When: Mon, Oct 27 2014 8:31 AM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies