SAP Knowledge Base Article - Preview

2643752 - OLEDB error Unsupported parameter type with SSIS Data Flow Task - SDK for SAP ASE

Symptom

  • 0xC0202009 at Data Flow Task, OLE DB Source [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
    An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x00000000  Description: "[HY000]
    [Native Code: 30071]
    [ASEOLEDB]Unsupported parameter type".
    Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: OLE DB Source failed the pre-execute phase and returned error code 0xC0202009.
    Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
    Task failed: Data Flow Task
     
  • In the ribo trace:
    DYNAMIC2 Token (0x62); variable length
      Length [4]:                   67
      Type [1]:                     DYN_PREPARE (0x01)
      Status [1]:                   DYNAMIC_SUPPRESS_FMT (0x02)
      Name Length [1]:              2
      Name [2]:                     "A0"
      Statement Length [4]:         58
      Statement [58]:               "CREATE PROC [A0] AS select * from authors where au_lname=?"
     
  • Happens with all datatypes, char, varchar, numeric and decimal.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • Adaptive Server Enterprise OLE DB Provider by Sybase
  • Microsoft MSSQL
  • SAP Adaptive Server Enterprise (ASE)
  • SSIS

Product

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

Keywords

CR#815602, CR815602, 815602, sybdrvoledb.dll, sybdrvoledb , KBA , BC-SYB-SDK , SDK , Bug Filed

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.