BUG FIX ARCHIVE
Download link
https://mats.datavard.com/downloader.php?ticketid=19dabe20b7c48a4dda3a929550c7901d
Description: OutBoard DataTiering SP23 FIX-005 Storage update write data fix
Password: Datavard1
Transports requests
Request | Date | Owner | Short Text |
|---|---|---|---|
| NSQK905612 | 16.05.2019 | DATAVARD | OutBoard DataTiering SP23 FIX-005 Storage update write fix |
Import the transport request to the affected system.
ISSUE DESCRIPTION
Performance problem during an Storage update, while moving data from Oracle to Redshift storage.
ERROR DESCRIPTION
The problem is caused by the Writer functionality, which was used when copying data. The Write was deleting and inserting a new package. A delete query cannot be performed in parallel in Redshift, so any parallel processes configured in BW have to wait because the DELETE step is executed sequentially.
SOLUTION
The Storage update uses a simple insert functionality instead of the Writer functionality, so the Writer only inserts a new package without deleting it.