5 Replies Latest reply: Mar 19, 2013 12:09 PM by Denis Mukhin-Oracle RSS

    Error in X11 (unable to start device PNG)

    Artem Khodyaev
      Hello.

      I have a problem with running embedded R script.

      First script runs fine:

      begin
      sys.rqScriptCreate('Example1',
      'function() {
      ID <- 1:10
      res <- data.frame(ID = ID, RES = ID / 100)
      res}');
      end;

      The second one is not so fine:

      select *
      from table(rqEval(NULL,
      'select 1 id, 1 res from dual',
      'Example1'));

      ORA-29400: data cartridge error
      Error in X11(paste("png::", filename, sep = ""), width, height, pointsize, :
      unable to start device PNG
      ORA-06512: на "RQSYS.RQEVALIMPL", line 57
      29400. 00000 - "data cartridge error\n%s"

      Can anyone help me?

      Thanks.
        • 1. Re: Error in X11 (unable to start device PNG)
          Artem Khodyaev
          Hi Sherry,

          Thanks for reply.

          I am using R version 2.13.2 on SPARC Solaris 64-bit.

          capabilities()[["X11"]] function returns me TRUE.

          And I have already solved my problem. I am start virtual framebuffer daemon and add to my Rprofile piece of code:
          Sys.setenv("DISPLAY" = ":1")

          Everything is ok!
          • 2. Re: Error in X11 (unable to start device PNG)
            user592301
            Sherry,

            we have the same problem, when we perform the script:

            SELECT PVALUE
            FROM TABLE (
            rqEval (CURSOR (SELECT 1 "ore.connect" FROM DUAL),
            'select 1 pValue from dual',
            'RF_TTEST_PVALUES'));


            ORA-20000: RQuery error
            Error in X11(paste("png::", filename, sep = ""), g$width, g$height, pointsize, :
            unable to start device PNG
            ORA-06512: a "RQSYS.RQEVALIMPL", line 104
            ORA-06512: a "RQSYS.RQEVALIMPL", line 101.

            we are using R version 2.15.1 on Platform: powerpc-ibm-aix5.3.0.0 (64-bit)

            capabilities()[["X11"]] function returns false


            Thanks.
            • 3. Re: Error in X11 (unable to start device PNG)
              Denis Mukhin-Oracle
              Another option is to disable embedded graphics capture by setting <tt>ore.graphics</tt> to <tt>FALSE</tt>. For you example it will look like this:
              SELECT PVALUE 
              FROM   TABLE(rqEval(
                             CURSOR(SELECT 1 "ore.connect", 0 "ore.graphics" FROM DUAL),
                             'select 1 pValue from dual',
                             'RF_TTEST_PVALUES'));
              Denis
              • 4. Re: Error in X11 (unable to start device PNG)
                maxijazz
                SELECT PVALUE
                FROM TABLE(rqEval(
                CURSOR(SELECT 1 "ore.connect", 0 "ore.graphics" FROM DUAL),
                'select 1 pValue from dual',
                'RF_TTEST_PVALUES'));
                Hi,
                Thats is very good. Is it a way to do it in R client to avoid following error?

                Example:
                ORE> library(ORE)
                ORE> ore.connect(user="rquser", password="pass", sid="TEST", host="r2151", port=1525, all=TRUE)
                Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, :
                Error in try({ : ORA-20000: RQuery error
                Error in X11(paste("png::", filename, sep = ""), g$width, g$height, pointsize, :
                unable to start device PNG
                ORA-06512: at "RQSYS.RQEVALIMPL", line 104
                ORA-06512: at "RQSYS.RQEVALIMPL", line 101

                Regards,
                Max
                • 5. Re: Error in X11 (unable to start device PNG)
                  Denis Mukhin-Oracle
                  Max,

                  We took care of the explicit SQL call in ORE 1.3. We will be taking care of <tt>ore.connect</tt> in the next release.

                  Denis