3 Replies Latest reply: May 13, 2013 3:12 AM by user637610 RSS

    chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: OR

    user637610
      Hi,

      if the query where my resource gantt chart is based on returns more the 107 rows, i will get the following error:

      chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      If i reduce the number of results, the chart is working fine.

      Max rows attribute of the series is adjusted to 4000

      Any idea?

      Thank you
        • 1. Re: chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: OR
          Hilary Farrell-Oracle
          Hi,

          You may be hitting the 32k limit for the chart XML being generated for the Gantt chart. Based upon the error you've reported, it sounds like that's the case. To work around this issue, your best option is to create your own custom Gantt chart, which will require the generation of the chart XML in the format expected by AnyChart. If you search on the forum, you'll find a number of related posted (e.g. https://forums.oracle.com/forums/search.jspa?threadID=&q=32k+gantt&objID=f137&dateRange=all&userID=&numResults=15&rankBy=10001). We certainly hope to address the 32k limit in a future release, but in the meantime, the generation of a custom Gantt chart is your best bet. While it's not a gantt example, I've added a map example to my sample application (http://apex.oracle.com/pls/apex/f?p=36648:109), demonstrating one possible method of generating a custom chart via a PL/SQL region and associated PL/SQL function for handling the generation of the XML. It could certainly be modified to work for a Gantt chart.


          Regards,
          Hilary
          • 2. Re: chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: OR
            user637610
            Thank you,

            I have tried it, but it I am not able to make it work, here you find a snip of my pagesource:

            <anygantt> <resource_chart>
            <resources>
            <resource id="341" name="Drexler, Franz" />
            <resource id="5" name="Gross, Johannes-Ludwig" />
            <resource id="8" name="Pecherski, Andrzej" />
            <resource id="131" name="Steinmetz, Raphael" />
            <resource id="191" name="Jenks, Raymond" />
            <resource id="33" name="Alhambra, Roda Marie" />
            <resource id="31" name="Daminescu, Adrian" />
            </resources>
            <periods>
            <period resource_id= "31" start="24-DEC-12 12.00.00.000000000 AM" end="31-DEC-12 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="27-DEC-12 12.00.00.000000000 AM" end="28-DEC-12 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="02-JAN-13 12.00.00.000000000 AM" end="04-JAN-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "131" start="26-JAN-13 12.00.00.000000000 AM" end="04-FEB-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "131" start="01-JAN-13 12.00.00.000000000 AM" end="06-JAN-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "131" start="22-DEC-12 12.00.00.000000000 AM" end="31-DEC-12 12.00.00.000000000 AM" style="green" />
            <period resource_id= "5" start="21-DEC-12 12.00.00.000000000 AM" end="31-DEC-12 12.00.00.000000000 AM" style="green" />
            <period resource_id= "31" start="07-JAN-13 12.00.00.000000000 AM" end="11-JAN-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="21-DEC-12 12.00.00.000000000 AM" end="21-DEC-12 12.00.00.000000000 AM" style="blue" />
            <period resource_id= "33" start="26-DEC-12 12.00.00.000000000 AM" end="28-DEC-12 12.00.00.000000000 AM" style="green" />
            <period resource_id= "33" start="25-FEB-13 12.00.00.000000000 AM" end="25-FEB-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="28-MAR-13 12.00.00.000000000 AM" end="29-MAR-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="09-APR-13 12.00.00.000000000 AM" end="09-APR-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="01-MAY-13 12.00.00.000000000 AM" end="01-MAY-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="12-JUN-13 12.00.00.000000000 AM" end="12-JUN-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="26-AUG-13 12.00.00.000000000 AM" end="26-AUG-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="01-NOV-13 12.00.00.000000000 AM" end="01-NOV-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="30-DEC-13 12.00.00.000000000 AM" end="30-DEC-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="31-DEC-13 12.00.00.000000000 AM" end="31-DEC-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="21-AUG-13 12.00.00.000000000 AM" end="21-AUG-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "33" start="15-OCT-13 12.00.00.000000000 AM" end="15-OCT-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "8" start="23-DEC-13 12.00.00.000000000 AM" end="23-DEC-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="27-DEC-13 12.00.00.000000000 AM" end="27-DEC-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="30-DEC-13 12.00.00.000000000 AM" end="30-DEC-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="02-JAN-14 12.00.00.000000000 AM" end="03-JAN-14 12.00.00.000000000 AM" style="green" />
            <period resource_id= "5" start="31-MAY-13 12.00.00.000000000 AM" end="31-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="21-MAY-13 12.00.00.000000000 AM" end="24-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="27-MAY-13 12.00.00.000000000 AM" end="29-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="31-MAY-13 12.00.00.000000000 AM" end="31-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="02-APR-13 12.00.00.000000000 AM" end="05-APR-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "5" start="11-FEB-13 12.00.00.000000000 AM" end="11-FEB-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "131" start="29-JUN-13 12.00.00.000000000 AM" end="14-JUL-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "131" start="16-AUG-13 12.00.00.000000000 AM" end="16-AUG-13 12.00.00.000000000 AM" style="blue" />
            <period resource_id= "8" start="26-AUG-13 12.00.00.000000000 AM" end="30-AUG-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="02-SEP-13 12.00.00.000000000 AM" end="06-SEP-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="15-FEB-13 12.00.00.000000000 AM" end="15-FEB-13 12.00.00.000000000 AM" style="blue" />
            <period resource_id= "5" start="13-MAR-13 12.00.00.000000000 AM" end="13-MAR-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "8" start="22-MAR-13 12.00.00.000000000 AM" end="22-MAR-13 12.00.00.000000000 AM" style="blue" />
            <period resource_id= "33" start="20-MAR-13 12.00.00.000000000 AM" end="20-MAR-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "5" start="08-APR-13 12.00.00.000000000 AM" end="08-APR-13 12.00.00.000000000 AM" style="blue" />
            <period resource_id= "31" start="05-APR-13 12.00.00.000000000 AM" end="05-APR-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "31" start="02-MAY-13 12.00.00.000000000 AM" end="03-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "341" start="01-JUL-13 12.00.00.000000000 AM" end="22-JUL-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "341" start="09-MAY-13 12.00.00.000000000 AM" end="12-MAY-13 12.00.00.000000000 AM" style="green" />
            <period resource_id= "191" start="04-JUL-13 12.00.00.000000000 AM" end="06-JUL-13 12.00.00.000000000 AM" style="red" />
            <period resource_id= "31" start="15-JUN-13 12.00.00.000000000 AM" end="30-JUN-13 12.00.00.000000000 AM" style="green" />
            </periods>
            </resource_chart></anygantt>
            </textarea>
            <div id="chartDiv"></div>
            <script type="text/javascript" language="javascript">
            /* Set default swf path */
            AnyChart.swfFile = 'i/flashchart/anychart_6/swf/OracleAnyChart.swf';
            /* Create new gantt chart */
            var chart = new AnyChart();
            chart.width="2500";
            chart.height="2500";
            /* Get string data from text area */
            var data = document.getElementById('rowData').value.toString();
            /* Set data */
            chart.setData(data);
            /* Write chart to "chart" div */
            chart.write("chartDiv");
            </script>


            do you have a idea whats wrong? thank you
            • 3. Re: chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: OR
              user637610
              ok figured out that i have to use ganttchart_4 not anychart_6...

              it works, but again only for a subset of data.

              I get:

              is_internal_error: true
              apex_error_code: APEX.REGION.UNHANDLED_ERROR
              ora_sqlcode: -6502
              ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
              component.type: APEX_APPLICATION_PAGE_REGIONS
              component.id: 5442300723550325
              component.name: t
              error_backtrace:
              ORA-06512: at "SYS.DBMS_LOB", line 1064
              ORA-06512: at line 21
              ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
              ORA-06512: at "SYS.WWV_DBMS_SQL", line 1064
              ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 4613
              ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 3220

              Any Idea?