Start Content Repository for Content Server

You have to start the Content Repository if the repository status is "defined" in transaction CSADMIN.

To start it you have to push butten for start. On the start butten you have an image of a padlock that is unlocked. I find it funny:)

Here is what you have to do to start Content Repository:

1. Transaction CSADMIN

2. Choose Content Repository and press "enter"

3. In the Content Server Admin-window you have to select "Details" and then "Display <-> Change"

4. Then push the butten with image of the padlock that is in status unlocked:

Shordump DBIF_RSQL_INVALID_REQUEST

Here is some info from the shordump:

Short text
Invalid request.
What happened?
The current ABAP/4 program terminated due to an internal error in the database interface.
What can you do?
Note which actions and input led to the error.
For further help in handling the problem, contact your SAP administrator
You can use the ABAP dump analysis transaction ST22 to view and manage termination messages, in particular for long term reference.
Error analysis
An invalid request was made to the SAP database interface in a statement in which the table "EDID4 " was accessed.

Keywords
"DBIF_RSQL_INVALID_REQUEST"
"SAPLEDI1" or "LEDI1F09"
"F09_IDOC_INSERT_WITH_NUMBER"

The Keywords did confuse me a bit. This shortdump recommend to check transaction SM21. Thats a very importen clue. Remember to check more than just the red lights in SM21.
Under a warning in SM21 I found this information:
ORA-01653: unable to extend table SAPR3.EDI40 by 46075 in tablespace PSAPCLUD
So the answer is to extend tablespace PSAPCLUD.






I had over 400MB of free space in the mentioned tablespace. It was 95% full.
I did not think it was a problem related to tablespace. Anyway.... a shortdump with the header "DBIF_RSQL_INVALID_REQUEST" can be a tablespace-problem even if the keywords indicate something else.
Please send me a message if you need help to extend tablespace (harald.v@epost.no).

Picture is from: http://img.pte.at/lowrespics/1096894834i23327.jpg
I love sap-commercial ;)

Shordump START_CALL_SICK - CPU timers not synchronized

After patching our Kernel for ECC 6.0 til patch 221 we receive shortdumps when logging in:

START_CALL_SICK
Short text

Database inconsistency: Start Transaction SICK.

What happened?
The current program had to be terminated because of an error when installing the R/3 System. The error occurred when initializing the R/3 System.

Remember to read whole text in this shordump beacuse you often find the answer in there:

Error analysis
The error probably occurred when installing the R/3 system. Error text of the first reported error: "CPU timers not synchronized. Check note 1036194.".

Follow what is written in this note and you will solve this issue.

You have to enter the text that have an underline in this image.


PS: This message is posted by my friend John Bjerke.

CSADMIN - Content Repository prompt you for user and password

After installing Content Server successfully and created Content Repository I still get prompt for user and password when entering transaction CSADMIN - Choosing Content Rep.
This is because I have not activated the certificate.


Solution:
1. Go to transaction CSADMIN and choose your Content Repository
2. When you are prompt for user and password you have to enter the OS-user on host for the Content Server - hit OK.
3. Choose folder "Certificates" in Content Server Administration (CSADMIN).
4. Change into "change mode":






5. Select the line where the certificate is and choose "Activate":







The next time you enter CSADMIN you will not be prompted for user and password:)

Remember that the DB must be up and running. Try with DB manager if you still have problems.

Delete background jobs older than 30 days

As default SAP delete background jobs that is older than 10 days. You'll find the standard jobs in SM36 - Standard Jobs.
You will see that the job SAP_REORG_JOBS delete old jobs. This job uses program RSBTCDEL with variant SAP&001. You are not able to change this variant. Even if your user have SAP_ALL- and SAP_NEW-authorization.
You have to make a new variant if you want to delete jobs that is older than 30 days.

This is how you can solve this issue after scheduling the standard job:

1. Go to SE38 and enter program RSBTCDEL
2. Select "Variants" and choose "Change"
3. In the "Variant"-field you have to select "SAP&001"
4. Then choose "Variants" in the menu top left corner and then "Copy". Copy the variant into a new name that you desire:)











5. Make the value-change for the new variant. "Older than days" = 30. Save and close.
6. In the end you have to change the released job SAP_REORG_JOBS. You can do this in SM37. Remember to set the job from released to scheduled before changing.

I guess it's more than one way to solve this issue. Maybe someone knows how to change the original variant?

R3TRFORMZZMEDRUCK original object cannot be replaced

Import of transport request ended with error.

Log file will tell you that original object cannot be replaced.
SAP will also provide you with a procedure to solve this:
If you still want to import the object, repeat the import with Unconditional Mode 2.

"Unconditional modes" is that you can override the rules of the transport system.
Import your request with option "Overwrite originals" is one of the unconditional modes.

HW-certification for SAP - Windows

Here is a usefull link if you are going to bay new hardware for your sap-application:
http://www.saponwin.com/

VMware:

Up until recently, to run SAP on VMware ESX on a given server, the server vendor had to do an additional certification specifically for VMware ESX. These certifications were published as SAP Benchmarks on http://www.sap.com/benchmark. In January, SAP agreed to remove this additional certification. This change was announced in the Benchmark Council in February. From now on, any server is supported that is

