jrscullin Posted September 12, 2017 Share Posted September 12, 2017 I get an error publishing a report that runs within Studio. error and jrxml below:org.apache.http.client.HttpResponseException: Invalid JRXML at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:106) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:125) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:52) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:49) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:550) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:328) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:184) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:62) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:303) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) JRXML<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ac_advanced_product_fee_tax_report_v" pageWidth="10040" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="10000" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="daf84dcd-cb3b-4db2-965c-2ed36fa438f5"> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.1" value="pageHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.2" value="pageFooter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.3" value="columnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1" value="columnHeader"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="AirCard Data Adapter"/> <property name="ireport.jasperserver.reportUnit" value="/Reports/AC_ADVANCED_PRODUCT_FEE_TAX_REPORT"/> <property name="ireport.jasperserver.url" value="https://opdev04.multiservice.com:8443/jasperserver-pro-5.6.1/services/repository/"/> <property name="ireport.jasperserver.user" value="jrscullin-ac|aircard"/> <style name="Crosstab Data Text" hTextAlign="Center" hImageAlign="Center"/> <style name="BandStyle"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{ROWCOUNT}.intValue()%new Integer(2).intValue() == 0)]]></conditionExpression> <style backcolor="#91E7EE"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($V{ROWCOUNT}.intValue()%new Integer(2).intValue() != 0)]]></conditionExpression> <style backcolor="#FFFFFF"/> </conditionalStyle> </style> <parameter name="VERSION_NUMBER" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["V1.1.GED.0.0"]]></defaultValueExpression> </parameter> <parameter name="TEMPLATE_VERSION_NUMBER" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["V1.1.AR.1.3"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[WITH columns AS (SELECT /*+ materialize */ * FROM (SELECT 1101 position, 19 type_group, 12000656 phrase FROM DUAL UNION ALL SELECT 1102, 18, 12000655 FROM DUAL UNION ALL SELECT 1103, 0, 12000262 FROM DUAL UNION ALL SELECT 1104, 1, 12001175 FROM DUAL UNION ALL SELECT 1105, 2, 12001176 FROM DUAL UNION ALL SELECT 1106, 4, 12003897 FROM DUAL UNION ALL SELECT 1107, 5, 12003899 FROM DUAL UNION ALL SELECT 1108, 6, 12003900 FROM DUAL UNION ALL SELECT 1109, 7, 12003900 FROM DUAL UNION ALL SELECT 1110, 8, 12004956 FROM DUAL UNION ALL SELECT 1111, 9, 12005101 FROM DUAL UNION ALL SELECT 1114, 16, 12004249 FROM DUAL UNION ALL SELECT 1115, 17, 12008345 FROM DUAL UNION ALL SELECT 1116, 24, 12008790 FROM DUAL UNION ALL SELECT 1118, 20, 12017394 FROM DUAL UNION ALL SELECT 1119, 21, 12017459 FROM DUAL UNION ALL SELECT 1120, 22, 12017460 FROM DUAL)), allp AS (SELECT rri.product_id, ring.product_group FROM r_product_ri rri, r_product_grouping ring, r_product_group_ri rgi WHERE rri.product_id = ring.product_id AND rgi.product_group = ring.product_group), allt AS (SELECT rri.tax_type_id, ring.tax_type_group FROM r_tax_type_ri rri, r_tax_type_grouping ring, r_tax_type_group_ri rgi WHERE rri.tax_type_id = ring.tax_type_id AND rgi.tax_type_group = ring.tax_type_group), allf AS (SELECT rri.fee_type_id, ring.fee_type_group FROM r_fee_type_ri rri, r_fee_type_grouping ring, r_fee_type_group_ri rgi WHERE rri.fee_type_id = ring.fee_type_id AND rgi.fee_type_group = ring.fee_type_group), allnsn AS (SELECT rri.product_id, pdm.nsn_code, pdm.desc_code, pdm.contract, pdm.discounted, pdm.ground_service FROM r_product_ri rri, product_to_desc_map pdm WHERE rri.product_id = pdm.product_id(+)), da AS (SELECT rri.product_id, da.entry_ts FROM r_product_ri rri, dml_audit da WHERE da.table_id = 7 AND da.operation = 'I' -- this Substr just takes all characters infront of the | da.primary key is in product_id|card_type AND rri.product_id = SUBSTR (da.primary_key, 1, INSTR (da.primary_key, '|', 1, 1) - 1) -- takes all characters after the | (i.e. the card type should be 7 or 8) AND ( SUBSTR (da.primary_key, INSTR (da.primary_key, '|', -1, 1) + 1) = 7 OR SUBSTR (da.primary_key, INSTR (da.primary_key, '|', -1, 1) + 1) = 8)), la_nsn_w_noncon AS ( SELECT product_id, 1001 position, 12017628 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.nsn_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'N') GROUP BY product_id), la_nsn_w_discount AS ( SELECT product_id, 1002 position, 12017629 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.nsn_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'N') GROUP BY product_id), la_nsn_w_noncon_gs AS ( SELECT product_id, 1003 position, 12031293 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.discounted = 'N' AND aln.ground_service = 'Y') GROUP BY product_id), la_nsn_w_discount_gs AS ( SELECT product_id, 1004 position, 12031294 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.discounted = 'Y' AND aln.ground_service = 'Y') GROUP BY product_id), la_nsn_w_contract AS ( SELECT product_id, 1005 position, 12017630 phrase, LISTAGG (TO_CHAR (nsn_code), ', ') WITHIN GROUP (ORDER BY nsn_code) VALUE FROM (SELECT DISTINCT product_id, nsn_code FROM allnsn aln WHERE aln.contract = 'Y' AND aln.nsn_code IS NOT NULL) GROUP BY product_id), la_desc_w_noncon AS ( SELECT product_id, 1006 position, 12017631 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'N') GROUP BY product_id), la_desc_w_discount AS ( SELECT product_id, 1007 position, 12017632 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'N') GROUP BY product_id), la_desc_w_noncon_gs AS ( SELECT product_id, 1008 position, 12031295 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'N' AND aln.ground_service = 'Y') GROUP BY product_id), la_desc_w_discount_gs AS ( SELECT product_id, 1009 position, 12031296 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'N' AND aln.desc_code IS NOT NULL AND aln.discounted = 'Y' AND aln.ground_service = 'Y') GROUP BY product_id), la_desc_w_contract AS ( SELECT product_id, 1010 position, 12017633 phrase, LISTAGG (TO_CHAR (desc_code), ', ') WITHIN GROUP (ORDER BY desc_code) VALUE FROM (SELECT DISTINCT product_id, desc_code FROM allnsn aln WHERE aln.contract = 'Y' AND aln.desc_code IS NOT NULL) GROUP BY product_id), all_nsn_desc AS (SELECT * FROM la_nsn_w_noncon UNION ALL SELECT * FROM la_nsn_w_discount UNION ALL SELECT * FROM la_nsn_w_noncon_gs UNION ALL SELECT * FROM la_nsn_w_discount_gs UNION ALL SELECT * FROM la_nsn_w_contract UNION ALL SELECT * FROM la_desc_w_noncon UNION ALL SELECT * FROM la_desc_w_discount UNION ALL SELECT * FROM la_desc_w_noncon_gs UNION ALL SELECT * FROM la_desc_w_discount_gs UNION ALL SELECT * FROM la_desc_w_contract), products AS (SELECT (SELECT FW_Phrase_P.Text (12000593) FROM DUAL) source, rpr.product_id code, (SELECT FW_Phrase_P.Text (rpr.phrase) FROM DUAL) descr, rpr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (rpcr.phrase) FROM DUAL) classification, rpr.internal int, DECODE (rctpra.product_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_product_ri rctpra, r_product_category_ri rpcr, r_product_ri rpr, da WHERE rpr.product_category_id = rpcr.product_category_id AND rpr.product_id = rctpra.product_id(+) AND rctpra.card_type(+) = 7 AND da.product_id(+) = rpr.product_id), fees AS (SELECT (SELECT FW_Phrase_P.Text (12000994) FROM DUAL) source, rftr.fee_type_id code, (SELECT FW_Phrase_P.Text (rftr.phrase) FROM DUAL) descr, rftr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (12000994) FROM DUAL) classification, rftr.internal int, DECODE (rctfra.fee_type_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_fee_ri rctfra, r_fee_type_ri rftr, (SELECT rri.fee_type_id, da.entry_ts FROM r_fee_type_ri rri, dml_audit da WHERE da.table_id = 8 AND rri.fee_type_id = da.primary_key AND operation = 'I') da WHERE rftr.fee_type_id = rctfra.fee_type_id(+) AND rctfra.card_type(+) = 7 AND rftr.fee_type_id = da.fee_type_id(+)), taxes AS (SELECT (SELECT FW_Phrase_P.Text (12000993) FROM DUAL) source, rttr.tax_type_id code, (SELECT FW_Phrase_P.Text (rttr.phrase) FROM DUAL) descr, rttr.settlegate_text sg_text, (SELECT FW_Phrase_P.Text (12000993) FROM DUAL) classification, rttr.internal int, DECODE (rcttra.tax_type_id, NULL, 'No', 'Yes') valid_air, da.entry_ts CREATION_TIME FROM r_card_type_tax_ri rcttra, r_tax_type_ri rttr, (SELECT rri.tax_type_id, da.entry_ts FROM r_tax_type_ri rri, dml_audit da WHERE da.table_id = 9 AND rri.tax_type_id = da.primary_key AND operation = 'I') da WHERE rttr.tax_type_id = rcttra.tax_type_id(+) AND rcttra.card_type(+) = 7 AND da.tax_type_id(+) = rttr.tax_type_id), rownums AS (SELECT rownum row_num, code FROM (SELECT code FROM products UNION ALL SELECT code FROM fees UNION ALL SELECT code FROM taxes ORDER BY code ) )SELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, a.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, VALUE FROM (SELECT * FROM products UNION ALL SELECT * FROM fees UNION ALL SELECT * FROM taxes) a JOIN rownums r ON a.code = r.code JOIN all_nsn_desc b ON a.code = b.product_idUNION ALLSELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, p.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allp.product_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN products p JOIN rownums r ON p.code = r.code LEFT JOIN allp ON allp.product_ID = p.code AND allp.product_group = c.type_groupUNION ALLSELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, f.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allf.fee_type_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN fees f JOIN rownums r ON f.code = r.code LEFT JOIN allf ON allf.fee_type_id = f.code AND allf.fee_type_group = c.type_groupUNION ALLSELECT row_num, (SELECT TO_CHAR(fw_date_p.sys_date, 'MON dd, YYYY HH24:MI:SS') FROM dual) timerun, source, t.code, descr, sg_text, classification, int, valid_air, creation_time, position, fw_phrase_p.text (phrase) phrase, DECODE (allt.tax_type_id, NULL, 'No', 'Yes') VALUE FROM columns c CROSS JOIN taxes t JOIN rownums r ON t.code = r.code LEFT JOIN allt ON allt.tax_type_id = t.code AND allt.tax_type_group = c.type_groupORDER BY code, position]]> </queryString> <field name="ROW_NUM" class="java.math.BigDecimal"/> <field name="SOURCE" class="java.lang.String"/> <field name="CODE" class="java.math.BigDecimal"/> <field name="DESCR" class="java.lang.String"/> <field name="SG_TEXT" class="java.lang.String"/> <field name="CLASSIFICATION" class="java.lang.String"/> <field name="INT" class="java.lang.String"/> <field name="VALID_AIR" class="java.lang.String"/> <field name="CREATION_TIME" class="java.sql.Timestamp"/> <field name="POSITION" class="java.math.BigDecimal"/> <field name="PHRASE" class="java.lang.String"/> <field name="VALUE" class="java.lang.String"/> <field name="TIMERUN" class="java.lang.String"/> <pageHeader> <band height="30"> <textField> <reportElement x="0" y="0" width="752" height="15" uuid="f75a3009-092b-49e7-b543-b5abf7ef1a07"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="11" isBold="true"/> </textElement> <textFieldExpression><![CDATA["AIR Card" + "u00AE"]]></textFieldExpression> </textField> <staticText> <reportElement x="150" y="15" width="452" height="15" uuid="8814dd0a-d26e-4401-a4cf-73c2091170ef"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="11" isBold="true"/> </textElement> <text><![CDATA[Advanced Product Fee Tax Report]]></text> </staticText> <textField pattern=""> <reportElement x="0" y="15" width="150" height="15" uuid="767b64ad-222c-4e3c-8750-346bf5f4a602"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$F{TIMERUN}]]></textFieldExpression> </textField> <elementGroup> <textField> <reportElement x="602" y="15" width="108" height="15" uuid="d0c8b612-ad9b-4e32-9421-96e9281a173e"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="710" y="15" width="42" height="15" uuid="e9bdf76b-9c48-461a-b2b9-7bb05e509c02"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </elementGroup> </band> </pageHeader> <pageFooter> <band height="20"> <textField> <reportElement mode="Opaque" x="225" y="0" width="302" height="20" uuid="e9ffbf79-fdca-4010-b204-a62a9930306f"/> <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> <font size="8"/> </textElement> <textFieldExpression><![CDATA["US Government AIR Card" + "u00AE" + " Information//FOUO/"]]></textFieldExpression> </textField> <textField evaluationTime="Page"> <reportElement x="527" y="0" width="225" height="20" uuid="d187ece2-2027-48ad-85a4-f4cea6803c6d"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[" "]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="0" width="225" height="20" uuid="c9c86107-efa7-482f-90fb-db428d5bce8e"/> <textElement verticalAlignment="Middle"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$P{JASPER_REPORT}.getName() + " " + $P{VERSION_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="45" splitType="Stretch"> <crosstab> <reportElement x="0" y="0" width="10000" height="45" uuid="45eb6ab0-08ef-439f-8532-68a1a1295809"> <printWhenExpression><![CDATA[$V{REPORT_COUNT} > 0]]></printWhenExpression> </reportElement> <crosstabHeaderCell> <cellContents> <box> <pen lineWidth="3.0" lineStyle="Double"/> <topPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> <bottomPen lineWidth="3.0" lineStyle="Double" lineColor="#999999"/> <rightPen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="50" height="30" uuid="cd075cb8-6149-43f8-9974-2b7da70b6b37"/> <box topPadding="2" leftPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[item Type]]></text> </staticText> <staticText> <reportElement x="50" y="0" width="40" height="30" uuid="fbe76095-55a3-4e22-85d8-8d2348ab4511"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[item Code]]></text> </staticText> <staticText> <reportElement x="90" y="0" width="150" height="30" uuid="41c03cad-3161-4a24-884d-3b13dcda342b"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[Product Description]]></text> </staticText> <staticText> <reportElement x="240" y="0" width="120" height="30" uuid="069d1d65-cd3a-4c7e-a8b6-3754ae7f2850"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[settlegate Text]]></text> </staticText> <staticText> <reportElement x="360" y="0" width="80" height="30" uuid="0c79ccc5-c15e-4748-a414-fb52ad7c28ce"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[Classification]]></text> </staticText> <staticText> <reportElement x="440" y="0" width="50" height="30" uuid="a4acf2c2-724f-4cf1-9df6-e1feb932e285"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[internal]]></text> </staticText> <staticText> <reportElement x="490" y="0" width="50" height="30" uuid="0d6c1bb4-97aa-4075-b8fc-50e333d0b7f2"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[Valid For AIR]]></text> </staticText> <staticText> <reportElement x="540" y="0" width="82" height="30" uuid="ae3a9079-76d1-4213-98d6-edc39ac28576"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement verticalAlignment="Bottom"> <font size="8"/> </textElement> <text><![CDATA[Creation Time]]></text> </staticText> </cellContents> </crosstabHeaderCell> <rowGroup name="ROWCOUNT" width="0"> <bucket class="java.math.BigDecimal"> <bucketExpression><![CDATA[$F{ROW_NUM}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents/> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents/> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="CODE" width="622"> <bucket class="java.math.BigDecimal"> <bucketExpression><![CDATA[$F{CODE}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="3" width="50" height="15" uuid="0dc746d5-72a9-48ac-ae29-0890315d03ef"/> <box topPadding="2" leftPadding="2" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{SOURCE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="50" y="3" width="40" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{CODE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="90" y="3" width="150" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{DESCR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="240" y="3" width="120" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{SG_TEXT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="360" y="3" width="80" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{CLASSIFICATION}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="440" y="3" width="50" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{INT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="490" y="3" width="50" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{VALID_AIR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="540" y="3" width="82" height="15" uuid="632397f9-4a5e-4b0c-b5b6-b150ba253a5d"/> <box topPadding="2" leftPadding="3" bottomPadding="2"/> <textElement> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{CREATION_TIME}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents/> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="PHRASE" height="30"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{PHRASE}]]></bucketExpression> <orderByExpression><![CDATA[$V{POSITION}]]></orderByExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box> <bottomPen lineWidth="3.0" lineStyle="Double" lineColor="#999999"/> </box> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="120" height="30" uuid="0b4d14c5-f77a-4033-9f61-b226208a997b"/> <box topPadding="2" bottomPadding="2"> <bottomPen lineWidth="0.0" lineStyle="Double" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{PHRASE}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents/> </crosstabTotalColumnHeader> </columnGroup> <measure name="SOURCE" class="java.lang.String"> <measureExpression><![CDATA[$F{SOURCE}]]></measureExpression> </measure> <measure name="DESCR" class="java.lang.String"> <measureExpression><![CDATA[$F{DESCR}]]></measureExpression> </measure> <measure name="SG_TEXT" class="java.lang.String"> <measureExpression><![CDATA[$F{SG_TEXT}]]></measureExpression> </measure> <measure name="CLASSIFICATION" class="java.lang.String"> <measureExpression><![CDATA[$F{CLASSIFICATION}]]></measureExpression> </measure> <measure name="INT" class="java.lang.String"> <measureExpression><![CDATA[$F{INT}]]></measureExpression> </measure> <measure name="VALID_AIR" class="java.lang.String"> <measureExpression><![CDATA[$F{VALID_AIR}]]></measureExpression> </measure> <measure name="CREATION_TIME" class="java.sql.Timestamp"> <measureExpression><![CDATA[$F{CREATION_TIME}]]></measureExpression> </measure> <measure name="POSITION" class="java.math.BigDecimal"> <measureExpression><![CDATA[$F{POSITION}]]></measureExpression> </measure> <measure name="VALUE" class="java.lang.String"> <measureExpression><![CDATA[$F{VALUE}]]></measureExpression> </measure> <crosstabCell width="120" height="18"> <cellContents> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="BandStyle" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="3" width="120" height="15" uuid="20dedff2-32fd-40e2-8f2a-edc9fe88e347"/> <box topPadding="2" bottomPadding="2"/> <textElement textAlignment="Center"> <font size="8"/> </textElement> <textFieldExpression><![CDATA[$V{VALUE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" columnTotalGroup="PHRASE"> <cellContents/> </crosstabCell> </crosstab> <staticText> <reportElement x="0" y="0" width="752" height="20" uuid="db2a4df4-57be-443b-90f3-ae6d2efbdb40"> <printWhenExpression><![CDATA[$V{REPORT_COUNT} == 0]]></printWhenExpression> </reportElement> <textElement verticalAlignment="Middle"> <font size="8" isBold="false" isItalic="true"/> </textElement> <text><![CDATA[No data returned.]]></text> </staticText> </band> </summary></jasperReport> Link to comment Share on other sites More sharing options...
hozawa Posted September 13, 2017 Share Posted September 13, 2017 Check the log file under jasperserver/WEB-INF/logs to find the "cause by" clause.Also, be sure you are trying to publish to JasperReports Server 6.4.0 server because jrxml files are version dependent. Link to comment Share on other sites More sharing options...
reportdev Posted September 18, 2017 Share Posted September 18, 2017 Even I got this error message using Jasper Server 6.4 and Jasper Studio 6.4After investigation, I found that the machine from which I was publishing was using 32 bit jdk. After installing the 64 bit jdk, tried publishing the report and it worked fine. please check the jdk version Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now