Wednesday, December 17, 2014
UC4 Automic "Automatically deactivate when finished"
You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository.
select OH_IDNR, OH_NAME,
CASE
WHEN JBA_AUTODEACT = 'A' THEN 'Always'
WHEN JBA_AUTODEACT = 'J' THEN 'After error-free execution'
WHEN JBA_AUTODEACT = 'N' THEN 'No'
WHEN JBA_AUTODEACT = 'F' THEN 'After an error-free restart'
end as "Automatically deactivate"
from uc4.oh t1, uc4.JBA t2
where OH_IDNR = JBA_OH_IDNR
select OH_IDNR, OH_NAME,
CASE
WHEN JBA_AUTODEACT = 'A' THEN 'Always'
WHEN JBA_AUTODEACT = 'J' THEN 'After error-free execution'
WHEN JBA_AUTODEACT = 'N' THEN 'No'
WHEN JBA_AUTODEACT = 'F' THEN 'After an error-free restart'
end as "Automatically deactivate"
from uc4.oh t1, uc4.JBA t2
where OH_IDNR = JBA_OH_IDNR
Saturday, December 6, 2014
UC4 status messages - AH_STATUS
Unfortunately UC4 (Automic) software does not have any lookup table for ah_status values.
These are the ah_status messages I stumbled upon among years.
AH_STATUS Status Text
when t1.eh_status = 1300 then 'Preparing '
when t1.eh_status = 1510 then 'Transferred '
when t1.eh_status = 1520 then 'Ready for transfer (before
Connect) '
when t1.eh_status = 1521 then 'Ready to be transferred '
when t1.eh_status = 1529 then 'Ready for generation '
when t1.eh_status = 1530 then 'Ready for start '
when t1.eh_status = 1531 then 'To be called '
when t1.eh_status = 1540 then 'Start initiated '
when t1.eh_status = 1541 then 'Checking '
when t1.eh_status = 1542 then 'Calling '
when t1.eh_status = 1543 then 'Unknown '
when t1.eh_status = 1544 then 'Inconsistent '
when t1.eh_status = 1545 then 'Started '
when t1.eh_status = 1546 then 'Connecting '
when t1.eh_status = 1550 then 'Active '
when t1.eh_status = 1551 then 'Transferring '
when t1.eh_status = 1552 then 'Called '
when t1.eh_status = 1553 then 'Accepted '
when t1.eh_status = 1554 then 'Sampling Files '
when t1.eh_status = 1556 then 'Escalated '
when t1.eh_status = 1560 then 'ProcessFlow is blocked. '
when t1.eh_status = 1561 then 'STOP - Client-wide stop of
automatic processing. '
when t1.eh_status = 1562 then 'HELD - Manual stop has been set.
'
when t1.eh_status = 1563 then 'STOP - Automatic processing has
been stopped. '
when t1.eh_status = 1564 then 'STOP - Queue processing has been
stopped. '
when t1.eh_status = 1570 then 'Skipping '
when t1.eh_status = 1571 then 'Canceling '
when t1.eh_status = 1572 then 'Generating '
when t1.eh_status = 1573 then 'Generated '
when t1.eh_status = 1574 then 'Post processing '
when t1.eh_status = 1575 then 'Ending '
when t1.eh_status = 1600 then 'Internal checking '
when t1.eh_status = 1684 then 'Waiting for Queue slot (max.
parallel tasks exceeded) '
when t1.eh_status = 1688 then 'Waiting for the host of an
AgentGroup. '
when t1.eh_status = 1689 then 'Waiting for resource (max.
FileTransfers exceeded) '
when t1.eh_status = 1690 then 'Waiting for external precondition
'
when t1.eh_status = 1693 then 'Waiting for manual release '
when t1.eh_status = 1694 then 'Waiting for resource (max. Jobs
exceeded) '
when t1.eh_status = 1695 then 'Waiting for restart time '
when t1.eh_status = 1696 then 'Waiting for host '
when t1.eh_status = 1697 then 'Waiting for SYNC '
when t1.eh_status = 1698 then 'Waiting for start time '
when t1.eh_status = 1700 then 'Waiting for predecessor '
when t1.eh_status = 1701 then 'Sleeping '
when t1.eh_status = 1702 then 'Not yet called '
when t1.eh_status = 1703 then 'Waiting for Pre-Conditions '
when t1.eh_status = 1709 then 'Waiting for end of parallel task
'
when t1.eh_status = 1710 then 'Registered '
when t1.eh_status = 1800 then 'ENDED_NOT_OK - Aborted '
when t1.eh_status = 1801 then 'ENDED_NOT_OK - Aborted because of
SYNC condition '
when t1.eh_status = 1802 then 'ENDED_JP_ABEND - Not executed
because of abnormal ProcessFlow end. '
when t1.eh_status = 1810 then 'ENDED_VANISHED - Disappeared '
when t1.eh_status = 1815 then 'ENDED_LOST - Ended undefined
(host terminated prematurely) '
when t1.eh_status = 1820 then 'FAULT_OTHER - Start impossible.
Other error. '
when t1.eh_status = 1821 then 'FAULT_NO_HOST - Start impossible.
Cannot reach host. '
when t1.eh_status = 1822 then 'FAULT_ALREADY_RUNNING - Task is
already running '
when t1.eh_status = 1823 then 'FAULT_POST_PROCESSING - Error in
post processing '
when t1.eh_status = 1824 then 'FAULT_POST_CONDITION - Error in
Post-Condition. '
when t1.eh_status = 1850 then 'ENDED_CANCEL - Manually canceled.
'
when t1.eh_status = 1851 then 'ENDED_JP_CANCEL - ProcessFlow
canceled manually. '
when t1.eh_status = 1852 then 'Rejected '
when t1.eh_status = 1856 then 'ENDED_ESCALATED - Aborted due to
escalation '
when t1.eh_status = 1898 then 'Blocked '
when t1.eh_status = 1899 then 'Status blocked manually removed.
'
when t1.eh_status = 1900 then 'ENDED_OK - Ended normally '
when t1.eh_status = 1901 then 'Confirmed '
when t1.eh_status = 1902 then 'ENDED_QUEUE_END (status for
subordinate tasks of a SAP job that has been ended) '
when t1.eh_status = 1903 then 'ENDED_CONTAINER_END (status for
tasks of an AgentGroup that has been ended) '
when t1.eh_status = 1910 then 'ENDED_EMPTY - Task is empty (STOP
NOMSG) '
when t1.eh_status = 1911 then 'ENDED_TRUNCATE - Transfer
incomplete because of the line limit. '
when t1.eh_status = 1912 then 'ENDED_EMPTY - Nothing found '
when t1.eh_status = 1920 then 'ENDED_INACTIVE - Inactive today
because of the Calendar. '
when t1.eh_status = 1921 then 'ENDED_INACTIVE - Task is not
active because of the definition. '
when t1.eh_status = 1922 then 'ENDED_INACTIVE - Task has
manually been set inactive. '
when t1.eh_status = 1930 then 'ENDED_SKIPPED - Skipped because
of WHEN clause. '
when t1.eh_status = 1931 then 'ENDED_SKIPPED - Skipped because
of SYNC condition. '
when t1.eh_status = 1932 then 'ENDED_SKIPPED - Schedule ended
prematurely. '
when t1.eh_status = 1940 then 'ENDED_TIMEOUT - Not executed
because of timeout (WHEN clause). '
when t1.eh_status = 1941 then 'ENDED_TIMEOUT - Start time
exceeded. '
when t1.eh_status = 1942 then 'ENDED_TIMEOUT - Ended untimely. '
when t1.eh_status = 1999 then 'SYNC check passed. '
