KB180985314: Automation Engine - Database Access Point Delete or Update Record fails with "The value is not set for the parameter number x"

Summary

A Database Access Point processes database entries, but a Delete/Update record fails with "The value is not set for the parameter number x".

Symptoms

The Database Access Point functions, it does process queries, entries are detected and the requested workflow is started, but the records are not deleted or updated. As a consequence, the Access Point keeps detecting the entries.

When manually executing the Database Access Point, an error "The value is not set for the parameter number x" is returned

Problem description: The SELECT query does not return the unique ID / primary key, so when trying to execute the 'After Processing' action (Delete or Update the Record), it cannot find the matching record.

Solution

Solve this by adding the unique ID / primary key column to the SELECT query (either add it individually, or select * (all) ).