Workflow and call to external database

[Cristiana D'Agosto]

Further info:
 
We checked the application log (tcode SLG1 / SM21) and found that
something didn't work during the connection and the program was aborted;
when that happened the workflow kept 'In Process' and the method kept
trying to re-connect the remote database.
 
The log says that  'Access to the database system has returned an SQL code
indicating that the operation could not be performed correctly by the
database system."
 
I don't know if there is a way to let the method know that this happened?
 
Anyway, it is working now but I am a bit concerned on how to prevent that
to happen?
 
Cheers
 
Cristiana
 
 
----- Forwarded by Cristiana D'Agosto/Australia/IBM on 24/11/2003 01:37 PM
-----
 
 
Cristiana D'Agosto
24/11/2003 11:58 AM
 
 
        To:     SAP-WUG at MITVMA.MIT.EDU
        cc:
        From:   Cristiana D'Agosto/Australia/IBM at IBMAU
        Subject:        Workflow and call to external database
 
 
 
G'day all,
 
we are in 4.6c
 
We wrote a method that calls an external database (Oracle) to retrieve
some information required for the workflow.
 
We tested the method in SWO1 and works fine, i.e. it reads the Oracle
database and returns the expected fields.
 
I included the method in my workflow and it is not working, the step that
calls the method stays 'In Process' forever. The method is defined as
background and synchronous.
 
Any ideas what I am missing?
 
Regards
 
Cristiana