IBM Support

error "BMXAA4195E - The Application field requires a value" when attempting to clone an application within Maximo

Technical Blog Post


Abstract

error "BMXAA4195E - The Application field requires a value" when attempting to clone an application within Maximo

Body

You attempt to clone an application using application designer in Maximo, and receive the error:

BMXAA4195E - The Application requires a value

One reason for this type of error is that the primarykeycolseq values in Maximo attributes have changed, causing the wrong fields to be validated within Maximo when performing certain actions.

If the primarykeycolseq values are incorrect for the APPLICATIONAUTH attributes, you will receive an error when attempting to clone an application within Maximo.  This problem can occur if an index that contains fields that have a value in the primarykeycolseq column in the maxattribute table is dropped.

The following set of instructions can be used to correct the data:


Run the following select statement:
select * from MAXSYSKEYS where IXNAME = 'APPAUTH_NDX1'

If no results are returned, a new index will need to be created.  Log
into Maximo, navigate to database configuration and create a new index
for the APPLICATIONAUTH object using the following three columns in the
sequence specified below:

NAME:  APPAUTH_NDX1
Cols:     

1  GROUPNAME
2  APP
3  OPTIONNAME

Ensure you select the checkbox beside "enforce uniqueness"

Apply the configuration changes

Next, shut down the Maximo application, connect to the database, and run
the following update statements to correct the primarykeycolseq values:

update maxattribute set primarykeycolseq='1' where
objectname='APPLICATIONAUTH' and attributename='GROUPNAME'

update maxattribute set primarykeycolseq='2' where
objectname='APPLICATIONAUTH' and attributename='APP'

update maxattribute set primarykeycolseq='3' where
objectname='APPLICATIONAUTH' and attributename='OPTIONNAME'

update maxattribute set primarykeycolseq=NULL where
objectname='APPLICATIONAUTH' and attributename='APPLICATIONAUTHID'

update maxattributecfg set primarykeycolseq='1' where
objectname='APPLICATIONAUTH' and attributename='GROUPNAME'

update maxattributecfg set primarykeycolseq='2' where
objectname='APPLICATIONAUTH' and attributename='APP'

update maxattributecfg set primarykeycolseq='3' where
objectname='APPLICATIONAUTH' and attributename='OPTIONNAME'

update maxattributecfg set primarykeycolseq=NULL where
objectname='APPLICATIONAUTH' and attributename='APPLICATIONAUTHID'

Restart the Maximo application and attempt to duplicate your application.

[{"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":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11132599