IBM Support

"BMXAA7094E- The entered value 1.0 is not valid. Enter a valid integer value"

Troubleshooting


Problem

Unable to create/save a custom object in Database Configuration in SCCD 7.5 after upgrade from TSRM 7.2.1.3

Cause

The root cause of the problem is due to invalid default value in MaxSequence. The following exceptions has been found in the log:

BMXAA6696E - The required field validation in the MBO failed for object MAXSEQUENCE and attribute TBNAME

class psdi.mbo.MboSet save(long) EXCEPTION psdi.util.MXApplicationException: BMXAA7094E - The entered value 1.0 is not valid. Enter a valid integer value

BMXAA4195E - The Table field requires a value.
class psdi.mbo.MboSet save(long) EXCEPTION psdi.util.MXRequiredFieldException: BMXAA4195E - The Table field requires a value.

Diagnosing The Problem

1. Go to Database Configuration --> Create a custom object --> Save

You get the following error message





On the second save button click, you get:


Resolving The Problem

The following solution have been applied to resolve the problem:

1. Run the following queries against your database:


select defaultvalue from maxattribute where attributename='MAXRESERVED' AND
objectname='MAXSEQUENCE'

select defaultvalue from maxattributecfg where attributename='MAXRESERVED' AND objectname='MAXSEQUENCE'

The results of the queries should return 1, confirmed in maxdemo SCCD 7.5

 DEFAULTVALUE    
 ---------------
 1            

You can also double check in Database Configuration


If the value is anything other than 1, please do the following:

2. Backup your database

3. Run SQL:

UPDATE maxattribute SET DEFAULTVALUE='1' where attributename='MAXRESERVED' AND objectname='MAXSEQUENCE'

UPDATE maxattributeCFG SET DEFAULTVALUE='1' where attributename='MAXRESERVED' AND objectname='MAXSEQUENCE'


3. Restart the server.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","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 & Data Platform"},"Component":" ","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 & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21618150