Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
    • Sign In
    • -Exor - Wiki
      • +ALIM Document Manager
      • An Attempt to Reset Your Password Has Failed
      • +AWLRS
      • +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
        • ARCSDE service does not start
        • Can’t create a new section in SM
        • Datum network views will not display new or edited sections
        • Domain index is marked LOADING/FAILED/UNUSABLE error
        • +Hosting/Accessibility - Exor Spatial Manager
        • Install/Upgrade - Exor Spatial Manager
        • Layer created with the GIS Layer tool not visible
        • +Layers/Themes - Exor Spatial Manager
        • Mapviewer service cannot start
        • Network Disappears upon selection
        • ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
        • +Other - Exor Spatial Manager
        • Selecting features does not work or does not select all required features
        • +Startup/Connection Issue - Exor Spatial Manager
        • Streets/ESUs - Exor Spatial Manager
        • Unable to view Street Attributes
        • Unexpected error when trying to login in Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • Remove @ from the AWLRS Local Password Policy
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation
    • How To Import SSL Certificate 11g Weblogic

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

    ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

      Product(s): Exor Spatial Manager
      Version(s): N\A
      Environment: N\A
      Area: Create
      Subarea: N\A

    Error or Warning Message

    On Spatial index rebuilding, the errors below appear:

     

    ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

    ORA-29400: data cartridge error

    ORA-01403: no data found

    ORA-13249: internal error in Spatial index: [mdidxrbd]

    ORA-13249: Error in Spatial index: index build failed

    ORA-13249: Error in spatial index: [mdrcrtxfergm]

    ORA-13249: Error in spatial index: [mdpridxtxfergm]

    ORA-13200: internal error [ROWID:AADshKAAaAAOpeCAAA] in spatial indexing.

    ORA-13206: internal error [] while creating the spatial index

    ORA-13365: layer SRID does not match geometry SRID

    ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 3131

     

    Explanation

    This happens because there are null SRID values in spatial data.

    How to Avoid

    Please note in scripts below the INDEX_NM should be changed to the index name that you have tried to rebuild. Change TABLE_NM to the table_name selected on step 1: GEOLOC -to the name of the column from this table that contains spatial data and SRID to srid value selected on step 3.

     

    1. Connect to your data base using sql plus and find the table on which this index was created. You can use the script below:

     

    select owner, index_name, table_name from all_indexes

    where index_name = 'INDEX_NM' ;

     

    2. Drop the index:

     

    drop index INDEX_NM;

     

    3. Check the SRID set for the table by selecting it from user_sdo_geom_metadata

     

    select srid from user_sdo_geom_metadata where table_name='TABLE_NM';

     

    4. Find the geometry srid used in this table:

     

    select tnm.GEOLOC.sdo_srid, count(*) from TABLE_NM tnm

    group by tnm.GEOLOC.sdo_srid;

     

    5. If script above returns null srid you should update it by running following script:

     

    update TABLE_NM tnm set tnm.GEOLOC.sdo_srid=SRID where tnm.GEOLOC.sdo_srid is null;

     

    6. Commit changes:

     

    Commit;

     

    7.  Create spatial index:

     

    create index INDEX_NM on TABLE_NM(GEOLOC)

    indextype is mdsys.spatial_index;

     

    See Also

    https://communities.bentley.com/products/assetwise/exor/w/wiki/8668

      Original Author: NT
    • Share
    • History
    • More
    • Cancel
    • NT Created by Bentley Colleague NT
    • When: Thu, Mar 16 2017 7:17 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Fri, May 10 2019 12:09 PM
    • Revisions: 5
    • 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

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