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: 1.5.0.10 and later   [Release: 1.5 and later ]
Information in this document applies to any platform.

Symptoms

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.

Cause

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.