My Oracle Support Banner

CopyToPendingFields Attached Rule Crash (Doc ID 2595787.1)

Last updated on OCTOBER 04, 2019

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.0.15 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
CopyToPendingFields attached rule crash. When this rule is running and trying to change another transaction, it's crashing. The stack doesn't provide the root cause however. Inside the
DataRetrieerDal.findRedoActivityGuidAndStatusCodeForRelatedGuid
when it's running the line: getSecondaryDataAccessHelper().executeSelectQuery(query, new Object[] { relatedGuid });
  it gets into this line (in the and tries to add a parameter : preparedStatement.setString(parameterIndex, (String)parameter);

The sql query it already generated (and transformed into a prepared statement) does not want a parameter.

The query/prepared statement has a value of:
SELECT AsActivity.ActivityGUID AS "ActivityGUID", AsActivity.StatusCode AS "StatusCode" FROM AsActivity WHERE AsActivity.RelatedGUID IN ( '40EBE0DC-69EE-4D8B-BA07-7A1D9590E89B' ) AND AsActivity.TypeCode IN ( '01', '04' ) AND AsActivity.StatusCode IN ( '02', '09', '12' )


preparedStatement.setString(parameterIndex, (String)parameter);


When it runs the ‘setString’ method, it’s crashing with the following error:
com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.

Changes

 

Cause

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
Changes
Cause
Solution
References


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