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>>
Sent: Thursday, May 17, 2018 7:27 PM
To: Portosa Alessandro <Alessandro.Portosa@eng.it<Alessandro.Portosa@eng.it>>; 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>>
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?
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.
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>>
Sent: Thursday, May 17, 2018 7:27 PM
To: Portosa Alessandro <Alessandro.Portosa@eng.it<Alessandro.Portosa@eng.it>>; 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>>
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?
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.