An OpenPages Administrator is Unable to Change the Default Value of an Enumerated String

Resolving The Problem

Prior to OpenPages FCM 4.x or OpenPages 5.x, blank enum values for drop-down properties was accomplished by having a value that contained a space character.

Beginning with FCM 4.x, this was no longer necessary.

In OpenPages 5.x, an error will occur if you try to change the default value to be blank in order to remove 2 blank values from the drop-down.

Attached to this solution is a SQL file that will rectify this situation by changing the label for the enumeration from " " to "<blank", then hiding this value.  The procedure for running it is as follows:

1. Stop all OpenPages services.

2. In a CMD, run the attached sql as follows:
   sqlplus openpages/<PASSWORD>@<DB_ALIAS> @fix_blank_enums.sql

   <PASSWORD> = openpages oracle user password
   <DB_ALIAS> = database instance used for OpenPages application

3. Start OpenPages services by starting AutoExNt service.

If you have objects that have this property value set, you can write a SCOR ruleset to change the property value for the object to be blank (if not required).  The value would need to be set to one of the drop-down values if the property is required.

Related Error Messages:
Error Message OP-01318 Please specify a valid name for the enumerated value.