Input String was Not in a Correct Format in 20.10 version

[chaitanyaKumar]

Hi Community,

I am facing input string issue suddenly. previously my code is running 2018 version and in windows 7 environment. now we migrated the code to Win10 and UiPath 20.10 version. once we moved the code facing this issue.

can any one suggest on this.

[Quenton_Wayne_Rebello]

Could you share the contents of in_dtReport17 and io_dtLookupReport17

[chaitanyaKumar]

Hi Quenton,

all will be dealing with numbers.

Loan AC NO.	MORT/RETAIL/OD/RSME	PRODUCT ECL	N_IFRS_STAGE_SKEY	STAGE 24 MOB	24 MOB	CIF No.	Customer Name	IC No.	Product Type	Customer Indicator	First Disburse Date	First Instalment Date	Opening MIA	Opening Balance	Current MIA	Current Balance	STATUS PAID/UNPAID
324212353353	MORTGAGE	HL	2		158	4362810	Test	3.44981E+11	OD	2	26/3/2010		4	352,935.44	4	4,292,854.44	UNPAID

Regards,
Chaitanya

[Quenton_Wayne_Rebello]

The issue may mostly arise when converting to Int64 Type, instead you can try

(From x In io_dtLookupReport17 
Join y In in_dtReport17 On Integer.TryParse(x("Loan Ac No.").ToString.Trim,0) Equals Integer.TryParse(y("Loan Ac No.").ToString.Trim,0)
Select io_dtLookupReport17.Clone.LoadDataRow(New Object(){x("Loan Ac No.").ToString,y("Current MIA").ToString,y("UDF Tagging Account"),y("UDF Tagging Customer")},False)).CopyToDataTable