SAP Knowledge Base Article - Preview

3075030 - CIS: Select remote text column from table located in ORACLE hangs - ASE

Symptom

Select from a proxy table with a text column over Direct Connect for Oracle hangs indefinitely.

ASE's log (information from CIS trace):

=====

00:0006:00000:00025:2021/07/07 14:48:28.69 server  TXTQUERY, spid 25: cursor opened; name TC15.
00:0006:00000:00025:2021/07/07 14:48:28.69 server  CT_PARAM, spid 25: 1, @p1, BINARY(16)='0x0400000100d0b233270000010600c41b'
00:0006:00000:00025:2021/07/07 14:48:28.86 server  TXTABORT, spid 25: deallocating cursor 'TC15'

====
 
From the ASE log, there is a TXTABORT. There is an issue with the value of the textpointer.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP03 and higher

Product

SAP Adaptive Server Enterprise 16.0

Keywords

OMNI CIS DCO Direct Connect ORACLE proxy table hang TXTABORT text 817607 CR817607 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.