Submitted by: Buvan (buvanmca)

During restoring my database I received such error: Can you please guide me how to fix this issue.

gbak: activating and creating deferred index PK_CISTA
gbak:cannot commit index PK_CISTA
gbak: ERROR:sort error
gbak: ERROR: No free space found in temporary directories
gbak: ERROR: operating system directive write failed
gbak: ERROR: Success
gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
gbak: ERROR: Cannot deactivate index used by a PRIMARY/UNIQUE constraint
gbak:Exiting before completion due to errors

Note : The index table contain around 170000000 records.

CREATE TABLE CLIENT_IMPORT_SUB_TABLE_ARCHIVE (
CLIENT_IMPORT_SEQNO T_SEQNO_REQUIRED /* T_SEQNO_REQUIRED = INTEGER NOT NULL */,
PARAMETER_ID T_FIELD_NAME_REQ /* T_FIELD_NAME_REQ = VARCHAR(31) NOT NULL */,
PARAMETER_VALUE T_NOTES_256 /* T_NOTES_256 = VARCHAR(256) */
);

ALTER TABLE CLIENT_IMPORT_SUB_TABLE_ARCHIVE ADD CONSTRAINT PK_CISTA PRIMARY KEY (CLIENT_IMPORT_SEQNO, PARAMETER_ID);

ALTER TABLE CLIENT_IMPORT_SUB_TABLE_ARCHIVE ADD CONSTRAINT FK_CISTA_CIA_SEQNO FOREIGN KEY (CLIENT_IMPORT_SEQNO) REFERENCES CLIENT_IMPORT_ARCHIVE (CLIENT_IMPORT_SEQNO);