Sysout error message table

Several scripts
Post Reply
User avatar
gwr_d
Nouveau
Nouveau
Posts: 12
Joined: 25 Jan 2010 12:00

Sysout error message table

Post by gwr_d » 25 Jan 2010 2:11

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!

User avatar
blueskydiver76
Nouveau
Nouveau
Posts: 3
Joined: 04 Jan 2008 12:00
Contact:

Post by blueskydiver76 » 25 Jan 2010 7:44

The sysouts are typically stored in sysout directory in the install path of the agent as text files. i.e /home/ctm/agent/sysout

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 27 Jan 2010 11:29

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

User avatar
gwr_d
Nouveau
Nouveau
Posts: 12
Joined: 25 Jan 2010 12:00

Post by gwr_d » 28 Jan 2010 7:49

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

User avatar
gwr_d
Nouveau
Nouveau
Posts: 12
Joined: 25 Jan 2010 12:00

Post by gwr_d » 11 Feb 2010 3:02

actually we need to get error message from sysout
like" sql execution failed"
this message is thrown out by the program which controlm executes

User avatar
gglau
Nouveau
Nouveau
Posts: 317
Joined: 13 Jun 2007 12:00

Post by gglau » 11 Feb 2010 4:46

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.

Post Reply