Hi all. I have configured a jdbc connector against some table, on which I have mapped account id and locked attributes, to respective fields. In this table, the lock field has Yes-No values. So, in the attribute mapping con connector xpress, I establish the attribute format to the suspend enumerated value. I also modified this enumerating value, in this way (value-display name-ordinal):
* on this table, YES means the user is unlocked
I can perform an explore / correlation which works fine. I see that users with YES have the etLocked attribute with 0 value. Also, users with NO (locked users on my application) has etLocked with 1 value. Also, on Provisioning Manager, I see some locked user with the LOCKED display value. I changed this to UNLOCKED, and in application this change is well performed.
Problem is on the user console. I have generated the role definition data and imported. I can see this new endpoint on user console now, but all users appear as Unlocked. Also, if Y try to force an unlock, I get this following exception. Is there some mapping I should add besides the one I described on Conn XPress, Provisioning Manager or User Console?
14:13:32,414 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-94 (HornetQ-client-global-threads-800061613)) Execution of event: AccountUnlockEvent failed. Exception encountered: 'false' is not a valid value of enum Suspended
You may be best with opening a support case in order to share configurations/logs and work further with CA Support.
Hi Kenny, thanks for your response. I raised a case, as in parallel I am trying to find what can be missed.
I ask something more trivial. Suppose I have this conn xpress jdbc connector. I would like to map an attribute from the Global User to a boolean field on db table. On global user this should be 0/1, and in database is Y/N. Where can I establish this mapping, so when connector reads from DB it expects Y/N and converts it to 0/1, and the opposite way, when a true 1 / false 0 value is added to the global user, connector knows that it has to be put as Y/N on database?