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.