EHP4 upgrade

[#1]

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

[Former Member · Accepted solution]

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

SH

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Seet,

It worked using the SAPEHPI700 tool only..

thanks a lot..

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

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

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

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

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

Its 262144

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

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

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

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

please suggest

Regards,

Mridul

[markus_doehr2 · Accepted solution]

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

[Former Member · Accepted solution]

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

[markus_doehr2 · Accepted solution]

> 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

[Former Member · Accepted solution]

Hi,

SAPEHPI didn't asked me for no of batch processes while taking inputs.

there are around 1.85 million objects in TADIR table in our system...if I go with current configuration how much time it wud take to run this phase, I would also like to know how much memory is needed for upgrade...

Regards,

Mridul

[markus_doehr2 · Accepted solution]

> SAPEHPI didn't asked me for no of batch processes while taking inputs.

Then you apparently used the default configuration, which is, for most systems, too low configured.

> there are around 1.85 million objects in TADIR table in our system...if I go with current configuration how much time it wud take to run this phase, I would also like to know how much memory is needed for upgrade...

Nobody can tell how long it will take.

Out of my experience I wouldn't do an upgrade beyond 16 GB where at least 8 GB are configured for the database. Technically it'll work with lower memory but you need to be patient.

On our system from the initial start of SAPehpi till the downtime it took us two days (> 48 hours).

Markus