cancel
Showing results for 
Search instead for 
Did you mean: 

After EHP5 upgrade

Former Member
0 Kudos

Dear All,

Dear All,

I upgraded our SAP ECC6 from EHP4 ready to EHP5 . current version of kernel is 720 sup.pkg lvl 90 DB client.Lib DB6_81

DBSL version 720 DBSL Patch level 089

We are facing following issues

1. System is constantly compiling old transanctions when entered although i've ran sgen selecting all components

2. Kernel giving error (in all dev_w* files)

A PXA

A PXA INITIALIZATION

A PXA: max_map_count = 1000000: ok

A System page size: 4kb, total admin_size: 67160kb, dir_size: 22020kb.

A Attached to PXA (address 7fe44989b000, size 900000K, 3 fragments of 277616K )

A PXA allocated (address 7fe44989b000, size 900000K)

*A *** WARNING: INTERNAL_KERNEL_VERSION of message server A unknown yet.*

A abap/pxa = shared protect gen_remote

A PXA: checking structure sizes: 752 264 8

A PXA INITIALIZATION FINISHED

A PXA

I also changed latest kernel but issue is same .

We are using DB2 9,7 and suse linux 11

Please Guide me

Regards

Shahid

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

after detailed check sgen job its give following information

25.11.2011 12:25:42 During this run of the generation 74672 objects were processed.

25.11.2011 12:25:42

25.11.2011 12:25:42 The generation set comprises 232769 objects.

25.11.2011 12:25:42 74048 objects were successfully generated.

25.11.2011 12:25:42* 624 objects show (syntax) errors.*

25.11.2011 12:25:42

25.11.2011 12:25:42* The generation of 158097 objects is still outstanding.*

25.11.2011 12:25:42

25.11.2011 12:25:42 Due to system failures 128 objects remain with status <in process>.

25.11.2011 12:25:42

25.11.2011 12:25:42 (Further information can be found in db table GENSETM.)

25.11.2011 12:25:42

25.11.2011 12:25:42 2) Runtime statistics

25.11.2011 12:25:42

25.11.2011 12:25:42 The generation required 4407 seconds

25.11.2011 12:25:42 (resp. 011327 (hhmmss)).

I don't know how to resolved that error

624 objects show (syntax) errors.*

Regards

former_member260607
Discoverer
0 Kudos

Hi shahid,

we have the same issue with our system after EHP5 installation. I  executed SGEN using option Generate for all Software Components and In job log for RSPARAGENER8M i see:

23.04.2012 00:39:57 During this run of the generation 68950 objects were processed.

23.04.2012 00:39:57

23.04.2012 00:39:57 The generation set comprises 230085 objects.

23.04.2012 00:39:57 68426 objects were successfully generated.

23.04.2012 00:39:57 524 objects show (syntax) errors.

23.04.2012 00:39:57

23.04.2012 00:39:57 The generation of 161135 objects is still outstanding.

23.04.2012 00:39:57

23.04.2012 00:39:57 (Further information can be found in db table GENSETM.)

Could you tell us how you solved it?

Regards,

Marco

JPReyes
Active Contributor
0 Kudos

That is a BUG import SAP Note 1630356 - SGEN terminates after 500 generation errors via SNOTE and that will solve the problem

Regards, Juan

former_member260607
Discoverer
0 Kudos

Thanks Juan,

correction of note 1630356 solved the problem.

BR
Alessandro

Former Member
0 Kudos

Sunny thankx for reply,

given sap notes related to basis version 700,710,711 etc but our current release is 720 .

regards

Shahid

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

You are right. I would suggest you to raise an OSS.

Thanks

Sunny

Former Member
0 Kudos

Thanx all for reply

After adjust instance parameters and then run SAPPFPAFR again no error

SGEN create job RSPARAGENER8M and its successfully finished, but when I run again SGEN status bar shows message "There are still 158743 objects from an earlier selection to be generated" then we goto regenerate the objects of the last run option and continue , then option appear resume and regeneration I selected resume and continue , then select server and continue after that its shows message in status bar " then amount generated contains no objects u201C

after all above activity transaction still compiling.

I am trying to regenerate all objects 2 or 3 times but issue is same

Regards

Shahid

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

I think SAP note 1147789 can solve your issue.

Thanks

Sunny

Former Member
0 Kudos

Thankx Arjun and Siva for helpful reply.

when I run sgen it generate all objects and job successfully completed ,but when I run again sgen its prompt me resume or continue option ( this option normaly appear when sgen not finished ) when I select resume option and ok it give us for example 15000 objects waiting for regenerate ( this is information popup ) then when I continue it give me information no objects in queue .

following out of SAPPFPAR

dbdev-se:devadm 51> sappfpar pf=/sapmnt/DEV/profile/DEV_DVEBMGS10_cidev check

================================================================================

== Checking profile: /sapmnt/DEV/profile/DEV_DVEBMGS10_cidev

================================================================================

***ERROR: /dev/shm is too small (7128 MB required, 5956 MB configured)

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_0 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_1 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_2 with 2047 MB

***INFO: Temporary create ES2 resource /SAP_ES2_sappfpar_3 with 987 MB

***ERROR: Size of shared memory pool 40 too small

================================================================

SOLUTIONS: (1) Locate shared memory segments outside of pool 40

with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 40

with parameter: ipc/shm_psize_40 =154000000

Shared memory disposition overview

================================================================

Shared memory pools

Key: 10 Pool

Size configured.....: 136000000 ( 129.7 MB)

Size min. estimated.: 132565864 ( 126.4 MB)

Advised Size........: 136000000 ( 129.7 MB)

Key: 40 Pool for database buffers

