0 Replies Latest reply: Aug 2, 2014 8:40 PM by 2719138 RSS

    ORE Intergration in SAMPLE APP version 406

    2719138

      Hi Guru

       

      So I downloaded the latest Sample Application version 406 to test out the Oracle R integration, however I am keeping having trouble displaying (under 8.40 ORE Integration) the 'R Sourcing from CEIM' and 'R Sourcing from CEIM (end-user page)' . I follow the instruction to download the additional R scripts package and install them, but still getting the following error on the dashboard page. Thanks!

       

      Error Details

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 20000, message: ORA-20000: RQuery error Error in library("RJDBC") : there is no package called ‘RJDBC’ ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 112 ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 109 at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

      SQL Issued: SET VARIABLE OR_PERSP_THETA=30, ORE_PARAM1='cursor(select 0 from dual)', ORE_PARAM2='cursor(select 550 "ore.png.height", 550 "ore.png.width",1 "ore.connect" from dual)', OR_PERSP_PHI=30, OR_REDDOTS=50, PREFERRED_CURRENCY='USD', ORE_SCRIPTNAME='Enhanced Bar Plot', OR_PERSP_COLOR='red', ORE_SCRIPTNAME='Multivariate Star Plot', DISABLE_CACHE_HIT=1, DISABLE_CACHE_SEED=1; SELECT 0 s_0, DESCRIPTOR_IDOF("R - ORE Sample"."ORE Graphics"."Image") s_1, "R - ORE Sample"."ORE Graphics"."Image" s_2, SORTKEY("R - ORE Sample"."ORE Graphics"."Image") s_3 FROM "R - ORE Sample" FETCH FIRST 5000001 ROWS ONLY

       

       

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 20000, message: ORA-20000: RQuery error Error in library(RJDBC) : there is no package called ‘RJDBC’ ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 112 ORA-06512: at "RQSYS.RQTABLEEVALIMPL", line 109 at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

      SQL Issued: SET VARIABLE OR_PERSP_THETA=30, ORE_PARAM1='cursor(select 1 n from dual)', ORE_PARAM2='cursor(select q''"Time"."T03 Per Name Qtr"'' "dim1", q''"Products"."P2 Product Type"'' "dim2", q''"Base Facts"."2- Billed Quantity"'' "metric", q''Time."T05 Per Name Year"=^2010^'' "cond", 650 "ore.png.height", 650 "ore.png.width", q''skyblue'' "dcol" from dual)', OR_PERSP_PHI=30, OR_REDDOTS=50, PREFERRED_CURRENCY='USD', ORE_SCRIPTNAME='Enhanced Bar Plot', OR_PERSP_COLOR='red', ORE_SCRIPTNAME='Balloon Plot', DISABLE_CACHE_HIT=1, DISABLE_CACHE_SEED=1; SELECT 0 s_0, DESCRIPTOR_IDOF("R - ORE Sample"."ORE Graphics"."Image") s_1, "R - ORE Sample"."ORE Graphics"."Image" s_2, SORTKEY("R - ORE Sample"."ORE Graphics"."Image") s_3 FROM "R - ORE Sample" FETCH FIRST 5000001 ROWS ONLY


      Also, when I try to manually install the RJDBC package in the terminal it gives me the follow error


      [root@demo R]# Rscript --verbose -e 'install.packages("RJDBC_0.2-2.tar.gz",repos=NULL,lib="/app/oracle/app/oracle/product/12.1.0/dbhome_1/R/library")'

      running

        '/usr/lib64/R/bin/R --slave --no-restore -e install.packages("RJDBC_0.2-2.tar.gz",repos=NULL,lib="/app/oracle/app/oracle/product/12.1.0/dbhome_1/R/library")'

       

      ERROR: dependency ‘rJava’ is not available for package ‘RJDBC’

      * removing ‘/app/oracle/app/oracle/product/12.1.0/dbhome_1/R/library/RJDBC’

      Warning message:

      In install.packages("RJDBC_0.2-2.tar.gz", repos = NULL, lib = "/app/oracle/app/oracle/product/12.1.0/dbhome_1/R/library") :

        installation of package ‘RJDBC_0.2-2.tar.gz’ had non-zero exit status

      [root@demo R]#