ENG0703: XOCACHE Line 1 variable exceeds ...... (OpenInsight) [Revelation On-Line Wiki]

OpenInsight, Edward Wells, WinWin/Revelation Technical Support

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

At 09 MAY 2000 06:49:58PM Edward Wells wrote:

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.

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

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

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

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

View this thread on the Works forum...