The importance of ‘sameas’ in Database Configuration

An often misused feature of Maximo Database Configuration is the ‘Same as Object’ and ‘Same as Attribute’ fields when defining custom database attributes.

To understand how this works lets consider the ASSET.LOCATION attribute. As you can see from the screenshot below, the LOCATION column of the ASSET table is defined ‘same as’ LOCATIONS.LOCATION’ field.

The direct effect of this is that if you change the size of the LOCATIONS.LOCATION field it will affect all the ‘sameas’ fields defined in other tables.

This is really important to have a consistent data model for your custom fields. Here is an SQL query to help identify missing same-as in the custom objects and attributes.

select objectname, attributename, maxtype, length, sameasobject, sameasattribute
from maxattributecfg
where objectname like 'XXX%' or attributename like 'XXX%'
order by attributename, sameasattribute;

Replace the ‘XXX’ with your custom prefix (hope you have one) and it will list all the custom attributes to be verified.

The importance of ‘sameas’ in Database Configuration

3 thoughts on “The importance of ‘sameas’ in Database Configuration

  1. When I am trying to call .Net webserive from Maximo 7.6. i am getting below error.

    psdi.util.MXSystemException: BMXAA1481E – Cannot deliver the message to the endpoint.
    java.io.IOException: Async IO operation failed (3), reason: RC: 107 Transport endpoint is not connected
    at psdi.iface.router.WebServiceHandler.invoke(WebServiceHandler.java:258)
    at psdi.iface.mic.MicService.routeData(MicService.java:472)
    at psdi.iface.app.endpoint.MaxEndPointTestSet.execute(MaxEndPointTestSet.java:131)
    at psdi.webclient.beans.endpoint.EndPointTestBean.testxml(EndPointTestBean.java:59)
    at sun.reflect.GeneratedMethodAccessor252.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)

    It is throwing in Prod only but not in test environments. Any suggestions please????

Leave a Reply

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

Scroll to top