Error + Database configuration for Business data

Hey @philippe, thanks for ur answer, I´m running the 7.0.9 Java jdk Version, but I think that is not the problem, because when I executed at the first time the Jboss bundle my Bonita BPM Engine Tables were generated without any problem, actually i have 2 process and 1 organization installed, the problem starts when i try to install the Business Data .

This is my Standalone configuration for the Business Data - Data Bases :

<datasource jta="false" jndi-name="java:jboss/datasources/NotManagedBizDataDS" pool-name="NotManagedBizDataDS" enabled="true" use-java-context="false" use-ccm="false">
<connection-url>jdbc:postgresql://localhost:5432/datos_negocio</connection-url>
<driver>postgres</driver>
<security>
<user-name>postgres</user-name>
<password>admin</password>
</security>
<validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<background-validation-millis>30000</background-validation-millis>
</validation>
<timeout>
<idle-timeout-minutes>0</idle-timeout-minutes>
</timeout>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>

<xa-datasource jndi-name="java:jboss/datasources/BusinessDataDS" pool-name="BusinessDataDS" enabled="true" use-java-context="false" use-ccm="false">
<xa-datasource-property name="URL">
jdbc:postgresql://localhost:5432/datos_negocio
</xa-datasource-property>
<driver>postgres</driver>
<xa-pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>50</max-pool-size>
<prefill>true</prefill>
</xa-pool>
<security>
<user-name>postgres</user-name>
<password>admin</password>
</security>
<validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<background-validation-millis>30000</background-validation-millis>
</validation>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</xa-datasource>

Thanks in advance

Hey @philippe, thanks again for u answer i checked Bonita page and I used the new Bonita 7.0.3 it has a specific configuration as you show me before. I was thinking that maybe it will fix my error but not, i have the same error when i try to install the business data.

16:37:12,225 GRAVE [org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet] (http--127.0.0.1-8080-7) org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model: org.bonitasoft.web.toolkit.client.common.exception.api.APIException: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model
    at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:35) [console-server-7.0.3.jar:]
    at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:41) [console-server-7.0.3.jar:]
    at org.bonitasoft.web.rest.server.api.tenant.APIBusinessDataModel.add(APIBusinessDataModel.java:27) [console-server-7.0.3.jar:]
    at org.bonitasoft.web.rest.server.framework.API.runAdd(API.java:156) [console-server-7.0.3.jar:]
    at org.bonitasoft.web.rest.server.framework.APIServletCall.doPost(APIServletCall.java:213) [console-server-7.0.3.jar:]
    at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doPost(ToolkitHttpServlet.java:188) [console-server-7.0.3.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.0.3.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.0.3.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.0.3.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.0.3.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.0.3.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.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(Thread.java:745) [rt.jar:1.7.0_79]
Caused by: org.bonitasoft.engine.business.data.BusinessDataRepositoryDeploymentException: USERNAME=install | org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model
    at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:282) [bonita-server-7.0.3.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
    at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
    at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:467) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:436) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:443) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:278) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:131) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) [bonita-common-7.0.3.jar:]
    at com.sun.proxy.$Proxy24.installBusinessDataModel(Unknown Source)
    at org.bonitasoft.web.rest.server.engineclient.TenantManagementEngineClient.installBusinessDataModel(TenantManagementEngineClient.java:31) [console-server-7.0.3.jar:]
    ... 48 more
Caused by: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model
    at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.createClientBDMZip(BusinessDataModelRepositoryImpl.java:180) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.install(BusinessDataModelRepositoryImpl.java:149) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.installBusinessDataModel(TenantAdministrationAPIImpl.java:278) [bonita-server-7.0.3.jar:]
    ... 61 more
Caused by: org.bonitasoft.engine.business.data.SBusinessDataRepositoryDeploymentException: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model
    at org.bonitasoft.engine.bdm.AbstractBDMJarBuilder.build(AbstractBDMJarBuilder.java:66) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.generateClientBDMZip(BusinessDataModelRepositoryImpl.java:206) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.business.data.impl.BusinessDataModelRepositoryImpl.createClientBDMZip(BusinessDataModelRepositoryImpl.java:177) [bonita-server-7.0.3.jar:]
    ... 63 more
Caused by: org.bonitasoft.engine.bdm.CodeGenerationException: Error when generating source files for business object model
    at org.bonitasoft.engine.bdm.AbstractBDMJarBuilder.addSourceFilesToDirectory(AbstractBDMJarBuilder.java:74) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.client.ClientBDMJarBuilder.addSourceFilesToDirectory(ClientBDMJarBuilder.java:37) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.AbstractBDMJarBuilder.build(AbstractBDMJarBuilder.java:59) [bonita-server-7.0.3.jar:]
    ... 65 more
Caused by: java.lang.IllegalArgumentException: Class com.company.model.SolicitudVacaciones already exists in target runtime environment.
    at org.bonitasoft.engine.bdm.EntityCodeGenerator.validateClassNotExistsInRuntime(EntityCodeGenerator.java:179) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.EntityCodeGenerator.addEntity(EntityCodeGenerator.java:69) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.AbstractBDMCodeGenerator.buildJavaModelFromBom(AbstractBDMCodeGenerator.java:74) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.AbstractBDMCodeGenerator.generateBom(AbstractBDMCodeGenerator.java:64) [bonita-server-7.0.3.jar:]
    at org.bonitasoft.engine.bdm.AbstractBDMJarBuilder.addSourceFilesToDirectory(AbstractBDMJarBuilder.java:72) [bonita-server-7.0.3.jar:]
    ... 67 more

Hey @philippe thanks for your help, but i cant solved my problem with your answer. So i decided to start the Bonita Portal implementation again, and dont install any process and company just the Business Data, but i get the same error or when i try for 2 time the same error about "already exist" ...

can u tell me if im right about the steps that I follwing for the Business Data configuration ?

1) change the standalone.xls Business data configuration (easy the examples are there)
2) I used the Postgres JDBC driver just one code line for the Bonita Business Data database and the Bonita BPM standard database
3) create 2 database on postgres with a privileged user. (for standar database and Business Data database)
4) edit postgresql.conf and set a non-zero value for max_prepared_transactions. (100 as normally)
5) created the driver folder on modules folder and put the driver and the module.xls file (org.postgresql.main)
6) change this line db.vendor=${sysprop.bonita.db.vendor:postgres} on bonita-platform-community.properties

as i mention before I havent any problem when the Bonita BPM standard database tables created, only when the ** Business Data database** try to create the tables. (when i install it)

I was reading the manual i notice this point : The Hibernate library to generate SQL queries compatible with your RDBMS / ¿what is this library?

i hope you can help me or give me an idea, i´m really grateful for ur help.

cheers