Integrity Checker reports GL Too Small Error

Technote (troubleshooting)


Problem(Abstract)

Integrity Checker reports the following cryptic error message:

BMXAA0443E -- ERROR -- configdb#GLTOOSMALL



The error message is followed by a list of columns.

Symptom

The error code GLTOOSMALL is not being translated to an error message. The error should read:
"The following attributes are defined as GL attributes, but the character length is too short:"

The error message is followed by a list of columns.


Cause

A Maximo-specific datatype is 'GL'. All columns defined as type GL contain GL Account Codes. All GL Account codes, and GL columns, must be the same character length. The columns listed in the error message are too short to contain a full GL Account Code.

Diagnosing the problem

To determine the proper length of a column defined to be datatype GL, execute this query:

Select length From maxattribute Where objectname='CHARTOFACCOUNTS' And attributename='GLACCOUNT;

Resolving the problem

Use the Database Configuration application to set the length of every column listed in the error message to the results of the above query.


To add the error message to your database, apply one of attached SQL scripts AddMaxMessage.xxx that is appropriate for your database platform.


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT Not Applicable
Systems and Asset Management Tivoli Change and Configuration Management Database
Systems and Asset Management Tivoli Service Request Manager
Systems and Asset Management IBM Maximo Asset Management Essentials
Systems and Asset Management IBM SmartCloud Control Desk

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Upgrade Integ Checker

Software version:

7.1, 7.5

Operating system(s):

Platform Independent

Reference #:

1633020

Modified date:

2013-07-16

Translate my page

Machine Translation

Content navigation