| |
Results |
|
SBM: When activities are stuck in CANCEL_SENT status, the delete icon is missing
|
SBM: When activities are stuck in CANCEL_SENT status, the delete icon is missing
|
|
|
|
"Cancel Selected" does not work for the Get snapshot
|
4. Click on the "Cancel Selected" button, and approve "Yes" 5. Make sure that status changed to the " CANCEL_SENT " 6. Wait.
|
|
|
|
How to clear an Application Repository activity that is hung in a Waiting status
|
Attempting to cancel or delete the jobs stuck in Waiting doesn't do anything and requires you to run an update query against the Application Repository database. In the Application Repository database look in the QRTZ_ACTIVITY table. Identify the row in question and change the Status column to 2. (For example, if the row has a TS_ID of 5, you can run this statement: UPDATE QRTZ_ACTIVITY SET STATUS = 2 WHERE TS_ID = 5)
|
|
|
|
SBM: About the "Clear History" feature used to schedule Common Log cleanup (Delete Common Logger)
|
to_date('1970-01-01','YYYY-MM-DD')+TIME_START_NEXT/86400000 as NEXT_START, STATUS from QRTZ_ACTIVITY where NAME = 'ClearCommonLogJob' SQL Server:
|
|
|
Computing Statistics for Table Indexes.txt
|
------------------------------- ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY _LOG COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY _PARAM COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE
|
|
|
TeamTrack Database Schema
|
Described below. QRTZ_*: Tables used by SBM Application Repository for scheduling engine. QRTZ_ACTIVITY QRTZ_ACTIVITY _LOG QRTZ_ACTIVITY _PARAM QRTZ_BLOB_TRIGGERS QRTZ_CALENDARS QRTZ_CRON_TRIGGERS QRTZ_FIRED_TRIGGERS QRTZ_JOB_DETAILS QRTZ_JOB_LISTENERS QRTZ_LOCKS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_SCHEDULER_STATE QRTZ_SIMPLE_TRIGGERS QRTZ_TRIGGERS QRTZ_TRIGGER_LISTENERS CL_*: Tables used by Common Logger to log system messages.
|
|
|
|
SBM Application Repository Guide
|
• CANCELED – a user has canceled the deployment • CANCEL_SENT – a user has requested to cancel the deployment • ABORTED – a user terminated the deployment, an endpoint or target server validation failed, or there is some other problem that caused the deployment to stop
|
|
|
|
TeamTrack Database Schema
|
• QRTZ_*: Tables used by Mashup Manager for scheduling engine. QRTZ_ACTIVITY QRTZ_ACTIVITY _LOG QRTZ_ACTIVITY _PARAM QRTZ_BLOB_TRIGGERS QRTZ_CALENDARS QRTZ_CRON_TRIGGERS QRTZ_FIRED_TRIGGERS QRTZ_JOB_DETAILS QRTZ_JOB_LISTENERS QRTZ_LOCKS 18
|
|
|
|
TeamTrack Database Schema
|
Described below. • QRTZ_*: Tables used by Mashup Manager for scheduling engine. QRTZ_ACTIVITY QRTZ_ACTIVITY _LOG QRTZ_ACTIVITY _PARAM QRTZ_BLOB_TRIGGERS QRTZ_CALENDARS QRTZ_CRON_TRIGGERS QRTZ_FIRED_TRIGGERS QRTZ_JOB_DETAILS QRTZ_JOB_LISTENERS QRTZ_LOCKS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_SCHEDULER_STATE QRTZ_SIMPLE_TRIGGERS QRTZ_TRIGGERS • CL_*: Tables used by Common Logger to log system messages.
|
|
|
|
TeamTrack Database Schema
|
Described below. QRTZ_*: Tables used by SBM Application Administrator for scheduling engine. QRTZ_ACTIVITY QRTZ_ACTIVITY _LOG QRTZ_ACTIVITY _PARAM QRTZ_BLOB_TRIGGERS QRTZ_CALENDARS QRTZ_CRON_TRIGGERS QRTZ_FIRED_TRIGGERS QRTZ_JOB_DETAILS QRTZ_JOB_LISTENERS QRTZ_LOCKS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_SCHEDULER_STATE QRTZ_SIMPLE_TRIGGERS QRTZ_TRIGGERS CL_*: Tables used by Common Logger to log system messages.
|
|
|
