CMDBuild Forum

Again upload report failed

Hello,

I created a new simple report, but upload of the images (only 2) failed.  I got following warning:
INFO  2016-12-12 16:41:32 [jsonrpc ] Calling url /schema/modreport/importjasperreport
ERROR 2016-12-12 16:41:39 [jsonrpc ] A org.cmdbuild.exception.ReportException occurred calling method class org.cmdbuild.servlets.json.schema.ModReport.importJasperReport: REPORT_UPLOAD_ERROR Expected image 'Banner.png' not found in uploaded data
org.cmdbuild.exception.ReportException: REPORT_UPLOAD_ERROR Expected image 'Banner.png' not found in uploaded data
      at org.cmdbuild.exception.ReportException$ReportExceptionType.createException(ReportException.java:13)
      at org.cmdbuild.servlets.json.schema.ModReport.importSubreportsAndImages(ModReport.java:602)
      at org.cmdbuild.servlets.json.schema.ModReport.importJasperReport(ModReport.java:551)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

I see in /usr/share/apache-tomcat-8.0.33/temp the following files:
-rw-r--r-- 1 root root  12574 Dec 12 16:44 upload_e98385e3_91e5_46f6_90fd_0dcb52a8f1e5_00000015.tmp
-rw-r--r-- 1 root root 505442 Dec 12 16:45 upload_e98385e3_91e5_46f6_90fd_0dcb52a8f1e5_00000016.tmp

The first file (*15.tmp) is my report.jrxml
The second file (*16.tmp) is my "Banner.png"

So actually the file "PhilipsLogo.png" isn't uploaded.  Besides that the report isn't loaded, the message is wrong also.

I'm running CMDBuild 2.4.1 and 2.4.2 and on both versions the download fails.

Hi,
you could check differences from your implementation to our CMDBuild online demo "Location list with assets" report wich has two images, right and left logo.
Zip file is downloadable from report administration module.
 
CMDBuild Team
 
 
 
 
 
Previously Eric wrote:

Hello,

I created a new simple report, but upload of the images (only 2) failed.  I got following warning:
INFO  2016-12-12 16:41:32 [jsonrpc ] Calling url /schema/modreport/importjasperreport
ERROR 2016-12-12 16:41:39 [jsonrpc ] A org.cmdbuild.exception.ReportException occurred calling method class org.cmdbuild.servlets.json.schema.ModReport.importJasperReport: REPORT_UPLOAD_ERROR Expected image 'Banner.png' not found in uploaded data
org.cmdbuild.exception.ReportException: REPORT_UPLOAD_ERROR Expected image 'Banner.png' not found in uploaded data
      at org.cmdbuild.exception.ReportException$ReportExceptionType.createException(ReportException.java:13)
      at org.cmdbuild.servlets.json.schema.ModReport.importSubreportsAndImages(ModReport.java:602)
      at org.cmdbuild.servlets.json.schema.ModReport.importJasperReport(ModReport.java:551)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

I see in /usr/share/apache-tomcat-8.0.33/temp the following files:
-rw-r--r-- 1 root root  12574 Dec 12 16:44 upload_e98385e3_91e5_46f6_90fd_0dcb52a8f1e5_00000015.tmp
-rw-r--r-- 1 root root 505442 Dec 12 16:45 upload_e98385e3_91e5_46f6_90fd_0dcb52a8f1e5_00000016.tmp

The first file (*15.tmp) is my report.jrxml
The second file (*16.tmp) is my "Banner.png"

So actually the file "PhilipsLogo.png" isn't uploaded.  Besides that the report isn't loaded, the message is wrong also.

I'm running CMDBuild 2.4.1 and 2.4.2 and on both versions the download fails.

 

Previously Tecnoteca wrote:

Hi,
you could check differences from your implementation to our CMDBuild online demo "Location list with assets" report wich has two images, right and left logo.
Zip file is downloadable from report administration module.
 
CMDBuild Team
 