a.) on the VMware Hardware Compatibility List (http://www.vmware.com/resources/guides.html) AND !
b.) on the SAP certified hardware list, maintained at http://www.saponwin.com/

This info is taken from:

http://communities.vmware.com/blogs/SAPsolutions/2008/04/30/sap-hardware-certification-for-vmware-esx

Installing SAProuter with SNC connection on Windows

Here is my guide to install SAProuter with SNC for connection to SAP.
Hopefully you'll find it helpful.

Secure Network Communications:

Figure is taken from service marketplace and the saprouter-guide.

1. Register SAProuter at service marketplace. Send an oss-message with component XX-SER-NET-NEW to SAP. You have to attach "Remote Connection Data Sheet" to this oss-message (note 28976).
2. Download SAPSECULIB and SAPCRYPTO from service marketplace.
You'll find SAPSECULIB under Download - SAP support Packages - Entry by application group - SAP Technology Components.
You'll find SAPCRYPTO here:
https://websmp203.sap-ag.de/~form/handler?_APP=00200682500000000917&_EVENT=I_AGREE&_SWFOLDER=
3. Download SAPROUTER from service marketplace.
You'll find it under Download - SAP support Packages - Entry by application group - SAP Technology Components.
In my case I had to download version 7.00 because I could not find 7.10 for 32-bit Windows.
4. Create directory "saprouter" at your saprouter-host. In this example I created \usr\sap\saprouter.
5. Uncar your saprouter-file and copy saprouter.exe and niping.exe into your saprouter-folder (\usr\sap\saprouter).
6. Check if you can find ntscmgr.exe in the windows\system32-folder. If it's not there - find it and copy.
7. Create saprouter as an service.
Example: ntscmgr install SAProuter -b E:\usr\sap\saprouter\saprouter.exe -p "service -r -R E:\usr\sap\saprouter\saprouttab -S 3299"
8. Set saprouter-service to "Automatic" and user "adm".
9. Create key "saprouter" under
HKEY_LOCAL_MACHINE → SYSTEM → CurrentControlSet → Services → Event Log → Application
Then this values:
EventMessageFile (REG_SZ): ....\saprouter\saprouter.exe
TypesSupported (REG_DWORD): 0x7
10. Check if you can find MSVCR71.DLL and MSVCP71.dll in your system32-folder.
11. Download MS Runtime DLL attached to note 684106 (r3dllinst.zip). Unzip and run R3DLLINS.EXE from \NTPATCH - restart if necessary.
12. Uncar SECULIB and copy files from nt-i386 (if 32-bit windows) into \usr\sap\saprouter folder.
Uncar SAPCRYPTOLIB and copy files from \ntintel into \usr\sap\saprouter. You also have to copy files directly from the uncared SAPCRYPTOLIB-folder (files as ticket) into \usr\sap\saprouter.
13. Create environment variables for user:
SECUDIR = E:\usr\sap\saprouter
PATH = E:\usr\sap\saprouter
SNC_LIB = E:\sap\saprouter\sapcrypto.dll
14. Go to service marketplace:
https://websmp201.sap-ag.de/SAPROUTER-SNCADD
Press Apply Now!
You'll receive some data. Save it and copy the Distinguished Name.
Press Continue.
15. Open dos-command at your saprouter-host and type:
sapgenpse get_pse -v -r certreq -p local.pse ""
Just press "Enter" twice if you have to enter PIN.
16. Files local.pse and certreq is now created in saprouter-folder.
Open file certreq in notepad and copy the content.
17. Go back to service marketplace (window from nr. 14) and paste the content from certreq there. Press Request Certificate.
You will then receive your certificate.
18. Copy your certificate into notepad at your saprouter-host. Save this notepad-file as srcert in your saprouter-folder.
19. Open dos-command and import the certificate:
sapgenpse import_own_cert -c srcert -p local.pse
20. Create credentials. Open dos-command and type:
sapgenpse seclogin -p local.pse
21. Verify the import of the certificate. Open dos-command and type:
sapgenpse get_my_name -v -n Issuer
Everything should be ok.
22. Create a file called saprouttab in your saprouter-folder and enter thise entries:
KT "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" 194.39.131.34 *
KP "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" *
P 194.39.131.34 3299
23. Go into registry at your saprouter-host.
HKEY_LOCAL_MACHINE - SYSTEM - ControlSet001 - Services - SAProuter
Modify string ImagePath.
It should look like this:
E:\usr\sap\saprouter\saprouter.exe service -r -R E:\usr\sap\saprouter\saprouttab -S 3299 -K "p:"
24. Start saprouter-service
25. Open port 3299, 3200 between SAP and your saprouter.
26. Create RFC in SM59. If you need some help with this let me know.

Upgrade and migrate ContentServer with MAXDB - v2

It seems that I have been worrying too much.


Created a snapshot of my ContentServer and successfully upgraded to maxdb 7.7.00.28.

I had no experience with CS or MAXDB, but with Database Manager it's pretty easy to handle:)