Question Re: EHP4 upgrade in Technology Q&A

EHP4 upgrade

Former Member — Thu, 10 Jun 2010 10:00:21 GMT

HI Guys,

While performing EHP4 upgrade, I am getting below error(VALCHK.LOG) in PREP_INIT/VALCHK_INI phase of extraction.

1 ETQ201 Entering upgrade-phase "VALCHK_INI" ("20100610144701")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '12', GwService = 'sapgw12'

4 ETQ399 Environment variables:

4 ETQ399 dbs_ada_schema=SAPW6Q

4 ETQ399 auth_shadow_upgrade=0

4 ETQ399 Set environment for standard connect:

4 ETQ399 ENV: dbs_ada_schema=SAPW6Q

4 ETQ399 ENV: auth_shadow_upgrade=0

4 ETQ399 Set RFC variables for standard connect:

4 ETQ399 System-nr = '12', GwService = 'sapgw12'

4 ETQ399 Set tool parameters for standard connect:

4 ETQ399 default TPPARAM: DEFAULT.TPP

1 ETQ200 Executing actual phase 'PREP_INIT/VALCHK_INI'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'HARD-CHK'

2 ETQ399 Arg[1] = ''

4 ETQ359 RFC Login to: System="W6Q", Nr="12", GwHost="wss-cha-w6q", GwService="sapgw12"

4 ETQ232 RFC Login succeeded

2 ETQ399 Calling SUBST_HANDLE_UVERS with iv_mode 'R' iv_all ' ' and entries:

3 ETQ399 "SAP_ABA","700","","","","","","","","","","",""

3 ETQ399 "SAP_APPL","600","","","","","","","","","","",""

3 ETQ399 "SAP_BASIS","700","","","","","","","","","","",""

3 ETQ399 "SAP_BW","700","","","","","","","","","","",""

3 ETQ399 "SAP_HR","600","","","","","","","","","","",""

