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 laterInformation 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 |