Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle errors: update_cursor98 z76, update_cursor99 z601; fetch out of sequence

    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    The following sequence of transactions appears several times in the pc_server log at 11:12 and 11:13 on the morning of Oct. 5 for user FLICKA:

    DESCRIPTION: Get Budget List
    ACTION : GROUP
    PROGRAM : pc_com_c0116

    Oracle error: update_cursor98 z76
    ORA-01480: trailing null missing from STR bind value
    ...
    ...
    DESCRIPTION: Get Budget Balance
    ACTION : HTML
    PROGRAM : pc_com_c0115

    Oracle error: update_cursor99 z601
    ORA-01480: trailing null missing from STR bind value
    ...
    ...
    DESCRIPTION: Print Budget Information
    ACTION :
    PROGRAM : pc_com_c0130

    Oracle error: update_cursor99 z601
    ORA-01003: no statement parsed

    Oracle error: fetch z601
    ORA-01002: fetch out of sequence

    Oracle error: update_cursor98 z76
    ORA-01003: no statement parsed
    ...
    ...
    DESCRIPTION: Get Budget List
    ACTION : GROUP
    PROGRAM : pc_com_c0116

    Oracle error: update_cursor98 z76
    ORA-01003: no statement parsed

    Oracle error: fetch budget
    ORA-01002: fetch out of sequence
    ...
    ...
    DESCRIPTION: Get Budget Balance
    ACTION : HTML
    PROGRAM : pc_com_c0115

    Oracle error: update_cursor99 z601
    ORA-01003: no statement parsed

    Oracle error: fetch z601
    ORA-01002: fetch out of sequence

    The messages appeared only during these two minutes.

    Resolution:
    The errors apparently occurred when FLICKA was trying to produce a list of object codes, unsuccessfully. A few days later she did the same thing with no problem. There aren't any 'fetch' errors in the recent pc_server logs.


    • Article last edited: 10/8/2013