1561026 - Error : "An OLE DB error has occurred. Error code: 0x80040E37" when running an 'Import SQL into Fact table' Data Manager package - BPC MS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1561026 - Error : "An OLE DB error has occurred. Error code: 0x80040E37" when running an 'Import SQL into Fact table' Data Manager package - BPC MS

Symptom

When running an 'Import SQL into Fact table' Data Manager package the following errors may be received:

  1. "Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available."
  2. "NullPointerException"
  3. "Description = SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37."

Read more...

Environment

  • SAP Business Planning and Consolidation 7.5, version for Microsoft

  • SAP Business Planning and Consolidation 10.0, version for Microsoft

  • SQL Server 2008

  • SQL Server authentication mode.

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 7.5, version for Microsoft

Keywords

DTSX, Import, standard, custom, SQL 2005. , KBA , EPM-BPC-MS , Microsoft Version , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.