StackOverflowError When Using Long String In The Agent SQL Query. (Doc ID 1232795.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Transportation Management - Version 6.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Sep-2012***

Symptoms


When attempting to execute an agent that is configured with any  Direct SQL Update query with long value, the following error occurs.

ERROR
-----------------------
java.lang.StackOverflowError
at org.apache.regexp.RE.matchNodes(RE.java:933)


An example DSU query with long  msg_body value:
-------------------------------------------------
INSERT INTO sniotm.freefrm_msg
(msg_id,enty_type,enty_id,subj,msg_body,cre_usr_id,cre_dttm,UPD_USR_ID,UPD_DTTM,PRCS_FLG)
SELECT SNIOTM.FREEFRM_MSG_SEQ.nextval,'DRIVER', RPT_GENERAL.F_REMOVE_DOMAIN(IES.DRIVER_GID), 'TRACTOR UNIT PICKUP OR DROP FAILED','TRACTOR UNIT PICKUP FAILED, DRIVER IS ALREADY ASSIGNED TO '|| $ASGND_PU ||' POWER UNIT, PLEASE SEND A DROP MESSAGE FOR THE EXISTING POWER UNIT',vpd.get_gl_user(),sysdate,vpd.get_gl_user(),sysdate,'N' FROM ie_shipmentstatus ies
WHERE ies.i_transaction_no =$GID

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms