[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: zsoltputnoky.spw
Forum Index » Profile for zsoltputnoky.spw » Messages posted by zsoltputnoky.spw
Author Message
Hi Community,

Is there a way to copy a QBE document from one user to another one? I created some models with the Studio and deployed on the server. They all comes under the biadmin folder. I would like to use these documents when not logged in as biadmin but ordinary user. Can I copy them into other folders?

Thanks alot for your help,

Zsolt Putnoky
luissantos.spw wrote:Hello comunity

I want to know step-by-step how can i install your opensource bi SpagoBI on my laptop.
I need to know what package i need to run and also some important informations.
My laptop like i say have Win 7 x64 with Sql server 2008 R2.
I hope someone could me some help and useful tips to sucessfully install SpagoBi.

Best regards,
Luis Santos


Hi Luis,

I just did that, so let me know if you still have the issues. I might be able to help.

My config -test in the office - is Win7 64bit OS, MySQL Community Edition for the SpagoBI db, MS SQL 2008 R2 Full/Express for DWH, SpagoBI 3.6.0 for BI Engine.

Though I am still smarting out details, installation was done and it works.

Zsolt

Issue fixed with the help of Spago! Many thanks!

When created the data source under SpagoBI, I left the dialect as Default. This caused the :-1 problem. Once it is changed, this problem is gone and new appeared :)
Dear All,

I am evaluating SpagoBI as a dashboard/reporting tool. Currently using the All-in-one version on a Win 7 64 bit machine, with MS SQL 2008 R2 DB engine.

Created a BM and a query in SpagoStudio 3.6, all works fine there. Deployed to the server and it appears all right. However when I try to execute the query I receive the following message: Unexpected Error Occurred While Executing Dataset: -1.

Searched the forums and found some ideas, unfortunately none of them seems to work. Trace below:

"type":"datamartField","id":"it.eng.spagobi.meta.Task:task_id","entity":"TASK","
field":"Task id","longDescription":"TASK : Task id","group":"","funct":"NONE","i
conCls":"attribute","nature":"attribute"},{"alias":"Proj id","visible":true,"inc
lude":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:proj_id","entit
y":"TASK","field":"Proj id","longDescription":"TASK : Proj id","group":"","funct
":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Wbs id","visible"
:true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:wbs_i
d","entity":"TASK","field":"Wbs id","longDescription":"TASK : Wbs id","group":""
,"funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Task name"
,"visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.
Task:task_name","entity":"TASK","field":"Task name","longDescription":"TASK : Ta
sk name","group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{
"alias":"Rsrc name","visible":true,"include":true,"type":"datamartField","id":"i
t.eng.spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_name","en
tity":"RSRC","field":"Rsrc name","longDescription":"TASK / RSRC : Rsrc name","gr
oup":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Rsr
c short name","visible":true,"include":true,"type":"datamartField","id":"it.eng.
spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_short_name","en
tity":"RSRC","field":"Rsrc short name","longDescription":"TASK / RSRC : Rsrc sho
rt name","group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{
"alias":"Rsrc id","visible":true,"include":true,"type":"datamartField","id":"it.
eng.spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_id","entity
":"RSRC","field":"Rsrc id","longDescription":"TASK / RSRC : Rsrc id","group":"",
"funct":"NONE","iconCls":"attribute","nature":"attribute"}]
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:197)
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeQue
ry(QueryJSONDeserializer.java:87)
at it.eng.qbe.dataset.QbeDataSet.getCatalogue(QbeDataSet.java:247)
... 30 more
Caused by: it.eng.qbe.serializer.SerializationException: An error occurred while
deserializing field [[{"alias":"Task id","visible":true,"include":true,"type":"
datamartField","id":"it.eng.spagobi.meta.Task:task_id","entity":"TASK","field":"
Task id","longDescription":"TASK : Task id","group":"","funct":"NONE","iconCls":
"attribute","nature":"attribute"},{"alias":"Proj id","visible":true,"include":tr
ue,"type":"datamartField","id":"it.eng.spagobi.meta.Task:proj_id","entity":"TASK
","field":"Proj id","longDescription":"TASK : Proj id","group":"","funct":"NONE"
,"iconCls":"attribute","nature":"attribute"},{"alias":"Wbs id","visible":true,"i
nclude":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:wbs_id","enti
ty":"TASK","field":"Wbs id","longDescription":"TASK : Wbs id","group":"","funct"
:"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Task name","visibl
e":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:tas
k_name","entity":"TASK","field":"Task name","longDescription":"TASK : Task name"
,"group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":
"Rsrc name","visible":true,"include":true,"type":"datamartField","id":"it.eng.sp
agobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_name","entity":"R
SRC","field":"Rsrc name","longDescription":"TASK / RSRC : Rsrc name","group":"",
"funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Rsrc short
name","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.
meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_short_name","entity":"R
SRC","field":"Rsrc short name","longDescription":"TASK / RSRC : Rsrc short name"
,"group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":
"Rsrc id","visible":true,"include":true,"type":"datamartField","id":"it.eng.spag
obi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_id","entity":"RSRC"
,"field":"Rsrc id","longDescription":"TASK / RSRC : Rsrc id","group":"","funct":
"NONE","iconCls":"attribute","nature":"attribute"}]] of query [q1354541501665]
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:193)
... 32 more
Caused by: java.lang.RuntimeException: Impossible to build model structure
at it.eng.qbe.model.structure.builder.jpa.JPAModelStructureBuilder.build
(JPAModelStructureBuilder.java:175)
at it.eng.qbe.datasource.jpa.JPADataSource.getModelStructure(JPADataSour
ce.java:139)
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:151)
... 32 more
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: PF_P6] Unab
le to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:912)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(Hib
ernatePersistence.java:57)
at javax.persistence.Persistence.createEntityManagerFactory(Unknown Sour
ce)
at it.eng.qbe.datasource.jpa.JPADataSource.initEntityManagerFactory(JPAD
ataSource.java:71)
at it.eng.qbe.datasource.jpa.JPADataSource.open(JPADataSource.java:116)
at it.eng.qbe.datasource.jpa.JPADataSource.getEntityManager(JPADataSourc
e.java:96)
at it.eng.qbe.model.structure.builder.jpa.JPAModelStructureBuilder.build
(JPAModelStructureBuilder.java:82)
... 34 more
Caused by: org.hibernate.HibernateException: Dialect class not found: -1
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(Dialec
tFactory.java:159)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFac
tory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
130)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2836)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2832
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1843)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:903)
... 40 more
Caused by: java.lang.ClassNotFoundException: -1
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1233)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)

at org.hibernate.dialect.resolver.DialectFactory.constructDialect(Dialec
tFactory.java:156)
... 46 more
it.eng.spagobi.commons.utilities.SpagoBIServiceExceptionHandler.logError: The er
ror full stack trace is:
it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error
occured while executing dataset: -1
at it.eng.spagobi.commons.utilities.SpagoBIServiceExceptionHandler.getWr
appedException(SpagoBIServiceExceptionHandler.java:86)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.handleException
(AbstractSpagoBIAction.java:163)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(Abstrac
tSpagoBIAction.java:70)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusine
ss(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoord
inator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.
java:41
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.j
ava:109)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter
(SpagoBICoreCheckSessionFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Thread.java:619)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexp
ected error occured while executing dataset: -1
at it.eng.spagobi.tools.dataset.service.ManageDatasets.getDatasetTestRes
ultList(ManageDatasets.java:1032)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.getDataSetResults
AsJSON(ManageDatasets.java:623)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.datatsetTest(Mana
geDatasets.java:213)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.doService(ManageD
atasets.java:105)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(Abstrac
tSpagoBIAction.java:6
... 22 more
Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Impos
sible to deserialize catalogue
at it.eng.qbe.dataset.QbeDataSet.getCatalogue(QbeDataSet.java:252)
at it.eng.qbe.dataset.QbeDataSet.init(QbeDataSet.java:82)
at it.eng.qbe.dataset.QbeDataSet.loadData(QbeDataSet.java:99)
at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.test(Configurable
DataSet.java:209)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.getDatasetTestRes
ultList(ManageDatasets.java:1012)
... 26 more
Caused by: it.eng.qbe.serializer.SerializationException: An error occurred while
deserializing select clause: [{"alias":"Task id","visible":true,"include":true,
"type":"datamartField","id":"it.eng.spagobi.meta.Task:task_id","entity":"TASK","
field":"Task id","longDescription":"TASK : Task id","group":"","funct":"NONE","i
conCls":"attribute","nature":"attribute"},{"alias":"Proj id","visible":true,"inc
lude":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:proj_id","entit
y":"TASK","field":"Proj id","longDescription":"TASK : Proj id","group":"","funct
":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Wbs id","visible"
:true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:wbs_i
d","entity":"TASK","field":"Wbs id","longDescription":"TASK : Wbs id","group":""
,"funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Task name"
,"visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.
Task:task_name","entity":"TASK","field":"Task name","longDescription":"TASK : Ta
sk name","group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{
"alias":"Rsrc name","visible":true,"include":true,"type":"datamartField","id":"i
t.eng.spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_name","en
tity":"RSRC","field":"Rsrc name","longDescription":"TASK / RSRC : Rsrc name","gr
oup":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Rsr
c short name","visible":true,"include":true,"type":"datamartField","id":"it.eng.
spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_short_name","en
tity":"RSRC","field":"Rsrc short name","longDescription":"TASK / RSRC : Rsrc sho
rt name","group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{
"alias":"Rsrc id","visible":true,"include":true,"type":"datamartField","id":"it.
eng.spagobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_id","entity
":"RSRC","field":"Rsrc id","longDescription":"TASK / RSRC : Rsrc id","group":"",
"funct":"NONE","iconCls":"attribute","nature":"attribute"}]
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:197)
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeQue
ry(QueryJSONDeserializer.java:87)
at it.eng.qbe.dataset.QbeDataSet.getCatalogue(QbeDataSet.java:247)
... 30 more
Caused by: it.eng.qbe.serializer.SerializationException: An error occurred while
deserializing field [[{"alias":"Task id","visible":true,"include":true,"type":"
datamartField","id":"it.eng.spagobi.meta.Task:task_id","entity":"TASK","field":"
Task id","longDescription":"TASK : Task id","group":"","funct":"NONE","iconCls":
"attribute","nature":"attribute"},{"alias":"Proj id","visible":true,"include":tr
ue,"type":"datamartField","id":"it.eng.spagobi.meta.Task:proj_id","entity":"TASK
","field":"Proj id","longDescription":"TASK : Proj id","group":"","funct":"NONE"
,"iconCls":"attribute","nature":"attribute"},{"alias":"Wbs id","visible":true,"i
nclude":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:wbs_id","enti
ty":"TASK","field":"Wbs id","longDescription":"TASK : Wbs id","group":"","funct"
:"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Task name","visibl
e":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Task:tas
k_name","entity":"TASK","field":"Task name","longDescription":"TASK : Task name"
,"group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":
"Rsrc name","visible":true,"include":true,"type":"datamartField","id":"it.eng.sp
agobi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_name","entity":"R
SRC","field":"Rsrc name","longDescription":"TASK / RSRC : Rsrc name","group":"",
"funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Rsrc short
name","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.
meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_short_name","entity":"R
SRC","field":"Rsrc short name","longDescription":"TASK / RSRC : Rsrc short name"
,"group":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":
"Rsrc id","visible":true,"include":true,"type":"datamartField","id":"it.eng.spag
obi.meta.Task::rel_rsrc_id_in_rsrc(rel_rsrc_id_in_rsrc):rsrc_id","entity":"RSRC"
,"field":"Rsrc id","longDescription":"TASK / RSRC : Rsrc id","group":"","funct":
"NONE","iconCls":"attribute","nature":"attribute"}]] of query [q1354541501665]
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:193)
... 32 more
Caused by: java.lang.RuntimeException: Impossible to build model structure
at it.eng.qbe.model.structure.builder.jpa.JPAModelStructureBuilder.build
(JPAModelStructureBuilder.java:175)
at it.eng.qbe.datasource.jpa.JPADataSource.getModelStructure(JPADataSour
ce.java:139)
at it.eng.qbe.query.serializer.json.QueryJSONDeserializer.deserializeFie
lds(QueryJSONDeserializer.java:151)
... 32 more
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: PF_P6] Unab
le to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:912)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(Hib
ernatePersistence.java:57)
at javax.persistence.Persistence.createEntityManagerFactory(Unknown Sour
ce)
at it.eng.qbe.datasource.jpa.JPADataSource.initEntityManagerFactory(JPAD
ataSource.java:71)
at it.eng.qbe.datasource.jpa.JPADataSource.open(JPADataSource.java:116)
at it.eng.qbe.datasource.jpa.JPADataSource.getEntityManager(JPADataSourc
e.java:96)
at it.eng.qbe.model.structure.builder.jpa.JPAModelStructureBuilder.build
(JPAModelStructureBuilder.java:82)
... 34 more
Caused by: org.hibernate.HibernateException: Dialect class not found: -1
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(Dialec
tFactory.java:159)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFac
tory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
130)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2836)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2832
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1843)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con
figuration.java:903)
... 40 more
Caused by: java.lang.ClassNotFoundException: -1
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1233)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)

at org.hibernate.dialect.resolver.DialectFactory.constructDialect(Dialec
tFactory.java:156)
... 46 more

Any ideas?

Unfortunately, DB engine cannot be changed as I am modelling a Client environment.

I appreciate your help,

Zsolt Putnoky
 
Forum Index » Profile for zsoltputnoky.spw » Messages posted by zsoltputnoky.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team