G'day,

I have a protocol that contains two sub-protocols which in turn contain SQL Select for each Data components.  When I run the protocol I get the following error message:

CStdioFile: Unable to open file /apps/pp/web/jobs/cpudney/{ppcA4AD6-865A-A25E-BDF1-39E9F163F134}/_cptcache_/{A1F389FF-CEB1-4699-A6AD-FBC23E3ADE52}/CACkZdynj.tmp for reading: No such file or directory

Locating the error identifies the SQL component in the first sub-protocol.  If I disable one of the sub-protocols then the error goes away.

Is the second instance of the SQL component cleaning up cache files that are still needed by the first instance?

Regards,

Chris.

Here's the full error stack:

CStdioFile: Unable to open file /apps/pp/web/jobs/cpudney/{ppcA4AD6-865A-A25E-BDF1-39E9F163F134}/_cptcache_/{A1F389FF-CEB1-4699-A6AD-FBC23E3ADE52}/CACkZdynj.tmp for reading: No such file or directory

vcFile::Open : Failed to open /apps/pp/web/jobs/cpudney/{ppcA4AD6-865A-A25E-BDF1-39E9F163F134}/_cptcache_/{A1F389FF-CEB1-4699-A6AD-FBC23E3ADE52}/CACkZdynj.tmp: Exception caught

vcByteArrayCache::DiskFileInfo::OpenFile: Pipeline Pilot exception rethrown

vcByteArrayCache::DiskFileInfo::ReadDataBlock: Pipeline Pilot exception rethrown

vcByteArrayCache::DiskFileInfo::GetDataBlock: Pipeline Pilot exception rethrown

vcByteArrayCache::FileInfo::ExtractDataBytes: Pipeline Pilot exception rethrown

vcByteArrayCache::GetDataBytes: Pipeline Pilot exception rethrown

vcCache::GetRecord: Pipeline Pilot exception rethrown

CDataCacheIO::onProcess: Pipeline Pilot exception rethrown

-> Fetch biology

(SQL Select for Each Data) - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> Get biology (Subprotocol) - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> EPS breakpoint (Local Shortcut) - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

-> Break pointing (Subprotocol) - error during Data Record Processing phase

CProtocolStd::onProcess: Pipeline Pilot exception rethrown

CProtocol::onProcess: Pipeline Pilot exception rethrown

CComponentRunner::CallOnProcess: exception caught, calling onFinalize before rethrow

Protocol GHDC, user cpudney: Pipeline Pilot exception caught

Protocol GHDC, user cpudney: Protocol failed: Pipeline Pilot error

Pipeline Pilot Server version 8.5.0.200