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



Joined: 18 Jun 2018
Posts: 7
Location: Regina, SK
Points: 397

Post Posted: Thu Jul 12, 2018 3:32 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have hit a wall.

It is a very simple job, which is supposed to parse xml

The newest problem is that now I get errors:

1) Out of String space when you save

2) Error message:
Error calling subroutine: *DataStage*DSR.ADMIN (Action=36); check DataStage is set up correctly in project ETL_TEST_PROJECT_WI

(The connection is broken (81002))


I think I shouldn't have to jump through hoops for a simple job reading a few columns from an xml file; any ideas why the server is running out of memory somehow?

The CPU gets very easily bogged down in Datastage I find; currently it is in the mid 20's. I have to assume something in the job is making Datstage work far harder than it is; or perhaps a setting in the datastage config file; whatever that means can't handle the very simple job I am trying to make go

_________________
Will
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42618
Location: Denver, CO
Points: 219425

Post Posted: Thu Jul 12, 2018 4:27 pm Reply with quote    Back to top    

So... "when you save" meaning the error is thrown when working with it in the Designer? Or based on the "make it go" comment, does this happen when you try to run it? As a general question, do you have other jobs that run (or save) fine and there's only a problem with this particular one or is this part of a larger problem?

Just trying to get an idea of the scope.

Oh, and how large is this XML file you are trying to process? It all has to get loaded and parsed to find your few columns...

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16311
Location: Germany
Points: 92496

Post Posted: Fri Jul 13, 2018 1:28 am Reply with quote    Back to top    

Is your DataStage engine running on "UNIX" as listed? The "Out of String Space" is more indicative of Windows. Where or when are you seeing the error message - could it be a Client issue?

_________________

Image
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