jasperserver.war deployment return crasy error.

[david.lariviere]

Hi, since 3 weeks i try and retry (and retry) to deploy jasperreports-server-cp-5.1.0 in glassfish with Mysql Database 5.5.

 

Each time that i try to deploy war file i receive the following error:

 

:Error occurred during deployment: Exception while loading the app : java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: com.jaspersoft.jasperserver.api.JSExceptionWrapper: 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 query. Please see server.log for more details.]]

 

Someone have an idea ?

 

Have tested connexion manually, tested glassfigh jdbc successfully, try qurey (with succes) into Mysql Database ... All work properly except when deploy.

 

I try too to generate my own jasperserver.war from jasperreports-server-cp-5.1.0-src and i got the exacte same result.

 

Please Help.

 

David

[rsuddhala]

Could you attach server log for more details.

[martin.rosicky]

Hi,

I've received the same error in environment GF4, PSQL 8.4, JasperServer 5.5.

- data into DB uploaded by js-ant without any error

- connection to database is without problem from GF

- direct query works in psql under the right account works as well

- application deployment fails

Thanks a lot for any help

Martin R.

 

Part of server.log is:

-----------------------------------------------

[2014-02-08T21:49:57.220+0100] [glassfish 4.0] [iNFO] [] [] [tid: _ThreadID=110 _ThreadName=Thread-3] [timeMillis: 1391892597220] [levelValue: 800] [[

2014-02-08 21:49:57,206 ERROR JDBCExceptionReporter,admin-listener(6):101 - Table/View 'JIRESOURCEFOLDER' does not exist.]]

 

[2014-02-08T21:49:57.244+0100] [glassfish 4.0] [sEVERE] [] [org.springframework.web.context.ContextLoader] [tid: _ThreadID=110 _ThreadName=admin-listener(6)] [timeMillis: 1391892597244] [levelValue: 1000] [[

Context initialization failed

com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id5_0_, this_.version as version5_0_, this_.uri as uri5_0_, this_.hidden as hidden5_0_, this_.name as name5_0_, this_.label as label5_0_, this_.description as descript7_5_0_, this_.parent_folder as parent8_5_0_, this_.creation_date as creation9_5_0_, this_.update_date as update10_5_0_ from JIResourceFolder this_ where (this_.uri=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

at 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:487)

at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$26.execute(HibernateRepositoryServiceImpl.java:1516)

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.getFolderUnsecure(HibernateRepositoryServiceImpl.java:1514)

at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolder(HibernateRepositoryServiceImpl.java:1504)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

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 com.sun.proxy.$Proxy359.getFolder(Unknown Source)

at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.fixFolderParentBug(PropertiesManagementServiceImpl.java:354)

at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:337)

at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:58)

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.contextListenerStart(StandardContext.java:5362)

at com.sun.enterprise.web.WebModule.contextListenerStart(WebModule.java:743)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:5898)

at com.sun.enterprise.web.WebModule.start(WebModule.java:691)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1041)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:1024)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:747)

at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:2278)

at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1924)

at com.sun.enterprise.web.WebApplication.start(WebApplication.java:139)

at org.glassfish.internal.data.EngineRef.start(EngineRef.java:122)

at org.glassfish.internal.data.ModuleInfo.start(ModuleInfo.java:291)

at org.glassfish.internal.data.ApplicationInfo.start(ApplicationInfo.java:352)

at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:497)

at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:219)

at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:491)

at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:527)

at com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:523)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:356)

at com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:522)

at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:546)

at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1423)

at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1500(CommandRunnerImpl.java:108)

at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1762)

at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1674)

at org.glassfish.admin.rest.utils.ResourceUtil.runCommand(ResourceUtil.java:235)

at org.glassfish.admin.rest.utils.ResourceUtil.runCommand(ResourceUtil.java:257)

at org.glassfish.admin.rest.resources.TemplateListOfResource.createResource(TemplateListOfResource.java:134)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:125)

at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:152)

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:91)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:346)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:341)

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:101)

at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:224)

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)

at org.glassfish.jersey.internal.Errors.process(Errors.java:315)

at org.glassfish.jersey.internal.Errors.process(Errors.java:297)

at org.glassfish.jersey.internal.Errors.process(Errors.java:267)

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)

at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:198)

at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:946)

at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:331)

at org.glassfish.admin.rest.adapter.RestAdapter$2.service(RestAdapter.java:318)

at org.glassfish.admin.rest.adapter.RestAdapter.service(RestAdapter.java:181)

at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:246)

at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:191)

at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:168)

at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:189)

at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)

at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:288)

at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:206)

at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:136)

at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:114)

at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)

at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:838)

at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:113)

at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:115)

at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:55)

at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:135)

at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)

at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)

at java.lang.Thread.run(Thread.java:724)

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

at 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.listUsingQueryCache(Loader.java:2161)

at org.hibernate.loader.Loader.list(Loader.java:2121)

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)

... 99 more

Caused by: java.sql.SQLSyntaxErrorException: Table/View 'JIRESOURCEFOLDER' does not exist.

at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)

at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)

at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)

at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:586)

at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.prepareCachedStatement(ConnectionWrapper40.java:255)

at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.prepareCachedStatement(ConnectionWrapper40.java:52)

at com.sun.gjc.spi.ManagedConnectionImpl.prepareCachedStatement(ManagedConnectionImpl.java:992)

at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.prepareStatement(ConnectionWrapper40.java:173)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)

at org.hibernate.loader.Loader.doQuery(Loader.java:696)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

at org.hibernate.loader.Loader.doList(Loader.java:2232)

... 107 more

Caused by: org.apache.derby.client.am.SqlException: Table/View 'JIRESOURCEFOLDER' does not exist.

at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)

at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)

at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)

... 120 more

]]

 

[2014-02-08T21:49:57.246+0100] [glassfish 4.0] [sEVERE] [AS-WEB-CORE-00174] [javax.enterprise.web.core] [tid: _ThreadID=110 _ThreadName=admin-listener(6)] [timeMillis: 1391892597246] [levelValue: 1000] [[

Startup of context /jasperserver failed due to previous errors]]

--------------------------------------------------------

 

 

[plar]

Did you ever find solution to this problem. I am having same problem, please hlep me if possible.