DSXchange

Hi Ernie - By "payload that works", I was referring to the soa envelope I copied from the Trace log of the DS job. I copied that to notepad, converted all of the escape characters back to brackets, and posted the entire thing into SoapUI. The service worked correctly in that case. Make sen...

Hi Julio -

Thanks for your response. What a frustrating issue this has been.

Would you mind giving me a few more details, such as how you went about determining that it was caused by the service, and how your workaround worked?

Thanks so much.

Tom

Hi Ernie - Thanks for your reply. To answer your question - yep, it works perfectly in SoapUI, as long as I manually convert the < and %gt; to brackets (<>) first. (If I paste the soap envelope as is into SoapUI, I get the same error that DataStage produces.) I had also tried setting the Data Elemen...

I don't see anything that I can directly relate to this problem I'm encountering when using a Web Service Client stage - so here goes - I'm trying to call a web service from a vendor, who supplied the wsdl definitions for the various services we need to call. The wsdl for this particular service is ...

I'm closing this one and marking it as resolved. My ultimate output was to be a payload for a web service. The payload, a single string, consisted of two columns - 1) the xml payload and 2) an ID string. My mistake was that I was trying to include the ID string as part of the entire XML payload. Onc...

Aargh! Thanks Craig, because you made me realize I'd pasted the wrong error message in my original post. This is the one I meant to post: CDIUI2820E The mapping is not applicable due to an invalid type conversion or difference in the source and target list dimensions. To summarize, when I try to map...

I'm trying for the first time to use the fancy all-in-one XML stage, and I'm having a hard time with one column. I'm getting error CDIUI2805E, which I see referenced in a few posts, but I don't believe those posts relate to the problem I'm seeing. My design is dataset --> XML --> WebService Client s...

Did a little more research here in the forums. I found something somewhat similar to the issue I was facing, and the recommendation there was to set the datatypes (within the job) to Double (instead of Float) for both the source and target. Once I tried that, the data then displayed correctly in sql...

I have a simple job in which my source is a sequential file, and the target is a sql database table. A number of fields are of the Float data type. I've got the data defined as Float in both the source and target, and am doing a straight move within the transformer. Data length for both source and t...

One of our nightly processes is to truncate and re-populate a sql database table for one of our business areas. Our process is to run two jobs - the first job calls a stored procedure to truncate the table, and the second job loads the fresh data. An instance occurred recently when (for an unrelated...

This will be is a general about architecture and the Infosphere environment. At my company, we are in the process of upgrading from DS 8.0.1 to 8.7. At the same time, we are changing our basic architecture (which we've had in place for a number of years) from single to multiple servers (for failover...

I was wondering if anyone had heard anything about the compatibility of 8.7 and Solaris 11. IBM's website shows Solaris 10 as the supported version for 8.7, and that information was updated as recently as 2011-10-25. But I was just curious to see if anyone had heard anything specifically about Solar...

Seems like this is my week for questions. This questions pertains to our entire Dev/UAT DataStage environment. (Both environments live on the same server.) We had an Oracle failure there yesterday, and our DBAs are unable to recover from past backups. I believe their plan is to now recover using cur...

Thanks for the suggestions so far. I'm in the process of examing our %PH% files and their cleanup.

Paul - Our OS is Solaris 9. No grid.

And we do have all of our jobs in one main project. We're not a huge shop - total of all jobs is around 1200.

At our firmrun most of our DS jobs with one of a few ksh scripts. There are a few standard audit-type steps that get executed before and after the main DS processing. These audit steps involve loading information to a few Oracle tables. This process has been in place with very few problems for a few...