Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'status' cannot be null: INSERT INTO {tmp_8fab66apidoc_field_revision}

I'm using Apigee Developer Portal Kickstart with a version of 8.7.3 and trying to update the version from 8.7.3 to 8.9.7.

Before I update the version I checked the drush updb, it has listed an update to be done in the apigee api catalog table. Please refer below table.

But when I try to run "Yes" it shows " Integrity constraint violation: 1048" in the temp table "{tmp_8fab66apidoc_field_revision}". Have you come across this kind of issue? Please share your experience. Much appreciated for your assistance.

-------------------- ----------- --------------- ---------------------------------------
Module Update ID Type Description
-------------------- ----------- --------------- ---------------------------------------
apigee_api_catalog 8701 hook_update_n Update the length of the name field.
-------------------- ----------- --------------- ---------------------------------------

Do you wish to run the specified pending updates? (yes/no) [yes]:
> yes

[warning] The following module is missing from the file system: admin_toolbar_search bootstrap.inc:277
[warning] The following module is missing from the file system: path_alias bootstrap.inc:277
> [notice] Update started: apigee_api_catalog_update_8701
> [error] Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'status' cannot be null: INSERT INTO {tmp_8fab66apidoc_field_revision} (id, revision_id, langcode, status, name, description__value, description__format, spec__target_id, spec__display, spec__description, api_product, created, changed, default_langcode, revision_translation_affected) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14); Array
> (
> [:db_insert_placeholder_0] => 16
> [:db_insert_placeholder_1] => 36
> [:db_insert_placeholder_2] => en
> [:db_insert_placeholder_3] =>
> [:db_insert_placeholder_4] =>
> [:db_insert_placeholder_5] =>
> [:db_insert_placeholder_6] =>
> [:db_insert_placeholder_7] =>
> [:db_insert_placeholder_8] =>
> [:db_insert_placeholder_9] =>
> [:db_insert_placeholder_10] =>
> [:db_insert_placeholder_11] =>
> [:db_insert_placeholder_12] =>
> [:db_insert_placeholder_13] =>
> [:db_insert_placeholder_14] =>
> )
> in Drupal\Core\Database\Connection->handleQueryException() (line 689 of C:\xampp\htdocs\developerPortal\docroot\core\lib\Drupal\Core\Database\Connection.php).
> [error] The entity update process failed while processing the entity type apidoc, ID: 16, revision ID: 36.
> [error] Update failed: apigee_api_catalog_update_8701
[error] Update aborted by: apigee_api_catalog_update_8701
[error] Finished performing updates.