Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » REMOTE .rptdocument file
REMOTE .rptdocument file [message #647136] Tue, 04 January 2011 17:24 Go to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello,

we're have a requirement to load BIRT .rptdesign file within RAP at run-time and generate it's corresponding .rptdocument file dynamically. this .rptdocument file is refernced by webviewer within RAP to display the contents of the report.

following snippet invokes the .rptdocument file within webviewer.
WebViewer.display(rptdocument_file, browser, report_params)

where is the best path/url to store this dynamically created .rptdocument file during this process, which is required when invoking the Webviewer.display() method ?
the path/url needs to be valid when calling the report from remote RAP client session, so that the path reference is resolved appropriately at run-time.

any suggestion is highly appreciated.

regards,
sudesh

[Updated on: Tue, 04 January 2011 17:26]

Report message to a moderator

Re: REMOTE .rptdocument file [message #647144 is a reply to message #647136] Tue, 04 January 2011 17:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sudesh,

Have you tried adding the rptdocument to the report_params map?

HashMap myparms = new HashMap();
HashMap emitmap = new HashMap();

myparms.put("SERVLET_NAME_KEY", "frameset");
myparms.put("FORMAT_KEY", "html");
//myparms.put("RESOURCE_FOLDER_KEY", "c:/myresources");
myparms.put("ALLOW_PAGE", "false");
myparms.put("SHOW_PARAMETER_PAGE", "false");
myparms.put("DOCUMENT_NAME_KEY", rptdocument);
emitmap.put("Top Count", "6");
emitmap.put("Top Percentage", "15");
myparms.put("EMITTER_OPTIONS_KEY", emitmap);
//myparms.put("MAX_ROWS_KEY", "500");


WebViewer.display(rptdesign, browser, myparms);


Jason

On 1/4/2011 12:24 PM, Sudesh Bulathsinhala wrote:
> hello,
>
> we're have a requirement to load BIRT .rptdesign file within RAP at
> run-time and generate it's corresponding .rptdocument file dynamically.
> this .rptdesign file is refernced by webviewer within RAP to display the
> contents of the report.
>
> following snippet invokes the .rptdocument file within webviewer.
> WebViewer.display(rptdocument_file, browser, report_params)
>
> where is the best path/url to store this dynamically created
> .rptdocument file during this process, which is required when invoking
> the Webviewer.display() method ?
> the path/url needs to be valid when calling the report from remote RAP
> client session, so that the path reference is resolved appropriately at
> run-time.
>
> any suggestion is highly appreciated.
>
> regards,
> sudesh
Re: REMOTE .rptdocument file [message #647232 is a reply to message #647144] Wed, 05 January 2011 08:58 Go to previous messageGo to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member

hello jason,

i tried what you proposed, but didn't work.

i get the following error message :

This webpage is not available.

The webpage at http://127.0.0.1:63828/viewer/frameset?__document=C%3A%2Fins ight%2Fbirt%2Fws%2Fcom.argos.module.accounting%2Fac_account_ codes.rptdocument&__format=html&__svg=false&__lo cale=en_US&__timezone=Asia%2FColombo&__masterpage=tr ue&__rtl=false&__maxrows=500&__cubememsize=10&am p;am p;am p;am p;am p;am p;__resourceFolder=&__dpi=96&__parameterpage=false&a mp;a mp;a mp;a mp;a mp;a mp;Top%20Count=100&-682941018 might be temporarily down or it may have moved permanently to a new web address.

More information on this error
Below is the original error message

Error 102 (net::ERR_CONNECTION_REFUSED): Unknown error.



following is the code snippet i use to invoke the report document from RAP client

/* initialize config and engine instance */
final IReportEngine _engine;
final EngineConfig config = new EngineConfig();
final IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_ REPORT_ENGINE_FACTORY);
config.setEngineHome("");
final IPlatformContext context = new PlatformServletContext(RWT.getSessionStore().getHttpSession( ).getServletContext());
config.setPlatformContext(context);
_engine = factory.createReportEngine(config);

/* variables to store both .rptdesign and .rptdocument files
* .rptdesign file exist where as .rptdocument file gets generated during the process */


String RPTDESIGN_URL = "C:/insight/ide/_rap target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1. v20100913/birt/ac_account_codes.RPTDESIGN ";
String RPTDOCUMENT_URL = "C:/insight/ide/_rap target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1. v20100913/birt/ac_account_codes.RPTDOCUMENT ";

try {
final IReportRunnable reportRunnable = _engine.openReportDesign(RPTDESIGN_URL);
final IRunTask runTask = engine.createRunTask(reportRunnable);
/* generate .rptdocument file in the specified location */
runTask.run(RPTDOCUMENT_URL);
runTask.close();

System.setProperty(WebViewer.REPORT_DEBUT_MODE, "true");
final HashMap reportParams = new HashMap();
reportParams.put("SERVLET_NAME_KEY", "frameset");
reportParams.put("FORMAT_KEY", "html");
reportParams.put("ALLOW_PAGE", Boolean.toString(true));
reportParams.put("SHOW_PARAMETER_PAGE", Boolean.toString(false));
reportParams.put("DOCUMENT_NAME_KEY", RPTDOCUMENT_URL);

/* invoke the .rptdocument file within the webviewer */
WebViewer.display(RPTDOCUMENT_URL, _browser, reportParams);

} catch (final EngineException e) {
e.printStackTrace();
}

the above code snippet works fine when RAP client is invoked from the local developer machine (where the RAP instance is running), otherwise when invoked from remote machine using the IP address (192.168.1.55) it throws the error message :

This webpage is not available.

The webpage at http://127.0.0.1:63828/viewer/frameset?__document=C%3A%2Fins ight%2Fbirt%2Fws%2Fcom.argos.module.accounting%2Fac_account_ codes.rptdocument&__format=html&__svg=false&__lo cale=en_US&__timezone=Asia%2FColombo&__masterpage=tr ue&__rtl=false&__maxrows=500&__cubememsize=10&am p;am p;am p;am p;am p;am p;__resourceFolder=&__dpi=96&__parameterpage=false&a mp;a mp;a mp;a mp;a mp;a mp;Top%20Count=100&-682941018 might be temporarily down or it may have moved permanently to a new web address.

More information on this error
Below is the original error message

Error 102 (net::ERR_CONNECTION_REFUSED): Unknown error.


what might be causing this ?
i presume that the RAP renders the calling BIRT report in server and once the page is constructed, it send the page to the remote client. then again, i don't understand why the same works if i invoke from the development machine(SERVER) and not REMOTELY.

does the error message reference to localhost (127.0.0.1) has anything to do with this ?
everything works fine, if i invoke this from the LOCAL machine where RAP entrypoint is invoked.

is it all right to use full path url's for the .rptdcoument ?
ex.
String RPTDOCUMENT_URL = "C:/insight/ide/_rap target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1. v20100913/birt/ac_account_codes.RPTDOCUMENT ";

kindly advise me if i'm missing something.

thanks & regards,
sudesh

[Updated on: Wed, 05 January 2011 09:34]

Report message to a moderator

Re: REMOTE .rptdocument file [message #647312 is a reply to message #647232] Wed, 05 January 2011 15:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sudesh,

Try adding this before your display:
WebViewer.startup();

also

WebViewer.display(RPTDOCUMENT_URL, _browser, reportParams);
try passing the rpt design as the first parameter. You are setting the
document in the params.

Jason

On 1/5/2011 3:58 AM, Sudesh Bulathsinhala wrote:
> hello jason,
>
> i tried what you proposed, but didn't work.
>
> i get the following error message :
>
> This webpage is not available.
>
> The webpage at
> http://127.0.0.1:63828/viewer/frameset?__document=C%3A%2Fins
> ight%2Fbirt%2Fws%2Fcom.argos.module.accounting%2Fac_account_
> codes.rptdocument&__format=html&__svg=false&__lo
> cale=en_US&__timezone=Asia%2FColombo&__masterpage=tr
> ue&__rtl=false&__maxrows=500&__cubememsize=10&am p;am p;am p;am
> p;__resourceFolder=&__dpi=96&__parameterpage=false&a mp;a mp;a mp;a
> mp;Top%20Count=100&-682941018 might be temporarily down or it may have
> moved permanently to a new web address.
>
> More information on this error
> Below is the original error message
>
> Error 102 (net::ERR_CONNECTION_REFUSED): Unknown error.
>
> following is the code snippet i use to invoke the report document from
> RAP client
>
> /* initialize config and engine instance */
> final IReportEngine _engine;
> final EngineConfig config = new EngineConfig();
> final IReportEngineFactory factory = (IReportEngineFactory)
> Platform.createFactoryObject(IReportEngineFactory.EXTENSION_
> REPORT_ENGINE_FACTORY);
> config.setEngineHome("");
> final IPlatformContext context = new
> PlatformServletContext(RWT.getSessionStore().getHttpSession(
> ).getServletContext());
> config.setPlatformContext(context);
> _engine = factory.createReportEngine(config);
>
> /* variables to store both .rptdesign and .rptdocument files *
> .rptdesign file exist where as .rptdocument file gets generated during
> the process */
>
> String RPTDESIGN_URL = "C:/insight/ide/_rap
> target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1.
> v20100913/birt/ac_account_codes.RPTDESIGN ";
> String RPTDOCUMENT_URL = "C:/insight/ide/_rap
> target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1.
> v20100913/birt/ac_account_codes.RPTDOCUMENT ";
>
> try {
> final IReportRunnable reportRunnable =
> _engine.openReportDesign(RPTDESIGN_URL);
> final IRunTask runTask = engine.createRunTask(reportRunnable);
> /* generate .rptdocument file in the specified location */
> runTask.run(RPTDOCUMENT_URL);
> runTask.close();
>
> System.setProperty(WebViewer.REPORT_DEBUT_MODE, "true");
> final HashMap reportParams = new HashMap();
> reportParams.put("SERVLET_NAME_KEY", "frameset");
> reportParams.put("FORMAT_KEY", "html");
> reportParams.put("ALLOW_PAGE", Boolean.toString(true));
> reportParams.put("SHOW_PARAMETER_PAGE", Boolean.toString(false));
> reportParams.put("DOCUMENT_NAME_KEY", RPTDOCUMENT_URL);
>
> /* invoke the .rptdocument file within the webviewer */
> WebViewer.display(RPTDOCUMENT_URL, _browser, reportParams);
>
> } catch (final EngineException e) {
> e.printStackTrace();
> }
>
>
>
>
>
>
Re: REMOTE .rptdocument file [message #647456 is a reply to message #647312] Thu, 06 January 2011 13:56 Go to previous messageGo to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello jason,

i'm still getting the same error.

is this a bug in WebViewer on RAP ? or is this the preferred approach to invoke reports from remote RAP client ?

our requirement is to load reports, when invoked from remote RAP client.

is there any alternate approach to achieve the same ?
any suggestion is highly appreciated.


thanks & regards,
sudesh
Re: REMOTE .rptdocument file [message #647467 is a reply to message #647456] Thu, 06 January 2011 14:47 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sudesh,

The error you are getting looks like the webviewer is not started. Does
it work if you just use a rptdesign?

Jason

On 1/6/2011 8:57 AM, Sudesh Bulathsinhala wrote:
> hello jason,
>
> i'm still getting the same error.
>
> is this a bug in WebViewer on RAP ? or is this the preferred approach to
> invoke reports from remote RAP client ?
>
> our requirement is to load reports, when invoked from remote RAP client.
>
> is there any alternate approach to achieve the same ?
> any suggestion is highly appreciated.
>
>
> thanks & regards,
> sudesh
Re: REMOTE .rptdocument file [message #647571 is a reply to message #647467] Fri, 07 January 2011 06:32 Go to previous messageGo to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello jason,

i tried the following changes as you suggested and now the report does not run on the developer's machine either.


CODE :

String RPTDESIGN_URL = "C:/insight/ide/_rap target/eclipse/plugins/org.eclipse.birt.report.viewer_2.6.1. v20100913/birt/ac_account_codes.RPTDESIGN ";

final HashMap reportParams = new HashMap();
reportParams.put("SERVLET_NAME_KEY", "frameset");
reportParams.put("FORMAT_KEY", "html");
reportParams.put("ALLOW_PAGE", Boolean.toString(true));
reportParams.put("SHOW_PARAMETER_PAGE", Boolean.toString(false));

WebViewer.startup();
WebViewer.display(RPTDESIGN_URL, _browser, reportParams);


I tried without WebViewer.Startup() as well..

LOG


!ENTRY org.eclipse.rap.ui 4 0 2011-01-07 11:57:34.365
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NoClassDefFoundError: org/eclipse/birt/report/designer/ui/ReportPlugin
at org.eclipse.birt.report.viewer.utilities.ViewerClassPathHelp er.getWorkspaceClassPath(ViewerClassPathHelper.java:191)
at org.eclipse.birt.report.viewer.utilities.WebViewer.startWebA pp(WebViewer.java:756)
at org.eclipse.birt.report.viewer.utilities.WebViewer.display(W ebViewer.java:1004)
at org.eclipse.birt.report.viewer.utilities.WebViewer.display(W ebViewer.java:998)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart.invokeRunReport(CustomReportEditorPart.java:400)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart.access$0(CustomReportEditorPart.java:371)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart$1.handleEvent(CustomReportEditorPart.java:101)
at org.eclipse.swt.internal.widgets.UntypedEventAdapter.dispatc hEvent(UntypedEventAdapter.java:651)
at org.eclipse.swt.internal.widgets.UntypedEventAdapter.widgetS elected(UntypedEventAdapter.java:88)
at org.eclipse.swt.events.SelectionEvent.dispatchToObserver(Sel ectionEvent.java:194)
at org.eclipse.rwt.internal.events.Event.processEvent(Event.jav a:44)
at org.eclipse.swt.events.TypedEvent.processEvent(TypedEvent.ja va:161)
at org.eclipse.swt.events.TypedEvent.executeNext(TypedEvent.jav a:201)
at org.eclipse.swt.widgets.Display.runPendingMessages(Display.j ava:1100)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :1090)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2390)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2351)
at org.eclipse.ui.internal.Workbench.access$5(Workbench.java:22 06)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:424)
at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:332)
at org.eclipse.jface.internal.databinding.realmadapter.RealmAda pter.run(RealmAdapter.java:44)
at org.eclipse.rap.ui.internal.RealmAdapterHook.runWithDefault( RealmAdapterHook.java:48)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:427)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:157)
at com.argos.sys.client.entrypoint._rap.ClientEntryPoint.create UI(ClientEntryPoint.java:18)
at org.eclipse.rwt.internal.lifecycle.EntryPointManager.createU I(EntryPointManager.java:92)
at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle.createUI(RWT LifeCycle.java:245)
at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle$UIThreadCont roller.run(RWTLifeCycle.java:114)
at java.lang.Thread.run(Unknown Source)
at org.eclipse.rwt.internal.lifecycle.UIThread.run(UIThread.jav a:102)
Caused by: java.lang.ClassNotFoundException: org.eclipse.birt.report.designer.ui.ReportPlugin
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInter nal(BundleLoader.java:513)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(Bund leLoader.java:429)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(Bund leLoader.java:417)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loa dClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 30 more


one more thing i forgot to mention, our BIRT project is external and it produces .RPTDESIGN files, which we reference using FULL QUALIFIED PATH URL when accessing from RAP client.

thanks & regards,
sudesh

[Updated on: Fri, 07 January 2011 10:47]

Report message to a moderator

Re: REMOTE .rptdocument file [message #647582 is a reply to message #647571] Fri, 07 January 2011 07:49 Go to previous messageGo to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello jason,

when i invoke the report using the following snippet it works fine, only in the developer workstation..

but i get a warning, maybe the warning might help you a bit..

CODE

final String RPTDESIGN_URL = _reportFileFolderURL + _reportFileName
+ RPTDESIGN;
final String RPTDOCUMENT_URL = _reportFileFolderURL + _reportFileName
+ RPTDOCUMENT;
try {
final IReportEngine engine = CustomReportProvider.getInstance()
.getDefaultReportEngine();
final IReportRunnable reportRunnable = engine
.openReportDesign(RPTDESIGN_URL);
final IRunTask runTask = engine.createRunTask(reportRunnable);
/* this method call will set run time parameters */
decorateReportParams(runTask);
runTask.validateParameters();
runTask.run(RPTDOCUMENT_URL);
runTask.close();
System.setProperty(WebViewer.REPORT_DEBUT_MODE, "true");
final HashMap reportParams = new HashMap();
reportParams.put("SERVLET_NAME_KEY", "frameset");
reportParams.put("FORMAT_KEY", "html");
reportParams.put("ALLOW_PAGE", "true");
reportParams.put("SHOW_PARAMETER_PAGE", "false");
reportParams.put("DOCUMENT_NAME_KEY", RPTDOCUMENT_URL);
WebViewer.startup();
WebViewer.display(RPTDESIGN_URL, _browser, reportParams);
} catch (final EngineException e) {
e.printStackTrace();
}


WARNING

Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory loadFontMappingConfig
INFO: load font config in bundleentry://138.fwk820791943/fontsConfig.xml cost 23ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/ja/X11/fonts/TT cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_13/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/ru.ansi-1251/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_15/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in d:/windows/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in C:/windows/fonts cost:451ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X11R6/lib/X11/fonts/truetype cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/ar/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in e:/WINNT/fonts cost:1ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /var/lib/defoma/x-ttcidfont-conf.d/dirs/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in C:/WINNT/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_2/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X11R6/lib/X11/fonts/tt cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/th_TH/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_8/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_7/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X11R6/lib/X11/fonts/TTF cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/truetype cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in f:/WINNT/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/ko.UTF-8/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in g:/WINNT/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_5/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in f:/windows/fonts cost:1ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in d:/WINNT/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/ko/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh_TW/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in e:/windows/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/zh_TW/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/ja/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh_CN.GB18030/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/default/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X/lib/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/euro_fonts/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/hi_IN.UTF-8/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh.GBK/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X11R6/lib/X11/fonts/OTF cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_9/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/X11R6/lib/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh_TW.BIG5/X11/fonts/TT cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/ko/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh_HK.BIG5HK/X11/fonts/TT cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/KOI8-R/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/openwin/lib/locale/zh/X11/fonts/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in /usr/share/fonts/zh_CN/TrueType cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory$2 run
INFO: register fonts in g:/windows/fonts cost:0ms
Jan 7, 2011 12:36:42 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory loadFontMappingConfig
INFO: load font config in bundleentry://138.fwk820791943/fontsConfig_win32.xml cost 2ms
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingMa nagerFactory loadFontMappingConfig
INFO: load font config in bundleentry://138.fwk820791943/fontsConfig_pdf.xml cost 3ms
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions
INFO: Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions
INFO: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver , connectionFactory=org.eclipse.birt.report.data.oda.sampledb. SampleDBJDBCConnectionFactory
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: DriverClassLoader failed to load class: org.postgresql.Driver
java.lang.ClassNotFoundException: org.postgresql.Driver
at org.eclipse.birt.core.framework.URLClassLoader.findClass1(UR LClassLoader.java:185)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClas sLoader.java:154)
at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClas sLoader.java:1)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.birt.core.framework.URLClassLoader.findClass(URL ClassLoader.java:149)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load ExtraDriver(JDBCDriverManager.java:919)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:738)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:862)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:246)
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.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:617)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteQuery(DataGenerationEngine.java:80)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.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.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:85)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart.invokeRunReport(CustomReportEditorPart.java:385)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart.access$0(CustomReportEditorPart.java:371)
at com.argos.sys.base.controller.widget.editor.CustomReportEdit orPart$1.handleEvent(CustomReportEditorPart.java:101)
at org.eclipse.swt.internal.widgets.UntypedEventAdapter.dispatc hEvent(UntypedEventAdapter.java:651)
at org.eclipse.swt.internal.widgets.UntypedEventAdapter.widgetS elected(UntypedEventAdapter.java:88)
at org.eclipse.swt.events.SelectionEvent.dispatchToObserver(Sel ectionEvent.java:194)
at org.eclipse.rwt.internal.events.Event.processEvent(Event.jav a:44)
at org.eclipse.swt.events.TypedEvent.processEvent(TypedEvent.ja va:161)
at org.eclipse.swt.events.TypedEvent.executeNext(TypedEvent.jav a:201)
at org.eclipse.swt.widgets.Display.runPendingMessages(Display.j ava:1100)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :1090)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2390)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2351)
at org.eclipse.ui.internal.Workbench.access$5(Workbench.java:22 06)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:424)
at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:332)
at org.eclipse.jface.internal.databinding.realmadapter.RealmAda pter.run(RealmAdapter.java:44)
at org.eclipse.rap.ui.internal.RealmAdapterHook.runWithDefault( RealmAdapterHook.java:48)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:427)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:157)
at com.argos.sys.client.entrypoint._rap.ClientEntryPoint.create UI(ClientEntryPoint.java:18)
at org.eclipse.rwt.internal.lifecycle.EntryPointManager.createU I(EntryPointManager.java:92)
at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle.createUI(RWT LifeCycle.java:245)
at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle$UIThreadCont roller.run(RWTLifeCycle.java:114)
at java.lang.Thread.run(Unknown Source)
at org.eclipse.rwt.internal.lifecycle.UIThread.run(UIThread.jav a:102)

Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: refreshUrlsWhenFail: true
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: driverClassPath: null
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: Registered URLs:
Jan 7, 2011 12:36:43 PM org.eclipse.birt.report.data.oda.jdbc.Connection open
WARNING: JDBC connection: org.postgresql.jdbc4.Jdbc4Connection@53a4c0e2 is opened
Jan 7, 2011 12:36:44 PM org.eclipse.birt.report.data.oda.jdbc.Connection close
WARNING: JDBC connection: org.postgresql.jdbc4.Jdbc4Connection@53a4c0e2 is closed
2011-01-07 12:36:44.052:INFO::jetty-6.1.x
2011-01-07 12:36:44.069:INFO::Started SelectChannelConnector@127.0.0.1:54554
Jan 7, 2011 12:36:44 PM org.apache.axis.utils.JavaUtils isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). Attachment support is disabled.


one more thing that i noticed.
if i send the RPTDESIGN_URL to the WebViewer as you suggested earlier, the report does not work with filter parameters i provide during runtime.
for instance report with only account_status = inactive fetches all the records irrespective of the status parameter we provide at runtime.

are we following the right approach when using BIRT reports in RAP ?

thanks & regards,
sudesh

[Updated on: Fri, 07 January 2011 10:50]

Report message to a moderator

Re: REMOTE .rptdocument file [message #647610 is a reply to message #647582] Fri, 07 January 2011 10:36 Go to previous messageGo to next message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello jason,

i did another interesting test case.

when i invoke the RAP client from the developer workstation(local host machine) using its host IP address as following.
(using the host IP address 192.168.1.54 instead of 127.0.0.1 from the same machine)

http://192.168.1.54 :58081/insight.default?startup=com.argos.sys.client.entrypoi nt._rap.entrypoint

i get error message dialog saying
"The viewing session is not available or has expired."

if the same is invoked using 127.0.0.1 instead of 192.168.1.54
things are working out and you could see the report preview on the WebViewer.

i'm sure this is causing the damage when invoked using IP address from REMOTE workstation, instead of using 127.0.0.1 (localhost)

WebViewer session has something to do with this, i assume.

let me know your thoughts on this.

thanks and regards,
sudesh


[Updated on: Fri, 07 January 2011 11:09]

Report message to a moderator

Re: REMOTE .rptdocument file [message #647640 is a reply to message #647610] Fri, 07 January 2011 14:12 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Sudesh,

This error:
SEVERE: DriverClassLoader failed to load class: org.postgresql.Driver
java.lang.ClassNotFoundException: org.postgresql.Driver
at org.eclipse.birt.core.framework.URLClassLoader.findClass1(UR
LClassLoader.java:185)

Means the report engine is not finding the postgresql driver. Where do
you have it? It should be in the BIRT jdbc plugin's drivers directory.

You can set the hostname and port for the viewer in the preferences of
the viewer

window->preferences->Report Design->Preview->Preview Server

Or set them in code with
System.setProperty( "server_host", hostname )
System.setProperty( "server_port", hostport );


Jason


On 1/7/2011 5:36 AM, Sudesh Bulathsinhala wrote:
> hello jason,
>
> i did another test case.
>
> when i invoke the RAP client from the developer workstation using the IP
> address as following.
>
> http://192.168.1.54
> :58081/insight.default?startup=com.argos.sys.client.entrypoi
> nt._rap.entrypoint
>
> i get error message dialog saying
> "The viewing session is not available or has expired."
>
> if the same is invoked using 127.0.0.1 instead of 192.168.1.54
> things are working out and you could see the report preview on the
> WebViewer.
>
> i'm sure this is causing the damage when invoked using IP address from
> REMOTE workstation, instead of using 127.0.0.1 (localhost)
>
> WebViewer session has something to do with this, i assume.
>
> let me know your thoughts on this.
>
> thanks and regards,
> sudesh
>
>
>
Re: REMOTE .rptdocument file [message #647862 is a reply to message #647640] Mon, 10 January 2011 08:12 Go to previous message
Sudesh Bulathsinhala is currently offline Sudesh BulathsinhalaFriend
Messages: 180
Registered: October 2010
Senior Member
hello jason,

thanks for the fix.
it worked as expected.

KUDOS

rgs,
sudesh
Previous Topic:Proper aggregated file sizes
Next Topic:Running Sum problem in Chart
Goto Forum:
  


Current Time: Sun Nov 23 15:00:16 GMT 2014

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

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