Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Occur error login to server

0 votes
1 view

Hi Good Day,

This login issue occur after night idle. Every morning must force reload more than 5 times to login without need restart the tomcat. Current my server has no any problem or any setting to idle some services. I installed Knowage-6_1_1-CE-Installer-Windows-JVM64bit-20171213.exe and made only some change on server.xml,hibernate.cfg.xml and quartz.properties. I wonder if i missed out other settings?

Here's my catalina log:

Feb 06, 2018 3:27:04 PM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.2.14 using APR version 1.6.2.
Feb 06, 2018 3:27:04 PM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Feb 06, 2018 3:27:05 PM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.2l  25 May 2017)
Feb 06, 2018 3:27:06 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8080"]
Feb 06, 2018 3:27:06 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Feb 06, 2018 3:27:06 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2307 ms
Feb 06, 2018 3:27:06 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Feb 06, 2018 3:27:06 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.50
Feb 06, 2018 3:27:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\.install4j
Feb 06, 2018 3:27:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\host-manager
Feb 06, 2018 3:27:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\examples
Feb 06, 2018 3:27:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\docs
Feb 06, 2018 3:27:08 PM org.apache.catalina.util.SessionIdGenerator createSecureRandom
INFO: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [141] milliseconds.
Feb 06, 2018 3:27:08 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowage
Feb 06, 2018 3:27:08 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagebirtreportengine
Feb 06, 2018 3:27:08 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagecockpitengine
Feb 06, 2018 3:27:09 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagecommonjengine
Feb 06, 2018 3:27:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagedataminingengine
Feb 06, 2018 3:27:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagegeoreportengine
Feb 06, 2018 3:27:45 PM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/portlet is already defined
Feb 06, 2018 3:27:45 PM com.hazelcast.config.ClasspathXmlConfig
INFO: Configuring Hazelcast from 'hazelcast.xml'.
Feb 06, 2018 3:27:51 PM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://www.eclipse.org/birt/taglibs/birt.tld is already defined
Feb 06, 2018 3:27:56 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagejasperreportengine
Feb 06, 2018 3:28:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagekpiengine
Feb 06, 2018 3:28:07 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagemeta
Feb 06, 2018 3:28:19 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagenetworkengine
Feb 06, 2018 3:28:23 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowageqbeengine
Feb 06, 2018 3:28:26 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagesvgviewerengine
Feb 06, 2018 3:28:29 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagetalendengine
Feb 06, 2018 3:28:33 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\knowagewhatifengine
Feb 06, 2018 3:28:42 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\manager
Feb 06, 2018 3:28:42 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\TEMP\Knowage-Server-CE\webapps\ROOT
Feb 06, 2018 3:28:55 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Feb 06, 2018 3:28:56 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Feb 06, 2018 3:28:56 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 109786 ms
Feb 06, 2018 10:36:52 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.

Thank you.
Regards,

Herman

Environment Knowage-6.1.1 CE, Windows Server 2012 R2, MySQL Server 5.6, Google Chrome & Mozilla Firefox.
in General Configuration by (1.1k points)
Hi,
did you looked also at the knowage.log file?
by (11.6k points)

1 Answer

0 votes

Hi Mcortella,

Thank you for your prompt reply. I checked and found it's due to the MySQL server has time out connection. 
I monitor this issue these days and already fixed by edit the server.xml as below highlight:

<Resource auth="Container" 
driverClassName="com.mysql.jdbc.Driver" 
maxActive="20" 
maxIdle="10" 
maxWait="-1" 
name="jdbc/foodmart" 
username="XXXXX" 
password="XXXXXXX" 
type="javax.sql.DataSource" 
url="jdbc:mysql://localhost:3306/database?autoReconnect=true" 
validationQuery="select 1 from dual" 
testOnBorrow="true" />

 I'll keep monitor further.

Regards,

Herman.

by (1.1k points)
Powered by Question2Answer
...