After installing Maximo for Utilities 7.5.0.1, if you run Integrity Checker you may see these errors reported:
BMXAA0443E -- Error - BMXAA0497E -- The following columns are defined to be 'same-as', but have different definitions:
LBSCREWVIEW.AMCREWID BIGINT same as AMCREW.AMCREWID INTEGER
BMXAA0443E -- Error - BMXAA0497E -- The following columns are defined to be 'same-as', but have different definitions:
SKDEXTRACAPCREWVIEW.AMCREWID BIGINT same as AMCREW.AMCREWID INTEGER
Columns LBSCREWVIEW.AMCREWID and SKDEXTRACAPCREWVIEW.AMCREWID are defined in Maximo to be the "same as" column AMCREW.AMCREWID. "Same as" means that the columns must be the same data type, length, and scale. In this case, columns LBSCREWVIEW.AMCREWID and SKDEXTRACAPCREWVIEW.AMCREWID are maximo datatype BIGINT, but column AMCREW.AMCREWID is Maximo datatype INTEGER.
Further, the Maximo definition of column AMCREW.AMCREWID is not valid, as depicted in the Warning message in the same Integrity Checker report:
BMXAA0442W -- Warning - BMXAA7113W -- The value defined for the length of this column is invalid. Go to the Database Configuration application and correct the discrepancy.
AMCREW.AMCREWID INTEGER(19)
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Upgrade Integ Checker","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.