What to do if you are seeing this error on a SQL node in an IPA work unit:

java.sql.SQLException: Unable to get a SQL connection from the pool at com.lawson.bpm.processflow.pooling.SQLConnectionPool.borrow(SQLConnectionPool.java:79) at com.lawson.bpm.processflow.pooling.SQLConnectionPool.getPooledConnection(SQLConnectionPool.java:58) at com.lawson.bpm.processflow.workFlow.flowGraph.FgSQL.executeQuery(FgSQL.java:1107) at com.lawson.bpm.processflow.workFlow.flowGraph.FgaSQLQuery.startActivity(FgaSQLQuery.java:149) at com.lawson.bpm.processflow.workFlow.flowGraph.FgActivity.execute(FgActivity.java:947) at com.lawson.bpm.processflow.workFlow.flowGraph.FgProcess.run(FgProcess.java:2201) at com.lawson.bpm.eprocessserver.grid.ExecuteFlowImpl.executeFlow(ExecuteFlowImpl.java:427) at com.lawson.bpm.eprocessserver.grid.ExecuteFlowImpl.restartFlowForUA(ExecuteFlowImpl.java:181) at com.lawson.bpm.eprocessserver.ProcessFlowEngine.execute(ProcessFlowEngine.java:193) at com.lawson.bpm.eprocessserver.ProcessFlowEngine.reStartProcessAt(ProcessFlowEngine.java:116) at com.lawson.bpm.eprocessserver.KBConnectionDispatch.dispatch(KBConnectionDispatch.java:48) at com.lawson.bpm.eprocessserver.KBConnectionDispatch.run(KBConnectionDispatch.java:37) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744) Caused by: java.util.NoSuchElementException: Timeout waiting for idle object at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown Source) at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:181) at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:701) at com.lawson.bpm.processflow.pooling.SQLConnectionPool.borrow(SQLConnectionPool.java:68) … 14 more

 

To resolve this error, try setting your Maximum Core Pool Size, which determines how many work units can concurrently execute SQL nodes.  Best practices are to set this value to the number of work units that are allowed to concurrently run on your system.

To add this parameter, search for “Configuration Parameter” in Process Server Administration in the GEN data area.  Create the parameter if it doesn’t already exist.

 

Federal law generally requires organizations in regulated industries to have written data retention policies. For example, if an organization operates in a regulated industry where data must be retained for seven years, the company’s retention policy must specify and enforce the specified seven-year retention period. With established policies, organizations can comply with regulatory requirements that require the storage of various types of data. There are many operational advantages to implementing a data retention policy, and many companies have policies in place to ensure they do not violate local, state, and federal laws, as well as various industry regulations.

Both internal and external policies dictate the rules and regulations for data retention, and it is critical that organizations can manage a comprehensive data retention program that meets both requirements. As healthcare organizations create and manage large amounts of electronic data from a variety of sources, record keeping is becoming an increasingly important and complex aspect of information management. Compliance with HIPAA records retention requirements is critical for both medical file storage software developers and healthcare professionals. Given the wide range of varying federal and state health record retention and destruction requirements, it is imperative to follow best practices to ensure compliance with HIPAA and state standards.

HIPAA requires each provider and company that manages protected information to develop a policy for the retention and deletion of medical records. While the HIPAA Privacy Policy does not contain requirements for the retention of medical records, the HIPAA Privacy Policy does include requirements for how data is stored. Statewide, there is no HIPAA medical record retention requirement, and in many cases the state legislature determines the retention period, in which case HIPAA does not take precedence over state law.

State laws may also require medical records to be retained for a longer period than HIPAA retention standards and background data. Any state law that requires a stricter retention period for medical records than HIPAA requirements remains in effect and supersedes federal law. There is actually no HIPAA medical records retention period, which means there is no period of time that a healthcare provider must keep a patient’s medical records before those records can be deleted or destroyed.

Following the HIPAA medical records and record retention period, HIPAA requires the secure destruction of physical and electronic forms of PHI to prevent unauthorized disclosure of PHI. HIPAA record retention rules apply when an entity covered by HIPAA collects information related to medical services or payment for medical services.

Health insurance providers must comply not only with the HIPAA retention rules, but also with the Financial Industry Regulatory Authority (FINRA) rules. In addition to the HIPAA requirements, the healthcare industry is subject to data retention requirements set by the Centers for Medicare and Medicaid Services (CMS) and state laws.

Healthcare organizations are subject to the data retention requirements of the Health Insurance Portability and Accountability Act, and organizations that accept credit cards must adhere to the data retention and deletion policies of the Payment Card Industry Data Security Standard.

For example, for companies in the healthcare sector, one unique regulatory requirement is the Health Insurance Portability and Accountability Act (HIPAA), which governs medical data. There are requirements for how long HIPAA records must be kept while states regulate medical record storage requirements. Although the Health Insurance Portability and Accountability Act (HIPAA) does not contain universal health record retention requirements—instead, they vary from state to state—it does include specific HIPAA-related record retention language. Approved in 1996 to protect health insurance coverage for people who were off work, HIPAA is now known as the document that also guarantees health record retention policies, defines the parties and documents involved, and is the primary document that providers use when creating. internal physician retention policy.

Although HIPAA stipulates that medical records must be kept “for as long as necessary” and does not set time limits, what this means is that healthcare professionals must instead look at the statute of limitations applicable to their condition, as well as the rules required by any regulatory authorities. While record retention requirements are part of the broader HIPAA compliance policy, they should be considered first by your software solution or service provider. In addition to maintaining HIPAA records, insurance companies may be subject to the complexities of FINRA, while employers may need to comply with the record keeping requirements of the Employee Retirement Income Security Act and the Fair Labor Standards Act.

As stated earlier, HIPAA protections apply to many different types of PHI, including patient records, diagnostic images, prescription records, billing records, etc. and require retention of all protected health information for a period of six years from the date of publication, creation or the date of its last effective date, whichever is later. In the UK, the Health and Social Care Records Practice Code of Practice 2016 specifies that anyone working with or in the National Health Service (NHS) is required to keep medical records for 20 years after the last contact with a patient – 8 years after death or up to 25 years after the birth of the last child on maternity documents. Customer records, contracts, financial information, health data, third party data, employee records, spreadsheets, emails, and more are typically subject to data retention policies, regardless of sector.

Organizations should conduct a thorough audit of the data they hold, from patient and employee records to policies and procedure documentation. In many modern health care organizations, the ongoing maintenance of medical records is a discipline that requires specialized personnel and skills. Depending on the industry and business, several laws and regulations may affect data retention policies and may require overlapping or even conflicting requirements regarding how long certain types of data should be retained or what you need to do with it when it’s time to delete it.

If you’re migrating to a new system and need to properly archive your data, you should consider your options. One option is to keep your old system around for inquiry purposes only, though this can prove to be costly and complicated. Another option is to dump all your data into a data lake and worry about it all later, but this fails the most basic test for a data archive solution; accessibility. Luckily, there is a third solution.

The APIX serverless framework, based on the AWS serverless stack has opened up incredible possibilities for inquiry only applications never before possible without a substantial investment in infrastructure. Clients can now provision a web based, lightweight, data archive solution and migrate all their data within days rather than months and at a fraction of the cost of the other solutions with none of the risk. Find out how the APIX serverless framework can help you meet all your Lawson data archive needs and eliminate the legacy servers for good.

For API calls that return a large result set, you may encounter the message “Error while executing Web Service activity javax.xml.ws.soap.SOAPFaultException: reach the innerElementCountThreshold:50000”.  To resolve this issue, add a JVM command to allow a larger threshold.

 

Launch the Landmark Grid.  Click on the “configuration” icon.

 

Click “Applications”

Select your Landmark application

 

Click “Edit Properties”

 

