Error In Executing Odciindexstart
Contents |
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 ora-29902 error in executing odciindexstart() routine ora-20000 oracle text error about Stack Overflow the company Business Learn more about hiring developers or posting drg-50901 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack ora-20000 oracle text error drg-50901 text query parser syntax error 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-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901:
Ora-06512: At "mdsys.sdo_index_method_10i", Line 333
text query parser syntax error on line 1, column 19 up vote 0 down vote favorite SELECT person_no sub_sys_individual_id, nm_e, nm_a, nvl(sex, -1) sex, nvl(prs_nat, -999) prs_nat, person_no, 'NA' prog_where_not_allowed, 'NA' udb_no, person_tp, pass_no FROM ban_inq_tab WHERE contains (nm_e ,'xxstart JUHETI BT MEMED ASMANI%') >0 AND (trans_flag IS NULL OR trans_flag = 'C'); please help me in this issue and getting parser syntax error oracle text share|improve this question ora-13208 edited Nov 5 '14 at 14:43 mmmmmpie 1,4651819 asked Nov 5 '14 at 12:36 Francis John 2928 Does the query work without this: WHERE contains (nm_e ,'xxstart JUHETI BT MEMED ASMANI%') >0 –mmmmmpie Nov 5 '14 at 14:18 yes query is working fine without contains. Help me in handling this reseved word BT –Francis John Nov 6 '14 at 5:33 Its look like OracleText index error –Max Kvt May 7 '15 at 6:50 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The error is causing the BT, which is a reserved word. The solution is described in the Oracle Community forum. share|improve this answer answered Nov 5 '14 at 14:25 mikron 58369 Thanks Mike, In that post they mentioned that putting curly braces {} will solve the issue. But for me now after putting {} no rows returned from the query. –Francis John Nov 6 '14 at 5:31 Help me in handling this reserved word BT –Francis John Nov 6 '14 at 5:34 Try to replace the reserved word BT (Broader Term) with the escape character /. Your search string would be like
where contains (oratand JChem Oracle Cartridge ORA-29902: error in executing ODCIIndexStart() routine ORA-29902: error in executing ODCIIndexStart() routine To watch this topic for replies Register (enables digests) or give email address: Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First View previous topic :: drg-51030: wildcard query expansion resulted in too many terms View next topic Author Message Samantha Joined: 14 Mar 2012 Posts: 36 Back to top Posted:
Examine The Error Messages Produced By The Indextype Code And Take Appropriate Action.
Mon Mar 02, 2015 9:11 amPost subject: ORA-29902: error in executing ODCIIndexStart() routine Hi, I've just created another cartridge user name DATAP which needs to read
Ora-29855: Error Occurred In The Execution Of Odciindexcreate Routine
the compound table of user CHEM which is also a cartridge user. This following query execute fine with user them, but will cause this error when executed from user DATAP. "ORA-29902: error in executing ODCIIndexStart() routine ORA-29540: class chemaxon/jchem/cartridge/JFunctions does not exist http://stackoverflow.com/questions/26757387/ora-29902-error-in-executing-odciindexstart-routine-ora-20000-oracle-text-er ORA-06512: at "JCMV53.JCHEM_CORE_PKG", line 49 ORA-06512: at "JCMV53.JC_IDXTYPE_IM", line 357" What am I missing here? SELECT * FROM CHEM.COMPOUND WHERE (jc_compare(CHEM.COMPOUND.cd_structure, ' 10 11 0 0 0 0 999 V2000 0.4330 0.2500 0.0000 C 0 0 0 0 0 0 1.2990 -0.2500 0.0000 C 0 0 0 0 0 0 1.2990 -1.2500 0.0000 C 0 0 0 0 0 0 0.4330 https://www.chemaxon.com/forum/ftopic13761.html -1.7500 0.0000 C 0 0 0 0 0 0 -0.4330 -1.2500 0.0000 C 0 0 0 0 0 0 -0.4330 -0.2500 0.0000 C 0 0 0 0 0 0 -1.2990 0.2500 0.0000 C 0 0 0 0 0 0 -1.2990 1.2500 0.0000 C 0 0 0 0 0 0 -0.4330 1.7500 0.0000 C 0 0 0 0 0 0 0.4330 1.2500 0.0000 C 0 0 0 0 0 0 1 21 0 0 0 2 32 0 0 0 M END', 't:f tautomerSearch:n') = 1); Thanks. Regards,Samantha Norbert ChemAxon personnel Joined: 08 May 2013 Posts: 144 Back to top Posted: Mon Mar 02, 2015 9:56 amPost subject: Hi Samantha, You are getting the error because DATAP user has no rights to cartridge functions that resides in the schema of your cartridge owner (while CHEM apparently has). You may grant the appropriate privileges via the role given during Cartridge install. Checking the roles granted to a user can be done by: select * from USER_ROLE_PRIVS where USERNAME='SAMPLE'; Best regards, Norbert Samantha Joined: 14 Mar 2012 Posts: 36 Back to top Posted: Mon Mar 02, 2015 10:05 amPost subject: Hi, The user DATAP has the same role privs as CHEM SQL> select * from user_role_privs; USERNAME GRANTED_ROLE ADM DEF OS_ ------------------------------ ------------
Bees(22) Creatures(34) Docbook(1) Gadgets & Gizmos(9) Humanity(1) Humour(3) Linux(36) NetBeans(1) Oracle(87) Personal(4) QDOSMSQ(2) Rants & Raves(36) Raspberry Pi(12) Religion(5) Twitter(1) Uncategorized(1) VirtualBox(3) Welcome(2) Pages http://qdosmsq.dunbar-it.co.uk/blog/2013/05/spatial-indexes-and-oracle-errors-how-to-fix/ About Linux A Tale of Failure, Success and Open Source. Oracle Resources http://dbaforums.org/oracle/index.php?showtopic=9786 Blog Archives Blog Archives Select Month September 2016 (1) August 2016 (4) June 2016 (2) May 2016 (1) March 2016 (2) February 2016 (2) January 2016 (1) December 2015 (1) November 2015 (1) October 2015 (1) September 2015 (1) August 2015 (3) June 2015 (1) April 2015 (2) December 2014 (2) error in November 2014 (1) October 2014 (1) September 2014 (2) August 2014 (2) June 2014 (2) March 2014 (2) January 2014 (1) December 2013 (2) November 2013 (1) September 2013 (1) August 2013 (4) July 2013 (1) June 2013 (3) May 2013 (7) April 2013 (4) March 2013 (4) February 2013 (5) January 2013 (2) December 2012 (3) November 2012 (4) October 2012 (4) error in executing September 2012 (2) August 2012 (5) June 2012 (1) May 2012 (4) April 2012 (3) March 2012 (3) February 2012 (7) January 2012 (3) December 2011 (3) November 2011 (6) October 2011 (1) September 2011 (1) August 2011 (1) July 2011 (1) June 2011 (5) May 2011 (3) April 2011 (1) March 2011 (2) February 2011 (2) January 2011 (3) October 2010 (3) September 2010 (3) August 2010 (5) May 2010 (4) April 2010 (2) March 2010 (3) February 2010 (2) January 2010 (1) December 2009 (2) October 2009 (1) August 2009 (2) July 2009 (3) May 2009 (6) April 2009 (4) March 2009 (4) February 2009 (3) January 2009 (5) Bees Bees For Development Harrogate and Ripon Beekeepers The British Beekeepers' Association Blogroll Greg Rahn Howard J Rogers Jonathan Lewis Julian Dyke Martin CarstenBach Miladin Modrakovic Oracle Optimizer Richard Foote Tanel Poder Charities Bees For Development Non-Believers Giving Aid Wordpress Documentation Spatial Indexes and Oracle Errors. How to fix. Send article as PDF If, like me, you have suffered from ORA-29902 Error in executing ODCIIndexStart() routine errors where Spatial indexes are involved, the
Member No.: 13,502 We have been getting ORA-29902 errors from certain queries against some Oracle 9.2.0.6 databases with Oracle Text. A good example of our queries is shown as follows:SELECT r.id, r.parentid, r.nameFROM assetrefs r INNER JOIN FullTextStrings s ON s.assetid = r.id AND CONTAINS( s.val, 'anyword', 1 ) > 0 WHERE r.parentid = '{583503FF-67E7-431E-93F8-382CCA65F9C5}';The complete error message is shown as follows:11/16/07 01:19:35 ORA-29902: error in executing ODCIIndexStart() routineORA-20000: Oracle Text error:DRG-50901: text query parser syntax error on line 1, column 1 State:S1000,Native:29902,Origin:[Oracle][ODBC][Ora]Now, the tricky things about the error are that1. The error happens ONLY when the parameter for Oracle Text, 'anyword', is passed in by our application via dynamic parameter binding. If we don't use dynamic binding for that parameter, the query runs well and returns correct results;2. The error happens no matter what that 'anyword' is;3. Dynamic parameter binding for the parameter in the non-Oracle-Text constraint, r.parentid = '{583503FF-67E7-431E-93F8-382CCA65F9C5}', does NOT incur any error;4. The error always happens to some Oracle database instances but never happened to other instances. Based on the observation described above, we suspected that our error problem is related to the configuration and/or environment of Oracle Text. Does anyone out there have any idea about what's wrong with the configuration/environment? Any idea how to fix the problem?Your any help is greatly appreciated! chandra_vivek View Member Profile Feb 9 2008, 07:02 AM Post #2 Member Group: Members Posts: 14 Joined: 30-March 06 Member No.: 3,961 QUOTE (spiff @ Jan 30 2008, 10:18 PM) We have been getting ORA-29902 errors from certain queries against some Oracle 9