Infor Lawson cannot load because the Profile service returned an error: Error occurred while accessing user data

, ,

If one of your users in Lawson Portal or Mingle is receiving this error (or similar), a Lawson Security administrator will have to follow the steps below.

  1. Login to Lawson Administrator Tool
  2. Go to Use Management > User Maintenance
  3. Query the user who is having the issue.
  4. Right-click on their record and choose ‘Edit Lawson Environment Information’.
  5. Make sure the user has a data area set. Edit >> Change after changing.
    1. Alternatively, if the data area is already set, select Edit >> Change. Reminder, if you are using ISS, hit the save icon. (You do not need to actually add or change anything on this form/screen.) This creates the R_USER record in the GEN database.
  6. In Lawson portal (or mingle, selecting the globe icon), if you’re a portal admin, you should see an option to Clear IOS Cache.
  7. Have the user that was encountering the error close all of their web browsers Internet Explorer (IE), Chrome, Edge, etc and then open a new web browser session and log in again.

Note: LSF 9 ONLY – LAUA users: If the user has the attribute CheckLS=No, the user may also need an LAUA Security Class assigned to their Operating System account via LAUA.

 

Good luck!

Lawson Portal Error: You are not authorized to view this Page

, ,

This error occurs in Lawson portal version 9.0.1 right when the user logs into Lawson Portal.

 

This is a web server issue when users and group are not allowed access to the directory.

To resolve this error, verify that the <document root>\lawson\portal\admin\usersandgroup\usersandgroups.js file has the correct file permissions.

 

Note: This same issue should no longer occur in v10+

Lawson Mingle Portal error – You are not authorized to access this site

, ,

When logging in on Lawson Mingle (or portal direct), you may receive an error “You are not authorized to access this site” even though your user is all setup with the proper security in Lawson.

The highlighted error indicates that the user has been authenticated but is not authorized to access the application. This indicates that the issue is likely within Infor Federation Services for Infor Ming.le 11.1.x or Security Administration for Infor OS.

 

To resolve, a Lawson administrator with access to Infor Federated services will have to login to IFS.

Select Manage >> Users

Type in the domain\user and click filter

If the user does not come up, click the Add user button

Select your organizations domain (not bootstrap)

Type the users domain\user in the User Filter box and click Load

Select the user, click Apply then Ok

After the users been added, click save next to the add button:

The IFS system should be setup to sync automatically but an issue with auto-sync or possibly a connection to the IFS server may need to be addressed first.

You can click the manual sync and check if there are errors with the auto-sync:

Work with your network or windows team to resolve any connection issues to further resolve auto-sync.

 

Good luck!

How to Reset an SQL database user password via Infor Cloudsuite

, ,

With Infor Cloudsuite’s SQL Manage User Service, there is no need to setup any DBA permissions or to use database management software in order to see who has Database access and with what role.

 

  1. Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
  2. Select Deployment and Request Type: SQL Manage User >> Next
  3. Select Action “Change Password” and enter the User and New Password >> Submit
  4. Once the request completes, send the user their new password to access the database.

Done!

 

NOTE: Some organizations have a different password requirement and if the process fails you should check the post-load log to see if the password is too weak.

How to Reset a Lawson Portal users password via Infor Cloudsuite

, ,

With Infor Cloudsuite’s password reset service, it’s easier than ever for a Lawson Security Admin to reset a user’s password.

 

  1. Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
  2. Select Deployment and Request Type: Request Password Reset >> Next
  3. Type in the user ID (without the domain) and click Submit

That’s it! The user should get an email with instruction on how to reset their password.  Good luck!

How to preserve linked Lawson tables in Access when copying to different machines

, ,

Need an Access Lawson database to reside on the desktop of select users without having to relink all the tables each time?

If so, see the below query for the DSN-less connection with a function to relink all the tables and pass-through queries. This also just works for databases in general. Good luck!

 



How to generate an SQL database user report via Infor Cloudsuite

, ,

With Infor Cloudsuite’s SQL Users And Roles Report Service, there is no need to setup any DBA permissions or to use database management software in order to see who has Database access and with what role.

 

  1. Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
  2. Select Deployment and Request Type: SQL Users And Roles Report >> Next
  3. Select the Database Server and Database fields >> Submit
  4. This report can take anywhere from 5-15 minutes. Once complete, select the Request ID created and download the Users or Roles report for review.

And we’re done! Good luck!

Infor Cloudsuite Add Users Process Failed

, ,

You’ve created a template file to load a user into Lawson via Infor Cloudsuite but it failed.

  1. First let’s review the Request ID that failed by clicking on it.
  2. At the bottom you will see 2-3 links, one to download the Template file, and the others to download the AD or LSF log file (depending on the error). Let’s click the AD and LSF Logs to review.
  3. In this example, the AD log file was fine, but the LSF log file shows errors.
  4. In the log shown above, we have an invalid LBI Group. Review your template file (you can download it above AD log file) and make the correction to the template file. Load it again and see if the errors are resolved.

Good luck!