Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data Cube Creation Issue - using Kerberos connection -
Data Cube Creation Issue - using Kerberos connection - [message #671077] Mon, 16 May 2011 17:33 Go to next message
No real name is currently offline No real name
Messages: 1
Registered: May 2011
Junior Member
Hi,

I have a report that runs ok, when I have my jndi data source setup, to connect as the owner of the tables it's querying.

When I change the JNDI datasource, to use a kerberos connection (this user Id will be different from the table owner, my report will not run). I have created public synonyms for the tables being queried, and granted select privileges.

If I run without kerberos, but connecting as a user different that doesn't own the tables, the report fails also.

The stack traces are below.

Any ideas on why the cube creation would fail? I assume it's metadata related?
Is there any suitable logging I can turn on in birt to help diagnose the problem?


Aside, I see that it reverts back to JDBC when the queries fails - I do not have the jdbc connection details configured for these reports - I assume this is normal.

{code}
May 16, 2011 12:10:39 PM org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor execute

SEVERE: An exception occurred during processing. Please see the following message for details:

exception.error

Error happens when create hierarchy:USer.NewTabularHierarchy.

org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:

exception.error

Error happens when create hierarchy:USer.NewTabularHierarchy.

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:637)

at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteCube(DteDataEngine.java:222)

at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteCube(DataGenerationEngine.java:93)

at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:270)

at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.executeQueries(ExtendedGenerateExecutor.java:205)

at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.execute(ExtendedGenerateExecutor.java:65)

at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:62)

at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)

at org.eclipse.birt.report.engine.internal.executor.emitter.Rep ortItemEmitterExecutor.execute(ReportItemEmitterExecutor.jav a:46)

at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)

at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)

at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)

at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)

at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)

at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)

at org.eclipse.birt.report.engine.presentation.ReportDocumentBu ilder.build(ReportDocumentBuilder.java:249)

at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:260)



at org.apache.jk.common.ChannelSocket.processConnection(Channel Socket.java:703)

at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(Ch annelSocket.java:896)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:690)

at java.lang.Thread.run(Thread.java:619)

Caused by: org.eclipse.birt.data.engine.core.DataException: exception.error

Error happens when create hierarchy:USer.NewTabularHierarchy.

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.materializeCube(DataRequestSessionImpl.java:754)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:626)

... 95 more

Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Error happens when create hierarchy:USer.NewTabularHierarchy.

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.populateDimension(DataRequestSessionImpl.java:1358)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.populateDimensions(DataRequestSessionImpl.java:1204)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.createCube(DataRequestSessionImpl.java:797)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.materializeCube(DataRequestSessionImpl.java:746)

... 96 more

Caused by: java.lang.NullPointerException

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:169)

at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:724)

at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)

at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:255)

at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)

at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:235)

at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:250)

at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:165)

at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:222)

at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:210)

at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:208)

at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:406)

at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:316)

at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)

at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:145)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:159)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:142)

at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.ex ecuteQuery(DataSetIterator.java:84)

at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.<init >(DataSetIterator.java:121)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.populateDimension(DataRequestSessionImpl.java:1331)

{code}
Re: Data Cube Creation Issue - using Kerberos connection - [message #671094 is a reply to message #671077] Mon, 16 May 2011 18:15 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you open a bug for this?

Jason

On 5/16/2011 1:33 PM, forums-noreply@eclipse.org wrote:
> Hi,
>
> I have a report that runs ok, when I have my jndi data
> source setup, to connect as the owner of the tables it's
> querying.
>
> When I change the JNDI datasource, to use a kerberos
> connection (this user Id will be different from the table
> owner, my report will not run). I have created public
> synonyms for the tables being queried, and granted select
> privileges.
>
> If I run without kerberos, but connecting as a user
> different that doesn't own the tables, the report fails
> also.
>
> The stack traces are below.
> Any ideas on why the cube creation would fail? I assume
> it's metadata related? Is there any suitable logging I can turn on in
> birt to help
> diagnose the problem?
>
>
> Aside, I see that it reverts back to JDBC when the queries
> fails - I do not have the jdbc connection details
> configured for these reports - I assume this is normal.
>
> {code}
> May 16, 2011 12:10:39 PM
> org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor execute
>
> SEVERE: An exception occurred during processing. Please see
> the following message for details:
>
> exception.error
>
> Error happens when create
> hierarchy:USer.NewTabularHierarchy.
>
> org.eclipse.birt.report.data.adapter.api.AdapterException:
> An exception occurred during processing. Please see the
> following message for details:
>
> exception.error
>
> Error happens when create
> hierarchy:USer.NewTabularHierarchy.
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:637)
>
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteCube(DteDataEngine.java:222)
>
> at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine
> doExecuteCube(DataGenerationEngine.java:93)
>
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:270)
>
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.executeQueries(ExtendedGenerateExecutor.java:205)
>
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.execute(ExtendedGenerateExecutor.java:65)
>
> at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor
> execute(ExtendedItemExecutor.java:62)
>
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4
> 6)
>
> at org.eclipse.birt.report.engine.internal.executor.emitter.Rep
> ortItemEmitterExecutor.execute(ReportItemEmitterExecutor.jav
> a:46)
>
> at org.eclipse.birt.report.engine.internal.executor.dup.Suppres
> sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor
> java:43)
>
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4
> 6)
>
> at org.eclipse.birt.report.engine.internal.executor.l18n.Locali
> zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja
> va:34)
>
> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:65)
>
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:90)
>
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:99)
>
> at org.eclipse.birt.report.engine.presentation.ReportDocumentBu
> ilder.build(ReportDocumentBuilder.java:249)
>
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas
> k.java:260)
>
>
>
> at org.apache.jk.common.ChannelSocket.processConnection(Channel
> Socket.java:703)
>
> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(Ch
> annelSocket.java:896)
>
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
> n(ThreadPool.java:690)
>
> at java.lang.Thread.run(Thread.java:619)
>
> Caused by: org.eclipse.birt.data.engine.core.DataException:
> exception.error
>
> Error happens when create
> hierarchy:USer.NewTabularHierarchy.
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.materializeCube(DataRequestSessionImpl.java:754)
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:626)
>
> ... 95 more
>
> Caused by:
> org.eclipse.birt.report.data.adapter.api.AdapterException:
> Error happens when create
> hierarchy:USer.NewTabularHierarchy.
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.populateDimension(DataRequestSessionImpl.java:1358)
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.populateDimensions(DataRequestSessionImpl.java:1204)
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.createCube(DataRequestSessionImpl.java:797)
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.materializeCube(DataRequestSessionImpl.java:746)
>
> ... 96 more
>
> Caused by: java.lang.NullPointerException
>
> at java.lang.Class.forName0(Native Method)
>
> at java.lang.Class.forName(Class.java:169)
>
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find
> Driver(JDBCDriverManager.java:724)
>
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi
> sterDriver(JDBCDriverManager.java:879)
>
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo
> nnect(JDBCDriverManager.java:255)
>
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC
> onnection(JDBCDriverManager.java:212)
>
> at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr
> l(Connection.java:235)
>
> at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec
> tion.java:160)
>
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo
> nnection.open(OdaConnection.java:250)
>
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:165)
>
> at org.eclipse.birt.data.engine.executor.DataSource.newConnecti
> on(DataSource.java:222)
>
> at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo
> urce.java:210)
>
> at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD
> ataSource(DataSourceRuntime.java:208)
>
> at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour
> ce(QueryExecutor.java:406)
>
> at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu
> tion(QueryExecutor.java:316)
>
> at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr
> eparedQuery.java:448)
>
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr
> oduceQueryResults(PreparedDataSourceQuery.java:190)
>
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:178)
>
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute
> (PreparedOdaDSQuery.java:145)
>
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:159)
>
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:142)
>
> at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.ex
> ecuteQuery(DataSetIterator.java:84)
>
> at
> org.eclipse.birt.report.data.adapter.impl.DataSetIterator.<init
>> (DataSetIterator.java:121)
>
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.populateDimension(DataRequestSessionImpl.java:1331)
>
> {code}
Previous Topic:data source
Next Topic:Plugin not visible in Report Designer View
Goto Forum:
  


Current Time: Sat Sep 20 14:18:40 GMT 2014

Powered by FUDForum. Page generated in 0.01624 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software