org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]: 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: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]

JIRA | Khaled metwaly | 5 months ago
  1. 0

    error are following: 10:20:35,577 INFO [java.sql.DatabaseMetaData] (http--127.0.0.1-8080-4) HHH000262: Table not found: REQUEST 10:20:35,587 INFO [java.sql.DatabaseMetaData] (http--127.0.0.1-8080-4) HHH000262: Table not found: REQUEST 10:20:35,591 INFO [java.sql.DatabaseMetaData] (http--127.0.0.1-8080-4) HHH000262: Table not found: REQUEST 10:20:35,594 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (http--127.0.0.1-8080-4) HHH000388: Unsuccessful: create table REQUEST (persistenceId bigint generated by default as identity, LOCTION varchar(255), REQUEST varchar(255), SOURCE timestamp, TITLE timestamp, persistenceVersion bigint, primary key (persistenceId)) 10:20:35,598 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (http--127.0.0.1-8080-4) Incorrect syntax near 'generated'. 10:20:35,598 SEVERE [org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet] (http--127.0.0.1-8080-4) org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]: 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: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.] at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:35) [console-server-7.3.0.jar:] at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:41) [console-server-7.3.0.jar:] at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:27) [console-server-7.3.0.jar:] at org.bonitasoft.web.rest.server.framework.API.runAdd(API.java:150) [console-server-7.3.0.jar:] at org.bonitasoft.web.rest.server.framework.APIServletCall.doPost(APIServletCall.java:213) [console-server-7.3.0.jar:] at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doPost(ToolkitHttpServlet.java:188) [console-server-7.3.0.jar:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75) [console-server-7.3.0.jar:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:226) [console-server-7.3.0.jar:] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) [urlrewritefilter-4.0.3.jar:4.0.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60) [console-server-7.3.0.jar:] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:840) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:622) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:560) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:488) [jbossweb-7.0.13.Final.jar:] at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) [urlrewritefilter-4.0.3.jar:4.0.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60) [console-server-7.3.0.jar:] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60) [console-server-7.3.0.jar:] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:] at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:] at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_80] Caused by: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.] at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:282) [bonita-server-7.3.0.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_80] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_80] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_80] at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_80] at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86) [bonita-common-7.3.0.jar:] at com.sun.proxy.$Proxy54.installBusinessDataModel(Unknown Source) at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:31) [console-server-7.3.0.jar:] ... 49 more Caused by: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.] at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.update(BusinessDataModelRepositoryImpl.java:166) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.createAndDeployServerBDMJar(BusinessDataModelRepositoryImpl.java:156) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.install(BusinessDataModelRepositoryImpl.java:147) [bonita-server-7.3.0.jar:] at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:278) [bonita-server-7.3.0.jar:] ... 62 more

    JIRA | 5 months ago | Khaled metwaly
    org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]: 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: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]
  2. 0

    Error while Import and activate a new Business Data Model | Bonitasoft Community

    bonitasoft.com | 8 months ago
    org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "ACCOORDEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "ACCOORDEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_f47qlrxnnvcexbr07bo1wpcle' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_pajq1dbem0lwly54syreyt8u5' references invalid table 'AURECEPCIONEXP'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "REGISTROPNC" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDANALISISTOPOGRAFICO" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDPREDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_mvgso40wpdse06rnaq2q05ijs' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_oi5yt7my4yu9loldwr4s616lp' references invalid table 'SUBDIVISION'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_9xbejp2k1ck590t3lkoi07ud3' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_42seltjhcbn10hjuxylnmgslf' references invalid table 'SUBDIVISION'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_a9u3jycd3qb8m6wpq9whm3ufl' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_6xniukxkmw55mv5u8biw0lh0e' references invalid table 'TPGANALISIS'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGLEVANTAMIENTODET" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREGFOLPAGO" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREQUISITOS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREQUISITOS" because it does not exist or you do not have permissions.]: 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: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "ACCOORDEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "ACCOORDEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AURECEPCIONEXP" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_f47qlrxnnvcexbr07bo1wpcle' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_pajq1dbem0lwly54syreyt8u5' references invalid table 'AURECEPCIONEXP'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "REGISTROPNC" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDANALISISTOPOGRAFICO" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SDPREDICTAMEN" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "SUBDIVISION" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_mvgso40wpdse06rnaq2q05ijs' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_oi5yt7my4yu9loldwr4s616lp' references invalid table 'SUBDIVISION'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_9xbejp2k1ck590t3lkoi07ud3' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_42seltjhcbn10hjuxylnmgslf' references invalid table 'SUBDIVISION'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGANALISIS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_a9u3jycd3qb8m6wpq9whm3ufl' references invalid table 'REGISTROPNC'., com.microsoft.sqlserver.jdbc.SQLServerException: Foreign key 'FK_6xniukxkmw55mv5u8biw0lh0e' references invalid table 'TPGANALISIS'., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGLEVANTAMIENTODET" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREGFOLPAGO" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREQUISITOS" because it does not exist or you do not have permissions., com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "TPGREQUISITOS" because it does not exist or you do not have permissions.]

    Root Cause Analysis

    1. org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException

      Updating schema fails due to: [com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'generated'.]

      at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.update()
    2. org.bonitasoft.engine
      TenantAdministrationAPIImpl.installBusinessDataModel
      1. org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.update(BusinessDataModelRepositoryImpl.java:166)[bonita-server-7.3.0.jar:]
      2. org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.createAndDeployServerBDMJar(BusinessDataModelRepositoryImpl.java:156)[bonita-server-7.3.0.jar:]
      3. org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.install(BusinessDataModelRepositoryImpl.java:147)[bonita-server-7.3.0.jar:]
      4. org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:278)[bonita-server-7.3.0.jar:]
      4 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[rt.jar:1.7.0_80]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)[rt.jar:1.7.0_80]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[rt.jar:1.7.0_80]
      4. java.lang.reflect.Method.invoke(Unknown Source)[rt.jar:1.7.0_80]
      4 frames
    4. org.bonitasoft.engine
      ClientInterceptor.invoke
      1. org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462)[bonita-server-7.3.0.jar:]
      2. org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431)[bonita-server-7.3.0.jar:]
      3. org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312)[bonita-server-7.3.0.jar:]
      4. org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)[bonita-server-7.3.0.jar:]
      5. org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)[bonita-server-7.3.0.jar:]
      6. org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)[bonita-server-7.3.0.jar:]
      7. org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)[bonita-common-7.3.0.jar:]
      7 frames
    5. com.sun.proxy
      $Proxy54.installBusinessDataModel
      1. com.sun.proxy.$Proxy54.installBusinessDataModel(Unknown Source)
      1 frame
    6. org.bonitasoft.web
      ToolkitHttpServlet.doPost
      1. org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:31)[console-server-7.3.0.jar:]
      2. org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:41)[console-server-7.3.0.jar:]
      3. org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:27)[console-server-7.3.0.jar:]
      4. org.bonitasoft.web.rest.server.framework.API.runAdd(API.java:150)[console-server-7.3.0.jar:]
      5. org.bonitasoft.web.rest.server.framework.APIServletCall.doPost(APIServletCall.java:213)[console-server-7.3.0.jar:]
      6. org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doPost(ToolkitHttpServlet.java:188)[console-server-7.3.0.jar:]
      6 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:754)[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
      1 frame
    8. org.bonitasoft.web
      ToolkitHttpServlet.service
      1. org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)[console-server-7.3.0.jar:]
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
      1 frame
    10. org.bonitasoft.web
      ToolkitHttpServlet.service
      1. org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:226)[console-server-7.3.0.jar:]
      1 frame
    11. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      2 frames
    12. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)[urlrewritefilter-4.0.3.jar:4.0.3]
      2. org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)[urlrewritefilter-4.0.3.jar:4.0.3]
      3. org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)[urlrewritefilter-4.0.3.jar:4.0.3]
      4. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)[urlrewritefilter-4.0.3.jar:4.0.3]
      4 frames
    13. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      2 frames
    14. org.bonitasoft.console
      AbstractAuthorizationFilter.doFilter
      1. org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)[console-server-7.3.0.jar:]
      1 frame
    15. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:840)[jbossweb-7.0.13.Final.jar:]
      4. org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:622)[jbossweb-7.0.13.Final.jar:]
      5. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:560)[jbossweb-7.0.13.Final.jar:]
      6. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:488)[jbossweb-7.0.13.Final.jar:]
      6 frames
    16. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213)[urlrewritefilter-4.0.3.jar:4.0.3]
      2. org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171)[urlrewritefilter-4.0.3.jar:4.0.3]
      3. org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)[urlrewritefilter-4.0.3.jar:4.0.3]
      4. org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)[urlrewritefilter-4.0.3.jar:4.0.3]
      5. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)[urlrewritefilter-4.0.3.jar:4.0.3]
      5 frames
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      2 frames
    18. org.bonitasoft.console
      AbstractAuthorizationFilter.doFilter
      1. org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)[console-server-7.3.0.jar:]
      1 frame
    19. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      2 frames
    20. org.bonitasoft.console
      AbstractAuthorizationFilter.doFilter
      1. org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:60)[console-server-7.3.0.jar:]
      1 frame
    21. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)[jbossweb-7.0.13.Final.jar:]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)[jbossweb-7.0.13.Final.jar:]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)[jbossweb-7.0.13.Final.jar:]
      4 frames
    22. org.bonitasoft.console
      SessionFixationValve.invoke
      1. org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
      1 frame
    23. JBoss Web
      SecurityContextAssociationValve.invoke
      1. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)[jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
      1 frame
    24. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)[jbossweb-7.0.13.Final.jar:]
      3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)[jbossweb-7.0.13.Final.jar:]
      4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)[jbossweb-7.0.13.Final.jar:]
      4 frames
    25. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)[jbossweb-7.0.13.Final.jar:]
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)[jbossweb-7.0.13.Final.jar:]
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)[jbossweb-7.0.13.Final.jar:]
      3 frames
    26. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)[rt.jar:1.7.0_80]
      1 frame