Error: "ORA-01400: Cannot Insert NULL" when creating Activity Document using REST API
(Doc ID 3065970.1)
Last updated on JANUARY 24, 2025
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 22.12 and laterInformation in this document applies to any platform.
Symptoms
When attempting to create an activity note using the REST API the following response is returned:
"message": "Error in DBEngine.executeUpdate: ORA-01400: cannot insert NULL into (\"ADMUSER\".\"TASKDOC\".\"TASKDOC_ID\")"
The issue can be reproduced at will with the following steps:
- Create a project document using a POST request like the following:
https://<HOST>/<SERVICE_INSTANCE>/p6ws/restapi/document
Response:
{
"message": "Error in DBEngine.executeUpdate: ORA-01400: cannot insert NULL into (\"ADMUSER\".\"TASKDOC\".\"TASKDOC_ID\")"
}
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |