2018626 - ESP error 150005 reports incorrect zero-length string and column width for IQ output adapter

The ESP project's error message 150005 reports an incorrect length of zero for both the source string and the destination column width. The ESP project logs this error message in its esp_server.log (located in the project's working directory) when the SAP Sybase IQ Output Adapter reads a string from the ESP project whose length is greater than the character width of the destination IQ database table's column.

Note: the adapter will truncate the string and IQ will insert the truncated string into the destination database column. (For example, the string “true” that is destined for a char(2) IQ database column will get inserted into the database column as "tr".)

Example of incorrect log message:

[SP-4-150005] (234.303) sp(5947) Connection(Sybase_IQ_Output2/s1):: A string value destined for the database column c1 has a length of 0000000000000000000, but the database column can support a length of at most 0000000000000000000. The data will be truncated to fit in the column.

Example of expected log message, e.g. for the string "true" destined for char(2) database column:

[SP-4-150005] (234.303) sp(5947) Connection(Sybase_IQ_Output2/s1):: A string value destined for the database column outstanding_indicator has a length of 0000000000000000004, but the database column can support a length of at most 0000000000000000002. The data will be truncated to fit in the column.

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