Error In Executing Odciindexstart Routine
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 ora-29902 error in executing odciindexstart() routine ora-20000 oracle text error site About Us Learn more about Stack Overflow the company Business Learn drg-50901 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question ora-20000 oracle text error drg-50901 text query parser syntax error 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-29902:
Ora-06512: At "mdsys.sdo_index_method_10i", Line 333
error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: 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 ora-13208 help me in this issue and getting parser syntax error oracle text share|improve this question 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 Joh
and 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_ ------------------------------ -------
Mon, 01 June 2009 07:46 navkrish Messages: 189Registered: May 2006 Location: NJ,USA Senior Member All, I have table T1 with column tc1. Tc1 has a domain index on it. CREATE INDEX t1_ID1 ON T1 (tc1) INDEXTYPE IS CTXSYS.CONTEXT; http://www.orafaq.com/forum/t/145890/ For certain words, if I do a search I get below error: SQL> SELECT count(*) http://dbaforums.org/oracle/index.php?showtopic=9786 2 FROM T1 3 WHERE contains (tc1, 'NTI') > 0; SELECT count(*) * ERROR at line 1: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 4 Any idea? Thanks, NavKrish Report message to a moderator Re: Oracle Text error [message #406000 is a error in reply to message #405992] Mon, 01 June 2009 08:47 Michel Cadot Messages: 63861Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator DRG-50901: text query parser syntax error on line %(1)s, column %(2)s *Cause: bad query *Action: fix query *Mnemonic: PE_SYNTAX Regards Michel Report message to a moderator Re: Oracle Text error [message #406008 is a reply to message #406000] Mon, 01 June 2009 10:08 Barbara Boehmer Messages: 8603Registered: error in executing November 2002 Location: California, USA Senior Member Any time that you try to search for a word that has special meaning to Oracle Text or a stopword or some such thing, without escaping it, you are likely to get a syntax error. "NTI" has special meaning to Oracle Text, as documented here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqoper.htm#sthref1132 You can find a list of such words here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqspcl.htm#sthref1319 So, you need to escape it, as documented here: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqspcl.htm#sthref1309 Please see the demonstration below, that first reproducers the error, then corrects it by using curly brackets to escape the special word. SCOTT@orcl_11g> CREATE TABLE t1 (tc1 VARCHAR2(30)) 2 / Table created. SCOTT@orcl_11g> INSERT INTO t1 VALUES ('NTI') 2 / 1 row created. SCOTT@orcl_11g> CREATE INDEX t1_id1 ON t1 (tc1) INDEXTYPE IS CTXSYS.CONTEXT 2 / Index created. SCOTT@orcl_11g> SELECT * FROM t1 WHERE CONTAINS (tc1, 'NTI') > 0 2 / SELECT * FROM t1 WHERE CONTAINS (tc1, 'NTI') > 0 * ERROR at line 1: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 4 SCOTT@orcl_11g> SELECT * FROM t1 WHERE CONTAINS (tc1, '{NTI}') > 0 2 / TC1 ------------------------------ NTI SCOTT@orcl_11g> [Updated on: Mon, 01 June 2009 10:11]Report message to a moderator Re: Oracle Text error [message #4
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.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 n