How to debug Lawson Business Intelligence (LBI) Report prompting Database Login

, ,

Learn how to debug Lawson Business Intelligence (LBI) Report prompting Database Login.

 

Here is an example issue when opening a report via LBI dashboard:

It prompts to a login screen and no credentials work:

To solve this, first validate the datasource of the report and validate its correct (it may resolve after you click save and test the report again)

If not, see if you can view the report with Data Refresh

If it generates data, you can grab this URL:

Edit your report from the dashboard, in this example we edit the “LP Exception Report”:

You can copy this URL:

You can either replace it complete with the top URL shown below with the HTTPS://yourorg.domain.com…. Etc.

OR

You can modify the link with just the tail end of it as shown below:

Then copy and paste this URL back in and save:

That’s it! Test it and the database login prompt should no longer show if you followed everything correctly.

If this is too complex for you and you need Lawson specialists to help manage your Lawson ERP system, Nogalis offers a team of consultants to help manage this for you under one MSP contract. Feel free to reach out to us to get a free consultation today.

IPA Process Notifications

, ,

There may be some cases where you want to notify your IT or other staff that an Infor Process Automation (IPA) flow has run successfully, or has run with errors overall, in addition to internal notifications for specific events.  Follow these steps to set up notifications on an IPA process.

  1. First, log into Process Administrator.
  2. Next, navigate to Configuration > Process Definitions > User Defined Process
  3. Open your Process.
  4. On the “Notify by Email” option, select your preferred option.
  5. Once you select an email notification type, the email notification tab will open up.
  6. You can use global parameters in the email details.

You are now set up to receive notifications!

Active or Disabled Users Reporting

, ,

What is the best way for me to get a list of active or disabled users within the Lawson environment?

 

Resolution:

To see all users who are “Active” or “Disabled”, run the “RM User Attribute report” within the LSA tool. Follow these steps below.

  1. Reports
  2. Report Maintenance
  3. Click New Report
  4. Choose the “RM User Attribute Report”
  5. Add a report a name
  6. OPTIONS:
    ACTIVE USER LISTING: Create a query for the Filter Criteria  where  IsDisabled isNot YES
    or
    DISABLED USER LISTING: Create a query with the filter criteria set to  IsDisabled is YES
  7. Hit next
  8. Choose the attributes about the user you want to see, such as First Name, Last name, etc… By default isDisabled is already checked and ID will automatically show up on the report as well. Click Ok to save the report.
  9. Run the report by highlighting the report and clicking the “Run Report” button at the top of the screen, choose your report format, html, pdf or csv.
  10. Use the Refresh button at the top of the screen and wait for the status of the report to show as “completed”. Once it’s complete, make sure the report name is highlighted then choose View Report. Put a check next to the report format and click View File.

 

How to resolve Lawson Error Unable to remove object delete failed

, ,

Follow these simple steps to know how to resolve the Lawson Error, “Unable to remove object delete failed”

 

You may come across the following: Unable to remove object (RQRequester), delete failed. Original Exception: Role RQRequester is in use on a resource or group and cannot be deleted. (Note: there are 3 screenshots below)

 

To resolve, you need to remove role from the user and try again. follow these visual guides for the role removal process: (Note: there are 2 screenshots below)

That should be it!

Mass remove candidates or suppliers and their identities from LSF

, ,

Candidates and suppliers from Landmark applications should not be synced to LSF. Services which allow users to register externally are services that should NOT be synced. If they were synced to LSF, follow the steps below to remove user and identity records from LSF.

Configure sync service lists to exclude candidates from sync – This process should be used if possible
Use Configure Services for Synchronization menu in ISS

Manual Sync service list configuration – This process may be used if not all services are shown in ISS
Export list of all services from LMK
 secadm -p <secadmpassword> service list
 The list outputs to the screen –copy the list from the screen into a text document
Determine which services from each system you DO want synced

Configure sync service lists for LSF and LMK in the LSF by adding the following lines to LAWDIR/system/lsservice.properties file:

 fed.LSFSERVERNAME.DOMAIN.COM;40000;40001;LSF. syncServiceList=YourListofLSFServicesToSync,SeparatedByCommas,NoSpaces fed.LMKSERVERNAME.DOMAIN.COM;10888;11888;LANDMARK. syncServiceList=YourListofLMKServicesToSync,SeparatedByCommas,NoSpaces

 Save changes and close lsservice.properties
Restart LSF and WAS

Configure tuning for sync*

  1. Add the following line to the LAWDIR/system/lsservice.properties

file: Nthread=5

This value can be any number between 2 and 10. You can tweak the Nthread parameter until you find the optimized setting for your system. Do not go above 10 unless directed by Infor.

  1. Adjust lase GRID node max heap to at least 3096

From the Grid Management main page go to Configuration Manager->Applications->Application->Landmark and the select the environment.
Select “Edit Properties.”
Under Grid Defined Properties -> Node Memory, select “Max Heap.”
Adjust the lase node memory to 3096 and then click Save
It may be set higher if number of users/identities indicates
-Restart the node for this environment or restart Landmark.

 

Change the Passwords in install.cfg

, ,

The passwords in install.cfg are encrypted in later versions of lawson.  If these passwords change, it would be ideal to also change them in install.cfg so the next update doesn’t run into any issue. To do this, follow the instructions below:

First, Open a command line utility with Lawosn env variables set.

Then type in the command java -cp %GENDIR%/java/thirdParty/installer.jar com.lawson.delivery.secure.PasswordAdministrator -s %LAWDIR%/system/install.cfg

Enter the Lawson configuration password

Next, View or edit passwords.  You can show them in clear text by clicking the “Yes” radio button.

Click finish when done

Restart Lawson services, or reboot the server. This should make the necessary changes and prevent any issues.

How to include Report ID in LBI Maintain Reports

, ,

Follow these simple steps to learn how to include Report ID in LBI Maintain Reports

  1. First, go into Tools when logged in as an admin and select “Reporting Services My Reports”.
  2. Under the “All” section in the Report Lists on the left side dash, click “Edit List” on the top right of the screen.

  3. Next, under “List Options” select “Columns”.
  4. Then select “Report Id” and click the right arrow in the middle of the screen:
  5. Click “Save and Exit” and then go to “Maintain Reports” in the Reporting Services Administration Report Management Menu.
  6. Now you’ll see all the Report ID’s on the right hand column:

 

That’s all there is to it!

GL256 No report in Print Manager

, ,

Problem:
If a GL256 was run but did not create a report in the Print Manager, but, there is a csv file, follow these simple and quick steps to change the csv output to a prt file.

 

Resolution:
First, you will need to create a GL55.1 for this report.

Navigate to the Basic Tab, then change the CSV Output parameter from Y (Yes) to N (No).

Next, Re-run the GL256 and it will produce a regular report in the Print Manager.

This should create a report in print manager with the proper output format.

That’s all there is to it!

Process Server Administrator – How to access Channel Administrator

, ,

File channels in Lawson Infor Process Automation (IPA) are very useful for picking up flat files and processing them.

 

In Infor’s older Rich Client tool, this can be easily found under the Start button drop down.

However, based on user permissions, this might not appear properly so I will tell you two ways to access the Channel Administrator.

 

First should be the obvious way which is Administrator >> Channel Administrator

 

However, based on your _ST roles, this might’ve not been granted properly. So, the second way to access it is in the top right search box. You can search Channel Administrator and access it there.