Forum Stats

  • 3,875,889 Users
  • 2,266,986 Discussions
  • 7,912,370 Comments

Discussions

FDMEE Error in CommData.validateData

Muhammad Jahanzeb
Muhammad Jahanzeb Member Posts: 51 Red Ribbon
edited May 23, 2020 11:23AM in Planning and Budgeting

I am doing write back integration to ebs GL from Hyperion , source is Hyperion app and target is ebs gl. I have completed the required setup for write-back in fdmee.

When i run the data load rule only IMPORT step successful and it gives an Error on VALIDATE step and validate icon is also grayed out in workbench.

Following is the ERROR LOG:

2020-05-08 16:27:09,299 DEBUG [AIF]: CommData.updateWorkflow - END

2020-05-08 16:27:09,300 INFO  [AIF]: Total Data Rows available for Export to Target: 3

2020-05-08 16:27:09,300 DEBUG [AIF]: CommMap.validateData - END

2020-05-08 16:27:09,301 INFO  [AIF]:

Validate Data Members for Period 'Jan-20'

2020-05-08 16:27:09,301 DEBUG [AIF]:

      SELECT COUNT(*) ROW_COUNT

      FROM TDATASEG

      WHERE LOADID = 1228

      AND (PARTITIONKEY = 40 AND CATKEY = 2 AND PERIODKEY = '2020-01-31' AND RULE_ID = 88 AND VALID_FLAG = 'Y')

    

2020-05-08 16:27:09,302 INFO  [AIF]: Total Data Rows available for Export to Target: 3

2020-05-08 16:27:09,302 DEBUG [AIF]: Comm.executeScript - START

2020-05-08 16:27:09,302 INFO  [AIF]: Executing the following script: /u01/hyperion/fdmee/SOURCE_EBS/data/scripts/event/AftValidate.py

2020-05-08 16:27:09,320 INFO  [AIF]: ======================================================================

2020-05-08 16:27:09,320 INFO  [AIF]: Open Interface Process: Begin

2020-05-08 16:27:09,320 INFO  [AIF]: ======================================================================

2020-05-08 16:27:09,328 ERROR [AIF]: The script has failed to execute:

2020-05-08 16:27:09,332 FATAL [AIF]: Error in CommData.validateData

Traceback (most recent call last):

  File "<string>", line 4501, in validateData

  File "<string>", line 445, in executeScript

  File "/u01/hyperion/fdmee/SOURCE_EBS/data/scripts/event/AftValidate.py", line 29, in <module>

fdmAPI.executeDML(Qdelete,["B"], True)

SQLException: java.sql.SQLException: ORA-12543: TNS:destination host unreachable

Best Answer

Answers