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