History Data Import Doenst Work
hi! I m trying to import history data from one mango to my local one by merging my NoSQL database. But i m getting this error:
I imported the data points before and i checked that they have the same xid. Also, i tried to import the data with the "restore", but it doesnt work right.
I hope someone has the solution to this.
phildunlap last edited by
Hi acamina, welcome to the forum!
The "Merge TSDB Data into Mango" tab is for bringing in values that would have been recorded using the same (or an older) version of the same SQL database (such that the data point IDs are the same in the database now and when the data was recorded).
If the matching is to be done on XID, you'll need an external SQL database for the locating which series is which in the TSDB, and you would use the second tab, "Migrate NoSQL Data into Mango." So, if you had an H2 backup of the Mango where the data was recorded, you could restore that to have the necessary information to bring in the NoSQL data to the correct series.