Data warehouse ETL refresh fails because of snapshot

When using the "Database Snapshots" option for processing the Blackbaud Data Warehouse ETL available as of 4.0 SP11, the ETL may fail with error:

An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E14  Description: "Cannot open database "BBInfinity_SNAPSHOT_FOR_ETL" requested by the login. The login failed.".

Subsequent ETL refresh attempts may also fail with errors such as:
***Snapshot exists or sqlcmd_snapshot_exists command failed.*** or ***sqlcmd_destroy_snapshot command failed.***


 
Redeploy the data warehouse.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?