Btree Read Error (OpenInsight 64-bit)
At 02 SEP 2023 10:18:37AM melia wrote:
Hi,
I am running OI 9, OI 10 and UD 9.2 on my server.
Why does my OI 10 show Btree read error message very often ? Even when I don't do anything, just open the OI 10 IDE, this pop up message appears.
Does Anyone have the same experience like me ? Please help.
Thank you
Melia
At 02 SEP 2023 10:42AM Andrew McAuley wrote:
Hi,
I am running OI 9, OI 10 and UD 9.2 on my server.
Why does my OI 10 show Btree read error message very often ? Even when I don't do anything, just open the OI 10 IDE, this pop up message appears.
Does Anyone have the same experience like me ? Please help.
Thank you
Melia
From Sprezzatura :: Making Databases Happen (sprezzblog.blogspot.com)
As a side note - if you DO want to do this in 10.x there is a major caveat. Indexing has been rewritten for 10 and works in a different way than 9. This means that out of the box, OI 9 and OI 10 have different indexing routines and are not compatible. Fortunately Rev have provided a way to deal with this.
All that we need to do is edit or create a record in SYSENV called CFG_RTI_UPDATE_INDEX. Set line 1 to RTI_UPDATE_INDEX_90 then save it, exit OI and restart. This will force 10 to use 9 indexing logic. We've been working a lot with indexes on large tables in 10 and we'd recommend using this setting in any case if you're working with large data volumes. By large tables, we are talking tens of millions of rows.
For the avoidance of doubt - if you are sharing data between OI 9 and OI 10 you MUST do this or you will experience issues.
World leaders in all things RevSoft
At 02 SEP 2023 10:44AM Andrew McAuley wrote:
Hi,
I am running OI 9, OI 10 and UD 9.2 on my server.
Why does my OI 10 show Btree read error message very often ? Even when I don't do anything, just open the OI 10 IDE, this pop up message appears.
Does Anyone have the same experience like me ? Please help.
Thank you
Melia
This issue has been fixed in the latest release apparently
World leaders in all things RevSoft
At 03 SEP 2023 09:23PM Rudhy B wrote:
Is there any OI updates ? Where can I get the link to download the latest updates ?
Right now, I am already running OI 10.2
At 03 SEP 2023 09:33PM Donald Bakke wrote:
Is there any OI updates ? Where can I get the link to download the latest updates ?
Right now, I am already running OI 10.2
Andrew is either referring to 10.2.1 (which is still in Beta) or 10.3 (which is in process but nothing released yet). Perhaps he can clarify which one. If it is the 10.2.1 Beta, then I think you might want to wait for a little longer. I believe it will soon be officially released.
P.S. I owe you an email. I was on holiday and then we got sick at the end of our travels. I'm slowly catching up on a few things.