Landmark Grid shows Default Router is LIMITED

, ,

To get the error log, click on the notepad icon in LOG column

You find there is an error showing Address is already in use:

These errors are because two applications are using the same port 50000

 

To resolve this:

Run netstat to find out what other application is using that port.

Here we see it is PID 6152

Open task manager and find what process is using that PID and go to the description to find out what the application is.

You will need to get the other application to use a different port than 50000 and make sure it is open.

 

Setting up Drill Options in Infor Portal 10.1

, ,

The Drill options in Infor Portal 10.1 allow you to specify how many records will be displayed at one time in the drill explorer.  You can also select which features should open in a new window.  Under “Other Options”, select whether the default should be “Find” or “Filter”. “Filter” only displays relevant results, while “Find” moves the first relevant result to the top of the list of records. This can also be manually toggled in the search dialog. See below for screenshots of the drill options in the Portal 10.1 screen.

 

LSA  Audit Report

, ,

Audit Report shows changes to security in LSA that have been made through Lawson Security to the security setup of selected users (CONFIG option). Also, shows Instances where users have attempted access that has been denied (ACCESS option).

  1. From the Security Administrator main menu, select Reports > Report Maintenance.
  2. Select New Report
  3. Select Audit report

  4. Specify a name for the report. The name can be up to 30 characters.
  5. Select the Report Type, either CONFIG or ACCESS.
  6. Optional. Select start and end date ranges for the report. Click in the From Date and To Date fields and then choose a date from the calendar.

    If you do not select a date, all data that meets the criteria will be included in the report.

  7. Optional. Select Securable Objects to run the report against. If you do not select specific objects, all objects will be included.
    For example, to check access attempts for HR11.1 and AP20.1, type HR11.1 and then click Add. Then type AP20.1 and click Add. Objects that will appear in the report are listed in the second dialog box. You can click Remove to take an object out of the report.

    You must type the name of the object exactly as it appears in the Security Administrator Object Selector. If you specify a form name, such as HR11.1, use all uppercase letters. If you are typing an Environment executable name, such as, jobdef, use all lowercase. The report does not check for object names. If you type an incorrect name, the report will fail or will not locate any records.

  8. You are now ready to select users to run the report against. Click Select Users
  9. Perform a Basic or Advanced query as necessary to locate the users. Click Find Now when you have specified the query criteria
  10. When the list of users that meet the criteria appears, you can click to select a single entry or Ctrl-click to select multiple entries
  11. Click OK twice when you are finished selecting users.

You are now ready to run the report.

 

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.

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.

BN532 Employee benefit does not exist – error in Lawson

, ,

Problem: You get a print directory error when running the BN532 and staging the BNDEPBATCH file: “Employee benefit does not exist;”

 

This typically occurs when you’re testing BN531 and BN532 in report mode to make sure everything runs correctly. Both you BNBATCH and BNDEPBATCH file are ready to go and have been renamed (because BN531 and BN532 to this day still appear to only accept BNBATCH).

 

Resolution: While it’s easy to overlook, you must first run BN531 in UPDATE mode after running it in report mode to test. Once the BNBATCH employee data is loaded into the database, you must rename your BNDEPBATCH file to BNBATCH and run the BN532 in report mode to test it as well.

 

So, to recap simply:

  1. Stage BNBATCH file in %LAWDIR%\<productline>\work\BNBATCH\ folder
  2. Run BN531 in report mode, check for error
  3. Run BN531 in update mode if no errors from step 2.
  4. Stage BNDEPBATCH by renaming it to BNBATCH (backup BNBATCH employee file) %LAWDIR%\<productline>\work\BNBATCH\ folder
  5. Run BN532 in report mode, check for errors
  6. Run BN532 in update mode if no errors in step 5.

That’s it!

Which version of IPD should I run with my Landmark?

, ,

If you are wondering what version of Infor Process Designer (IPD) you should run with Landmark, follow this simple guide.

 

Your IPD install should be the same version as your Landmark version.

 

You can find your version of IPD to check if it is running the same version as Landmark.

 

To find your Landmark version go to Process Server Administrator

Administration>Work Units>Work Units

 

Open a work unit that has completed and go to the Information tab and look at the landmark version noted:

 

Other releases of IPD are not compatible if not the same version of Landmark.

 

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!

 

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.