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!
Sysout error message table
- blueskydiver76
- Nouveau
- Posts: 3
- Joined: 04 Jan 2008 12:00
- Contact:
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- 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
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