Occurrences Of ORA-01400: cannot insert NULL into ("MWMTEST"."DHTCREWACT"."CREWACT_ID") "...Error Writing Crewlog Record..." In The Server.exe Logs Due To Missing DHTCREWACT_PREINSERT_TRIG Trigger (Doc ID 1286710.1)
Last updated on JANUARY 24, 2011
Oracle Utilities Mobile Workforce Management - Version: 220.127.116.11 and later [Release: 1.5 and later ] Information in this document applies to any platform.
In the server audit and trace logs, an error relating to crew assignments is occurring frequently. The error message is "WARNING: SchedulerAllocate::Error writing crewlog record for User" is being generated multiple times for all crews. This is followed by "Database exception occurred / Error=ORA-01400: cannot insert NULL into ("MWMTEST"."DHTCREWACT"."CREWACT_ID").
It is not clear if this error is causing any functional problems or is affecting system response times.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms