OLAM: After upgrading to OLAMv2.2, Jobs fails with "psycopg2.errors.NotNullViolation" errors
(Doc ID 3061947.1)
Last updated on DECEMBER 09, 2024
Applies to:
Linux OS - Version Oracle Linux 8.9 with Unbreakable Enterprise Kernel [5.15.0] and laterLinux x86-64
Symptoms
On a recently upgraded OLAMv2.2 environment, jobs fail to execute with the below error in the User Interface
Traceback (most recent call last):
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/tasks/jobs.py", line 624, in run
self.pre_run_hook(self.instance, private_data_dir)
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/tasks/jobs.py", line 1112, in pre_run_hook
local_project_sync = job.project.create_project_update(_eager_fields=sync_metafields)
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/models/projects.py", line 417, in create_project_update
return self.create_unified_job(**kwargs)
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/models/unified_jobs.py", line 390, in create_unified_job
unified_job.save()
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/models/projects.py", line 652, in save
return super(ProjectUpdate, self).save(*args, **kwargs)
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/awx/main/models/unified_jobs.py", line 869, in save
Traceback (most recent call last):
File "/var/lib/ol-automation-manager/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.NotNullViolation: null value in column "task_impact" of relation "main_unifiedjob" violates not-null constraint
DETAIL: Failing row contains (1081, 2024-11-29 10:40:42.633061+00, 2024-11-29 10:40:42.63308+00, , Demo Project, null, sync, f, running, f, 2024-11-29 10:40:42.632828+00, null, 0.000, , , , , null, , 067df5cc-2e6a-4a83-9665-54a136b913c0, null, null, 10, null, 6, 10.0.0.165, 7, 0, 10.0.0.165, null, f, 1, null, {}, , null, null, null, null, {}).
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 |