Question

validation error

0

I have an entity 'Rental' with two date attributes: startDate and endDate. When I make a validation rule: endDate >= startDate and I create an instance of the entity I got an error message: Failed to set autonumber and/or tokens for object 'Rental'. What does this mean and how can I solve this problem?

asked 2011-01-20

Johan van der Graaf

3 answers

Alexander Willemsen · Answer 1 · 2011-01-20

Did you set [%CurrentDateTime%] as the default value for endDate and no default value for startDate by any chance? If so, this would explain the error: when the object is created Mendix tries to set the default value for endDate, but this fails because it doesn't comply to your validation rule (a date value is never greater or equal to an empty value).

IMO, validation rules should only be checked on a commit, but currently they are also checked when changing an object (including when Mendix tries to set default values for attributes). To solve the error, you could either validate using a before commit microflow instead of validation rules on the entity, or remove the default values for the attributes on the entity.

Chris de Gelder · Answer 2 · 2011-01-20

Problably you are setting an autonumber attribute.

Johan van der Graaf · Answer 3 · 2011-01-21

Alexander, Chris, thanks. I set [%CurrentDateTime%] for both endDate and startDate. I have no autonumber attribute. It is not the behaviour expected.