0

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!

3 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 2 days ago
    • Reported - view

    You're attempt to change a "1" to a date time value. It correctly fails in Java. This is not a useful test.

      • ALN
      • yesterday
      • Reported - view

       
      Thanks for your prompt response.
      I have two follow-up questions:
      1. If your explanation is correct, could you clarify why Master Flow is considered valid if the Variable is still of type "date", but the "List" checkbox is deactivated?
      2. Additionally, even when the query is adjusted to return a date or datetime value instead of "1", Master Flow still fails with an error. Could you please explain why this happens?

      • "making the sophisticated simple"
      • AviPerez
      • yesterday
      • Reported - view

      Submit a support ticket and we'll take a deeper look into it

Login to reply

Content aside

  • Status Answered
  • yesterdayLast active
  • 3Replies
  • 26Views
  • 2 Following