Re: Stored Procedure Jobs Hanging in Domino

[rob@xxxxxxxxx]

I guess I would do the usual:
What subsystem is this job running?
Can you determine which job queue that this job is running?  Is it single
stringed?  Should it be?
What other jobs is it stopping from running?  Domino?  If so, are you
expecting return variables or could you submit the job to batch and not
hang up the Domino job which calls it?

Rob Berendt

==================
Remember the Cole!


                                                                                
                                     
                    "Mike Naughton"                                             
                                     
                    <mnaughton@judd        To:     WEB400@midrange.com, 
ign_list@ignite400.org                       
                    wire.com>              cc:                                  
                                     
                    Sent by:               Subject:     Stored Procedure Jobs 
Hanging in Domino                      
                    owner-web400@mi                                             
                                     
                    drange.com                                                  
                                     
                                                                                
                                     
                                                                                
                                     
                    04/02/01 12:40                                              
                                     
                    PM                                                          
                                     
                    Please respond                                              
                                     
                    to WEB400                                                   
                                     
                                                                                
                                     
                                                                                
                                     




We are running a Domino server, and some of our apps use stored procedures
to call RPG programs on the AS/400. Occasionally, these programs will get
passed bad data, and and when that happens it hangs (typically, it's a
decimal data error problem). We've found that when that happens no further
jobs will run until we end the offending job. Obviously, one solution is
to add some error checking so the job doesn't hang, but it's got us
wondering -- why does one job hanging prevent others from running? Is
there a way we can set things up so that this won't happen?

TIA,

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

+---
| This is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---