Document Express error 52 – Bad file name or number

, ,

You may be running Document Express with Lawson and Citrix Storefront and encountering this error. Before you jump to conclusions that this issue is related to Lawson or Citrix security, check these steps below.

 

The user is likely experiencing this error when trying to import invoices into Document express.

  1. Make sure that all application related access is set in MHC.
  2. Verify the user has Active Directory access to the import routine folder on the server where the invoices are loaded in from Lawson.
  3. Lastly, verify the user has access to the import routine directly from Windows folder explorer. This path can be found in the import routine itself in document express.
  4. Copy the import routine path, paste it into Windows folder explorer to verify access.

Conclusion: When the user imports the invoice in doc express, it downloads the file locally and opens it. Verify both channels are open for the user.

Certificate Error When Loading Rich Client

, ,

If you launch Rich Client and get a certificate error (particularly after a new Landmark install or update), here are the steps to update your IRC certificate.

Here is a sample error message that you might receive before you are even presented with a login screen:

You can resolve this issue either in the LPA web administration tool, or you can log into your IPA server as the lawson user, open a Landmark command window, and type the command “canvas64 gen”.  These tasks are performed in the GEN data area.

In the search box, type “IRC” and select “IRC Trusted Certificates”

Go to Actions > Create

Add the certificate by file.  Browse to a previously exported certificate (Base 64 cer format) and click the save button.  The certificate details will be displayed if the certificate is valid.

Database File Space Issues That Manifest in IPA Errors

, ,

We recently noticed some strange behavior in IPA. All of our work units were stuck in “Ready” status, and the few Work Units that actually had errors indicated a java heap space issue. Some of the work units weren’t showing that a log was being created. We were also getting a generic error when uploading IPA processes.

It did seem like there was some kind of space or memory error. A reboot of the server didn’t address the issue. We were investigating and just happened to look at the command line window that opens up with IP Designer. That was the only place where saw a useful error message. It indicated that the database file had run out of space.

The resolution was to increase the “Maxsize” property on the IPA database file. In SQL Server, this is in the Database properties, Files tab.

Infor Support Ending for Internet Explorer

, ,

As of October 31, 2020, Infor is no longer going to support Internet Explorer as a browser for accessing Lawson applications. According to Microsoft, the end of life for IE will coincide with the end of life for Windows 10, so this is not a notice for the end of life for IE. This just means that any future Infor patches will not be developed to function with Internet Explorer.

 

Lawson has been stable in Chrome since the later releases of version 9. It is also supported on Microsoft Edge Chromium and Firefox. There are some things you will want to consider before moving to a different browser:

Impacted Applications

  • Infor Lawson System Foundation (LSF) 10.0.X.0 release
  • Infor Landmark Technology Runtime 10.1.1.X and 11 releases
  • Lawson for Infor Ming.le 10.0.X.0 and 10.1.X releases
  • Infor Lawson for Ming.le Content Lawson applications 10.0.X release
  • Infor Lawson Requisition Center 10.0.X.0 release
  • Infor Lawson Smart Reconciliation 10.0.X.0 release
  • Infor Lawson Procurement Card Self-Service 10.0.X.0 release
  • Infor Employee and Manager Self-Service 10.0.X.0 release
  • Infor Lawson Contextual Applications 10.0.X.0 release
  • Infor Lawson Mobile Supply Chain Management (MSCM) 11.X release
  • Infor Lawson Point of Use (POU) 11.X release
  • Infor Lawson Business Intelligence (LBI) 10.X.0.0 release
  • Infor Business Intelligence for Lawson (IBI) 10.X.0.0 release
  • All Infor Human Capital Management (HCM) products, including Infor Global Human Resources (GHR) and Infor Talent Management 10.1, 10.2 and 11 releases.
  • Infor CloudSuite Financials & Supply Management (CSF) 11 release

Design Studio

  • Design Studio 10 (the application) is going to continue to be supported in Internet Explorer
  • Design Studio forms might need some updates to make them compatible with a different browser. Design Studio relies heavily on JavaScript, and some of the syntax is browser-dependent.  Make sure you test all of your design studio forms before having users switch browsers.

MSCM

  • MSCM 10 is not compatible with Chrome. Infor will continue to support Internet Explorer with MSCM 10 installations until the end-of-life for MSCM 10.X.
  • MSCM 11.X (base, POU, and SIM) is compatible with Chrome, and it is recommended that you get to v11 as soon as possible! Contact us if you need help upgrading.

Recommendations

  • Switching browsers should be pretty seamless. Just have your users spend a week performing their daily tasks in your organization’s chosen browser, and log any issues that arise.  If they hit a wall, they can always move to IE until a workaround is provided.
  • Upgrade MSCM! If you own licensing for MSCM, the update should already be available to you.

 

As always, check the Infor Lawson compatibility matrix to get the latest information in application compatibility.

Securing a website using IIS

, ,

If your organization has custom websites that need to be secured quickly and easily, you can use the IIS internal authentication and authorization rules.

