E-ES: SQL SERVER Errors "The transaction log for database 'tempdb' is full due to" or "Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup" When Attempting to Run a Full Build for Large Indexes (Doc ID 2967953.1)

Last updated on AUGUST 17, 2023

Applies to:

Symptoms

When attempting to run Full Build for large indexes, such as EP_AM_METRIC_KIB, EP_GL_ACT_BUDG_LEDG_KIB, EP_GL_LEDGER_KIB, and EP_GL_JOURNAL_KIB, the following types of errors can be observed in the  <PS_CFG_HOME>/appserv/prcs/<Domain Name>/log_output/AE_PTSF_GENFEED_<processInstance>.stdout file.

- The transaction log for database 'tempdb' is full
- Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup
- Could not allocate space for object

The issue was reproducible in the customer site with the following steps:
1. Navigate to PeopleTools > Search Framework > Administration > Schedule Search Index.
2. Create a new Run Control ID and run the full build for the index.
3. Observe the errors in the <PS_CFG_HOME>/appserv/prcs/<Domain Name>/log_output/AE_PTSF_GENFEED_<processInstance>.stdout file.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.