ORA-00600: internal error code with xFlow error "Sorry, your session has already timed out. Please login again."

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Enabled xFlow interface, however, while accessing the queues under the TASKS - "Today's Tasks" or "Pending Tasks", upon clicking them, receiving the following error message. 

"Sorry, your session has already timed out. Please login again."

IncidentMS.log/IncidentMS_debug.log shows:

ERROR        orclclass.c           1313 SQL Statement Failed. ORA: 600  Message: ORA-00600: internal error code, arguments: [qkaffsindex3], [128], [], [], [], [], [], [], [], [], [], [] 
ERROR        orclclass.c           1314 SELECT crwf.sequence, crwf.object_id, crwf.start_date, call_req.persid, crwf.id FROM (crwf LEFT JOIN call_req ON crwf.object_id = call_req.persid) WHERE crwf.assignee = HEXTORAW('6075F3850FC05940812DA4E9F917C283') AND crwf.status = N'PEND' ORDER BY 4 DESC NULLS LAST
ERROR        orcl.c                1762  Oracle error #: 0
ERROR        orcl.c                1763  Oracle msg #: 0
ERROR        vdbmisc.c              688 Miscellaneous Database error occured :ORA-00600: internal error code, arguments: [qkaffsindex3], [128], [], [], [], [], [], [], [], [], [], [] 

Environment

Release : 17.3 or higher

Component : XFLOW INTERFACE FOR SDM

Database: Oracle

Cause

Oracle Database configuration issue

Resolution

Disable _FAST_FULL_SCAN_ENABLED

Reach out to the DBA to run:

alter system set "_fast_full_scan_enabled" = FALSE;