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