Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


...

titleArchival

The following groups contain Adeptia Connect microservices ArchivalAndCleanup properties that can be configured by going to Account > Settings > Microservice Settings. For more details on properties configuration, refer to the page Configuring the application properties.

abpm.logTable.delete.
Expand
titleArchival And Cleanup
abpm.logs.archival.dbTypeType of log database.As specified during installation
Expand
titleCleanUp


Property nameDescription

abpm.AC_AUDITTRAIL_LOG.cleanup.column

AuditTrail cleanup column.

abpm.AC_AUDITTRAIL_LOG.pk.column

Primary Key for AC_AUDITTRAIL_LOG.

abpm.AC_TXN_EXE_ERROR.cleanup.column

AC_TXN_EXE_ERROR cleanup column.

abpm.AC_TXN_EXE_LOG.cleanup.column

AC_TXN_EXE_LOG cleanup column.

abpm.AC_TXN_EXE_LOG.delete.starttime.column

AC_TXN_EXE_LOG delete column.

abpm.AC_TXN_EXE_LOG.pk.column

Primary Key for AC_TXN_EXE_LOG.

abpm.AC_TXN_EXE_LOG.txn.pid.column

Property that define transactionDomainId / transactionPID column name for AC_TXN_EXE_LOG table based on which clean up for running transactions data will not be done.

abpm.appmanagement.log.solutionGroupNames

Property that defines different solution groups. Each solution group contains log tables on which clean up action will be performed. It can contain any number of comma separated solution group names. On adding any new group, specify logRetainTime, cleanup.class property too for that group.

abpm.appmanagement.logTablesNames

Property that define different log tables on which clean up action will be performed. It can contain any number of comma separated table name. On adding any new table, specify logRetainTime, cleanup.column, txn.domainId.column/txn.pid.column property too.

abpm.appmanagement.retainTime

Data Cleanup Retain Time.

abpm.logTable.delete.retryCount

Number of times the utility shall try running the delete query for all tables in case there is an error in executing it. Error codes for which retry shall be performed needs to be specified in property 'abpm.logs.delete.retryErrorCodes'
EDI. retain time for archive log(in days) for different log solution groups. For each entry in abpm.appmanagement.log.solutionGroupNames, provide this property. Syntax is abpm.archive.solutionGroupName.logRetainTime. If this property is not specified, then default retain time of 30 days will be considered for this group.Defines log. If the value is left blank then it takes 30 days as the default retain time.
Property nameDescription
abpm.archive.fetchsizeNumber of records to be fetched at a time from result set cursor.
abpm.archive.pagesizeThe total number of records to be fetched by the query in a single page.
abpm.archive.chunksizeNumber of records to be processed in each thread. All the threads run in parallel fashion.
abpm.logs.archival.enable

Option Property to enable or disable the archival of the process flow repository and logs. Set

Set this property is to yes, to yes if you want to archive the process flow repositories and logs before they are cleaned up by the cleanup process. If you set this property to no, then the repositories are not archived before cleanup.

+

Enable or disable Archival of Process flow log

 

abpm.logs.b2b.retainTime

Property that defines the retain time for EDI and non-EDI transactions/templates.

abpm.logs.db.retryErrorCodes

Comma separated error Error codes for which retry shall be is performed in case there is any an error occurs while executing the query for all the tables.

You can enter multiple error code separated by comma.

abpm.logs.db.skipErrorCodes

opposite of aboveError codes for which no retry takes place in case an error occurs while executing the query for all the tables.

You can enter multiple error code separated by comma.

abpm.logs.migration.retainTime

Property that defines the retain time for migration log table.

abpm.logs.retainTimeabpm.logs.retryInterval

Time interval(in seconds) after which the re-execution of delete query for transaction log and transaction data tables will be performed if the first execution of the query fails.

abpm.AC_AUDITTRAIL_LOG.logRetainTime

Property that defines the retain time for AC_AUDITTRAIL_LOG.

abpm.archive.dataRetainTime

Defines the retain time for archive data. If the value is left blank then retain time specified for log will be taken as data retain time

Property that defines the retain time for tables other than EDI, and migration.

abpm.logs.retryCount

Number of times the utility shall try running the delete query for all tables in case there is an error in executing it. Error codes for which retry shall be performed needs to be specified in property 'abpm.logs.delete.retryErrorCodes'

.

abpm.archive.logRetainTimeProperty that defines

abpm.archive.logRetainTime

