Posts

IP Designer Series – Landmark Transaction

Use the Landmark Transaction node to query or update Landmark data.  In the properties window, select “Build” and you will be presented with a wizard to help you build your Landmark query.

Select the data area that you are querying/updating.  Select the Module and Object Name.  (HINT: these values can be found by using Ctrl+Shift+Click on the form in Rich Client or the Landmark Web UI).

Choose your action.  There are basic CRUD (create, read, update, delete) actions for each object, and there will be more actions specific to the object you selected.  Action Operator will likely be “NONE”.  Select your action type (SingleRecordQuery, MultipleRecordQuery, etc.), and finally select the criteria.  Click OK.

Decide whether to use the hardcoded values for your transaction field values.  You can supply variables here to make your flow more portable.

 

 

 

Security violation for activity group on Activities batch jobs

Security on activity groups is handled outside of LSA.  If users are getting a “security violation for activity group” when they try to add a batch job in the activities module, you will need to do a little extra security maintenance.

First, go to AC00 and make note of the value in the “Security” field.

Next, open the user’s security record in ISS or LSA and navigate to the “Company Control” field.  Click on the search and make sure that “Security” value is in the user’s company list.  If not, add it.  Then clear out the security cach and perform an IOSCacheRefresh.

SSO Error Due to Expired WebSphere Cert

Recently we ran into the dreaded “Unable to load” error message in Portal, and could not find any indication of why Portal couldn’t load.  The most we could see through a Fiddler trace is that the sso.js file was getting a 500 error.  There was nothing logged anywhere.  Not on the WebSphere node, application server, nothing in ios, security, event viewer.  Nothing!  We figured WebSphere had to be the culprit, because sso.js is wrapped up in an ear file in WAS_HOME, and everything on the Portal side was working until it tried to hit that script.  So, we started digging into WebSphere and figured out that one of the certs was expired on the Node.  For some reason, a custom wildcard cert had been used for the WebSphere install on the node only.  We opted to switch it to use the default self-signed cert, which was not expired, and was the solution that worked best for us.  Another option would, of course, be to upload a new wildcard cert and switch the old one to the new one.

To switch a cert in WebSphere, go to Security > SSL certificate and key management > Key stores and certificates.  Select the NodeDefaultKeyStore of the node you want to change, and under additional properties on the right, select “Personal certificates”.  Click your “old” cert and select “Replace”.  Select the “new” certificate that is replacing the old one.  Check the “Delete old Certificate after replacement” box.

Bounce WebSphere services, or better yet, reboot.  And you should be good to go!

 

 

 

IP Designer Series – Landmark Admin Node

The Landmark Admin Node can be used to run command line utilities on the Landmark Server.  In the node properties, select the command you wish to run.  Then click Build and provide the parameters to be used in your command.

 

How to Stop an IPA Schedule

There are a couple of different ways to disable an IPA schedule to stop it from running.  One way is to disable the process itself.  To do that, open User Defined Processes (Start > Process Server Administrator > Configuration > Process Definitions > User Defined Processes).  Select the process being disabled and clear the “Is Process Enabled” flag.  It is important to note that this method will cause the schedule to go into an error mode, and will have to be cleared and requeued when you are ready to start the schedule back up.

The other way is to set the Latest Time to Run on the schedule.  I like to set it to some date in the past (like yesterday) to make absolutely sure the schedule won’t run again.  When you click Save, the next time to run dates will clear.  To start the schedule back up again, simply clear out the Latest Time To Run and save the schedule.

View IPA Schedules in Async Administrator

To view/edit your own schedules, log into Rich Client and navigate to Start > My Actions.

To view/edit ALL schedules, log into Rich Client and navigate to Start > Applications > Async Framework Components > Requests.  From there, you will be presented with a list of all Async Action Requests.  The IPA process schedules are under module “pfi”.

 

 

 

Triggering an IPA Process Manually

To trigger a process manually, you first have to set up a trigger.  From Rich Client, navigate to Start > Process Server Administrator > Scheduling > By Process Definition.  Click Actions > Create to create a new trigger.  For Process Name, select the IPA process that you want to run.  Enter a descriptive Work Title (the trigger will fail if it doesn’t have a Work Title).  Click Save.  Then, click Actions > Start.  Check the Work Unit log to see that your process has run!  If you want to delete your trigger, you will first need to delete the work units associated with it.

Activating Landmark Time Zones in Configuration Console

To activate the time zones available in your Landmark applications, from the GEN data area, go to Start > Configure > Application.  Under “Data Area” in the left panel, select “Time Zones”.  Find the Time Zone(s) that you want to activate, and double-click to edit.  Set the “In Use” flag.  Now that Time Zone will be available to select in your Landmark applications.

Landmark Application Configuration Overview

The Landmark Configuration Console allows you to effect system-wide changes with no downtime for your users.  You can personalize your Landmark applications in a multitude of ways:

  • Add custom fields
  • Move fields or remove them from forms
  • Set fields to required
  • Modify list columns (add/remove/rearrange)
  • Create new
    • User interfaces (pages, lists, etc)
    • Business classes (data, objects, etc)
  • Security
    • Use the Security Configuration tool to modify security classes, rules, and roles
  • Web Services
    • External systems communication with Landmark business classes using SOAP, HTTP, WSDL, or REST

The Infor-delivered role what will allow users to access Configuration Console is GlobalUIConfigAccess_ST.  The role that will allow users to access Security Configuration is SecurityConfigAccess_ST.

Use IPA FTP Node to Transfer Multiple Files

When you are using IPA to transfer files, there may be some cases where you need to pick up multiple files, or where you need to get files for which you only know a partial name (such as a file that contains a date/timestamp).  To get multiple or masked files, you can supply an asterisk (*) in the filename as a wildcard.  Then, the destination file should actually be a directory name (of a directory that exists).  All files that are picked up in the FTP process will be placed in that directory, and you can use them from there.