A Guide to Managing Infor Year-End Updates for AP and Payroll

, ,
This article will give you all the information you need to know about the Infor Year End Regulatory Patching that will be released by the end of the year.   Why Year-End Updates Matter As you probably know the YE regulatory patches …

Amazon Athena SQL Syntax Quirks

, ,
When working with Amazon Athena, SQL syntax quirks can sometimes trip up even seasoned database professionals. In this post, we’ll look at several syntax patterns that come up often when building queries in Athena. Common Table Expressions…

Weekly Patch Notification: June 6, 2026

, ,

Flexform Broke after adding Memory to Lawson Server

, ,
After updating the memory on the application server the flexform application started having issues with printing. The Memory increase was reverted and decreased it to what it was(16g). At that point, admin was not able to get the Lawson service…

Using the “LIMIT” Keyword in Athena Queries

, ,
When working with Amazon Athena, a common stumbling block is using LIMIT inside a subquery. Unlike many other SQL engines, Athena does not support LIMIT in scalar subqueries (those that return just one value). If you try to use it, you’ll…

Weekly Patch Notification: May 23, 2026

, ,

How to add a user into Lawson Business Intelligence

, ,
Lawson makes it incredibly simple to add users to its reporting wing LBI.   First what you want to do is add the LBIUser GROUP to the user in LSA: This group may be spelled differently but typically it's called LBIUSER and…

Setting up Drill options

, ,
You can specify the number of records to display at one time. From the Navigation menu, select General > User Options. Click the Drill tab and select values for these fields: Option Description Number of…

Weekly Patch Notification: May 16, 2026

, ,