Solution : https://service.sap.com/sap/support/notes/1179880 (SAP Service marketplace login required)
Summary : 
      Due to an issue in NetWeaver 2004s, transformations are inadvertently deleted from BI Content during the replication of DataSources and connection of new source systems, leading to activation failures. SAP Note 1171293 provides a fix. For BI_CONT 7.04 and 7.03, Support Package 3 and 14 respectively must be imported. In upgrades, only delta changes are applied which may omit some transformations, however, these are fully delivered in the specified Support Packages.
Key words : 
solution implement note 1171293, import support package 3, import support package 14, support package, bi content, content found, rsor reason, prerequisites due, netweaver 2004s, source systems
Related Notes : 
       
| 1341984 | Error "Field length too long for PSA fields", BI_CONT 7.04 | 
| 1341931 | Load scenario in InfoCube 0IC_C03 contains syntax error | 
| 1339523 | Various delivery errors in BI_CONT 7.03 and 7.04 | 
| 1311698 | Installing or creating TRFN with master data LookUp | 
| 1229136 | 70SP20: Incorrect shadow DTP during release upgrade | 
| 1171293 | BI7.0(SP19)/BI7.1SPS07: Content disappears | 
| 653814 | BI Content add-on dependencies for NetWeaver/SAP_BW | 
| 13719 | Preliminary transports to customers (note for customers) |