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.

Browser not supported