Calling Web Service from DS Routine

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

Moderators: chulett, rschirm

Post Reply
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Calling Web Service from DS Routine

Post by nick.bond »

Hi,

We are having a strange problem when calling a Web Service from a generated routine. If there is the following job structure

Sequence A
|
Sequence B
|
Web Service Routine

Sequence B will complete and the Web Service routine completes successfully but Sequence A will never complete because it seems to loose track of the state of Sequence B.

When looking at the log of Sequence B the time suddenly changes by an hour which may be connected to the controlling sequence loosing control of it.
Occurred: 11:03:48 AM On date: 7/12/2006 Type: Control
Event: Starting Job WebServiceRoutineCheck.
Occurred: 11:03:48 AM On date: 7/12/2006 Type: Info
Event: Environment variable settings: (...)
Occurred: 11:03:48 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (@Coordinator): Starting new run of checkpointed Sequence job
Occurred: 11:03:49 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (exceptionReceive): Debug 09
Occurred: 11:03:49 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (exceptionReceive): My Time= 11:03:49:
Occurred: 10:03:51 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (exceptionReceive): Debug 10
Occurred: 10:03:51 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (exceptionReceive): My Time= 10:03:51:
Occurred: 10:03:51 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (@Sequencer_1): OKOKOKOKOK
Occurred: 10:03:51 AM On date: 7/12/2006 Type: Info
Event: WebServiceRoutineCheck..JobControl (@Coordinator): Summary of sequence run (...)
Occurred: 10:03:51 AM On date: 7/12/2006 Type: Control
Event: Finished Job WebServiceRoutineCheck.

By debuging the DS generated routine I can see that the change in system time takes place when the Web Service is actually called.

Code: Select all

*************************************************************
      * Call the actual web service, returning the Ans                
 ************************************************************
      Ans = ''
      ds%%status = callWebService( ds%%wsHdl, 'ARRAY', Ans )
I inserted into the routine two lines either side of the Web Service call like:

Code: Select all

CALL DSLogInfo( 'My Time= ' : Oconv(Time(), 'MTS:'):': ' , RoutineName )
You can see from the output in the log extract that DS thinks the system time has changed??????

Anyone got any ideas???????

Thanks, Nick.
Regards,

Nick.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

AS to the time "change", looks like whatever is hosting the web service has not adjusted for daylight saving. Or there's a really weird bug in the exception handler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

I like Ray's thoughts --- it's certainly a good possibility --- and I also seem to remember something like this coming up a long time ago, and it had something to do with either the axis engine underneath WSPack, or the JVM... Some googling of "axis SOAP daylight savings" shows some interesting theories.

Certainly a strange one.

Ernie
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Post by nick.bond »

Thanks for suggestions, the Web Methods guy is looking into the configuration of the time on the Web Services box.

Why would DS use the time from the Web Services box as it's system time? Surely it should always use the time on the DS server.
Regards,

Nick.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I'm sure Ernie will be asking that very same question of the engineers who look after this part of the product!!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Post by nick.bond »

Problem is now solved. Our timezone settings were:
EET-10EETDT,M10.5.0,M4.1.0
and by changing it to
EET-10EETDT-11,M10.5.0,M4.1.0

the problem dissapeared. I couldn't get DataStage to pickup the change at a system level when rebooting DataStage so changed the value in the project with user definded parameter.

I'm told by our AIX admin that AIX doesn't use the -11 anywhere and that's why it's not set but I guess something in the Web Methods stuff does.
Regards,

Nick.
Post Reply