I have downloaded the report from the demo site.  Found following differences:
Header of my .jrxml file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 3.6.2  -->
<!-- 2016-12-13T12:50:22 -->
<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="PDU_Usage" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="CMDBuild"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <style name="Title" lineSpacing="Single" fontName="Arial" fontSize="26" isBold="true"/>
    <style name="SubTitle" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="18"/>
    <style name="Column header" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="12" isBold="true"/>
    <style name="Detail" lineSpacing="Single" fontName="Arial" fontSize="12"/>
    <queryString>
        <![CDATA[SELECT
        PDU."PDUInputGroup"             AS "Input Group",
        LPIF."Description"              AS "Input Fase",
:

Image section "Banner.png":
<image isUsingCache="true">
                <reportElement x="275" y="0" width="280" height="64"/>
                <imageExpression class="java.lang.String"><![CDATA["Banner.png"]]></imageExpression>
            </image>
Image section "Philips_Logo.png":
<image hAlign="Center" vAlign="Middle" isUsingCache="true">
                <reportElement x="248" y="0" width="25" height="26">
                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>

                </reportElement>
                <imageExpression class="java.lang.String"><![CDATA["Philips_Logo.png"]]></imageExpression>
            </image>

The header is different, but CMDBuild recognizes the report and knows 2 images are required (as shown in second screen after saving the .jrxml file, two entries shown for both images).  It loads the report (the .jrxml file) and the image "Banner.png" but doesn't download the "Philips_log.png".  It then reports that it couldn't download the "Banner.png" file ?

Strange is that i created another report (same jaspersoft studio) with same template and images and this installs without any problem.

 

We could debug this problem directly on your database to find real cause. If this procedure it's fine for you contact us by mail to tecnoteca@tecnoteca.com.
 
CMDBuild Team
 
 
 
 
Previously Eric wrote:
Previously Tecnoteca wrote:
Hi,
you could check differences from your implementation to our CMDBuild online demo "Location list with assets" report wich has two images, right and left logo.
Zip file is downloadable from report administration module.
 
CMDBuild Team
 
I have downloaded the report from the demo site.  Found following differences:
Header of my .jrxml file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 3.6.2  -->
<!-- 2016-12-13T12:50:22 -->
<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="PDU_Usage" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="CMDBuild"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <style name="Title" lineSpacing="Single" fontName="Arial" fontSize="26" isBold="true"/>
    <style name="SubTitle" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="18"/>
    <style name="Column header" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="12" isBold="true"/>
    <style name="Detail" lineSpacing="Single" fontName="Arial" fontSize="12"/>
    <queryString>
        <![CDATA[SELECT
        PDU."PDUInputGroup"             AS "Input Group",
        LPIF."Description"              AS "Input Fase",
:

Image section "Banner.png":
<image isUsingCache="true">
                <reportElement x="275" y="0" width="280" height="64"/>
                <imageExpression class="java.lang.String"><![CDATA["Banner.png"]]></imageExpression>
            </image>
Image section "Philips_Logo.png":
<image hAlign="Center" vAlign="Middle" isUsingCache="true">
                <reportElement x="248" y="0" width="25" height="26">
                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>

                </reportElement>
                <imageExpression class="java.lang.String"><![CDATA["Philips_Logo.png"]]></imageExpression>
            </image>

The header is different, but CMDBuild recognizes the report and knows 2 images are required (as shown in second screen after saving the .jrxml file, two entries shown for both images).  It loads the report (the .jrxml file) and the image "Banner.png" but doesn't download the "Philips_log.png".  It then reports that it couldn't download the "Banner.png" file ?

Strange is that i created another report (same jaspersoft studio) with same template and images and this installs without any problem.

 

 

Previously Tecnoteca wrote:

We could debug this problem directly on your database to find real cause. If this procedure it's fine for you contact us by mail to tecnoteca@tecnoteca.com.
 
CMDBuild Team
 
 
 
 
Previously Eric wrote:
Previously Tecnoteca wrote:
Hi,
you could check differences from your implementation to our CMDBuild online demo "Location list with assets" report wich has two images, right and left logo.
Zip file is downloadable from report administration module.
 
CMDBuild Team
 
I have downloaded the report from the demo site.  Found following differences:
Header of my .jrxml file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 3.6.2  -->
<!-- 2016-12-13T12:50:22 -->
<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="PDU_Usage" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="CMDBuild"/>
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <style name="Title" lineSpacing="Single" fontName="Arial" fontSize="26" isBold="true"/>
    <style name="SubTitle" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="18"/>
    <style name="Column header" forecolor="#666666" lineSpacing="Single" fontName="Arial" fontSize="12" isBold="true"/>
    <style name="Detail" lineSpacing="Single" fontName="Arial" fontSize="12"/>
    <queryString>
        <![CDATA[SELECT
        PDU."PDUInputGroup"             AS "Input Group",
        LPIF."Description"              AS "Input Fase",
:

Image section "Banner.png":
<image isUsingCache="true">
                <reportElement x="275" y="0" width="280" height="64"/>
                <imageExpression class="java.lang.String"><![CDATA["Banner.png"]]></imageExpression>
            </image>
Image section "Philips_Logo.png":
<image hAlign="Center" vAlign="Middle" isUsingCache="true">
                <reportElement x="248" y="0" width="25" height="26">
                    <property name="com.jaspersoft.studio.unit.x" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.y" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>

                </reportElement>
                <imageExpression class="java.lang.String"><![CDATA["Philips_Logo.png"]]></imageExpression>
            </image>

The header is different, but CMDBuild recognizes the report and knows 2 images are required (as shown in second screen after saving the .jrxml file, two entries shown for both images).  It loads the report (the .jrxml file) and the image "Banner.png" but doesn't download the "Philips_log.png".  It then reports that it couldn't download the "Banner.png" file ?

Strange is that i created another report (same jaspersoft studio) with same template and images and this installs without any problem.

 

 Hello Team,

I was able to solve this issues.  It turns out that the way the query is written c.q. how te reports is generated influences the download of the report.  It looks that if the interpreter of the jrxml file has a problem, the downloads fails.

Eric