My Oracle Support Banner

Stack Trace On Save Of User Preference. (Doc ID 2741030.1)

Last updated on JANUARY 04, 2021

Applies to:

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

Symptoms

On : 11.2.0.25 version, General

Stack Trace on Save of User Preference. Trying to change the order of the display on the Quick Search menu. When clicking the Save button after changing the Display order there is a Stack Trace.
 

ERROR
-----------------------
com.adminserver.utl.exception.AsExceptionUtl: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot insert the value NULL into column 'DEFAULTWIDGET', table 'EQDev10.dbo.ASUSERPREFERENCE'; column does not allow nulls. INSERT fails. Error Code: 515 Call: INSERT INTO AsUserPreference (USERPREFERENCEGUID, CENTRALADDENTITYORDER, CLIENTNUMBER, CREATIONTIMESTAMP, DEFAULTWIDGET, ENTITYSUMMARY, PAGELAYOUT, QUICKSEARCHTOOLTIP, SEARCHSUMMARY, STATUSCODE, UNIFIEDSEARCHENTITYORDER, UPDATEDTIMESTAMP, WIDGETDRAWER, WIDGETSEQUENCE, WORKFLOWWIDGET) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [C62341F8-39E0-4388-ABFC-058200AE80C7, Policy,Client,Customer,CustomerFromExisting,Suspense,Batch, VARM7t1, 2036-12-31, null, Y, 01, Y, Y, Active, Client,Case,Policy,Customer,Suspense,Disbursement,Bill,Batch, 2036-12-31, Y, null, null] Query: InsertObjectQuery(com.adminserver.pas.dcl.AsCustomWidgetViewDcl@41ab54fb)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Go to your username in top right corner and select preferences from dropdown
Other preferences
Change sort list so that Client instead of Policy is at top of list
Click the Save button.

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


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