• State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 94 subscribers
  • Views 9306 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

D1IM(6.1.2): How to tell if History Archive DB is working?

ToddFendt
over 7 years ago

I have attempted to configure and activate the History Archive DB. Service installed and running, service configured with one queue. Config params set to export over 90 days for Process View, progress View, and PropertyLog. IsToExport set to 1 for all three. Export Policy set to HDB. I have warning logging set for history service. it i slogging to a log file. Here are entries for history service logging:

 <w>2016-11-01 12:45:50 -04:00 - Warning: No private key supplied. Running without encryption support.<x>
<w>2016-11-01 12:45:50 -04:00 - Warning: No private key supplied. Running without encryption support.<x>
<w>2016-11-01 12:45:50 -04:00 - Warning: Starting queue \QIDINFWWATV01.<x>
<w>2016-11-01 12:45:50 -04:00 - Warning: Starting queue \QIDINFWWATV01.<x>

 

I know I  have a duplicate queue and I'm not sure how to correct that.

I keep running the Export process history job manually and scheduled and nothing seem to be archiving. 

I am looking for ways to tell what is going on?

The doc is very incomplete.

Any help is appreciated.

Parents
  • 0 over 7 years ago
    After redoing the Job Server Configuration several times the duplicate queue has disappeared. I was given these queries to look for records marked for deletion or export:

    select ReadyForDeleteOrExport, count(*) from DialogProcess
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from JobHistory
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from DialogWatchOperation
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from DialogProcessChain
    group by ReadyForDeleteOrExport

    Run these against the Main Database.

    And here are the meanings of the ReadyForDeleteOrExport values:
    ReadyForDeleteOrExport = 0 (Not completed)
    ReadyForDeleteOrExport = 1 (Ready for delete)
    ReadyForDeleteOrExport = 2 (Ready for export)

    I am waiting for evidence that records have been archived.
Reply
  • 0 over 7 years ago
    After redoing the Job Server Configuration several times the duplicate queue has disappeared. I was given these queries to look for records marked for deletion or export:

    select ReadyForDeleteOrExport, count(*) from DialogProcess
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from JobHistory
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from DialogWatchOperation
    group by ReadyForDeleteOrExport
    select ReadyForDeleteOrExport, count(*) from DialogProcessChain
    group by ReadyForDeleteOrExport

    Run these against the Main Database.

    And here are the meanings of the ReadyForDeleteOrExport values:
    ReadyForDeleteOrExport = 0 (Not completed)
    ReadyForDeleteOrExport = 1 (Ready for delete)
    ReadyForDeleteOrExport = 2 (Ready for export)

    I am waiting for evidence that records have been archived.
Children
No Data