Home > Forum > Rules, JS, SQL > Run a subworkflow (SQL)

Run a subworkflow (SQL)

0

Damian Stąsiek

30.05.2023

11:52

Damian Stąsiek

I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What could be the cause of the error if the test query displays values correctly?

30.05.2023

13:43

Hi,
Where is the action located? as global cyclic? or e.g. on a path on an already registered element?

Solution (0)

Helpful (0)

Wrong answer (0)

Damian Stąsiek

30.05.2023

13:57

Damian Stąsiek

In reply to: Karol Częczek

Hi,
Where is the action located? as global cyclic? or e.g. on a path on an already registered element?

On a path on an already registered element. In other applications this query works fine.

Solution (0)

Helpful (0)

Wrong answer (0)

30.05.2023

15:03

In reply to: Damian Stąsiek

On a path on an already registered element. In other applications this query works fine.

For the purposes of the test, try manually entering the ID of the current element from which you are registering matches, instead of using the {wfd_id} variable, and see what the result will be.

Solution (0)

Helpful (0)

Wrong answer (0)

Damian Stąsiek

31.05.2023

07:25

Damian Stąsiek

In reply to: Karol Częczek

For the purposes of the test, try manually entering the ID of the current element from which you are registering matches, instead of using the {wfd_id} variable, and see what the result will be.

I entered the id manually and the problem is still the same. Any query that returns a value throws an error. However, when the query returns null, the problem does not appear anymore.

Solution (0)

Helpful (0)

Wrong answer (0)

Damian Stąsiek

31.05.2023

10:41

Damian Stąsiek

In reply to: Damian Stąsiek

I entered the id manually and the problem is still the same. Any query that returns a value throws an error. However, when the query returns null, the problem does not appear anymore.

Problem has been solved. It turned out that the problem is in another query in the subworkflow when initializing the list of items.

Solution (0)

Helpful (0)

Wrong answer (0)