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.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21618150