OI shutting down randomly (OpenInsight 32-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 32-Bit" author:"Sean Bartram" author:"[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]" author:"Bob Carten" author:"support@sprezzatura.com" author:"John Bouley"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== OI shutting down randomly (OpenInsight 32-Bit) ====
=== At 28 FEB 2007 08:48:03AM Sean Bartram wrote: ===
 
 
<QUOTE>
Using OI 7.1 on Windows Server 2003 Service Pack 1, with XP workstations - I've been developing in this environment for months with no problems.  Yesterday, at midday (and since then) all OI programs (i.e. OpenEngine, App Manager, Database Manager, System Editor, etc.) shut down completely at random - there is no rhyme or reason to when it shuts down.  Sometimes it's as soon as you log into the application, others you can be working along for several minutes, then poof - gone.  It seems to only happen when the client side is idle.  I've even tried running locally on the server itself, (to eliminate the network as an issue) with the same results.  I was able to run the OI Examples app on the server without this problem occurring.



There were no changes on the server or workstations yesterday, although I was developing in the application, I cannot imagine why something in the app would cause this random shutdown of OI.  Any thoughts or suggestions would be greatly appreciated.
</QUOTE>
----

=== At 28 FEB 2007 08:55AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>If you are running UD3 move back to 2.1 and review



http://www.sprezzatura.com/senl/volume_4_issue_3.htm#DEP



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

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

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

</QUOTE>

----

=== At 28 FEB 2007 09:19AM Sean Bartram wrote:  ===

<QUOTE>We have never switched to UD3 - using 2.1

</QUOTE>

----

=== At 28 FEB 2007 01:12PM Bob Carten wrote:  ===

<QUOTE>

In database manager, Environment settings - is background indexing set to run every 5 seconds? Try extending to 30+ seconds, see if that helps.

</QUOTE>

----

=== At 28 FEB 2007 02:19PM Sean Bartram wrote:  ===

<QUOTE>I increased the time of the background indexing to 60 seconds, after a little over a minute - poof, OI closed.  I changed it back to 5 seconds, within 15 seconds of being idle - poof.



So perhaps there is an index somewhere that is abending?  Is my only recourse to go and rebuild all the indexes in the system?

</QUOTE>

----

=== At 28 FEB 2007 02:30PM Sean Bartram wrote:  ===

<QUOTE>Of course, when I attempt to rebuild any and all indexes in a suspect table, OI abends.

</QUOTE>

----

=== At 28 FEB 2007 03:07PM Sean Bartram wrote:  ===

<QUOTE>I've also tried removing the suspect files indexes, with the same result - abend.

</QUOTE>

----

=== At 05 MAR 2007 04:18AM support@sprezzatura.com wrote:  ===

<QUOTE>You'll probably need to [url=http://www.revelation.com/knowledge.nsf/461ff2bd5a8ddeed852566f50065057d/f840a25836992711852563e200478c02?OpenDocument]rebuild the indexes manually[/url].  Although this document is for ARev, the basic concepts are the same.  If you need some help in finding the comparable OI commands, let us know.



support@sprezzatura.com

The Sprezzatura Group Web Site

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

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

</QUOTE>

----

=== At 05 MAR 2007 09:50AM John Bouley wrote:  ===

<QUOTE>I would add you should do a verify first. Also, OI index rebuild is not really great in handling/reporting errors.



We just recently had a customer report a problem of not being able to lookup data. The OI indexer blistfully flushed indexes with no indication of a problem while AREV reported that the link list was corrupted and needed to be rebuilt. When we tried rebuilding in OI it "flashed" and reported the rebuild was complete eventhough nothing happended. We had to delete the queued records before OI could rebuild.



I'm looking forward to testing this in 8.0...



HTH,

John

</QUOTE>

----

=== At 13 MAR 2007 08:21AM Sean Bartram wrote:  ===

<QUOTE>Bob,



That was indeed the problem, thank you for your insight.  Once I knew it was an index I was able to remove the index and rebuild from scratch.

</QUOTE>


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