DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
atul9806
Participant



Joined: 06 Mar 2012
Posts: 95
Location: Pune
Points: 824

Post Posted: Mon Jan 02, 2017 6:33 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
Additional info: V11.5
Hi Team
I have created a Server job for calling a REST POST service and capturing the response.

This thread is a part of this issue but posting here if someone can help me with this server job.


Design:
transformer Stg ---> Hierarchical Stage ---> Seq File

a) transformer stage - generating a single dummy record to passing the payload file name into Hierarchical Stage

b) Hierachical Stage - ( Input Step, REST Step and Output Step)

i - Input Step - Reading the single row passed by transformer stage which have payload file name

ii- REST step - HTTP method - POST
URL - Service URL
Security -- None
Request - A file whole path is set in Mappings as bodyFilePath
Response - A text node named body in the Output Schema
Mappings - Mapped the input fileName (payload) to bodyFilePath

iii- Output Step - Mapped the Service response to output columns

c) Seq File - Load the response into file


When I am running this job, my job is aborting with below error -
Abnormal termination of stage jobName..xfm detected

DataStage is indicating that error is in transformer stage but it is working fine if I removed the HIerarchical Stage.

Help me to debug this server job as I am new to this Oldest job Smile

Thanks for your time !!

_________________
~Atul Singh
DataGenX | LinkedIn
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42274
Location: Denver, CO
Points: 217071

Post Posted: Mon Jan 02, 2017 8:40 am Reply with quote    Back to top    

Server jobs always point at a transformer when they abort as they are the active stage in the job. The first thing you need to do to help debug this is Reset the job and then check the log for a new entry saying "From previous run...". If that appears, post the contents.

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
atul9806
Participant



Joined: 06 Mar 2012
Posts: 95
Location: Pune
Points: 824

Post Posted: Tue Jan 03, 2017 12:32 am Reply with quote    Back to top    

Thanks craig for your inputs

FYI - My input json file is only having 7 records and size is 22kb.

Please find the job log when reset the job -

Code:

From previous run
DataStage Job 208 Phantom 20225
Abnormal termination of DataStage.
Fault type is 11.  Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.ActiveRun at address 7a.

Resetting Job srvrJob1.

Resetting stage srvrJob1..xfm.

Resetting stage srvrJob1..Hierarchical.

_________________
~Atul Singh
DataGenX | LinkedIn
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3724

Points: 29740

Post Posted: Tue Jan 03, 2017 7:05 am Reply with quote    Back to top    

Very difficult, unfortunately, to debug one like this... some thoughts for you would be: a) do you have the REST call and payload working PERFECTLY from some other environment testing tool, suc ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42274
Location: Denver, CO
Points: 217071

Post Posted: Tue Jan 03, 2017 8:48 am Reply with quote    Back to top    

Yeah, as noted that's not a fun one. If you want to try to track it down, do an exact search here for "Fault type is 11" and you'll find 70 posts that mention that, including some from me back in the day I'll wager. See if any of them help. Loop in support as well.

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours