Note 391694 usually helps with this. In any case currently main recommendation is to minimize the selection criteria as minimum as possible, or you can consider if parallel processing can be active for this backgroud job for fast processing. Archiving program SDVTTKWRS cannot handle a high huge set of data of shipment documents to be archived. Understand that when system reads a shipment doc., it is not just this document but also the deliveries involved or assigned to it. Once it is done, the reading of shipment net also checks if such deliveries are present in other shipment document.. in order to check if might or not be archived..To sump up, different tables and different documents involved in flow.
You must use more filtration parameters and cut down on the number of shipments to be archived.. if not, long response time will occur.
Apart from this, from a DB perspective, you can of course make sure that all oracle parameters are set as recommended. Main note for this is 830576. Also, the note 1171650 will help you this since it contains an script that will cross-check your current parameter setting with the recommended one (from note 830576) and will suggest you any necessary change.
Also I would recommend to make sure statistics are calculated. Please refer to notes 838725, 132861 and 122718 on this regard.
thanks, but my system is alraedy migrated to unicode EHP4 implemented, not sure the note Note 391694 - Performance problem when archiving SD_VTTK woudl be relevant and the note for performance autoamted check also fine, didnt see any issue against this.
is there any relevant note against on release SAP APPL 604.
Mostly all of simmilar issues are accessing VTFA table. Can you check it with a SQL trace from ST05 transaction? If that is the case, note 816915 could be of help.
From DB point of view, if all parameters are set correctly, you can ensure also that latest SBP is installed (note 1137346 for 10.2.0.4)
Otherwise I would suggest to open an oss message in LE-TRA-TP-AR component.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.