Hi Experts,
I have an issue with the JDBC Update_Insert action with the SQL database.
When I tried with the Update function and Insert Function seperately the data was updating in the database fine.
When I use the UPDATE_INSERT action with the same data getting below error.
Error while parsing or executing XML-SQL document:
Error processing request in sax parser: Error when executing statement for
table/stored proc. 'CUSTMAST' (structure 'Statement'):
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be
truncated.
And the query that was running in the background was as follows
10.04.2014 16:34:45 Information JDBC
When I try this query manually in the database it is working fine but when I trigger the data from SAP PI 7.1 we are facing error as mentioned above.
Please help me with this.
Thanks in advance.