How to Call AGS and DME Directly in Version 10

,

Not much has changed in this version of Lawson when it comes to AGS and DME. You can still use them directly whenever you doubt your security access or if you just want to get a sanity check. I have created this article to provide you a quick reference on how they should be run:

AGS:
To add a Nogalis Currency code:
https://<your server>/servlet/Router/Transaction/Erp?_PDL=TEST&_TKN=CU01.1&_EVT=ADD&_f1=A&_f2=NOG&_f3=Nogalis
To delete the Nogalis Currency code
https://<your server>/servlet/Router/Transaction/Erp?_PDL=TEST&_TKN=CU01.1&_EVT=CHG&_f1=D&_f2=NOG&_f3=Nogalis
DME:
To list all currency codes
https://<your server>/servlet/Router/Data/Erp?PROD=TEST&FILE=CUCODES
All of the above examples will need to be modified with your server name and your productline. In the above cases, the TEST productline was used.

Infor Acquires Merit Globe AS

Infor recently announced the acquisition of Merit Globe AS (Merit), a leading provider of consulting services for Infor M3 across Europe. Infor CEO Charles Phillips said the acquisition would help meet growing demand for Infor M3, which had accelerated growth over the last three years. Infor will also leverage best-practices and technology developed by Merit to deliver proactive services to customers, detecting and resolving issues before customers have experienced any business disruption. “Merit has grown to be one of the largest consulting firms dedicated to Infor products and regarded by our more than 500 customers for delivering unrivaled service,” said Erik Outzen, CEO of Merit Globe AS.

 

For Full Article, Click Here

How to Apply a Hotfix for MSCM

,

WFM Hot Fix – Deploy .ear file

To prepare for applying the Hot Fix

  1. Backup the appropriate databases
  2. Backup important application files (ex. lsfprod/law/system) app server:
    1. ssokeystore
    2. ssotruststore
    3. authen.dat
    4. install.cfg
    5. lsservice.properties
  3. Backup Ldap
    1. Get the instance name (ex. lsfprod-389)
    2. At the command prompt, browse to C:\
    3. Type: dsdbutil enter
    4. Type: active instance lsfprod-389 enter
    5. Type: ifm enter
    6. Type: create full D:/lsfprod/TEMP/ldapbackup/20160428

How to Apply a Hotfix for MSCM_1

