Datawarehouse column does not populate on refresh when working with benefits on event registrations

When adding an event registration to an event with benefits and a payment tied to that event registration, it does not populate after a refresh in BBDW, but it does populate after a reset.
Download and install the latest Service Pack which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.  

Steps to Duplicate

  1. Open SSMS and find SMP_EC_40_14_RPT_BBDW, right click the database and click new query and run the following query to get the count of the bbdw.fact_financialtransactionlineitem table.
  2. select count(*) as COUNT from bbdw.fact_financialtransactionlineitem
    where eventregistrantfactid  is not null and eventregistrantfactid <> '0'
  3. Click the fundraising tab
  4. Click Benefits catalog
  5. Click Add and fill out the Add a benefit form with a value of $25.00 and a Category of event.
  6. Click Events tab and click add new event.
  7. In the event click Options and click add next to Registration options
  8. Fill out the Add a registration option, make the registration fee $100.00 and make sure to add your benefits  under the Benefits area and click save.
  9. In the event click Registrations and fill out the Add a registrant form and click save
  10.   In the event registrant page click add a payment under tasks in the upper left hand corner.
  11. For the amount input $100.00 
  12. Click the event under application details, then click add and click save.
  13. Click the Administration tab, then click data warehouse
  14. Click Start ETL refresh.
  15. Run query again and check the count of that table.
  16. If count goes up go through steps again and refresh datawarehouse again
  17. If count does not go up click Reset ETL and run query again to view count.


 Blackbaud CRM
 4.0, Service Pack 12

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.