My FastExport query failed twice both times the error in the log file was ‘RDBMS Error one of the FastExport session has been logged off’.
Kindly provide reason for session getting logged off as here the query was not aborted and there is no trace as of why the sessions were logged off in viewpoint either.
Adding to it, I tried to find explanation for error 2594 and remedy for it what I got is to delete the answer set spool file if necessary and then resubmit the SQL Select. So my second question is how to find answer set spool file? and Is it actually necessary? How far this remedy given can be useful?
Thanks in advance.
how long has the export ran before it throws out the error that one of the session logged off? Usually it so happens that when a export is run with multiple sessions, only one of them will be inactive state and the remaining sessions will be idle. you can check with your DBA to know the maximum idle time allowed for a session to stay on the system before aborting the sessions.