[[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]]


==== Record Locking causes Oengine failure (OpenInsight Specific) ====
=== At 18 MAR 1998 07:58:48AM Geoff Gullick - Documation Software wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I have a stored procedure which locks user recrods to see who is logged onto the system. It then unlcoks them again.. I can run this procedutre once OK. If I run it a second time without exiting OInsight it causes an Oengine failure. Running it in debug the failure occurrs when actually executing a lock statement. (The particular record being locked does not seem to make any difference.) 

The resulting error details are -

1. White windows Message "OENGINE  an error has occrred in your program......"

Choose Close or ignore.



2. On closing this message I get a standard illegal op message for Oengine.The details given are for a GPF in APILH2 at offset 0001:0000246A



Any ideas???





  
</QUOTE>
----

=== At 18 MAR 1998 08:02AM Geoff Gullick - Documation software wrote:  ===

<QUOTE>Correction to my initial msg - The problem code is event code not a stored proc

</QUOTE>

----

=== At 18 MAR 1998 07:15PM Cameron Revelation wrote:  ===

<QUOTE>Geoff,



[i]I have a stored procedure which locks user recrods to see who is logged onto the system. It then unlcoks them again.. I can run this procedutre once OK. If I run it a second time without exiting OInsight it causes an Oengine failure. Running it in debug the failure occurrs when actually executing a lock statement. (The particular record being locked does not seem to make any difference.)  The resulting error details are - 1. White windows Message "OENGINE an error has occrred in your program......" Choose Close or ignore. On closing this message I get a standard illegal op message for Oengine.The details given are for a GPF in APILH2 at offset 0001:0000246A[/i]



So you are running Win 95 (?) with the NPP.  Do you have an NT Service that you are using?  What version of OpenInsight?  If you look at the version tab of the file properties of APILH2.DLL (from Win95 explorer) what does it say the file version is?  (Example: 1.1.1.0)  What is the file date and size?



Thanks,



Cameron Purdy

info@revelation.com

</QUOTE>

----

=== At 17 APR 1998 09:56AM Geoff gullick wrote:  ===

<QUOTE>Hi Cameron 

Yes ,I am running win95 with the NPP, No NT service

OI version is 3.2

The APILH2.DLL details are as follows

Size       139,904 bytes

Date       Tue December 10 1996

Version    1.1.0.1



Hope this helps



Geoff 

</QUOTE>


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