Oninit
Talk to an expert →

Informix Error -1329: A database index could not be created for a temporary database table needed for a report.

Cause and resolution

A database index could not be created for a temporary database table needed for a report.

Within the report definition, 4GL generated SQL statements to save rows into a temporary table. However, an index could not be created on the temporary table. Probably an index with the same name already exists in the database. (The sorting index is named "i_reportname"; for example, "i_order_rpt".) Possibly no disk space is available in the file system or dbspace. Another possibility with some database servers is that you have exceeded an operating-system limit on open files. Look for other error messages that might give more details.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1329 fires when 4GL can't create the index needed on a report's temporary table — per the official guidance, the sorting index is automatically named i_reportname (e.g. i_order_rpt); common causes include a name conflict with an existing index, insufficient disk space, or an OS open-file limit.

  1. An index with the same name (i_reportname) already existing, per the official guidance — the first named cause.
  2. Insufficient disk space in the filesystem or dbspace, per the official guidance — the second named cause.
  3. An operating-system open-file limit exceeded, per the official guidance — the third named cause, depending on the database server.
Solutions / Resolution
  1. Check for an existing i_reportname index conflicting with the automatic name.
  2. Check available disk space in the filesystem/dbspace.
  3. Check the OS open-file limit.
  4. Check for additional error messages, per the official guidance, for more diagnostic detail.
Examples
Checking for a naming conflict
SELECT idxname FROM sysindexes WHERE idxname = 'i_order_rpt';
Diagnostic Checks
  1. Check for an existing i_reportname conflict, disk space, and the OS open-file limit, in that rough order of likelihood.
Related Errors / Related Topics
  • -1327 — "An insert statement could not be prepared for inserting rows into a temporary table used for a report." A related report-generation error, about inserting rows rather than the index.
  • -1328 — "A temporary table needed for a report could not be created in the selected database." A related report-generation error, about the temp table's own creation rather than its index.

The report's automatically-named sorting index (i_reportname) couldn't be created — check for naming conflicts, disk space, and the OS open-file limit.