IBM Support

MAXINST fails with ORA-00955 (Oracle) or Error 2714 (SQL Server).

Flashes (Alerts)


Abstract

The Maximo schema installation utility cannot be run a second time against a partially installed schema. You must first remove the objects left by the previous incomplete install.

Content



Oracle

The following error appears in the UPDATE log:

ORA-00955: name is already in use by an existing object

Please do the following:

  1. From SQLPLUS logged in as SYSTEM: DROP USER maximo-schema-name CASCADE;
  2. Run the schema creation script again
  3. Run MAXINST again.



SQL Server

The following error appears in the UPDATE log:

com.inet.tds.SQLException: Msg 2714, Level 16, State 6, Line 1, Sqlstate S0001
[MAXIMO]There is already an object named 'maxintobjalias' in the database.
  1. Delete the Maximo database from Enterprise Manager
  2. Create the database from Enterprise Manager.
  3. Change the database ownership to the maximo login. Login to the database with Query Analyzer as the system user "sa" and execute the command: sp_changedbowner maximo
  4. Run MAXINST again.



[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0;6.1;6.2;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;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

M04825

Product Synonym

MAXIMO

Document Information

Modified date:
25 September 2022

UID

swg21263087