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?