Unable to Insert Data in sql throught UiPath


#1

Message: Cannot create and populate list type System.Data.SqlClient.SqlErrorCollection. Path ‘$values’, line 1, position 163.

Query -

“Insert Into dbo.quest_bot_run (ICN,Engine,FLN,DCC,ChargeAmt,FirstDOS,LastDOS,ClaimFromEDSS,SecondaryICN,SecondaryFLN,SecondaryDCC,MsgToPrint,EDSS_SSN,EDSSPATFirstNAme,EDSSPATLastName,EDSSPATDOB,EDSSPATSex,EDSSCode,MsgFromCEI,MsgFromCEI2,MsgFromEDS9,SAMADJID,SAMADJDate,UNETChgAmt,UNETPaidAmt,UNETCauseCode,UNETPriDiagCode,SAMBilledAmt,EDSSChargeAmt,SAMPaidAmt,MsgFromPMI,MsgFromNDB,MsgFromRHI,BOTComments,BOTStartTime,BOTEndTime) values(StrUNETICN,StrEng,StrUNETFLN,StrUNETDCC,UNETChAmtDollar+’.’+UNETChAmtCent,UNETDOSF,UNETDOSL,ClaimForm,StrSecondaryUNETICN,StrSecondaryUNETFLN,StrSecondaryUNETDCC,StrMsgToPrintPrivateRoomCode,EdssSSN,EdssPATNameF,EdssPATNameL,EdssPATDOB,EdssPATSex,EDSSCode,StrMsgtoPrintCEI1,StrMsgtoPrintCEI2,StrMsgtoPrintEDS9,SAMAdjID,SAMAdjudicationDate,UnetAdjID,UnetAdjudicationDate,UnetChAmtDollar+’.’+UnetChAmtCent,UnetPdAmtDollar+’.’+UnetPdAmtCent,Mid(UnetCauseCode,1,1),UnetPriDiagCode,SamBilledAmt,EDSSChAmt,SAMPaidAmt,StrMsgToPrintPMI,StrMsgToPrintNDB,StrMsgToPrintRHI,StrMsgToPrintSAM,StartTime,EndTime)”

All values are variables.

Please advise, test connection is successful.