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.

Monday, December 13, 2004

Export - Import database Oracle

Max 5.x

Untuk memindahkan database dari sebuah server oracle ke server oracle yang lain pada, kita bisa menggunakan perintah Export dan Import.

Langkah-langkahnya sebagai berikut

  • Export database yang ada di server sumber ke file (jalankan perintah ini di command prompt) : exp system/manager@maxdb full=yes (default file keluarannya adalah expdat.dmp)

  • Create database di server tujuan

  • Create Maximo tablespace pada database yang baru dibuat

  • Jalankan createmax.sql script (login sebagai system ke database baru)

  • Lakukan perintah import di command prompt dengan syntax : imp system/manager@maxdb full=yes file=expdat.dmp

  • Jalankan view9.ora script (login sebagai system ke database baru)

  • Sunday, November 28, 2004

    Setting Untuk Melihat Page Design

    Max 5.1, Max 5.2

    http://apps:7001/maximo/jsp/app/pm/main.jsp?PageDesignMode=True