ABAP Access Keys

Recently I tried to create a new object in the ABAP Object Navigator. It seemed simple, select Program, enter HELLO_WORLD_2 and press the Enter key. After doing so, I’m eventually faced with this screen:

If you have the Access keys, then enter the Developer Access key and the Object Access key and click Continue.

If you don’t, then you need go thru these 2 steps:

  1. Register the Developer
  2. Register the Object

Register the Developer

  1. Login to SAP Service Marketplace (http://service.sap.com/licensekey)
  2. Click SCCR Keys
  3. Click Register Developer and follow the prompts

Register the Object

  1. Same as above, except click Register Object for step 3

Once you have registered both the developer and object you can view either My Company’s Registrations, Developers Registered by Me or Objects Registered by Me by clicking the SSCR Keys menu link

Use the Developers and Object tabs to retrieve the Registration keys (Access key) and enter them in the User and SAP Object Key screen.

BPC 7.5 NW ApShell Data

Remembering where data is in the ApShell AppSet of NW 7.5 has been difficult for me. So instead of running RSA1 to find the data, I can look here:

  • Category: ACTUAL
  • Entity: C9000
  • P_Acct: CE0004010
  • P_Activity: NONE
  • P_DataSrc: Upload
  • RptCurrency: LC
  • Time: 2006, 2007, 2008

 

Installing BPC 7.5 NetWeaver Support Packages

Installing BPC NetWeaver Support Packages are a bit more involved than for the MS version. There are 2 parts to address: the ABAP SP and the BPC SP.

Before beginning, document the current install by making screen shots of the Server Manager screens into WordPad.

ABAP SP

For the ABAP SP retrieve the .SAR file from the SAP Marketplace

NOTE: ABAP BPC Support Packages are NOT cumulative, so download all the SPs between your current version and the latest.

  1. Software Downloads > Support Packages and Patches > A – Z Index > B
  2. SAP BPC FOR SAP NETWEAVER > SBOP PC 7.5 FOR SAP NW
  3. Comprised Software Component Versions > SAP CPM BPC ABAP 7.5 > Support Packages
  4. Check the box for the SP and click Add to Download Basket.
  5. At this point, the SP is in the Approval List tab of your Download Basket and needs to be approved for download by SAP.
  6. Submit a ticket to the XX-SER-SAPSMP-SDM component asking them to approve the download.
  7. Once it is approved you may download it.

NOTE with Solution Manager, you can retreive the SP directly thru NetWeaver.

Load the Support Package into NetWeaver

  1. On the NetWeaver server, logon to client 000 as Admin
  2. Run the SPAM transaction
  3. Go to the Support Packages menu
  4. Click Load Packages > From Front End
  5. Browse to the .SAR file location
  6. Click Open
  7. Click Decompress
  8. Repeat steps 1 thru 7 for all ABAP SP files.

Transport SP into the system

  1. On the main SPAM display ensure ‘New Support Packages’ is selected under ‘Directory’
  2. Click Display
  3. Click the SP in the list
  4. Right click on the package and choose Define Queue
  5. Click the green checkmark
  6. Click No to Adding Modification Adjustment Transports to the queue
  7. The window should close and in the main SPAM window, the Queue should display your SP
  8. Click the red truck button to transport the update
  9. Click the green checkmark to start the transport of the update into the system
  10. Once the transport finishes, ‘Confirm the Queue’ by clicking the green checkmark with a pencil.
  11. Repeat steps 1 thru 10 for all ABAP SP files.


BPC .NET SP

For the BPC SP retrieve the .exe file from the SAP Marketplace

NOTE: BPC .NET Support Packages are cumulative, so only download the latest.

  1. Software Downloads > Support Packages and Patches > A – Z Index > B
  2. SAP BPC FOR SAP NETWEAVER > SBOP PC 7.5 FOR SAP NW
  3. Comprised Software Component Versions > SAP CPM BPC 7.5 for NW > Win32
  4. Check the box for the SP and click Add to Download Basket.
  5. At this point, the SP is in the Download Basket tab of your Download Basket, download it locally by right clicking the file and selecting Save Target As…


Install the SP

    1. Reboot the server
    2. Uninstall the existing .NET Server application.
    3. Reboot the server
    4. Start the install program
    5. Locate XceedZip.dll and AntiXSSlibrary.dll. NOTE: SP06 requires version 3.1 of AntiXSS which requires .NET 3.5
    6. Specify user name and company
    7. Enter ADBPCSysAdmin
    8. Select authentication method, we use CMS
    9. Enter these values by referring to the WordPad document created at the beginning.
  1. Site Port
  2. Message Queue
  3. Message Server
  4. System ID
  5. Client
  6. Language
  7. System Number
  • There are 3 ABAP service users: bpcsysadmin, bpc_admin and bpc_user. Enter their credentials.
  • Click Install
  • When the install completes, click Finish

Processing Application: Cannot find the object ApShellExtra.dbo.Audit…

While testing a new installation of BPC, I encounter an error processing an Application:

Cannot find the object “ApShellExtra.dbo.AuditActivityHdrApShell” because it does not exist or you do not have permissions.

Sure enough SQL Server Management Studio shows the table is not there. On a whim I restart the Admin client and try processing the Application again; it works!?

Turns out, after the install I always modify security to allow the BPCSysAdmin account to have full control over ApShell. Apparently those security changes weren’t completely applied until I restarted.

BPC 7.0 Management Console ‘User does not exist’

After installing BPC 7.0 MS the Management Console wouldn’t let me view logging. The ‘User does not exist’ error would appear. This was a Windows Server 2003 R2 dual server environment. Using Fiddler I was seeing a 500 error, with something like ‘cannot resolve server name vmw2317’. Hmmm… vmw seems like VMWare, but I was dealing with physical servers.

Looking at the web.config file, I discovered several appSettings with vmw2317 and vmw2315; these were left over by SAP during development. Changed the names to our real server names, saved the file and everything works!

BPC 7.5 MS Prerequisites

Though the install guide for BPC provides the prereqs, I find I have to bounce around in the doc to find them. Here they are as of 8/3/2011:

Pre-Requisites:

App Server: OS (pick one preferably x64):

  1. Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
  2. Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V
  3. Windows Server 2008 Data Center with or without Hyper-V
  4. Windows Server 2003 Standard or Enterprise Edition SP2
  5. Windows Server 2003 R2 Standard or Enterprise Edition SP2

Database Server: OS (pick one preferably x64):

  1. Windows Server 2008 R2 Standard or Enterprise Edition with or without Hyper-V
  2. Windows Server 2008 Standard or Enterprise Edition with or without Hyper-V
  3. Windows Server 2008 Data Center with or without Hyper-V
  4. Windows Server 2003 Standard or Enterprise Edition SP2
  5. Windows Server 2003 R2 Standard or Enterprise Edition SP2

Service Accounts:

  1. SQL Server
  2. BPC SysAdmin
  3. BPC Admin
  4. BPC User

NOTE: These are domain accounts.

Have available, but do not install:

Database (pick one):

  1. SQL Server 2008: SP2 with Cumulative Update 1 for SP2.
  2. SQL Server 2008 R2: Cumulative Update 5.
  3. SQL Server 2005: If you wish to use 2005 ask me for SP and CU

BPC:

  1. BPC 7.5 MS setup

Misc:

  1. SQL Server 2005 Backward Compatibility Components

From SAP Marketplace website (SAP Cryptographic Software) :

  1. AmyuniPDF.exe
  2. XceedZip.dll


Re-installing BPC 7.5 MS

Some notes from re-installing BPC 7.5 MS.

  1. Backup AppSets
  2. Thru Server Manager, document existing settings
  3. Reboot the application server
  4. Rename the AppServer, ApShell and ApShellExtra databases
  5. Rename the AppServer, ApShell and ApShellExtra Data folders
  6. Uninstall BPC either thru Add and Remove Programs (Win Server 2003) or the new Win Server 2008 method
  7. Remove the BPC application folder (Not the data folder)
  8. Remove any remaining BPC COM+ objects
  9. Remove any remaining BPC, OutlookSoft and SAP registry entries

SAP Central Management Console and Windows AD Authentication

When changing Domain Controllers for a UMS/CMS server you need to modify the krb5.ini file. In our case that file was located in C:WinNT. Simply adding another kdc line, saving the file and restarting TomCat updates the system.

AD.ourdomain.COM = {
kdc = NewDCName.AD.ourdomain.COM
kdc = OldDCName.AD.
ourdomain.COM
default_domain = AD.
ourdomain.COM
}

Prior to this update, I was receiving this error:

Account Information Not Recognized: Active Directory Authentication
failed to log you on. Please contact your system administrator to make
sure you are a member of a valid mapped group and try again. If you are
not a member of the default domain, enter your user name as
[email protected]_DomainName, and then try again. (FWM 00006)

FWM 01003 null When Logging Into Central Management Console

When logging into the SAP Central Management Console used for managing security in UMS, I received the following error:

Server not found or server may be down (FWM 01003) null

Thanks to this post, it turns out that the CMS.exe process was not running. I could tell by looking in Task Manager. To start the process:

  1. Run Central Configuration Manager
  2. (Re)start Server Intelligence Agent