Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FDMEE Error in CommData.validateData

Muhammad JahanzebMay 11 2020 — edited May 23 2020

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

This post has been answered by Srini+K on May 23 2020

Jump to Answer

jsmith

Could I build openjfx with openjdk7?

Not a complete JavaFX system for openjdk, only parts of it like the ui controls.

----------

If you want to build openjfx with openjdk, use version 8 (as that branch of openjfx includes most of the javafx 8 code) and following the build instructions at:

https://wiki.openjdk.java.net/display/OpenJFX/Building+OpenJFX

for the code at:

http://hg.openjdk.java.net/openjfx/8/master - forest root
http://hg.openjdk.java.net/openjfx/8/master/rt - sub-repo

For version 8:
- there is active ongoing development
- there are comprehensive build instructions
- there is a new gradle based build system
- almost all of the javafx code is open source
- many bugs have been fixed since 2.2
- significant new features have been added since 2.2
- development can use new and desirable java8 features like lambdas

On the drawback side:
- java8 won't be stabilized for a few months
- java8 won't have an official release until march next year
- some tools (such as NetBeans 7.3) don't support java8 well

-----------

The openjfk branches dealing with JavaFX 2.2, which works with java7 are:

http://hg.openjdk.java.net/openjfx/2.2/master
http://hg.openjdk.java.net/openjfx/2.2/master/rt

Building using JavaFX 2.2 with Java 7 is not advised because, for the 2.2 branch:
- the code has hardly changed in 8 months
- only contains a relatively small portion of open source code for javafx project
- there is no significant active development on it
- there are no published build instructions for it anymore

1005629

thanks a lot
then I will have a try . javafx2.2 ~

1 - 2

Added on May 11 2020

#business-intelligence-applications, #error, #fdmee, #performance-management-applications, #planning, #planning-and-budgeting, #validation

6 comments

1,313 views

Analytics Software

FDMEE Error in CommData.validateData

Comments

Post Details