none
An error has occurred during report processing. Cannot create a connection to data source

    Question

  • I'm using vs2013, and the report that comes with it, against MS SQL'08R2.

    The question I have is how do I debug the report data request -> data environment -> SQL pathway and find the broken bit.

    I'm trying to track down the source of the following message, since the query that is being referenced works fine when executed against the database:

    • An error has occurred during report processing.
      • Cannot create a connection to data source 'PDT'.
        • Exception has been thrown by the target of an invocation.
          • Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
    Tuesday, February 18, 2014 4:25 PM

Answers

  • the table that was being created from the query was breaking on field  lengths of strings and numeric values, I had to use the long form of the table creating query, and define correct field dimensions before the errors went away.
    • Marked as answer by David Len Tuesday, March 04, 2014 8:04 PM
    • Edited by David Len Tuesday, March 04, 2014 8:05 PM
    Tuesday, March 04, 2014 8:04 PM

All replies