Btree Read Error (OpenInsight 64-bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight 64-bit"}}

[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Btree Read Error (OpenInsight 64-bit) ====
=== At 02 SEP 2023 10:18:37AM melia wrote: ===
 
 
<QUOTE>
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.





[url=https://optikseis-aws-jkt.s3.ap-southeast-3.amazonaws.com/images/mainbanner/error.png]Your text to link here...[/url]





Thank you



Melia


</QUOTE>
----

=== At 02 SEP 2023 10:42AM Andrew McAuley wrote:  ===

<QUOTE>
<QUOTE>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.





[url=https://optikseis-aws-jkt.s3.ap-southeast-3.amazonaws.com/images/mainbanner/error.png]Your text to link here...[/url]





Thank you



Melia

</QUOTE>



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.

 



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 02 SEP 2023 10:44AM Andrew McAuley wrote:  ===

<QUOTE>
<QUOTE>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.





[url=https://optikseis-aws-jkt.s3.ap-southeast-3.amazonaws.com/images/mainbanner/error.png]Your text to link here...[/url]





Thank you



Melia

</QUOTE>



This issue has been fixed in the latest release apparently



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 03 SEP 2023 09:23PM Rudhy B wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 03 SEP 2023 09:33PM Donald Bakke wrote:  ===

<QUOTE>
<QUOTE>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</QUOTE>



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.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=ADBAF64AC514284B851383FD3F03136F|View this thread on the  forum...]]