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.
SAP Knowledge Base Article - Preview