Database Error Number 8115

Troubleshooting

Problem

Unable to adjust current balance in the Inventory application.

Symptom

A user issued a large quantity of an inventory items to a work order and now you are unable to change the current balance in inventory for that item (which is -4701999886).

You receive this error when adjusting current balance via the "Select Action" menu in the Inventory application:

error: Database error number 8115 has occurred when operating on INVTRANS Site=BEDFORD ID=1,976,056,956.
[MXEAM6]Arithmetic overflow error converting float to data type numeric.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Inventory","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8;7.1;7.1.1;7.5;Version Independent","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Maximo Asset Management

Software version:
6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5, Version Independent

Operating system(s):
AIX, HP-UX, Linux, Windows

Document number:
198517

Modified date:
17 June 2018

UID

swg21579350

IBM Support

Tips