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

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