IBM Support

"Could not allocate space for object 'dbo.Event'" Exception during Content Platform Engine Upgrade

Troubleshooting


Problem

Conteng Platform Engine (CPE) upgrade fails during the asynchronous event upgrade phase

Symptom

CPE upgrade fails with the following exception:


2015-03-04T11:11:59.137 A82D95F9 ENG FNRCD0009E - ERROR ObjectStoreUpgrade(OS1) Asynchronous Event Task: encountered an exception. com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 1,105, Message 'Could not allocate space for object 'dbo.Event' in database 'db1' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.' ObjectStore: "UCB", SQL: ""INSERT INTO dbo.Event (object_id, object_class_id, security_id, epoch_id, home_id, creator, create_date, modify_user, modify_date, source_object_id, source_object_class_id, status, serialized_source_object, query_text, version_series_id, lifecycle_change, element_name, audit_level, initiating_user, sequence_number, serialized_orig_object) SELECT object_id, object_class_id, security_id, epoch_id, home_id, creator, create_date, modify_user, modify_date, source_object_id, source_object_class_id, status, serialized_source_object, query_text, version_series_id, lifecycle_change, element_name, audit_level, initiating_user, sequence_number, serialized_orig_object FROM dbo.LegacyEvent WHERE object_id = ?"

Cause

CPE needs to make a clone of the Event table during the upgrade, and the file system has ran out of disc space.

Diagnosing The Problem

Look for the ""Could not allocate space for object 'dbo.Event'" error message in CPE error logs.

Check and see if the database's file system has ran out of disc space.

Resolving The Problem

Allocate more disc space on the database's file system.

[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"5.2.1;5.2","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21962615