To check the approved versions of Microsoft SQL Server, go to the Portability matrix
As of the Liquid (1.6.5) update, it is no longer necessary to perform any database compatibility commands. However, if you have a previous update, you must go to the Microsoft SQL Server Management Studio and define the database compatibility level for SQL Server 2012, by running the following command:
If you do not run the command, the platform’s startup process will be blocked. |
TOTVS Fluig Platform requires a database with Latin1_General_CI_AS encoding. To create the database with this characteristic, log in to SQL Server with the user that will be used by Fluig and run the following SQL command:
CREATE DATABASE database_name COLLATE Latin1_General_CI_AS; |
Where database_name is the name of the database to be created.
Another alternative for the creation of the database is to use the Microsoft SQL Server Management Studio, following these steps:
|
After creating the database, you need to perform the following checks:
The user used by TOTVS Fluig Platform to connect to the database should be the owner (db_owner) of the database used by Fluig. To check which user is the database owner, run the following SQL command:
SELECT suser_sname(owner_sid) FROM sys.databases WHERE name = 'database_name'; |
Where database_name is the name of the database to query the owner.
If the database owner is not the user used by Fluig to connect to the database, run the following T-SQL command to define this user as owner (db_owner):
USE database_name EXEC sp_changedbowner 'user_name'; |
Where database_name is the database name and user_name is the user who will become the database owner.
To check if the isolation option READ_COMMITTED_SNAPSHOT is enabled for the database, run the following SQL command:
SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name= 'database_name'; |
Where database_name is the name of the database to query the owner.
If the return of the previous query is the value 0, you need to run the following SQL command:
ALTER DATABASE database_name SET READ_COMMITTED_SNAPSHOT ON; |
Where database_name is the name of the database to be used for Fluig.
This SQL Server standard isolation level change operation is performed automatically by Fluig. However, it is important to pay attention to the following factor:
When creating the database, a change action is run on the database. It is normal to see some error messages in the log, in the case of a standard process for update. The situation will be normalized at the end of the operation. As soon as the Fluig server is up, we recommend restarting it. |
If you use SQL Server 2014 or higher, you need to change the file <INSTALL_FLUIG>\jboss\bin\standalone.conf.bat (standalone.conf in Linux environments) and add the following line:
set "JAVA_OPTS=%JAVA_OPTS% -Dhibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect" |