2 ETQ399 Returned UVERS (#5) evLen = 102:

3 ETQ399 "SAP_ABA","700","20100607","191115","20100607","191115","I","A","","700","","",""

3 ETQ399 "SAP_APPL","600","20100607","191115","20100607","191115","I","A","","600","","",""

3 ETQ399 "SAP_BASIS","700","20100607","191115","20100607","191115","I","A","","700","","",""

3 ETQ399 "SAP_BW","700","20100607","191115","20100607","191115","I","A","","700","","",""

3 ETQ399 "SAP_HR","600","20100607","191115","20100607","191115","I","A","","600","","",""

1AETQ228 Detected invalid (temporary) start release "SAP_ABA "

Is it the problem with the abap patch level, currently SAP_ABA patch level in the system is 14. Please suggest.

DB: MaxDB

OS :Win2k3 Server

Regards,

Mridul Gupta

Re: EHP4 upgrade

former_member126060 — Thu, 10 Jun 2010 19:27:28 GMT

Hello Mridul,

Download and use the latest version of EHpi.

This will resolve the problem

Re: EHP4 upgrade

Former Member — Thu, 10 Jun 2010 19:58:20 GMT

HI,

Concerning this error, please refer to Note 1251735 (the part about

Phase VALCHK_INI) and then start with a clean EHPI directory again from

the beginning. This should work.

- 1251735 - Add. Info. - SAP Enhancement Package Installer (7.10/5);

Hope this helps.

cheers

Re: EHP4 upgrade

Former Member — Fri, 11 Jun 2010 07:36:08 GMT

Hi,

I tried to use EHP 7.1 but it is not compatible, giving error, not compatible with release 7.00. I am using sapehpi7.00.

Any other suggestion.

Regards,

Mridul Gupta

Re: EHP4 upgrade

Former Member — Fri, 11 Jun 2010 12:12:36 GMT

Hi Seet,

It worked using the SAPEHPI700 tool only..

thanks a lot..

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 07:08:11 GMT

Hi,

I got stuck in PREP_IMPORT/RUN_GENPUTTBSHD phase, the RS_GENERATE_PUTTB_SHD is running since 48 hrs. Below is the log RSPTBINI.LOG

1 ETQ201 Entering upgrade-phase "RUN_GENPUTTBSHD" ("20100611203929")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '12', GwService = 'sapgw12'

4 ETQ399 Environment variables:

4 ETQ399 dbs_ada_schema=SAPW6Q

4 ETQ399 auth_shadow_upgrade=0

4 ETQ399 Set environment for standard connect:

4 ETQ399 ENV: dbs_ada_schema=SAPW6Q

4 ETQ399 ENV: auth_shadow_upgrade=0

4 ETQ399 Set RFC variables for standard connect:

4 ETQ399 System-nr = '12', GwService = 'sapgw12'

4 ETQ399 Set tool parameters for standard connect:

4 ETQ399 default TPPARAM: DEFAULT.TPP

1 ETQ200 Executing actual phase 'PREP_IMPORT/RUN_GENPUTTBSHD'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'RS_GENERATE_PUTTB_SHD'

2 ETQ399 Arg[1] = 'SAP_TMPLOG'

2 ETQ399 Arg[2] = 'NO-IGNORE'

2 ETQ399 Arg[3] = 'RS_GENERATE_PUTTB_SHD\.$(SAPSID)'

2 ETQ399 Arg[4] = '5'

2 ETQ399 Arg[5] = 'PUTTB_SHD generation'

2 ETQ399 Arg[6] = 'RSPTBINI.ELG'

4 ETQ010 Date & Time: 20100611203929

4 ETQ265 Starting report "RS_GENERATE_PUTTB_SHD" with variant "SAP_TMPLOG" in batch

4 ETQ359 RFC Login to: System="W6Q", Nr="12", GwHost="wss-cha-w6q", GwService="sapgw12"

4 ETQ232 RFC Login succeeded

4 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

4 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ239 Logging off from SAP system

4 ETQ311 Batch job "RS_GENERATE_PUTTB_SHD" with job count "20393200" scheduled

4 ETQ359 RFC Login to: System="W6Q", Nr="12", GwHost="wss-cha-w6q", GwService="sapgw12"

4 ETQ232 RFC Login succeeded

Please advise...

Regards,

Mridul

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 08:26:32 GMT

Hi,

I tried the solution mentioned in but when I am using command x_cons <SID> sh ac 1 it gives error

-24977,ERR_COMMAND: Unknown DBM command "x_cons"

Also when I tried to stop the installation it throws a message, Stopping EhP Installation is not possible.

Please suggest.

Regards,

Mridul

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 10:34:25 GMT

> I tried the solution mentioned in but when I am using command x_cons <SID> sh ac 1 it gives error

> -24977,ERR_COMMAND: Unknown DBM command "x_cons"

You run a MaxDB database? If yes, as which user are you trying to run that command?

You see activity on the disks and is CPU used?

Markus

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 10:59:30 GMT

Yes, I am using MaxDB version 7.7.06.010 and using superdba as user to execute x_cons <SID> sh ac 1

No, I don't see major activity on the disks and CPU used for the same.

Also I terminated the EHPI installation and started it again after deleting PUTTB_SHD as mentioned in , its again performing PREP_IMPORT/RUN_GENPUTTBSHD phase but its being an hour there are no entries in PUTTB_SHD table. Please suggest.

Regards,

Mridul

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 11:35:19 GMT

> Yes, I am using MaxDB version 7.7.06.010 and using superdba as user to execute x_cons <SID> sh ac 1

x_cons is an external command. Don't log on with something, just execute that in a shell/cmd.

Markus

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 12:01:38 GMT

x_cons <SID> sh ac 1 gave the status of db server as I saw from the command executed, the result is below

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

T95 8 0xB64 User 14940 IO Wait (R) 0 0 5 43160655

(s)

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

T95 8 0xB64 User 14940 IO Wait (R) 0 0 2 43160818

(s)

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

T95 8 0xB64 User 14940 IO Wait (R) 0 0 8 43161006

(s)

I also checked x_cons W6Q show active

SERVERDB: W6Q

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

T95 8 0xB64 User 14940 IO Wait (R) 0 0 11 43206427

(s)

Console command finished (2010-06-14 17:07:18).

But how it is helping me in my issue, its being 3 hrs table PUTTB_SHD is still empty...

Please suggest.

Regards,

Mridul

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 12:04:59 GMT

> ID UKT Win TASK APPL Current Timeout Region Wait

> tid type pid state priority cnt try item

> T95 8 0xB64 User 14940 IO Wait (R) 0 0 5 43160655

> (s)

> ID UKT Win TASK APPL Current Timeout Region Wait

> tid type pid state priority cnt try item

> T95 8 0xB64 User 14940 IO Wait (R) 0 0 2 43160818

> (s)

> But how it is helping me in my issue, its being 3 hrs table PUTTB_SHD is still empty...

> Please suggest.

This means, that the process with application PID 14940 is still doing something (reading data from the database).

How big is your CACHE_SIZE on that system?

Markus

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 12:48:02 GMT

Its 262144

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 12:53:06 GMT

> Its 262144

So that means your database has only 2 GB of memory. This is WAY too less for an ERP system. All data needs to be read again and again from the database and hence its taking a LONG time.

How much memory do you have in that machine?

Markus

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 12:56:28 GMT

6gb of memory with 20.5 gb of page file...

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 12:59:09 GMT

> 6gb of memory with 20.5 gb of page file..

Very small system. There's not much you can do about the speed then, you'll just have to be patient. This is not a database problem but a problem of the sizing of the system.

Markus

Re: EHP4 upgrade

Former Member — Mon, 14 Jun 2010 13:02:03 GMT

yeah its a test box..but 48 hrs is too much......any parameter which can speed-up the process..

please suggest

Regards,

Mridul

Re: EHP4 upgrade

markus_doehr2 — Mon, 14 Jun 2010 23:24:30 GMT

How many R3trans and batch processes do you have configured?

You can try to increase the cache size of the database but this will sooner or later make your system swap. You could also run the upgrade itself on a separate dialog instance.

All in all your hardware is not suited for such a big upgrade.

Markus

Re: EHP4 upgrade

Former Member — Tue, 15 Jun 2010 11:09:25 GMT

There are 3 batch process in the system and there is no R3trans process active as of now in my system...I restarted the upgrade and it is in Extraction phase(PREP_IMPORT/RUN_GENPUTTBSHD) and in SAPMMC I can c again a batch process is running in Sequential read as action and table TADIR, where it hanged earlier...

Please suggest.

Regards,

Mridul

Re: EHP4 upgrade

markus_doehr2 — Tue, 15 Jun 2010 11:17:12 GMT

> There are 3 batch process in the system and there is no R3trans process active as of now in my system...

and how many of them have you configured during PREPARE?

> I restarted the upgrade and it is in Extraction phase(PREP_IMPORT/RUN_GENPUTTBSHD) and in SAPMMC I can c again a batch

> process is running in Sequential read as action and table TADIR, where it hanged earlier.

it's not hanging, it's reading data.

If the table TADIR is bigger than your cache size the database will need to read the data over and over again - which takes time. Again, there's nothing you can do but increase the memory size for the database or just be patient. The sizing of the system is not appropriate so there's not a single button you can push to make it faster.

TADIR has all repository objects (tables, data elements etc.), in our system those are > 3,4 million. All those have to be read to be compared with all new objects. If those 3,4 million don't fit in your database cache, they are displaces before they are used, so the database has to read them again...

Markus

Edited by: Markus Doehr on Jun 15, 2010 1:17 PM