I am runing an option of a report and system show me this errorate:
02/07/2003 Time: 19:50:48
Program error at "report r_impresion_remesa_pagos", line number 0.
FORMS statement error number -1328.
A temporary table needed for a report could not be created in
the selected database. The user must have permission to
create tables in the selected database, and there must be no
existing table named "t_<reportname>" already in the database.
It seems to me the server cannot create a temporary file.
is /tmp full?
is $DBTEMP full?
check the owner of the SE process and check the user rights on both directories. The owner of the process should be allowed to write in these directories.
My suggestion would be:
set DBTEMP and let it point to a directory with 777 rights and enough free space.
SE needs it to create temporary tables.
Does the user have enough permissions in the database?
Does the temp table already exist?
Are you able to create a temporary table manually with that user?
I had the same error occur when I moved several 4gl programs from Informix SE version 7.2 running under HP/UX version 10.2 to Informix SE version 7.31 running under HP/UX version 11.0. I found that the DBTEMP variable had no effect at all on the error, but I did notice that the report name used by georgipa was "r_impresion_remesa_pagos" which means a temp table named "t_r_impresion_remesa_pagos" had to be created. The name of my report was "issue_slip_report" which required a table named "t_issue_slip_report" to be created. On a hunch, I tried renaming my report to "is_rpt" and recompiled. The program ran without a flaw. It seems that the older version of Informix had allowed longer table names than the newer version. Of course, this result does not reflect the wording of the error message, but is good to have something that worked.