SAP Knowledge Base Article - Preview

2179545 - SSIS Package Execution fails with Attempted to read or write protected memory - SDK for SAP ASE

Symptom

  • when using same parameter twice in a batch of SQL sent to ASE
  • In SSIS package sending SQL statement (simplified version): select @p1 select @p1.
  • The parameter is defined properly in the SSIS package.
  • The SSIS Package execution fails with the following error:
    • Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
    • Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
  • No problem if just sending "select @p1".


Read more...

Environment

  • SAP Sybase Software Developers Kit (SDK) 15.7
  • Adaptive Server Enterprise OLE DB Provider by Sybase
  • Microsoft Visual Studio 2008/2010/2012+ using SSIS (SQL Server Integration Services)
  • MS SQL Server 2008+

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

OCS, CR#785285, CR785285, 785285 , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.