Listing IPA Scheduled Processes

, ,

If you are like me, you find it frustrating that you can only see the scheduled IPA processes that you created.  As an administrator, this can make tracking down process triggers quite difficult.  It is also difficult to determine which process is triggered by which schedule in the front-end Rich Client.  I have created a query that can show all schedules, and which process is triggered by the schedule.  Feel  free to take this and make it useful to you!

 

ORACLE

SELECT NAME, SUBSTR(AAR.ACTIONPARAMETERS, INSTR(AAR.ACTIONPARAMETERS, ‘<field name=”FlowName” id=”FlowName”><![CDATA[‘)+46,

INSTR(AAR.ACTIONPARAMETERS, ‘]]>’, INSTR(AAR.ACTIONPARAMETERS, ‘<field name=”FlowName” id=”FlowName”><![CDATA[‘)) –

            (INSTR(AAR.ACTIONPARAMETERS, ‘<field name=”FlowName” id=”FlowName”><![CDATA[‘)+46)) FLOW,

SCHEDULEWEEKDAY,SCHEDULEHOUR,SCHEDULEMINUTE,TIMETOEXEC

from LMK_LAWSON.ASYNCACTIONREQUEST ASYNCACTIONREQUEST INNER JOIN

LMK_LAWSON.S$AAR AAR ON AAR.ASYNCACTIONREQUEST = ASYNCACTIONREQUEST.ASYNCACTIONREQUEST

WHERE “GROUP” = ‘pfi’

ORDER BY NAME

SQL SERVER

SELECT NAME, RIGHT(LEFT(AAR.ACTIONPARAMETERS, CHARINDEX(‘]]>’, AAR.ACTIONPARAMETERS, CHARINDEX(‘<field name=”FlowName” id=”FlowName”><![CDATA[‘, AAR.ACTIONPARAMETERS)+46)-1),

CHARINDEX(‘]]>’, AAR.ACTIONPARAMETERS, CHARINDEX(‘<field name=”FlowName” id=”FlowName”><![CDATA[‘, AAR.ACTIONPARAMETERS)+46) –

(CHARINDEX(‘<field name=”FlowName” id=”FlowName”><![CDATA[‘, AAR.ACTIONPARAMETERS)+49)),

SCHEDULEWEEKDAY,SCHEDULEHOUR,SCHEDULEMINUTE,TIMETOEXEC

from LMKPRODGEN.ASYNCACTIONREQUEST ASYNCACTIONREQUEST INNER JOIN

LMKPRODGEN.S$AAR AAR ON AAR.ASYNCACTIONREQUEST = ASYNCACTIONREQUEST.ASYNCACTIONREQUEST

WHERE “GROUP” = ‘pfi’

ORDER BY NAME

 

Nogalis would love to assist with all your IPA needs!  We have some great resources on hand who can provide managed services of your system, training, and project work.  Check out our managed services program today!

Saudi Diesel Embraces Cloud-based ERP to Support Equipment and Power Generation Market

Saudi Diesel Equipment Co. (SDEC), the Al Khobar, Saudi Arabia-based leader in diesel power generation, transportation and support equipment manufacturing, recently announced their decision to migrate its existing deployment of Infor M3 on-premises to Infor CloudSuite Equipment. This would enable them to improve and automate business processes raise efficiency, and boost its ability to innovate. Moving to the cloud is part of SDEC’s wider digital transformation project, Digi-Step, as the company scales its operations to support strong demand for equipment, machinery, and power generators across a range of sectors in Saudi Arabia. Per the press release, SDEC had been using an on-premises version of Infor M3 as its ERP (enterprise resource planning) solution for more than 12 years, but wanted to migrate to Infor CloudSuite Equipment powered by Amazon Web Services (AWS). The company will benefit from using Infor’s OS cloud operating platform while also consolidating its processes around a more comprehensive CloudSuite solution, which includes the Infor Birst business intelligence data analytics solution. Additionally, moving to the cloud and replacing various legacy systems from other vendors with Infor solutions allows SDEC to simplify, automate, and gain visibility of business processes including supply chain management, production, financial management, stock taking, and after-sales service. This, in turn, will transform the company’s ability to work efficiently and integrate with partners including original equipment manufacturers (OEMs) to deliver the specific solutions customers want. Further, the move to a multi-tenant cloud environment also will allow SDEC to benefit from integrating with other Infor products and continuous innovation from Infor, with software updates and upgrades taking place automatically as soon as Infor implements them, without the need to perform manual updates at set intervals.

 

For Full Article, Click Here

Creating custom IPA triggers using 4GL

, ,

With Infor Process Automation, there are several ways to trigger a Process.  This article will discuss how to trigger a custom process using 4GL.

First, create your Process.  Test it and upload it to the Process Server.

Next, in IPA Rich Client (or the LPA Admin tool), you must create a Service Definition (Process Server Administrator > Administration > Scheduling > By Service Definition) and attach a Process to it.  There, you will configure any variables that should be passed to the process.

Now, let’s create the trigger in the 4GL program.  This will be either a custom program your organization has created, or an existing Lawson form.

The first step is to initialize the WF SERVICE.

INITIALIZE WFAPI-INPUT

INITIALIZE WFAPI-OUTPUT

 

MOVE <serviceNameString> TO WFAPI-I-SERVICE

 

PERFORM 1000-WF-SERVICE

***Verify that the return code != 0 (anything other than 0 indicates error)

IF (WFAPI-O-RETURN-CODE NOT = ZEROS)

GO TO 600-END

Next, create the Work Unit

MOVE WFAPI-O-SERVICE TO WFAPI-I-SERVICE

MOVE <workTitleString> to WFAPI-I-WORK-TITLE

INITIALIZE WFAPI-OUTPUT

PERFORM 1000-WF-CREATE-SETUP

 

Now, populate your variables.  You can have an unlimited number of variables per Service Definition, but you must populate them in groups of 10 (i.e. perform the 1000-WF-ADD-VAR-SETUP for each group of 10)

INITIALIZE WFAPI-INPUT

 

MOVE WFAPI-O-WORKUNIT TO WFAPI-I-WORKUNIT

MOVE “company” TO WFAPI-I-VARIABLE-NAME (1)

MOVE HR11F1-EMP-COMPANY TO WFAPI-I-VARIABLE-VAL  (1)

MOVE “I” TO WFAPI-I-VARIABLE-TYPE (1)

 

MOVE “employee” TO WFAPI-I-VARIABLE-NAME (2)

MOVE HR11F1-EMP-EMPLOYEE TO WFAPI-I-VARIABLE-VAL  (2)

MOVE “I” TO WFAPI-I-VARIABLE-TYPE (2)

 

INITIALIZE WFAPI-OUTPUT

PERFORM 1000-WF-ADD-VAR-SETUP

 

Finally, release the Work Unit

INITIALIZE WFAPI-INPUT

MOVE WFAPI-O-WORKUNIT TO WFAPI-I-WORKUNIT

INITIALIZE WFAPI-OUTPUT

PERFORM 1000-WF-RELEASE-SETUP

 

Nogalis would love to assist with all your IPA needs!  We have some great resources on hand who can provide managed services of your system, training, and project work.  Check out our managed services program today!

4 Mind-Boggling Technology Advances In Store For 2023

Technological innovation continued to make its presence known in 2022 and the trend continues to move at an increasing pace coming into the new year. This year and in recent years impactful tech such as the Internet of  Things, 5G, and Augmented Reality (AR) paved the way. Chuck Brooks, Global Thought Leader in Cybersecurity and Emerging Tech, shares an article on Forbes of some mind-boggling technology advances we should look forward to in 2023.
  1. Artificial Intelligence (AI). “We are now on the cusp of AI emergence and AI is no longer just found in science fiction movies. AI systems seek to replicate human traits and computational capabilities in a machine, and surpass human limitations and speed. It is already happening. Artificial synapses that mimic the human brain will likely direct the next generation of computing. The components may differ, it may be analog or digital, and it may be based on transistors, chemicals, biological, photonics, or possibly quantum components.”
  2. Cognitive Computing Technologies. “Futurist Ray Kurzweil said that mankind will be able to “expand the scope of our intelligence a billion-fold” and that “the power of computing doubles, on average, every two years. Recent breakthroughs in physics, nanotechnologies, and have brought us into a cognitive computing reality that we could not have imagined a decade ago.”
  3. Robotics. “Robotics are often viewed as the face of emerging technology, especially with the growth of capabilities in humanoid type machines that captivate our attention. They have also been used for decades in automating manufacturing, farming, warehouse functions, hospitals, security, etc. for mostly routine programmable functions. Now aided by machine learning, machine vision, AI and advanced sensors, robotics has become transformative in many industry verticals.”
  4. Advanced Materials Science and 3-D Printing. “Applications for advanced materials are part of the new world of discovery enabled by AI, and advanced analytics. As with AI, it applies to the fusion of working in concert with other emerging technologies. New materials are now being developed that can be stronger, lighter, handle extreme environments, and often can function at a higher rate of efficiency. They include, (among other categories) electric materials, biological materials, composites, polymers, and nanotech.

The societal, scientific, and economic impact of these 4 technology areas will be harvested in the coming year and into the foreseeable future. I have just provided a glimpse of a few of their potential applications. It could be a very promising, likely disruptive, and probably a wild ride in the quest for actualizing new technologies of the Fourth Industrial Era.

 

For Full Article, Click Here

4 Ways Technology Can Support A Culture Of Innovation

Innovation is a key formula to maintaining success in today’s business landscape. One of the easiest way to bring about innovation to your company is utilizing technology and the many advancements its given to businesses of every sector. While a business leader may be hesitant to bring about technological change because they don’t quite fully understand the right technology to introduce to their companies, they can still lay a technological foundation to invite change. Many times, it’s about having the right minds and leaders on your team. Daragh Mahon, Forbes Technology Council Member and EVP and CIO of Werner Enterprises, shares an article describing how technology can support a culture of innovation for your business.

  1. Position IT as collaborators. “Because innovation and tech are so intertwined, your IT department will play a crucial role in driving your innovation culture. They will be the builders of departmental designs and solutions, so their expertise in providing recommendations will be vital.”
  2. Invest in diverse tech leadership. “Technology is the primary tool of the modern world, and leaders need to have a solid understanding of how it can best benefit their business.”
  3. Reassess and revise your tech. “Legacy technology has been a stumbling block for many organizations as they try to modernize. Many businesses opt for building intermediate solutions between old and new solutions as a quick workaround. However, long-term costs need to be considered as well. Time and labor spent creating solutions to integrate with older systems are resources taken away from any forward-looking innovation. Newer talent may not be versed in an older system’s framework or language, making them harder to maintain as time goes by.”
  4. Create an idea-testing process. “Developing a standardized process for creating, building and testing ideas—whether technical or not—is imperative for an innovative culture. You must set clear boundaries around time, budget, resources, testing and scalability.”

 

For Full Article, Click Here

Lawson CSV Read Error – Bad Field Data Format for Fld: 5 on Record Nbr 1

, ,

Common error with conversion upload file: “CSV Read Error: Bad Field Data Format for Fld: 5 on Record Nbr 1”.

 

This could happen for example when running say PR530 in Lawson.

 

There are a couple ways to resolve this issue:

 

Resolution #1:

Fix the headers of the file by removing spaces or bad characters that the program doesn’t like in the file you’re using for upload.

Also keep in mind that if there are problems with the header records, you will be able to see the exact errors in the examine log after you run the job (Job Scheduler > Completed Queue > click on completed job and then select ACTIONS from the menu and highlight Examine Log). This gives more detail as to the exact CSV Header Read errors.

 

Resolution #2:

For the job that’s throwing this error, in LID, go to jobdef and enter the username and jobname

Move down to the form field >> F6 >> C. CSV File Attributes (PR530 is the example below):

Turn off File Header and Xlt Header Names and save.

When you run the job again, it will ignore the headers and process the data so make sure the columns are correct. This has to be done per user that runs the job.

 

Good luck!

Snellman Chooses Infor Cloud ERP System

Infor recently announced that Snellman, the Finnish and Swedish ready-made food and meat processor, will implement their cloud-based enterprise resource planning (ERP) system built on Amazon Web Services (AWS) to support its future growth and new business development. Per the press release, Infor CloudSuite Food & Beverage will help simplify Snellman’s IT environment and improve the use of in-house resources. This new CloudSuite system includes automated version updates, secure maintenance and scalability of the cloud environment, as well as the ease and straightforward ability to add modular extensions as needed. Additionally, it was the industry-specific ERP system for the food industry and the advantages brought by a genuine multi-tenant cloud solution that helped Snellman chose to move from Infor M3 on-premises to the Infor cloud. Snellman will also use the Infor Factory Track functionality for logistics automation and the Infor Birst BI solution that comes with the Infor OS platform for presenting and analyzing operational data.

 

For Full Article, Click Here

What to do if Landmark is crashing with core dumps

, ,

Here are a few mitigation procedures to use when Landmark applications are crashing or performing very slowly and throwing core dumps on the server.

 

First, check the environment.properties file.  Validate that file is pointing to the correct version/location of Java.  Sometimes, Java is updated on the server, and the environment.properties file is not changed accordingly.  It’s not a guaranteed issue, but should be validated and resolved if found.

 

Secondly, make sure there is adequate heap space provided to the jvm.  Here are some examples for heavy processing:

 

com.lawson.was.nodeagent.jvm-init-mem=1024

com.lawson.was.nodeagent.jvm-max-mem=3072

com.lawson.was.dmgr.jvm-max-mem=4096

com.lawson.was.dmgr.jvm-init-mem=2048

com.lawson.was.<app Server>.jvm-init-mem=3072

com.lawson.was.<app server>.jvm-max-mem=12228

 

àThese values will be deployed every time a CU is applied, so you don’t have to keep updating them

 

Be sure to recycle the Landmark application server once these changes are made.

 

Note that clustering Landmark WebSphere would not do any good.  Landmark applications behave very differently from Lawson applications, and it would only waste resources to vertically scale.

 

Improving Leadership During Periods Of Digital Transformation

Digital transformation, when done in a smart, planned out way, can be the key to growth for your business and team morale. Giuliana Corbo, CEO of remote-first nearshore tech solutions company Nearsure and Forbes council member, shares an article on how to improve executive leadership during periods of digital transformation in your business. Corbo states that best leaders pursue customer and team transformation not simply for the sake of embracing new technology, but to improve the customer experience, the cohesion between teams and build a resilient business that can thrive in the long term. With her own experience at Nearsure, Corbo outlines key steps that can help ease the transition into this new style of leadership.

Invest in people. “Throughout my career, I’ve found that the most important element of success is your team. By carefully selecting employees based on their cultural fit and technical abilities, companies can consistently improve the quality of their digital transformation initiatives and improve cohesion between departments.

Remember that transformation is more than technology. “I know that the most successful changes occur when new technology is integrated into the company’s larger mission statement and long-term goals. This helps improve the quality of software and ensures that the transformation helps improve teamwork, enhance leadership and solidify company culture.”

Secure stakeholder involvement. “The best executives will not only include managers, engineers and customers in the brainstorming process—they’ll also solicit feedback from regular employees. This type of leadership helps regular employees feel like their voices are being heard and are vital for maintaining a strong business culture and succeeding in the remote work age.”

Corbo concludes that those executives interested in building off of outstanding technology and promoting a culture of innovation can assist their organizations in this mission by leading from the front. This means investing in people, thinking about technology and how it fits into the bigger picture, and involving all stakeholders in the planning process.

 

For Full Article, Click Here

10 mobile technology trends that defined 2022

The adoption of “mobile” anything is an increasing trend each year. This year is no exception as 2022 say more than 5.31 billion mobile users globally. With the rise of wearables and smart devices, the demand and availability of mobile applications is a norm in our everyday and professional lives. Back End News shares an article listing the top mobile technology trends that more or less defined the way we used our devices and ran our businesses.

  1. Artificial Intelligence
  2. Mobile Security
  3. Virtual Reality and Augmented Reality
  4. Mobile Apps for Small Businesses
  5. IoT (Internet of Things) apps
  6. 5G Network
  7. Rise of M-Commerce
  8. Wearable App Integration
  9. Development of Cross-Platform Apps
  10. Personalization

Mobile technology is here to stay, and it will get more and more advanced this year and the next.

 

For Full Article, Click Here