When you try to do Data Extraction in BW system, the extraction will fail for all the data sources and you will get an error message like below.
"SUBMIT authorization SODQADM required for program ODQ_TASK"
SAP Cloud For Customer
SAP Business By Design
When you switch to Pagination (Open Fetch) Method, it is a mandatory step that the Communication Arrangement needs to be Reactivated.
If this step is not followed, the necessary roles will not be assigned to the technical user. This is the reason for the failure in Data Extraction.
You need to Reactivate the Communication Arrangement. Follow the steps given below.
Navigate to Administrator work center and choose Communication Arrangements , select an Arrangement, and click Reactivate.
Navigate to Application and User Management work center and choose Communication Arrangements , select an Arrangement, and click Reactivate.
To know more about Pagination and communication arrangements refer to the below help center documents.
communication arrangement, extraction, fails, failure, data extraction, BW , integration, error message, SOAP , authorization, roles , user, data sources, C4C , BYD, ODP , Endpoint , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , How To