1922285 - Aleri Streaming Platform "sp_archive" falls over intermittently with error

• The error message shown is below:

SqlState : HY000 Error Message :[Sybase][ODBC Driver][Sybase IQ]
Connection was terminated
ERROR: While bulk loading data for Stream to exernal repository.
ABORTING ARCHIVE.

On restart it's ok - affects various sp_archives on various UNIX servers  and no errors/warning in Sybase IQ logs. 

• The full error from sp_archive screen is:

  Reading base data for Stream AnalysisResult_log...
  Done reading base data for Stream AnalysisResult_log
  1 transactions bulk loaded from Stream AnalysisResult_log.
   failed SQLRETURN code is -1
  ERROR: Executing Statement
  load table AR102_Partition (AnalysisResultEntryId,AnalysisEntryId,ScenarioEntryId,DeliveryEntryId,LegDateTenorEntryId,RiskMeasureTypeOriginalEntryId,RiskFact orEntryId,RiskMeasureTypeEntryId,TradePositionEntryId,InstrumentTenorEntryId,UnderlyingTenorEntryId,FixingTenorEntryId,DeliveryId,  ScenarioDate,Value,ValueCurrency,DataStatusId,Valid,Warning,Invalid ) from '/app/alr/archive/sit3/transformation/fx/analysisresult/AnalysisResult_log_20130902_113518000.csv'  BLOCK SIZE 1000000 DELIMITED BY '' ESCAPES OFF FORMAT ASCII IGNORE CONSTRAINT UNIQUE 0 MESSAGE LOG '/app/alr/archive/sit3/transformation/fx/analysisresult/log/m.log' ROW LOG '/app/alr/archive/sit3/transformation/fx/analysisresult/log/r.log'  ONLY LOG UNIQUE, NULL, DATA VALUE LOG DELIMITED BY ',' QUOTES OFF ROW DELIMITED BY '
  '; commit;
  SqlState : HY000 Error Message :[Sybase][ODBC Driver][Sybase IQ]Connection was terminated
  ERROR: While bulk loading data for Stream to exernal repository.
  ABORTING ARCHIVE.

  DATA ARCHIVAL FAILED TO FINISH SUCCESSFULLY ON: Mon Sep  2 11:35:18 2013

• IQ Version= Sybase IQ/15.4.0.3027/130221/P/ESD 3/Sun_x64/OS 5.10/64bit/2013-02-21 19:58:48
• IQ Client= IQ15.4ClientSolaris-64bitEBF20597
• Solaris version= SunOS wfd-alrap4 5.10 Generic_147441-27 i86pc i386 i86pc
• Aleri Streaming Platform = Release 3.2  REVISION <28292M>, start timestamp (gmt): 2013-08-28 13:35:03

KBA , aleri streaming platform , BC-SYB-CEP , Sybase Aleri Streaming Platform (CEP) , Problem