Solution : https://service.sap.com/sap/support/notes/1455399 (SAP Service marketplace login required)
Key words : 
stms  > overview   > imports highlight <system id>  > goto   > import monitor, oracle databasein bw objects, mssql databasethe system log, made require additional updates, prerequisites adding fields, long execution times, reporting queries defined, transaction log space, ods/dso object, cancel transport reason
Related Notes : 
       
| 1599602 | FAQ: BW system performance | 
| 1340922 | Follow-on to Note 1287382 | 
| 1287382 | Extending BW objects on Oracle with large tables | 
| 363018 | File management for SQL Server |