rw-network

Hello Doug! We had a number issues with our Jasper upgrade but we did finally resolve everything. Our biggest issue was the web.xml file inside the WEB-INF got messed up somehow. I copied it from the WAR file from the 6.3 upgrade folder into the jasperserverWEB-INF directory and this solved our 404 errors we were receiving. I also had to do the same with the web.xml file in the apache-tomcatconf directory but this one I pulled from our stage server which had a working web.xml file. Hope this helps!

Yes, after the first run I went to the home page of Jasperserver which showed the old version still. I ran the upgrade a second time and then all of a sudden couldn't get to the Jasperserver URL at all. I checked with the localhost:8080/manager/html and I'm unable to start the jasperserver from the tomcat page.

We have version 5.0 running on a server and are upgrading to 6.3. We are using this link for the upgrade (http://community.jaspersoft.com/documentation/tibco-jasperreports-server-upgrade-guide/v630/upgrading-37-61-63). The upgrade went off well after figuring out a few things with wrong Java versions and such. The upgrade finished successfully so moved onto the next step of clearing browser cache and then checking the http://localhost:8080/jasperserver site. At this point I was happy to see page loaded but it showed in the bottom left that it was still version 5.0. Cleared browser cache again and anything else I could think of but still kept showing old version. At this point I assumed the server upgrade did not work and tried it again, which again showed successful, but I'm unable to get to that URL. Also when I go to localhost:8080/manager/html I notice the /jasperserver is not started but it errors out saying it failed when I do try to start it. I don't mind rolling the server back and doing the upgrade again just trying to figure out where it went wrong. Did the first upgrade work successfully but I missed a step pointing to new page or? Also see this error in the stderr logs but unsure if related or not. [/code]Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation jiresourcefolderat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)at org.hibernate.loader.Loader.doQuery(Loader.java:697)at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)at org.hibernate.loader.Loader.doList(Loader.java:2232)... 65 moreDec 29, 2016 4:10:54 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublishercom.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id2_0_, this_.version as version2_0_, this_.uri as uri2_0_, this_.hidden as hidden2_0_, this_.name as name2_0_, this_.label as label2_0_, this_.description as descript7_2_0_, this_.parent_folder as parent8_2_0_, this_.creation_date as creation9_2_0_, this_.update_date as update10_2_0_ from JIResourceFolder this_ where (this_.uri=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryat org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:633)at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolder(HibernateRepositoryServiceImpl.java:423)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:986)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:294)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:287)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:191)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:189)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:184)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)at $Proxy9.getResource(Unknown Source)at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.loadProperties(PropertiesManagementServiceImpl.java:166)at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.initialize(PropertiesManagementServiceImpl.java:115)at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:286)at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:80)at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:324)at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:929)at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:467)at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)at org.apache.catalina.core.StandardService.start(StandardService.java:519)at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)at org.apache.catalina.startup.Catalina.start(Catalina.java:581)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: org.hibernate.exception.SQLGrammarException: could not execute queryat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)at org.hibernate.loader.Loader.doList(Loader.java:2235)at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)at org.hibernate.loader.Loader.list(Loader.java:2124)at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)... 57 moreCaused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation jiresourcefolderat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)at org.hibernate.loader.Loader.doQuery(Loader.java:697)at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)at org.hibernate.loader.Loader.doList(Loader.java:2232)... 65 moreDec 29, 2016 4:10:54 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartDec 29, 2016 4:10:54 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errorsDec 29, 2016 4:10:54 PM org.apache.catalina.core.ApplicationContext logINFO: Closing Spring root WebApplicationContextDec 29, 2016 4:10:55 PM org.apache.catalina.core.ApplicationContext logINFO: Shutting down log4j My other question is, on an upgrade should a new apache-tomcat folder be created during the install/unpacking or does it use the old installs apache folder still?

Only Jasperserver is under the following directory: C:Program Filesjasperreports-server-cp-5.0.0apache-tomcatwebappsjasperserver

There is a japerreportsPostgreSQL & jasperreportsTomcat running.

Not a new install, this is an upgrade from 5.0 to 6.3 and was working before upgrade. Exported repo and upgrade was "successful" I can't connect to localhost jasperserver

I can access tomcat just fine on localhost http://localhost:8080 but can't access http://localhost:8080/jasperserver after upgrade. Utilizing the following guide:http://community.jaspersoft.com/documentation/tibco-jasperreports-server-upgrade-guide/v630/upgrading-37-61-63 tomcat & postgres services are running, also restarted server to troubleshoot as well. When following: If you made modifications to the original JasperReports Server application, JasperReports Server 6.16.3 for example, these configurations are typically found in the WEB-INF/applicationContext-*.xml set of files. You'll need to manually copy configuration changes, like client-specific security classes or LDAP server configurations, from your previous environment and integrate them with your upgraded environment. Where do you place those files as there is not an apache-tomcat under the c:jaspersoft directory. If this isn't the issue...please explain in detail haven't worked w/JasperServer. Thanks much!

Thanks JDK 8 did the trick! Much appreciated!http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_up.gif

Running the js-upgrade-newdb-ce.bat file and everthing is going swimmingly then the follow error:Exception in thread "main" java.lang.UnsupportedClassVersionError: net/sf/jasperreports/data/cache/DataSnapshot : Unsupported major.minor version 51.0 What version of Java is needed for 6.3? Any help would be greatly appreciated!RW

I have also dug into the log file located on my machine at c:users%username%JaspersoftWorkspace.metadata.log and found the following error corresponding with each attempt to run the report.

This is Taylor, I work with Gunnard. I am further troubleshooting this issue. To provide more information, the text of error we are receiving is An internal error occurred during: "Preview: cnctZGV2Ymkx:/reports/CompAnalysis/AnnualDepAvg:aHR0cDovL3J3LWRldmJpMTo4MDgwL2phc3BlcnNlcnZlci8KaGFtbWVybGluZwo= on ".java.lang.NullPointerException This is a screenshot of the error Also, If I dig into the error in the report state tab, I get the following information The filename, directory name, or volume label syntax is incorrect java.io.IOException: The filename, directory name, or volume label syntax is incorrectat java.io.WinNTFileSystem.createFileExclusively(Native Method)at java.io.File.createNewFile(File.java:1012)at com.jaspersoft.studio.server.editor.ReportRunControler$2.run(ReportRunControler.java:258)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Here is a screenshot of that error. To produce this error i1) installed jaspersoft studio 6.31 on my pc using the windows installer2) added our dev server to the repository explorer, it would only add it once i checked "use soap only" under advanced settings3) browsed to the report I wanted to run4) right clicked on the report's main jrxml file, and clicked "run report unit" Any help you can provide would be greatly appreciated!

