
How to Recover Lost Files in Git After Committing to the Wrong Branch
Articles, Frontpage Article, NewsIf you’ve ever accidentally committed changes to the wrong Git branch, you know how stressful it can be — especially if you stash your work or switch branches afterward. Fortunately, Git keeps a detailed history that makes it possible to…

Requisition Center (RQC) error, “Error 23 – Product line PROD is secure.”
Articles, Frontpage Article, NewsProblem Description:
User’s using shopping in Requisition Center (RQC) and getting the error, “Error 23 - Product line PROD is secure.”
Resolution:
These errors can be due to the user not having a GEN user record…

Securing ODBC Access to Amazon Athena Without Making It Painful for Users
Articles, Frontpage Article, NewsAmazon Athena is a popular choice for analytics because it allows you to query data directly in Amazon S3 using standard SQL. As more organizations want to enable self-service analytics, a common request is to provide ODBC access to Athena so…

Error for Environment identity
Articles, Frontpage Article, NewsLawson Portal fails to load with the error:
“Profile service returned an error: Error occurred while accessing user data.”
The root cause is the affected user does not have a record in the GEN/USER table.
This is most caused by a corrupted…

Fixing the InvalidLocationConstraint Error When Creating S3 Buckets with Boto3
Articles, Frontpage Article, NewsIf you’ve ever tried to create an Amazon S3 bucket using Boto3 and run into the following error, you’re not alone:
botocore.exceptions.ClientError: An error occurred (InvalidLocationConstraint)
when calling the CreateBucket operation:…

How to setup Lawson email notifications when a file channel errors out
Articles, Frontpage Article, NewsFollow the steps and visual guide below to learn how to setup Lawson email notifications when a file channel errors out.
In Infor Process Server Administrator, under the administration tab, select Channels Administrator.
Next,…
https://www.nogalis.com/wp-content/uploads/2026/08/Solving-the-TOO_MANY_ARGUMENTS-Error-with-concat-in-Amazon-Athena.jpg
470
470
Angeli Menta
https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png
Angeli Menta2026-08-13 08:01:082026-08-12 13:05:23Solving Amazon Athena error “Too Many Arguments”
AM190 Error: “Period or year-end close for company 1000 is in process”
Articles, Frontpage Article, NewsThis error occurs when the AM190 process is incorrectly marked as still running for company 1000.
In this scenario, the AM190 job was deleted from Needs Recovery, but the system status was not fully cleared. As a result, the AMCONTROL table…

Understanding and Setting group_concat_max_len in MySQL
Articles, Frontpage Article, NewsIf you’ve ever used MySQL’s GROUP_CONCAT() function and found that your results were mysteriously cut off, you’ve likely run into the group_concat_max_len setting. This system variable controls how much data MySQL is allowed to return…

