Error: A record with an ID of zero was encountered saving the static query - when generating Envelopes or Labels in Mail and saving a truncation query

When generating Envelopes or Labels in Mail and generating a Truncation query,  the following message may occur:

A record with an ID of zero was encountered saving the static query.
Review the following until resolved:
  1. Recreate the Label or Envelope parameter from scratch. (Be sure to create a new one. Don't use a Save As to make a copy.)
  2. Adjust Label/Envelope size and font size, especially making fonts smaller, such as 10 pt Arial Narrow
  3. If possible, run the Labels or Envelopes for Constituents on the General tab.
  4. Do not create the Truncation query. At Format tab > Truncation Reports. Preview the run first with the report only.

If a query is needed:
  1. Create a constituent query for use on the General tab
  2. Mark the option to Create output query on the General tab
  3. Set up Truncation Report to run on the Format tab > Truncation Reports
  4. Preview the Envelopes
  5. Name and save the output query when prompted
  6. After the preview, use a Query Merge to group the exceptions: Primary query is the query from step 1, Secondary query is the output query from steps 2 and 5, and operation is SUB


 

Steps to Duplicate

  1. In The Raiser's Edge, click on Mail
  2. Select Envelopes or Labels
  3. Start a new Envelopes or Labels
  4. On General tab, select Create for Participants
  5. On the Format tab, highlight Truncation Reports.
  6. Mark Print Truncation Report and Create an exception query
  7. Click Preview
  8. Error occurs

Was this article helpful?