If the JasperServer runs on a different OS you could try something like this: ( System.getProperty("os.name").equals("OS/400") ? "/reports/templates/images/Logo1_noTag.png" : "H:\Jasper\Logos\Logo1_noTag.png" )

I am not sure if this is a frowned upon solution, but it works for us when outputting to html. Plus it may not truly solve your issue, but it should make the fonts bigger. At the Report level add the "net.sf.jasperreports.export.html.size.unit" Property with a value of "pt" (no quotes).

I was able to figure out that I can use the tHttpRequest Component. I was missing the proper formatting of the Headers for authentication. In the Headers section of the Component put "Authorization" in the Header Key column. The value column is made up of the term 'Basic' and then your user ID and password in Base64 encoding. Follow Jasper Webservice docs for that part. Ex: "Basic HmDwb3F0VnBubmCyOlE1bjRzAKJDcWK=". I was missing the 'Basic' part. This may not be the only way to do this, but it is working for my POC. My next problem is trying to figure out why it seems that Jasper Web service cannot keep up with the requests from the Talend job. I am ending up with empty PDFs on some calls.

We have just upgraded to JasperServer 5.0. We also use Talend / JasperETL for our ETL processing. I am trying to build a prototype Talend Job that uses the new Rest web service access in Jasper 5.0, but I am having a problem figuring out just the right Components and settings within them to use. I am most intersted in using the 'running a report part of the rest_v2/reports Service. Does any one have this working in a Talend job that they can give me pointers on getting it set up correctly? Thanks.