Data Cube Creation Issue - using Kerberos connection - [message #671077] |
Mon, 16 May 2011 17:33 |
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 |
|
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}
|
|
|
Powered by
FUDForum. Page generated in 0.02809 seconds