• State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 93 subscribers
  • Views 7104 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

History DB

lerodriguezdiez
over 6 years ago

Hello everyone,

Im installing the HistoryDB and Im having some issues...

We have followed the administration guide, we have more than 300k registers ready to export (JobHistory and DialgWatchOperation tables ).  The configuration that we have followed on Main database is set TimeTrace and lifetime parameters. The configuration that we have followed on History database tools is:

-HDB Manager : Create the connection on ‘Base data’ with the main database with 'sa' user ( just write permissions only) . After that we can see all the existing tables.

-Designer : 

  1. Create the connection with history database in Base data > DataBase
  2. Create the job server connection: It is the server where we have installed the HDB service.

The problems goes when we go to HDB Designer and launch the schedule ‘Import process information directly’ we see the event ‘VI_SourceDatabase_import’ running (only a few second) but after the process is over, we check that there is not data imported on history database, we use the following query to check it:

select * from WatchProperty dwp join WatchOperation dwo on dwp.UID_DialogWatchOperation = dwo.UID_DialogWatchOperation

 order by operationdate desc

I think that we have forgotten something related with the connection to the main database.

Have anybody idea of what is happening?

Thank you guys!

Parents
  • 0 over 6 years ago
    Hi trevor,

    I copy you the result:

    select ReadyForDeleteOrExport, count(*) from DialogProcess
    group by ReadyForDeleteOrExport ---> 0 ready

    select ReadyForDeleteOrExport, count(*) from JobHistory
    group by ReadyForDeleteOrExport--> 316390 records ready.

    select ReadyForDeleteOrExport, count(*) from DialogWatchOperation
    group by ReadyForDeleteOrExport--> 6259 records ready.

    select ReadyForDeleteOrExport, count(*) from DialogProcessChain
    group by ReadyForDeleteOrExport--> 20007 records ready.


    And the last one query:
    2018-03 0 318
    2018-02 0 1114
    2018-01 0 612
    2017-12 0 33
    2017-11 0 478
    2017-10 0 123
    2017-09 0 81
    2017-08 0 5
    2017-07 0 51
    2017-06 0 219
    2017-05 0 202
    2017-04 0 360
    2017-03 0 589
    2017-02 0 713
    2017-01 0 133
    2016-12 0 8
    2016-11 0 77
    2016-10 0 29

    I think that shrink schedule is working, because when i launch it, we can see the number of 'ready for delete of exported' records is increasing.

    Thank you
Reply
  • 0 over 6 years ago
    Hi trevor,

    I copy you the result:

    select ReadyForDeleteOrExport, count(*) from DialogProcess
    group by ReadyForDeleteOrExport ---> 0 ready

    select ReadyForDeleteOrExport, count(*) from JobHistory
    group by ReadyForDeleteOrExport--> 316390 records ready.

    select ReadyForDeleteOrExport, count(*) from DialogWatchOperation
    group by ReadyForDeleteOrExport--> 6259 records ready.

    select ReadyForDeleteOrExport, count(*) from DialogProcessChain
    group by ReadyForDeleteOrExport--> 20007 records ready.


    And the last one query:
    2018-03 0 318
    2018-02 0 1114
    2018-01 0 612
    2017-12 0 33
    2017-11 0 478
    2017-10 0 123
    2017-09 0 81
    2017-08 0 5
    2017-07 0 51
    2017-06 0 219
    2017-05 0 202
    2017-04 0 360
    2017-03 0 589
    2017-02 0 713
    2017-01 0 133
    2016-12 0 8
    2016-11 0 77
    2016-10 0 29

    I think that shrink schedule is working, because when i launch it, we can see the number of 'ready for delete of exported' records is increasing.

    Thank you
Children
No Data