What does "insufficient data left in message" mean and how to avoid it?

[jmuehlenhoff]

Hi,

under certain conditions one of our customers gets:

EPgError "insufficient data left in message"

Our code is using the TPgLoader component to copy data to Postgres.

What exactly does this message mean? Are there any limitations we need to be aware of?

[azyk]

The error "insufficient data left in message" can occur in cases when a value in incorrect format is passed to a table field on the server. For example, if you pass a value 'abccd' (string) for a field of the uuid data type. A script for creating such a table:

Code: Select all

CREATE TABLE tbl_customer_master_data (credit_controller_id uuid);

[jmuehlenhoff]

Thanks, we'll have a look at the data types and loader input.

[azyk]

Feel free to contact us if you have any further questions.