I have a protocol that reads data out of a file, checks various values against different database tables, and adds data when it is not found in the database.  The protocol is set up to execute all of the SQL for a file as a single transaction, so if an error is found, all database changes can be rolled-back.  On larger files, I will receive the error below on random SQL Select components after running for a while.  None of the select statements retrieve more than a single column from a single row.  Is Pipeline Pilot caching the results of every SQL query in memory for a single transaction?  Is it possible to clear this cache after each record completes pipeline?  We are using Pipeline Pilot 8.0.  Thanks for the help.

No more memory is available: 5000000 objects of size 1 requested

vcByteArrayCache::MemFileInfo::WriteBlock: Pipeline Pilot exception rethrown

vcByteArrayCache::MemFileInfo::WriteDataBlock: Pipeline Pilot exception rethrown

vcByteArrayCache::WriteDataBlock: Pipeline Pilot exception rethrown

vcByteArrayCache::EndRecord: Pipeline Pilot exception rethrown

vcCache::SaveRecord: Pipeline Pilot exception rethrown

CRDBMSComponent::onProcess: Pipeline Pilot exception rethrown

-> Get gene ID if missing (SQL Select for Each Data) - error during Data Record Processing phase

CProtocolRtc::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> Subprotocol 1 (Subprotocol) - error during Data Record Processing phase

CProtocolRtc::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> Parse Job files (Subprotocol) - error during Data Record Processing phase

CProtocolRtc::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> RNA-SEQ (Subprotocol) - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

Protocol NGO Parse Data, user oemler: Pipeline Pilot exception caught

Protocol NGO Parse Data, user oemler: Protocol failed: Pipeline Pilot error

Pipeline Pilot Server version 8.0.1.700

Server OS: Windows 6.0 Server Service Pack 2