Packs for SAP - issues opening stage editors or not displaying stage properties values

Content

This issue affects Pack for SAP R/3 6.5.0.2 (when running on IS 9.1 - 9.1.2), Pack for SAP Applications 7.0 (when running on IS 9.1 - 9.1.2) and Pack for SAP Applications 7.1 (when running on IS 9.1.2 and 11.3 - 11.3.1). It may also affect Pack for SAP BW 4.3.2.1a (when running on IS 9.1 - 9.1.2), Pack for SAP BW 4.3.2.2 (running on IS 11.3.1) and Pack for SAP BW 4.3.2.3 (which runs on both IS 9.1-9.1.2 and 11.3-11.3.1).
The issue does not affect Pack for SAP Applications 8.0 since it runs on IS 11.3.1.2 and later (where the issue does not exist).

BAPI stage in Pack version 6.5.0.2, 7.0, 7.1 (JR52514) or legacy IDOC stage in Pack version 6.5.0.2 (JR53320) may not open, may hang or loose parameters on reopening. Other stages may also be affected, but the patches mentioned here only fix the BAPI and legacy IDOC stage.

The fix is delivered as a Client tier patch for the DataStage Core component. After installing the patch, the Engine tier of Pack for SAP needs to be re-installed.
APAR JR53320 supersedes JR52514 for IS versions 9.1 - 9.1.2 and includes the additional fix for the legacy IDOC stage (the original JR52514 fix only addresses the BAPI stage).

Patch JR53320/JR52514 becomes a required prerequisite for the Pack versions mentioned.

Download documents:
Patch JR53320 for IS 9.1-9.1.2 : http://www.ibm.com/support/docview.wss?rs=14&uid=swg24040641
Patch JR52514 for IS 11.3-11.3.1 : http://www.ibm.com/support/docview.wss?rs=14&uid=swg24040640
Fixpack 2 for IS 11.3.1: http://www.ibm.com/support/docview.wss?uid=swg24040138

Notes:
- After patch JR53320/JR52514 (or a containing Fixpack) is installed on the Client tier, the Pack stage types need to be refreshed from repository. See the dedicated section below.
- The fixes are not included in the REST Rollup patches (v1 or v2) for IS 9.1. If applying these rollup patches, the patches JR53320/JR52514 needs to be installed afterwards.
- Fix JR52514 is included in Fixpack 2 for IS 11.3.1 (but not JR53320)
- If the Pack for SAP initial installation is done after the patch/Fixpack is installed, there's no need to refresh the stage types

Refreshing the stage types
Execute the following commands from either DS Administrator or uvsh command prompt to delete the local copy of the stage types on the Engine tier.

Commands to use to delete the stage local copy
The commands are shown for BAPI stage. For the legacy IDOC stage replace the selection mask 'BAPI%' with 'IDOC%' in all commands. The only required command is the DELETE command - the SELECT commands are used for confirmation only. Make sure the last SELECT shows 0 records listed to confirm deletion.

PTERM CASE NOINVERT
SELECT @ID FROM DS_STAGETYPES WHERE @ID LIKE 'BAPI%';
BAPI_PACK_for_R3_PX
BAPI_PACK_for_R3
2 records listed.

DELETE FROM DS_STAGETYPES WHERE @ID LIKE 'BAPI%';

SELECT @ID FROM DS_STAGETYPES WHERE @ID LIKE 'BAPI%';
0 records listed.

To use DS Administrator (recommended):
- open Administrator Client and click on Projects tab
- select the Project. Click on Command button
- enter the command in the corresponding field, then click Execute. Repeat for each command.

To use command prompt uvsh:
- close all DS Designer sessions
- open a command prompt window to the Engine tier machine, logged on as DS Administrative user
- on Unix source dsenv
- change directory to the Project folder (e.g. /opt/IBM/InformationServer/Server/Projects/dstage)
- run uvsh
- enter the commands

$cd <Project_Folder>
$uvsh
enter commands

After using either method, restart the DS Designer and connect to the server. This will create new local stage type copies with corrected properties.