A Database Access Point processes database entries, but a Delete/Update record fails with "The value is not set for the parameter number x".
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.
Solve this by adding the unique ID / primary key column to the SELECT query (either add it individually, or select * (all) ).