Hi,
I tried to setup the Bonita community with SQL server. I can see that tables are created in the database.
But I am getting the below error.
[INFO] configuration for Database vendor: sqlserver
[INFO] Connected to 'sqlserver' database with url: 'jdbc:sqlserver://localhost:2000;useBulkCopyForBatchInsert=false;cancelQueryTimeout=-1;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=bonitaschema;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;' with user: 'dibyajit'
[INFO] Platform is already created.
[INFO] Upgrading default configuration with files from folder: platform_conf\initial
[INFO] Tomcat environment detected with root D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4
[INFO] Running auto-configuration using file D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\setup\database.properties
[ERROR] Found more than 1 file containing sqlserver drivers in folder D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\setup\lib. Make sure to put only 1 jar or zip file containing drivers there.
[ERROR] You might get more detailed information about the error by adding '--debug' to the command line, and run again
Press any key to continue . . .
Check that Java version is compatible with Bonita
Java full version: 1.8.0_202
Java version: 8
Java version is compatible
------------------------------------------------------
Initializing and configuring Bonita Tomcat bundle
------------------------------------------------------
____ _ _
| _ \ (_) |
| |_) | ___ _ __ _| |_ __ _
| _ < / _ \| '_ \| | __/ _` |
| |_) | (_) | | | | | || (_| |
|____/ \___/|_| |_|_|\__\__,_|
(Platform Setup 7.11.4)
[INFO] Starting PlatformSetupApplication on MSI with PID 9836 (started by dbyaj in D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\setup)
[DEBUG] Running with Spring Boot v2.2.2.RELEASE, Spring v5.2.2.RELEASE
[INFO] The following profiles are active: default
[INFO] configuration for Database vendor: sqlserver
[INFO] Started PlatformSetupApplication in 0.868 seconds (JVM running for 1.285)
[INFO] Connected to 'sqlserver' database with url: 'jdbc:sqlserver://localhost:2000;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=bonitaschema;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;' with user: 'bonitadev1'
[INFO] Platform is already created.
[INFO] Upgrading default configuration with files from folder: platform_conf\initial
[INFO] Tomcat environment detected with root D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4
[INFO] Running auto-configuration using file D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\setup\database.properties
[INFO] Same configuration detected for file 'server\bin\setenv.bat'. No need to change it.
[INFO] Same configuration detected for file 'server\bin\setenv.sh'. No need to change it.
[INFO] Same configuration detected for file 'server\conf\Catalina\localhost\bonita.xml'. No need to change it.
[INFO] Your sqlserver driver file 'server\lib\bonita\sqljdbc42.jar' already exists. Skipping the copy.
[INFO] Your sqlserver driver file 'server\lib\bonita\sqljdbc42.jar' already exists. Skipping the copy.
[INFO] Tomcat auto-configuration complete.
"-----------------------------------------------------"
"Starting Bonita Tomcat bundle"
"-----------------------------------------------------"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Set some JVM system properties required by Bonita
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set PLATFORM_SETUP="-Dorg.bonitasoft.platform.setup.folder=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\..\setup"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set H2_DATABASE_DIR="-Dorg.bonitasoft.h2.database.dir=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\..\h2_database"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set INCIDENT_LOG_DIR="-Dorg.bonitasoft.engine.incident.folder=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\logs"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Define the RDMBS vendor use by Bonita Engine to store data. Valid values are: h2, postgres, sqlserver, oracle, mysql.
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set DB_OPTS="-Dsysprop.bonita.db.vendor=sqlserver"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Define the RDMBS vendor use by Bonita Engine to store Business Data. Valid values are: h2, postgres, sqlserver, oracle, mysql.
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem If you use different DB engines by tenants, please update directly bonita-tenant-community-custom.properties
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set BDM_DB_OPTS="-Dsysprop.bonita.bdm.db.vendor=sqlserver"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Arjuna (JTA service added to Tomcat and required by Bonita Engine for transaction management)
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set ARJUNA_OPTS="-Dcom.arjuna.ats.arjuna.common.propertiesFile=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\conf\jbossts-properties.xml"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Optional JAAS configuration. Usually used when delegating authentication to LDAP / Active Directory server
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem set SECURITY_OPTS="-Djava.security.auth.login.config=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\conf\jaas-standard.cfg"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Pass the JVM system properties to Tomcat JVM using CATALINA_OPTS variable
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set CATALINA_OPTS= "-Dorg.bonitasoft.platform.setup.folder=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\..\setup" "-Dorg.bonitasoft.h2.database.dir=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\..\h2_database" "-Dsysprop.bonita.db.vendor=sqlserver" "-Dsysprop.bonita.bdm.db.vendor=sqlserver" "-Dcom.arjuna.ats.arjuna.common.propertiesFile=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\conf\jbossts-properties.xml" "-Dorg.bonitasoft.engine.incident.folder=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\logs" -Dfile.encoding=UTF-8 -Xshare:auto -Xms1024m -Xmx1024m -XX:+HeapDumpOnOutOfMemoryError
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set CATALINA_PID=D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\catalina.pid
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>set CLASSPATH="D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\lib\ext\*"
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>goto setenvDone
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>rem Get standard Java environment variables
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>if exist "D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\bin\setclasspath.bat" goto okSetclasspath
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>call "D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server\bin\setclasspath.bat" start
Work\Old was unexpected at this time.
D:\My Work\Old Bonita setup\BonitaCommunity-7.11.4\BonitaCommunity-7.11.4\server>
Completed the Installation with My SQL Database.