SAP Knowledge Base Article - Preview

2471663 - Error: 16282 Severity: 10 State: 0 OS Error: -1 : srv_senddone(): No cursor row description present OS Error Text: <SRV-Lib> - ECDA

Symptom

  • Command has been aborted
    Sybase EnterpriseConnect Data Access (ECDA)
       %SYBASE%\OCS-15_0\bin>isql -S<ase_server> -U<userid> -P<pwd> -w2048 -D<ase_dbname>
       1> select * from <proxy_table_mapped_to_mssql_table>
       2> go
       quickpass disabled, reason: text/image column
       SELECT dt_logged, TEXTPTR(messagetext), messageDirection, vcmsDestMnem, clientDestMnem, vcmsOrigMnem, clientOrigMnem, vcmsRoutingkey, clientRoutingkey, taf, oif, dbIdentifier, dbmessageType, messageType, credentialMnemonic, credentialIp, credentialApplica
       tion, credentialPassword, credentialUser, messageidUnit, messageidId, messageidNamespace, id FROM <mssql_dbname>.<schema>.<mssql_table>
       
        id messageidNamespace messageidId messageidUnit credentialUser credentialPassword credentialApplication credentialIp credentialMnemonic messageType dbmessageType dbIdentifier oif taf clientRoutingkey vcmsRoutingkey clientOrigMnem vcmsOrigMnem clientDestMnem vcmsDestMnem messageDirection messagetext dt_logged
     -- ------------------ ----------- ------------- -------------- ------------------ --------------------- ------------ ------------------ ----------- ------------- ------------ --- --- ---------------- -------------- -------------- ------------ -------------- ------------ ---------------- ----------- ---------
       112590829 blahah-157.145.097.113 1 NULL Vruson-10303 NA blahah 157.145.097.113 XYG0 4 I N NULL NULL ABC8S0 ABC8S0 NULL NULL XYG0 XYG0 fromMas NULL Apr 24 2017 1:59PM
       Command has been aborted.
       (1 row affected)
  • Error: 16282 Severity: 10 State: 0 OS Error: -1 : srv_senddone(): No cursor row description present  OS Error Text:  <SRV-Lib>
       type %SYBASE%\DC-15_0\servers\<ecda_server>\log\<ecda_servername>.log
       . . .
       TraceInterface 05/10/2017 12:22:34.876 pdb1 12 sa OmniServer [..\smdcamsg.cpp(149)] Trace API Level ENTER odbcBaseStatement():SQLPrepare [a5a830 | request= 
          select textptr(<mssql_dbname>.<schema>.<mssql_table>.messagetext), datalength(<mssql_dbname>.<schema>.<mssql_table>.messagetext), <mssql_dbname>.<schema>.<mssql_table>.messagetext from <mssql_dbname>.<schema>.<mssql_table>
             where textptr(<mssql_dbname>.<schema>.<mssql_table>.messagetext) = @p1 | length=200]
       TraceInterface 05/10/2017 12:22:34.876 pdb1 12 sa OmniServer [..\smdcamsg.cpp(149)] Trace API Level EXIT odbcBaseStatement():SQLPrepare with return code 0
       TraceEntryExit 05/10/2017 12:22:34.876 pdb1 12 sa OmniServer [..\smdcamsg.cpp(145)] TRACE_ENTRY_EXIT <odbcBaseStatement::prepare sql retcode[0]
       TraceEvents 05/10/2017 12:22:34.876 pdb1 12 sa OmniServer [..\smdcamsg.cpp(489)] 05/10/2017 12:22:34.876 pdb1 2584 NULL NULL < Statement::stmtPrepare
       TraceEntryExit 05/10/2017 12:22:34.881 pdb1 12 sa OmniServer [..\smdcamsg.cpp(145)] TRACE_ENTRY_EXIT >odbcBaseStatement::getRowSetResult[ bindlob=0]
       TraceEntryExit 05/10/2017 12:22:34.881 pdb1 12 sa OmniServer [..\smdcamsg.cpp(145)] TRACE_ENTRY_EXIT <odbcCursorStmt::getRowSetResult
       TraceEvents 05/10/2017 12:22:34.881 pdb1 12 sa OmniServer [..\smdcamsg.cpp(489)] 05/10/2017 12:22:34.881 pdb1 2584 NULL NULL < DcaCursor::cursorOpen
       LogOCOSMessages 05/10/2017 12:22:34.883 pdb1 12 sa OmniServer Error: 16282 Severity: 10 State: 0 OS Error: -1 : srv_senddone(): No cursor row description present OS Error Text: <SRV-Lib>
       . . . 

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) with proxy table
  • Sybase EnterpriseConnect Data Access (ECDA) to Microsoft SQL Server (MSSQL)

Product

Sybase Enterprise Connect Data Access all versions

Keywords

ECDA odbc ASE proxy table proxy_table create existing table text Microsoft SQL Server Command has been aborted  Error: 16282 Severity: 10 State: 0 OS Error: -1 : srv_senddone(): No cursor row description present OS Error Text: <SRV-Lib> , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , 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.