Invoke code activity error: Invoke Code: Exception has been thrown by the target of an invocation

[ayushi_jain3 (ayushi jain)]

I ma using Invoke code activity and getting error as : Invoke Code: Exception has been thrown by the target of an invocation…

Below is the code I am using inside the activity:

Can Someone please help with this?

[Anil_G (Anil Gorthi)]

@ayushi_jain3

Please open the exception details from the locals panel when the error happens…in it you will see the exact exception

Check if you have passed all the required arguments

And you can actuall do this using assign and if activities

Cheers

[lrtetala (Lakshman Reddy)]

Hi @ayushi_jain3

Exception has been thrown by target of invocation - error occurs if the value goes null to the variable.

Check for any null values assigned/passed.

Check the values assigned to the argument.

[supermanPunch (Arpan)]

Hi @ayushi_jain3 ,

Could you also maybe try as per the Suggestion provided in the below post :

Invoke code - Exception has been thrown by the target of an invocation

Hi @Sirisha_Siri , To understand more about the error being faced inside the Invoke Code, try using Try Catch Block inside it like the below Updated Code. We would require to handle the Exceptions inside Invoke Code Activity to be able to understand where/what was the exact error. Try Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook xlApp = New Microsoft.Office.Interop.Excel.Application wb = xlApp.Workbooks.Open(in_FilePath) xl…