Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [RESOLVED]iSM data migrator ETL object
Go
New
Search
Notify
Tools
Reply
  
[RESOLVED]iSM data migrator ETL object
 Login/Join
 
Gold member
posted
Hi,

I'm new to iSM. I want to run a data migrator job from iSM. When I'm trying to configure the ETL object in iSM, i'm getting this error(please see print screen image).

Does anyone know that if I need to setup something before I can start using the ETL object in iSM?

http://www.flickr.com/photos/3...hotostream/lightbox/


This message has been edited. Last edited by: Shirley,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
This error occurs because Service Manager is attempting to invoke a stored procedure called EDAEXEC to issue commands on the DataMigrator server instead of executing them directly.

For security reasons this procedure is disabled. To enable it, please go to (by default) c:\ibi\srv77\home\catalog directory and rename edaexec.dat as edaexec.fex.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Clif,

Thanks. It's working now.

Cheers,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [RESOLVED]iSM data migrator ETL object

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.