Troubleshooting
Problem
Adding an attribute to the Maximo Classification with over 900 children in SCCD may cause an error with SQL error code -805.
Symptom
The following error appears in System Out log:
[2015-11-03 08:29:50:392 CET] 00051690 SystemOut O 03 nov 2015
08:29:50:392 [ERROR] [MXServer] [server1234] BMXAA6713E - The
MBO fetch operation failed in the mboset with the SQL error code -805.
The record could not be retrieved from the database. See the log file
for more details about the error.
Cause
When following these steps, the action errors:
1) Go to the Classifications application and bring up a classification.
2) Try to add an attribute to classification. The following error is displayed:
BMXAA4210E - Database error -805
3) Check "Apply down hierarchy".
Environment
The problem was reproduced in SCCD 7.5.0.2, TPAE 7.5.0.4 and DB2 NT 9.7
Resolving The Problem
Confirm that the know Maximo defect IV65191 is resolved.
APAR IV65191 CANNOT ADD ATTRIBUTE TO CLASSIFICATION
WHEN ATTRIBUTE ALREADY ADDED TO ASSET SPECIFICATIONS.
Otherwise, it could be related to the DB2 configuration to handle largeSQL
statements in sections in 9.7. As per the DB2 Technote below, check how the CLIPkg is set in the db2cli.ini file.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0008961.html
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Classifications","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21974465