Unable to Validate Data Flow Because of the SQL Script Node

Hello PA Team,

I encountered an issue with SQL Script node in the Master Flow.

Steps to reproduce:

1. Create new model and dataflow
   In our case it’s a simple dataflow from excel file to an In-Memory database

   

2. Open Master Flow

3. Add “SQL Script” and “Data Model” nodes and connect them to the Data Flow

   

4. Configure SQL Script node to access In-Memory DB and choose any available DB

5. In the SQL Script node write query: “SELECT 1”

   

6. Add new Variable in the following manner:
   Change Data Type to “Date” and activate checkbox “List”

   

7. Press Validate or Process Model

I get an error: «java.lang.NullPointerException: Cannot invoke "java.time.LocalDate.format(java.time.format.DateTimeFormatter)" because "date" is null»

 

If I remove the variable, or deactivate the "List" checkbox, or delete the SQL Script node, the flow is considered correct.

Thanks!