DSXchange

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

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

what release? any chance this is 7.5x2 ?

Ernie

Yup.

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,

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,
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.

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

Are you running in the server or parallel canvases?

Rob

I am running in the server canvase.

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

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,

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

...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

...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

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