0

Scheduled Report Management

Forum / Questions & Answers

Hi,

Is there a way to view and edit scheduled Axiom reports , and the details of the chart/application and the user?

I have many errors in the logs, all presumably from scheduled reports created by users that have since resigned and comprehensively removed from Active Directory.

 

I have seen some details in a SQLite file, but I don't want to scratch where I don't belong.

Regards,

Deon

3 replies

null
    • smason
    • 3 wk ago
    • Reported - view

    Hi ,

    You can use the ID from the message you're displaying to remove any reports you no longer wish to run. I've tried this on my system and it seems to have work. You may want to create a backup of the SQLite just in case. I had to remove it from 3 of the tables: 

    • QRTZ_CRON_TRIGGERS
    • QRTZ_JOB_DETAILS
    • QRTZ_TRIGGERS

    You should see the corresponding ID in the TRIGGER NAME or JOB NAME column within those tables. I would stop the Axiom service before editing the file.

    I had to run DB Browser as an admin in order to remove the records. I also noticed it would not let me remove the records from the QRTZ_JOB_DETAILS until I removed them from the other 2 tables and saved it.

    Once you remove the records from each of the 3 tables, Write Changes, then restart Axiom. I did not encounter any errors, even when the report was originally scheduled to run.

    Let me know how it goes.

    • deon_korb
    • 2 wk ago
    • Reported - view

    Hi Steve,

    Thanks for pointing me in the right direction. For future reference, I did the following:

    1. Export the errors to CSV and extract the list of error IDs with some string manipulation
    2. Stop Axiom, backup SQLite database
    3. Run query below with the list of IDs
    4. Save DB and restart Axiom

     

    DROP TABLE IF EXISTS temp.brokenreports;
CREATE TEMP TABLE brokenreports (id TEXT);

insert into temp.brokenreports
values
('id1'),
('etc...');

delete from QRTZ_CRON_TRIGGERS
where TRIGGER_NAME in (select 'axiom_trigger_' || id from temp.brokenreports);

delete from QRTZ_TRIGGERS
where TRIGGER_NAME in (select 'axiom_trigger_' || id from temp.brokenreports);

delete from QRTZ_JOB_DETAILS
where JOB_NAME in (select 'axiom_job_' || id from temp.brokenreports);

DROP TABLE IF EXISTS temp.brokenreports;
    • smason
    • 2 wk ago
    • Reported - view

    Nice! Thanks !

Login to reply

Content aside

print this pagePrint this page
  • Status Answered
  • 2 wk agoLast active
  • 3Replies
  • 23Views
  • 3 Following