application.yml
The application.yml file configures the Sign-Off database settings, including initial load, schema, cube-level adjustments, conflicts, and domains.
Location: signoff-starter\src\main\resources.
File values
| Property | Value | Description |
|---|---|---|
| server.port | 9090 | Port used by the sign-off server application |
| management.endpoints.web.exposure.include | “*” | List of the Spring Boot Actuator endpoint exposed in the application |
Section: content.hibernate
This section configures the Content Service database and connections to the Content Server.
| Property | Value | Description |
|---|---|---|
| content.hibernate.connection.url | “jdbc:h2:mem:content_service;DB_CLOSE_DELAY=-1” | URL of the Hibernate connection to the content server. |
| content.hibernate.connection.driver_class | org.h2.Driver | Driver used for the Hibernate connection to the content server |
| content.hibernate.dialect | “org.hibernate.dialect.H2Dialect” | SQL dialect used for the Hibernate connection to the content server |
| content.hibernate.show_sql | false | Flag used to set up the printing of the SQL queries in the Hibernate logs |
| content.hibernate.format_sql | false | Flag used to set up the formatting of the SQL queries in the Hibernate logs |
| content.hibernate.hbm2ddl.auto | update | Hibernate DDL generation setup to run on startup against the content server database. NOTE: Remove this line once the table is created. |
| content.hibernate.hikari.connectionTimeout | 30000 | Maximum time (in milliseconds) that a client will wait for a connection from the pool (connection to the content server). |
| content.hibernate.hikari.idleTimeout | 60000 | Maximum time (in milliseconds) that a connection is allowed to sit idle in the pool (connection to the content server). |
| content.hibernate.hikari.minimumIdle | 1 | Minimum number of idle connections that HikariCP tries to maintain in the pool (connection to the content server) |
| content.hibernate.hikari.maximumPoolSize | 10 | Maximum size that the pool is allowed to reach, including both idle and in-use connections (connection to the content server). |
| content.hibernate.hikari.poolName | “content” | User-defined name for the connection pool. Displayed mainly in logging and JMX management consoles to identify pools |
Section: JWT configuration
This section configures the JWT parameters used for authentication
| Property | Value | Description |
|---|---|---|
| qfs.jwt.key.public | The RSA key public key encoded in Base64, used to verify the integrity of the tokens | |
| qfs.jwt.key.private | The RSA key private key encoded in Base64, used to sign the tokens | |
| qfs.expiration | 43200 | The lifetime of the tokens in seconds |
Section: Content Server security configuration
This section configures the Content Service entitlements
| Property | Value | Description |
|---|---|---|
| contentServer.security.calculatedMemberRole | ROLE_USER | The role users must have to create calculated members in the content server |
| contentServer.security.kpiRole | ROLE_USER | The role users must have to create KPIs in the content server |
| contentServer.security.cache.entitlementsTTL | 3600 | The time to live of the entitlement cache |
Section: Activiti History
This section configures the use of the Activiti History. See Activity user guide for details about the Activiti History: https://www.activiti.org/userguide/
| Property | Value | Description |
|---|---|---|
| spring.activiti.dbHistoryUsed | true | Flag used to enable/disable the Activiti History |
| spring.activiti.historyLevel | full | Activity History level |
Section: Activiti database
This section configures the Activiti database and the connection to the Activiti database.
| Property | Value | Description |
|---|---|---|
| activiti.datasource.url | “jdbc:h2:file:./sign-off-activiti;DB_CLOSE_DELAY=-1” | URL of the Hibernate connection to the Activiti database. |
| activiti.datasource.username | activiti | User name used for the Hibernate connection to the Activiti database. |
| activiti.datasource.password | password | Password used for the Hibernate connection to the Activiti database |
| activiti.datasource.properties.hibernate.dialect | org.hibernate.dialect.H2Dialect | SQL dialect used for the Hibernate connection to the Activiti database. |
| activiti.datasource.properties.hibernate.format_sql | true | Flag used to set up the formatting of the SQL queries in the Hibernate logs |
| activiti.datasource.properties.hibernate.hbm2ddl.auto | update | Hibernate DDL generation setup to run on startup against the Activiti database. NOTE: Remove this line once the table is created. |
| activiti.datasource.hikari.connectionTimeout | 30000 | Maximum time (in milliseconds) that a client will wait for a connection from the pool (connection to the Activiti database). |
| activiti.datasource.hikari.idleTimeout | 60000 | Maximum time (in milliseconds) that a connection is allowed to sit idle in the pool (connection to the Activiti database). |
| activiti.datasource.hikari.minimumIdle | 1 | Minimum number of idle connections that HikariCP tries to maintain in the pool (connection to the Activiti database). |
| activiti.datasource.hikari.maximumPoolSize | 10 | Maximum size that the pool is allowed to reach, including both idle and in-use connections (connection to the Activiti database). |
| activiti.datasource.hikari.poolName | “activiti” | User-defined name for the connection pool. Displayed mainly in logging and JMX management consoles to identify pools |
Section: Application database
This section configures the Activiti database and the connection to the Application database.
| Property | Value | Description |
|---|---|---|
| application.datasource.url | “jdbc:h2:tcp://localhost/./application-signoff” | URL of the Hibernate connection to the Application database. |
| application.datasource.username | app | User name used for the Hibernate connection to the Application database. |
| application.datasource.password | Password used for the Hibernate connection to the Application database | |
| application.datasource.properties.hibernate.dialect | org.hibernate.dialect.H2Dialect | SQL dialect used for the Hibernate connection to the Application database. |
| application.datasource.properties.hibernate.format_sql | true | Flag used to set up the formatting of the SQL queries in the Hibernate logs |
| application.datasource.properties.hibernate.hbm2ddl.auto | update | Hibernate DDL generation setup to run on startup against the Application database. NOTE: Remove this line once the table is created. |
| application.datasource.hikari.connectionTimeout | 30000 | Maximum time (in milliseconds) that a client will wait for a connection from the pool (connection to the Application database). |
| application.datasource.hikari.idleTimeout | 60000 | Maximum time (in milliseconds) that a connection is allowed to sit idle in the pool (connection to the Application database). |
| application.datasource.hikari.minimumIdle | 1 | Minimum number of idle connections that HikariCP tries to maintain in the pool (connection to the Application database). |
| application.datasource.hikari.maximumPoolSize | 10 | Maximum size that the pool is allowed to reach, including both idle and in-use connections (connection to the Application database). |
| application.datasource.hikari.poolName | “application” | User-defined name for the connection pool. Displayed mainly in logging and JMX management consoles to identify pools |
Section: RESTful service
This section configures the access to the RESTful service used to communicate with the ActivePivot server that contains the data to be signed-off (in this case, the MRA application)
| Property | Value | Description |
|---|---|---|
| application.rest-apis.MRA.url | http://localhost:10010/risk-activepivot/services/rest/v3 | URL of the RESTful server used for operations on the signed-off data in the ActivePivot application where those data are present (MRA) |
| application.rest-apis.MRA.user | admin | User id used to send requests on the RESTful service (MRA) |
| application.rest-apis.MRA.password | admin | Password used to send requests on the RESTful service (MRA) |
| application.rest-apis.FRTB.url | http://localhost:8080/frtb-starter/services/rest/v3 | URL of the RESTful server used for operations on the signed-off data in the ActivePivot application where those data are present (FRTB - placeholder for now) |
| application.rest-apis.FRTB.user | admin | User id used to send requests on the RESTful service (FRTB - placeholder for now) |
| application.rest-apis.FRTB.password | admin | Password used to send requests on the RESTful service (FRTB - placeholder for now) |
note
To add the configuration related to other application servers, add these properties:
- application.rest-apis.
.url - application.rest-apis.
.user - application.rest-apis.
.password
where
Section: Audit Log Database
This section configures the Activiti database and the connection to the Audit Log database.
| Property | Value | Description |
|---|---|---|
| audit-log.datasource.url | “jdbc:h2:tcp://localhost/./audit-log” | URL of the Hibernate connection to the Audit Log database. |
| audit-log.datasource.username | audit | User name used for the Hibernate connection to the Audit Log database. |
| audit-log.datasource.password | Password used for the Hibernate connection to the Audit Log database. | |
| audit-log.datasource.properties.hibernate.dialect | org.hibernate.dialect.H2Dialect | SQL dialect used for the Hibernate connection to the Audit Log database. |
| audit-log.datasource.properties.hibernate.format_sql | true | Flag used to set up the formatting of the SQL queries in the Hibernate logs |
| audit-log.datasource.properties.hibernate.hbm2ddl.auto | update | Hibernate DDL generation setup to run on startup against the Audit Log database. NOTE: Remove this line once the table is created. |
| audit-log.datasource.hikari.connectionTimeout | 30000 | Maximum time (in milliseconds) that a client will wait for a connection from the pool (connection to the Audit Log database). |
| audit-log.datasource.hikari.idleTimeout | 60000 | Maximum time (in milliseconds) that a connection is allowed to sit idle in the pool (connection to the Audit Log database). |
| audit-log.datasource.hikari.minimumIdle | 1 | Minimum number of idle connections that HikariCP tries to maintain in the pool (connection to the Audit Log database). |
| audit-log.datasource.hikari.maximumPoolSize | 10 | Maximum size that the pool is allowed to reach, including both idle and in-use connections (connection to the Audit Log database). |
| audit-log.datasource.hikari.poolName | “audit-log” | User-defined name for the connection pool. Displayed mainly in logging and JMX management consoles to identify pools |
Section: sign-off
This section defines additional properties used in the sign-off process
| Property | Value | Description |
|---|---|---|
| sign-off.workflow-types.4-eyes | sign-off-process-instance.four-eyes | Maps the ‘4-eyes’ workflow type used for the creation of sign-off tasks to the ‘sign-off-process-instance.four-eyes’ workflow |
| sign-off.workflow-types.simple | sign-off-process-instance.simple | Maps the ‘simple’ workflow type used for the creation of sign-off tasks to the ‘sign-off-process-instance.simple’ workflow |
| sign-off.workflow-types.4-eyes-kpi | sign-off-process-instance.four-eyes-kpi | Maps the ‘4-eyes-kpi’ workflow type used for the creation of sign-off tasks to the ‘sign-off-process-instance.four-eyes-kpi’ workflow |
| sign-off.export.polling-period-in-milliseconds | 1000 | Polling period (in milliseconds) of the task that polls for the export status / |
| sign-off.export.initial-delay-in-milliseconds | 100 | Delay (in milliseconds) before the polling for the export status starts |
| sign-off.export.timeout-delay-in-milliseconds | 3600000 | Delay (in milliseconds) before the polling will timeout by raising an error and stop |
| sign-off.export.scheduler-pool-size | 1 | Size of the thread pool used for the polling of the export status |