[SOLVED] JasperReports 5.5.1 + buildomatic + DB2 + import-minimal-ce fail

[maximatt]

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

[maximatt]

Was my fault...

I just need run this scripts:

# ./js-ant clean-config
# ./js-ant gen-config
# ./js-ant import-minimal-ce