Size configured.....: 112000000 ( 106.8 MB)

Size min. estimated.: 151175040 ( 144.2 MB)

Advised Size........: 154000000 ( 146.9 MB)

Shared memories inside of pool 10

Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer

Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.

Key: 13 Size: 60500000 ( 57.7 MB) Alert Area

Key: 14 Size: 4400000 ( 4.2 MB) Presentation buffer

Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring

Key: 17 Size: 11142696 ( 10.6 MB) Roll administration

Shared memories inside of pool 40

Key: 42 Size: 10752992 ( 10.3 MB) DB TTAB buffer

Key: 43 Size: 64134392 ( 61.2 MB) DB FTAB buffer

Key: 44 Size: 11910392 ( 11.4 MB) DB IREC buffer

Key: 45 Size: 5766392 ( 5.5 MB) DB short nametab buffer

Key: 46 Size: 20480 ( 0.0 MB) DB sync table

Key: 47 Size: 5121024 ( 4.9 MB) DB CUA buffer

Key: 48 Size: 500000 ( 0.5 MB) Number range buffer

Key: 49 Size: 2968344 ( 2.8 MB) Spool admin (SpoolWP+DiaWP)

Shared memories outside of pools

Key: 1 Size: 2500 ( 0.0 MB) System administration

Key: 2 Size: 5953636 ( 5.7 MB) Disp. administration tables

Key: 3 Size: 66864000 ( 63.8 MB) Disp. communication areas

Key: 4 Size: 515848 ( 0.5 MB) statistic area

Key: 6 Size: 958464000 ( 914.1 MB) ABAP program buffer

Key: 7 Size: 14838 ( 0.0 MB) Update task administration

Key: 8 Size: 268435556 ( 256.0 MB) Paging buffer

Key: 9 Size: 268435556 ( 256.0 MB) Roll buffer

Key: 18 Size: 3670116 ( 3.5 MB) Paging adminitration

Key: 19 Size: 60000000 ( 57.2 MB) Table-buffer

Key: 30 Size: 24576 ( 0.0 MB) Taskhandler runtime admin.

Key: 31 Size: 9612000 ( 9.2 MB) Dispatcher request queue

Key: 33 Size: 20480000 ( 19.5 MB) Table buffer, part.buffering

Key: 34 Size: 33554432 ( 32.0 MB) Enqueue table

Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer

Key: 51 Size: 18000000 ( 17.2 MB) Extended memory admin.

Key: 52 Size: 180000 ( 0.2 MB) Message Server buffer

Key: 54 Size: 4202496 ( 4.0 MB) Export/Import buffer

Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist

Key: 57 Size: 1572864 ( 1.5 MB) Profilparameter in shared mem

Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes

Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory

Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.

Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory

Key: 76 Size: 1564448 ( 1.5 MB) Ext. Segment Administration

Key: 77 Size: 506912 ( 0.5 MB) Ext. Memory Administration

Key: 78 Size: 500384 ( 0.5 MB) Ext. Global Memory Admin

Key: 81 Size: 21760 ( 0.0 MB) Security Audit Log

Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0

Key: 58900110 Size: 4096 ( 0.0 MB) SCSA area

Nr of operating system shared memory segments: 33

Shared memory resource requirements estimated

================================================================

Total Nr of shared segments required.....: 33

System-imposed number of shared memories.: 1000

Shared memory segment size required min..: 958464000 ( 914.1 MB)

Currently available maximum segment size.: 46439333888 (44288.0 MB)

Swap space requirements estimated

================================================

Shared memory....................: 2034.0 MB

..in pool 10 126.4 MB, 97% used

..in pool 40 106.8 MB, 134% used !!

..not in pool: 1757.4 MB

Processes........................: 1264.2 MB

Extended Memory .................: 4361.0 MB

Extended Memory 2 ...............: 7128.0 MB

.. 25 VMs, 792.0 MB address space

-


Total, minimum requirement.......: 14787.2 MB

Process local heaps, worst case..: 5722.0 MB

Total, worst case requirement....: 20509.2 MB

Errors detected..................: 1

Warnings detected................: 0

dbdev-se:devadm 52>

Regards

Shahid

Former Member
0 Kudos

Hi Shahid,

1. Please try to resume SGEN again. If it does not allow you to resume, please run fresh SGEN by choosing option "Generate for all Software Components".

2. Please increase shared memory pool parameter ipc/shm_psize_40 to value 154000000 in profiles and restart your system. Please run SAPPFPAR command again and make sure no errors reported.

Good Luck.

Thanks,

Siva Kumar

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

This means that your SGEN is not finished successfully. As per your sappfpar report, you need to to change parameter for shared memory.

Thanks

Sunny

Former Member
0 Kudos

Hi Shahid,

Please try to change the parameters recommended by SAPPFPAR and restart the server.

example :- /dev/shm is too small (7128 MB required, 5956 MB configured) - /dev/shm - 7128MB

Thanks,

Arjun

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Please run SGEN again using option Generate for all Software Components.

Thanks

Sunny

Former Member
0 Kudos

Hi Shahid,

1. System is constantly compiling old transanctions when entered although i've ran sgen selecting all components.

- Are you sure previous SGEN run was successful? I would suggest you check logs and run SGEN on all components again, if needed.

2. Kernel giving error (in all dev_w* files)

- I don't consider this warning as serious error. As Arjun suggested, please run SAPPFPAR PF=</sapmnt/SID/profile/inst.profile> CHECK and fix the errors accordingly.

Thanks,

Siva Kumar

Former Member
0 Kudos

Hi,

Can you please check SAPPFPAR and paste the log.

Thanks,

Arjun