WebServices Transformer run time error

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

WebServices Transformer run time error

Post by rwierdsm »

Folks,

Just started messing around with the Web Services pack. We were able to connect to the Web Service and access some metadata information from Manager. Now we've created a job using some of that info, compiled it cleanly and ran.
Job log produces following error:

Unable to load plug-in in call to ORPHLoadPlugin()

Tried a re-install, but that didn't do it. Any ideas?

Thanks,

Rob Wierdsma
Rob Wierdsma
Toronto, Canada
bartonbishop.com
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Re: WebServices Transformer run time error

Post by rwierdsm »

Not sure why I couldn't find this post in my previous searches, but I am following the info in the thread....

viewtopic.php?t=107823&highlight=ORPHLoadPlugin
Rob Wierdsma
Toronto, Canada
bartonbishop.com
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

what release? any chance this is 7.5x2 ?

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

Yup.
Rob Wierdsma
Toronto, Canada
bartonbishop.com
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Support will know, but I'm not certain that Web Services Pack was supported in that version, which was a specialized early edition of EE on Windows. Hopefully it's something simpler, like a configuration/installation/path type error, but it's not one I've seen.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

Ernie,

We're getting conflicting messages from IBM support. Initially we were assured that the Web Services pack version 7.5.1 was the appropriate one for 7.5x2. Now, based on the call to support, there seems to be some question.

We did get by the error when we ran the job in Server edition, however, some of the threads indicate that Parallel should work too.

I'll let you know what transpires.

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Rob,
Yes, Web Services pack 7.5.1 installed on my 7.5.x2 has been working just fine. Try to run a test job using the WS_Client stage to see whether at least one of them is working.
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

I have tried both the web services client and transformer, same error.

Are you running in the server or parallel canvases?

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

I am running in the server canvase.
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

Yah, we blew up on Parallel and then later tried Server. It works there.

Is everyone else out there on 7.5x2 experiencing the same thing?

Web Services works on the Server canvas but fails on the Parallel canvas?

Our call into IBM support has yielded the conclusion that Web Services pack 7.5.1 is NOT certified for 7.5x2. Sounds like you are on your own if that is your environment.

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Hi Rob...

I was afraid you might get that conclusion. It's been over four years since I had 7.5.x2 installed, so don't remember all the details, but recall it being primarily used when parallelism was needed on Windows, as it was the first release for EE on that platform.

What is your Web Services Job going to be doing? SOAP based Web Services are not screamers anyway --- Server may be sufficient for your needs. Describe the Web Service --- perhaps there are some things we can all think of to ensure that it works at its best in that environ.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

Ernie,

Here's a picture of the way I'm doing it so far.


WS Client ---> Xfm ----> WS Xfm -----> Seq File

WS Client - gets a session token This part seems to work. single row output.
Xfm - just because
WS Xfm - get account table data
Seq File - so I can look at it.

I had thought I would get a bunch of rows out of the WS Xfm stage, but only one comes out. It appears to produce all the columns, but they are all blank.

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

...a couple of things....

For starters, just grab the whole SOAP body.....there's a table definition you can use from ...Table Definitions...Builtins....SOAPBody, or you can just put a single column, longvarchar, some long integer for length, and use that column in the "User Defined Message" on the Message tab. Have that as the only column on the output link. This will prove that you are getting actual content.

If the body has multiple rows in an array, then you will have to go to XMLInput....... WS Pack can't pick apart the array.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

...and there it is! 12,500 rows of XML!

Ernie, you're a good man to have on the team! :D

Now to monkey around with some XML stages, etc.

I'll let you know how it goes.

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
rwierdsm
Premium Member
Premium Member
Posts: 209
Joined: Fri Jan 09, 2004 1:14 pm
Location: Toronto, Canada
Contact:

Post by rwierdsm »

I've output the data from the WS transform using the SOAPbody column as suggested by Ernie.

Next stage is a XML Input stage. By fiddling around with the settings, I've output according to the table definition imported as meta data from the Web Services. Still getting a warning message, but I'm pleased to see data. :)

In terms of exporting from the WS xfm, is this the best approach, or should I be able to export in the structure of the XML file to the XML Input stage?

Rob
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Post Reply