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