Expand “Node Properties” under “Grid Defined Properties”

 

Click the link to Append another entry

 

Add the property “-Dorg.apache.cxf.stax.maxChildElements=<an appropriate # for your organization>”

Click “Update Property”

Be sure to save the Grid changes!!

Restart the server

 

If the IBM WebSphere Application Server deployment manager, node agent, or application server will not start, you can try clearing out the temporary directories and cached files.  Here are the steps to complete this procedure:

  1. Stop the deployment manager, node agent, and application server
  2. Back up the existing configurations
    1. Open a command line window as admin
    2. Navigate to PROFILE_ROOT\bin (i.e. D:\IBM\WebSphere\AppServer\profiles\profile1\bin)
    3. Run the command “backupConfig <backup file>”
    4. Repeat this backup step for every profile (Dmgr, AppSrv01, etc)
  3. Rename or archive the following directories
    1. PROFILE_ROOT/wstemp
    2. PROFILE_ROOT/temp
    3. PROFILE_ROOT/config/temp
    4. Repeat this step for every profile
    5. These folders will be recreated when the servers are restarted
  4. Delete the javasharedresources directory located at C:\Windows\System32\config\systemprofile\AppData\Local\javasharedresources
  5. Initialize the OSGI configuration and clear the OSGI cache
    1. Open a command line window as admin
    2. Navigate to PROFILE_ROOT/bin
    3. Run command “osgiCfgInit”
    4. Run command “clearClassCache”
    5. Repeat this step for every profile
  6. Start the deployment manager, node agent, and application servers

Prior to Landmark version 11.0.29, IPA had trouble recovering gracefully from a loss in data connection.  When IPA loses connection with the database, it can sometimes throw this exception in the Work Unit logs:

To recover from this issue, you will need to restart the LPA node in Landmark grid, or restart the Landmark server.  After that, upgrade Landmark to a more stable version at the earliest convenience.

 

 

 

 

 

The error “security.authen.os_account_not_configured” in Landmark will present itself when attempting to open Landmark web pages.  There will be a 500 service error, and the security_authen.log will throw an exception similar to “: SecurityEventHandler #34 got exception.

1617884962 – L(2) : security.authen.os_account_not_configured”.

In this case, the resolution is to open the Landmark command line utility as the install user, and run the command secadm provision os -C -o -a.

Security_authen.log

Sat Sep 25 12:29:59.250 PDT 2021 – default-1617884962 – L(2) : security.authen.os_account_not_configured

Sat Sep 25 12:29:59.250 PDT 2021 – default-1617884962 – L(2) : SecurityEventHandler #34 got exception.

1617884962 – L(2) : security.authen.os_account_not_configured

Stack Trace :

com.lawson.security.authen.SecurityAuthenException: 1617884962 – L(2) : security.authen.os_account_not_configured

at com.lawson.security.authen.LawsonOSAuthenticatorImpl.getPrimordialContext(LawsonOSAuthenticatorImpl.java:206)

at com.lawson.security.authen.LawsonOSAuthenticatorImpl.getPrimordialContext(LawsonOSAuthenticatorImpl.java:58)

at com.lawson.security.server.SecurityEventHandler.getSecurityContextForEvent(SecurityEventHandler.java:376)

at com.lawson.security.server.SecurityEventHandler.processEvent(SecurityEventHandler.java:350)

at com.lawson.security.server.SecurityEventHandler.run(SecurityEventHandler.java:228)

 

 

 

 

 

 

 

secadm provision os -C -o -a

 

 

 

 

 

 

In Lawson you may be creating a custom ESS form that you don’t want users to be able to get to (assuming you removed the search button).

 

Example of this below:

Open design studio by going to https://yourcompany.domain/lawson/studio

To remove these related forms, edit the custom form in design studio and remove transfers id in source:

Save the now custom form, make sure it is set to default in logan or is accessible via a bookmark direct URL.

 

Clear your IOS Cache and test to make sure the related button is now gone.

 

Good luck!