E-COB: Comment or Hint Within SQL Select Stored Statement Causes Crash of COBOL Process "error code: 115, pc=0, call=1, seg=0 115 Unexpected signal (Signal 6)" (Doc ID 2929267.1)

Last updated on MAY 17, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Generic UNIX
Generic Linux

Sample Environment:
------------------------
PeopleTools 8.60.03
Linux 7.9
Visual COBOL version 7 patch 8
Oracle 19.16.0.0

Issue:
-------
COBOL processes are crashing if there is a comment or a hint added to the SQL stored statement.

Replication Steps:
--------------------

1. As an example, update the PS_SQLSTMT_TBL to update the stored statement PTPUSTAT_S_JOBINST.

2. Update the stored statement SQL_TEXT from:

SELECT JOBINSTANCE FROM PSPRCSRQST WHERE PRCSINSTANCE = :1

To:

SELECT /*PTPUSTAT_S_JOBINST*/ JOBINSTANCE FROM PSPRCSRQST WHERE PRCSINSTANCE = :1

3. Run the PTPDBTST process.

4. Locate, open the process_state.txt file. and observe the stack trace errors above.

PeopleTools upgrade from 8.59.14 to 8.60.03

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.