My Oracle Support Banner

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 MARCH 14, 2019

Applies to:

Oracle Utilities Mobile Workforce Management - Version 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.


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

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