APPLICATION DEPLOYMENT

  1. Logon as an administrator WEBLOGIC server.
  2. Backup your current directory where the application is deployed (ex. workbrain_20160502)
  3. Since you backed up the current Weblogic deployment directory, create a directory with the original name (ex. workbrain)
  4. Open a command prompt and browse to the directory where the application is deployed
    ex. cd $WB_HOME/deployments/production/workbrain
  5. Copy the EAR File to deployment directory (ex. $WB_HOME/deployments/production/workbrain
  6. Expand the EAR file in the deployment directory, using the jar tool:
    jar xvf workbrain.ear
  7. Delete the EAR File
    rm workbrain.ear
  8. Create a directory named war
    mkdir war
  9. Move the workbrain.war file into the war directory:
    mv workbrain.war war
  10. Select the war directory and expand the war file:
    cd war
    jar xvf workbrain.war
  11. Delete the war file:
    rm workbrain.war
  12. Edit the application.xml file found in the deployment_directory/workbrain/META-INF
  13. Change the line from:
    <web-uri>workbrain.war</web-uri>
    to:
    <web-uri>war</web-uri>
  14. For the process of deploying as non-root context, select the deployment_directory/workbrain/META-INF directory, edit the application.xml file, and modify for the application non-root context:

<module id=”WebModule_1066144042227″>
<web>
<web-uri>war</web-uri>
<context-root>/workbrain</context-root>
</web>
</module>
<module id=”WebModule_1066144042228″>
<web>
<web-uri>lib/axis.war</web-uri>
<context-root>/workbrain/axis</context-root>
</web>
</module>

NOTE: Make sure that you copy over any custom .jar files. Compare your previously deployed directories (the directory you backed up in step 5) to the new deployment for any custom .jar files.

  1. In the Administration Console, select Deployments in the left panel, and click Install in the right panel.The Install Application Assistant – Locate deployment to install and prepare for deployment page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_2
  2. Select the folder where the application was exploded.
  3. Click Next The Install Application Assistant – Choose targeting style page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_3
  4. Leave the default Install this deployment as an application option selected.
  5. Click Next. The Install Application Assistant – Select deployment targets page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_4
  6. Select the managed server.
  7. Click Next. The Install Application Assistant – Optional Settings page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_5
  8. Select Copy this application onto every target for me.
  9. Click Next. The Install Application Assistant – Review your choices and click Finish page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_6
  10. Leave the default Yes, take me to the deployment’s configuration screen option selected.
  11. Click Finish. The Install Application Assistant – Settings for My App page is displayed.
    How-to-Apply-a-Hotfix-for-MSCM_7
  12. Confirm that all settings are correct.
  13. Click Save.
  14. Click Activate Changes in the left panel.
  15. Click Deployment in the left panel.
    How-to-Apply-a-Hotfix-for-MSCM_8
  16. In the right panel, select the deployed application check box.

The Start Application Assistant page is displayed

How-to-Apply-a-Hotfix-for-MSCM_9

  1. Click Yes.Note:Before you start your deployment, make sure that your managed server is running (<domain_name>/Environment/Servers/<managed_server>/control).

Copy User Jobs/Reports to Another User

,

This scenario may be familiar for you if you’ve been living in the Lawson world.

Let’s say Sarah got promoted or transferred to a new position. The first thing we do is assign Sarah her new security access, but all the Lawson jobs/reports that she used to run no longer pertain to her new position. Rather, Sarah needs a new set of jobs to run and instead of creating them one by one from another user in her new department, we can simply copy them over from another user.

delusers

By the name of the command, you may think we are deleting users, but nope, there is a hidden gem inside.

First, lets login to LID and then type the delusers command and press enter

Copy User Jobs Reports to Another User_1

You’ll now see a list of your users >> Press F8

Copy User Jobs Reports to Another User_2

You’ll now be able to Copy reports and jobs:

Copy User Jobs Reports to Another User_3

Make sure you select “Yes” for Reports and/or Jobs.

Any existing jobs/reports that have the same name from the user you’re copying from will be prompted to rename the jobs/report before continuing.

Enjoy your new jobs/reports!

Infor Implementation Accelerators Can Help Customers Attain Value Realization

Infor announced significant momentum for the Infor Implementation Accelerator program – preconfigured solutions based on the latest version of Infor application suites that are designed to deliver certain core industry application processes for customers in specific industries. With more than 50 Implementation Accelerators licensed annually since 2013, there are now 26 types of Implementation Accelerators available to customers across more than 16 industries and product areas globally. Global Head of Infor Services, Darren Saumur, adds, “Implementation Accelerators are an integral part of our value proposition, particularly for the Infor CloudSuite™ product line, as these solutions are designed to empower our customers to help speed the time to value.”

 

For Full Article, Click Here

How to Implement SSL for Lawson Portal

,

image

If you haven’t already done so, implementing SSL after the install is a bit of a black art. Without going into gory detail, here’s a very simple set of steps to follow:

  1. On the LSF server turn off all the services related to lawson aside from ADLDS
  2. Import your new certificate (preferably a wildcard cert) into windows as a personal cert
  3. Create a binding within IIS using the imported certificate on port 443
  4. Load up  your favorite ldap editing tool. We prefer this one.
  5. Under O=lwsnrmdata -> OU=resources you’ll find all your users and services. You’ll want to edit the following identities (or more if you have other service URLs):
    • BPM
    • IOS
    • IOSAdmin
    • LSAdmin
    • mingle
    • mingle_env
    • SSO
    • SSOP
    • Environment
  6. In each of the cases above you’re going to modify the Service URL and any other http protocol. You’ll also want to change the PROTOASSERT attribute from “Use HTTP only” to “Use HTTPS always”.
  7. Then change every relevant entry in %LAWDIR%/system/install.cfg that refers to http, protoassert, or the secure ports. They’re relatively easy to find.
  8. You can now reboot the LSF server and restart your services.
  9. If you have Landmark installed, then bring up the rich client
  10. In the GEN productline, navigate to: “Security System management” > Services
  11. Change every service to HTTPS_ONLY and change the service properties to HTTP Port=-1 and HTTPS Port=443
  12. Change all the relevant entries in system/install.cfg
  13. Reboot the Landmark server
  14. Run all the smoke tests with updated URL to verify everything is working
  15. If you are using inbaskets you’ll want to import your certificates into Websphere as well but that’s a topic for another article

How to Resolve Infor Lawson 10 Session Timeout Errors

,

When you upgrade to Lawson version 10, you might notice some issues with session timeouts. The most common issue that I’ve seen is that the user will get 30+ blank popups. IF they have the patience to close each popup individually, they can eventually get back to the browser screen and close it. That’s the only way to start a new session. However, most users do NOT have the patience to click 30+ times, and they end up having to kill their browser session in Task Manager. Either way, it is no fun.

Here are some examples of the popups:

How to Resolve Infor Lawson 10 Session Timeout Errors_1

How to Resolve Infor Lawson 10 Session Timeout Errors_2

Luckily, with several encounters of this bothersome task, here is a solution on how to fix it:

Step 1: Make sure you are on the highest patch level of ios.jar and lawsec.jar for your version of Lawson.

  • You can find your current version in LID by typing in the commands “univver ios.jar” and “univver lawsec.jar”.
  • Then, you can check with Infor support to determine if you need to update, and they will direct you to the appropriate patches

Step 2: Copy the msgdlg.xml to the appropriate location

  • The system seems to generate all these popups in a panic because it can’t find the msgdlg.xml file where it is expected
  • Navigate to LAWDIR/persistdata/lawson/portal/data/msgs/en-us.
    • If the msgdlg.xml file is there, COPY it to WEBDIR/lawson/portal/data/msgs/en-us
    • If the msgdlg.xml file is not there, ask Infor to provide it for you
  • Once you copy the file over, upon session timeout you should receive ONE popup message. Once you click OK, you will be taken back to the logon screen where you can start a new session.

How to Resolve Infor Lawson 10 Session Timeout Errors_3

Next Generation of Infor Customer Relationship Management Now Available

Infor recently announced the next generation of Infor Customer Relationship Management (CRM), featuring an intuitive user interface with Infor SoHo styling for the updated mobile application. The latest Infor CRM version 8.3 delivers pre-configured back office integration with multiple Enterprise Resource Planning (ERP) systems via the Infor Intelligent Open Network (ION). Additionally, the new Infor Configure Price Quote (CPQ) integration will allow customers operating in the manufacturing and distribution industry to deliver one vision from order to delivery. Ultimately, with its new reconfigured layout, the smart design promotes user efficiency, greatly reducing the need for use training, and increases user confidence with its unified platform for social, mobile, and cloud.

 

For Full Article, Click Here

How to determine the version of your Lawson jar files

,

If you have every had to figure out what version of a certain Java executable you have you will appreciate this simple trick. Simply point your browser to this url:

Example:

This example displays the version of the ios.jar file as shown below.

How to determine the version of your Lawson jar files

In the above case the version of ios.jar file on the server is 9.0.1.11.521.
This information can be very helpful when working with Infor support to determine if patches are needed.

A More Efficient way to Update Report Data Sources

,

During an upgrade, re-pointing all your LBI reports to your new database may seem like a daunting task. Never fear! You don’t have to do it manually (at least not all of them). Here are the steps to overwrite your data sources using a SQL update query:

  1. Create an ODBC connection on your LBI server that connects to your NEW database server.
    1. Don’t forget that you have to use the 32-bit ODBC tool for LBI data sources!
  2. Create your new data source in LBI
    1. Tools > Reporting Services Report Administration > Server Administration > New Data Source A More Efficient way to Update Report Data Sources_2
  3. Open SQL Server Management Studio (or whatever database management tool you use)
  4. Log-in to your LBI database server
  5. Navigate to the LawsonRS databaseA More Efficient way to Update Report Data Sources_3
  6. BACK UP YOUR ERS_REPORTDATASOURCES TABLE! (You should always back up the table or the database if you are making changes directly)
  7. Run a query to view all the reports for which you plan to change the data source: A More Efficient way to Update Report Data Sources_4
  8. When you are ready, run your update query using the same WHERE clause that you used when you viewed your reports in step 7
    A More Efficient way to Update Report Data Sources_5

    1. NOTE: you are updating RSDATASOURCE. This is so that the report data source will be overridden.
    2. If you have a new username & password for this data source, you will also need to update the DEFAULTUSER and DEFAULTPASSWORD fields as well.
  9. Now your reports should run against the new data source. There are a few cases in which you will need to manually reset the data source in Crystal and republish the report. They are:
    1. If your report mixes schemas (i.e. it uses tables owned by dbo, and views owned by xyz)
    2. If your report has subreports
    3. If your report has a command that explicitly defines the database name (and the database name has changed)
    4. There may be more, but these are the instances that I discovered on a recent upgrade!