Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"RQSYS.RQEVALIMPL"Line 104->output data.frame doesnot match output specification

gitaish-OracleNov 12 2017 — edited Nov 20 2017

At First the issues seems like script error but apparently some other issue. Below is the snapshot of the architecture.

OFSADV->Working Env

OFSUAT->Non working env.

1. we have a exadata half rack. Which is running on 4 nodes like 4 physical node ip's and 1 scan ip.

2. OFSADV database runs on Node-1 and Node-3 which is the working environment and is in PDB/CDB architecture.

3. OFSUAT is running on Node-3 but is a stand alone database.

4. Oracle R distribution which were RPM's has been installed on all the 4 nodes and (usr/lib64/R is the R home for all, since bank wanted all node IP to have the same image.

5. Now ORE is installed on OFSADV(PDB/CDB->working env, operational for almost 6 months).

6. Again ORE is installed on OFSUAT(Non-Working Env, standalone architecture)

Now when we execute the below scrip in the working environement

begin
sys.rqScriptDrop( 'SID' );
end;
/


begin
sys.rqScriptCreate( 'SID',
'
function(){

return( data.frame(ORACLE_SID = Sys.getenv( "ORACLE_SID" ) ) );
}
'
);
end;
/

select * from table ( rqEval( NULL, 'select ''1234567890123456789123456789'' as ORACLE_SID from dual', 'SID'));

ORACLE_SID

Consildal

But when we run the same query in OFSUAT Environment we get the following error

select * from table ( rqEval( NULL, 'select ''1234567890123456789123456789'' as ORACLE_SID from dual', 'SID'));

select * from table ( rqEval( NULL, 'select ''1234567890123456789123456789'' as ORACLE_SID from dual', 'SID'))

*

ERROR at line 1:

ORA-20000: RQuery error

output data.frame does not match output specification

ORA-06512: at "RQSYS.RQEVALIMPL", line 104

ORA-06512: at "RQSYS.RQEVALIMPL", line 101

This post has been answered by gitaish-Oracle on Nov 20 2017
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 18 2017
Added on Nov 12 2017
6 comments
722 views