I did find similar threads too on some oracle forums.. And it would
basically work - only the user has to be granted dbms_lock which by default
the ARADMIN user is not..
So far most of my team are in favor of the WSDL I have created and checking
possibilities of the OIM team consuming it upon completion of the request we
send to them.. We are not sure if they can do that, but its an angle worth
pursuing.. Personally I'm half and half for it as it does not feel like its
real time. If their processing time for this operation had a high degree of
variance, I would find it more acceptable than I do right now. But most of
the others here like this idea so it may possibly be the one that may get
accepted unless something better comes up..
Joe
-----Original Message-----
From: Longwing, LJ CTR MDA/IC
Sent: Wednesday, May 30, 2012 4:53 PM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: PAUSE or SLEEP a filters in between actions...
My brief search came up with
execute dbms_lock.sleep(60);
for a 60 second sleep...although I have no way to test it :)
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Joe Martin D'Souza
Sent: Wednesday, May 30, 2012 2:39 PM
To: [email protected]
Subject: Re: PAUSE or SLEEP a filters in between actions...
We are on Oracle.. I was in fact searching for an Oracle equivalent.. Great
minds :-)
-----Original Message-----
From: Longwing, LJ CTR MDA/IC
Sent: Wednesday, May 30, 2012 4:31 PM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: PAUSE or SLEEP a filters in between actions...
Joe,
If using SQL Server you could issue a Direct SQL of
waitfor delay "00:00:01"
this would call the DB and would return after SS seconds or HH:MM:SS if you
wanted more than SS seconds....but I agree with everyone else...setting hard
'pauses' in place is not ideal, but sometimes necessary.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Joe Martin D'Souza
Sent: Wednesday, May 30, 2012 2:06 PM
To: [email protected]
Subject: PAUSE or SLEEP a filters in between actions...
**
We are updating an identity management system (OIM) using its SPML based
WSDL.
During the operations to suspend or resume a user the output status of this
operation seems to always be ‘pending’ – which in reality is really an
intermediate status before ‘success’ or ‘failure’. The lifespan of this
intermediate status is just a brief fraction of a second before the update
either succeeds or fails..
From the service consumption point of view, this intermediate status of
‘pending’ is not quite meaningful other than the the fact that the WSDL call
was successful. Given a choice I would have rather had the option to wait
for those few micro seconds, at what point the status of either ‘success’..
They have a operation in the same web service to query the status. Following
the update WSDL with a query WSDL is what I thought would be my answer to
getting the new status (although I do not like the option of have another
WSDL call when there could have been one)... This query however returns the
status of the the user pre update. Filters as we know have no ‘SLEEP’ type
action, else I could have used that to pause the filter operations in
between the update and query operation.
Ideally it would have been perfect if there was an ability to introduce a
pause between the two WSDL calls.
Is there any ‘creative’ way of inserting a pause in a filter operation that
maybe I do not know of?
Joe
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
