Tuesday, February 21, 2012

Upgrade Issues BW 7.3 SP5

Quickly I would like to share some technical lessons learned from the upgrade at a customer that i work for:

- SID generation now checks if characteristic value is valid for conversion routine of infoobject.This could potentially show problems in your datamodel. Please perform a regular delta load in a test system to avoid surprises after upgrade.
- Masterdata activation has changed in 7.3, we encountered a few issues with deadlocks during activation/SID generation. (1637633 note)
- Data activation in DSO's is/was a bit instable after upgrade. Also, no real improvement on data activation can be measured so far.
- Many problems with JAVA Web frontend, please test thoroughly. Many notes are already available since SP5. (also IP issues)
- Start/End routines of transformations are changed, now fields should be selected induvidually. Note 1635588 imported to fix issue with conversion 7.0 > 7.3 transformation with start/endroutines.
- Semantic key of DTP towards Infoobject should now be selected, otherwise no parallel loading can take place.
- Upgrading JAVA stack was really troublesome for SAP Basis team.
- Vague error messages when loading towards a cube with SID generation..check notes 1639786, 1657854 and 1664648.

Some nice new features:
- Skip button in process chains
- Drag and drop DTP's and Infopackages to proces chains
- Proces chain hierarchy when using local chains
- Extra checks when releasing transports
- Documentation of objects improved
- Version management of BW objects
- Hierarchy view in proces chains