Solving Amazon Athena error “Too Many Arguments”

, ,

AM190 Error: “Period or year-end close for company 1000 is in process”

, ,
This 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

, ,
If 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…

Weekly Patch Notification: August 1, 2026

, ,

How to Resolve Lawson PR140 Fatal Table error

, ,
Follow this simple guide to learn how to resolve the Lawson PR140 Fatal Table error – See errors files. A Lawson PR140 (Earnings and Deductions Calculation) fatal table error can mena many things like  the payroll job hit bad data, a lock…

Passing Parameters to a Thread Target in Python

, ,
When working with multithreading in Python, a common question is whether you can pass parameters to the function executed by a thread. The short answer is yes — Python’s threading. Thread class provides built-in support for this. This…

Weekly Patch Notification: July 25, 2026

, ,

Why os.getenv() Ignores Your .env File (and How to Fix It)

, ,
If you’ve ever logged an environment variable in Python and thought, “Why is this value coming from my system instead of my .env file?” — you’re not alone. This is a very common source of confusion when working with AWS credentials,…

Weekly Patch Notification: July 18, 2026

, ,

Changing the Portal Timeout Property

, ,
To change the TimeoutRedirectDisable property, you need to delete this using ssoconfig and re-add it with the correct value. this needs a restart to take effect.   Follow these steps to add the service properties on Infor Lawson Server: …