Skip to Content

We have recently worked together with SAP Support in a ticket about SAP Strategy Management 7.5.

The customer implemented the tool more than one year ago, and now, a SSM issue “stopped” the production environment and gave us a big headache during few days.

First, let´s talk about customer SSM Architecture and releases.

  • SAP Strategy Management 7.5
  • Service Pack 10
  • DataBase Version 75.10.0
  • NetWeaver 7.2 (Oracle Database)
  • Source data: E&A Interface (don´t have load process implemented into Application Server – all data come from manually input).

The SSM users was working with the tool normaly and suddenly the data that were displayed on the End Users Screens, stopped to be displayed.

Problema SSM.jpg

/wp-content/uploads/2013/01/score_176955.png

1) First test done was check the Model Connetions and be sure that was all working fine. The follow connections were tested:

  • CBDEFAULT
  • CBXXXXXX_MM
  • CBXXXXXX_SC

Acess DemoLauncher -> SAP SSM Administrator -> Manage Models

Sem título2.png

*** Connection made, logged on, database found *** ๐Ÿ™‚

2) Moved to Application Server layer, and checked the Link ID connection (between Application Server and Oracle NetWeaver database):

Application Server Client -> Link ID´s -> SSM_CB_EA

/wp-content/uploads/2013/01/pas_176951.png

Into Application Server, execute the follow command:

SUP USE MODEL EXCLUSIVE -> Click on DataView tab (be sure that exist data into the Dimensional Model):

/wp-content/uploads/2013/01/data_176960.png

No problems here. ๐Ÿ™‚

3) Access CubeBuilder Interface and try Build PAS Model again (just to be sure):

/wp-content/uploads/2013/01/cb_176953.png

Rebuilding PAS Model and analyzing the “cb_build_XXXXXX.trc” file (Cube Builder Log file), all the instructions compiled fine. ๐Ÿ˜Ž

4) Access Entry and Approval Interface and Load the manual input data again into the PAS Model.

/wp-content/uploads/2013/01/ea_176956.png

Analyzing the “wfmde_update_XXXXXXXX.trc” file (E&A log file), all instructions worked fine.

5) After doing these steps, we tried to fix the issue, applying the follow SAP Note (SAP Suggestion):

1645293Data entered in Metric Set is not shown in PAS and Scorecard

The SAP Note was applied, but nothing changed. ๐Ÿ˜

6) Check the Default Trace Parameter and analyse the log file:

Acess DemoLauncher -> SAP SSM Administrator -> Set system defaults

/wp-content/uploads/2013/01/pastrace_176961.png

Directory: C:\sap\CE1\J00\j2ee\cluster\server0\log

Ex.: File “defaultTrace_00.14.trc”

No error messages found into Default trace file.

7) Analyse the PAS trace file:

Directory: C:\Program Files (x86)\SAP BusinessObjects\Strategy Management\ApplicationServer\home

These should be files called:

  • <modelname><app_server_user><unique_stamp>_both.txt
  • <modelname><app_server_user><unique_stamp>_cmd.txt
  • <modelname><app_server_user><unique_stamp>_time.txt

For a cube in particular, we have 3 log files, with different endings.

Please, analyse the follow log files(“_both”, “_cmd”, “_time”).

Analyzing the log file “XXXXXXXXXXXGUEST1358342361963_both.txt”, we found an error, in the end of the compilation process:

“…Internal Programming Error, File .\glib\ggetmat.c, Line 1253

ENV010:

An internal programming error has occurred.  Please report this

condition to your Customer Service Representative.

CHE FRE…”

8) Searching for SAP Notes, we found the follow:

1594340 – Error: Internal Programming Error, File .\glib\ggetmat.c in PAS.

Following the resolution steps into the Note, one of the steps is Load a dump file.

When tried do this, the follow issue happened:

/wp-content/uploads/2013/01/dump_177246.png

“…Model is out of space…Either EXTEND it, or contact your Database Administrator for more information…”

9) Workaround to solve the issue:

Access the Application Server and run the follow commands in PAS:

  • SUP USE MODEL_NAME
  • EXTEND MODEL_NAME 30000
  • SUP SHO DATE MODEL_NAME

P.s: Ensure that there is sufficient number of free blocks.

Using the EXTEND command, you can increase the size of a database.

This was the root cause, the number of blocks free into the database were over and stop to show data into End User Application Screens.

Sem título.png

๐Ÿ™‚ ๐Ÿ˜† ๐Ÿ™‚ ๐Ÿ˜† ๐Ÿ˜‰

I hope this help you.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. zimkhita buwa

    Thank you for this! I am sure it will help a lot of people. I hope we can start getting more SSM users/consultants posting documents like these.

    This really illustrates the whole point of having SDN(promoting a culture of learning and sharing).

    Thanks ๐Ÿ™‚

    (0) 
  2. Luis Leal

    Thanks for sharing this! i’m not facing this issue, but i leared a lot from this material, especialy de names of the logs generated by every different tool. Thanks for sharing knowlege with everybody, i’m sure this will be valuable material por many people.

    (0) 

Leave a Reply