(SP23) FIX-005 Storage update write data fix

Owned by SNP
Last updated: May 29, 2019 by Martina Pospisilova (Unlicensed)

BUG FIX ARCHIVE

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
NSQK90561216.05.2019DATAVARDOutBoard 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.