It is currently 16 Aug 2018 12:18


Post new topic  Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 25 Jan 2010 2:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Jan 2010 12:00
Posts: 12
Hi All,

I have a requirement to create a report on failed job and the cause for failure
Can you please let me know the table which holds the sysout error message like "Unable to connect to database"

Thanks!


Top
   
 Post subject:
PostPosted: 25 Jan 2010 7:44 
Offline
Nouveau
Nouveau
User avatar

Joined: 04 Jan 2008 12:00
Posts: 3
The sysouts are typically stored in sysout directory in the install path of the agent as text files. i.e /home/ctm/agent/sysout


Top
   
 Post subject:
PostPosted: 27 Jan 2010 11:29 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
no no the error tables messages are in controlm server directorie:
look at ~/ctm<_server>/data/dbs_ag_msgtbl
and ~/ctm<_server>/data/dbs_msgtbl
you will find messages used by the agent and the server.
probably you can find the same tables in EM for EM purposes.

it look like this for the server :
4000 Order Validity Error
4001 A mandatory parameter (%s) is missing
4002 Invalid value for parameter %s
4003 NoDuplication is valid if InGroupOrderId is {group orderid}|LAST
4004 The specified table (%s) cannot be found
4005 The specified jobname (%s) cannot be found, or incorrect job SeqNo
4006 Date specified (%s) is illegal, or its format invalid yyyymmdd
4007 OdateOption cannot be RUN_DATE when Odate is set to the past
4008 None of the jobs can be submitted with the requested Odate
4009 Group entity cannot be ordered with the requested Odate
4010 InGroupOrderId should not be specified with regular table
4011 AutoEdit Var APPLGROUP valid if InGroupOrderId is {empty}|NEWG
4012 AutoEdit Var MEMLIB is invalid when ordering all jobs from a table
4020 The specified Order Id (%s) was not found
4021 CONTROL-M/Server is not ready to process such requests
4022 Internal Error occurred and the request failed
4023 The order request id (%s) was not found in CONTROL-M/Server
4024 CONTROL-M/Server received duplicate order request id
4025 CONTROL-M/Server received duplicate request
4026 Request did not complete due to an internal error or server shutdown
5000 CONTROL-M IS NOW INACTIVE
5001 FORCING %s OUT
5002 PROCESS %s IS RUNNING
5003 MAXRETRY REACHED FOR %s. SUPERVISOR IS SHUTTING DOWN
5004 RUNNING NEW DAY PROCEDURE

or like this for the agent :

0001 JOB %s (ORDERID %d) STARTED, OWNER %s
0002 JOB %s (ORDERID %d) ENDED OK
0003 JOB %s (ORDERID %d) ENDED NOTOK
0004 COMMUNICATION : START
0005 COMMUNICATION : STOP
0006 FAILED TO CREATE PROCESS : %s. ERROR: %s. (CHECK FILE ACCESS)
0007 SHOUT TO %s PERFORMED
0008 SHOUT TO %s FAILED
0009 %s
0010 CONTROL-M/Srv(%s) is not authorized to run jobs on this agent
0011 JOB LOG COPIED TO %s
0012 JOB LOG COPY TO %s FAILED
0013 JOB LOG MOVED TO %s
0014 JOB LOG MOVE TO %s FAILED
0015 JOB LOG RELEASED
0016 JOB LOG RELEASE FAILED
0017 JOB LOG DELETED
0018 JOB LOG DELETE FAILED

hope it help you
regards
philmalmaison


Top
   
 Post subject:
PostPosted: 28 Jan 2010 7:49 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Jan 2010 12:00
Posts: 12
thanks a lot for the information
again I'm looking for a controlm database table so that i can write a procedure or something to load the error details into our error table


Top
   
 Post subject:
PostPosted: 11 Feb 2010 3:02 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Jan 2010 12:00
Posts: 12
actually we need to get error message from sysout
like" sql execution failed"
this message is thrown out by the program which controlm executes


Top
   
 Post subject:
PostPosted: 11 Feb 2010 4:46 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jun 2007 12:00
Posts: 317
Control-M does not deal with the content of sysout. You need specific coding in individual job definition and/or script/executable to detect/interpret any errors within the sysout.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 6 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved