Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Show Page Sections

download

Something's not quite right about your data – it can't be displayed in Excel. Column 'id' does not allow nulls. (Release 7)

Error Message

Something's not quite right about your data – it can't be displayed in Excel. Column 'id' does not allow nulls.

Cause

The Conga View Data Workbook generates an Excel workbook based on the dataset supplied to Conga in your solution. This error occurs when the dataset supplied to Conga is empty. There are a variety of reasons that can cause this such as:

  • A poorly formed query can filter out all data resulting in an empty dataset
  • A Salesforce report that filters out all data
  • Permissions that do not allow the user running the solution to see the required data

What to Do

  • Review your data for null values (ensure every record in your report has an ID)
  • Test on a different record
  • Run your Salesforce report outside of Conga Composer (by entering your record ID in the first filter on the report)
  • Unless you are using Mail Merge or Conductor, remove the ID column from your report