Skip to Main Content
Forums

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!

I am getting Automation Error in FDM

681786May 3 2011 — edited May 5 2011
Hi,

I am trying to load data from FDM into HFM, It was working fine till afternoon. I switched on Enable intersection validation ON and saved and did the Load;
I got Automation Error. Then I disabled Enable intersection validation and tried loading data. I am getting same error Automation error.

I saw in Metalink they said to configure your adapter. While doing reconfiguring I am getting some other error saying Specified Cast not valid.

Can any one tell me what is going wrong? and how do I need to resolve this.

Thanks,

Comments

4297041
Hello,

If you review your error log what does it state? It might be good to clear it (Tools > Clear Error Log), reproduce the issue, and then review the error log (Tools > View Error Log).
The root cause of the issue will be just before the "Automation Error" notification as FDM write issues in order from the top down.

Thank you,
JeffJon
Is this a x64 server? Specified Cast is invalid indicates that the adpater was not registered properly. If it is a x64 server the adapter needs to be registered manually.

Follow document 1073992.1 to resolve the issue.
Jeo123
Try going into the mapping section and browsing for target value. 9 times out of 10 an automation error seems to be related to an inability to connect to the target system. The most common cause in my experience relates to entereing a Domain on the login page when one isn't required, but there are other causes as well.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 2 2011
Added on May 3 2011
#business-intelligence-applications, #fdm, #financial-data-management, #performance-management-applications
3 comments
861 views