Archive for category: Articles

You are here: / / Articles

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!

Infor Automated Process Error – No Incoming Connection

, ,

If you just started working in IPA, some of the documentation is not straight forward and can often even be confusing at times.

The “No Incoming Connection” error is a simple fix for most nodes that do a query or write/read on a file.

 

Example of a No Incoming Connection error:

 

To resolve, select the connect tool and connect the Starting node with the end node to resolve the issue.

Done! These types of nodes should already come connected and if the developer needs to change them up that would be up to them. Good luck with the rest of the little quirks of IPA!

How to add a read-only SQL database user 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. You can simply add a read-only database user via Cloudsuite in the below steps.

 

  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 the Database Server, fill in the User, Password, Database name and for our example we are using the default database roles, for read-only, use db_datareader. See all default SQL database roles here and then click Submit!

 

Done!

NOTE: Some organizations have minimum password requirements. We recommend using a password generator online and keeping it to letters and numbers so users can type in relatively easy.