SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
running database job on remote agent freezes

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
running database job on remote agent freezes
Author Message
Dominic Klein



Joined: 23 Nov 2001
Posts: 132

Post running database job on remote agent freezes Reply with quote

Hi,
We have just upgraded Oracle to 9i release 2.

I have a job that is of type "run a database command"
the command I run is :

EXECUTE compaq_comm

Where compaq_comm is a stored procedure in the database

This works FINE on the master scheduler.
But if I try to run the command on the remote agent on the machine where the actual database resides it just hangs completely - the job only normally takes 15 secs to run.

How can our upgrade have affected our database job ? Everything is the same apart from now the OS user on the database server has changed (but we are not running 24x7 as a service anyway). This is a major problem for us so would be VERY grateful for a speedy solution. We are connecting using the normal Database Profiles (ie we are NOT using ODBC).

Thanks in advance.

Sun Jul 07, 2002 1:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Re: running database job on remote agent freezes Reply with quote

Most likely you have an issue with the database connection. First of all check
if you use database side user authentication or trusted connection. Check the version of the Oracle client files installed on the agent is compatible with the server. If not, upgrade the client.

If that does not help, enable database tracing option in profile on the agent (someone has be there and click on the confirmation message) when the job starts. After the job hangs, open the trace file in notepad and check the last performed operation and the error message.

: Hi,
: We have just upgraded Oracle to 9i release 2.

: I have a job that is of type "run a database command"
: the command I run is : EXECUTE compaq_comm

: Where compaq_comm is a stored procedure in the database

: This works FINE on the master scheduler.
: But if I try to run the command on the remote agent on the machine where the
: actual database resides it just hangs completely - the job only normally
: takes 15 secs to run.

: How can our upgrade have affected our database job ? Everything is the same
: apart from now the OS user on the database server has changed (but we are
: not running 24x7 as a service anyway). This is a major problem for us so
: would be VERY grateful for a speedy solution. We are connecting using the
: normal Database Profiles (ie we are NOT using ODBC).

: Thanks in advance.

Mon Jul 08, 2002 8:40 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.