francis.pang

I have some performance issue which I am not sure it is lying in the Jaspersoft AJAX or Jaspersoft Server processing. I received an 502 Proxy error. <variable name="var_amount_difference" class="java.lang.Double" resetType="Group" resetGroup="Fruit" calculation="Sum">[/code]I will like to know if it is possible to configure the Log setting in either the log_setting.html or in the Log4j setting files to see the log for calculating the variable?

Hi hozawa, I do not think that the issue lies with the Connection Timeout. In normal setting, there will be response with wording such as "Connecting via RESTv2", then "Connecting via SOAP". But my studo lies dead on this page. UPDATE: I found out the solution to the issue. As suspected, it is issue with Ubunut 16 LTS with Eclipse. You have to set --launcher.GTK_version2 before the line: --launcher.appendVmargsMore information can be found at here.

I have set up a local JasperServer on my machine, and when I wanted to test out the connection. The studio hangs there. I cannot close the whole studio. An error message "Wizard can not be closed to due to an active operation. You must cancel the operatiuon before you can close the wizard". This test connection normally don't last more than 10 seconds, but I have been waiting over an hour for this.

I am getting the error when I am publishing my report to JasperReports Server. I am not too sure if I have selected the right options: 1. Choose the report to be published. 2. Choose all the resources (auto-populated) to Publish 3.Use the pre-defined data source And then I will get the error as shown above.

This is the most complete error I can give.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2016-04-11T13:25:51 --><jasperReportxmlns="http://jasperreports.sourceforge.net/jasperreports"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreportshttp://jasperreports.sourceforge.net/xsd/jasperreport.xsd"name="REPORT204" pageWidth="1550" pageHeight="842"orientation="Landscape" columnWidth="1510" leftMargin="20"rightMargin="20" topMargin="20" bottomMargin="20"isSummaryWithPageHeaderAndFooter="true"uuid="139ea73b-023b-49f9-af84-9f8b2c2df58d"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="InformixDataAdapter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.pageFooter" value="pageFooter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.columnHeader" value="columnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.title" value="title"/> <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> <property name="ireport.jasperserver.user" value="superuser"/> <property name="ireport.jasperserver.report.resource"value="/test/George/SPPLNew/REPORT204MarketTemplateSummaryReport_files/main_jrxml"/> <property name="ireport.jasperserver.reportUnit"value="/organizations/organization_1/Reports/SPPL/REPORT204MarketTemplateSummaryReport"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <parameter name="p_businessday" class="java.sql.Timestamp"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA[newjava.sql.Timestamp((new Date()).getYear(),(new Date()).getMonth() ,(newDate()).getDate(),00,00,00,00)]]></defaultValueExpression> </parameter> <parameter name="p_updated_to" class="java.sql.Timestamp"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA[newjava.sql.Timestamp((new Date()).getYear(),(new Date()).getMonth() ,(newDate()).getDate(),23,59,59,00)]]></defaultValueExpression> </parameter> <parameter name="p_datetime_from" class="java.sql.Timestamp"/> <parameter name="p_datetime_to" class="java.sql.Timestamp"/> <queryString language="SQL"> <![CDATA[select tabnamefrom systableswhere tabid = 1]]> </queryString> <field name="tabname" class="java.lang.String"/> <variable name="v_decimalformat" class="java.text.DecimalFormat" calculation="System"> <initialValueExpression><![CDATA[new DecimalFormat("#.00")]]></initialValueExpression> </variable> <variable name="v_report_execution_date" class="java.util.Date" calculation="System"> <initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression> </variable> <title> <band height="134" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="330" height="30" uuid="061cc727-426c-4dc7-a009-545ede9e380d"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="16" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[Market Template Summary Report]]></text> </staticText> <staticText> <reportElement x="860" y="0" width="110" height="30" uuid="6cc04786-8f15-4519-862d-cacce6633cba"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="13" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[Printing date:]]></text> </staticText> <textField pattern="dd-MMM-yyyy HH:mm:ss"> <reportElement x="970" y="0" width="180" height="30" uuid="1b767dcb-e5e9-45ad-97ab-daf3f59815ef"/> <textElement verticalAlignment="Bottom"> <font size="13"/> </textElement> <textFieldExpression><![CDATA[DATEFORMAT($V{v_report_execution_date},"dd-MMM-yyyyHH:mm:ss")]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="50" width="190" height="30" uuid="d42e2bad-7943-424c-804e-a40d32fb12a8"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="13" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[start Bet settled at Date]]></text> </staticText> <staticText> <reportElement x="0" y="80" width="190" height="30" uuid="89ddcefb-e82e-49ae-ad7c-2f37ea3a56d9"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="13" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[End Bet settled at Date]]></text> </staticText> <textField pattern="dd-MMM-yyyy HH:mm:ss"> <reportElement x="197" y="50" width="150" height="30" uuid="05a5c1fc-3b18-4c19-b0e0-20e4af693c7d"/> <textElement verticalAlignment="Bottom"> <font size="13"/> </textElement> <textFieldExpression><![CDATA[DATEFORMAT($P{p_datetime_from},"dd-MMM-yyyyHH:mm:ss")]]></textFieldExpression> </textField> <textField pattern="dd-MMM-yyyy HH:mm:ss"> <reportElement x="197" y="80" width="150" height="30" uuid="f3453b47-2aae-40dd-8734-d49b991eab38"> <property name="local_mesure_unitwidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textElement verticalAlignment="Bottom"> <font size="13"/> </textElement> <textFieldExpression><![CDATA[DATEFORMAT($P{p_datetime_to},"dd-MMM-yyyyHH:mm:ss")]]></textFieldExpression> </textField> <staticText> <reportElement x="190" y="80" width="10" height="30" uuid="65be39d0-acea-40a3-a799-40f6b97700f1"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="13" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[:]]></text> </staticText> <staticText> <reportElement x="190" y="50" width="10" height="30" uuid="f0ab1eae-64f7-4adf-92cf-a28c134e915f"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font size="13" isBold="true"/> <paragraph lineSpacing="1_1_2"/> </textElement> <text><![CDATA[:]]></text> </staticText> </band> </title> <pageFooter> <band height="30"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <frame> <reportElement x="1" y="0" width="1509" height="30" uuid="2dc63351-3856-499b-b9b6-a19f3aa06c2c"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </frame> <textField> <reportElement x="1308" y="1" width="100" height="28" uuid="82ae0cae-09a3-482d-9ecc-0b976166eae3"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="1408" y="1" width="100" height="28" uuid="fd8984be-f300-4fea-a4a0-8e39b7a716d2"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="287"> <subreport> <reportElement x="1" y="0" width="1509" height="280" uuid="9edb3de5-336a-407c-949b-810f69a243a0"/> <subreportParameter name="p_settled_from"> <subreportParameterExpression><![CDATA[$P{p_datetime_from}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_settled_to"> <subreportParameterExpression><![CDATA[$P{p_datetime_to}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["repo:marketTemplateSummaryReport_detail"]]></subreportExpression> </subreport> </band> </summary></jasperReport>[/code]This is the error: