“ORA-01002: Fetch Out of Sequence” error when exporting to a large text file (4324375)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

“ORA-01002: Fetch Out of Sequence” error when exporting to a large text file
Beschreibung

“We have a daily automatic process which exports a text file of around 1GB. This export fails almost every day with the error "Fetch Out of Sequence". It causes the following automated processes to fail and needs a manually re-launch.”
Ursache

The issue is caused by a timeout occurring due to the time taken to export a large amount of data (tested with approximately 1GB). After the timeout occurs, the cursor no longer exists and the error occurs.
Lösung

RESOLUTION:
1) Go to Tools | Options | Database | Timeouts
2) Set all settings to 0.
3) Try the export again.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel