I am getting Automation Error in FDM

681786 May 4, 2011 12:58 AM

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,

1. Re: I am getting Automation Error in FDM

WPaffhausen May 4, 2011 3:44 AM (in response to 681786)

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,
Like Show 0 Likes(0)

Actions
2. Re: I am getting Automation Error in FDM

JeffJon May 4, 2011 7:56 PM (in response to 681786)

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.
Like Show 0 Likes(0)

Actions
3. Re: I am getting Automation Error in FDM

Jeo123 May 5, 2011 7:58 PM (in response to 681786)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.