the retain time for archive

abpm.create.repository.archive.path

Specifies whether to create the archive folder or not if it does not exist. Set this property to yes, if you want to archive the process flow logs before they are cleaned up by the cleanup process. If you set this property to no, then the logs are not archived before cleanup.yesyes or no

abpm.data.archival.enable

Option to enable or disable the archival of the process flow repository. Set this property is to yes, if you want to archive the process flow repositories before they are cleaned up by the cleanup process. If you set this property to no, then the repositories are not archived before cleanup.yesyes or no

abpm.EDI.logRetainTime

Property that defines the retain time for EDI.

abpm.logs.archival.batch.enable

Specifies whether to archive the logs record by record or in a batch. If the values is no, records are archived one by one.
If the value is yes, the records are archived in batches.
noyes or no

abpm.logs.archival.enable

Enable or disable Archival of Process flow logyesyes or no

abpm.logs.deleteData.onArchivalFailure

Specifies whether to delete the records from the log table, if an error occurs in archival. If the value is no, then records from main log tables are not deleted when there is any error during archival.
If the value is yes, then records from main log tables are deleted, even if there is any error during archival.
It is recommended to keep this property as no.
noyes or no

abpm.logs.skipErrorRecordOnArchival

Option to continue archival process in case an error occurs during archival process. Error codes for which archival process shall be continued further needs to be specified in property 'abpm.logs.archival.skipErrorCodes'

abpm.logTables.archive.chunks.size

To archive data in chunks. Only positive integer will be a valid value. Use maximum value 999 in case of Oracle.

adeptia.group.names

Group Names (comma separated).
Expand
titleArchival Database
Property nameDescriptionDefault valuePossible valueabpm.logs.archival.batch.size

Specifies the number of records to be archived in one batch. Its value specifies the number of records, which are archived in one batch, when abpm.logs.archival.batch.enable property is set to yes.

1000any integerabpm.logs.archival.database

Specifies whether to archive the logs on the same database, which is used to store the logs, or to use another database. Set this property to 1, if you want to archive the logs in the same database, where the logs are being stored. In this case, for every log table, an archive table is created in the log database and logs are archived in these tables.
Set this property to 2, if you want to archive the logs in different database. It is recommended to use a different database to archive the logs because archiving the logs on the same database may affect the performance.

11 or 2
tables.
abpm.logs.retryCount

The number of times the application retries running the query for log cleanup and archival in case the query execution fails.

The number of times the retry happens in case of failure of execution of a query.

abpm.logs.retryInterval

Time interval (in seconds) after which the re-execution of

delete

query for transaction log and transaction data tables

will be

is performed if the

first

query execution

of the query

fails.

abpm.logTables.delete.chunks.delay

Option to configure the delay between consecutive chunk deletion. Value provided is in seconds.

abpm.logTables.delete.chunks.enable

Enable this property to delete log table data in chunks.

abpm.logTables.delete.chunks.size

Option to configure the number of rows that will delete from the table per chunk. For SQL-Server database server we should not keep chunk size value to more than 5000; otherwise it will do lock escalation i.e. it will exclusively lock the entire table.
Expand
titleLog Database
Property nameDescriptionDefault valuePossible value



abpm.logdb.isolation.levelControls the transaction locking behavior for all statements issued by a connection.1

Any integer

abpm.logs.dbTypeType of log database.

 As specified during installation.

abpm.logTables.autoCommit.enableOption to configure whether database transactions commit automatically or not.abpm.logTables.fetchSizeOption to configure the number of rows that shall be fetched from the database each time new set of records is needed.
Expand
titleLogging


Property nameDescription
logging.level.rootRoot Application logging level. For production server, it is recommended to use NOTICE log level.
logging.level.systemSystem logging level. For production server, it is recommended to use NOTICE log level.
logging.pattern.console



Expand
titleMail Notification


Property nameDescriptionDefault valuePossible value
abpm.logs.sendNotification.onArchivalFailureSpecifies whether to send a mail, if an error occurs during log archival. If the value is no, then no mail notification is sent in case of any error during log archival.
If the value is yes, then mail notification is sent to the email address configured for the admin user, in case of any error during log archival. If this property is set to yes, then make sure that the Mail Server Parameter properties are configured properly.
yesyes or no



Expand
titleOthers


Property nameDescription
abpm.log.connection.retryTimeIntervalTime interval (in seconds) after which the next retry for log database will be done.