Maximo

 View Only

 MAS 9.1 Installation - Manage installation getting stuck with SQLCODE=-204, SQLSTATE=42704, SQLERRMC=MAXIMO.MAXVARS

  • Install
  • installation
  • Maximo
osama attia's profile image
osama attia posted Tue July 15, 2025 04:50 AM

Hi,

I installed MAS Core using the OneClick method and proceeded to install Manage via the MAS Administration Console.

However, I wanted the database to be on a VM outside the cluster. So I followed the documentation to create an empty Db2 database with the Maximo schema — but without any tables.

Now, the installation is stuck, and the logs show the following error:

[AUDIT   ] CWWKF0011I: The default server is ready to run a smarter planet. The default server started in 15.754 seconds.
BMXAA6818I - ProcessReduceDowntime started for schema MAXIMO, connected to database jdbc:db2://10.0.27.122:50005/maxdb90 Tue Jul 15 06:37:26 GMT 2025
ProcessConfigChanges setup complete Tue Jul 15 06:37:26 GMT 2025
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=MAXIMO.MAXVARS, DRIVER=4.32.28 Tue Jul 15 06:37:26 GMT 2025
BMXAA6819I - ProcessReduceDowntime completed with errors. Tue Jul 15 06:37:26 GMT 2025
BMXAA6818I - ValidateRowBasedTables started for schema MAXIMO, connected to database jdbc:db2://10.0.27.122:50005/maxdb90 Tue Jul 15 06:37:29 GMT 2025
ValidateSequences setup complete Tue Jul 15 06:37:29 GMT 2025
create table testrowlevel(name varchar(50));
commit;
drop table testrowlevel;
commit;
BMXAA6820I - ValidateRowBasedTables completed without errors. Tue Jul 15 06:37:29 GMT 2025

It appears that the installation assumes the database already contains the required Maximo tables, which is not the case — this is a brand new, empty database.

The documentation doesn't mention this requirement, and I haven't found any official guidance addressing this scenario.

Any help or clarification would be greatly appreciated.


#installation #Install #Maximo

osama attia's profile image
osama attia

i want to add that i followed this document https://www.ibm.com/support/pages/how-run-maxinst-mas-environment
the error got resolved but the installation is still stuck 
also the --all-- deployment mentioned in the document never got created 
image.png