Run Command: Conversion from string '27AAAFS7156D1Z9' to type 'Integer' is not valid

Help Studio
,
1

Today, we tried to insert data into the database, extracted from DU, but we are facing the following issue:

“Run Command: Conversion from string ‘27AAAFS7156D1Z9’ to type ‘Integer’ is not valid.”

This error occurs in every field. We have already checked all the parameter data types, and they match. However, the studio is behaving unexpectedly. Please look into this issue and provide a solution as soon as possible.

We are connected to Microsoft SQL Server with the studio. It was working fine and inserting data properly yesterday, but today we are stuck with this issue.

Please find the attached screenshot for your reference.

Looking forward to your prompt response.

List item

The image displays a table listing various input arguments for a process, including their names, types, and associated values in a software configuration interface. (Captioned by AI)
The image displays a table listing various input arguments for a process, including their names, types, and associated values in a software configuration interface. (Captioned by AI)1345×638 40.2 KB

The image shows the UiPath Studio interface with a sequence in the workflow, highlighting a SQL command execution for an invoice insertion process, and an output log indicating a type conversion error from string to integer. (Captioned by AI)
The image shows the UiPath Studio interface with a sequence in the workflow, highlighting a SQL command execution for an invoice insertion process, and an output log indicating a type conversion error from string to integer. (Captioned by AI)1324×686 61.6 KB

The image shows a SQL stored procedure script named "SP_Miro_2_INVOICE_Insert" with various parameters for inserting invoice data into a database. (Captioned by AI)
The image shows a SQL stored procedure script named "SP_Miro_2_INVOICE_Insert" with various parameters for inserting invoice data into a database. (Captioned by AI)819×521 34.3 KB

2

when the value is the value which should be parsed within a number, then keep in mind that it contains Letters 27AAAFS7156D1Z9 so the value is not a number

3

i am not trying to Convert i just called SP to insert the data into DB but it is giving that exception i tried all the possible ways but it is not resolved please check images and give me suggestion

4

from the current screenshot we do see a few XXX.parse(… and this is about conversion. The error message itself is also a hint for

However, you can analyze by

  • which column has the reported value
  • what is done further with the value

Analysis can be done with debugging / immediate panel

5

Could you please tell like the below value belongs to which column in list as well as in DB?

27AAAFS7156D1Z9

Edit - Found that it is for Vendor GST Number. Does this column in DB was created as varchar only or was it previously configured as INT??

Did you tried creating a new column with varchar property and update to that column instead of existing one?Are you facing the same error?

Also check the syntax of DB insert command is correct and matching with the values and columns. Considering the number of fields are more - it is worth to confirm that as well