Details
-
Type:
extRequest
-
Status: Closed
-
Priority:
Major
-
Resolution: Done
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:None
-
HD-Chapter:Apps
-
HD-Enabler:Wirecloud
Description
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 <http://www.techmahindra.com/Disclaimer.html> externally http://tim.techmahindra.com/tim/disclaimer.html <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@lists.fiware.org
https://lists.fiware.org/listinfo/fiware-tech-help
[Created via e-mail received from: Krishan Babbar <KB00449283@TechMahindra.com>]
Activity
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@fiware.org>
Sent: Thursday, May 17, 2018 7:27 PM
To: Portosa Alessandro <Alessandro.Portosa@eng.it>; Krishan Babbar <KB00449283@TechMahindra.com>; Juanjo Hierro <juanjose.hierro@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@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.
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
[X][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.
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:image001.png@01D3EE12.B0EE0FD0]
Below is the result of "top" command
[cid:image003.png@01D3EE12.B0EE0FD0]
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@eng.it>
Sent: Thursday, May 17, 2018 3:34 PM
To: Krishan Babbar <KB00449283@TechMahindra.com>; Juanjo Hierro <juanjose.hierro@fiware.org>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@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.
Please add ubuntucustomfiware to your /etc/hosts and try again
https://stackoverflow.com/a/43570800
Alessandro Portosa
Technical Consultant
[X][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.
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
–
−−−
José Ignacio Carretero
FIWARE Cloud and Platform Expert
FIWARE Foundation
FIWARE Foundation
Franklinstrasse 13A
10587 Berlin
email: joseignacio.carretero@fiware.org
<joseignacio.carretero@fiware.org
>
www: http://fiware.org
twitter: @jicarreterogu @FIWARE
skype: jicarretero
__________________________________________________________________________________________
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@lists.fiware.org
https://lists.fiware.org/listinfo/fiware-tech-help
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@eng.it>; Juanjo Hierro <juanjose.hierro@fiware.org>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@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:image001.png@01D3EDDF.7D6AFD90]
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@eng.it<Alessandro.Portosa@eng.it>>
Sent: Wednesday, May 16, 2018 8:16 PM
To: Krishan Babbar <KB00449283@TechMahindra.com<KB00449283@TechMahindra.com>>; Juanjo Hierro <juanjose.hierro@fiware.org<juanjose.hierro@fiware.org>>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org<joseignacio.carretero@fiware.org>>; fiware-tech-help@lists.fiware.org<fiware-tech-help@lists.fiware.org>; Fernando López Aguilar <fernando.lopez@fiware.org<fernando.lopez@fiware.org>>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com<PC00474884@TechMahindra.com>>; Yugal Kishor Mullick <YM00106030@TechMahindra.com<YM00106030@TechMahindra.com>>; Álvaro Arranz <aarranz@ficodes.com<aarranz@ficodes.com>>; Francisco de la Vega <fdelavega@ficodes.com<fdelavega@ficodes.com>>; Zerbetto Davide <davide.zerbetto@eng.it<davide.zerbetto@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.
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:image001.png@01D3EDD1.ECAD3B40]
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@eng.it>
Sent: Wednesday, May 16, 2018 8:16 PM
To: Krishan Babbar <KB00449283@TechMahindra.com>; Juanjo Hierro <juanjose.hierro@fiware.org>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@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.
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
[X][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.
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@eng.it>
Sent: Wednesday, May 16, 2018 1:37 PM
To: Krishan Babbar <KB00449283@TechMahindra.com>; Juanjo Hierro <juanjose.hierro@fiware.org>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@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.
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
[X][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.
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:image001.png@01D3ED09.55BD1520]
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@fiware.org>
Sent: Monday, May 14, 2018 1:30 PM
To: Krishan Babbar <KB00449283@TechMahindra.com>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Alessandro Portosa <alessandro.portosa@eng.it>; Davide Zerbetto <davide.zerbetto@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@fiware.org><joseignacio.carretero@fiware.org>
Cc: fiware-tech-help@lists.fiware.org<fiware-tech-help@lists.fiware.org>; Fernando López Aguilar <fernando.lopez@fiware.org><fernando.lopez@fiware.org>; Yugal Kishor Mullick <YM00106030@TechMahindra.com><YM00106030@TechMahindra.com>; PC00474884@TechMahindra.com<PC00474884@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.
============================================================================================================================
Thanks Juanjo,
I will explore Knowage and get back to you with queries if any.
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: Juanjo Hierro <juanjose.hierro@fiware.org>
Sent: Monday, May 14, 2018 1:30 PM
To: Krishan Babbar <KB00449283@TechMahindra.com>; Jose Ignacio Carretero <joseignacio.carretero@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Alessandro Portosa <alessandro.portosa@eng.it>; Davide Zerbetto <davide.zerbetto@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@fiware.org><joseignacio.carretero@fiware.org>
Cc: fiware-tech-help@lists.fiware.org<fiware-tech-help@lists.fiware.org>; Fernando López Aguilar <fernando.lopez@fiware.org><fernando.lopez@fiware.org>; Yugal Kishor Mullick <YM00106030@TechMahindra.com><YM00106030@TechMahindra.com>; PC00474884@TechMahindra.com<PC00474884@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.
============================================================================================================================
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
__________________________________________________________________________________________
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@lists.fiware.org
https://lists.fiware.org/listinfo/fiware-tech-help
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@fiware.org>
Cc: fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; PC00474884@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 <http://www.techmahindra.com/Disclaimer.html> externally http://tim.techmahindra.com/tim/disclaimer.html <http://tim.techmahindra.com/tim/disclaimer.html> internally within TechMahindra.
============================================================================================================================
Hi All,
Any input on below error?
Do we need to run any SQL script manually before starting Knowage server?
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 18, 2018 6:15 PM
To: 'José Ignacio Carretero' <joseignacio.carretero@fiware.org>; Portosa Alessandro <Alessandro.Portosa@eng.it>; Juanjo Hierro <juanjose.hierro@fiware.org>; fiware-tech-help@lists.fiware.org; Fernando López Aguilar <fernando.lopez@fiware.org>
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; Álvaro Arranz <aarranz@ficodes.com>; Francisco de la Vega <fdelavega@ficodes.com>; Zerbetto Davide <davide.zerbetto@eng.it>
Subject: RE: [Fiware-tech-help] How to fetch historical data?
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@fiware.org<joseignacio.carretero@fiware.org
>>
>>; Krishan Babbar <KB00449283@TechMahindra.com<KB00449283@TechMahindra.com
>>; Juanjo Hierro <juanjose.hierro@fiware.org<juanjose.hierro@fiware.org
>>; fiware-tech-help@lists.fiware.org<fiware-tech-help@lists.fiware.org
>; Fernando López Aguilar <fernando.lopez@fiware.org<fernando.lopez@fiware.org
>>
>>; Yugal Kishor Mullick <YM00106030@TechMahindra.com<YM00106030@TechMahindra.com
>>; Álvaro Arranz <aarranz@ficodes.com<aarranz@ficodes.com
>>; Francisco de la Vega <fdelavega@ficodes.com<fdelavega@ficodes.com
>>; Zerbetto Davide <davide.zerbetto@eng.it<davide.zerbetto@eng.it
>>
Sent: Thursday, May 17, 2018 7:27 PM
To: Portosa Alessandro <Alessandro.Portosa@eng.it<Alessandro.Portosa@eng.it
Cc: Prashant Chauhan1 <PC00474884@TechMahindra.com<PC00474884@TechMahindra.com
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.