Error 500 when accessing Maximo

[hunterr007]

Hello,
After completing all the steps, when I am trying to access maximo via http://localhost/maximo it is throwing error 500.

The server has encountered an unknown error. Reload the application and try again. If the problem persists, contact your system administrator.

Looks like Maximo is not able to connect the DB but I can see container with DB running.

Can you also tell me how can I check Maximo sysout log in these containers?

Thanks.

[nishi2go]

Almost 500 errors are caused by a connection error between app servers and database. Please check there was any exception in the application logs. Here is useful information to diagnose db connection errors - https://www.ibm.com/mysupport/s/ibm-community-support-search-results?page=1&sort=0&q=BMXAA6418E&language=en_US

[hunterr007]

I can see DB2 container has run w/o any issue and there is no error but Maximo is throwing 500 because of an error -SQL0290N Table space access is not allowed.

Database Connection Information

Database server = DB2/LINUXX8664 11.1.4.4
SQL authorization ID = MAXIMO
Local database alias = MAXDB76

db2 => select varchar(tbsp_name, 30),varchar(tbsp_state, 40) from table(mon_get_tablespace('',-2))

1 2

---

SYSCATSPACE NORMAL
TEMPSPACE1 NORMAL
USERSPACE1 NORMAL
MAXDATA OFFLINE + DROP_PENDING
MAXTEMP NORMAL
MAXINDEX OFFLINE + DROP_PENDING
SYSTOOLSPACE NORMAL

7 record(s) selected.

Have you seen this issue earlier? tried multiple times but this error persist. Can connect with db but can't query the data from SQL Developer as well. Please advise.

[hunterr007]

Tried - ALTER TABLESPACE MAXDATA SWITCH ONLINE but it is throwing error- DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0552N "MAXIMO" does not have the privilege to perform operation "ALTER
TABLESPACE". SQLSTATE=42502

But I can see DB2ADM has already been granted into Maximo in installdb2.sh.

[nishi2go]

I think your container is broken. Please rerun build.sh with the -v option that enables to output the detailed messages.

[hunterr007]

I ran build.sh -r -v -c and here is the output. I don't see any errors.

ExecutionLog.txt

[nishi2go]

Have you edited the build.sh or used an old script? I have the log running the latest script.

build.log

[hunterr007]

Can you please tell me what is log path for Maximo inside the container? I have checked in container maximo-liberty/maximo-ui:7.6.1.2 wlp folder but can't find logs path. Thanks.

[nishi2go]

The default log path is /logs.

https://hub.docker.com/_/websphere-liberty