I faced this issue recently.I have installed cognos 10 on my system .suddently today morning when i tried to start cognos service on my system .The cognos connection page was not appearing it was getting stuck and page was showing still loading . Though the cognos configuration shows started succesfully .
The first place to check in such case if cogserver.log file in configuration folder .It showed me the CFG ERR 0106 error .so below is how to procedd in case you get this error .
Steps
1) Check if your Java folder has been recently updated that is in program files earlier you were using JRE 1.4 and now its 1.6 .C:\Program Files\Java\jre6 (Here folder name jre 6 says i am using java 1.6) .
Now in normal case when you have not defined variable JAVA_HOME for your pc.This path is included in your system variable . as path variable
Right Click on my computer >Advanced system settings >environment variable >system variable and under sytem variable path (path in lower letters is the default .. in case some on has changed anything by mistake) .Here you will have path set to lot of path and one of them will be C:\Program Files\Java\jre6
OR
It can be your cognos installation JRE path C:\Datawarehousing_cognos_10\bin\jre( Datawarehousing_cognos_10 is my cognos installation folder , your will be different)
now if its any of the above its fine .There are lot of sites saying stuff to change dont bother to do so .
2) NOW THE CAUSE OF ISSUE - IF YOUR COGNOS WAS RUNNING FINE AND YOU SUDDENTLY CAME UP WITH THIS ISSUE
If your system has shut down suddenly in case of power failure .Where in the process did not get time to close cognos properly then the tomcat-users.xml might have incorrect entries resulting in this behavior
I opened the Catalina log file in the Tomcat folder and found the following error:
2010-12-16 18:44:34 UserDatabaseRealm[Standalone]: Exception looking up UserDatabase under key UserDatabase
javax.naming.NamingException: Content is not allowed in prolog.
The error suggests something about userdatabase.
Next i opened the tomcat-users.xml file in the Tomcat folder and found out that it had close to 300 NUL entries. Bingo..that was the problem..
I copied and pasted the contents of another tomcat-users.xml file into this one and ram IBM Cognos configuration again...yippeee...it works now...finally...ISSUE SOLVED...
Old Content of the xml file:
?NULNULNULNULNULNULNULNULNULNULNULNUL...
OR
your xml file can be totally blank which is also wrong .
Solution -Just take backup of your tomcat-user.xml file and copy paste the below .
(replace first line with for below ..
--------------------------------------------------------------------
?xml version='1.0' encoding='utf-8'?>
tomcat-users>
role rolename="role1"/>
role rolename="tomcat"/>
user username="role1" password="tomcat" roles="role1"/>
user username="both" password="tomcat" roles="tomcat,role1"/>
user username="tomcat" password="tomcat" roles="tomcat"/>
/tomcat-users>
-----------------------------------------------------------------------
put starting brackets < for all of the above i have removed them due to a posting issue with this blog
Thanks Kapil.
ReplyDelete