Hello All!
With 10.3 version, I’m using a BatchInsert Adapter Service to insert amounts of data in a SQL Server database.

But, I’m getting the following message:
"NumberFormat Exception for field: Material_code. Error: For input string: “888R0R1200"”

The problem is that “Material_code” field is NVARCHAR and it is defined as “java.lang.string” as the image shows below:

image1568×395 10.2 KB

Please, what am I doing wrong? I don’t know why its throwing this exception.

Thank you!

Dear All,

I managed to solve the issue.

I had to delete and recreate all the Columns fields in the Service Adapter using the button below:

image1621×437 11.9 KB

Now it is working as it should.

Thank you for your assistance.