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 for Me (Login required).

Search for additional results

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