Case :

Datasource not active on BW system after a support package on ECC system.

Error message below 

Error when creating transfer structure /BIC/CCWGDTS_PROD_ATTR in source system WGPCLNT400

Message no. R3104

Diagnosis

An error occurred when creating transfer structure /BIC/CCWGDTS_PROD_ATTR as an IDoc segment in source system WGPCLNT400 .

Procedure

Use the generation log in source system WGPCLNT400 to identify the error, and remove the cause.

And not possible to reactive it even if with the program RSDS_DATASOURCE_ACTIVATE_ALL 

Note OSS :

2214733 - SAPI:Inconsistent IDoc segments/transfer structures in source system

Reason and Prerequisites
The IDOC administration or transfer structure administration is inconsistent.
Solution
Implement the attached correction.
Use the report 'RS_SCRSYSTEM_R3_CHECK' in Source system to eliminate the inconsistencies.

2524663 - Error when creating transfer structure /BI*/CCxxxxxxx in source system '&

Symptom
Errors when importing a transport request: Error when creating transfer structure /BI*/CCxxxxxxx in source system '& Error when activating Datasource '& Error when resetting Datasource '& <source_system> to the active version

Environment
Business Warehouse

Reproducing the Issue
Import a transport request

Cause
The source system contains inconsistent IDoc segments, transfer structures, or ABAP Dictionary structures

Resolution
Implement note 2617887(if necessary) and run RS_SCRSYSTEM_R3_CHECK report as per note 2214733. Follow the recommendation given for error R3104 in the note, due to inconsistent IDOC Segments or transfer structure.

By using the program RS_SCRSYSTEM_R3_CHECK (if not create => Implement note 2617887) on ECC system and not BW system.

Result :

+ RE-run the program with option unflagged (NO_DB_UP)

+ replicate the datasource on BW + run again the program RSDS_DATASOURCE_ACTIVATE_ALL

And the extraction should be working well after.