8 Replies Latest reply: Jan 11, 2013 6:17 AM by Denis Mukhin RSS

    ORA-29913: error in executing ODCITABLEDESCRIBE callout

    maxijazz
      Hi,
      Database is 11.2.0.3 Solaris SPARC with R 2.13.2 and ORE installed.
      When executing last example from page 39: http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-trng4-embeddedrscripts-1501638.pdf

      select *
      from table(rqTableEval(
      cursor(select ARRDELAY, DISTANCE, DEPDELAY
      from ontime_s
      where year = 2003
      and month = 5
      and dayofmonth = 2),
      cursor(select 1 max1, 1 pos1, 'mod' name1,
      to_number(null) max2, to_number(null) pos2,
      to_char(null) name2, total, chunk, value
      from ontime_lm),
      'select ARRDELAY, DISTANCE, DEPDELAY, 1 PRED from ontime_s',
      'R_TEST_Example3'))
      order by 1, 2, 3;
      select *
      *
      ERROR at line 1:
      ORA-29913: error in executing ODCITABLEDESCRIBE callout

      What could be a problem?

      Regards,
        • 1. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
          Denis Mukhin
          A similar error usually happens in versions before 11.2.0.3 due to a bug that was fixed in 11.2.0.3. Are you sure you are running 11.2.0.3?
          • 2. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
            maxijazz
            Yes, it is 11.2.0.3.4 on Solaris 10 SPARC:

            BANNER
            --------------------------------------------------------------------------------
            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
            PL/SQL Release 11.2.0.3.0 - Production
            CORE 11.2.0.3.0 Production
            TNS for Solaris: Version 11.2.0.3.0 - Production
            NLSRTL Version 11.2.0.3.0 - Production

            and excerpt from opatch lsinventory:
            Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
            Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
            Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
            Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"

            I just confimed I have the same error on another box with base 11.2.0.3.0 (no patches) database installed on Solaris 10 x64.

            Thank you.
            • 3. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
              Denis Mukhin
              Thank you for confirming this. Could, please, paste the R script that you are running so that I can try to reproduce this locally.

              Denis
              • 4. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
                maxijazz
                Here is the code:
                #########################################################################################
                -- build model
                begin
                sys.rqScriptCreate('Example2',
                'function(dat) {
                mod <- lm(ARRDELAY ~ DISTANCE + DEPDELAY, dat)
                mod}');
                end;
                /

                drop table ontime_lm;
                create table ontime_lm as
                select *
                from table(rqTableEval(
                cursor(select ARRDELAY,
                DISTANCE,
                DEPDELAY
                from ontime_s),
                NULL,
                NULL,
                'Example2'));

                -- score data
                begin
                sys.rqScriptCreate('Example3',
                'function(dat, mod) {
                prd <- predict(mod, newdata=dat)
                prd[as.integer(rownames(prd))] <- prd
                res <- cbind(dat, PRED = prd)
                res}');
                end;
                /

                select *
                from table(rqTableEval(
                cursor(select ARRDELAY, DISTANCE, DEPDELAY
                from ontime_s
                where year = 2003
                and month = 5
                and dayofmonth = 2),
                cursor(select 1 max1, 1 pos1, 'mod' name1, to_number(null) max2, to_number(null) pos2,
                to_char(null) name2, total, chunk, value
                from ontime_lm),
                'select ARRDELAY, DISTANCE, DEPDELAY, 1 PRED from ontime_s',
                'Example3'))
                order by 1, 2, 3;
                #########################################################################################

                Thank you.
                • 5. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
                  Denis Mukhin
                  This is a bug in ORE 1.1 on Solaris. We were able to reproduce this issue locally on a SPARC box. On a positive side, we do have a fix for this in ORE 1.3. We have already released ORE 1.3 on Linux and will be releasing both Solaris versions very soon.
                  • 6. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
                    maxijazz
                    Thank you for confirmation!
                    I really appreciate your effort and prompt help!

                    I was already reviewing config on my both Solaris boxes and getting crazy that i missed something after spending few hours without a clue on this...
                    • 7. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
                      User13268327-Oracle
                      Hi Denis,

                      I am trying similar thing on Exadata and getting ORA-29913 error.

                      SQL> select * from table(rqTableEval(cursor(select VISIT_DATE,DRUG_CODE from CLAIMS),NULL,'XML','dprediction2'));
                      select * from table(rqTableEval(cursor(select VISIT_DATE,DRUG_CODE from CLAIMS),NULL,'XML','dprediction2'))
                      *
                      ERROR at line 1:
                      ORA-29913: error in executing ODCITABLESTART callout

                      ORE version is 1.3
                      RDBMS version is 11.2.0.3.0

                      Can you please provide any inputs on this?

                      Regards,
                      Pankaj Ranga
                      • 8. Re: ORA-29913: error in executing ODCITABLEDESCRIBE callout
                        Denis Mukhin
                        Pankaj,

                        Could you, please, paste your script and at least one row from CLAIMS table (and the data types for the columns) so that I can try reproducing it in our environment.

                        Thanks,
                        Denis