x

SSRS - Cannot create a connection to Oracle data source Error

Hi,

From time to time some of the ssrs reports connecting to oracle data sources gives "ORA-12154: TNS:could not resolve the connect identifier specified" error. Restarting IIS fixes the issue. This happens only with data sources connecting to Oracle databases. Below is a transcript of the error message from reportserver logfile.

Any help would be much appreciated.

Thanks,

Joseph.

w3wp!processing!6!31/05/2010-10:45:02:: e ERROR: Data source 'ds_: An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ds_. ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

w3wp!processing!6!31/05/2010-10:45:02:: e ERROR: An exception has occurred in data source 'ds_. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ds_. ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

w3wp!processing!6!31/05/2010-10:45:02:: i INFO: Merge abort handler called. Aborting data sources ... w3wp!processing!6!31/05/2010-10:45:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ds_. ---> System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

more ▼

asked Jun 01, 2010 at 11:17 PM in Default

Joseph 1 gravatar image

Joseph 1
1 1 1 1

Have you checked that this is not an ORACLE issues... Is tnsnames.ora defined correctly?
Jun 02, 2010 at 02:32 AM sp_lock
thanks. tnsnames are correct, maybe I'll try updating the oracle drivers and see what happens.
Jun 02, 2010 at 08:24 PM Joseph 1
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

resolved the issue by recycling the application pool on a periodic basis. thanks.

more ▼

answered Jun 04, 2010 at 02:25 AM

Joseph 1 gravatar image

Joseph 1
1 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x547
x378

asked: Jun 01, 2010 at 11:17 PM

Seen: 2197 times

Last Updated: Jun 02, 2010 at 03:49 AM