Hello Team, @amit_anand15 Amit
I am using AE Studio v18.2 Enterprise Edition.
I am trying to read data from excel and inserting it into mysql database.
I am using Excel loop to read data from file and pass it to ‘Input Parameters’ in Execute Db query activity to pass values to store procedure.
When I have all values in the column in excel file, the process works fine and data is inserted successfully in database.
My issue is,
When I leave a cell for a header blank(value under Name header is left blank in attached screen shot), the process breaks at ‘Execute Db query activity’ saying ‘Object reference not set to instance of an object’.
I found out the control doesn’t even pass to store procedure and seems to be broken at Input Parameters.
Could you please assist on this issue and help to get it resolved.