SETTURGOPI Posted July 25, 2018 Share Posted July 25, 2018 Hi we now switched to postgresql database but not sure why the applcaition still refes to the Oracle and tthows error. I want application to connect to postgresql.1. All the Sql's supplied with inslall buildomatic were executed sucess fully in postgresql.2. Made necessary changes that the applciation will connect to postgresql DB.2018-07-25 18:22:36,872 ERROR JDBCExceptionReporter,localhost-startStop-1:101 - ORA-00920: invalid relational operator2018-07-25 18:22:36,908 ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failedorg.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id10_0_, this_.tenantId as tenantId10_0_, this_.tenantAlias as tenantAl3_10_0_, this_.parentId as parentId10_0_, this_.tenantName as tenantName10_0_, this_.tenantDesc as tenantDesc10_0_, this_.tenantNote as tenantNote10_0_, this_.tenantUri as tenantUri10_0_, this_.tenantFolderUri as tenantFo9_10_0_, this_.theme as theme10_0_ from JITenant this_ where this_.tenantId ilike ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1040) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getRepoTenant(TenantServiceImpl.java:112) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getPersistentTenant(TenantServiceImpl.java:438) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy31.getPersistentTenant(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributeServiceImpl.applyProfileAttributes(ProfileAttributeServiceImpl.java:768) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy30.applyProfileAttributes(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.ServerSettingsInitialization.onApplicationEvent(ServerSettingsInitialization.java:36) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.ServerSettingsInitialization.onApplicationEvent(ServerSettingsInitialization.java:29) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:96) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:335) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:958) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:485) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4900) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5363) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:731) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:973) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1850) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)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:1057) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407) ... 54 moreCaused by: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) 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) ... 62 more2018-07-25 18:22:36,929 ERROR JDBCExceptionReporter,pool-8-thread-1:101 - ORA-00920: invalid relational operator2018-07-25 18:22:37,012 ERROR GlobalPropertiesListUpgradeExecutor,pool-8-thread-1:176 - Unexpected error occurred during inserting administrator root attributes permissionorg.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id10_0_, this_.tenantId as tenantId10_0_, this_.tenantAlias as tenantAl3_10_0_, this_.parentId as parentId10_0_, this_.tenantName as tenantName10_0_, this_.tenantDesc as tenantDesc10_0_, this_.tenantNote as tenantNote10_0_, this_.tenantUri as tenantUri10_0_, this_.tenantFolderUri as tenantFo9_10_0_, this_.theme as theme10_0_ from JITenant this_ where this_.tenantId ilike ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1040) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getRepoTenant(TenantServiceImpl.java:112) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getPersistentTenant(TenantServiceImpl.java:438) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy31.getPersistentTenant(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getPersistentTenant(UserAuthorityServiceImpl.java:2022) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getRepoRole(UserAuthorityServiceImpl.java:609) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getRepoRole(UserAuthorityServiceImpl.java:605) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getPersistentObject(UserAuthorityServiceImpl.java:861) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy29.getPersistentObject(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$InsertingPermissionCallable.call(GlobalPropertiesListUpgradeExecutor.java:171) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$InsertingPermissionCallable.call(GlobalPropertiesListUpgradeExecutor.java:156) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)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:1057) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407) ... 41 moreCaused by: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) 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) ... 49 more25-Jul-2018 18:22:37.133 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file25-Jul-2018 18:22:37.136 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/jasperserver] startup failed due to previous errors -- JasperServer: TeiidCache preparedplan shutdown called. This normal shutdown operation. -- JasperServer: TeiidCache resultset-repl shutdown called. This normal shutdown operation. -- JasperServer: TeiidCache resultset shutdown called. This normal shutdown operation. -- JasperServer: ProfileAttributeCacheImpl shutdown called. This normal shutdown operation.25-Jul-2018 18:22:38.398 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [jasperserver] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.25-Jul-2018 18:22:38.399 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc 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.25-Jul-2018 18:22:38.401 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [jasperserver] appears to have started a thread named [Thread-5] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Object.wait(Native Method) java.lang.Object.wait(Object.java:502) com.jaspersoft.jasperserver.war.themes.ThemeCache$RefreshThread.run(ThemeCache.java:327)25-Jul-2018 18:22:38.403 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads 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. Stack trace of thread: java.lang.Object.wait(Native Method) java.util.TimerThread.mainLoop(Timer.java:552) java.util.TimerThread.run(Timer.java:505)25-Jul-2018 18:22:38.404 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads 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. Stack trace of thread: java.lang.Object.wait(Native Method) org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:552)25-Jul-2018 18:22:38.405 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads 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. Stack trace of thread: java.lang.Object.wait(Native Method) org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:552)25-Jul-2018 18:22:38.407 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads 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. Stack trace of thread: java.lang.Thread.sleep(Native Method) bitronix.tm.timer.TaskScheduler.run(TaskScheduler.java:245)25-Jul-2018 18:22:38.408 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads 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. Stack trace of thread: java.lang.Object.wait(Native Method) org.teiid.common.buffer.impl.BufferManagerImpl$Cleaner.run(BufferManagerImpl.java:120) java.util.TimerThread.mainLoop(Timer.java:555) java.util.TimerThread.run(Timer.java:505)25-Jul-2018 18:22:38.411 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [jasperserver] created a ThreadLocal with key of type [org.teiid.query.parser.QueryParser$1] (value [org.teiid.query.parser.QueryParser$1@2c3178ba]) and a value of type [org.teiid.query.parser.QueryParser] (value [org.teiid.query.parser.QueryParser@1964922f]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.25-Jul-2018 18:22:38.452 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /opt/apache-tomcat-8.0.52/webapps/jasperserver.war has finished in 62,498 ms25-Jul-2018 18:22:38.454 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /opt/apache-tomcat-8.0.52/webapps/manager25-Jul-2018 18:22:38.643 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /opt/apache-tomcat-8.0.52/webapps/manager has finished in 188 ms25-Jul-2018 18:22:38.643 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /opt/apache-tomcat-8.0.52/webapps/host-manager25-Jul-2018 18:22:38.718 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /opt/apache-tomcat-8.0.52/webapps/host-manager has finished in 74 ms25-Jul-2018 18:22:38.718 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /opt/apache-tomcat-8.0.52/webapps/ROOT25-Jul-2018 18:22:38.779 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /opt/apache-tomcat-8.0.52/webapps/ROOT has finished in 61 ms25-Jul-2018 18:22:38.794 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-9080"]25-Jul-2018 18:22:38.817 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-9009"]25-Jul-2018 18:22:38.821 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 63057 ms Link to comment Share on other sites More sharing options...
hozawa Posted July 25, 2018 Share Posted July 25, 2018 It's because JasperReports Server installer actually generates setup files that's are to be used in the installation. Unless you've deleted all the initial installation files are restarted every thing over from scratch, you'll going to get some files left over from the previous installation. Link to comment Share on other sites More sharing options...
SETTURGOPI Posted July 26, 2018 Author Share Posted July 26, 2018 Hi, We used the Buildo matic this time to fully install jasper resports server on tomcat and the log is below. we did not observe any errors in build but still the same problem happens - Unable to initialize the application.----------------------------------------------------------------------Running JasperReports Server install script at 2018-07-25_19-15--------------------------------------------------------------------------------------------------------------------------------------------Using ANT_OPTS: -Dnet.sf.ehcache.disabled=true -Xms512m -Xmx2048m----------------------------------------------------------------------WARNING: JAVA_HOME environment variable not found[default]Running install-normal-ce Ant task.----------------------------------------------------------------------Buildfile: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build.xml [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlgen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commandstest-ce-all-props: [echo] Checking properties: [echo] dbType=postgresql [echo] dbHost=192.168.204.223 [echo] dbUsername=postgres [echo] dbPassword=********** [echo] dbPort=5432 [echo] js.dbName=postgres [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperserver [echo] appServerType=tomcat [echo] appServerDir=/opt/apache-tomcat-8.0.52check-dbtype-ce:test-appServerType-ce:do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate port: 192.168.204.223:5432 [echo] Port 5432 is OK [echo] Done validating port: 192.168.204.223:5432 [echo] Validating administrative database connection at jdbc:postgresql://192.168.204.223:5432/postgres. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [echo] Validating JasperServer database connection at jdbc:postgresql://192.168.204.223:5432/postgres. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OKdo-pre-install-test: [echo] Validating FoodMart database connection at jdbc:postgresql://192.168.204.223:5432/foodmart. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: FATAL: database "foodmart" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "foodmart" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Validating SugarCRM database connection at jdbc:postgresql://192.168.204.223:5432/sugarcrm. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: FATAL: database "sugarcrm" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "sugarcrm" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next steppre-install-test-ce:recreate-js-db: [echo] Validating JasperServer database connection at jdbc:postgresql://192.168.204.223:5432/postgres. Phase: [before] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [input] Database [postgres] already exists. Drop it and create new? WARNING: All existing data will be lost! This operation may not be rolled back. Enter 'y' to recreate or 'n' to skip this step. Default is 'n' (y, [n]) [echo] Database recreation skipped. Leaving database intactfill-js-ce-db-minimal:fill-js-ce-db-normal:prepare-js-ce-db-normal:recreate-foodmart-db: [echo] Validating FoodMart database connection at jdbc:postgresql://192.168.204.223:5432/foodmart. Phase: [before] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: FATAL: database "foodmart" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "foodmart" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlcreate-foodmart-db: [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 0 rows affected[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Validating FoodMart database connection at jdbc:postgresql://192.168.204.223:5432/foodmart. Phase: [after] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OKfill-foodmart-db: [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlload-foodmart-db: [echo] [echo] Jars loaded from property foodJarsDir: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/ieCe/lib [echo] foodMartData: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/FoodMartCreateData.zip [echo] jdbcJar: postgresql-9.4-1210.jdbc41.jar [echo] Using jdbc Jar: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/db/postgresql/jdbc/postgresql-9.4-1210.jdbc41.jar [echo] [java] Main error [java] org.postgresql.util.PSQLException: FATAL: role "${foodmart.dbUsername}" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453) [java] at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2576) [java] at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:111) [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:218) [java] at org.postgresql.Driver.makeConnection(Driver.java:407) [java] at org.postgresql.Driver.connect(Driver.java:275) [java] at java.sql.DriverManager.getConnection(DriverManager.java:571) [java] at java.sql.DriverManager.getConnection(DriverManager.java:215) [java] at com.jaspersoft.buildomatic.loader.MondrianFoodMartLoader.load(MondrianFoodMartLoader.java:364) [java] at com.jaspersoft.buildomatic.loader.MondrianFoodMartLoader.main(MondrianFoodMartLoader.java:348) [java] 2018-07-25 19:15:52,524 ERROR MondrianFoodMartLoader:350 - Main error [java] org.postgresql.util.PSQLException: FATAL: role "${foodmart.dbUsername}" does not exist [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453) [java] at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2576) [java] at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:111) [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) [java] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) [java] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:218) [java] at org.postgresql.Driver.makeConnection(Driver.java:407) [java] at org.postgresql.Driver.connect(Driver.java:275) [java] at java.sql.DriverManager.getConnection(DriverManager.java:571) [java] at java.sql.DriverManager.getConnection(DriverManager.java:215) [java] at com.jaspersoft.buildomatic.loader.MondrianFoodMartLoader.load(MondrianFoodMartLoader.java:364) [java] at com.jaspersoft.buildomatic.loader.MondrianFoodMartLoader.main(MondrianFoodMartLoader.java:348) [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlupdate-foodmart-db: [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing resource: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/supermart-update.sql[advanced-sql] Failed to execute: UPDATE currency SET date = date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "currency" does not exist[advanced-sql] Failed to execute: UPDATE promotion SET start_date = start_date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "promotion" does not exist[advanced-sql] Failed to execute: UPDATE expense_fact SET exp_date = exp_date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "expense_fact" does not exist[advanced-sql] Failed to execute: UPDATE agg_g_ms_pcat_sales_fact_1997 SET the_year = the_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "agg_g_ms_pcat_sales_fact_1997" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET the_year = the_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE reserve_employee SET hire_date = hire_date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "reserve_employee" does not exist[advanced-sql] Failed to execute: UPDATE employee SET hire_date = hire_date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "employee" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET the_date = the_date + interval '15 years'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE agg_lc_100_sales_fact_1997 SET the_year = the_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "agg_lc_100_sales_fact_1997" does not exist[advanced-sql] Failed to execute: UPDATE agg_c_10_sales_fact_1997 SET the_year = the_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "agg_c_10_sales_fact_1997" does not exist[advanced-sql] Failed to execute: UPDATE agg_c_14_sales_fact_1997 SET the_year = the_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "agg_c_14_sales_fact_1997" does not exist[advanced-sql] Failed to execute: UPDATE agg_c_special_sales_fact_1997 SET time_year = time_year + 15[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "agg_c_special_sales_fact_1997" does not exist[advanced-sql] Failed to execute: ALTER TABLE time_by_day ADD day_of_week int[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 1 WHERE the_day = 'Monday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 2 WHERE the_day = 'Tuesday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 3 WHERE the_day = 'Wednesday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 4 WHERE the_day = 'Thursday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 5 WHERE the_day = 'Friday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 6 WHERE the_day = 'Saturday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: UPDATE time_by_day SET day_of_week = 7 WHERE the_day = 'Sunday'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "time_by_day" does not exist[advanced-sql] Failed to execute: CREATE TABLE monthly_profit AS SELECT min(time_by_day.the_date) as the_date, time_by_day.the_year AS the_year, time_by_day.the_month AS the_month, time_by_day.quarter AS the_quarter, time_by_day.month_of_year AS time_by_day_month_of_year, sum(sales_fact_1997.store_sales) AS store_sales, sum(sales_fact_1997.store_sales)-sum(sales_fact_1997.store_cost) AS profit, store.store_state AS store_state FROM sales_fact_1997 sales_fact_1997 INNER JOIN store store ON sales_fact_1997.store_id = store.store_id INNER JOIN time_by_day time_by_day ON sales_fact_1997.time_id = time_by_day.time_id WHERE store.store_state IS NOT NULL /* when param PickState contains ALL use NULL otherwise use PickState */ GROUP BY time_by_day.the_year, time_by_day.the_month, time_by_day.quarter, time_by_day.month_of_year, store.store_state[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "sales_fact_1997" does not exist[advanced-sql] Failed to execute: CREATE TABLE product_sales AS SELECT product.product_name AS product_product_name, sum(sales_fact_1997.store_sales)AS store_sales, product.product_id AS product_product_id FROM sales_fact_1997 sales_fact_1997, product product WHERE sales_fact_1997.product_id = product.product_id GROUP BY product.product_name, product.product_id[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "sales_fact_1997" does not exist[advanced-sql] Failed to execute: CREATE TABLE customer_sales AS SELECT customer.fullname AS customer_fullname, sum(sales_fact_1997.store_sales)AS store_sales, customer.customer_id AS customer_id FROM sales_fact_1997 sales_fact_1997, customer customer WHERE sales_fact_1997.customer_id = customer.customer_id GROUP BY customer.fullname, customer.customer_id[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "sales_fact_1997" does not exist[advanced-sql] Failed to execute: CREATE TABLE promotion_sales AS SELECT promotion.promotion_name AS promotion_promotion_name, sum(sales_fact_1997.store_sales)AS store_sales, promotion.promotion_id AS promotion_promotion_id FROM sales_fact_1997 sales_fact_1997, promotion promotion WHERE sales_fact_1997.promotion_id = promotion.promotion_id GROUP BY promotion.promotion_name, promotion.promotion_id HAVING promotion.promotion_name <> 'No Promotion'[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "sales_fact_1997" does not exist[advanced-sql] Failed to execute: ALTER TABLE product RENAME COLUMN "SKU" TO "sku"[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "product" does not exist[advanced-sql] Failed to execute: ALTER TABLE product RENAME COLUMN "SRP" TO "srp"[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation "product" does not exist[advanced-sql] 0 of 26 SQL statements executed successfullyprepare-foodmart-db:recreate-sugarcrm-db: [echo] Validating SugarCRM database connection at jdbc:postgresql://192.168.204.223:5432/sugarcrm. Phase: [before] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Failed to connect: FATAL: database "sugarcrm" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "sugarcrm" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlcreate-sugarcrm-db: [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 0 rows affected[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Validating SugarCRM database connection at jdbc:postgresql://192.168.204.223:5432/sugarcrm. Phase: [after] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing commands[advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OKfill-sugarcrm-db: [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlload-sugarcrm-db: [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists[advanced-sql] Executing resource: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/sugarcrm.zip:sugarcrm.sql[advanced-sql] 69316 of 69316 SQL statements executed successfullyprepare-sugarcrm-db:prepare-all-ce-dbs-normal:deploy-webapp-ce-if-needed:do-deploy-webapp-if-needed:init-source-paths: [echo] [echo] Property values (dev.xml:init-source-paths): [echo] Source Paths: [echo] js-path = ${js-base-path} [echo] js-pro-path = ${js-pro-base-path} [echo] Other Paths: [echo] maven-localrepo-path = //.m2/repository [echo] [echo] set-ce-webapp-name: [copy] Copying 1 file to /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default [copy] Copying 5 files to /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/webapp/WEB-INFdeploy-jdbc-jar: [echo] Copy JDBC drivers to the app-server [echo] First copy jars [echo] FROM the conf_source/db/app-srv-jdbc-drivers folder [echo] TO the folder /opt/apache-tomcat-8.0.52/lib [copy] Copying 2 files to /opt/apache-tomcat-8.0.52/lib [echo] About to copy JS repository JDBC driver (if it exists): [echo] Copy jdbc driver from: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/db/postgresql/jdbc/postgresql-9.4-1210.jdbc41.jar [echo] Copy jdbc driver to: /opt/apache-tomcat-8.0.52/lib [copy] Copying 1 file to /opt/apache-tomcat-8.0.52/lib [copy] Copying /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/db/postgresql/jdbc/postgresql-9.4-1210.jdbc41.jar to /opt/apache-tomcat-8.0.52/lib/postgresql-9.4-1210.jdbc41.jardeploy-webapp: [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [echo] About to copy JDBC driver for import-export config (if it exists): [echo] [echo] Property values (in app-server.xml: deploy-webapp): [echo] jsEdition = ce [echo] warFileDistSourceDir = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/../jasperserver.war [echo] warTargetDir = /opt/apache-tomcat-8.0.52/webapps/jasperserver [echo] webAppName = jasperserver [echo] webAppNameCE = jasperserver [echo] webAppNamePro = jasperserver-pro [echo] webAppNameSrc = jasperserver [echo] webAppNameDel = jasperserver [echo] warTargetDirDel = /opt/apache-tomcat-8.0.52/webapps/jasperserver [echo] [unzip] Expanding: /opt/jasperreports-server-cp-7.1.0-bin/jasperserver.war into /opt/apache-tomcat-8.0.52/webapps/jasperserver [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found. [echo] using settings file: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xmlinit-source-paths: [echo] [echo] Property values (dev.xml:init-source-paths): [echo] Source Paths: [echo] js-path = ${js-base-path} [echo] js-pro-path = ${js-pro-base-path} [echo] Other Paths: [echo] maven-localrepo-path = //.m2/repository [echo] [echo] deploy-webapp-datasource-configs: [echo] [echo] Property values (in app-server.xml: deploy-webapp): [echo] jsEdition = ce [echo] warFileDistSourceDir = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/../jasperserver.war [echo] warTargetDir = /opt/apache-tomcat-8.0.52/webapps/jasperserver [echo] webAppName = jasperserver [echo] webAppNameCE = jasperserver [echo] webAppNamePro = jasperserver-pro [echo] webAppNameSrc = jasperserver [echo] webAppNameDel = jasperserver [echo] warTargetDirDel = /opt/apache-tomcat-8.0.52/webapps/jasperserver [copy] Copying 8 files to /opt/apache-tomcat-8.0.52/webapps/jasperserverdeploy-webapp-ce:install-normal-ce: [echo] Installation successfully completed!BUILD SUCCESSFULTotal time: 6 minutes 0 secondsChecking Ant return code: OK---------------------------------------------------------------------- 2018-07-25 19:26:51,731 ERROR GlobalPropertiesListUpgradeExecutor,pool-8-thread-1:176 - Unexpected error occurred during inserting administrator root attributes permissionorg.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id10_0_, this_.tenantId as tenantId10_0_, this_.tenantAlias as tenantAl3_10_0_, this_.parentId as parentId10_0_, this_.tenantName as tenantName10_0_, this_.tenantDesc as tenantDesc10_0_, this_.tenantNote as tenantNote10_0_, this_.tenantUri as tenantUri10_0_, this_.tenantFolderUri as tenantFo9_10_0_, this_.theme as theme10_0_ from JITenant this_ where this_.tenantId ilike ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1040) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getRepoTenant(TenantServiceImpl.java:112) at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getPersistentTenant(TenantServiceImpl.java:438) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy31.getPersistentTenant(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getPersistentTenant(UserAuthorityServiceImpl.java:2022) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getRepoRole(UserAuthorityServiceImpl.java:609) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getRepoRole(UserAuthorityServiceImpl.java:605) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getPersistentObject(UserAuthorityServiceImpl.java:861) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy29.getPersistentObject(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$InsertingPermissionCallable.call(GlobalPropertiesListUpgradeExecutor.java:171) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$InsertingPermissionCallable.call(GlobalPropertiesListUpgradeExecutor.java:156) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)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:1057) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407) ... 41 moreCaused by: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) 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) ... 49 more Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now