Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: The support homepage carousel is not displaying. We are working toward a resolution.

Qlik Replicate and SAP Extractor source: SQL error SQL code: -10807 occurred while accessing table 'TABLE_NAME'

100% helpful (1/1)
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DesmondWOO
Support
Support

Qlik Replicate and SAP Extractor source: SQL error SQL code: -10807 occurred while accessing table 'TABLE_NAME'

Last Update:

Sep 20, 2023 4:58:10 AM

Updated By:

john_wang

Created date:

Sep 20, 2023 3:21:45 AM

After a full load runs for an extended duration (example: twelve hours or longer), Qlik Replicate may report the following error: 

java.lang.RuntimeException: SAP aborted the extraction job.

This error indicates that the extraction job was terminated by SAP.

After reviewing the SAP dump log, it was found that the job was terminated due to the following error:

SQL error 'SQL code: -10807' occurred while accessing table 'TABLE_NAME'

Resolution

To address this issue, please increase the suspended_cursor_lifetime parameter on the SAP side. If the issue persists, it is advisable to consult with your SAP administrator.

Environment

Qlik Replicate all versions
Source Endpoints: SAP Extractor

Internal Investigation ID(s):

Support case: 00105401, CC-10774

Qlik Replicate
Thumbnail of Qlik Replicate
Qlik Replicate
Labels (1)
Labels:
2,126 Views
Was this article helpful? Yes No
Version history
Last update:
‎2023-09-20 04:58 AM
Updated by:
Support