Invalid column name error in JDBC adapter

[Former Member]

Hi all,

My scenario is Proxy->XI->JDBC.

I get the following error in receiver JDBC adapter.

Unable to execute statement for table or stored procedure. 'Account_Master' (Structure 'STATEMENT') due to com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'A7'.

There is no column by name A7 in the table nor there is a field by that name in the data type.

Can anyone provide any help

[Former Member]

Thanks for the support guys.

The problem was with the length and type of one of the fields.

Rgds

Prashant

[bhavesh_kantilal]

Hi,

Can you post the Message being sent from XI to the JDBC adapter.

Regards,

Bhavesh

[Former Member]

Hi Swatantra,

compare your message-type with the database table!

There must be difference!

Regards Mario