Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
FDMEE Error in CommData.validateData
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
-
This is oracle client install issue on your FDMEE server.
check using sqlplus if you can login. if you can not login set the TNS_ADMIN variable to point to location where TNSNAMES.ora SQLNET.ora
Answers
-
Have you checked the validation error tab?
BR,
-
No error is displaying in the validation tab.
-
Have you set the Functional Currency at the specific location?
-
-
"SQLException: java.sql.SQLException: ORA-12543: TNS:destination host unreachable"
This last line says, the jython execution script had gone into the exception.Your destination EBS GL is not (or no longer) reachable from FDMEE server.
Can you go to the respective source system and try to Test connection again?
-
This is oracle client install issue on your FDMEE server.
check using sqlplus if you can login. if you can not login set the TNS_ADMIN variable to point to location where TNSNAMES.ora SQLNET.ora