Solved

Error :Row(Person(xxx), was changed after it was selected. reselect and try again.

  • 18 November 2020
  • 9 replies
  • 342 views

Userlevel 4
Badge +8

Getting the error when updating the change password field for the person record.

Error :Row(Person, was changed after it was selected. reselect and try again.

Am able to update rest of the fields in the person record. So am not able to change the password for any person.

 

icon

Best answer by Lee Pinchbeck 18 November 2020, 15:36

View original

This topic has been closed for comments

9 replies

Userlevel 7
Badge +24

Hi @TatKhandM,

Can you please try adding metadata to the NACL field on PERSON to set force select to Y. You may then need to refresh cache, log out and then back in to reattempt.

Hope this helps,

Lee Pinchbeck

Userlevel 4
Badge +8

Hi Lee,

        Am not able to find the NACL field on PERSON. can you please provide more info to find the filed.

 

Userlevel 7
Badge +24

Hi @TatKhandM,

It is a hidden field so cannot be viewed on the screen but it will still allow you to add it on the metadata screen when you make an entry for the PERSON table.

Kind regards,

Lee Pinchbeck 

Userlevel 4
Badge +8

Hi Lee,

 Appreciate your support.

Can you explain the what is the use of NACL field?

 

Userlevel 4
Badge +8

Hi Lee,

      I found the NACL column in the metadata person but the ForceSelect field is disable . So how to enable it.

 

Userlevel 7
Badge +24

Hi @TatKhandM,

In the Custom Metadata screen you need to search for PERSON. If it already exists then great, if not you will need to create a new record for the PERSON table.

Once in PERSON you need a column entry for NACL. Again, if it selects thats great but if not just click new and enter NACL for the column. There is a tick box field for ‘force select’, make sure this is ticked and then save.

Then refresh cache, log out and log back in.

If you need further help with custom metadata then click the question mark in the top left of the screen when you are in custom metadata. This will take you to the user guide for the area.

Kind regards,

Lee Pinchbeck

Userlevel 4
Badge +8

Hi @TatKhandM,

In the Custom Metadata screen you need to search for PERSON. If it already exists then great, if not you will need to create a new record for the PERSON table.

Once in PERSON you need a column entry for NACL. Again, if it selects thats great but if not just click new and enter NACL for the column. There is a tick box field for ‘force select’, make sure this is ticked and then save.

Then refresh cache, log out and log back in.

If you need further help with custom metadata then click the question mark in the top left of the screen when you are in custom metadata. This will take you to the user guide for the area.

Kind regards,

Lee Pinchbeck

The issue is solved . Appreciate your support

Userlevel 4
Badge +8

Hi Lee,

Can you explain how adding metadata to the NACL field on PERSON to set force select to Y solving the issue. what is the use of NACL column ?

Userlevel 7
Badge +24

Hi @TatKhandM,

The NACL field is a system field that needs to be accessed when changing a password. Setting the force select ensure that FSM is given access by the database when it needs it to change the password preventing the issue of it being changed elsewhere whilst the change is made.

The metadata change to this field is one that is included as a bug fix in the latest version of FSM so an upgrade would also correct this issue.

Kind regards,

Lee Pinchbeck