Running Undocumented Object Wizard (UOW) for Message Catalog Entry an error is raised.
Unable to open cursor for Message Catalog Entry object type.
SQLCODE=-1, SQLDBCode=207, SQLNRows=0, SQLErrText= SQLSTATE= 42S22
Microsoft OLE DB Provider for SQL Server
Invalid column name 'LASTUPDOPRID'.
After STAT migration from 5.6.2 to 5.7.1 some data were missed from Stat's tables/view structure. Stat is looking for data on the Psoft db when the UOW runs. It reads the STAT_OBJECT_TYPES and STAT_PSTOOLS_SQL_VW2 in table_seq order.
There are several objects where tables used in early versions and then are no longer used in later versions. Those tables don’t show up on the view when the version_minor_cd is part of the filter.
The problem is that the view doesn’t have a table_seq value of 1 for this object type. Therefore the error.WORKAROUND:
Run the UOW without the Message Catalog Entry object type
STATUS:
The issue is fixed in STAT 5.7.2.
