Working at night, Closeup of hands typing on back lit laptop in dark

Restoring Your Missing PUI Database

If you’ve tried to apply an update to Infor XA’s PUI (Product Update Information) Tool lately, you might have been surprised to see your entire PUI Database disappear!  Luckily, this is easy to fix.


PUI is a tool provided with Infor XA that can be used to check the level of each object in an XA Environment.  It will issue several different types of error messages if it finds things to be incorrect within the Environment.  It runs in Powerlink, the GUI interface for Infor XA.


XA PUI Database Disappears

In June 2020, Infor decided that it wanted to add some additional fields behind the scenes for PUI.  These fields were added on both the Client and the Server sides.  Unfortunately, Infor didn’t realize that after the database was loaded with the new format, nothing would actually be displayed in PUI.


Once this was brought to their attention (by yours truly!), Infor whipped up a new pre-requisite PTF for PUI.  This pre-requisite will fix things up behind the scenes, so that the PUI Database will once again display properly.


New XA PTF SH67853

The new PTF is named SH67853, and there is a version available for XA Release levels 7.8, 9.1, and 9.2.  You only have to apply the PTF for the newest XA Release you’re on.  So, for example, if you are on 9.2, you can just apply the PTF for 9.2.  You don’t have to put the one for 9.1 on as well, even if you refresh the 9.1 PUI Database.  This is a standard-apply PTF, meaning there are no extra steps to apply it.  However, you’ll want to close PUI before applying it.


After you have applied the PTF, you’ll need to run the UPDPUIDTA Command to restore your PUI Database.  Once that has been completed, you should be good to go!  You should not need to apply SH67853 again in the future.


PUI Background

If you’re new to PUI and would like to learn how it works, I previously wrote a three-part article that can be found on this Blog.  The first article explains how to load and set up PUI.  The second article shows how to run a PUI Analysis, and the third article shows how to resolve the three different types of errors that come up.  Be sure to look for the link to the downloadable PDF that goes with each article.  That way, you can easily print out and save the information.



Sharon Foster

Senior Programmer/Analyst with Information Systems Engineering, Inc.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top