Database configuration is in progress message starting Maximo. Start fails

Database configuration is in progress message starting Maximo. Start fails

java.lang.Exception : Database Configuration is in process . ConfigDB and RestoreFromBackup must complete before MXServer can be booted .
at pdsi.server.MXServer.boot
Login receives Error 500: system#notboundexception

Resolving the problem

It is possible for configdb to leave a flag set, which can stop Maximo from starting.

Run the following SQL

select * from MAXVARS where varname='CONFIGURING';

Check the VARVALUE returned. It will be a '1' to signify that configdb is running . If it is not, then do not continue and call into support to report the error.

update MAXVARS set varvalue='0' where varname='CONFIGURING';

This will reset the flag that signifies configdb to be running.

Maximo should now start.

Setting a Default Filter Where Clause for a Maximo Application

Steps:
Launch App Designer.
Select an application such as WOTRACK.
From the Select Action menu select Toggle/Show All Controls
Select the presentation link so that the presentation highlights in green.
Select Control Properties.
In the Where Clause property enter a value such as: TYPE = ‘PM’
Save.

Keep in mind this is not an Application Restriction but a default filter.
Being that this is only a filter, you will be able to re-query using the Advanced Search or Quick Find and get around the where clause parameters.
This may be useful if the majority of time you want a certain setting but sometimes you still want to be able query the other records.