Results 1 to 7 of 7
  1. #1
    Join Date
    May 2004
    Posts
    3

    Angry Unanswered: stored procedures trace

    Hi!

    I have a problem. My informix server(Informix Dynamic Server Version 7.31) is installed on linux Red hat 8.0 (2.4.18-14). My application is running on SCO Unix(SCO_SV 3.2 2 i386).

    If I set trace on in stored procedure, I get error in app.
    "
    Program stopped at "nad_zaj.4gl", line number 1718.,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    SQL statement error number -648.
    Cannot open DEBUG file for stored procedure trace.
    SYSTEM error number -2.
    No such file or directory
    "

    Does anyone know how to solve this problem, becouse it is annoying to write stored procedures without trace.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    -648 Cannot open DEBUG file for SPL routine trace.

    An error occurred trying to open DEBUG trace file. This error can occur
    when one of the directories in the specified debug file name does not
    exist, or the directory is write protected. Check that the directory
    path is valid and that group informix can write to the directory.


    -2 No such file or directory.

    An operating-system error code with the meaning shown was unexpectedly
    returned to the database server. Look for other operating-system error
    messages that might give more information.

    Suggest you check the trace file path and use "informix" account access server.
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Check the permisions on the file that the path is pointing to

  4. #4
    Join Date
    May 2004
    Posts
    3
    Thank you for prompt reply!

    But this is not the sollution. A have created directories on both server with all permisions, then set log file and path to this directory but it doesn work.

    If I run application on linux, then trace works fine. It looks like there is some problem between linux-SCO

    PS: Changing app. server is not an option

  5. #5
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    Use hosts.equiv in Linux machine
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

  6. #6
    Join Date
    May 2004
    Posts
    3
    What do I do with it.

    I have allready put the name of server in /etc/hosts.equiv on both servers (unix and linux).

    Stored procedures are working fine, only trace doesn't work.

  7. #7
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    I use dbaccess tool test the trace between Linux's IDS7.31UD6 and Windows2000's IDS9.40TC2,no problem.
    The procedure's trace file come into being $HOME of connect user.
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

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