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

Maycon Belfort's profile image
Maycon Belfort IBM Champion

Hi @osama attia,

Do you have Reduce Downtime option as Online Upgrade on the Manage deployment page in MAS CORE? If so, change it to Regular Upgrade and Failure Control to Retry.

Based on your logs, the ProcessReduceDowntime failed checking the MAXVARS, which is valid, as your database was still fresh.

Cheers,

Maycon