Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Problem with DBAmp and SSRS subscriptions

I have an SSRS report that uses Salesforce data. It runs perfectly when run by itself, but when run as part of a subscription in which multiple reports get generated and emailed, several of them often fail. In looking at the reporting services logs, I found the following: System.Data.SqlClient.SqlException: Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "salesforce".
1 person has
this problem
+1
Reply
  • Are there additional error messages ?

    Does the SSRS report use local tables created by sf_replicate or Linked server tables like SALESFORCE...Account ?

    Also, can you send a screenshot to support at forceamp.com of the Security page of your linked server ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • I am using linked tables (salesforce...account, etc.). For a given subscription, some of the reports usually run successfully, but some fail with this error.

    Here are the errors from the Reporting Services log:

    processing!WindowsService_0!8100!08/30/2013-06:54:53:: e ERROR: An exception has occurred in data set 'DataSource1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset DataSource1. ---> System.Data.SqlClient.SqlException: Cannot get the data of the row from the OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".
    processing!WindowsService_0!8100!08/30/2013-06:54:53:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!WindowsService_0!8100!08/30/2013-06:54:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset DataSource1. ---> System.Data.SqlClient.SqlException: Cannot get the data of the row from the OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

    I've sent a screenshot of the security page over
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Can you identify the specific query for DataSource1 that is failing ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited