Client Support
cancel

Unable to customize user permissions for Position location type

SOLVED
Go to solution
Highlighted
catalonia
Respected Contributor.

Unable to customize user permissions for Position location type

Hi guys,

 

I am facing with this error message when trying to customize the user permission. Please help me out:

 

'User Access Type' can not be assigned the value of '7'. Valid options are 0-Administrator, 1-Records Manager, 2-Records Co-ordinator, 3-Knowledge Worker, 4-Contributor, 5-Inquiry User.

 

Steps to replicate:

1) Create an internal 'Position' location.

2) Set 'User Type' to 'Records Manager'.

3) Deseclect the 'Delete Records' and 'Reverse Final Declaration' permissions.

4) Save the location

 

then the above message is displayed. The issue appears in HP RM 8.1.1.7919

 

14 REPLIES
Greg Fraser_1
Micro Focus Expert

Re: Unable to customize user permissions for Position location type

I just gave this a try and it worked for me without receiving the error.

 

Do you have permissions to edit a location?

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
catalonia
Respected Contributor.

Re: Unable to customize user permissions for Position location type

Yes, I do.

 

Btw, I am trying to replicate the issue but i cannot.

 

It's weird.

catalonia
Respected Contributor.

Re: Unable to customize user permissions for Position location type

Hi guys,

 

I have investigated this a bit further and found it is only applicable to Locations that previously had their Profile permissions modified in HP TRIM 7.1.  After upgrading to 8.1.1 the profile looks like this:

 

 

As you can see the User Type is blank.

 

If I try to change it to anything (e.g. Inquiry User) I get the following message:

 

 

Any ideas?

 

Thanks in advanced.

 

 

 

Greg Fraser_1
Micro Focus Expert

Re: Unable to customize user permissions for Position location type

I am assuming from the title of the position that these locations were imported from TRIM \ dataport?

Did you give them a user type when they were imported? Leaving it blank might have resulted in this issue.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
Grundy
Acclaimed Contributor.
Solution

Re: Unable to customize user permissions for Position location type

I saw this same issue with a recent upgrade.

 

There's a bug in HPRM8.1.1 Patch 2 where any CUSTOM users from the previous version appear in the new system with a 'User Type' of 7 in the database.

 

This copmpletely breaks them in the interface and connot be changed.

 

However, you CAN change them directly via the database so that you can then work with them again in the client without error.

 

Step 1 - Get a list of all locations in the system with User Type 7 (Custom Users)

 

select lcName from TSLOCATION where URI IN (select luLocUri from TSLOCUSAGE where luUserType = 7)

 

 

Step 2 - Convert them all to a standard User Type (e.g. End User)

 

update TSLOCUSAGE set luUserType = 5 where luUserType = 7

 

Step 3 - Using the list of people/positions from Step 1, use the HPRM Client to edit the locations normally and set their user types and permissions manually as required.

 

 

NOTE!!! - TEST THIS IN A TEST ENVIRONMENT FIRST AND ENSURE YOU HAVE A BACKUP OF PRODUCTION BEFORE MAKING ANY CHANGES

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
Greg Fraser_1
Micro Focus Expert

Re: Unable to customize user permissions for Position location type

Nice one Grundy.

And that bit at the bottom of Jon's post is a must:

NOTE - TEST THIS IN A TEST ENVIRONMENT FIRST AND ENSURE YOU HAVE A BACKUP OF PRODUCTION BEFORE MAKING ANY CHANGES

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
catalonia
Respected Contributor.

Re: Unable to customize user permissions for Position location type

Hi Grundy,

Hi Greg,

 

Thank you very much for your instructions and advices.

 

I am going to give it a try then let all of you know the result.

 

Cheers,

catalonia
Respected Contributor.

Re: Unable to customize user permissions for Position location type

Hi guys,

 

I applied and it now works. Thank you very much again.

 

Do it need to be logged as a bug to be fixed?

 

Cheers,

Grundy
Acclaimed Contributor.

Re: Unable to customize user permissions for Position location type

Glad that worked!

 

I'm not sure if it's logged as a bug already. 
Greg can probably do that for us. ;)



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
Greg Fraser_1
Micro Focus Expert

Re: Unable to customize user permissions for Position location type

There is a knowledge article about the change to permissions: KM01590679

 

 

 

Did you perform a schema upgrade before the error message was received?

 

'User Access Type' cannot be assigned the value of '7'. Valid options are 0-Administrator, 1-Records Manager, 2-Records Co-ordinator, 3-Knowledge Worker, 4-Contributor, 5-Inquiry User.

If it is happening after then there might be a problem.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
Grundy
Acclaimed Contributor.

Re: Unable to customize user permissions for Position location type

Yeah. it happens after the schema upgrade.

It's 100% a bug.

 

Create custom users in something like 7.1, change a bunch of permissions, upgrade to 8.1.1 Patch 2, find the same users and their permission type will be blank, cant be changed and gives an error.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
Greg Fraser_1
Micro Focus Expert

Re: Unable to customize user permissions for Position location type

No worries, I'll write it up.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
catalonia
Respected Contributor.

Re: Unable to customize user permissions for Position location type

Hi Grundy,

 

Could you help me to replicate the issue?

 

I have tried many times but I could not.

 

I set up a fresh installation of HP TRIM 7.1.1.2017, created some positions, changed some of their permission, then upgraded to HPRM 8.1.1.7919.

 

After that, I found the same positions but their user type were not blank (before and after I ran a schema upgrade, it behaved the same).

 

What could i miss here?

 

Thanks in advanced.

Grundy
Acclaimed Contributor.

Re: Unable to customize user permissions for Position location type

Hi!

I havn't tried replicating like that before, I have just seen the issue in production databases I have upgraded.

 

Your test steps sound correct, so not sure why it didn't break again.

Have you also tried using the 'Use profile of' feature, selecting another person that is also customised?

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au