SAP Knowledge Base Article - Public

2941162 - Extraction of Data in BW from C4C or BYD System Fails with Error Message

Symptom

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"

Environment

SAP Cloud For Customer

SAP Business By Design

Cause

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.

Resolution

You need to Reactivate the Communication Arrangement. Follow the steps given below.

In C4C

Navigate to Administrator work center and choose Communication Arrangements , select an Arrangement, and click Reactivate.

In ByD

Navigate to Application and User Management work center and choose Communication Arrangements , select an Arrangement, and click Reactivate.

See Also

To know more about Pagination and communication arrangements refer to the below help center documents.

https://help.sap.com/viewer/637db7a0d01e47009d9420e9a927c571/1708/en-US/982376a43cdc409aa2f38b8a5fc492e9.html

https://help.sap.com/viewer/2754875d2d2a403f95e58a41a9c7d6de/2005/en-US/c30ccd16669c43a69482b490fdecaad0.html?q=reactivate%20communication%20arrangement

Keywords

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

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions