Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Unable to find the connection profile reference by DS connection properties in BIRT report(DB Profile open)
icon8.gif  Unable to find the connection profile reference by DS connection properties in BIRT report [message #1632831] Tue, 24 February 2015 14:06 Go to next message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
index.php/fa/20985/0/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 3573 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 14:06 Go to previous messageGo to next message
Felipe Moreira is currently offline Felipe MoreiraFriend
Messages: 5
Registered: February 2015
Junior Member
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 14:48 Go to previous messageGo to next message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
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 14:48]

Report message to a 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 16:19 Go to previous messageGo to next message
Felipe Moreira is currently offline Felipe MoreiraFriend
Messages: 5
Registered: February 2015
Junior Member
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 09:37 Go to previous message
Prathyush S is currently offline Prathyush SFriend
Messages: 10
Registered: February 2015
Junior Member
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 07:11]

Report message to a moderator

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


Current Time: Tue Jul 23 16:10:57 GMT 2024

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

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

Back to the top