Error 29855
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life ora-29855 error occurred in the execution of odciindexcreate Cycles Manage Cases Request Case Start Chat Back to
29855. 00000 - "error Occurred In The Execution Of Odciindexcreate Routine"
results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas
Ora-29855 Error Occurred In The Execution Of Odciindexcreate Routine Ora-20000 Oracle Text Error
Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine Error Message When attempting to create a spatial index on a st_geometry
Maximo Ora-29855: Error Occurred In The Execution Of Odciindexcreate Routine
attribute with SQL, the command fails with the following Oracle error:"ORA-29855 error occurred in the execution of ODCIINDEXCREATE routine". Cause In this specific case, the Oracle error ORA-29855 is being encountered because the parameters string clause contains an unnecessary comma between the st_srid and st_grids ora-06512: at "ctxsys.textindexmethods", line 366 parameters.Code:SQL> CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index 2 parameters('st_srid=12, st_grids=25000');CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index*ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-06502: PL/SQL: numeric or value error: character to number conversion errorORA-06512: at "SDE.SPX_UTIL", line 190ORA-06512: at "SDE.SPX_UTIL", line 696ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 1438 Solution or Workaround The correct syntax for creating the index is the following:Code:SQL> CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index 2 parameters('st_srid=12 st_grids=25000');When creating a spatial index do not insert any commas between the arguments in the parameters clause. Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000010701 Software: ArcSDE 9.2, 9.3, 9.3.1 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact
text; text search; text index; ORA-29855; ctxsys Technote (troubleshooting) Problem(Abstract) java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine during drg-10700 execution of updatedb scripts or configdb Cause Database imported from an failed to read user_sdo_geom_metadata view export of another Oracle database and/or schema Resolving the problem You may receive the following error when running ora-06512: at "mdsys.sdo_index_method_10i", line 10 updatedb.bat or configdb.bat on a database that was imported from and export of a different Oracle database and/or schema. java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: http://support.esri.com/technical-article/000010701 Oracle Text error: DRG-10700: preference does not exist: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364. You could be getting this error because a schema export will not export the Oracle Text preferences and sub-lexer definitions or the database does not have Oracle Text indexing enabled. 1. Restore the database back to the before the start up http://www-01.ibm.com/support/docview.wss?uid=swg21405526 updatedb 2. Follow the steps in the following Technote ORA-29855 Error When Running updatedb 3. If updatedb or configdb failed with the same or similar error continue with the following 4. Repeat steps 1 and 2 then, 5. Connect to the database instance specifying AS SYSDBA 6. Create the MDSYS user with a command in the following format: SQL> CREATE USER MDSYS IDENTIFIED BY
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on https://community.oracle.com/thread/2215634 and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Spatial All PlacesDatabaseOracle Database + OptionsSpatial This discussion is archived 9 Replies Latest reply on Feb 3, 2012 3:57 PM by Ying Hu-Oracle Error while importing data into Oracle error occurred 11gr2 with arcsde 9.3.1 user12134253_xavierite Apr 27, 2011 8:05 AM I am getting error while importing the data into oracle 11g r2. We are using arcsde 9.3.1 It seems to be having some problem with spatial index creation. kindly help IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "A3032_IX1" ON "DGN_POLYLINE_2D" ("SHAPE" ) error occurred in INDEXTYPE IS "MDS" "YS"."SPATIAL_INDEX"" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine 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:AAAT5pAA9AACIy5AAQ] in spatial indexing. ORA-13206: internal error [] while creating the spatial index ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object ORA-06512: at "MDSYS I have the same question Show 0 Likes(0) 1891Views Tags: none (add) arcgisContent tagged with arcgis, creationContent tagged with creation, errorContent tagged with error, esriContent tagged with esri, indexContent tagged with index, sdo_sridContent tagged with sdo_srid, spatialContent tagged with spatial, spatial_indexContent tagged with spatial_index This content has been marked as final. Show 9 replies 1. Re: Error while importing data into Oracle 11gr2 with arcsde 9.3.1 ToM2 Apr 27, 2011 10:32 AM (in response to user12134253_xavierite) Hi, You should check geometry before index creation: 1 using functions validate_geometry_with_context.(function check p