Thanks Jose and Alessandro,
After fixing memory issues, I was getting following error of Table doesn’t exist.
Caused by: java.sql.SQLSyntaxErrorException: Table 'knowage_ce.SBI_CONFIG' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019)
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)
... 39 more
[localhost-startStop-1] 18 May 2018 09:51:00,853 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:48 - Impossible to load configuration for report engine
it.eng.spago.error.EMFUserError: severity [ERROR] description [100]
at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:82)
at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at it.eng.spagobi.commons.SingletonConfig.<init>(SingletonConfig.java:53)
at it.eng.spagobi.commons.SingletonConfig.getInstance(SingletonConfig.java:43)
at it.eng.spago.dbaccess.Configurator.<init>(Configurator.java:104)
at it.eng.spago.dbaccess.Configurator.getInstance(Configur
Then, I added configuration “hibernate.hbm2ddl.auto=create” in hibernate.cfg.xml and now I am getting following errors.
[localhost-startStop-1] 18 May 2018 09:58:54,259 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:41 - The table sbi_config is EMPTY
[localhost-startStop-1] 18 May 2018 09:58:57,443 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:87 - An unexpected error occured while initializing metadata
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Ab unexpected error occured while initializeng Engines
at it.eng.spagobi.commons.initializers.metadata.EnginesInitializer.init(EnginesInitializer.java:66)
at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:82)
at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:66)
at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5198)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5481)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1074)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1858)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.DataException: could not insert: [it.eng.spagobi.commons.metadata.SbiDomains]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.findDomain(SpagoBIInitializer.java:146)
at it.eng.spagobi.commons.initializers.metadata.EnginesInitializer.writeEngines(EnginesInitializer.java:157)
at it.eng.spagobi.commons.initializers.metadata.EnginesInitializer.init(EnginesInitializer.java:60)
... 21 more
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'VALUE_CD' at row 1
[localhost-startStop-1] 18 May 2018 09:58:57,497 ERROR it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init:99 - An unexpected error occured while initializing [SpagoBI Metadata Database]
org.hibernate.exception.ConstraintViolationException: could not insert: [it.eng.spagobi.commons.metadata.SbiDomains]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
Caused by: java.sql.BatchUpdateException: Duplicate entry '15' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[localhost-startStop-1] 18 May 2018 09:58:57,587 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:319 - java.lang.NullPointerException
[localhost-startStop-1] 18 May 2018 09:58:57,899 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initRoles:339 - An unexpected error occurred while initializieng default roles
java.lang.IllegalArgumentException: id to load is required for loading
[localhost-startStop-1] 18 May 2018 09:58:58,236 ERROR it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.updateSbiUserRoles:263 - Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: Column 'EXT_ROLE_ID' cannot be null
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[localhost-startStop-1] 18 May 2018 09:58:58,275 ERROR it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init:99 - An unexpected error occured while initializing [InternalSecurity]
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An unexpected error occurred during users' initialization
Caused by: it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]
at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.updateSbiUserRoles(SbiUserDAOHibImpl.java:266)
at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:147)
... 19 more
[http-bio-8080-exec-1] 18 May 2018 10:10:14,000 ERROR it.eng.spagobi.commons.utilities.ChannelUtilities.isWebRunning:161 - SPAGOBI.SPAGOBI-MODE.mode IS NULL
[http-bio-8080-exec-1] 18 May 2018 10:10:14,021 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:319 - java.lang.NullPointerException
[http-bio-8080-exec-1] 18 May 2018 10:10:14,021 ERROR it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:55 - Error occurred
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
Please guide what am I doing wrong?
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: José Ignacio Carretero <joseignacio.carretero at fiware.org>
Sent: Thursday, May 17, 2018 7:27 PM
To: Portosa Alessandro <Alessandro.Portosa at eng.it>; Krishan Babbar <KB00449283 at TechMahindra.com>; Juanjo Hierro <juanjose.hierro at fiware.org>; fiware-tech-help at lists.fiware.org; Fernando López Aguilar <fernando.lopez at fiware.org>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com>; Álvaro Arranz <aarranz at ficodes.com>; Francisco de la Vega <fdelavega at ficodes.com>; Zerbetto Davide <davide.zerbetto at eng.it>
Subject: Re: [Fiware-tech-help] How to fetch historical data?
However.... despite of creating bigger VMs, you also have the option to create some swap space on a file --- As root user you can exec these four commands
dd if=/dev/zero of=/swapfile bs=((1024*1024)) count=4096 ### This is slow. It has to write 4Gb of data
chmod 600 /swapfile
mkswap /swapfile
swapon /swapfile
This is the same approach windows uses for its swap memory. Swap memory most times improves OS Performance.
Regards,
José Ignacio
El 17/05/18 a las 15:46, Portosa Alessandro escribió:
The error is pretty clear. Not enough memory. You didn't miss any step.
By default Knowage wants to get 2Gb of memory. You can tune this configuration in bin/setenv.sh but be aware that it is not recommended to go below 2Gb.
Alessandro Portosa
Technical Consultant
[1513603850060_logotipo_knowage_150px.png]
Knowage Labs
Engineering Group
Via G. Marconi, 10 - 40131 Bologna - Italy
Tel. + 39 051 0435090
Skype alessandro.portosa
www.knowage-suite.com<http://www.knowage-suite.com/> - www.eng.it<http://www.eng.it/web/eng_en/home>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
________________________________
Da: Krishan Babbar <KB00449283 at TechMahindra.com><mailto:KB00449283 at TechMahindra.com>
Inviato: giovedì 17 maggio 2018 15:40:21
A: Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar
Cc: Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; Francisco de la Vega; Zerbetto Davide
Oggetto: RE: [Fiware-tech-help] How to fetch historical data?
Hi Alessandro,
Thanks Again.
After adding host and MySQL Datasource in conf/server.xml, when I started Knowage server it is giving memory error as shown below.
INFO: Deploying web application archive /home/ubuntu/knowage/destination/Knowage-Server-CE/webapps/knowagewhatifengine.war
May 17, 2018 12:51:02 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(/home/ubuntu/knowage/destination/Knowage-Server-CE/webapps/knowagewhatifengine/WEB-INF/lib/servlet-api-2.4.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
Java HotSpot(TM) 64-Bit Server VM warning: INFO: os::commit_memory(0x00000000f5200000, 133169152, 0) failed; error='Cannot allocate memory' (errno=12)
#
# There is insufficient memory for the Java Runtime Environment to continue.
# Native memory allocation (mmap) failed to map 133169152 bytes for committing reserved memory.
# An error report file with more information is saved as:
# /home/ubuntu/knowage/destination/Knowage-Server-CE/bin/hs_err_pid7651.log
My Instance is having 4 GB of RAM. Is it not sufficient?
[cid:image002.png at 01D3EED3.65AF8C30]
Below is the result of “top” command
[cid:image003.png at 01D3EED3.65AF8C30]
Do let me know if I am missing any step?
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Portosa Alessandro <Alessandro.Portosa at eng.it><mailto:Alessandro.Portosa at eng.it>
Sent: Thursday, May 17, 2018 3:34 PM
To: Krishan Babbar <KB00449283 at TechMahindra.com><mailto:KB00449283 at TechMahindra.com>; Juanjo Hierro <juanjose.hierro at fiware.org><mailto:juanjose.hierro at fiware.org>; Jose Ignacio Carretero <joseignacio.carretero at fiware.org><mailto:joseignacio.carretero at fiware.org>; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org><mailto:fernando.lopez at fiware.org>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com><mailto:PC00474884 at TechMahindra.com>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com><mailto:YM00106030 at TechMahindra.com>; Álvaro Arranz <aarranz at ficodes.com><mailto:aarranz at ficodes.com>; Francisco de la Vega <fdelavega at ficodes.com><mailto:fdelavega at ficodes.com>; Zerbetto Davide <davide.zerbetto at eng.it><mailto:davide.zerbetto at eng.it>
Subject: Re: [Fiware-tech-help] How to fetch historical data?
Please add ubuntucustomfiware to your /etc/hosts and try again
https://stackoverflow.com/a/43570800
Alessandro Portosa
Technical Consultant
[1513603850060_logotipo_knowage_150px.png]
Knowage Labs
Engineering Group
Via G. Marconi, 10 - 40131 Bologna - Italy
Tel. + 39 051 0435090
Skype alessandro.portosa
www.knowage-suite.com<http://www.knowage-suite.com/> - www.eng.it<http://www.eng.it/web/eng_en/home>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
________________________________
Da: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>
Inviato: giovedì 17 maggio 2018 11:44:29
A: Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar
Cc: Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; Francisco de la Vega; Zerbetto Davide
Oggetto: RE: [Fiware-tech-help] How to fetch historical data?
Hi,
JAVA_HOME error was fixed by adding forward slash (JAVA_HOME="/usr/lib/jvm/java-8-oracle/"). My Bad.
Now when I am starting Knowage server, I can see errors in logs and http://<MyIPAddress>:8080/knowage/<http://%3cMyIPAddress%3e:8080/knowage/> is not working.
I followed https://www.knowage-suite.com/qa/548/not-able-to-start-knowage-server and tried changing hazelcast port but still same error.
catalina.out
INFO: Configuring Hazelcast from 'hazelcast.xml'.
May 17, 2018 7:40:31 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
May 17, 2018 7:40:31 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/knowage] startup failed due to previous errors
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
May 17, 2018 7:40:31 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/knowage] appears to have started a thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
knowage.log
[localhost-startStop-1] 17 May 2018 07:40:31,604 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.getCurrentHostName:777 - Error in retrieving host name
java.net.UnknownHostException: ubuntucustomfiware: ubuntucustomfiware: Name or service not known
at java.net.InetAddress.getLocalHost(InetAddress.java:1505)
at it.eng.spagobi.commons.utilities.SpagoBIUtilities.getCurrentHostName(SpagoBIUtilities.java:773)
at it.eng.spagobi.utilities.locks.listeners.HazelcastContextListener.contextInitialized(HazelcastContextListener.java:34)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1074)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1858)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.UnknownHostException: ubuntucustomfiware: Name or service not known
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928)
at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323)
at java.net.InetAddress.getLocalHost(InetAddress.java:1500)
... 15 more
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Krishan Babbar
Sent: Thursday, May 17, 2018 11:27 AM
To: 'Portosa Alessandro' <Alessandro.Portosa at eng.it<mailto:Alessandro.Portosa at eng.it>>; Juanjo Hierro <juanjose.hierro at fiware.org<mailto:juanjose.hierro at fiware.org>>; Jose Ignacio Carretero <joseignacio.carretero at fiware.org<mailto:joseignacio.carretero at fiware.org>>; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org<mailto:fernando.lopez at fiware.org>>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com<mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com<mailto:YM00106030 at TechMahindra.com>>; Álvaro Arranz <aarranz at ficodes.com<mailto:aarranz at ficodes.com>>; Francisco de la Vega <fdelavega at ficodes.com<mailto:fdelavega at ficodes.com>>; Zerbetto Davide <davide.zerbetto at eng.it<mailto:davide.zerbetto at eng.it>>
Subject: RE: [Fiware-tech-help] How to fetch historical data?
Thanks Alessandro,
I downloaded “Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip” and ran following command.
sh Knowage-6_2_0-RC-CE-Installer-Unix-20180509.sh –c
But getting following error.
In action "Check JAVA_HOME [Run script]" (screen "Display text"), property "Script":
java.lang.NullPointerException
at com.install4j.script.I4jScript_Internal_4.eval(I4jScript_Internal_4.java:1)
at com.install4j.script.I4jScript_Internal_4.evaluate(I4jScript_Internal_4.java:*26)
at com.install4j.runtime.installer.helper.Script.evaluate(Script.java:33)
at com.install4j.runtime.installer.ContextImpl.runScript(ContextImpl.java:188)
at com.install4j.runtime.installer.ContextImpl.runScript(ContextImpl.java:182)
at com.install4j.runtime.beans.actions.control.RunScriptAction.execute(RunScriptAction.java:34)
at com.install4j.runtime.beans.actions.SystemInstallOrUninstallAction.install(SystemInstallOrUninstallAction.java:29)
at com.install4j.runtime.installer.ContextImpl$7.executeAction(ContextImpl.java:1668)
at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1659)
at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1656)
at com.install4j.runtime.installer.helper.comm.actions.FetchObjectAction.execute(FetchObjectAction.java:14)
at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionDirect(HelperCommunication.java:274)
at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionInt(HelperCommunication.java:249)
at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionChecked(HelperCommunication.java:187)
at com.install4j.runtime.installer.helper.comm.HelperCommunication.fetchObjectChecked(HelperCommunication.java:170)
at com.install4j.runtime.installer.ContextImpl.performActionIntStatic(ContextImpl.java:1656)
at com.install4j.runtime.installer.InstallerContextImpl.performActionInt(InstallerContextImpl.java:151)
at com.install4j.runtime.installer.ContextImpl.performAction(ContextImpl.java:1103)
at com.install4j.runtime.installer.controller.Controller.executeAction(Controller.java:368)
at com.install4j.runtime.installer.controller.Controller.executeActions(Controller.java:334)
at com.install4j.runtime.installer.controller.Controller.handleCommand(Controller.java:195)
at com.install4j.runtime.installer.controller.Controller.start(Controller.java:94)
at com.install4j.runtime.installer.Installer.runInProcess(Installer.java:59)
at com.install4j.runtime.installer.Installer.main(Installer.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)
at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57)
Unable to find environment variable JAVA_HOME, please set it and restart installer
My JAVA_HOME already set as shown below.
[cid:image004.png at 01D3EED3.65AF8C30]
Please guide.
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Portosa Alessandro <Alessandro.Portosa at eng.it<mailto:Alessandro.Portosa at eng.it>>
Sent: Wednesday, May 16, 2018 8:16 PM
To: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>; Juanjo Hierro <juanjose.hierro at fiware.org<mailto:juanjose.hierro at fiware.org>>; Jose Ignacio Carretero <joseignacio.carretero at fiware.org<mailto:joseignacio.carretero at fiware.org>>; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org<mailto:fernando.lopez at fiware.org>>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com<mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com<mailto:YM00106030 at TechMahindra.com>>; Álvaro Arranz <aarranz at ficodes.com<mailto:aarranz at ficodes.com>>; Francisco de la Vega <fdelavega at ficodes.com<mailto:fdelavega at ficodes.com>>; Zerbetto Davide <davide.zerbetto at eng.it<mailto:davide.zerbetto at eng.it>>
Subject: Re: [Fiware-tech-help] How to fetch historical data?
Hi,
first of all you could use the latest release, which is 6.2.0-RC that we just released.
Also, to install it without the GUI, please use the -c option: sh Knowage-6_1_1-CE-Installer-Unix-20171213.sh -c
Alessandro Portosa
Technical Consultant
[1513603850060_logotipo_knowage_150px.png]
Knowage Labs
Engineering Group
Via G. Marconi, 10 - 40131 Bologna - Italy
Tel. + 39 051 0435090
Skype alessandro.portosa
www.knowage-suite.com<http://www.knowage-suite.com/> - www.eng.it<http://www.eng.it/web/eng_en/home>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
________________________________
Da: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>
Inviato: mercoledì 16 maggio 2018 16:39:44
A: Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar
Cc: Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; Francisco de la Vega; Zerbetto Davide
Oggetto: RE: [Fiware-tech-help] How to fetch historical data?
Thanks Alessandro,
Need your guidance for installation and setup of Knowage with MySQL.
I am using Ubuntu 16.04 (Linux ubuntucustomfiware 4.4.0-119-generic #143-Ubuntu SMP Mon Apr 2 16:08:24 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux).
I have already installed MySQL.
For Knowage, I downloaded zip file from http://download.forge.ow2.org/knowage/Knowage-6_1_1-CE-Installer-Unix-20171213.zip
After unzipping it, there is a .sh file.
On running this .sh file I am getting following error.
sh Knowage-6_1_1-CE-Installer-Unix-20171213.sh
Starting Installer ...
java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at com.install4j.runtime.installer.Installer.getScreenExecutor(Installer.java:105)
at com.install4j.runtime.installer.Installer.runInProcess(Installer.java:58)
at com.install4j.runtime.installer.Installer.main(Installer.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)
at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57)
Caused by: java.lang.reflect.InvocationTargetException
at java.awt.EventQueue.invokeAndWait(EventQueue.java:1321)
at java.awt.EventQueue.invokeAndWait(EventQueue.java:1296)
at javax.swing.SwingUtilities.invokeAndWait(SwingUtilities.java:1348)
at com.install4j.runtime.installer.Installer.getScreenExecutor(Installer.java:96)
... 8 more
Caused by: java.awt.HeadlessException:
No X11 DISPLAY variable was set, but this program performed an operation which requires it.
at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:204)
at java.awt.Button.<init>(Button.java:152)
at java.awt.Button.<init>(Button.java:139)
at com.install4j.runtime.installer.frontend.WizardScreenExecutor.initAWT(WizardScreenExecutor.java:462)
at com.install4j.runtime.installer.frontend.WizardScreenExecutor.<init>(WizardScreenExecutor.java:42)
at com.install4j.runtime.installer.frontend.InstallerWizardScreenExecutor.<init>(InstallerWizardScreenExecutor.java:18)
at com.install4j.runtime.installer.Installer$2.run(Installer.java:99)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:301)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Could not display the GUI. This application needs access to an X Server.
*******************************************************************
You can also run this application in console mode without
access to an X server by passing the argument -c
*******************************************************************
Kindly let me know what am I doing wrong?
Also, how to use existing MySQL server?
I downloaded “Knowage_6.x_CE_Manual.pdf” file but could not find steps for installation.
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Portosa Alessandro <Alessandro.Portosa at eng.it<mailto:Alessandro.Portosa at eng.it>>
Sent: Wednesday, May 16, 2018 1:37 PM
To: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>; Juanjo Hierro <juanjose.hierro at fiware.org<mailto:juanjose.hierro at fiware.org>>; Jose Ignacio Carretero <joseignacio.carretero at fiware.org<mailto:joseignacio.carretero at fiware.org>>; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org<mailto:fernando.lopez at fiware.org>>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com<mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com<mailto:YM00106030 at TechMahindra.com>>; Álvaro Arranz <aarranz at ficodes.com<mailto:aarranz at ficodes.com>>; Francisco de la Vega <fdelavega at ficodes.com<mailto:fdelavega at ficodes.com>>; Zerbetto Davide <davide.zerbetto at eng.it<mailto:davide.zerbetto at eng.it>>
Subject: Re: [Fiware-tech-help] How to fetch historical data?
Dear Krishan,
you can exploit Knowage with MySQL, CKAN, and several other datasources: Oracle, SQL Server, HSQL, MySQL, PostgreSQL, Ingres, DB2, AS400, Impala, Hive, Cassandra, SparkSQL.
You can also exploit data directly from the Context Broker as well as with a REST service or a simply CSV/XLS file.
You can have a look at the PDF version of our community documentation, which BTW I'm happy to say that will be published also on readthedocs in a really short time.
Alessandro Portosa
Technical Consultant
[1513603850060_logotipo_knowage_150px.png]
Knowage Labs
Engineering Group
Via G. Marconi, 10 - 40131 Bologna - Italy
Tel. + 39 051 0435090
Skype alessandro.portosa
www.knowage-suite.com<http://www.knowage-suite.com/> - www.eng.it<http://www.eng.it/web/eng_en/home>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
________________________________
Da: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>
Inviato: mercoledì 16 maggio 2018 08:00:52
A: Juanjo Hierro; Jose Ignacio Carretero; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar
Cc: Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; Francisco de la Vega; Portosa Alessandro; Zerbetto Davide
Oggetto: RE: [Fiware-tech-help] How to fetch historical data?
Hi Juanjo,
In initial understanding of ‘Knowage’, it seems it works with CKAN. Am I right?
Actually, I was using MySQL with Cygnus, so is it possible to use Knowage MySQL?
I tried using CKAN with Cygnus but on installing CKAN (http://docs.ckan.org/en/ckan-2.7.3/maintaining/installing/install-from-source.html#install-the-required-packages) I am getting following issue.
[cid:image005.png at 01D3EED3.65AF8C30]
Please suggest.
Thanks & Regards,
Krishan Babbar
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Juanjo Hierro <juanjose.hierro at fiware.org<mailto:juanjose.hierro at fiware.org>>
Sent: Monday, May 14, 2018 1:30 PM
To: Krishan Babbar <KB00449283 at TechMahindra.com<mailto:KB00449283 at TechMahindra.com>>; Jose Ignacio Carretero <joseignacio.carretero at fiware.org<mailto:joseignacio.carretero at fiware.org>>; fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org<mailto:fernando.lopez at fiware.org>>
Cc: Prashant Chauhan1 <PC00474884 at TechMahindra.com<mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com<mailto:YM00106030 at TechMahindra.com>>; Álvaro Arranz <aarranz at ficodes.com<mailto:aarranz at ficodes.com>>; Francisco de la Vega <fdelavega at ficodes.com<mailto:fdelavega at ficodes.com>>; Alessandro Portosa <alessandro.portosa at eng.it<mailto:alessandro.portosa at eng.it>>; Davide Zerbetto <davide.zerbetto at eng.it<mailto:davide.zerbetto at eng.it>>
Subject: Re: [Fiware-tech-help] How to fetch historical data?
Dear Krishan,
GUIs of applications tend to be tailor-made. Nevertheless, I will try to give you some hints that I hope can be useful:
* Knowage<https://github.com/KnowageLabs/Knowage-Server> is a very complete business intelligence tool that comprises many functions including those for producing reports on historic data which has beeen stored in data-sinks using Cygnus. It also include some functions for creating dashboards.
* Operational dashboards which query directly on the Orion Context Broker or some other data services can also be based on Wirecloud<https://github.com/Wirecloud/wirecloud>.
* STH-Comet<https://github.com/telefonicaid/fiware-sth-comet> can be used to store raw and aggregated time series context information in MongoDB which then you can get access to using an API
* You can also use QuantumLeap<https://smartsdk.github.io/ngsi-timeseries-api/> for transferring historic data into time series databases and then use some GUI tools for visualizing data (e.g., Grafana). This is useful is some use cases.
I add people from the Eng and FICodes teams in case they want to add something regarding Knowage and Wirecloud.
Let us know if these hints bring answer to your questions.
I would like to take advantage of this mail to let you know that we have re-structure contents of the FIWARE developers' page<https://developer.fiware.org/> and the FIWARE Catalogue<https://www.fiware.org/developers/catalogue/>. We will continue working on improving it based on feedback.
Cheers,
Juanjo
On 14/05/2018 08:45, Krishan Babbar wrote:
Any input?
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
From: Krishan Babbar
Sent: Friday, May 11, 2018 2:40 PM
To: Jose Ignacio Carretero <joseignacio.carretero at fiware.org><mailto:joseignacio.carretero at fiware.org>
Cc: fiware-tech-help at lists.fiware.org<mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar <fernando.lopez at fiware.org><mailto:fernando.lopez at fiware.org>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com><mailto:YM00106030 at TechMahindra.com>; PC00474884 at TechMahindra.com<mailto:PC00474884 at TechMahindra.com>
Subject: How to fetch historical data?
Hi Jose,
Thanks for all your support so far.
I have setup Cygnus with MySQL agent and now data is storing into MySQL.
As a next step, we need to show reports of historical data (Saved in Cygnus_MySQL) in GUI. It may be based upon some filters like data for today, last week/month, area wise etc.
My questions are
1. Do we need to create our own APIs for fetching data from MySQL and returning to GUI application?
2. Or is there any GUI component (WireCloud or any other) in which we can directly fetch Cygnus Data? Or we need to create our custom GUI ourselves?
3. I found a component STH-Comet (https://github.com/telefonicaid/fiware-sth-comet), will it fit in our requirements for fetching Cygnus_MySQL data?
4. Do let me know if Fiware have any other components matching with our requirement.
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA
• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
============================================================================================================================
__________________________________________________________________________________________
You can get more information about our cookies and privacy policies on the following links:
- http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/FIWARE_Privacy_Policy
- http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/Cookies_Policy_FIWARE
Fiware-tech-help mailing list
Fiware-tech-help at lists.fiware.org<mailto:Fiware-tech-help at lists.fiware.org>
https://lists.fiware.org/listinfo/fiware-tech-help
--
−−−
José Ignacio Carretero
FIWARE Cloud and Platform Expert
FIWARE Foundation
[FIWARE Foundation]
Franklinstrasse 13A
10587 Berlin
email: joseignacio.carretero at fiware.org<mailto:joseignacio.carretero at fiware.org>
www: http://fiware.org
twitter: @jicarreterogu @FIWARE
skype: jicarretero
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3338 bytes
Desc: image001.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 29109 bytes
Desc: image002.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 38475 bytes
Desc: image003.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 10434 bytes
Desc: image004.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 19913 bytes
Desc: image005.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 251283 bytes
Desc: image006.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180518/814a291e/attachment-0011.png>
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy