My Oracle Support Banner

FDMEE 11.2.x - Error "SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00939: too many arguments for function" in Validate Step (Doc ID 3000004.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.2.14.0.000 and later
Information in this document applies to any platform.

Symptoms

Upgraded environment from 11.1.2.4 to 11.2.x.

The following error is thrown when running a Data Load Rule during the Validate step.


DEBUG [AIF]: CommData.updateWorkflow - END
DEBUG [AIF]: Comm.executeScript - START
INFO [AIF]: Executing the following script: <Application_root_folder>/scripts/event/AftValidate.py
DEBUG [AIF]: Export rounding
ERROR [AIF]: The script has failed to execute:
FATAL [AIF]: Error in CommData.validateData
Traceback (most recent call last):
  File "", line 3738, in validateData
  File "", line 439, in executeScript
  File "<Application_root_folder>/scripts/event/AftValidate.py", line 5, in
  fdmAPI.executeDML(strSQL, strParam, False)
  File "<Application_root_folder>/scripts/event/AftValidate.py", line 5, in
  fdmAPI.executeDML(strSQL, strParam, False)
SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00939: too many arguments for function


Changes

 Upgraded to FDMEE 11.2.x

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
Changes
Cause
Solution
References


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