Skip to content

Instantly share code, notes, and snippets.

@shruti-palshikar
Created October 16, 2013 19:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shruti-palshikar/d3f75f1157028e963a3c to your computer and use it in GitHub Desktop.
Save shruti-palshikar/d3f75f1157028e963a3c to your computer and use it in GitHub Desktop.
sudo ./js-ant import-minimal-ce
Buildfile: /opt/jasperreports-server-cp-5.2.0-bin/buildomatic/build.xml
[echo] Filtering properties (cleaning out blank spaces)
[echo] chkIfPackageManagedTomcat: check if package managed tomcat
[echo] using settings file: /opt/jasperreports-server-cp-5.2.0-bin/buildomatic/build_conf/default/maven_settings.xml
import-minimal-ce:
[echo]
[echo] Property values (in install.xml):
[echo] archiveArg = --input-zip=/opt/jasperreports-server-cp-5.2.0-bin/buildomatic/install_resources/export/js-catalog-minimal-ce.zip
[echo] dbType = postgresql
[echo] jdbcJar = postgresql-9.2-1002.jdbc4.jar
[echo] currentConf = /opt/jasperreports-server-cp-5.2.0-bin/buildomatic/build_conf/default
[echo] importExportConfig = /opt/jasperreports-server-cp-5.2.0-bin/buildomatic/conf_source/ieCe
[echo]
[echo] Validating JasperServer database connection at jdbc:postgresql://166.78.177.147:8082/jasperserver. Phase: [import-export-test]
[echo] For JDBC driver the artifactId and version properties are set:
[echo] maven.jdbc.artifactId=postgresql
[echo] maven.jdbc.version=9.2-1002.jdbc4
[echo] Specified JDBC driver jar exists
[advanced-sql] Executing commands
[advanced-sql] 1 of 1 SQL statements executed successfully
[echo] Connection OK
[java] First resource path:/opt/jasperreports-server-cp-5.2.0-bin/buildomatic/conf_source/ieCe/applicationContext-events-logging.xml
[java] Started to load resources
[java] Resource name: applicationContext.xml
[java] Resource name: applicationContext-cascade.xml
[java] Resource name: applicationContext-data-snapshots.xml
[java] Resource name: applicationContext-events-logging.xml
[java] Resource name: applicationContext-export-config.xml
[java] Resource name: applicationContext-export-import.xml
[java] Resource name: applicationContext-logging.xml
[java] Resource name: applicationContext-olap-connection.xml
[java] Resource name: applicationContext-report-scheduling.xml
[java] Resource name: applicationContext-search.xml
[java] Resource name: applicationContext-security.xml
[java] Resource name: applicationContext-themes.xml
[java] Resource name: applicationContext-virtual-data-source.xml
[java] Creating ActionModelService object.
[java] Creating action model infrastructure.
[java] ERROR: relation "jitenant" does not exist
[java] Position: 352
[java] org.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
[java] org.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
[java] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:633)
[java] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)
[java] at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getRepoTenant(TenantServiceImpl.java:107)
[java] at com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.getTenant(TenantServiceImpl.java:239)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:616)
[java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
[java] at sun.proxy.$Proxy30.getTenant(Unknown Source)
[java] at com.jaspersoft.jasperserver.export.modules.mt.TenantImporter.process(TenantImporter.java:61)
[java] at com.jaspersoft.jasperserver.export.modules.mt.TenantImporter.process(TenantImporter.java:50)
[java] at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:156)
[java] at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:98)
[java] at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:58)
[java] at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:94)
[java] at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
[java] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java] at org.hibernate.loader.Loader.doList(Loader.java:2235)
[java] at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2161)
[java] at org.hibernate.loader.Loader.list(Loader.java:2121)
[java] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
[java] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
[java] at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
[java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
[java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
[java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
[java] ... 23 more
[java] Caused by: org.postgresql.util.PSQLException: ERROR: relation "jitenant" does not exist
[java] Position: 352
[java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
[java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
[java] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
[java] at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
[java] at org.hibernate.loader.Loader.doQuery(Loader.java:697)
[java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
[java] at org.hibernate.loader.Loader.doList(Loader.java:2232)
[java] ... 31 more
BUILD FAILED
/opt/jasperreports-server-cp-5.2.0-bin/buildomatic/bin/import-export.xml:270: The following error occurred while executing this line:
/opt/jasperreports-server-cp-5.2.0-bin/buildomatic/bin/import-export.xml:158: Java returned: 255
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment