Jump to content


Oracle Connection Issues


  • Please log in to reply
5 replies to this topic

#1 BlackStone

BlackStone

    Forum Newbie

  • Members
  • 3 posts

Posted 16 January 2012 - 01:39 AM

HI there,

I have successfully managed to get the new Collabion charts connecting to oracle in our dev invironment (1 WFE / 1 App server) but in production it is failing with the following the standard error:

"Could not connect o selected data provider. Please, check the network connection or make sure the database settings are correct."

Oracle client is installed on all WFEs (2) and APP servers (2). I use exactly the same connection entries as dev and it fails. I can connect to the database on all servers via odbc connection via oracle client with no worries. I've checked the ULS logs and can't find anything there meaningful as to why its failing. Do you have any suggestions for troubleshooting this connection issue? This is my first exposure to Collabion Charts and feel it would be a great product to add to our SharePoint Environment.

kind regards,

Blacky..

#2 Rahul Kumar

Rahul Kumar

    Supreme Being

  • L1 Moderators
  • 1227 posts

Posted 16 January 2012 - 05:20 AM

Hi,


Could you please send us the detailed error information which is being logged in "CollabionCharts_ErrorLog" by going to "Lists" > "CollabionCharts_ErrorLog"?
Regards,
Rahul Kumar
Tech Lead


A byte of magic.

#3 BlackStone

BlackStone

    Forum Newbie

  • Members
  • 3 posts

Posted 17 January 2012 - 02:28 AM

Hi Rahul, thanks for you time!

The oracle client we are using is the win64 11gR2 version. The error in the log is as follows:

Title
Could not connect to selected data provider. Please, check the network connection or make sure database settings are correct
Date
11/01/2012 2:52 PM
Type
Error
<a name="SPBookmark_Exception">Exception
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Stack Trace
at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at Collabion.Charts.Business.Providers.Base.SqlDataProvider.Connect()
at Collabion.Charts.Business.WebService.Connect(String webPartId, String name)
at Collabion.Charts.WebServicePage.OnInit(EventArgs e)


#4 Rahul Kumar

Rahul Kumar

    Supreme Being

  • L1 Moderators
  • 1227 posts

Posted 17 January 2012 - 05:25 AM

Hi,

Thanks for the information.

Could you please try installing Oracle client software version 8.1.7 in your client and check again, in case if you are still getting this issue then please refer to http://moustafa-araf...res-oracle.html to solve the issue.

I hope this helps.
Regards,
Rahul Kumar
Tech Lead


A byte of magic.

#5 BlackStone

BlackStone

    Forum Newbie

  • Members
  • 3 posts

Posted 18 January 2012 - 12:19 AM

Hi,

Thanks for the information.

Could you please try installing Oracle client software version 8.1.7 in your client and check again, in case if you are still getting this issue then please refer to http://moustafa-araf...res-oracle.html to solve the issue.

I hope this helps.


Hi again .... all is working well now. Installing the previous version wasn't an option but I did follow the instructions for giving authenticated users read/execute rights over the oraclehome directory and as of today, connections are working as exptected.

Thanks again for your time ... charting product is great! A bit off topic though, is this product actually free? I can't seem to find licencing information anywhere for it ?

cheers and thanks again !

Blacky.

#6 Rahul Kumar

Rahul Kumar

    Supreme Being

  • L1 Moderators
  • 1227 posts

Posted 18 January 2012 - 05:27 AM

Hi,

We are glad your issue is resolved.
I am afraid, it is not free, since it is in beta we are giving it free so that we improve it more and make it an exciting product by getting users' feedback.
Regards,
Rahul Kumar
Tech Lead


A byte of magic.