Home » Archived » BIRT » /run works; /frameset = no data; __format=pdf errors out
| /run works; /frameset = no data; __format=pdf errors out [message #230441] |
Mon, 26 March 2007 13:42  |
Eclipse User |
|
|
|
The good news: I'm getting consistent behavior between the BIRT designer
in the IDE and the BIRT runtime in my application.
What I'm stuck on now:
Background: I got BIRT through the Callisto update site.
I've used JDBC to produce a simple BIRT report off of one table. In the
BIRT designer, if I click the "preview" tab (equivalent to calling /run,
I think), everything works. Similarly, if I choose "view report as
HTML" on the toolbar, this works.
However, choosing "View Report in Web Viewer" on the tool bar results in
my report running, but no data appearing. I see my title table, the
header band, and the date/time the report was run in the footer, but no
data in between.
Also, choosing "View Report as PDF" on the tool bar results in the
following error message in the popup browser window:
org.eclipse.birt.report.service.api.ReportServiceException: Report
engine fails to create extension to handle this request.
I get exactly the same behavior in my application. Hopefully, if I can
get BIRT to run properly in the IDE, I can get it to run properly in my
application. :-)
Regards,
Dave Orme
--
Senior Consultant, Trainer
Coconut Palm Software, Inc.
http://www.coconut-palm-software.com
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230449 is a reply to message #230441] |
Mon, 26 March 2007 13:48  |
| Eclipse User |
|
|
|
One additional data point:
Clicking the "Export Data" button in the frameset version successfully
exports the correct data. :-?
Dave
David J. Orme wrote:
> The good news: I'm getting consistent behavior between the BIRT designer
> in the IDE and the BIRT runtime in my application.
>
> What I'm stuck on now:
>
> Background: I got BIRT through the Callisto update site.
>
> I've used JDBC to produce a simple BIRT report off of one table. In the
> BIRT designer, if I click the "preview" tab (equivalent to calling /run,
> I think), everything works. Similarly, if I choose "view report as
> HTML" on the toolbar, this works.
>
> However, choosing "View Report in Web Viewer" on the tool bar results in
> my report running, but no data appearing. I see my title table, the
> header band, and the date/time the report was run in the footer, but no
> data in between.
>
> Also, choosing "View Report as PDF" on the tool bar results in the
> following error message in the popup browser window:
>
> org.eclipse.birt.report.service.api.ReportServiceException: Report
> engine fails to create extension to handle this request.
>
> I get exactly the same behavior in my application. Hopefully, if I can
> get BIRT to run properly in the IDE, I can get it to run properly in my
> application. :-)
>
>
> Regards,
>
> Dave Orme
--
Senior Consultant, Trainer
Coconut Palm Software, Inc.
http://www.coconut-palm-software.com
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230520 is a reply to message #230449] |
Mon, 26 March 2007 17:05 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Dave,
Is there any chance you could try the allinone download? Also can you
log a bug with this issue. This appears to be happening with some users
that use the update manager.
Jason
David J. Orme wrote:
> One additional data point:
>
> Clicking the "Export Data" button in the frameset version successfully
> exports the correct data. :-?
>
>
> Dave
>
> David J. Orme wrote:
>> The good news: I'm getting consistent behavior between the BIRT
>> designer in the IDE and the BIRT runtime in my application.
>>
>> What I'm stuck on now:
>>
>> Background: I got BIRT through the Callisto update site.
>>
>> I've used JDBC to produce a simple BIRT report off of one table. In
>> the BIRT designer, if I click the "preview" tab (equivalent to calling
>> /run, I think), everything works. Similarly, if I choose "view report
>> as HTML" on the toolbar, this works.
>>
>> However, choosing "View Report in Web Viewer" on the tool bar results
>> in my report running, but no data appearing. I see my title table,
>> the header band, and the date/time the report was run in the footer,
>> but no data in between.
>>
>> Also, choosing "View Report as PDF" on the tool bar results in the
>> following error message in the popup browser window:
>>
>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>> engine fails to create extension to handle this request.
>>
>> I get exactly the same behavior in my application. Hopefully, if I
>> can get BIRT to run properly in the IDE, I can get it to run properly
>> in my application. :-)
>>
>>
>> Regards,
>>
>> Dave Orme
>
>
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230544 is a reply to message #230520] |
Mon, 26 March 2007 17:42 |
| Eclipse User |
|
|
|
https://bugs.eclipse.org/bugs/show_bug.cgi?id=179395
Jason Weathersby wrote:
> Dave,
>
> Is there any chance you could try the allinone download? Also can you
> log a bug with this issue. This appears to be happening with some users
> that use the update manager.
>
> Jason
>
>
> David J. Orme wrote:
>> One additional data point:
>>
>> Clicking the "Export Data" button in the frameset version successfully
>> exports the correct data. :-?
>>
>>
>> Dave
>>
>> David J. Orme wrote:
>>> The good news: I'm getting consistent behavior between the BIRT
>>> designer in the IDE and the BIRT runtime in my application.
>>>
>>> What I'm stuck on now:
>>>
>>> Background: I got BIRT through the Callisto update site.
>>>
>>> I've used JDBC to produce a simple BIRT report off of one table. In
>>> the BIRT designer, if I click the "preview" tab (equivalent to
>>> calling /run, I think), everything works. Similarly, if I choose
>>> "view report as HTML" on the toolbar, this works.
>>>
>>> However, choosing "View Report in Web Viewer" on the tool bar results
>>> in my report running, but no data appearing. I see my title table,
>>> the header band, and the date/time the report was run in the footer,
>>> but no data in between.
>>>
>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>> following error message in the popup browser window:
>>>
>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>> engine fails to create extension to handle this request.
>>>
>>> I get exactly the same behavior in my application. Hopefully, if I
>>> can get BIRT to run properly in the IDE, I can get it to run properly
>>> in my application. :-)
>>>
>>>
>>> Regards,
>>>
>>> Dave Orme
>>
>>
--
Senior Consultant, Trainer
Coconut Palm Software, Inc.
http://www.coconut-palm-software.com
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230590 is a reply to message #230544] |
Mon, 26 March 2007 23:52 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Thanks
David J. Orme wrote:
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=179395
>
> Jason Weathersby wrote:
>> Dave,
>>
>> Is there any chance you could try the allinone download? Also can you
>> log a bug with this issue. This appears to be happening with some
>> users that use the update manager.
>>
>> Jason
>>
>>
>> David J. Orme wrote:
>>> One additional data point:
>>>
>>> Clicking the "Export Data" button in the frameset version
>>> successfully exports the correct data. :-?
>>>
>>>
>>> Dave
>>>
>>> David J. Orme wrote:
>>>> The good news: I'm getting consistent behavior between the BIRT
>>>> designer in the IDE and the BIRT runtime in my application.
>>>>
>>>> What I'm stuck on now:
>>>>
>>>> Background: I got BIRT through the Callisto update site.
>>>>
>>>> I've used JDBC to produce a simple BIRT report off of one table. In
>>>> the BIRT designer, if I click the "preview" tab (equivalent to
>>>> calling /run, I think), everything works. Similarly, if I choose
>>>> "view report as HTML" on the toolbar, this works.
>>>>
>>>> However, choosing "View Report in Web Viewer" on the tool bar
>>>> results in my report running, but no data appearing. I see my title
>>>> table, the header band, and the date/time the report was run in the
>>>> footer, but no data in between.
>>>>
>>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>>> following error message in the popup browser window:
>>>>
>>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>>> engine fails to create extension to handle this request.
>>>>
>>>> I get exactly the same behavior in my application. Hopefully, if I
>>>> can get BIRT to run properly in the IDE, I can get it to run
>>>> properly in my application. :-)
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Dave Orme
>>>
>>>
>
>
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230762 is a reply to message #230520] |
Tue, 27 March 2007 12:24 |
| Eclipse User |
|
|
|
I tried the allinone download: same result. Actually, I tried two
permutations:
1) allinone + all my other usual plugins
2) Just the allinone download with no other plugins installed
Unfortunately, neither the web viewer nor the PDF output are working for me.
More data:
My report is a simple Chart of Accounts report--it just lists the
accounts in the accounts table, grouping by account type first, then by
parent_ID second. The SQL query is the following:
SELECT
GL_ACCOUNT_TYPE,
if(trim(GL_ACCOUNT_PARENT_ID)='',null,GL_ACCOUNT_PARENT_ID),
GL_ACCOUNT_ID,
GL_ACCOUNT_CODE,
GL_ACCOUNT_NAME
FROM GL_ACCOUNT;
I just closed Eclipse and found the following warning on sysout:
Mar 27, 2007 11:08:09 AM org.apache.axis.utils.JavaUtils
isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler
and javax.mail.internet.MimeMultipart). Attachment support is disabled.
I have no idea if this means anything...
Anything I can try?
Dave
Jason Weathersby wrote:
> Dave,
>
> Is there any chance you could try the allinone download? Also can you
> log a bug with this issue. This appears to be happening with some users
> that use the update manager.
>
> Jason
>
>
> David J. Orme wrote:
>> One additional data point:
>>
>> Clicking the "Export Data" button in the frameset version successfully
>> exports the correct data. :-?
>>
>>
>> Dave
>>
>> David J. Orme wrote:
>>> The good news: I'm getting consistent behavior between the BIRT
>>> designer in the IDE and the BIRT runtime in my application.
>>>
>>> What I'm stuck on now:
>>>
>>> Background: I got BIRT through the Callisto update site.
>>>
>>> I've used JDBC to produce a simple BIRT report off of one table. In
>>> the BIRT designer, if I click the "preview" tab (equivalent to
>>> calling /run, I think), everything works. Similarly, if I choose
>>> "view report as HTML" on the toolbar, this works.
>>>
>>> However, choosing "View Report in Web Viewer" on the tool bar results
>>> in my report running, but no data appearing. I see my title table,
>>> the header band, and the date/time the report was run in the footer,
>>> but no data in between.
>>>
>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>> following error message in the popup browser window:
>>>
>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>> engine fails to create extension to handle this request.
>>>
>>> I get exactly the same behavior in my application. Hopefully, if I
>>> can get BIRT to run properly in the IDE, I can get it to run properly
>>> in my application. :-)
>>>
>>>
>>> Regards,
>>>
>>> Dave Orme
>>
>>
--
Senior Consultant, Trainer
Coconut Palm Software, Inc.
http://www.coconut-palm-software.com
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #230827 is a reply to message #230762] |
Tue, 27 March 2007 17:52 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
The error you got is an expected error.
If you create a new report off the sample db just using a simpe table
does it work?
Jason
David J. Orme wrote:
> I tried the allinone download: same result. Actually, I tried two
> permutations:
>
> 1) allinone + all my other usual plugins
> 2) Just the allinone download with no other plugins installed
>
> Unfortunately, neither the web viewer nor the PDF output are working for
> me.
>
> More data:
>
> My report is a simple Chart of Accounts report--it just lists the
> accounts in the accounts table, grouping by account type first, then by
> parent_ID second. The SQL query is the following:
>
> SELECT
> GL_ACCOUNT_TYPE,
> if(trim(GL_ACCOUNT_PARENT_ID)='',null,GL_ACCOUNT_PARENT_ID),
> GL_ACCOUNT_ID,
> GL_ACCOUNT_CODE,
> GL_ACCOUNT_NAME
> FROM GL_ACCOUNT;
>
> I just closed Eclipse and found the following warning on sysout:
>
> Mar 27, 2007 11:08:09 AM org.apache.axis.utils.JavaUtils
> isAttachmentSupported
> WARNING: Unable to find required classes (javax.activation.DataHandler
> and javax.mail.internet.MimeMultipart). Attachment support is disabled.
>
>
> I have no idea if this means anything...
>
> Anything I can try?
>
>
> Dave
>
> Jason Weathersby wrote:
>> Dave,
>>
>> Is there any chance you could try the allinone download? Also can you
>> log a bug with this issue. This appears to be happening with some
>> users that use the update manager.
>>
>> Jason
>>
>>
>> David J. Orme wrote:
>>> One additional data point:
>>>
>>> Clicking the "Export Data" button in the frameset version
>>> successfully exports the correct data. :-?
>>>
>>>
>>> Dave
>>>
>>> David J. Orme wrote:
>>>> The good news: I'm getting consistent behavior between the BIRT
>>>> designer in the IDE and the BIRT runtime in my application.
>>>>
>>>> What I'm stuck on now:
>>>>
>>>> Background: I got BIRT through the Callisto update site.
>>>>
>>>> I've used JDBC to produce a simple BIRT report off of one table. In
>>>> the BIRT designer, if I click the "preview" tab (equivalent to
>>>> calling /run, I think), everything works. Similarly, if I choose
>>>> "view report as HTML" on the toolbar, this works.
>>>>
>>>> However, choosing "View Report in Web Viewer" on the tool bar
>>>> results in my report running, but no data appearing. I see my title
>>>> table, the header band, and the date/time the report was run in the
>>>> footer, but no data in between.
>>>>
>>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>>> following error message in the popup browser window:
>>>>
>>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>>> engine fails to create extension to handle this request.
>>>>
>>>> I get exactly the same behavior in my application. Hopefully, if I
>>>> can get BIRT to run properly in the IDE, I can get it to run
>>>> properly in my application. :-)
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Dave Orme
>>>
>>>
>
>
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #231001 is a reply to message #230827] |
Wed, 28 March 2007 15:18 |
| Eclipse User |
|
|
|
Yes, a basic grouped report from the sample data works, both using the
web viewer and as PDF.
So what did I do wrong? Or more to the point, what do I need to fix to
make the web viewer and PDF generator work for me?
Thanks,
Dave Orme
Jason Weathersby wrote:
>
> The error you got is an expected error.
> If you create a new report off the sample db just using a simpe table
> does it work?
>
> Jason
>
> David J. Orme wrote:
>> I tried the allinone download: same result. Actually, I tried two
>> permutations:
>>
>> 1) allinone + all my other usual plugins
>> 2) Just the allinone download with no other plugins installed
>>
>> Unfortunately, neither the web viewer nor the PDF output are working
>> for me.
>>
>> More data:
>>
>> My report is a simple Chart of Accounts report--it just lists the
>> accounts in the accounts table, grouping by account type first, then
>> by parent_ID second. The SQL query is the following:
>>
>> SELECT
>> GL_ACCOUNT_TYPE,
>> if(trim(GL_ACCOUNT_PARENT_ID)='',null,GL_ACCOUNT_PARENT_ID),
>> GL_ACCOUNT_ID,
>> GL_ACCOUNT_CODE,
>> GL_ACCOUNT_NAME
>> FROM GL_ACCOUNT;
>>
>> I just closed Eclipse and found the following warning on sysout:
>>
>> Mar 27, 2007 11:08:09 AM org.apache.axis.utils.JavaUtils
>> isAttachmentSupported
>> WARNING: Unable to find required classes (javax.activation.DataHandler
>> and javax.mail.internet.MimeMultipart). Attachment support is disabled.
>>
>>
>> I have no idea if this means anything...
>>
>> Anything I can try?
>>
>>
>> Dave
>>
>> Jason Weathersby wrote:
>>> Dave,
>>>
>>> Is there any chance you could try the allinone download? Also can
>>> you log a bug with this issue. This appears to be happening with
>>> some users that use the update manager.
>>>
>>> Jason
>>>
>>>
>>> David J. Orme wrote:
>>>> One additional data point:
>>>>
>>>> Clicking the "Export Data" button in the frameset version
>>>> successfully exports the correct data. :-?
>>>>
>>>>
>>>> Dave
>>>>
>>>> David J. Orme wrote:
>>>>> The good news: I'm getting consistent behavior between the BIRT
>>>>> designer in the IDE and the BIRT runtime in my application.
>>>>>
>>>>> What I'm stuck on now:
>>>>>
>>>>> Background: I got BIRT through the Callisto update site.
>>>>>
>>>>> I've used JDBC to produce a simple BIRT report off of one table.
>>>>> In the BIRT designer, if I click the "preview" tab (equivalent to
>>>>> calling /run, I think), everything works. Similarly, if I choose
>>>>> "view report as HTML" on the toolbar, this works.
>>>>>
>>>>> However, choosing "View Report in Web Viewer" on the tool bar
>>>>> results in my report running, but no data appearing. I see my
>>>>> title table, the header band, and the date/time the report was run
>>>>> in the footer, but no data in between.
>>>>>
>>>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>>>> following error message in the popup browser window:
>>>>>
>>>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>>>> engine fails to create extension to handle this request.
>>>>>
>>>>> I get exactly the same behavior in my application. Hopefully, if I
>>>>> can get BIRT to run properly in the IDE, I can get it to run
>>>>> properly in my application. :-)
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> Dave Orme
>>>>
>>>>
>>
>>
--
Senior Consultant, Trainer
Coconut Palm Software, Inc.
http://www.coconut-palm-software.com
|
|
|
| Re: /run works; /frameset = no data; __format=pdf errors out [message #231014 is a reply to message #231001] |
Wed, 28 March 2007 17:57 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Dave,
Did the sample db report work in your setup or just using BIRT alone?
You could also download the TopNpercent report which contains a chart
and try it in your environment.
http://www.eclipse.org/birt/phoenix/examples/solution/
Jason
David J. Orme wrote:
> Yes, a basic grouped report from the sample data works, both using the
> web viewer and as PDF.
>
> So what did I do wrong? Or more to the point, what do I need to fix to
> make the web viewer and PDF generator work for me?
>
>
> Thanks,
>
> Dave Orme
>
> Jason Weathersby wrote:
>>
>> The error you got is an expected error.
>> If you create a new report off the sample db just using a simpe table
>> does it work?
>>
>> Jason
>>
>> David J. Orme wrote:
>>> I tried the allinone download: same result. Actually, I tried two
>>> permutations:
>>>
>>> 1) allinone + all my other usual plugins
>>> 2) Just the allinone download with no other plugins installed
>>>
>>> Unfortunately, neither the web viewer nor the PDF output are working
>>> for me.
>>>
>>> More data:
>>>
>>> My report is a simple Chart of Accounts report--it just lists the
>>> accounts in the accounts table, grouping by account type first, then
>>> by parent_ID second. The SQL query is the following:
>>>
>>> SELECT
>>> GL_ACCOUNT_TYPE,
>>> if(trim(GL_ACCOUNT_PARENT_ID)='',null,GL_ACCOUNT_PARENT_ID),
>>> GL_ACCOUNT_ID,
>>> GL_ACCOUNT_CODE,
>>> GL_ACCOUNT_NAME
>>> FROM GL_ACCOUNT;
>>>
>>> I just closed Eclipse and found the following warning on sysout:
>>>
>>> Mar 27, 2007 11:08:09 AM org.apache.axis.utils.JavaUtils
>>> isAttachmentSupported
>>> WARNING: Unable to find required classes
>>> (javax.activation.DataHandler and javax.mail.internet.MimeMultipart).
>>> Attachment support is disabled.
>>>
>>>
>>> I have no idea if this means anything...
>>>
>>> Anything I can try?
>>>
>>>
>>> Dave
>>>
>>> Jason Weathersby wrote:
>>>> Dave,
>>>>
>>>> Is there any chance you could try the allinone download? Also can
>>>> you log a bug with this issue. This appears to be happening with
>>>> some users that use the update manager.
>>>>
>>>> Jason
>>>>
>>>>
>>>> David J. Orme wrote:
>>>>> One additional data point:
>>>>>
>>>>> Clicking the "Export Data" button in the frameset version
>>>>> successfully exports the correct data. :-?
>>>>>
>>>>>
>>>>> Dave
>>>>>
>>>>> David J. Orme wrote:
>>>>>> The good news: I'm getting consistent behavior between the BIRT
>>>>>> designer in the IDE and the BIRT runtime in my application.
>>>>>>
>>>>>> What I'm stuck on now:
>>>>>>
>>>>>> Background: I got BIRT through the Callisto update site.
>>>>>>
>>>>>> I've used JDBC to produce a simple BIRT report off of one table.
>>>>>> In the BIRT designer, if I click the "preview" tab (equivalent to
>>>>>> calling /run, I think), everything works. Similarly, if I choose
>>>>>> "view report as HTML" on the toolbar, this works.
>>>>>>
>>>>>> However, choosing "View Report in Web Viewer" on the tool bar
>>>>>> results in my report running, but no data appearing. I see my
>>>>>> title table, the header band, and the date/time the report was run
>>>>>> in the footer, but no data in between.
>>>>>>
>>>>>> Also, choosing "View Report as PDF" on the tool bar results in the
>>>>>> following error message in the popup browser window:
>>>>>>
>>>>>> org.eclipse.birt.report.service.api.ReportServiceException: Report
>>>>>> engine fails to create extension to handle this request.
>>>>>>
>>>>>> I get exactly the same behavior in my application. Hopefully, if
>>>>>> I can get BIRT to run properly in the IDE, I can get it to run
>>>>>> properly in my application. :-)
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Dave Orme
>>>>>
>>>>>
>>>
>>>
>
>
|
|
| | | |
| Re: /run works; /frameset = no data; __format=pdf errors out [message #231587 is a reply to message #231537] |
Fri, 30 March 2007 14:14 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Dave,
Just to let you know there is a bugzilla entry for the XML datasource in
2.2M5.
Jason
David J. Orme wrote:
> Log level set.
>
> I've moved away from JDBC to using the XML data source, and this solved
> this problem for me (but introduced another).
>
> I'll try to re-introduce the JDBC data source again and run the test for
> you when I get a chance.
>
>
> Regards,
>
> Dave Orme
>
> Jason Weathersby wrote:
>> Dave,
>>
>> Sounds good. Can you turn on logging in the WebViewer plugin web.xml
>> and set it to FINEST. Run the report that is failing and either email
>> to me or post it?
>>
>> Thanks
>>
>> Jason
>>
>> David J. Orme wrote:
>>> Jason Weathersby wrote:
>>>> Dave,
>>>>
>>>> Did the sample db report work in your setup or just using BIRT alone?
>>>> You could also download the TopNpercent report which contains a
>>>> chart and try it in your environment.
>>>> http://www.eclipse.org/birt/phoenix/examples/solution/
>>>
>>> The sample db report worked in BIRT in the IDE. I didn't deploy it
>>> and try it in my app because so far the behavior in the IDE and in my
>>> app has been completely consistent.
>>>
>>> If I can make my own report work completely in the IDE, that would
>>> seem to be the right first step--before we worry about if my app runs
>>> correctly?
>>>
>>> Dave Orme
>
>
|
|
|
Goto Forum:
Current Time: Mon Aug 25 13:58:33 EDT 2025
Powered by FUDForum. Page generated in 0.05779 seconds |
Home