Unable to execute statement for table or stored procedure.

[Former Member]

I am facing the following error while doing the monitoringinthe receiver communication channel..

This is actually idoc_aae tojdbc scenario..

What changes need to made in pi level or ms-sqllevelinorderto get it rectified?

'dbo.SalesDataFromSAP' (Structure 'Details') due to com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting date and/or time from character string

do help me out to resolve the same..

Regards,

valliprasad v r

[former_member187587]

Seems like you are dealing with Date\time conversion between systems in your SalesDataFromSAP field located under segment Structure 'Details'.

Databased expectes their specific format handling.

Please check:

• which format is expected in the Database ?
• Did you convert it correctly?
• Check the JDBC channel for specific Date\time handling if needed.

Look at the end of this sap.help page for specific date\time parameters required in Stored procedures

Configuring the Receiver JDBC Adapter - Configuring the JDBC Adapter in the Integration Directory/PC...