Skip to main content
Question

fme server job does not work when triggered from informatica

C
Forum|alt.badge.img

Hi Guys,

I have tested the workspace in workbench and published it into the server. When running the job manually from the fme server, it works. However when I call it from informatica http transformer, it does not work.

Under job history in fme server, it can be seen that the job is being triggered from informatica but the end result is not there.

I am trying to update a column in the database.

Thank you.

5 replies

takashi
Influencer
  • takashiInfluencer
  • July 5, 2018
Have you checked the log to see if parameters have been passed to the workspace correctly.

 

rylanatsafe
Safer
Forum|alt.badge.img+13

Hi @chiaweijie1991, are you using the 'Direct URL Example' located under the 'Advanced' section found on the Run Workspace page for the URL in the trigger? I also wonder if the parameters have been passed correctly as @takashi questioned.

 

 

Edit: Or are you using the REST API /transformations/ call?

C
Forum|alt.badge.img
rylanatsafe wrote:

Hi @chiaweijie1991, are you using the 'Direct URL Example' located under the 'Advanced' section found on the Run Workspace page for the URL in the trigger? I also wonder if the parameters have been passed correctly as @takashi questioned.

 

 

Edit: Or are you using the REST API /transformations/ call?

Hi I am using the direct URL example in the http transformation.

 

 

C
Forum|alt.badge.img
chiaweijie1991 wrote:
Hi I am using the direct URL example in the http transformation.

 

 

I did not set any parameters. Only input is the URL i believe. It is a 'POST' inside the transformer.

 

 

rylanatsafe
Safer
Forum|alt.badge.img+13
chiaweijie1991 wrote:
I did not set any parameters. Only input is the URL i believe. It is a 'POST' inside the transformer.

 

 

I recognize that it's quite possible your workspace does not require parameters to run correctly,... this may warrant an investigation outside of this forum – please consider contacting Safe Support if you have not yet resolved this issue. I think I would need to see your FME Server environment to get a better handle on potential causes.

 

(If you submit a ticket, it will be helpful to reference this Q&A; thread!)

 

Reply


Helpful Members This Week

Community Stats

31,336
Posts
118,868
Replies
38,957
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.