After a system outage, or maintenance, or reboot of LBI, you may encounter this “Error in validating session” error message when trying to navigate around LBI.  If you receive this message, the first step is to check the WebSphere systemout.log.  If you are seeing messages such as “Failed to obtain DB connection from data source” and “Could not retrieve datasource via JNDI url”, this could simply mean that the IBM services didn’t come up in the proper order.  The solution is to bring all the services down (order doesn’t matter), then bring them back up in the proper order, ensuring that each one is completely up before you move onto the next one.  That proper order is: Cell Manager, Node Manager, then Application Server.

[9/7/22 13:18:35:153 PDT] 0000009b ErrorLogger   E org.quartz.core.ErrorLogger schedulerError An error occured while marking executed job complete. job= ‘LBIAdmin.133’

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source ‘ejs’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/LawsonRS’ javax.naming.ConfigurationException: A JNDI operation on a “java:” name cannot be completed because the server runtime is not able to associate the operation’s thread with any J2EE application component.  This condition can occur when the JNDI client using the “java:” name is not executed on the thread of a server application request.  Make sure that a J2EE application does not execute JNDI operations on “java:” names within static code blocks or in threads created by that J2EE application.  Such code does not necessarily run on the thread of a server application request and therefore is not supported by JNDI operations on “java:” names. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/LawsonRS’ javax.naming.ConfigurationException: A JNDI operation on a “java:” name cannot be completed because the server runtime is not able to associate the operation’s thread with any J2EE application component.  This condition can occur when the JNDI client using the “java:” name is not executed on the thread of a server application request.  Make sure that a J2EE application does not execute JNDI operations on “java:” names within static code blocks or in threads created by that J2EE application.  Such code does not necessarily run on the thread of a server application request and therefore is not supported by JNDI operations on “java:” names.]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:575)

at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1320)

at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)

at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:392)

at org.quartz.core.JobRunShell.run(JobRunShell.java:276)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

* Nested Exception (Underlying Cause) —————

java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/LawsonRS’ javax.naming.ConfigurationException: A JNDI operation on a “java:” name cannot be completed because the server runtime is not able to associate the operation’s thread with any J2EE application component.  This condition can occur when the JNDI client using the “java:” name is not executed on the thread of a server application request.  Make sure that a J2EE application does not execute JNDI operations on “java:” names within static code blocks or in threads created by that J2EE application.  Such code does not necessarily run on the thread of a server application request and therefore is not supported by JNDI operations on “java:” names.

at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)

at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)

at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1320)

at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)

at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:392)

at org.quartz.core.JobRunShell.run(JobRunShell.java:276)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

 

The digital age has given the healthcare sector a boost in patient care, big data analysis, and technological innovations. In this modern world, it’s easy for people to find help with any medical concerns – whether it’s via hospital resources online, virtual appointments, or the traditional office visit. The healthcare sector itself on the business side has also found improved methods. Cloud computing especially is the technology to thank for the advancement of many aspects in the healthcare sector. A great article on startup.info takes a look at how cloud technology has and is continuing to revolutionize the healthcare sector.

Storage Without limits. “Unrestricted storage is one of the key advantages of cloud technology. Infinite storage brings forth two advantages: scalability and cost savings due to less use of physical storage space.”

Data Restoration. “A backup or data recovery plan should be present because data loss can occur anytime. The cloud is the best option because patient data stored there is protected from natural disasters and abrupt computer processing problems. The ability to store data anywhere at any time makes cloud storage more scalable.”

Improved Productivity. “All data entry and storage processes become quicker, more precise, and more organized when everything is in the cloud. Medical care centers conserve space while lowering the likelihood of human error.”

Numerous Studies & Insights. “Medical research has significantly improved as a result of cloud healthcare. With the help of cloud technology, it is easy to access a wealth of information, and medical personnel can speed up all appointment procedures and processes.”

Remote Cooperation and Medical Care.  “It is now simpler for medical experts to communicate worldwide and collaborate when needed. Retrieving patient medical history data has grown more effortless, and collaboration is now possible and reliable.”

 

For Full Article, Click Here

A common AS400 Database Maintenance Command – Finding and Fixing Dictionary Issues – is a quick task to complete. Follow these simple steps:

  1. Use the Verify Dictionary utility when you suspect dictionary mismatches such as missing objects or mismatched columns.
  2. Use the Build Data Definition Language utility to correct these issues or others, when you do not want to use the reorganization process.
  3. Use the Verify Dictionary (verifyibm) utility to check the two definitions.

