Monday, June 02, 2008

Maximo 5.1: Problem with large numbers

We found that Maximo rejects/creates error messages when PO lines value is greater than 99,999,999.00. Since the clients issues POs in multi-currency (US$, Indonesian Rupiah and Malaysian Ringgit), this bug seriously affects our operation.

Solution:
Finally solved by reconfigure the database for all fields which has amount type (become decimal 15 with scale 2).

Sunday, June 01, 2008

Problem Connection Maximo 6.2.1 to MS SQL Server

When installing maximo 6.2.1, in section Creating Maximo Database using maxinst, problem arise: cannot connect to database (MS SQL Server 2000).
in this condition, Maximo application and Database are installed in the separate server.

Problem solved when MS SQL Server 2000 is patched using SP3, both on the Maximo application server (database client) and in the database server.