Solution : https://service.sap.com/sap/support/notes/1455399 (SAP Service marketplace login required)
Summary :
A transport request adding a new field to an ODS/DSO may result in prolonged runtime in the target system due to the need for structure adjustment and data updates. The existing ODS tables must undergo conversion to accommodate the new field, filling added fields with default values, particularly impacting on large datasets. For cancellation, use STMS to manage and potentially roll back the transport. Performance challenges specific to Oracle and MSSQL databases are addressed with structured solutions including making a copy of the dataset for updates or adjusting log configurations to manage database logging demands efficiently.
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 |