[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 
New Data Source  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
giulio gusella.spw



Joined: 12/01/2012 10:50:45
Messages: 8
Offline

Hi guys,
after the db configuration (post solved last week), I would to configure a new datasource.
I follow this tutorial:
http://www.robertomarchetto.com/www/tutorial_spagobi_jasper_report

I compile the form, test connection was ok, but when i return on "Data Source", this message appear:

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'DS_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5073) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:290) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:263) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:191) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:87) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:3 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:423) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:263) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:191) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:87) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:3 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:423) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662)
Parent not avalaible

Why?
Please Help Me!

Thanks!
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

Column 'DS_ID' not found

This could happens fro three mai reasons...

1. the version of SpagoBI's metadata database that you have installed on your mysql does not match with the version of SpagoBI Server.
2. you do not have properly configured the hibernate dialect as described in the wiki
3. there is a problem with the configuration of the query engine of your databese. the column ds_id exists but the query engine works in a case sensitive (ds_id <> DS_ID).

Regards,
aG

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
siladityadash.spw

Newby

Joined: 02/04/2013 08:38:47
Messages: 15
Offline

Hi,

Someone have some solution for the above issue as I'm also getting the same issue. Tried to findout the points which angioia suggested, but that also not solving my problem.
1. the version of SpagoBI's metadata database that you have installed on your mysql does not match with the version of SpagoBI Server.
For me both of the versions are same only as I'm using both on single server.
2. you do not have properly configured the hibernate dialect as described in the wiki
I followed the wiki document to configure the hibernate dialect.
3. there is a problem with the configuration of the query engine of your databese. the column ds_id exists but the query engine works in a case sensitive (ds_id <> DS_ID).
I searched in all the metadata tables and found some table having the same name 'DS_ID' as the column name. So it should not be the issue as the error is showing that its missing the column 'DS_ID' not 'ds_id'

thanks..
Aditya
alexbaron77.spw



Joined: 21/11/2014 17:14:18
Messages: 7
Offline

Hi,

i reload the sql script MySQL_create.sql and Mysql_Create_quartz_schema.sql
and restart TOMCAT.

I 've no more problem.
ashokraman.spw



Joined: 16/12/2014 13:57:11
Messages: 3
Offline

My setup is similar to Aditya's. There must be a better solution than just recreating the db and re-running the scripts?

Despite recreating the database and re-running the scripts, the issue persists. Created a datasource, entry is inserted into sbi_data_source table, however after a restart, the same error comes up on selecting datasource menu. However, creating a user works fine.... So problem seems to be around creation/selection of data_source or data_set.

Thanks for any help,
Ashok

This message was edited 1 time. Last update was at 16/12/2014 16:24:12

ashokraman.spw



Joined: 16/12/2014 13:57:11
Messages: 3
Offline

I modified server.xml's url specification to

url="jdbc:mysql://localhost/spagobi?useOldAliasMetadataBehavior=true"

based on https://forum.hibernate.org/viewtopic.php?f=1&t=1006399 & http://bugs.mysql.com/bug.php?id=35150 to deal with MySQL incompatibilities -

this seems to work, will need more testing.....

Thanks,
waschult.spw

Newby

Joined: 16/01/2014 09:07:52
Messages: 33
Offline

Hallo,

i'd similar issue. The solution was ?useOldAliasMetadataBehavior=true

Regards,
Walter
gassantos.spw



Joined: 31/07/2015 15:40:11
Messages: 2
Offline

Thanks, ashokraman!

I put at the url "?useOldAliasMetadataBehavior=true" and all right.

Very good!
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team