pspjasper
-
Posts
30 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by pspjasper
-
-
After installing Jasperserver 7.2 (Linux installer) without errors using Tomcat9 (not bundled) the Web Application Manager page shows the Jasperserver application but it can't be started.
Following suggestion below I found this error :
...2019-09-25 13:42:12,971 ERROR ContextLoader,http-nio-8081-exec-15:350 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jasperJMXServerConnector' defined in ServletContext resource [/WEB-INF/applicationContext-diagnostic.xml]: Invocation of init method failed; nested exception is java.io.IOException: Cannot bind to URL [rmi://localhost:10990/jasperserver]: javax.naming.NameAlreadyBoundException: jasperserver [Root exception is java.rmi.AlreadyBoundException: jasperserver]... [/code]
I realize that what I am working on a single machine and trying to move my configuration from Jasperserver6.x + Tomcat bundled to Jasperserver 7.x + Tomcat 9 NOT bundled.
So at the moment I need to temporary have 2 version of Jasperserver both "alive" modifing config files accordingly.
-
I'm working with TIBCO Jaspersoft® Studio 6.6.0 and my need is to create a report based on a query listing n parent keys. For each key I need 2 subreports based on 2 different queries both filterd by the parent key.
The structure consists in a group based on the key (with pagebreak), in the group I define 2 details and in each detail I add a subreport passing the field key as the corresponding parameters.
When only 1 of the 2 subqueries returns some result the report in correct but when both return the results are rendered twice in the sequence
detail1 detail2 detail1 detail2
I'm not used to work with the xml source code but I add it below hoping it helps finding the problem/error.
Any solution or diffrentapproach will be appreciated.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.6.0.final-->
<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="test" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="917f0b13-a12d-4ba1-b9e4-2deaaebf5f2d">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Xenia12 Data Adapter "/>
<parameter name="ID" class="java.lang.String"/>
<parameter name="KC" class="java.lang.String"/>
<queryString language="SQL">
<![CDATA[select *
from sp_v_ddt_testa
where KEY = $P{ID}
and KEY_DELIVERY = nvl( $P{KC} ,KEY_DELIVERY)]]>
</queryString>
<field name="KEY" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="KEY"/>
</field><group name="KEY_DELIVERY" isStartNewPage="true">
<groupExpression><![CDATA[$F{KEY_DELIVERY}]]></groupExpression>
<groupHeader>
<band height="30">
<textField>
<reportElement x="0" y="0" width="100" height="30" uuid="14944b42-27e2-435b-97f0-0d8657f66ae8"/>
<textFieldExpression><![CDATA[$P{ID}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="330" y="0" width="100" height="30" uuid="b0cb4c4b-3543-4eff-933b-09e4ef0e83d2"/>
<textFieldExpression><![CDATA[$F{KEY}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="440" y="0" width="100" height="30" uuid="04ef2988-c5d2-442f-b2d3-10078d0f7bea"/>
<textFieldExpression><![CDATA[$F{KEY_DELIVERY}]]></textFieldExpression>
</textField>
</band>
</groupHeader>
</group>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="70" splitType="Stretch">
<subreport>
<reportElement isPrintRepeatedValues="false" x="0" y="0" width="550" height="70" uuid="7430fc99-11e2-4615-ab9c-9e615b4b9c0e"/>
<subreportParameter name="ID">
<subreportParameterExpression><![CDATA[$F{KEY}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="KC">
<subreportParameterExpression><![CDATA[$F{KEY_DELIVERY}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["test1.jasper"]]></subreportExpression>
</subreport>
</band>
<band height="70">
<subreport>
<reportElement isPrintRepeatedValues="false" x="0" y="0" width="550" height="70" uuid="94f18fa4-8331-436d-8c4c-f924febf602b"/>
<subreportParameter name="ID">
<subreportParameterExpression><![CDATA[$F{KEY}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="KC">
<subreportParameterExpression><![CDATA[$F{KEY_DELIVERY}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["test2.jasper"]]></subreportExpression>
</subreport>
</band>
</detail> -
Hi,
I am using Jaspersoft Studio 6.4.0 and Jaspersoft Server (not pro) 6.3.0 .
I have developed a webapp that call a report passing a parameter via rest v2 web service and open the PDF in the browser when the user requests.
Now in order to fullfill a new request my need is to generate programmatically a list of values for the parameter, for each generate a report and store the PDF in a path (FTP or FileSystem).
I found here something about modify a schedule by editing the XML but I don't understand how to.
I am looking for a solution in the community and reading the documentation but, if possible, I need to be pointed in the right direction.
Thanks in advance for any help or suggestion.
-
Hi,
I am facing a similar request because I already use parameters in SQL Query to generate a report with several pages (PDF) but my need is ,if possible, to generate different single page reports.
Thanks in advance for any help or sugestion.
-
I upload a report based on Oracle 12 (jdbc:oracle:thin:@myhost:1521/mydb) database to server but trying to run this error is raised:
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:63) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1725) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1086) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1015) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:908) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:898) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:920) at java.lang.Thread.run(Thread.java:736) Caused by: java.sql.SQLRecoverableException: IO Error: Unknown host specified at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at java.sql.DriverManager.getConnection(DriverManager.java:322) at java.sql.DriverManager.getConnection(DriverManager.java:358) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.getOriginalConnection(TibcoDriverManagerImpl.java:186) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:77) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) ... 9 more Caused by: oracle.net.ns.NetException: Unknown host specified at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:191) at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320) ... 23 more[/code]
Thanks in advance for any help or suggestion.
-
I am trying to restart Jasperserver but the error is raised
No way to understand what is going on ... all reports ara unvailable.
Thanks to those who have time to spend helping.
My env is:
- JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.131-3.b12.el7_3.x86_64/jre
Apache Tomcat/8.0.14 1.8.0_51-b16 Oracle Corporation Linux 3.10.0-514.21.2.el7.x86_64 - /jasperreports-server-cp-6.3.0
-
Hi all,
i am working with Jaspersoft Studio 6.0.2 final and JasperReport Server 5.6.1.
I create a sample report with several Static Text for testing different "size" of the same OCR font previously copied in WindowsFont.
The preview in Studio is ok.
Uploading to the server and generating online is ok.
BUT when trying to save from either Studio or server to PDF the font is "lost".
Thanks to any help or suggestions that point me in the right way.
-
Hi all,
how can i set the path of "myReport" folfer in jasper Studio?
Thanks to all
-
Hi all,
I have several reports developed in iReport 5.6.0 and use them in Oracle Apex via "Opal Integration"
Now i'am working in w7 and when modified a report the preview was fine and working and the compile end successfully.
When i call the report via browser as usual a sub report is missed but other are not.
Update:download Jasper Studio 6.2.0 final in order to manage and organize the "passage" of all report to the new program but the error still remain.
Please help!
Thanks a lot.
UPDATE :Dec 22 2015
i found that the problem is the font used in subreport ... and not only there. The subreport is not lost but the font is "invisible" infact other text fields in the main report that use the same size of font are invisible too.
I create a simply report that query SYSDATE from my connection and place in the detail section 5 text fileds shiwing sysdate with font size from 6 to 14.
The preview is correct and if i save the PDF it is correct too.
If i call the report via Apex the text fields has ALL the same size.
The "point" that separate "before" and "now" is that i pass to w7 but i think the problem could be the Acrobat Reader version? Or fonts installed in my os?
At this moment i bypass the problem setting the Markup property of text field to HTML and writing the query in order to add a style attribute to the result where i need it.
Nobody face the same problem? Something wrong in my config?
-
Hi all,
i am usign Jaspersoft iReport Designer 5.0.1
My need is to use a layout that in other reporting products is known as "repeater" and used for example to print labels in different format.
Gived a query that return n rows the need is to display x number of rows for each page/group.
Thanks to all for help or suggestions.
-
Hi all i am trying to use jasperserver web services in apex in order to access report via url.
The login service http://myHost:8080/jasperserver/rest/login?j_username=adminusername&j_password=adminpassword correctly return the cookie and a valid JSESSIONID.
Trying the report service http://myHost:8080/jasperserver/rest/report/apex/Blank_A4&ID=850 the returned response is :
Any help or suggestion to point me in the right direction will be truly appreciated.
-
Thanks nthapa,
in this case is not enough to set the report permissions for the role_anonymous to read only or run only but i need to create a user with a password to use when generating the web service url?
In my case i need to use the report in another web application and access them generating an html tag href.
In this way user:password are public and readable.
No way to access the server exporting as anonymous user?
-
I found the same file here
./buildomatic/conf_source/ieCe/applicationContext-events-logging.xml
and the server restart correctly.
-
I surely follow your suggestion but i think that my file looks to be a *.properties not an xml.
I have to reinstall the server?
Can i use the Tomcat manager's "deploy"?
There is in the installation jar an originale "applicationContext-events-logging.xml" to copy?
I will try one of these.
Thanks.
-
Hi
i was following the same trail and i found that my /WEB-INF/applicationContext-events-logging.xml is
## You can find all possible configuration parameters here:# http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/config.reference.html## general export properties#net.sf.jasperreports.export.ignore.page.margins=true# docx export propertiesnet.sf.jasperreports.export.docx.frames.as.nested.tables=true# xls export properties (also for xlsx)net.sf.jasperreports.export.xls.white.page.background=truenet.sf.jasperreports.export.xls.one.page.per.sheet=true#net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true#net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true# csv export propertiesnet.sf.jasperreports.csv.field.delimiter=t# html export propertiesnet.sf.jasperreports.export.html.output.images.to.dir=truenet.sf.jasperreports.export.html.images.dir=/reports/tmpnet.sf.jasperreports.export.html.output.images.uri=/JasperReportsIntegration/reports/tmp/[/code]
I think it is totally wrong. I dont know what happens. How can i restore the right file?
Thanks.
-
Hi all, Jasperserver was warking without problem until stop/start Tomcat. After that all webapps ara running except Jasperserver. If i try to start via tomcat manager the message FAIL - Application at context path /jasperserver could not be started is returned.
I know is a lot of log but really i don't know what happens and what to do. Thanks for any kinf of help or suggestion.
catalina log is :
Dec 2, 2014 1:25:39 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartDec 2, 2014 1:25:39 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errorse here..[/code]
localhost log is :
Dec 2, 2014 1:25:39 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListenerThrowable occurred: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 1 in XML document from ServletContext resource [/WEB-INF/applicationContext-events-logging.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:125) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:530) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:444) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:388) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:293) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:736)Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) at org.apache.xerces.impl.XMLDocumentScannerImpl$PrologDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:388) ... 36 moreDec 2, 2014 1:25:39 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisherThrowable occurred: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 1 in XML document from ServletContext resource [/WEB-INF/applicationContext-events-logging.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:125) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:530) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:444) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:388) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:293) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:736)Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) at org.apache.xerces.impl.XMLDocumentScannerImpl$PrologDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:388) ... 36 moreDec 2, 2014 1:25:39 PM org.apache.catalina.core.ApplicationContext logINFO:****************************************************** Owasp.CsrfGuard Properties** Logger: com.jaspersoft.jasperserver.api.security.JSCsrfLogger* NewTokenLandingPage: /jasperserver/login.html* PRNG: SHA1PRNG* SessionKey: JASPER_CSRF_SESSION_KEY* TokenLength: 96* TokenName: JASPER_CSRF_TOKEN* Ajax: true* Rotate: true* TokenPerPage: true* Action: org.owasp.csrfguard.action.Rotate* Action: org.owasp.csrfguard.action.Redirect* Parameter: Page = /jasperserver/login.html* Action: org.owasp.csrfguard.action.Log* Parameter: Message = potential cross-site request forgery (CSRF) attack thwarted (user:%user%, ip:%remote_ip%, uri:%request_uri%, error:%exception_message%)*****************************************************Dec 2, 2014 1:25:39 PM org.apache.catalina.core.ApplicationContext logINFO: Closing Spring root WebApplicationContextDec 2, 2014 1:25:39 PM org.apache.catalina.core.StandardContext listenerStopSEVERE: Exception sending context destroyed event to listener instance of class org.springframework.web.context.ContextLoaderListenerThrowable occurred: java.lang.IllegalStateException: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext at org.springframework.context.support.AbstractRefreshableApplicationContext.getBeanFactory(AbstractRefreshableApplicationContext.java:172) at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1078) at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1052) at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1000) at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:554) at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:142) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4245) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4750) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:736)Dec 2, 2014 1:25:39 PM org.apache.catalina.core.ApplicationContext logINFO: Shutting down log4j[/code]
manager log is:
2014-12-02 13:25:39,186 ERROR ContextLoader,http-8080-1:318 - Context initialization failedorg.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 1 in XML document from ServletContext resource [/WEB-INF/applicationContext-events-logging.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:125) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:530) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:444) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:388) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:293) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:736)Caused by:org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) at org.apache.xerces.impl.XMLDocumentScannerImpl$PrologDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:388) ... 36 more[/code]
-
Hi AnnMary.Thomas,
in resposponse to your 2nd point i figured the same issue trying to create a pdf with OcrB font embedded and i can suggests you this
http://www.codesuggestions.com/java/jasper-reports/adding-custom-fonts-to-jasper-reports/
Following all the steps (and stopping and starting Tomcat after updating the JAR) make the report working correctly.
Hope it help.
-
Hi all,
im trying to use the web service REST v2 in order to run a report via my web application.
the url is http://myHost:8080/jasperserver/rest_v2/reports/myPath/myReportName.pdf?ID=CC and it is working fine but before opening the save/open dialog a popup appear and a login to my server is requested for accessing Protected Area
This is about Jasperserver or Tomcat configuration? Where cna i fint the .htaccess file for jasperserver?
Any help will be welcome.
Thannks
-
Thankyou very much nthapa.
It was exactly what i was looking for.
It resolve tons of my troubles.
As a step forward i am reading the guide you suggest me in order to make (if possible) the report (a pdf url) opening in a new windows/tab of the browser instead of opening the "Open/Save" dialog.
-
Hi all,
after installing and configuring the community edition server ,in order to satisfy my requests, i would like to know if it is possibile (and possibily how) to access reports and pass needed parametrs from another web application in a way like
myHost:8080/jasperserver/something/myReportName.pdf
If not is which is the best practice to obtain the same result?
Thanks for the help.
-
I found THE solution by myself here:
https://community.jaspersoft.com/questions/826486/updating-jasperreports-server-aixdb2tomcat
where they say to simply add the line
org.owasp.csrfguard.PRNG.Provider=IBMJCE
in the file
WEB-INF/esapi/Owasp.CsrfGuard.properties
It is interesting to read about explaination.
-
Hi all,
i successfully install and deply jasperreports-server-cp-5.6.1-bin on AIX Version 6.1 with apache-tomcat-6.0.36
In the web manager of tomcat i see th application jasperserver but it is not running and if i try to start it the error
FAIL - Application at context path /jasperserver could not be started[/code]
is returned.
Here the last part of Catalina logfile
Nov 17, 2014 12:03:26 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartNov 17, 2014 12:03:26 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errorsNov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcSEVERE: The web application [/jasperserver] registered the JDBC driver [org.teiid.jdbc.TeiidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [olapCache] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-53] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [CascadeCacheCleaner] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [scheduled-eviction-thread-0] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [bufferManager Cleaner] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [bitronix-task-scheduler] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [sessionMonitor] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [pool-8-thread-1] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-39] but has failed to stop it. This is very likely to create a memory leak.Nov 17, 2014 12:03:26 PM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaksSEVERE: The web application [/jasperserver] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@614c614c]) and a value of type [org.springframework.security.context.SecurityContextImpl] (value [org.springframework.security.context.SecurityContextImpl@ffffffff: Null authentication]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.Nov 17, 2014 12:04:19 PM org.apache.catalina.loader.WebappClassLoader loadClassINFO: Illegal access: this web application instance has been stopped already. Could not load org.infinispan.util.concurrent.BoundedConcurrentHashMap$Values. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.Throwable occurred: java.lang.IllegalStateException at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1566) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526) at org.infinispan.util.concurrent.BoundedConcurrentHashMap.values(BoundedConcurrentHashMap.java:2113) at org.infinispan.container.DefaultDataContainer.purgeExpired(DefaultDataContainer.java:189) at org.infinispan.eviction.EvictionManagerImpl.processEviction(EvictionManagerImpl.java:102) at org.infinispan.eviction.EvictionManagerImpl$ScheduledTask.run(EvictionManagerImpl.java:144) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:453) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:329) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:162) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:110) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:193) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:217) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:898) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:920) at java.lang.Thread.run(Thread.java:736)[/code]
and the localhost logfile
Nov 17, 2014 12:03:07 PM org.apache.catalina.core.ApplicationContext logINFO: Set web app root system property: 'jasperserver.root' = [/home/oracle/apachetomcat/apache-tomcat-6.0.36/webapps/jasperserver/]Nov 17, 2014 12:03:07 PM org.apache.catalina.core.ApplicationContext logINFO: Initializing log4j from [/home/oracle/apachetomcat/apache-tomcat-6.0.36/webapps/jasperserver/WEB-INF/log4j.properties]Nov 17, 2014 12:03:07 PM org.apache.catalina.core.ApplicationContext logINFO: Initializing Spring root WebApplicationContextNov 17, 2014 12:03:26 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class org.owasp.csrfguard.CsrfGuardServletContextListenerThrowable occurred: java.lang.RuntimeException: java.security.NoSuchProviderException: Provider SUN is not available at org.owasp.csrfguard.CsrfGuardServletContextListener.contextInitialized(CsrfGuardServletContextListener.java:40) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:736)Caused by: java.security.NoSuchProviderException: Provider SUN is not available at java.security.SecureRandom.getInstance(SecureRandom.java:212) at org.owasp.csrfguard.CsrfGuard.load(CsrfGuard.java:101) at org.owasp.csrfguard.CsrfGuardServletContextListener.contextInitialized(CsrfGuardServletContextListener.java:38) ... 23 moreNov 17, 2014 12:03:26 PM org.apache.catalina.core.ApplicationContext logINFO: Closing Spring root WebApplicationContextNov 17, 2014 12:03:26 PM org.apache.catalina.core.ApplicationContext logINFO: Shutting down log4j[/code]
Any help is well received, Thank you in advance.
-
Something has moved.
These the steps followed:
- change in build_conf/default/db.template.properties at line 10 admin.jdbcUrl=jdbc:mysql://intraweb.psp.stpauls.it:3306/mysql to admin.jdbcUrl=jdbc:mysql://intraweb.psp.stpauls.it:3306/jasperserver
- js-install-ce.sh minimal 3 times :
- 1st time do-install-upgrade-test Connection OK, recreate-js-db ask Database [jasperserver] already exists. Drop it and create new? and i select y : BUILD FAILED Unknown database 'jasperserver'
- 2nd time do-install-upgrade-test Failed to connect: Unknown database 'jasperserver'
- jasperserver catalog createt via mysql Administrator
- 3rd time do-pre-install-test Connection OK, recreate-js-db ask Database [jasperserver] already exists. Drop it and create new? and i select n : BUILD SUCCESSFUL but no db tables created
- js-ant create-js.db
- js-ant init-js-db-ce
- js-ant import-minimal-ce
- js-ant deploy-webapp-ce
All of this end successfully but http://myAppServer:8080/jasperserver/ HTTP Status 404 - The requested resource is not available. and i'am working on it.
After all i don't know if the installation of the server is working and if yes if it is usefull. It was not easy and not so simple as the documentation says.
-
Hi hozawa,
first thanks for your attention and help.
After a series of unsucessfull try the last log says:
test-ce-all-props:
[echo] Checking properties:
[echo] dbType=mysql
[echo] dbHost=my.remote.db.server
[echo] dbUsername=jasperserver
[echo] dbPassword=**********
[echo] dbPort=3306
[echo] js.dbName=jasperserver
[echo] sugarcrm.dbName=sugarcrm
[echo] foodmart.dbName=foodmart
[echo] webAppNameCE=jasperserver
[echo] appServerType=tomcat6
[echo] appServerDir=/home/oracle/apachetomcat/apache-tomcat-6.0.36...
do-install-upgrade-test:
[echo] Checking DBMS host and port:
[echo] About to validate host: my.remote.db.server
[echo] Host my.remote.db.server is OK
[echo] Done validating host: my.remote.db.server
[echo] About to validate port: my.remote.db.server:3306
[echo] Port 3306 is OK
[echo] Done validating port: my.remote.db.server:3306
[echo] Validating administrative database connection at jdbc:mysql://my.remote.db.server:3306/mysql. Phase: [test]
[echo] For JDBC driver the artifactId and version properties are set:
[echo] maven.jdbc.artifactId=mysql-connector-java
[echo] maven.jdbc.version=5.1.33-bin
[echo] Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Access denied for user 'jasperserver'@'my.remote.ip.address' to database 'mysql'
[echo] Connection failed:
[echo] SQLState: 42000
[echo] Vendor specific error code: 1044
[echo] Message: [Access denied for user 'jasperserver'@'my.remote.ip.address' to database 'mysql]The string jdbc:mysql://my.remote.db.server:3306/mysql is used in buildomatic/bin/validation.xml in a variable named connectionURLOfDBToValidate initialized with the value of ${@{systemName}.jdbcUrl
If i use jasperserver instead of mysql in the url the connection works but i can't find where this configuration is set.
Someone has successfully installed the Jasper Server on AIX with remote mysql? If not my only choice are use local mysql or trying windows os?
Thanks.
Jasperserver 7.2 and Jaspersoft Studio 6.10 server connection not working
in Products
Posted
I successfully install Jasperserver 7.2 with Tomcat 9.x, I verify it is up and running at http://myremotehost:8081/jasperserver, it will replace a 6.x version
I am using Jaspersoft Studio 6.10 to develop several reports that I already use in my production environment. When I modify the server connection in Jaspersoft Studio changing the url from http://myremotehost:8080/jasperserver to http://myremotehost:8081/jasperserver the "test connection" fails with a difficult to read detail (I try to add it below)
but
If I try "Open in browser" the correct version in open without problems.
Without a verified connection I am not able to publish new reports or update old