Error: Error 0xC00CE558 while loading package file "C:\Program Files\Microsoft SQL Server\120\DTS\Packages\BBETL\BBCRM_RPT_BBDW\BBDW_CONFIGINFO.dtsx" into an XML document. XML document must have a top level element.

Some users may find that their BBDW does not refresh successfully and throws the below error after installing SP 16 hot fix 1608 and redeploying the ETL.

Error: Error 0xC00CE558 while loading package file "C:\Program Files\Microsoft SQL Server\120\DTS\Packages\BBETL\BBCRM_RPT_BBDW\BBDW_CONFIGINFO.dtsx" into an XML document. XML document must have a top level element.
We're currently evaluating this issue for a fix in a future hot fix.

Workaround: This issue only occurs if you've installed SP16 hot fix 1608 AND have performed a redeploy of the ETL.  If you haven't yet deployed or installed this specific patch we recommend that you do not install or redeploy either at this time while we work to address the issue. 

If you're an on premise client that has installed the patch and redeployed the ETL please see the following steps to resolve.
 
  1. Identify the CRM application installation folder that contains the corrupted (0 bytes) BBDW_CONFIGINFO.dtsx file. This is typically under: <CRM installation folder>\bbappfx\MSBuild\Datamarts\BBDW\SSIS.
  2. Replace the corrupted file with the attached file
  3. Redeploy the DataWarehouse/ETL by running the deployment tool
  4. (OPTIONAL) Check the SQL server folder where the ETL package have been deployed. Typically in a folder similar to this: C:\Program Files\Microsoft SQL Server\120\DTS\Packages\BBETL\BBInfinity_SP12_RPT_BBDW. The BBDW_CONFIGINFO.dtsx should now have a size of about 35-36kb.
  5. Refresh ETL
  BBDW_CONFIGINFO.dtsx

Environment

 Blackbaud CRM
 4.0

Was this article helpful?