If any problems are identified, you should use the Build Data Definition Language utility (bldibmddl) to modify an object (table or index) that needs rebuilding or modification. These utilities are used from a Lawson command prompt.

Methodist Hospitals recently selected Infor to achieve its goal of a clinically connected healthcare platform in the cloud. Per the press release, by automating key business processes, including its supply chain, HR and finance functions, and moving operations to a more modern cloud architecture solution, the community-based, not-for-profit health system will standardize and optimize across its health system to achieve strategic business goals and visions of providing the best possible care to the communities it serves. As long-time Infor customers, Methodist Hospitals chose again to partner with Infor for this project, knowing the tech giant will be able to consolidate information across the network and deliver financial data to decision makers that will improve budget management, cost reduction strategies and forecast accuracy. Additionally, they will be able to reduce reporting and custom interfaces, which will allow teams to be more productive and strategic and obtain valuable analytics without the use of consultants to build custom reports. Further, with a combined medical staff of more than 400 physicians, representing nearly 60 medical specialties, and more than 2,500 staff members, key applications for human capital management will empower teams to deliver streamlined processes and create significant value by eliminating complex processes, workflows and systems.

 

For Full Article, Click Here

Issued: November 16, 2022

 

Impacted Product

ALL Infor Lawson 10.0.X application customers, Infor Landmark version 11 and version 10 application customers, Infor Business Intelligence for Lawson 10.6 customers, and Mobile Supply Chain Management 11 customers deployed on-premises or managed by Infor (Infor Cloudsuite single tenant cloud customers do not need to take any action).

 

Vulnerability Summary

 

A security vulnerability due to ‘Dojo’ CVE-2021-23450 CVSS 9.8 has been identified by IBM® within the IBM WebSphere® Application Server Network Deployment (WAS ND) 8.5 used by the Infor Lawson 10.0.X applications and the Infor Landmark version 11 and version 10 applications deployed on-premises.

 

It is recommended for customers to take immediate action to mitigate this threat.

 

Background:

IBM has addressed this vulnerability. IBM interim fix (iFix) PH43148 resolves the problem.

IBM WebSphere Application Server is vulnerable to remote code execution due to Dojo (CVE-2021-23450 CVSS 9.8).

 

Action Steps:

Lawson and Landmark on-premises customers must install IBM interim fix PH43148.

ALL on-premises Lawson 10.0.X application customers and Landmark version 11 and version 10 application customers must apply the IBM WebSphere Application iFix patch as directed in the Infor Support Portal’s knowledge base (KB) article 2275124, title “IBM WebSphere Application Server Network Deployment – Remote Code Execution Vulnerability.”

Even though the likely trend for the enterprise resource planning (ERP) platform points towards the cloud, there are still some business leaders reluctant to migrate. Valid concerns such as data retention, security and other risks are usually the case for the indecisions. Despite these concerns, there are still so many benefits (some addressing the aforementioned concerns) for moving to the cloud. Darcy DeClute, Agile coach & Scrum Master at Scrumtuous Inc, shares an article on TechTarget of the top benefits of cloud computing, and why  your business should consider making the switch.

High availability. “A highly available system is one that experiences negligible downtime. Downtime is typically counted in seconds rather than minutes or hours, since cloud-based services rarely go down.”

Reliability. “Reliability describes how well a service performs the tasks it promises to do. It ensures highly available databases don’t randomly corrupt records or delete messages. Cloud providers routinely upgrade, update, patch and test their systems to make sure their services perform as promised. They further guarantee the reliability of their services in SLAs.”

Scalability. “In the cloud, you can scale your architecture in minutes and with the click of a button.”

Elasticity. “You can scale cloud-based services as needed. AWS provides a specialized Auto Scaling tool that helps companies dynamically rightsize EC2 instances, Aurora DB and NoSQL databases. An organization with a highly seasonal business, for example, could have millions of dollar’s worth of hardware and software sitting idle during slow months. That’s not a good allocation of capital.”

Agility. “One of the cloud computing benefits developers love is that it frees them from the time-consuming chore of managing infrastructure.”

Cost savings. “In the cloud, capacity planning is no longer guesswork. You simply scale up and down as needed. You don’t have to spend millions of dollars up front for software licenses or mainframe servers. And you’ll never run into the problem of having bought too much hardware.”

Global reach. “To reduce application latency, a data center should reside near its users. With cloud-based services, you can deploy applications into any region on the globe. You can also use edge locations around the world that have the power to cache data and further reduce application latency.”

Pre-certified compliance. “Pre-certified compliance is one of the biggest benefits cloud computing can bring to highly regulated industries. AWS, Azure, Google and IBM cloud-based infrastructure comes pre-certified in a multitude of fields.”

Enhanced security. “Some detractors suggest that moving data and applications to the cloud creates a security risk, but that is not the case. Take AWS, for example: All data that flows across the AWS global network is automatically encrypted. Most AWS services, such as S3, provide the option to encrypt all data at rest, so that if a data storage device is compromised, the information on it is indecipherable.”

Automation. “Every AWS, Azure, Google Cloud and IBM component comes with an API interface that makes it fully programmable. Developers can create, configure, query and destroy cloud-based resources with SDKs written in Java, Python, JavaScript and C++.”

Environmental sustainability. “You don’t generally think of AWS, Azure or Google Cloud as leaders in the fight against climate change, but there would be a positive impact on the environment if smaller companies moved their infrastructure into the cloud rather than running its own less-efficient data centers.”

 

For Full Article, Click Here

Infor recently announced that French-based Automotor, a market leader in the export of automotive parts, has chosen to deploy the Infor CloudSuite Distribution Enterprise ERP (enterprise resource planning) solution to cover all of its business needs in a single, centralized platform. Additionally, Automotor opted for the Authentic Distribution Solution (ADS), developed by Infor’s partner Authentic Group, to support the implementation and enrich it with high value-added services for the automotive distribution sector. Per the press release, the project to implement Infor’s solution, which is hosted by Amazon Web Services in the cloud, replaces a previously failed ERP project, which was, as Automotor’s management admits, poorly prepared. Infor technology partner Authentic Group will assist with the implementation. Further, Authentic Group suggested to Automotor’s teams that they opt for the Infor CloudSuite Distribution Enterprise solution, which is widely used among distribution professionals in France. Infor CloudSuite Distribution Enterprise is a multi-location, multi-company, multi-currency, multi-lingual solution that covers inventory and warehouse management, financial management, omnichannel order management, purchasing, services and more. Supporting 49 locations and 24 languages, the solution provides Automotor with the flexibility and scalability to easily enter new markets and adapt quickly to change.

 

For Full Article, Click Here

In AS400, it is convenient to know where all your data is distributed as well as how much disk space you have consumed and have leftover to use. If you want easy access to all this information at hand, all you need to do is run a simple command.

 

To get your AS400 Disk space usage, use the following command in your green screen command line:

 

Dspsyssts

 

On the right-hand top corner, you will see the sizes listed. You can run this command as often as you need to keep track of your disk space usage on a daily (or periodic) basis.

Infor recently announced a new a long-term strategic partnership agreement with the National Manufacturing Institute Scotland (NMIS). Per the press release, this investment will underpin the development of Model Digital Factory Demonstrators (MDFD) for the NMIS Digital Factory environment at the new NMIS 11,500-square-meter headquarters. Additionally, Infor will be funding dedicated MDFDs that will showcase end-to-end manufacturing use cases in the NMIS Digital Factory environment, which will integrate with the facility’s IT backbone and the digital and automation cells. This demonstrates how modern, advanced technology and solutions can help companies automate processes and transform workplaces. Further, Chris Dungey, research director at NMIS, says of the partnership with Infor, “I am delighted Infor has decided to join the National Manufacturing Institute Scotland’s community and is committed to working with us to transform manufacturing in Scotland and the wider UK.”

 

For Full Article, Click Here

Typically when you click on an LBI report that’s been setup on the dashboard, it will show you data of the last generated instance.  To add a refresh is incredibly easy.

 

First login to LBI and go to the dashboard you want to modify a report on. When you click it, you’ll see something like:

To allow the report to refresh data, select the plus sign >> Edit

You’ll see a URL field, all you need to do is add &Refresh=True to the end of the URL and click save.

The URL may look something like this:

FSRemote%3Ffsid%3DRS%3ARS-COMPANY%20Reporting%20Services%3A25%26

Now add %Refresh=True at the end of it like below:

FSRemote%3Ffsid%3DRS%3ARS-COMPANY%20Reporting%20Services%3A25%26&Refresh=True

 

Done! Now the report will always pull up the parameters (if any) so you can see the latest data:

If your organization still heavily relies on LBI today, which is harder and harder to find individuals who support it, we recommend organizations look into hiring a Lawson consultant team who offer managed services at a fixed monthly rate.

These Lawson teams have a wider range of expertise and knowledge and are ideal for larger organizations but also are great for smaller ones that don’t need a dedicated Lawson employee on-site that may only be an expert in 2-3 portions of Lawson.