The value '' is not valid (record does not exist)

The value '' is not valid (record does not exist)

book

Article ID: KB0073982

calendar_today

Updated On:

Products Versions
TIBCO EBX All supported versions.

Description

On a non-mandatory foreign key is left empty, the following error message is displayed at record saving or in validation context:

The value '' is not valid (record does not exist).

User-added image

It prevents the user from saving the record and raises an error in the validation report.

Resolution

This message shows up when the primary key of the target table is allowed to be empty, because of a regular expression pattern.
The solution is to modify the pattern of that primary key so that it forbids empty strings.

Example: [a-zA-Z]* → [a-zA-Z]+ (zero or more letters → one or more letters)

Please refer to the empty string management documentation for more information.

Issue/Introduction

The value '' is not valid (record does not exist)

Additional Information

https://docs.tibco.com/pub/ebx/5.9.12/doc/html/en/models/constraints.html#distinguishNullFromEmptyString