SAP Knowledge Base Article - Preview

2228514 - Crashed at stcxtlib/st_server.cxx:1921 during UPDATE - SAP IQ

Symptom

A monthly batch job was running at the moment of the crash.
It is not a newly added batch job and a regular monthly batch job and has ran without any error until 2015-09-23.

UPDATE
TAB001
SET COL001 = b.COL002
, COL003 = (SELECT CASE WHEN BYTE_LENGTH(TRIM(iA.COL004)) > 50
THEN SUBSTRING(TRIM(iA.COL004), 1,25)
ELSE iA.COL004
END
FROM TAB002 iA
WHERE iA.COL005 = b.COL002
)
FROM TAB001 a
, ( SELECT DISTINCT a.COL006.......
) b
WHERE a.COL005 = b.COL005
AND a.COL006 = b.COL006
AND a.COL007 = b.COL007
;

[Error Messages]
...
I. 09/23 05:19:41. 0000130966
I. 09/23 05:19:41. 0000130966 **************************************************
I. 09/23 05:19:41. 0000130966 *** SAP IQ Abort:
I. 09/23 05:19:41. 0000130966 *** From: stcxtlib/st_server.cxx:1921
I. 09/23 05:19:41. 0000130966 *** PID: 24332
I. 09/23 05:19:41. 0000130966 *** Message: caught signal 11, program abort
I. 09/23 05:19:41. 0000130966 *** Thread: 248 (TID: 108)
I. 09/23 05:19:41. 0000130966 **************************************************
I. 09/23 05:19:41. 0000130966
I. 09/23 05:19:41. 0000130966 ** Error from IQ connection: SA connHandle: 14661 SA connID: 84 IQ connID: 0000130966 User: user001
I. 09/23 05:19:41. 0000130966 ** Time of error: 2015-09-23 05:19:41
I. 09/23 05:19:41. 0000130966 ** IQ Version: SAP IQ/16.0.102/20057/P/sp10.03
I. 09/23 05:19:41. 0000130966 ** OS info: IQ built on: ITANIUM/HP-UXi 11.31, Executed on: HP-UX/host002/B.11.31/U/ia64
I. 09/23 05:19:41. 0000130966 ** Command status when error occured: CURSOR ACTIVE
I. 09/23 05:19:41. 0000130966 ** Command text:
...

The stacktrace file was incomplete and there was no thread stack in this file.
It was the same context with the last context of the iqmsg file.

Customer informed that he reran the same batch job without any modification and could not reproduce the same crash.
The following tables used in the problematic update statement were checked by sp_iqcheckdb and proved to have no inconsistency.


Read more...

Environment

SAP IQ 16.0 SP10 PL03 HPIA 64bit
3 Node Multiplex ( 1 Coordinator / 2 Secondary Writer nodes )
OS : HP-UX B.11.31 U ia64

Product

SAP IQ 16.0

Keywords

SAP IQ, crash, stcxtlib/st_server.cxx:1921 , KBA , BC-SYB-IQ , Sybase IQ , 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.