Usage Transaction Batch Processing Errors and Rollback at Higher Volume (Doc ID 2879592.1)

Last updated on DECEMBER 01, 2023

Applies to:

Goal

On : 2.4.0.0.0 version, Usage Transaction processing:


In MDM version 2.4.0.0 D2-UTCD batch errors out when submitting more than 150 records to be processed in a Multi-threaded environment, especially when many/most Usage Transactions are going to Issue Detected status due to no usage being present for the UT period. Errors are not specific to the Usage Transaction being processed, it can be retried manually and succeed or go to a valid error state, or it can be retried in a subsequent batch and will be fine, although other Usage Transactions which didn't error previously may error instead.

If the volume is high enough, the threads will all rollback any changes executed in the Batch run and all Usage Transactions will go back to CALC-DEFER status.

The following are a sampling of errors:


14:14:55,596 [sample-clusterWorker:0] ERROR (com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner) Encountered an error while logging a transition error. Stopping transition
com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner$TransitionErrorLoggingException: com.splwg.shared.common.ApplicationError: (Server Message)
Category: 11001
Number: 101
Call Sequence:
Program Name: UsageTransactionAutoTransitionBatchProcess$UsageTransactionAutoTransitionBatchProcessWorker
Text: End Date/Time field missing.
Description:
Table: D1_USAGE_PERIOD
Field: END_DTTM


14:14:55,594 [sample-clusterWorker:0] INFO (com.splwg.base.support.changehandlers.ChangeEventHandler) The following rule was violated: AutomatedRulesFactory:REQFLD:D1_USAGE_PERIOD :endDateTime : The endDateTime property on the D1_USAGE_PERIOD table is required on property endDateTime
  : (11001, 101) %1 field missing.
14:14:55,594 [qa2-clusterWorker:0] INFO (com.splwg.base.domain.AppLog) Application error encountered: End Date/Time field missing.
14:14:55,596 [qa2-clusterWorker:0] ERROR (com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner) Encountered an error while logging a transition error. Stopping transition
com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner$TransitionErrorLoggingException: com.splwg.shared.common.ApplicationError: (Server Message)
Category: 11001
Number: 101
Call Sequence:
Program Name: UsageTransactionAutoTransitionBatchProcess$UsageTransactionAutoTransitionBatchProcessWorker
Text: End Date/Time field missing.
Description:
Table: D1_USAGE_PERIOD
Field: END_DTTM


08:01:42,313 [sample-clusterWorker:4] INFO (usageTransaction.algorithms.RemoveEmptyUsagePeriodsFromUsageTransactionAlgComp_Impl) Usage Period deleted row(s): 1
 - 2022-04-05 08:01:42,331 [sample-clusterWorker:5] ERROR (schema.rules.BusinessObjectStateTransitioner) Encountered an error while logging a transition error. Stopping transition
com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner$TransitionErrorLoggingException: com.splwg.shared.common.ApplicationError: (Server Message)
Category: 11001
Number: 402
Call Sequence:
Program Name: UsageTransactionAutoTransitionBatchProcess$UsageTransactionAutoTransitionBatchProcessWorker
Text: 1 combination, not found.
Description: To solve the problem, check if the fields are populated, or the combination of them is a valid one to find an item in a table.
Example: if the parameter of an algorithm is not populated, this could result in the system not finding the algorithm.
Table: null
Field: null


07:17:23,737 [sample-clusterWorker:1] ERROR (schema.rules.BusinessObjectStateTransitioner) Encountered an error while logging a transition error. Stopping transition
com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner$TransitionErrorLoggingException: com.splwg.shared.common.ApplicationError: (Server Message)
Category: 11001
Number: 101
Call Sequence:
Program Name: UsageTransactionAutoTransitionBatchProcess$UsageTransactionAutoTransitionBatchProcessWorker
Text: Start Date/Time field missing.
Description:
Table: D1_USAGE_PERIOD
Field: START_DTTM

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.