Results 1 to 9 of 9

Thread: error in report

  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Red face Unanswered: error in report

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    I am using informix-SE.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    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.

  6. #6
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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?
    rws

  7. #7
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    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.

  8. #8
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  9. #9
    Join Date
    Aug 2003
    Location
    Utah
    Posts
    1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •