Flow Designer NullPointerException

[Kaniel Battles]

I am receiving the error below when running a flow that calls a custom action to insert records into a SQL Database.  

Flow Designer: Operation(SQL Insert.9695db1397f31d5497b2f576f053afab.5295db1397f31d5497b2f576f053afcb./start) failed with error: com.snc.process_flow.exception.InValEvaluationException: java.lang.NullPointerException

The action works as designed.  I am receiving this error as soon as the flow calls the action.  I have deleted and recreated the flow.  I have removed the action and added it back.  I have hard coded values in the test.  Nothing works. Any ideas what is causing this error?  

[reshmapatil]

Hi @Kaniel Battles ,

What type of input variable and what input are you passing from flow to inputs.columns?

Have you defined the input variable in the inputs component and also in the script step?

Also, add a log to check inputs.columns value.

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

[Kaniel Battles]

The columns input variable in the action is a string array.  It is also declared in the script step.

[kimberlynealy]

I had this error show up yesterday after adding the 'create due date' to my Flow. I went to HI support to open a ticket but decided to search via "Ask Now Assist" for the error and learned "the Flow is trying to access an object or variable that has not been initialized or has been set to null. To fix the error, you need to identify the object or variable that is causing the error and make sure it is properly initialized before it is used."

Therefore, since the error occurred on the Create Due Date step, I checked the configuration and the problem was that I had added a schedule-  "weekdays excluding holidays" - but I failed to check the little box next to "Use a Schedule?" . It is always the little things. After selecting use a schedule & Save, I ran the flow again and  the error was gone. The Ask Now Assist search feature was very helpful in breaking down exactly what this error meant.