Error Ora 29875
without it enabled. Please turn JavaScript back on and reload this page.All Places > GIS > Managing Data > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routDiscussion created by mousaem on Feb 4, 2012Latest reply on Sep 10, 2012 by staspinar Like • Show 0 Likes0 Comment • 3Hi,i have a feature class that is versioned with st_geometry storage. when i try to edit it using ArcMap with an Oracle user that has the full editing privileges i receive the following error:Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-00942: table or view does not existORA-06512: at "SDE.SPX_UTIL", line 925ORA-06512: at "SDE.SPX_UTIL", line 960ORA-06512 at "SDE.ST_DOMAIN_METHODS", line 1906however, when i try editing layer using the "schema owner", i don't receive this error !!! and editing works fine.My Geodatabase environment is:DBMS: Oracle 11g R2ArcSDE Version: ArcSDE 10 SP2Unix Server: IBM AIX 6.1The layers are hosted in a "user-schema geodatbase".Please check the attached error message.can somebody help?Thanks,AttachmentsERROR Message.jpg107.5 KBOutcomesVisibility: Managing Data4508 ViewsLast modified on Feb 4, 2012 6:27 PMTags:managing_dataContent tagged with managing_datagdbContent tagged with gdb_geodatabaseContent tagged with _geodatabaseThis content has been marked as final. Show 3 comments3 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website Addressmvisekru Feb 6, 2012 5:43 AMHave you checked the SDE schema of the user-schema geodatabase for any invalid objects? I have come across this issue and resolved it by recompiling the SPX_UTIL package.Like • Show 0 Likes0 Actions mousaem Feb 6, 2012 6:09 PMThanks for your feedback.I did recompile SPX_UTIL package under "SDE" schema, and it recompiled successfully (it was not initially invalid).However, when i try to put the layer in ArcMap again i receive the following error:Error: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLERegards,Like • Show 0 Likes0 Actions staspinar Sep 10, 2012 4:34 AMHi,You have some unusable spatial indexes which you can find by executing this SQL:SQL> SELECT owner,index_name,table_name from all_indexes where domidx_status
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle https://geonet.esri.com/thread/98415 User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-29875 Error Description: http://psoug.org/oraerror/ORA-29875.htm Failed in the execution of the ODCIINDEXINSERT routine Error Cause: Failed to successfully execute the ODCIIndexInsert routine. Action: Check to see if the routine has been coded correctly. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 208 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
the ODCIIndexInsert routine. Action: Check to see if the routine has http://www.oracle-error.com/8i/ora-29875.html been coded correctly. Version 10g failed in the execution http://stackoverflow.com/questions/36597303/ora-29875-error-on-serial-inserting-into-full-text-indexed-table of the ODCIINDEXINSERT routine Cause: Failed to successfully execute the ODCIIndexInsert routine. Action: Check to see if the routine has been coded correctly. Version 9i failed in the execution of the ODCIINDEXINSERT routine Cause: Failed to successfully execute the error ora ODCIIndexInsert routine. Action: Check to see if the routine has been coded correctly. Version 8i failed in the execution of the ODCIINDEXINSERT routine Cause: Failed to successfully execute the ODCIIndexInsert routine. Action: Check to see if the routine has been coded correctly. This entry was posted in Oracle 10g error ora 29875 Errors, Oracle 11g Errors, Oracle 8i Errors, Oracle 9i Errors, Oracle Database Server Messages. Bookmark the permalink. Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Currently you have JavaScript disabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page. Click here for instructions on how to enable JavaScript in your browser. Search for: Recent Commentsabhi on ORA-24237oracle-error on ORA-24237abhi on ORA-24237Mike TAILOR on ORA-12154oracle-error on ORA-39776Support services ? Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support Archives April 2015 Categories EXP Messages Oracle 10g Errors Oracle 11g Errors Oracle 8i Errors Oracle 9i Errors Oracle Database Server Messages Recent Posts XML-30017 XML-30016 XML-30014 XML-30013 XML-30012 Oracle-Error.com 2016Zerif Lite powered by WordPress
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-29875 error on serial inserting into full text indexed table up vote 0 down vote favorite I'm working on utility that adds all files in directory as entries to database and indexes them. My code itself works fine, but after exactly 297 inserts (always, checked on another document collection) i got following error java.sql.SQLException: ORA-29875: nie uda?o si? wykona? podprogramu ODCIINDEXINSERT ORA-20000: DRG-50857: ORA-20000: Oracle Text error:initialization failed ORA-06512: przy "CTXSYS.DRUE", linia 160 ORA-06512: przy "CTXSYS.TEXTINDEXMETHODS", linia 756 Any ideas what could be cause of this error? In my table there is FTINDEX column and entries have this value set to IGNORE. Using Java 1.7, Eclipse, Oracle 12c, OJDBC6 Driver. java oracle share|improve this question asked Apr 13 at 11:42 ShirouWrath 192219 1 Maybe you must include your table definition, your code for inserting a new row and the specific data that is causing the exception i.e the 297th file properties to be stored. –RubioRic Apr 13 at 11:51 1 @RubioRic Thanks, i will include some data. However it's not problem with a file itself as i tried to swap it with first one, process still failed. –ShirouWrath Apr 13 at 12:04 1 You might want to have a look at this question and its "correct" answer on OTN. I don't know if this applies in your case but it might be helpful. Best of luck. –Bob Jarvis Apr 13 at 12:07 1 @BobJarvis Thanks a lot for a clue, meanwhile i found a cause - it was unclosed cursor. I was just confused by error message. :) –ShirouWrath Apr 13 at 12:56 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged java oracle or ask your own question. asked 6 m