MultiApp collector is failing at task 3 with ORA-01400 error in RSA Governance & Lifecycle
Last Modified: 2024-01-09
Article Number
000071667
Applies To
RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition: 
  • RSA Governance & Lifecycle 7.5.2 P03
Issue
The MultiApp entitlement data collector fails on task 3 "Entitlement Data Object Processing"

image.png

with the following error showing in the logs, 
ORA-01400: cannot insert NULL into (""AVUSER"".""GTT_DC_RESOURCE"".""RUN_ID"")
ORA-06512: at ""AVUSER.EDC_NORMALIZE"", line 474
ORA-06512: at ""AVUSER.MAEDC_DATA_COLLECTOR"", line 196
ORA-06512: at ""AVUSER.MAEDC_DATA_COLLECTOR"", line 381
ORA-06512: at ""AVUSER.MAEDC_DATA_COLLECTOR"", line 466

 
Cause
The collector ideally should fail with circuit breaker failure as some of the applications completely missing data however due to a bug the collection kept running and failing with the ORA-01400 error.
Resolution
This issue is resolved in the following versions.  The solution requires being on the fixed version of the product AND configuring a custom parameter circuitBreakeFailureForMultiappCollectorIfAnyMissingApps.
  • RSA Governance & Lifecycle 7.5.2 P05
To resolve the issue, first, apply the fixed patch/version and then configure the custom parameter circuitBreakeFailureForMultiappCollectorIfAnyMissingApps as follows:
  • On the UI, go to Admin > System > Settings > click Edit
  • Scroll down to the bottom of the page, and add the following custom parameter:
Parameter name = circuitBreakeFailureForMultiappCollectorIfAnyMissingApps
Value = no
  • Click Save and then OK
  • Notice that the updated page will show "custom.circuitBreakeFailureForMultiappCollectorIfAnyMissingApps" set with a value no.

Related Articles

Trending Articles

Don't see what you're looking for?