Unknown column 'BF001' in 'field list' in receiver JDBC channel

[Former Member]

Hi All,

When i am sending data SAP to JDBC, i am getting below error.

"Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dtdc_f_prepaid_balance' (structure 'STATEMENT'): com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'BF001' in 'field list'"

And i have used in receiver structure ACTION as INSERT and attached table name also.DB details also correct. I have sent some dummy detals in that only one record is posted successfully remaining are not posted.when BF001 data  field is empty that is posted, if it is having not posting showing above error

why it is not posting into tables.

[Bhargavakrishna]

Hi,

It seems there is no field with the name "BF001" in your database table.

please check your database once.

Regards

Bhargava Krishna

[Former Member]

Hi

Thank you for your reply.

It is not a field, the field name is Franchisee_ID

<FRANCHISEE_ID>BF001</FRANCHISEE_ID>

regards,

raj