Instance shuts down - paging file too small

Our hosting-partner had some trouble with some SCSI-drivers who lead to disconnection from some of the harddrives.
Our db-disk and sap-disk was harmed.

When the problem was fixed we got problems starting one of our two SAP-instances.

At first both instances went green with the text:
"Running, Message Server connection ok"
But this status changed after some minutes:
"Running but not connected to Message Server"
And then the status changed into:
"Stopped"

I did not find any answers in the log-files (\usr\sap\sid\DVEBM0000\work).
The answer was in the event-viewer.





















[CreateOsShm] CreateFileMapping(6,450000 KB) failed with Err=1455 ERROR_COMMITMENT_LIMIT: The paging file is too small for this operation to complete.

Solution was to set the paging file again.

Shortdump DBIF_REPO_SQL_ERROR

Text in shortdump ST22:
Short text: SQL error 1654 occurred when accessing program
How to correct the error: Database error text........: "ORA-01654: unable to extend index SAPR3.D010TAB~0 by 128 in tablespace PSAPES700I"

This is basic understanding of an oracle-database. Tablespace is full. In this case it's PSAPES700I. Extend with brtools:
http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm
If you are using the old sap-tool "sapdba" insted of BRTOOLS you can email me (harald.v@epost.no) and I'll help you with the tablespace-extention.

(Photo: http://www.made-in-china.com/)

Shortdump CALL_FUNCTION_NOT_FOUND

The short text in this shortdump is:
Function module "ANLBZW_CREATE_TRANSFER" not found.

The solution for this was in my case note 1276128.
You have to maintain view TRWPR and delete an entry containing function module ANLBZW_CREATE_TRANSFER.
Attached to note 1095424 you will find a script for this action.

CANNOT_CREATE_COFILE during SPAM queue

This is usually solved by:
1. Check authorization for cofiles-folder (sidadm and servicesidadm)
2. Download the affected support package again. It can be corrupted
3. Any full tablespaces?

If you look into SLOG and find this error message:
WARNING: \\\sapmnt\trans\tmp\SAPKKB70014.ARP is already in use (10), I'm waiting 4 sec (20090515192357). My name: pid 7280 on (APServiceARP)

In my case the problem was corrupt support package. I downloaded the package, deleted the cofile and the datafile. Remember to also delete the pending transport request that you will find int the trans\tmp-folder.

Maybe my father is a war-hero;)

I promised you to not only write about SAP, but try to combine that with family. Here is something about my life..... or my fathers life.
I have written an article about him (John Vedvik). I focus on one special incident in 1943 where my father went against the Germans. He was only 9 years old at the time. It's in Norwegian and on my norwegian blog-site: http://rusle.blogg.no/1242204244_min_egen_max_manus.html

Photo is taken by Kjetil Simonsen pixelphoto.no.

What is BI Business Process Management?

My good friend and colleague in CIBER, Pål Risberg, just wrote an interesting article with the subject: "What is BI Business Process Management?".
It's in Norwegian, but if you want it in english or have other questions you can just ask him at pal.risberg@ciber.com.

Change your life and become a SAP Consultant

I found this link at Daniel Toba's blogspot:

http://www.sapforall.net
This is a community for people wanting to pursue a career as SAP consultant.

Migration of SAP Content Server

Migration of SAP Content Server 6.40 from 32 bit to AMD64 for Norwegian Air Shuttle AS (http://www.norwegian.com/).
At first I installed MAXDB 7.6.04.16 as my target database.
Source database is 7.3.0.35.
I recommend to read note 649814 and 962019 first.
There you will see that you have to install MAXDB 7.6.05 build 11 or higher at your target-system.
Note 962019:
Note that the target system must be installed at least with 7.6.05 build 11. An upgrade to this version does not help.

Uninstall the old target-system:
1. Uninstall Content Server with Add/Remove Programs
2. Stop MAXDB-instance:
dbmcli -d -u , db_offline
3. Delete MAXDB-instance:
dbmcli -d -u , db_drop
4. Uninstall MAXDB with Add/Remove Programs

Install SAP Content Server 6.40 with MAXDB 7.7.* for x64
CDLABEL.ASC=MAXDB7.7.04 Build 28RDBMSNumber 51035704.
Remember to configure the IIS
Create Repository in CSADMIN

The Migration is a Heterogeneouse system copy.
Actions at source-system:
1. Check Data ->
Database Manager - Instance - Check - Database Structure
2. Create Index (ony for Kernel version 7.3 and 7.5) ->
Database Manager - Tools - SQL Studio
----more will follow------

THIS DOES NOT WORK!!!! I'll try again later.

My first blogging-day

Hello dear friends and enemies!

This is me and my oldest son. He was 1 year old at the time this picture was taken. He is now 2,5 years old. In desember 2008 my wife and me had twins. A boy and a girl. They are 5 months old now.
So you can imagine that it's a hectic time in our home

This is my first day as a blogger. Mainly I'll write about my profession as an SAP Basis Consultent at CIBER in Norway, but this is something that also affects my private life. So - I will write about both subjects;)

I also want to use this opertunity to improve my english. So you have to excuse me if you find some bad spelling or grammar.