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 JANUARY 24, 2011

Applies to:

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


To view full details, 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 a vibrant support community of peers and Oracle experts.