Attach Tabbles from OIv9 to OIv10 (OpenInsight 64-bit)
At 01 JUN 2023 05:32:04AM Johan Liebenberg wrote:
Hi all,
I am more confused than usual with this attaching table business. I found this post from 2021 related to my problem.
Attach OI 9 table from within OI 10
From this I gather that you cannot access the same tables ruled by different versions of UD, 4.7 for OIv9 and 5.2 for OI v10.
All good as I have not yet installed UD5.2 for OIv10.
As a test I copied the oiv9 data files which lives in a seperate folder outside of the OIv9 folder, to a new location (c:\temp). Then I deleted the revparam file from the base of this new group of folders. The new copy of the data now looks something like this:
c:\temp\appdata\shared_data
c:\temp\appdata\shared_data\module1
c:\temp\appdata\shared_data\module2
c:\temp\appdata\shared_data\module3
All the above folders contains REV*.* files.
In OIv10 I created a new account with the same name as the original OIv9 account and log into this new matching OIv10 account. From here I go to Add Tables and navigate to c:\temp\appdata\shared_data and under Available Tables there is only a message "<The selected location contains NO OpenInsight tables>".
Selecting two of the other 3 works just fine. What is preventing some REV*.* files to no be avaiable?
I double checked for revparam files everywhere on c:\temp, nothing there. All the folders only contain *.LV, *.OV, REVLOCKS, REMEDIA.LK & REVMEDIA.OV.
No Anti-virus installed.
I have had issues with this constantly for weeks now. I create a new folder on c:\dataconv and create tables in there with OIv9. No revparam. Then I copy this elsewhere and try to attach it. Works fine. Then I update the original c:\dataconv from OIv9 with fresh data, copy it elsewhere again and this time it will not attach it again. Note that I tried detaching the volume 1st in OIv10 before I tried to re-attach it with the new data. No luck. Sometimes it works by simply renaming the folder with say folderX, then OIv10 will attach it without any issues. Next time around, folderX stops working…
Thanks :)
Johan Liebenberg
IOT Engineering
Brisbane
Australia
At 01 JUN 2023 08:03AM bob carten wrote:
Hi Johan,
I think two UD5 features are affecting you.
First, the UD5 client (revLh.dll) requires a revparam. More specifically, it defaults to ServerOnly=1 rather than ServerOnly=0.
We made the change so that you can better control who can attach tables.
Second, the UD5 client remembers what it learns from reading the revparam.
We made this change to reduce the number of times the ud client reads the revparam.
So, when you access your new volume, the UD client looks for a revparam. Finding none, it defaults to ServerOnly=1 and remembers that information for that location for the remainder of your OI session.
For a quick fix, I think you need to add a revparam with serverOnly=0, or a revparam with all the details, then restart OI.
At 02 JUN 2023 04:06PM Johan Liebenberg wrote:
Hi Bob,
Thanks for that. I am not currently using UD5 on OIv10. I still need to install it. But in the mean time, I think it is best not to have UD4/5 running and clashing.
Back in the days of RevG, we used to edit the ROSMEDIA.MAP file to change volume names and accounts linked to files. This seems to be ralated as it recognizes the previously used volume name or something and cannot re-use that.
Thanks
Johan Liebenberg
IOT Engineering
Brisbane
Australia