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

, ,

How to Update the ADFS Token-Signing Certificate

, ,
Lawson SSO issue We are having an issue with ADFS SSO login with Lawson and I need someone to pull the updated metadata. ADFS auto creates a new ‘secondary’ decrypt and signing cert 20 days prior to expiration so on 8/31-ish It then…

Lawson Infor Process Automation XML Builder/Parser node with error – ‘X is not defined’

, ,
Summary of issue: When working on a Lawson IPA Flow issue, there was an IPA Webservice Node call that grabs XML data. This data was then fed into an IPA XML Builder/Parser node and begin to throw an “’X’ is not defined” error.   After…

Weekly Patch Notification: May 9, 2026

, ,

RDS Table Schema Impact on Query Performance

, ,
When working with large databases, performance is always top of mind. A common question that comes up is whether the number of columns in a table impacts query speed. For example, if you have two tables—one with 10 columns and 100 million…

Lawson PR37 error – user not authorized for batch

, ,
Summary: A user was trying to make a change on PR37.1 but received error: “User not authorized for batch. Contact Payroll”   On PR37.1, the user was trying to make a change: Received the error at the bottom left: “User…
© 2026 Nogalis, Inc. All rights reserved. | Nogalis™ and APIX™ are trademarks of Nogalis, Inc.