My Oracle Support Banner

PMF workflow logs are not captured in AAI_WF_ACTIVITY_EXECUTION_LOG table (Doc ID 2748182.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute PMF workflow, following error is noticed in logs and logging information is not inserted into AAI_WF_ACTIVITY_EXECUTION_LOG table

Error:
[21-01-21 12:37:35,585 GMT PM] [DEBUG] [WEB] [NA] [NA] Error while execution addActivityExecutionLog query for activity log update: java.sql.SQLException:
 ORA-01461: can bind a LONG value only for insert into a LONG column

[21-01-21 12:37:35,585 GMT PM] [DEBUG] [WEB] [NA] [NA] Closing Connection...
[21-01-21 12:37:35,585 GMT PM] [DEBUG] [WEB] [NA] [NA] [2021-01-21 06:37:35.578] *** Activity execution completed...Start ***
[21-01-21 12:37:35,585 GMT PM] [DEBUG] [WEB] [NA] [NA] Connection requested...

Steps to reproduce
Try to execute PMF workflow

Business impact
Due to this issue, AAI_WF_ACTIVITY_EXECUTION_LOG table doesn't get the log entries

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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