This discussion is archived
8 Replies Latest reply: Jan 11, 2013 4:17 AM by Denis Mukhin RSS

ORA-29913: error in executing ODCITABLEDESCRIBE callout

maxijazz Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    852638 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points