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