An error has occurred when deploying Business Data Model

Submitted by koclife on Thu, 11/26/2015 - 11:46
1
0
-1

Hi all,

Whem i'm trying to upload this xml contained in the zip

`<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<businessObjectModel>
    <businessObjects>
        <businessObject qualifiedName="FirstLife.Segnal3">
            <fields>
                <field type="STRING" length="255" name="Titolo" nullable="true" collection="false"/>
                <field type="TEXT" length="255" name="Descrizione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="StatoSegnalazione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="UserEmail" nullable="true" collection="false"/>
                <field type="BOOLEAN" length="255" name="eRifiutata" nullable="true" collection="false"/>
                <field type="BOOLEAN" length="255" name="eMirafioriSud" nullable="true" collection="false"/>
                <field type="BOOLEAN" length="255" name="eSegnalazioneGestionale" nullable="true" collection="false"/>
                <field type="BOOLEAN" length="255" name="eAltroEnte" nullable="true" collection="false"/>
                <field type="BOOLEAN" length="255" name="eVerificata" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="Origine" nullable="true" collection="false"/>
                <field type="TEXT" length="255" name="MailRifiutoSegnalatore" nullable="true" collection="false"/>
                <field type="TEXT" length="255" name="MailAccettazioneSegnalatore" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailSegnalazioneAltroEnte" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailUtenteEsitoVerifica" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailChiusuraSegnalatore" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="mailSegnalatoreAccettatoAltroEnte" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailRipresaSegnalatore" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailSegnalatoreRipresaSegnalazione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="MailSegnalatoreSegnalazioneGestionale" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="Tipologia" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="LinkEsterno" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="Categoria" nullable="true" collection="false"/>
                <field type="DOUBLE" length="255" name="Lat" nullable="true" collection="false"/>
                <field type="DOUBLE" length="255" name="Long" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="NumeroProtocollo" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataRifiustata" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataRifiutataAltroEnte" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataAccettata" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataVerificata" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataRisolta" nullable="true" collection="false"/>
                <field type="DATE" length="255" name="dataSegnalazione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="NumeroTelefono" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="IndirizzoMailAltroEnte" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="DescrizioneChiusuraSegnalazione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="DescrizioneRipresaSegnalazione" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="IndirizzoGeolocalizzato" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="DataSegnalazioneGestionaleVerificata" nullable="true" collection="false"/>
                <field type="INTEGER" length="255" name="FLTicket" nullable="true" collection="false"/>
                <field type="STRING" length="255" name="IdentificativoPratica" nullable="true" collection="false"/>
            </fields>
            <uniqueConstraints/>
            <queries/>
            <indexes/>
        </businessObject>
    </businessObjects>
</businessObjectModel>`

I receive an error.

this is the log:

2015-11-25 12:12:36.982 -0500 org.hibernate.dialect.H2Dialect org.hibernate.dialect.H2Dialect <init>
WARN: HHH000431: Unable to determine H2 database version, certain features may not work
2015-11-25 12:12:37.277 -0500 org.hibernate.tool.hbm2ddl.SchemaUpdate org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: HHH000388: Unsuccessful: create table SEGNAL3 (persistenceId bigint generated by default as identity, CATEGORIA varchar(255), DATASEGNALAZIONEGESTIONALEVERIFICATA varchar(255), DESCRIZIONE clob, DESCRIZIONECHIUSURASEGNALAZIONE varchar(255), DESCRIZIONERIPRESASEGNALAZIONE varchar(255), FLTICKET integer, IDENTIFICATIVOPRATICA varchar(255), INDIRIZZOGEOLOCALIZZATO varchar(255), INDIRIZZOMAILALTROENTE varchar(255), LAT double, LINKESTERNO varchar(255), LONG double, MAILACCETTAZIONESEGNALATORE clob, MAILCHIUSURASEGNALATORE varchar(255), MAILRIFIUTOSEGNALATORE clob, MAILRIPRESASEGNALATORE varchar(255), MAILSEGNALATORERIPRESASEGNALAZIONE varchar(255), MAILSEGNALATORESEGNALAZIONEGESTIONALE varchar(255), MAILSEGNALAZIONEALTROENTE varchar(255), MAILUTENTEESITOVERIFICA varchar(255), NUMEROPROTOCOLLO varchar(255), NUMEROTELEFONO varchar(255), ORIGINE varchar(255), STATOSEGNALAZIONE varchar(255), TIPOLOGIA varchar(255), TITOLO varchar(255), USEREMAIL varchar(255), DATAACCETTATA timestamp, DATARIFIUSTATA timestamp, DATARIFIUTATAALTROENTE timestamp, DATARISOLTA timestamp, DATASEGNALAZIONE timestamp, DATAVERIFICATA timestamp, EALTROENTE boolean, EMIRAFIORISUD boolean, ERIFIUTATA boolean, ESEGNALAZIONEGESTIONALE boolean, EVERIFICATA boolean, MAILSEGNALATOREACCETTATOALTROENTE varchar(255), persistenceVersion bigint, primary key (persistenceId))
2015-11-25 12:12:37.277 -0500 org.hibernate.tool.hbm2ddl.SchemaUpdate org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: ERROR: syntax error at or near "generated"
Position: 58
2015-11-25 12:12:37.294 -0500 org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [org.postgresql.util.PSQLException: ERROR: syntax error at or near "generated"
Position: 58]
org.bonitasoft.web.toolkit.client.common.exception.api.APIException: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [org.postgresql.util.PSQLException: ERROR: syntax error at or near "generated"
Position: 58]
at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:35)
at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:41)
at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:27)
at org.bonitasoft.web.rest.server.framework.API.runAdd(API.java:156)
at org.bonitasoft.web.rest.server.framework.APIServletCall.doPost(APIServletCall.java:213)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doPost(ToolkitHttpServlet.java:188)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:226)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [org.postgresql.util.PSQLException: ERROR: syntax error at or near "generated"
Position: 58]
at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:282)
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:497)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:463)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:432)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:316)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:439)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
at com.sun.proxy.$Proxy20.installBusinessDataModel(Unknown Source)
at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:31)
... 55 more
Caused by: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [org.postgresql.util.PSQLException: ERROR: syntax error at or near "generated"
Position: 58]
at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.update(BusinessDataModelRepositoryImpl.java:171)
at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.createAndDeployServerBDMJar(BusinessDataModelRepositoryImpl.java:161)
at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.install(BusinessDataModelRepositoryImpl.java:150)
at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:278)
... 68 more

As I can see the query produce an error, how can avoid this problem? There's a workaround to Import and activate a new Business Data Model manually?

Regards

Comments

Submitted by thiagoaugs on Thu, 12/22/2016 - 17:17

Has anyone managed to solve this problem ??

Permalink
No answers yet.
Notifications