Data Quality Portal 5.0.2: java.lang.NoClassDefFoundError when Login

[Anonymous]

Hi all,
we installed the Data Quality Portal 5.0.2 in a Tomcat 7 on WinX64. All components startup (SpagoBI, tdqportal et al.) nicely, but if we attempt to login on the TDQ start page (http://:8080/tdqportal/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE) we get following text:
An error has occurred. Retry later.
If the problems persists, contact the system administrator.
in the web browser and this Tomcat server log output below.
Is there anybody who has an idea?
-Thanks in advance!!
Frank
INFO 28-03 17:19:03,269 (NilAuthenticator.java:authenticate:51) All users are guests.
javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:327)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:304)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.axis.components.logger.LogFactory
at org.apache.axis.description.TypeDesc.(TypeDesc.java:61)
at it.eng.spagobi.services.security.bo.SpagoBIUserProfile.(SpagoBIUserProfile.java:241)
at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:73)
at it.eng.spagobi.commons.services.LoginModule.service(LoginModule.java:219)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
... 21 more
javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:327)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:304)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.axis.components.logger.LogFactory
at org.apache.axis.description.TypeDesc.(TypeDesc.java:61)
at it.eng.spagobi.services.security.bo.SpagoBIUserProfile.(SpagoBIUserProfile.java:241)
at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:73)
at it.eng.spagobi.commons.services.LoginModule.service(LoginModule.java:219)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
... 21 more

[Anonymous]

I have the same problem, any idea ?
I Think I have a problem in server.xml but I don't found it.
Thank's







<SERVER port="8005" shutdown="SHUTDOWN">

<LISTENER classname="org.apache.catalina.core.AprLifecycleListener" sslengine="on"></LISTENER>

<LISTENER classname="org.apache.catalina.core.JasperListener"></LISTENER>

<LISTENER classname="org.apache.catalina.core.JreMemoryLeakPreventionListener"></LISTENER>

<LISTENER classname="org.apache.catalina.mbeans.ServerLifecycleListener"></LISTENER>
<LISTENER classname="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"></LISTENER>


<GLOBALNAMINGRESOURCES>

<RESOURCE name="UserDatabase" auth="Container">
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />

<ENVIRONMENT name="spagobi_resource_path" type="java.lang.String" value="C:/Program Files/Apache Software Foundation/Tomcat 6.0/resources"></ENVIRONMENT>
<ENVIRONMENT name="spagobi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"></ENVIRONMENT>
<ENVIRONMENT name="spagobi_service_url" type="java.lang.String" value=" http://192.168.1.104:8080/tdqportal"></ENVIRONMENT>
<ENVIRONMENT name="spagobi_host_url" type="java.lang.String" value=" http://192.168.1.104:8080"></ENVIRONMENT>
<ENVIRONMENT name="talend_logo_path" type="java.lang.String" value=" http://192.168.1.104:8080/tdqportal/docs/tdq_images"></ENVIRONMENT>

<RESOURCE auth="Container" factory="de.myfoo.commonj.work.FooWorkManagerFactory">
maxThreads="5" name="wm/SpagoWorkManager"
type="commonj.work.WorkManager"/>

<RESOURCE name="jdbc/spagobi">
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.1.15:3306/tdqportal?characterEncoding=UTF8"
username="tdqportal"
password="tdqportal"
maxActive="20"
maxIdle="10"
maxWait="-1"
validationQuery ="SELECT 1"
testOnBorrow ="true"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="60000"
minEvictableIdleTimeMillis="600000"
numTestsPerEvictionRun="5"/>
<RESOURCE name="jdbc/tdq_utf8">
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.1.15:3306/talend_dq?characterEncoding=UTF8"
username="talend_dq"
password="talend_dq"
maxActive="20"
maxIdle="10"
maxWait="-1"/>
</RESOURCE>

<SERVICE name="Catalina">






<CONNECTOR port="8080" protocol="HTTP/1.1">
connectionTimeout="20000"
redirectPort="8443" />





<CONNECTOR port="8009" protocol="AJP/1.3" redirectport="8443"></CONNECTOR>



<ENGINE name="Catalina" defaulthost="localhost">





<REALM classname="org.apache.catalina.realm.UserDatabaseRealm">
resourceName="UserDatabase"/>

<HOST name="localhost" appbase="webapps">
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">




</HOST>
</REALM>
</ENGINE>

[Anonymous]

When DQPortal installed together with TAC, a jar "pax-url-mvn-1.2.8.jar" under "endorsed" folder located under tomcat installation root directory will be created.
This can prevent DQPortal from running correctly.

[Anonymous]

related to this JIRS issue: bug:TDQ-5290

[geralds]

Due to related JIRS issue: bug:TDQ-5290 that mzhao mentioned, you need to install tdq portal separately.
If tdqportal was deployed with TAC you need to remove it:
1) Stop tomcat server
2) Remove all the folder and war files related to dq from <TOMCAT_HOME>/webapps
SpagoBICommonJEngine
SpagoBIConsoleEngine
SpagoBIJasperReportEngine
SpagoBIJPivotEngine
SpagoBIQbeEngine
tdqportal
3) Delete the folder "Catalina" from <TOMCAT_HOME>/conf and <TOMCAT_HOME>/work
4) Restart tomcat

Make sure your TAC webapp is still working.

Now you have to install TDQ Portal, by using custom installation if you're using the installer or follow the IG for manually installing TDQ Portal.
If you're using the installer, make sure to select option which will install dqportal on another Tomcat server (embedded tomcat that you have in Talend Installer), leave the default port or enter an unused port of your choice.
Shutdown tomcat and modify server.xml as per IG.

start the dedicated Tomcat, with the starting script that you will have in the folder tdqp.
..\5.0.2\tdqp\apache-tomcat\bin>startup.bat

If you want to install tdq portal tomcat as a service let me know.
hope this helps.

[Anonymous]

Also - this is a workaround if you are installing tdqportal using MySQL on windows:
Workaround: Set max_allowed_packet = 64M (or another value greater than 16M) in mysql.ini (of the user's
MySQL) and restart MySQL. Reinstall the tdqportal using the installer. It should work.