Hi all,

Decided that I needed a clean and fresh 10.2.1 install. After the install, I created the same application as before and the same users as on the 10.1 system. I then copied all the application entities via RDK from 10.1 to 10.2.1

The last step was to attach the data tables from the old 10.1 system under 10.2.1.

I created a folder under ..\OInsight10\custdata in 10.1, which I copied as is to the 10.2.1 system.

I then attached the tables the usual way via the "Add tables" dialog and then saved the database definition.

Now at this point everything worked fine until I realised that the Btree Index tables are not visible and none of the index (!*filename) files are showing in the database tool panel on the left. Selecting a file (right click drop down menu) that previously had a Btree index, now have most options greyed out including "List Indexes…" and "Update/Rebuild Index…"

So I am stuck because I cannot attach it manually, delete and rebuilt it because it is not visible, or create a new index because it is greyed out.

What to do?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Hi all,

Decided that I needed a clean and fresh 10.2.1 install. After the install, I created the same application as before and the same users as on the 10.1 system. I then copied all the application entities via RDK from 10.1 to 10.2.1

The last step was to attach the data tables from the old 10.1 system under 10.2.1.

I created a folder under ..\OInsight10\custdata in 10.1, which I copied as is to the 10.2.1 system.

I then attached the tables the usual way via the "Add tables" dialog and then saved the database definition.

Now at this point everything worked fine until I realised that the Btree Index tables are not visible and none of the index (!*filename) files are showing in the database tool panel on the left. Selecting a file (right click drop down menu) that previously had a Btree index, now have most options greyed out including "List Indexes…" and "Update/Rebuild Index…"

So I am stuck because I cannot attach it manually, delete and rebuilt it because it is not visible, or create a new index because it is greyed out.

What to do?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Do you have revparams anywhere in old or new OI10.

Are you running the LH Service, is it now running from the new location

Did you remove the running oengineserver from services and then reinstall from new location.

last resort - try reboot.

Fresh LH5.2 install.

revparam correctly set only in the root folder of OInsight10

Restarted services

Tried with revparam in the custdata folder

Still the same, cannot see the !* files.

Now looking at the DBT trying to compare the current to the backup DBT. Any tools available to make this process easier?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

FWIW, I started a tool to look at dbt's. It's more a proof of concept than a finished product. I think we shipped it. From system monitor, exec rti_dbt_viewer, see if that shows you the content of the dbt file.

Thanks Bob, got the new tool to display my dbt, but the !files are missing.

I made a backup of the dbt and are now trying to manually add the missing !files back via a Notepad++ compare. I 1st converted to txt format and will convert it back to the original format after I am done editong.

I noticed the slightly different format not having DICT.MFS,… in front of the !* files.

Got a backup, what can go wrong ;)

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Post removed by author

FWIW, I started a tool to look at dbt's. It's more a proof of concept than a finished product. I think we shipped it. From system monitor, exec rti_dbt_viewer, see if that shows you the content of the dbt file.

Looks great - needs vertical scroll bars in the tables and a delete row option in the 'Volumes' table. Yes, I know it says '_viewer' , maybe a _maint version with backup warnings and disclaimers!! :wink:

Fresh LH5.2 install.

revparam correctly set only in the root folder of OInsight10

Restarted services

Tried with revparam in the custdata folder

Still the same, cannot see the !* files.

Now looking at the DBT trying to compare the current to the backup DBT. Any tools available to make this process easier?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Try detach folders / save / attach

Fresh LH5.2 install.

revparam correctly set only in the root folder of OInsight10

Restarted services

Tried with revparam in the custdata folder

Still the same, cannot see the !* files.

Now looking at the DBT trying to compare the current to the backup DBT. Any tools available to make this process easier?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Try detach folders / save / attach

Did you copy the data folders over or created new folders and pasted the .lk/.ov files in?

Sort of works. After the manual edit, I can see all the !files again. If I double click on the !file, a popup displays all the index fields. Good!

But, if I right click and select "update/rebuild index…", there are no index fields in the display…

Missed something. I will try again…

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Tried all of that. If it is missing from the DBT, it's not going to display it.

So when I 1st attached the the folder to the newly installed 10.2.1, for some reason it did not pick up the !files.

Johan Liebenberg

IOT Engineering

Brisbane

Australia

When I added the !files back in the dbt, I excluded the DICT.MFS from the !files. But in the dbt viewer, it displays the !files now, but with DICT.MFS added back. When I compare this with the EXAMPLES application, the !files in there do not have the DICT.MFS in the dbt viewer.

Bob, any ideas? I can edit the dbt again and see if I can manually remove it again.

Johan Liebenberg

IOT Engineering

Brisbane

Australia

If I right click on the !file, and I click add a new index column, the following error comes up.

Unknown Error: Code FS210, !PARTS*EAIT*{2680C748-DD08-E940-904E-BCB1499A78D2}, %2%

So it looks like the details of the btree index setup is stored in the repos, but it did not with the RDK?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

If I right click on the !file, and I click add a new index column, the following error comes up.

Unknown Error: Code FS210, !PARTS*EAIT*{2680C748-DD08-E940-904E-BCB1499A78D2}, %2%

So it looks like the details of the btree index setup is stored in the repos, but it did not with the RDK?

Johan Liebenberg

IOT Engineering

Brisbane

Australia

One more thought:

Make copy of your app dbt

Delete the app dbt

Make copy of examples.dbt

rename the examples .dbt to the app dbt

Open the app

Remove any examples related tables

save

add your app tables

save

close app

open app

Are the missing tables there now?

Hi, Johan. You can take a look at this thread which discusses the FS210 error when someone has an index file problem, and see if the suggestions there help. In particular, if other suggestions don't work, you might manually remove the indices - the KB article doesn't seem to be around anymore, but here's a link to the description in the manual.

Hope that helps,

- Bryan Shumsky

Revelation Software, Inc.

Hi Bryan / Barry,

All the usual tricks did not work. The old documents listed some TCL commands not available anymore.

I managed to rebuild the DBT and to display the !files. But, I could not see the existing index fields if I tried to rebuild the index. I also couldn't add "existing" fields. A double click on the !file opened a popup displaying the indexed fields correctly. But I could not delete the !files or the invisible index fields via the GUI.

This page allowed me to edit the dictionary and manually remove the index from each of the the dictionaries, one by one in the editor.

After this, I was able to save the DBT, logout and back in and add the index fields back manually. The trick was in removing them via the dictionary 1st.

When I added the index fields back, and rebuild after I added them and saved, some indexes were OK. Other I had to go in a second time and rebuild them again before they started working.

Thanks, seems like everything is back to what is was before the 10.2.1 fresh install.

Johan Liebenberg

IOT Engineering

Brisbane

Australia

Hi, Johan. Glad to hear you've got it working again. Yes, I'd hoped the manual removal (from the dictionary fields) is what you needed to do to get everything fully "cleaned up", and once that was done you'd be able to recreate the indices.

Regards,

- Bryan Shumsky

Revelation Software, Inc.

View this thread on the Works forum...