Oninit
Talk to an expert →

Informix Error -9046: The report output file filename could not be opened. This is probably due to permissions.

Cause and resolution

The report output file filename could not be opened. This is probably due to permissions.

The report was directed to the destination shown, either with a REPORT TO statement or through the contents of the DBPRINT environment variable. Make sure that the destination was spelled correctly. Verify that your account has operating-system permissions to write the destination file and that the destination disk is writable and not full.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9046 fires when the report's destination file (set via a REPORT TO statement or the DBPRINT environment variable) couldn't be opened — per the official guidance.

  1. Insufficient operating-system permissions to write the destination file, per the official guidance — the direct, primary cause.
  2. A misspelled destination filename, per the official guidance.
  3. A full or non-writable destination disk, per the official guidance.
Solutions / Resolution
  1. Make sure the destination was spelled correctly, per the official guidance.
  2. Verify the account has operating-system permissions to write the destination file, per the official guidance.
  3. Verify the destination disk is writable and not full, per the official guidance.
Examples
Checking destination permissions
$ ls -ld $(dirname /path/to/report_output.txt)
$ df -h /path/to
Diagnostic Checks
  1. Check the destination path's permissions and free disk space, and correct the REPORT TO / DBPRINT destination if it's spelled wrong.
Related Errors / Related Topics
  • -9047 — "The output file filename could not be created." A related output-file error, on creation rather than opening an existing path.
  • -9048 — "The pipe pipe-specification could not be opened." A related report-destination error, for a pipe target rather than a file.

The report's destination file couldn't be opened, usually a permissions or disk-space issue — check the destination path and disk.