2018625 - The ESP IQ Output Adapter raises error 100005 when attempting to delete nonexistent records from IQ

The ESP SAP Sybase IQ Output Adapter logs error message 100005 when attempting to delete nonexistent records from an IQ database table. This error is unexpected because IQ does not treat this type of delete as an error condition. ESP should only raise errors that IQ treats as errors.  Additionally, since the delete is considered an error, the SAP Sybase IQ load file for the delete remains on the ESP’s file system. For each delete of this type, files continue to accumulate unnecessarily, and take up space in the file system.

For example, when attempting to delete a row from the IQ table named "DBA"."test" that does not exist there, ESP logs these messages to the project's esp_server.log file:

[SP-3-100005] (23.362) sp(9592) Error executing SQL statement DELETE FROM "DBA"."test" WHERE "a"=2.22.
[SP-3-148015] (23.516) sp(9592) ConnectionWriter(BPD_Out) error writing to Connection(BPD_iqOut): 2014-04-14 14:57:01 The IQ Output Adapter could not load the SQL data file C:/tmp/primary DBA.test_S_20140414_145700_002290.dat.. 2 records posted, 2 processed, 2 bad, 0 good.

SAP Sybase Event Stream Processor 5.1 SP04 (and above, until the issue is fixed).

esp_server, server , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem