Enabling Notification Settings via MUX Populates Application CA Logs with Errors

Products

• Clarity PPM On Premise
• Clarity FedRAMP
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce: 

1. Login to Clarity Classic UX with appropriate rights
2. In Clarity Classic UX navigate to Home --> Account Settings --> Notifications
3. Disable all the notifications and click save
4. Now navigate to Modern UX --> Click on Avatar --> Settings --> Notifications and enable the notifications for each functional area

Expected Results: Notification are enabled for the users and no errors should be seen in logs 

Actual Results: Notification are enabled for the users and below errors are seeing in the app ca logs 

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CLARITY"."CLB_NOTIFICATION_PREFS"."NOTIFICATION_TYPE")

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
	at jdk.internal.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:123)
	at jdk.proxy2/jdk.proxy2.$Proxy87.execute(Unknown Source)
	at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute(SQLTracePreparedStatement.java:112)
	at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3896)
	... 113 more
Caused by: Error : 1400, Position : 286, Sql = INSERT INTO CLB_NOTIFICATION_PREFS
        ( NOTIFICATION_TYPE, 
          METHOD,
          PRINCIPAL_TYPE,
          STATUS,
          USER_ID,
          CREATED_DATE, 
          CREATED_BY, 
          LAST_UPDATED_DATE, 
          LAST_UPDATED_BY
        )

Environment

Clarity 16.3.3

Cause

DE177850

Resolution

DE177850, in review by Engineering