Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » 'Select *' query always generates error
'Select *' query always generates error [message #198044] Fri, 27 October 2006 16:08 Go to next message
Eclipse UserFriend
Originally posted by: goykhmanster.gmail.com

Hi

I am having a problem with BIRT report viewer.
Any time my query text has 'select *' in it (select all columns), i get
the following error on the report page:

Exception in:
ReportEngineService.runReport( )

Error happended while running the report

I am using BIRT report viewer 2.0.2 with Eclipse 3.1.

Has any of you ever got this problem? Is there a workaround? I would
appreciate any help. Thanks in advance.

Report message to a moderator

Re: 'Select *' query always generates error [message #198211 is a reply to message #198044] Mon, 30 October 2006 02:44 Go to previous messageGo to next message
Mingxia Wu is currently offline Mingxia WuFriend
Messages: 25
Registered: July 2009
Junior Member
Can you get any error when you preview result in dataset editor page?Could
you please attach the detailed exception trace on the report page?

Thanks
Mingxia
"Boris" <goykhmanster@gmail.com> wrote in message
news:11b4d5f698e226f26f1e099cab48009c$1@www.eclipse.org...
> Hi
>
> I am having a problem with BIRT report viewer. Any time my query text has
> 'select *' in it (select all columns), i get the following error on the
> report page:
>
> Exception in:
> ReportEngineService.runReport( )
>
> Error happended while running the report
>
> I am using BIRT report viewer 2.0.2 with Eclipse 3.1.
>
> Has any of you ever got this problem? Is there a workaround? I would
> appreciate any help. Thanks in advance.
>

Report message to a moderator

Re: 'Select *' query always generates error [message #198348 is a reply to message #198211] Mon, 30 October 2006 15:48 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: goykhmanster.gmail.com

This is the error from dataset editor:

An unexpected internal exception occurred.Please see log for detail.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Designer UI
Plug-in ID:org.eclipse.birt.report.designer.ui
Version:2.0.2
Error Code:Error.GUIException.invokedByUnexpectedException
Error Message:IClob.getSubString()

Report message to a moderator

Re: 'Select *' query always generates error [message #198385 is a reply to message #198348] Tue, 31 October 2006 02:24 Go to previous messageGo to next message
Mingxia Wu is currently offline Mingxia WuFriend
Messages: 25
Registered: July 2009
Junior Member
Boris,
It seems that your table contains Clob column....Could you please tell me
the database and jdbc driver you used?

Thanks
Mingxia
"Boris" <goykhmanster@gmail.com> wrote in message
news:898e2534c4d11aab9bf4bbe108ace096$1@www.eclipse.org...
> This is the error from dataset editor:
>
> An unexpected internal exception occurred.Please see log for detail.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Designer UI
> Plug-in ID:org.eclipse.birt.report.designer.ui
> Version:2.0.2
> Error Code:Error.GUIException.invokedByUnexpectedException
> Error Message:IClob.getSubString()
>
>
>
>

Report message to a moderator

Re: 'Select *' query always generates error [message #198438 is a reply to message #198385] Tue, 31 October 2006 18:24 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: bgoykhman.hotmail.com

Hmm... Thanks for pointing that out...

I am using Oracle Thin driver. Should i use OCI driver instead?

Report message to a moderator

Re: 'Select *' query always generates error [message #198594 is a reply to message #198438] Wed, 01 November 2006 03:34 Go to previous messageGo to next message
Mingxia Wu is currently offline Mingxia WuFriend
Messages: 25
Registered: July 2009
Junior Member
Hi Boris,
Oracle Thin driver should also support Clob datatype. Maybe you could try
the latest version of Birt. BTW, could you provide the detailed error log
information in Error Log perspective? Thanks a lot.

Mingxia

"Boris" <bgoykhman@hotmail.com> wrote in message
news:ff9ab5f83da359b299c945aef911337e$1@www.eclipse.org...
> Hmm... Thanks for pointing that out...
>
> I am using Oracle Thin driver. Should i use OCI driver instead?
>

Report message to a moderator

Re: 'Select *' query always generates error [message #198642 is a reply to message #198594] Wed, 01 November 2006 18:24 Go to previous message
Eclipse UserFriend
Originally posted by: bgoykhman.hotmail.com

Error 2006-10-31 14:30:29.196 Error Message:IClob.getSubString()
Error 2006-10-31 14:30:29.196 Error
Code:Error.GUIException.invokedByUnexpectedException
Info 2006-10-31 14:30:29.196 Version:2.0.2
Info 2006-10-31 14:30:29.196 Plug-in ID:org.eclipse.birt.report.designer.ui
Info 2006-10-31 14:30:29.196 Plug-in Name:BIRT Designer UI
Info 2006-10-31 14:30:29.196 Plug-in Provider:Eclipse.org

Report message to a moderator

Previous Topic:ODA Extension
Next Topic:Storing custom metadata in rptdesign file?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 20 03:32:40 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly