Error in JDBC receiver communication channe

[Former Member]

Hi all,

My interface is sap to jdbc and i am facing with below error.

But my structure doesn't have that field " COLLECTIBLE_AMNT". But receiver CC showing Field "COLLECTIBLE_AMNT" doesn't have a default value. if my structure having any field like above, i can change .

But i don't have that field.....where is the problem.  and how to resolve it

thanks advance...

Regards,

raj

[nabendu_sen]

Hi Raj,

I think you have not defined <COLLECTIBLE_AMNT> field in your Receiver JDBC structure. I will suggest you import the structure metadata from the Database to ensure you are not missing any field which is expected by the Database.

This process actually helps to eliminate Typing and Typo errors.

Regards,

Nabendu.

[Former Member]

May be, COLLECTIBLE_AMNT is a parameter of stored procedure,called by JDBC adapter, declared without default value in stored proc definition, and it not passed to target stored procedure in mapping?

[former_member184720]

>>>But my structure doesn't have that field " COLLECTIBLE_AMNT". But receiver CC showing Field "COLLECTIBLE_AMNT" doesn't have a default value. if my structure having any field like above, i can change .

May be this field and a value for it is expected by your stored procedure. Did you check that?