First make sure that your host server is set up to utilize Windows Authentication.  In Roles and Features  > Server Roles > Web Server (IIS) > Security, install “Windows Authentication”.

Once Windows Authentication is installed, select your site in IIS and select “Authentication”

Set Windows Authentication to enabled

Go back to your website, and select “Authorization Rules”

From here, you can give access to individual users or Active Directory groups.  The users will be presented with a Microsoft credentials dialog, and they will log in with their Windows credentials.

 

 

 

Backing up the AD FS internal databases on Microsoft Server 2012

, ,

If AD FS is configured to use the Windows Internal Database (WID) server, there are a couple of ways to maintain the databases created in the install.  They can be maintained using command-line sql or SQL Server Management Studio.  The AD FS configuration databases are called AdfsArtifactStore and AdfsConfiguration.

Not that both of these methods need to be performed on the server where AD FS is configured.

 

Command-line SQL

Log into the AD FS server using the service account under which AD FS was configured.

To prepare the server to run SQLCMD.exe, you will need to install the Native Client, ODBC Driver 11 for SQL Server, and the Command Line Utilities for SQL Server 2012.  These can be downloaded from Microsoft’s website.

Once these utilities are installed, create two “.sql” files using a text editor, one for the artifact database and one for the configuration database.  The following text should be placed in the sql file (update with the appropriate names and file paths).  The database names are AdfsArtifactStore and AdfsConfiguration.

BACKUP DATABASE [database name] TO DISK = “backup-path/backup-file.BAK” WITH NOFORMAT, INIT, NAME = “Artifact – Full Database Backup”, SKIP, NOREWIND, NOUNLOAD,STATS = 10

GO

Next, run the sqlcmd to execute a SQL script (provide the name of the script you created in the step above).

sqlcmd.exe -S \\.\pipe\MICROSOFT##WID\tsql\query -i sql-script-path\sql-script-filename.sql

 

SQL Server Management Studio

The WID server can also be accessed using SQL Server Management Studio (SSMS).  Note that SSMS must be installed on the server where AD FS is configured in order to be able to connect.

Log into the AD FS server using the service account under which AD FS was configured.  Run SSMS as administrator.  Connect to the server \\.\pipe\MICROSOFT##WID\tsql\query, and use Windows Authentication to connect.

The AD FS configuration databases are AdfsArtifactStore and AdfsConfiguration.  As long as you logged into SSMS as administrator, you should have admin rights on these databases to perform backups, run queries, etc.

 

How to verify Lawson user AD identity through Windows powershell

, ,

A user in Lawson is unable to login to their account. Username or password is incorrect. Assuming your organization is using single sign-on through Active Directory, you can verify the user’s username via Windows powershell.

  1. Login into Lawson Security Administrator (or SCWeb Admin App). Locate the user and copy the username.
  2. Open powershell and check the user via this command: Get-ADuser -identity <username>
  3. If you receive this error: “Cannot find an object with identity”, the user is not setup in AD under that username.
  4. Check with the organizations IT team to verify the correct AD user (assuming you don’t have direct access).
  5. Once they send you that ID, check via powershell again and it should return this result:

How to fix bookmark add error in Lawson portal

, ,

If you’re trying to add new bookmarks in Lawson portal and receiving an add error, there might be an issue with your bookmark xml files.

To resolve this, follow the steps below:

  • Login into Lawson portal as an admin and run Rebuild Custom Form Index
  • Verify lo12.1.addchild.xml, lo12.1.addtop.xml, lo12.1.edit.xml are in the LAWDIR/persistdata/lawson/portal/content/forms directory
  • In portal go to Set Custom Forms Data Area
  • Click Find ‘lo’ to show data forms (switch “current data area” if they don’t show).
  • In the new data area select LOGAN and click Update. Run IOSCacheRefresh.

Done!

How to delete a recurring Journal Entry in Lawson

, ,

Though this is a fairly simple task, it typically requires higher access (sometimes temporary access as some organizations only want users deleting journal entries once or twice a month).

  1. Login to Lawson portal and go to GL70.1
  2. Enter the company and journal entry number, hit Inquire.
  3. Click the “New Entry” button
  4. This will take you to GL70.2 and contain the same company/entry number (if not, enter again and hit inquire).
  5. After inquiring again, hit Delete and confirm the journal entry has been deleted.

 

And you’re done!

APMONITOR not found or accessible

, ,

You may need to access APMONITOR for a failed job etc. Its usually as simple as searching APMONITOR in Lawson Portal. Often times its not setup in Lawson security and needs to be added.

  1. In Lawson security, go to the class you want to add APMONITOR to.
  2. Add a new rule and go under Online system code AP and search for token QAPM, grant all access.
  3. Clear server cache and log back into Lawson, search APMONITOR and your user should now be able to access it.

NOTE: As of March 2016, patch (CTP104021, JT-751224) has changed the token for APMONITOR to AP94.