Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: About SQLError, sqlcode = -255 , sqlerrd[1] = 0

    Dear All,
    Please help me on the following issue:

    I found the error "SQLError, sqlcode = -255 , sqlerrd[1] = 0" in the log file. Can you please let me how can I get the problematic SQL statement. I cannot see the sql what caused the error.


    Thanks a lot in advance.

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    OK, can you tell me in which logfile the entry occurs, does it give information about the program where and/or instance when it occurred? And can you repeat the situation that generates the error? The onstat utility can provide insight in the SQL statements last run by the active sessions. For that you must know the id of the regarding session. At runtime you can get the active session id's with
    Code:
    onstat -g ses
    run from the command line. This produces a list with session id as the first column. With the right session id you should run
    Code:
    onstat -g sql session id
    which shows the last parsed SQL statement by the session.
    But for this the session must still be active after the error occurred and if the error causes the program to abort you have a problem.

    Regards

Posting Permissions

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