IBM Support

BMXAA0443E -- Error - BMXAA0538E -- Column PLUSPCREATEBILL.BILLBATCHNUM is mapped to AutoKey PLUSPBBATCHNUM, but the autokey does not exist.

Troubleshooting


Problem

Integrity Checker output

BMXAA0443E -- Error - BMXAA0538E -- Column PLUSPCREATEBILL.BILLBATCHNUM is mapped to AutoKey PLUSPBBATCHNUM, but the autokey does not exist. 

select autokeyname, a.objectname as objectname, attributename, s.maxvalue as maxvalue from maxattribute a, maxobject o, synonymdomain s where a.objectname = o.objectname and autokeyname is not null and s.domainid = 'SITEORGTYPE' and s.value = o.siteorgtype and (s.maxvalue like 'ORG%' or s.maxvalue like 'SITE%')

This can be seen on a TPAE 7.6.0 system with Maximo for Service Providers 7.6.3.1

Resolving The Problem

The problem is with integrity checker rather than with Service Provider. 
The message in this instance can be ignored when shown against AutoKey PLUSPBBATCHNUM
Future versions of Integrity checker do not have this issue. The code which has been rewritten will not be back ported.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
21 June 2019

UID

ibm10887907