DSXchange

Hi Ernie, Yes, I get request and response nicely using the Temp Conversion Service. The datatypes looks ordinary. I tried another WSDL that I didn't know existed until now and this time the server job ran fine. I can see the XML Response in the Director log and everything looks good. It did throw &q...

I am not sure if I need a keystore file. I do know that the IP address of the machine that is making the request should be present in a whitelist. I confirm that the IP address of the DataStage Server has been whitelisted. The Directory log does show the request envelope. However, the very next line...

Ramesh,

OK, I see the fields to fill in the Proxy details. But I am not sure what do I with it. There is no proxy available in our infrastructure.

Ernie, Just wow. Thanks for elaborating on how to enable tracing. I did that, and I did see the XML request in the logs. The very next line is the following error. TSDS_UID_WebService_Server..Web_Services_Transformer_0: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation ex...

This is 8.1 And I did get http://webservices.daehosting.com/servi ... s.wso?WSDL working.

I get the following error, when invoking a webservice which otherwise runs fine in soapUI. Web_Services_Transformer_12,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: at com.ascentialsoftware.wsclient.WebService.callService(WebSe...

I am reading contents in a table and writing them to an XML file using the XML Output stage. Table Contents are as follows, ColA ColB ColC A1 B1 C1 A2 B1 C1 A3 B3 C3 The expected XML output is as follows, <tag> <tagColA>A1</tagColA> <tagColB>B1</tagColB> <tagColC>C1</tagColC> </tag> <tag> <tagColA>A...

The data read from DB2 had 'Unicode' under Extended. After I removed the Unicode type in the Transformer, I can see all the values in the Director log now.

Not sure why Unicode messed things up. I would like to understand the reason if anyone cares to share.

I composed a simple job to learn the Pivot Stage. This is the job flow. DB2 --> Transformer --> Pivot --> Peek The table description is as follows, ColA(Char 6), ColB (Char 9), ColC(Char 9), ColD (Integer), ColE (Integer) The output layout is like this, ColA(Char 6), ColP, ColQ. Derivation for ColP ...

Thanks Craig for confirming that VarBinary is not required for XML chunks.

You assumed right. It is varchar. I set the APT_STRING_PADCHAR to 0x20 and ran the job, but achieved the same result. The server job in 'BestPractices' had XML chunks of type varbinary. I changed it to varchar in my Parallel job and now the output looks right. It doesn't have the garbage characters....

Thanks to the 'BestPractices' document on XML that almost anyone who has spent quite some time on DSXchange will know about, I was finally able to create a XML Document with Multiple Repeated Elements in a Server job. That motivated me to start working on a Parallel job that does the same, using the...

Thanks Ernie. I will look up the document and other threads that deal with multi-path hierarchy.

Is it possible...that there will EVER be more than one StudentUniqueStateId under the StudentProgramAssociation node AND/or EVER possible that there will be more than one StudentUniqueStateId under the StudentProgramExtension node (in a single xml document or single InterchangeStudentProgramNode). ...

Yes, Ernie. It works.

fred/sally/alice are all under StudentProgramExtension

However, if I add another xpath as follows,

/InterchangeStudentProgram/StudentProgramAssociation/StudentReference/StudentIdentity/StudentUniqueStateId/text()

I do not get a single InterchangeStudentProgram node.