IBM Support

Fix: Attachments Unknown Exception when Application Name Longer Than 10 Chars (MAM v7.6.0.8)

Technical Blog Post


Abstract

Fix: Attachments Unknown Exception when Application Name Longer Than 10 Chars (MAM v7.6.0.8)

Body

Problem:

You can now create or duplicate an application with an id longer than 10 characters up to 20 characters. But, when you try to attach a document to this application you cannot select folder and even if you give default value for selected folder you get an unknown exception. It is not possible to add attachments on applications having id longer than 10 characters.

 

Root Cause:

Some Maximo objects do not have a length of 20 characters for APP attribute same as MAXPRESENTATION.APP attribute. DOCTYPES.APP, DOCLINKS.APP and DOCINFO.APP among those faulty attributes cause this error.

 

Local Fix:

Run the query below on Maximo database to identify all faulty attributes named MODULEAPP, APP and APPNAME.

select objectname,attributename,length from maxattribute where attributename in ('MODULEAPP','APP','APPNAME') and length<20;

Output:

OBJECTNAME ATTRIBUTENAME LENGTH
KPIMAIN APP 8
KPITEMPLATE APP 8
DOCINFO APP 10
REPORTFOLDER MODULEAPP 10
REPORTFOLDER APP 10
DOCLINKS APP 10
DOCTYPES APP 10

 

Go to Database Configuration application and change length to 20 chars for all attributes above in order to prevent errors related to application attribute length.

Note:

Indeed, these attributes should be defined with same as object "MAXPRESENTATION" and same as attribute "APP". We can also achieve this with an easy update on Maximo configuration tables but I will leave it to an official fix.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11129497