Page 1 of 2
Webservices
Posted: Tue Mar 17, 2009 8:59 am
by samsuf2002
I am new to web services and have searched the forum for the solution but couldn't find anything helpful.
We have a website published by asp.net on Windows machine and we need to bring it down before we start our batch cycle and then bring it up once batch cycle is completed. And data stage is on Unix machine. Is there anyway in data stage to do this ?
Is there any way to use web service pack in data stage to make this happen ?
Thanks in advance.
Posted: Tue Mar 17, 2009 9:04 am
by chulett
What's the process to bring the website "down"? Do you have access to any kind of Enterprise Scheduler?
Posted: Tue Mar 17, 2009 9:26 am
by samsuf2002
Normally we just go to the Windows IIS server and bring it down/up the site manually. We also have asp.net webservices by which we can do the same.
But now we want to automate it, may be using datastage (web services).
Posted: Tue Mar 17, 2009 9:42 am
by chulett
samsuf2002 wrote:We also have asp.net webservices by which we can do the same.
Meaning what? There is a webservice call available to bring it down? If yes, then I don't see why you couldn't do that in a job. Have you tried to yet?
Posted: Tue Mar 17, 2009 9:57 am
by samsuf2002
Yes Craig we have a web service call to do that, but I have never used web service package in data stage so I don't know how to call it from data stage job.
I will try it and let you know.
Posted: Tue Mar 17, 2009 10:19 am
by chulett
First step is to import the metadata from the existing service so you can load all that into the stage.
Posted: Tue Mar 17, 2009 12:53 pm
by eostic
..not trying to promote my blog, but this is one case where it might be worth a visit. I have some notes there on the basics of using the Web Services Stages that might help....
http://dsrealtime.wordpress.com/2007/11 ... g-started/
Ernie
Posted: Tue Mar 17, 2009 2:39 pm
by chulett
Didn't know that was there... bookmarked now for future promotion.
Posted: Wed Mar 18, 2009 10:56 am
by samsuf2002
I have imported the metadata but i am not sure sure what stage to use and what will be the next step.
Posted: Wed Mar 18, 2009 11:25 am
by chulett
Did you read Ernie's blog entry?
Posted: Wed Mar 18, 2009 1:35 pm
by samsuf2002
I read the blog and was able to design the job with webservice transformer followed by regular transformer then a peek stage. I did everything suggested in the blog but when I run the job I get this warning
Code: Select all
warning Web_Services_Transformer_1,0: Error: TJClient::initialize: unable to create Java Virtual Machine; classpath = /appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/wsclient.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/axis.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/commons-discovery.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/commons-logging.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/jaxrpc.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/saaj.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/wsdl4j.jar
ASCL-DSJNI-00011`:`JNIWrapper: load library failed: directory /appl/datastage/IBM/InformationServer/Server/DSEngine/java/jre/bin/sovvm, name jvm
0509-022 Cannot load module /appl/datastage/IBM/InformationServer/Server/DSEngine/java/jre/bin/sovvm/libjvm.a.
0509-026 System error: A file or directory in the path name does not exist.
fatal
Web_Services_Transformer_1,0: Resource bundle corresponding to message key DSTAGE-TODC-00017 not found! Check that DSHOME or APT_RESPATH is set.
The blog suggested to set up environment variables DATASTAGE_JRE and DATASTAGE_JVM, but I cant find these variables in administrator.
Don't know where I am getting wrong
Posted: Wed Mar 18, 2009 2:43 pm
by chulett
'Set' in that case would mean create them in the Administrator. Not sure what their value should be, however.
Posted: Wed Mar 18, 2009 4:36 pm
by eostic
there are other threads in here that talk about the settings..depends on your platform... call your support provider...this was an 8.0 problems and it was corrected for most platforms for 8.1, and/or the settings for 8.0 should be available from them....the settings are slightly different on each OS.
Ernie
Posted: Wed Mar 18, 2009 5:54 pm
by xjonny
samsuf2002 wrote:I read the blog and was able to design the job with webservice transformer followed by regular transformer then a peek stage. I did everything suggested in the blog but when I run the job I get this warning
Code: Select all
warning Web_Services_Transformer_1,0: Error: TJClient::initialize: unable to create Java Virtual Machine; classpath = /appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/wsclient.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/axis.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/commons-discovery.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/commons-logging.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/jaxrpc.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/saaj.jar
/appl/datastage/IBM/InformationServer/Server/DSEngine/java/lib/wsdl4j.jar
ASCL-DSJNI-00011`:`JNIWrapper: load library failed: directory /appl/datastage/IBM/InformationServer/Server/DSEngine/java/jre/bin/sovvm, name jvm
0509-022 Cannot load module /appl/datastage/IBM/InformationServer/Server/DSEngine/java/jre/bin/sovvm/libjvm.a.
0509-026 System error: A file or directory in the path name does not exist.
fatal
Web_Services_Transformer_1,0: Resource bundle corresponding to message key DSTAGE-TODC-00017 not found! Check that DSHOME or APT_RESPATH is set.
The blog suggested to set up environment variables DATASTAGE_JRE and DATASTAGE_JVM, but I cant find these variables in administrator.
Don't know where I am getting wrong
Sorry... but might help. I've used dsenv file and included all the necessary stuff there. You can find all necessary instructions in WebService install guide...
Stuff like that:
Code: Select all
export DATASTAGE_JRE=/opt/IBM/InformationServer/ASBNode/apps/jre
export DATASTAGE_JVM=/bin/j9vm
set +u
Reboot the server or do (sorry not sure abt. paths):
Code: Select all
PATH/uv -admin -stop
bash PATH2/dsenv
PATH/uv -admin -start
I hope, your web-services use RPC SOAP. Otherwise it will be difficult to use DS...
Posted: Wed Mar 18, 2009 6:35 pm
by lstsaur
Edit your dsenv file and put $ASBHOME/apps/jre/bin and $ASBHOME/apps/jre/bin/classic in the LD_LIBRAY_PATH and put $ASBHOME/apps/jre/bin in the PATH. This way you fix both web service problem and also the Java stages for parallel jobs.