How do I enable MSSQL AlwaysOn within Ephesoft when Upgrading non-AlwaysOn Ephesoft to AlwaysOn Ephesoft?

 

Applies to: 3.1.2.1+

Following configurations need to be changed to enable ALWAYS ON feature after upgrade:-

 

1.      Stop the Ephesoft server if it is currently running.

2.      We need to change the following configurations in properties located at ‘Application/WEB-INF/classes/META-INF’:-

a.      In ‘dcma-data-access/dcma-db.properties’ edit the following properties as:-

 

·        dataSource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

·        dataSource.dialect=org.hibernate.dialect.SQLServerDialect

·        dataSource.url= jdbc\:sqlserver\://${dataSource.serverName};databaseName\=${dataSource.databaseName};user\=${dataSource.username};password\=${dataSource.password};MultiSubnetFailover\=True;ApplicationIntent\=ReadWrite;loginTimeout=200

·        upgradePatch.enable=true

 

b.      In ‘dcma-performance-reporting/dcma-report-db.properties’ edit the following properties:-

 

·        hibernate.connection.url=jdbc\:sqlserver\:<server-name (like- locahost)>:<port (like-1433)>;databaseName\=<database-name> (like-ephesoft_report);user\=<username>;password\=<Password>;MultiSubnetFailover\=True;ApplicationIntent\=ReadWrite;loginTimeout=200

·        hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver

·        hibernate.dialect=org.hibernate.dialect.SQLServerDialect

 

c.      In ‘dcma-reporting/hibernate.cfg.xml’ and ‘dcma-reporting/hibernate-dcma.cfg.xml’ edit the following properties:-

 

·        <property name=”connection.driver_class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</property>

·        <property name=”connection.url”>jdbc\:sqlserver\:<server-name (like- locahost)>: <port (like-1433)>;databaseName\=<database-name (like-ephesoft_report)>;user\=<username>;password\=<Password>;MultiSubnetFailover\=True;ApplicationIntent\=ReadWrite;loginTimeout=200;</property>

·        <property name=”dialect”>org.hibernate.dialect.SQLServerDialect</property>

 

d.      In ‘dcma-workflows/dcma-workflows.properties’ edit the following property:-

 

workflow.deploy=true

 

3.      Take the backup and delete the ‘Application/WEB-INF/classes/META-INF/dcma-data-access/post-schema.sql’.

4.      Copy post-schema.sql’ at ‘Application/WEB-INF/classes/META-INF/dcma-data-access/AlwaysOnFeatureConfiguration’ to ‘Application/WEB-INF/classes/META-INF/dcma-data-access/’.

5.      In case of fresh database remove ‘-executed’ from all file names located at ‘SharedFolders/database-update

6.      Restart the Ephesoft server.

Was this article helpful to you?

Walter Lee

Comments are closed.