Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2012
    Posts
    4

    Post Unanswered: ORA-24334: no descriptor for this position

    The application where we have used the OCI landing up in the error “ORA-24334: no descriptor for this position” after some 4 hours.
    A restart after this error is helping but still the solution will not be considered stable because of this.


    The SQL is something like:
    INSERT
    INTO BL_TEST_RAW
    (
    FILE_ID,
    SEQ_NUMBER,
    ID,
    CONN_TIME,
    XYZ_START_TIME,
    XYZ_END_TIME,
    XYZ_ORIG_SOURCE_IP,
    XYZ_USED_SOURCE_IP,
    XYZ_ORIG_DESTINATION_IP,
    XYZ_USED_DESTINATION_IP,
    XYZ_SOURCE_PORT,
    XYZ_ORIG_DESTINATION_PORT,
    XYZ_USED_DESTINATION_PORT,
    XYZ_USER_ID,
    XYZ_WIRELESS_BYTES_IN,
    XYZ_WIRELESS_BYTES_OUT,
    XYZ_INTERNET_BYTES_IN,
    XYZ_INTERNET_BYTES_OUT,
    XYZ_FLAGS,
    XYZ_INTERNET_PORT,
    XYZ_URL,
    XYZ_INTERNET_METHOD,
    XYZ_INTERNET_RET_STATUS,
    XYZ_INTERNET_SERVER_TYPE,
    XYZ_INTERNET_COOKIES_USED,
    USER,
    TYPE,
    ID_2,
    INSERTED_DATE,
    SERVICE
    )
    VALUES
    (
    :1,
    :2,
    :3,
    to_date (:4, 'YYYYMMDDHH24MISS'),
    to_date (:5, 'YYYYMMDDHH24MISS'),
    to_date (:6, 'YYYYMMDDHH24MISS'),
    :7,
    :8,
    :9,
    :10,
    :11,
    :12,
    :13,
    :14,
    :15,
    :16,
    :17,
    :18,
    :19,
    :20,
    :21,
    :22,
    :23,
    :24,
    :25,
    :26,
    :27,
    :28,
    SYSDATE,
    :29
    )
    The script is using OCI Library to communicate with ORACLE.

    Does someone know what could be the issue and any guidance on this? Tried searching some posts but didn’t help much.

    Please help.

    Thank and Regards,
    DbUser595

  2. #2
    Join Date
    Jun 2012
    Posts
    4
    Can some please help on this?

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You're going to have to help us a bit more if you want us to help you.
    The application where we have used
    What application?
    Has it ever worked? If yes, what changes have been made to stop it working?
    A restart after this error is helping
    A restart of what? Helping in what way?
    The SQL is something like
    To fix the error you need to do something like change a value. Not really helpful, eh? So how are we supposed to help if you're only showing us 'something like' what you're trying to do?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jun 2012
    Posts
    4
    Apologize if I am not clear at any point. I will try to elaborate little more.

     The application is internal. The application uses a wrapper scripting language where we are using OCI to communicate with DB.
     This SQL is working fine in that script. But sometimes it logs ORA-24334. Occurrence of this error is 4hrs-5hrs. Means every 4-5hrs I am facing this error on script. As soon as the scripts encounters an error it stops processing files.
     Processing of this script is:: It parse the files and stores the records into DB by bulk insertion using bind variables.
     When I again executes the script it does not give me any error like this for next 4 hrs. Script even parse the same files which encountered error in previous run.
     SQL is exactly same as given below:
    INSERT INTO BL_TEST_RAW
    (
    FILE_ID,
    SEQ_NUMBER,
    ID,
    CONN_TIME,
    XYZ_START_TIME,
    XYZ_END_TIME,
    XYZ_ORIG_SOURCE_IP,
    XYZ_USED_SOURCE_IP,
    XYZ_ORIG_DESTINATION_IP,
    XYZ_USED_DESTINATION_IP,
    XYZ_SOURCE_PORT,
    XYZ_ORIG_DESTINATION_PORT,
    XYZ_USED_DESTINATION_PORT,
    XYZ_USER_ID,
    XYZ_WIRELESS_BYTES_IN,
    XYZ_WIRELESS_BYTES_OUT,
    XYZ_INTERNET_BYTES_IN,
    XYZ_INTERNET_BYTES_OUT,
    XYZ_FLAGS,
    XYZ_INTERNET_PORT,
    XYZ_URL,
    XYZ_INTERNET_METHOD,
    XYZ_INTERNET_RET_STATUS,
    XYZ_INTERNET_SERVER_TYPE,
    XYZ_INTERNET_COOKIES_USED,
    USER,
    TYPE,
    ID_2,
    INSERTED_DATE,
    SERVICE
    )
    VALUES
    (
    :1,
    :2,
    :3,
    to_date (:4, 'YYYYMMDDHH24MISS'),
    to_date (:5, 'YYYYMMDDHH24MISS'),
    to_date (:6, 'YYYYMMDDHH24MISS'),
    :7,
    :8,
    :9,
    :10,
    :11,
    :12,
    :13,
    :14,
    :15,
    :16,
    :17,
    :18,
    :19,
    :20,
    :21,
    :22,
    :23,
    :24,
    :25,
    :26,
    :27,
    :28,
    SYSDATE,
    :29
    )

    Logic of the code goes:
    -> Declaration of Oracle bind Variables to pursue bulk insertion.
    -> Add the values parsed from the records into these Oracle Bind Variables.
    -> Execute the above statement by passing Oracle Bind Variables in try catch block.

    Please let me know if I am not clear in any point. I hope it clear a little more about my issue.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    does application code contain any EXCEPTION handler code?

    I suspect a latent data dependent bug in application code.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2012
    Posts
    4
    -> We do have Exception handler in code.
    -> What you mean by latent data dependent bug? Can you please describe a little bit?

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    -> We do have Exception handler in code.
    if problem can be replicated in Development DB, test code after removing all EXCEPTION handler
    delete, remove, & eliminate all EXCEPTION code
    For reason why check these links.

    http://tkyte.*************/2007/03/d...kes-again.html

    http://tkyte.*************/2008/01/w...e-do-this.html

    http://tkyte.*************/2007/03/challenge.html


    -> What you mean by latent data dependent bug? Can you please describe a little bit?

    SELECT COL1/COL2 FROM TABLEA;
    error gets thrown when COL2=0; SQL above contains data dependent bug.
    code could be acting badly due to some obscure, infrequent & unexpected data value
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    Are you 100% sure that it is actually the SQL statement execution that is generating the error?
    Reason I ask is because the ORA-24334 error is caused by "the application trying to get a descriptor from a handle for an illegal position".
    The error is may be generated from a related OCI function call. I would guess, the error could be raised when setting bind variable values using OCIBindByPos.
    Alternatively, if it is raised from the execution of the statement, it might be that the bind variable is not set correctly.
    It's really difficult to say. Maybe post some OCI code? if so, use code tags please.

Tags for this Thread

Posting Permissions

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