RequirementField Query Does Not Include BigTextValue Column Causing Stack Trace
(Doc ID 2698174.1)
Last updated on AUGUST 07, 2020
Applies to:
Oracle Insurance Policy Administration J2EE - Version 11.2.0.20 and laterInformation in this document applies to any platform.
Symptoms
On : 11.2.0.20 version, General
RequirementField query does not include BigTextValue column causing stack trace. When using Datatype Text Area (05) for Requirement fields there is a scenario when the system loads the requirement records and corresponding fields, however the query used doesn't include the BigTextValue column. When the system tries to load the field data the BigTextValue field data is not there causing an error. Our workaround is to change datatype to Text for the affected fields.
ERROR
-----------------------
Error:
com.adminserver.sre.dal.PASDal.findRequirementsByRequirementGuidList(PASDal.java:2959)
com.equisoft.ape.CreateRequirementResult.loadRequirementStatus(CreateRequirementResult.java:242)
com.equisoft.ape.CreateRequirementResult.createRequirementResult(CreateRequirementResult.java:201)
com.equisoft.ape.CreateRequirementResult.process(CreateRequirementResult.java:110)
com.adminserver.ape.ExternalProcessApe.processRule(ExternalProcessApe.java:65)
com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll.processRule_aroundBody4(TransactionBusinessRulePacketRuleBll.java:133)
com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll$AjcClosure5.run(TransactionBusinessRulePacketRuleBll.java:1)
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Create Requirement Results failed with exception Field Name BigTextValue does not have a value.
at com.equisoft.ape.CreateRequirementResult.process(CreateRequirementResult.java:118)
at com.adminserver.ape.ExternalProcessApe.processRule(ExternalProcessApe.java:65)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add TextArea field to a Requirement. Process an activity that updates the requirementfields.
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 |
| Cause |
| Solution |
| References |