Eclipse Community Forums: BIRT » Unable to find the connection profile reference by DS connection properties in BIRT report

Home » Archived » BIRT » Unable to find the connection profile reference by DS connection properties in BIRT report(DB Profile open)

Unable to find the connection profile reference by DS connection properties in BIRT report [message #1632831]

Tue, 24 February 2015 09:06

Eclipse User

I am completely new to Birt Report.
I have generated a "***.rptdesign***" file and I have deployed it in tomacat server from windows OS it is working.Same file I deployed in tomacat server from Ubuntu OS is not working and it throwing the Exception. It is working in windows but not in Ubuntu.Some one facing the same issues? How to resolve the bug?

Exception:

org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
    Cannot open the connection for the driver:
    org.eclipse.birt.report.data.oda.jdbc.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException: Unable to find the connection profile referenced by the data source connection properties. ;
    org.eclipse.datatools.connectivity.oda.OdaException: Unable to find or access the named profile (birtconnectionprofile) in profile store path (/home/pro/Liferay/BIRTReport/BirtReport/lib/birtconnectionprofile). ;
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. (Element ID:95)

Hide Exception Stack Trace

Stack Trace:

 org. eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
    Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
    org.e clipse.datatools.connectivity.oda.OdaException: Unable to find the connection profile referenced by the data source connection properties. ;
    org. eclipse.datatools.connectivity.oda.OdaException: Unable to find or access the named profile (birtconnectionprofile) in profile store path (/home/pro/Liferay/BIRTReport/BirtReport/lib/birtconnectionprofile). ;
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. (Element ID:95)
           at org. eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
           at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
           at org. eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96).

Screen shot below
![enter image description here][2]

Embarrassed

Attachment: Capture.JPG
(Size: 147.46KB, Downloaded 3704 times)

Re: Unable to find the connection profile reference by DS connection properties in BIRT report [message #1634892 is a reply to message #1632831]

Wed, 25 February 2015 09:06

Eclipse User

Hi.
Do You export the Data Source as a connection profile store?
If yes, the path of the file of profile connection must be the same as windows

Re: Unable to find the connection profile reference by DS connection properties in BIRT report [message #1634961 is a reply to message #1634892]

Wed, 25 February 2015 09:48

Eclipse User

Hi Felipe Moreira,

Can you please tell me how to configure the connection profile in linux. I have place connection profile in following path
home/pro/Liferay/BIRTReport/BirtReport/lib/ and I have deployed '.rtpdesign' file into following path home/pro/Liferay/tomcat7/webapps/birt
and I run the url in browser //test.server.com:8080/birt/frameset?_report=demo.rtpdesing.
I am sure something is missing in the configuration.

[Updated on: Wed, 25 February 2015 09:48] by Moderator

Re: Unable to find the connection profile reference by DS connection properties in BIRT report [message #1635103 is a reply to message #1634961]

Wed, 25 February 2015 11:19

Eclipse User

Likewise the windows.

Do you exported your datasource as connection profile when you created your report with eclipse on Windows ? Because you not required to do that unless you want to share your data source with your reports, without having to set the data source one by one.

Re: Unable to find the connection profile reference by DS connection properties in BIRT report [message #1688188 is a reply to message #1635103]

Fri, 20 March 2015 05:37

Eclipse User

I have created connection profile in eclipse on Windows then paste into the path "tomcat/birt" from Ubuntu then hit the url it show the exception.

Steps:
1. Right click on the my "Data Sources" then click "Export to Library".
2. I given the name "birtconnectionprofile" then save,It automatically file extension "*.rptlibrary" it came.
3. Now "birtconnectionprofile.rptlibrary"file placed into the path "tomcat/birt" in Ubuntu 14.
4. PostgreSQL jar also place into the path "tomcat/webapps/birt/WEB-INF/lib" in Ubuntu 14.
5. Finally I hit the url(test.server.com:8080/birt/frameset?_report=demo.rtpdesing) in browser. But it is not working properly.

I am not sure the above steps are correct or not. Some one can help me.

[Updated on: Mon, 23 March 2015 03:11] by Moderator

Previous Topic:	No data in the report
Next Topic:	Getting Data to read from left to right

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Apr 30 14:06:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter