Tuesday, April 28, 2015

SP1 spagoBi error : At least one JAR was scanned for TLDs yet contained no TLDs

After spago Bi server startup i have faced the error and i look into the log files and error as below:

Apr 27, 2015 4:42:05 PM org.apache.jasper.compiler.TldLocationsCache tldScanJar
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
it.eng.spagobi.tools.objmetadata.dao.ObjMetadataDAOHibImpl.loadAllObjMetadata: Error while loading all metadata
org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at it.eng.spagobi.tools.objmetadata.dao.ObjMetadataDAOHibImpl.loadAllObjMetadata(ObjMetadataDAOHibImpl.java:204)
        at it.eng.spagobi.analiticalmodel.documentsbrowser.service.GetCategoriesList.doService(GetCategoriesList.java:35)
        at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(AbstractSpagoBIAction.java:68)
        at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
        at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:158)
        at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:425)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:33)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:119)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:82)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Invalid column name 'DESCR'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 46 more


to remove this error we need to modify the "logging.properties" file. which is reside at
apache tomcat * > conf > logging.properties.

and need to uncomment the line

# To see debug messages in TldLocationsCache, uncomment the following line:
org.apache.jasper.compiler.TldLocationsCache.level = FINE


Start the server and check for error:

if still error is coming continuously then follow below steps:
- stop SpagoBIServer
- move to folder apache tomcat\webapps\SpagoBI\WEB-INF\lib
- make a backup copy of the file hibernate3.6.2.jar
- with a zip navigator (for example 7zip/peazip) navigate the jar file hibernate3.6.2.jar
- open the folder hibernate3.6.2.jar\org\hibernate\mapping\
- delete the classes: Table.class and Table$ForeignKeyKey.class
- Start the server



reference : https://www.spagoworld.org/jforum/posts/list/1058.page#3492
 

Tuesday, April 14, 2015

QV29 Find and replace in all expression and conditions

If you have create a variable and try to add one by one in all charts, so dont waste your time.
We have find and replace functionality in qlikview  thru this we can replace a word in whole document.

goto MENU - setting - Expression Overview
or
ctrl +alt +e



QV28 Hidden sheets and objects in QLikkview

In qlikview document we can hide the sheets and sheet object. Hide means these will not visible to user any more, untill unless he enable them.

How to identify whether hidden sheet and objects are present in document:
goto MENU - setting - Expression Overview
or
ctrl +alt +e

LOOK the picture below, i have highlighted the sheet name (in yellow color) showing null value. which means we have hidden sheet in the document.


How to unhide sheet and object:
way1 - we can over ride the settings by pressing ctrl+alt+s
note*-Be very careful to undo this change before moving your application into a production environment.

way2: go to Menu - setting - Document Properties - sheet (tab)
look onto the STATUS column (Normal | Conditional: hidden | Conditional: Normal)
select any one sheet and properties - Under General tab - remove conditions

How to hide the document or sheet:
Write the condition 1=0 (under general tab of sheet and chart properties both)
web stats