Archive for category: Frontpage Article

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!
   

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.

If you found this article helpful and need support managing your Infor Cloudsuite or Lawson Database processes, Nogalis provides expert managed services to simplify and optimize your system. From resolving issues like database user management to maintaining/optimizing existing processes, our team is equipped to deliver the assistance you need—without the cost and commitment of a full-time, in-house staff. Contact us to learn more about how we can help streamline your Lawson environment.

How do I change the version of java IPD is using?

First, go to your IPDesigner folder.

You should see the following .ini files in your folder:

Next, check your IPDesigner.ini file and change it there if needed.

Also be sure to check your IPDesigner_console.ini file and change it there if needed.

If any changes are made, run the following command in the command window:

• cd C:\IPDesigner\PROD>
• exe > debug.log 2>&1

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.

If you found this article helpful and are considering optimizing your Lawson Security and LBI systems, Nogalis offers expert consultant teams specializing in managed services at a fixed monthly rate. Catering to both large organizations requiring robust support and smaller entities seeking efficient management without full-time on-site staff, our services are tailored to fit diverse organizational needs. For further details, please reach out to us via our contact page.

You can clear workunit logs and activities for workunits with Completed or Canceled status to minimize the amount of data related to workunits that is stored on your system without deleting the important information, such as execution date/time and user actions, for a workunit.

You can delete logs and activities for workunits from the active Workunits list or from Workunit History.

• Archive workunits in history.

To hide completed workunits from workunit lists but not delete them and their associated data, you can move the workunits to history. Workunits retain all associated data for as long as they remain in history.

• Permanently delete all workunit data.

It is possible to permanently delete workunit data. If you have old data that you know you will never again need, deleting the data, which can become quite large, might be a good idea.

1. Access the Process Server Administrator and select Administration > Work Units > Work Units
2. Click Actions > Schedule Logs And Activities Deletion.

The Delete Logs and Activities dialog box is displayed.

1. Select one or more of the types of records you to delete from these options:

1. • Delete Work Unit Logs And Activity Logs: Delete all log data for workunits and activities.

1. • Delete Activities And Activity Variables: Delete activity records.

1. • Delete Work Unit Variables: Delete workunit variable information.

1. Select the records to process. The action processes only workunits with a status of Completed or Canceled. Specify a method for selection:

Work Unit Completion Date Range

To process workunits within a specific range, select a begin and end date.

Work Unit Completion Days Range Prior to Current Date

To process workunits within a range of completion days prior to current date, specify the number of days prior to the current date. For example, if the date is February 1 and you want to clear January data, specify 31 in Begin Days and 1 in End Days.

Work Unit Range

To process workunits by work unit number, select begin and end workunit numbers.

1. Click OK to run the action or click Schedule to schedule the action to run.