Esko Logo Back to Esko Support
Choose your language for a machine translation:


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) ). 

Article information
Applies to

Automation Engine 14.1 and higher

Created
 
Last revised
AuthorANDS
Case Number00640695
Contents