Showing posts with label UC4. Show all posts
Showing posts with label UC4. Show all posts
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. '
