ENG0703: XOCACHE Line 1 variable exceeds ...... (OpenInsight) [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" author:"Edward Wells" author:"WinWin/Revelation Technical Support"}}

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


==== ENG0703: XOCACHE Line 1 variable exceeds ...... (OpenInsight) ====
=== At 09 MAY 2000 06:49:58PM Edward Wells wrote: ===
 
 
<QUOTE>
I am running a process that sends hundreds of SQL statements.  After about 600 times through the loop I recieve the following error:

ENG0703: XOCACHE Line 1 variable exceeds max length (64K).



I have to restart OInsight after recieving this error.  We are warehousing data for a web site to a SQL Server database.  

Is there a command that can reset the offending variable?  Any help on this would be appreciated.
</QUOTE>
----

=== At 09 MAY 2000 08:51PM WinWin/Revelation Technical Support wrote:  ===

<QUOTE>Ed-



Have you tried cancelling and destroying all connections and queries every 500 commands or so? This will unregister entries in the XOCACHE.



Hope it helps-



Mike Ruane

</QUOTE>

----

=== At 10 MAY 2000 01:04PM Edward Wells wrote:  ===

<QUOTE>Mike, 



Yes I do. Actually in this case we create and destroy the connection every 10 calls.  Before each sql call (QryMethod -- $SQL_EXECUTE) we cancel.



Most of these calls are contained in inet procedures.  We are doing a conversion so we have a bunch (of inet calls ) queued up.



Thanks,



Ed

</QUOTE>


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