Data Source Error: Error while trying to retrieve text for error ORA-12154

• Heidis_Mom

  SSC Veteran

  Points: 233

  More actions

  June 6, 2016 at 3:51 pm

  #314362

  I am deploying reports from Visual Studio 2013.

  As soon as deploy them - I run them and I get the following error:

  An error has occurred during report processing. (rsProcessingAborted)

  Cannot create a connection to data source 'xxxxxx'. (rsErrorOpeningConnection)

  For more information about this error navigate to the report server on the local server machine, or enable remote errors

  The reports I deploy use a shared data source that is stored on the SSRS server. I had checked each report (Manage >> Data Sources) and made sure

  they were mapped to the shared data source on the server. When I go to that data source on the server, if I hit the

  Test Connection button I get the following error: Error while trying to retrieve text for error ORA-12154

  Prior to deployment, I tested the shared data source in my visual studio project and I had no problem connecting to the Oracle database.

  My administrator thought that when I deploy all the report, not all of the stored credentials in my shared data source are getting created on the

  server. (Not sure about this explanation) In my VS project, I have set the Overwrite Datasets option and OverwriteDataSources options to False.

  Any ideas what is causing my ORA-12154 error???

  Thanks in Advance,

  Heidi's Mom