It's all about the answers!

Ask a question

RQM Error fetching server status information.ID CRJAZ1505E

Hu Jiale (1122) | asked Jun 26 '13, 3:26 a.m.
 The JTS(version 4.0.1) is installed on a ubuntu machine.
The database is DB2 (version 10.1.0).
We can login the jts by web(
However, if we click any items on the server(status summary,diagnostics,license key management etc...), the server will complain "Error fetching server status information.ID CRJAZ1505E".

Check the jts.log on the machine, we'll find the following info:
2013-06-26 15:09:33,342 [         http-bio-9443-exec-24] ERROR net.jazz.ajax.service.internal.http.ThemingHandler  - ERROR : GET HTTP/1.1
org.apache.http.HttpException: Problem initializing theme namespace
        at net.jazz.ajax.service.internal.http.ThemingHandler.getHttpException(
        at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(
        at net.jazz.ajax.service.internal.http.ThemingHandler.init(
        at net.jazz.ajax.service.internal.http.ThemingHandler.handle(
        at net.jazz.ajax.service.internal.AjaxServices$1.doWrappedService(
        at javax.servlet.http.HttpServlet.service(
        at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(
        at javax.servlet.http.HttpServlet.service(
        at org.eclipse.equinox.servletbridge.BridgeServlet.service(
        at javax.servlet.http.HttpServlet.service(
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(
        at org.apache.catalina.core.StandardWrapperValve.invoke(
        at org.apache.catalina.core.StandardContextValve.invoke(
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
        at org.apache.catalina.core.StandardHostValve.invoke(
        at org.apache.catalina.valves.ErrorReportValve.invoke(
        at org.apache.catalina.authenticator.SingleSignOn.invoke(
        at org.apache.catalina.core.StandardEngineValve.invoke(
        at org.apache.catalina.connector.CoyoteAdapter.service(
        at org.apache.coyote.http11.AbstractHttp11Processor.process(
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
        at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.lang.NullPointerException
        at net.jazz.ajax.service.internal.http.ThemingHandler.sendLocalRequest(
        at net.jazz.ajax.service.internal.http.ThemingHandler.sendJfsRequest(
        at net.jazz.ajax.service.internal.http.ThemingHandler.sendBasicJFSGet(
        at net.jazz.ajax.service.internal.http.ThemingHandler.createRootNamespace(
        at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(
        ... 33 more

The DB2 is started and listenning the port of 50000:
[root@guangzhou version]# netstat -npl|grep -i 50000
tcp        0      0     *                   LISTEN      5854/db2sysc 0

Is there any clue to fix the problem?


4 answers

permanent link
Indradri Basu (1.8k1514) | answered Jun 26 '13, 5:27 a.m.
I would probably try to connect to JTS db using the username that you used during jts setup to see if the user id is locked or password expired etc if you have not used the instance owner itself. Like "db2 connect to JTS user <mydb2user> using <password>
Your database is not local right ? and you are using Tomcat ?

permanent link
Sunil Kumar R (1.1k12944) | answered Jun 26 '13, 3:51 a.m.
 Hu Jiale, Is CLM running as a tomcat service?
I see similar problems observed with CLM started as tomcat service.

Did you try re-starting the service? i.e., stop - clear any stray "java.exe" processes - restart the service..
Check if the ubuntu user starting the service has "root" priveleges?

How about other context roots "qm/admin" OR "ccm/admin"? If they have similar errors also; re-check after a restart?
Might need to look at the logs to see if there is anything specific to be done..

Best Regards, Sunil

permanent link
Indradri Basu (1.8k1514) | answered Jun 26 '13, 3:51 a.m.
Although absolutely unsure but to me it looks like there are some issues with database connectivity. Check if the applications are actually connected to the databases. You can run "db2 list active databases" on the db2 server to see if there are any active connections exists on the application databases, specially to the JTS db once you login to jts/admin.
If not and assuming this is a new DB2 instance, try running db2set DB2COMM=tcpip on the db2 server, restart the application server and see if that works.

Hu Jiale commented Jun 26 '13, 4:45 a.m.

Thanks Indradri.

"db2 list active databases" shows there's no connections to the databases.
Please see my logs below(the characters are limited in comment).

permanent link
Hu Jiale (1122) | answered Jun 26 '13, 4:46 a.m.
Hi Indradri,
 "db2 list active databases" shows there's no connections to the databases.
[db2inst1@guangzhou ~]$ db2 list active databases
SQL1611W  No data was returned by Database System Monitor.

However, I can connect to jts manually by the command of"db2 connect to jts"
[db2inst1@guangzhou ~]$ db2 connect to jts

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.1.0
 SQL authorization ID   = DB2INST1
 Local database alias   = JTS

db2inst1@guangzhou ~]$ db2 list active databases

                           Active Databases

Database name                              = JTS
Applications connected currently           = 1
Database path                              = /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/

I tried running db2set DB2COMM=tcpip and then restart the app. server and got the same results.

Any more ideas?


Hu Jiale commented Jun 27 '13, 1:22 a.m.

 Hi Indradri,

Seems that the password expired for the user ID. 
After reset the password the connection to DB2 is OK now.
The password for the userID will be changed in two days though PASS_MAX_DAYS  is set to 90. We're checking why the password will be expired no more than two days.


Your answer

Register or to post your answer.