1. script to generate the chart with a function line - attached

2. generated aqua script and got Wrapped java.lang.IndexOutOfBoundsException: Index: 1, Size: 1. The generated aqua script is also attached below

3. When i looked into the script once i add a function series - this gets reflected in the chart immediately. but if i do SCRIPT to NEW Window it generate the below script and the function series line is missing. If you can see from the picture, once i generate a function series and then script to new window, the script doesnt take to account the Function series LINE.

So it is basically a problem with the scripting charts and since aqua script depends on it, i get the Wrapped java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

select top 15 * from Orders
GO
.setResultSettings 'Index=1,
    CategoryFields="[OrderID]",
    SeriesFields="[EmployeeID]",
    ShowChart=true,
    ShowToolbar=true,
    Paging=true,
    Split=300,
    Chart="{column,line}",
    RotX=321,
    RotY=-10,
    RotZ=0,
    ZoomScalar=1.0,
    ShowLegend=true,
    ShowGrid=true,
    PieExplode=0.0,
    GroupSmallValues=true,
    SmallValuesThreshold=3.0,
    PieLabelDistance=3.0,
    PieShowLines=false,
    LineWidth=1.0,
    ShowMarkers=true,
    MapShowBackground=false,
    MapShowDetails=false,
    Width=16.0,
    Height=10.0,
    Depth=5.0,
    SeriesSpacing=1.0,
    CategorySpacing=1.0,
    Font="Arial Bold-BOLD-10",
    TopColor="#EBF0F5",
    BottomColor="#D7DCF5",
    PanX=0.0,
    PanY=0.0,
    Lighting=Default,
    View2D=false,
    StackedPercent=false,
    ShowValueAxis=true,
    ReverseValueAxis=false,
    ShowCategoryAxis=true,
    ShowSeriesAxis=true,
    NumericCategoryAxis=false,
    MergeAxis=false,
    SeriesAlias="default,default",
    SeriesFunction="Add ( 0, 1 ) ",
    SeriesSubType=",",
    SeriesColumnType="Cube,Cube",
    SeriesMin="default,default",
    SeriesMax="default,default",
    SeriesColor="default,default",
    SeriesFunctionMetaData="true,true",
    LegendPosition=Top Right,
    LegendWidthType=Fit,
    LegendWidth=100,
    LegendHeightType=Fit,
    LegendHeight=160,
    ShowFixedCategoryCount=false,
    FixedCategoryCount=0'

Generated script aqua script

---------------------------------

// generates an html page which contains grid results and chart.

var conn = aqua.project.getServerConnection('sqlserver2005');
conn.connect();
conn.changeDatabase('Northwind');

// statement 1
aqua.response.write('select top 15 * from Orders');
aqua.response.write('<p>');
dataSet = conn.executeSnapshot('select top 15 * from Orders');


// chart
chart = aqua.chart.newChart();
chart.setDataSource(dataSet);
chart.setSeriesFields("EmployeeID");
chart.setCategoryFields("OrderID");
chart.properties.setBackgroundColorBottom(-2630411);
chart.properties.setBackgroundColorTop(-1314571);
chart.properties.setCategorySpacing(1.0);
chart.properties.setDefaultChartType(1);
chart.properties.setDepth(5.0);
chart.properties.setNumericCategoryAxis(false);
chart.properties.setFixedCategoryCount(0);
chart.properties.setShowFixedCategoryCount(false);
chart.properties.setFont('Arial Bold-BOLD-10');
chart.properties.setGroupSmallValuesThreshold(3.0);
chart.properties.setGroupSmallValues(true);
chart.properties.setHeight(10.0);
chart.properties.setImageWidth(640);
chart.properties.setImageHeight(480);
chart.properties.setShowLegend(true);
chart.properties.setLegendHeight(160);
chart.properties.setLegendHeightType(2);
chart.properties.setLegendPosition(2);
chart.properties.setLegendWidth(100);
chart.properties.setLegendWidthType(2);
chart.properties.setLighting(1);
chart.properties.setLineWidth(1.0);
chart.properties.setShowMarkers(true);
chart.properties.setMapShowBackground(false);
chart.properties.setMapShowDetails(false);
chart.properties.setMergeAxis(false);
chart.properties.setPanX(0.0);
chart.properties.setPanY(0.0);
chart.properties.setPieShowLines(false);
chart.properties.setPieExplode(0.0);
chart.properties.setPieLabelDistance(3.0);
chart.properties.setRotationX(321);
chart.properties.setRotationY(-10);
chart.properties.setRotationZ(0);
chart.properties.setSeriesSpacing(1.0);
chart.properties.setStackedPercent(false);
chart.properties.setWidth(16.0);
chart.properties.setView2D(false);
chart.properties.setZoom(1.0);
chart.properties.setShowValueAxis(true);
chart.properties.setShowCategoryAxis(true);
chart.properties.setShowSeriesAxis(true);
chart.properties.setShowGrid(true);
chart.properties.setChartType(0, 'column');
chart.properties.setColumnType(0, 'Cube');
chart.properties.setShowFunctionMetaData(0, true);
chart.properties.setChartType(1, 'line');
chart.properties.setColumnType(1, 'Cube');
chart.properties.setFunction(1, 'Add ( 0, 1 ) ');
chart.properties.setShowFunctionMetaData(1, true);

url = chart.cache(3600);
aqua.response.write('<img src=').write(url).write('>');
aqua.response.write('<p>');

// grid results
writer = aqua.io.newHtmlWriter();
writer.setTableStyle('background:#ffffe1;');
writer.write(dataSet);
aqua.response.write(writer.toHtml());
aqua.response.write('<p>');