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 :
- Create the connection with history database in Base data > DataBase
- 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!
