• 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