Hi, I trying to build JasperReport Sever v5.5.1 using DB2 as backend, but when I run "import-minimal-ce", the script fails. http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/sad_smile.gif These are the steps that i follow: # ./js-ant clean-config # ./js-ant gen-config # ./js-ant create-js-db # ./js-ant init-js-db-ce # ./js-ant import-minimal-ce The "default-master.properties" that I use is generate from "db2_master.properties". This is the error: # ./js-ant import-minimal-ce : : [java] Resource name: applicationContext-virtual-data-source.xml [java] Creating ActionModelService object. [java] Creating action model infrastructure. [java] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=xxxx.JITENANT, DRIVER=3.64.82 [java] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;xxxx.JITENANT, DRIVER=3.64.82 [java] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;xxxx.JITENANT, DRIVER=3.64.82 [java] org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id10_0_, this_.tenantId as tenantId10_0_, th is_.tenantAlias as tenantAl3_10_0_, this_.parentId as parentId10_0_, this_.tenantName as tenantName10_0_, this_.tenantDesc as tenantDesc10_0_, this_.tenantNote as tenantN ote10_0_, this_.tenantUri as tenantUri10_0_, this_.tenantFolderUri as tenantFo9_10_0_, this_.theme as theme10_0_ from JITenant this_ where lcase(this_.tenantId) like ?]; 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_, th is_.tenantAlias as tenantAl3_10_0_, this_.parentId as parentId10_0_, this_.tenantName as tenantName10_0_, this_.tenantDesc as tenantDesc10_0_, this_.tenantNote as tenantN ote10_0_, this_.tenantUri as tenantUri10_0_, this_.tenantFolderUri as tenantFo9_10_0_, this_.theme as theme10_0_ from JITenant this_ where lcase(this_.tenantId) like ?]; 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:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [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 $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: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=xxxx.JITENANT, DRIVER=3.64.82 [java] at com.ibm.db2.jcc.am.bd.a(bd.java:679) [java] at com.ibm.db2.jcc.am.bd.a(bd.java:60) [java] at com.ibm.db2.jcc.am.bd.a(bd.java:127) [java] at com.ibm.db2.jcc.am.io.c(io.java:2704) [java] at com.ibm.db2.jcc.am.io.d(io.java:2692) [java] at com.ibm.db2.jcc.am.io.a(io.java:2141) [java] at com.ibm.db2.jcc.am.jo.a(jo.java:7323) [java] at com.ibm.db2.jcc.t4.ab.h(ab.java:141) [java] at com.ibm.db2.jcc.t4.ab.b(ab.java:41) [java] at com.ibm.db2.jcc.t4.p.a(p.java:32) [java] at com.ibm.db2.jcc.t4.qb.i(qb.java:135) [java] at com.ibm.db2.jcc.am.io.gb(io.java:2110) [java] at com.ibm.db2.jcc.am.jo.qc(jo.java:3509) [java] at com.ibm.db2.jcc.am.jo.b(jo.java:4300) [java] at com.ibm.db2.jcc.am.jo.dc(jo.java:729) [java] at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:702) [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 I think the problem is in schemas.. but if them are provided from jasper I supose that they are ok (or not http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_down.gif) Thanks in advance! http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/regular_smile.gif
