Hi,

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.


You can tell me the reason of this error.

Thank you.

What database server do you work with, SE or IDS?
if SE, check permissions and freespace of $DBTEMP and /tmp
if IDS, check if you have a temporary dbspace.

I am using informix-SE.

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.

Hi,

I not understand, becuase the enviroment variable DBTEMP not is set and in /tmp there are space.

If run other option of a report not problem, is only with this option, with the same user.

Than you.

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?

Hi,

If, I create a table manually by dbaccess no problem.

You can tell me how to set the enviroment variable DBTEMP and what is the directory that will be have rights 777 and enough permissions in the database.

Thank you.

In korn shell, it would be something like:

create a directory temp: mkdir /informix/temp
Change the user rights: chmod 777 /informix/temp

Set the environment variable:
DBTEMP=/informix/temp
export DBTEMP

start SE daemon.

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.