cannot insert NULL into ("IDEMPIERE"."AD_USERMAIL"."AD_USER_ID")
Description
When I run the idempiere service, I notice a ora error in the log file: ++++++++++++++++++++++++++++++++++++++++++++++ 01:27:27.614===========> DB.executeUpdate: INSERT INTO AD_UserMail (AD_Client_ID,AD_Org_ID,AD_UserMail_ID,AD_UserMail_UU,Created,CreatedBy,IsActive,IsDelivered,MailText,MessageID,Subject,Updated,UpdatedBy) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) [POSaveAD_UserMail_624e75f7-42b9-4a1f-a754-9537846aa79a] [15] java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("IDEMPIERE"."AD_USERMAIL"."AD_USER_ID") ++++++++++++++++++++++++++++++++++++++++++++++
-------------------------------------------------------
Platform: SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 3 Oracle Database 11g 11.2.0.3.0
Environment
None
Attachments
2
UserMail-Error.log
20 Apr, 2015
idempiere_20130928012642.log
28 Sep, 2013
Activity
Carlos Ruiz
July 11, 2018 at 3:38 PM
Closing, probably a misconfiguration
Carlos Ruiz
April 20, 2015 at 10:16 PM
I see, this error seems to be caused by a misconfiguration in the email
When I run the idempiere service, I notice a ora error in the log file:
++++++++++++++++++++++++++++++++++++++++++++++
01:27:27.614===========> DB.executeUpdate: INSERT INTO AD_UserMail (AD_Client_ID,AD_Org_ID,AD_UserMail_ID,AD_UserMail_UU,Created,CreatedBy,IsActive,IsDelivered,MailText,MessageID,Subject,Updated,UpdatedBy) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) [POSaveAD_UserMail_624e75f7-42b9-4a1f-a754-9537846aa79a] [15]
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("IDEMPIERE"."AD_USERMAIL"."AD_USER_ID")
++++++++++++++++++++++++++++++++++++++++++++++
-------------------------------------------------------
Platform:
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3
Oracle Database 11g 11.2.0.3.0