DSXchange

Bummer. I first learned about using the JVM options at a site when WSPack was brand new --- we were reading from a BEA based Web Service that was returning nearly 20Meg.......but that was many releases and many years ago. ...still seems odd that your volume is so small (big but not anywhere near ex...

Trying to think of other things that could be an issue...... Let's talk about the Web Service itself and the method of calling it. It's a WISD based Service... Can I assume it is configurd to return an array? (lots of rows=lots of data) What is the topology of the Job? Is it WSClient at the start? ...

3.6M is still really small.... If it were 100M, and pushing on the limits of XMLPack, I'd be concerned...but something else would seem to be going on here. Do you get "cannot create the JVM" when just setting those values and running "any" service, or when you set those values a...

So much for it being an ISD thing. Oh well. Good debugging work. Web Services pack is limited on what it can do. Having a tool like SOAPui is so critical when building an ISD app.....for future readers of this thread, you often have no control of the web service client --- whether it is DataStage o...

Well...looking thru our threads again, if the RTI job is dumping it, it's likely not something at issue inside of the calling Job. And if you right mouse click on the WS Transformer (for future reference) and select "grid" option for editing, you will see an entry in there that lets you a...

....hmm..that's interesting. I didn't realize that you were calling this from another Job.... ...using WSTransformer? What happens when you invoke the service from an external tool, such as SOAPUI? Ernie Hi Ernie, as wirtten before - the same error wether we use a WS Client or WS Transformer. We ar...

Let's talk about "b". Using XMLOutput. You say that you get the same error......do you mean that a test job (not RTI) wth XMLOutput gets the same error (ie...when trying to build the xml payload and send to say, a flat file)? Just looking for clarification in our discussion. You may have ...

Hard to say...could be many different things. Some things to try: a) Server Job and not EE. Server is more flexible in large datatype areas....you are in the Server forum, so I will assume that you already are using a Server job, but just wanted to check... b) Package up the array before you send i...

How big is the answer set? There are defintely limits to the size, although I can attest to bringing back responses that are in the 10M range. On major key here though, is looking at the whole infrastructure......your Web Service is a lot more than just RTI.......there are a WHOLE lot of places whe...

Hi well I think this comes down to two situations: 1) if the migartion date is a Monday or Tuesday then you will look for a difference of 3 2) if the migration date is Wednesday, Thursday or Friday then use a difference of 5 So you just have to determine the day (name or number) i.e. with oconv reg...

Hi well I think this comes down to two situations: 1) if the migartion date is a Monday or Tuesday then you will look for a difference of 3 2) if the migration date is Wednesday, Thursday or Friday then use a difference of 5 So you just have to determine the day (name or number) i.e. with oconv rega...

Hi Chulett

thanks for your thoughts - yes it is something for support - I opened a case already but sometimes it is good to hear if someone else experiences the same thing or has any other idea....
There are not so many guys having RTI experience anyway

Thanks a lot.

regards
Michael

Hi, well this actually not a always on service because that wouldn't allow me to pass the WHERE condition directly into the SQL statement. So there should not be any problem passing the information down to the file... It works fine for when the WHERRE condition reduces the result set to about 2000 r...

Hi

DS Version 7.5.3
RTI Console 7.5.2.8

regards
Michael

Hi, I have a WebService selecting data from a DB2 table. The WHERE Condition of the statement is a parameter for the WS. My Testjob uses a WSClient stage and returns its output to a flat file. Specifying a WHERE Condition that returns < 2000 rows works fine but above a certain limit I do not get any...