[Getting exception while loading adhoc view in jasperserver-pro 5.5]

It is failing because you have a space in the column name. To fix do this:

Edit WEB-INF/applicationContext-adhoc-dataStrategy.xml file. Find the section below and comment out the "escapedVariableChars" property as shown: 

   <bean id="newClassicDataStrategy"

          class="com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy"

          parent="commonDomainDataStrategy"

          scope="prototype">

        <!-- need to get to the slFactory because you don't have a schema -->

        <property name="semanticLayerFactory" ref="semanticLayerFactory"/>

        <!-- enable escaping for field names in topic that may be special to DomEL -->

      <!-- COMMENT OUT THE LINE BELOW

        <property name="escapedVariableChars" value=" .-:"/>

        END COMMENT -->

    </bean>

 

Restart and it should work now.

 

[Getting exception while loading adhoc view in jasperserver-pro 5.5]

What I have found so far is that the reports that throw this error are ones that are broken in the source system already. I'm still checking, but so far none of the reports that failed to convert work in the original system either. They reference tables that don't exist (in my case). Hope that helps.

[Getting exception while loading adhoc view in jasperserver-pro 5.5]

I am encountering the same error. Have you found a solution?

[Problem with replacing report in Ireport. SAXException: Bad Envelope tag]

I ran into this same problem in JasperReports Server 4.1.0. It turned out that I had set iReports compatibility level to 4.0.1, but I didn't save it after changing the settings. Once I saved the report again, I was able to load it successfully to the repository.