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

[Former Member]

not answered still..

[markus_doehr2]

> not answered still..

So what did you do? I gave two options.

Markus

[Former Member]

Hi Markus,

I am currently in phase MAIN_NEWBAS/XPRAS_UPG and got the error

XPRA ERRORS and RETURN CODE in SAPR-603DWINEAAPPL.W6Q

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EENR397CThe subobject value table "TCACS_APPLDEF" contains invalid key fields

2EENR893INumber range object "CRD_AS_ID" " "

2EEPU133 Errors occurred during post-handling "AFTER_IMP_NROB" for "NROB" "L"

Cause: During the upgrade, import post-processing &V#& was performed for object &V#& &V#&. Errors were reported.

What to do

You will find the error messages for post-processing &V#& directly

before this message. First read these error messages and the respective

long texts. You will find further information there on correcting the

errors.

If this information is not sufficient, look for error notes in the

SAPNet - R/3 Front End. Keywords you can use for the search are

the name of post-processing &V#& or

the message numbers of the preceding error messages. The message number

appears in the header of the long text display.

If you enter a problem message for the error, enter the following

information:

the name of post-processing &V#&

the message numbers of the preceding error messages

the components in which the error occurred

2EEPU136 The errors affect the following components:

Long text:

Cause

During the upgrade or import of a transport request, errors occurred

which affect particular components of the SAP System.

The following messages list the components in which the errors

occurred.

System Response

The upgrade or import of the transport request is interrupted.

What to do

Read the preceding error messages and their long texts for more

information on correcting the errors.

2EEPU137 "BC-SRV-NUM" ("Number Range Management")

Long text:

Cause

During the upgrade or import of a transport request, errors occurred in

the component

&V#& (&V#&).

System Response

The upgrade or import of the transport request is interrupted.

What to do

Read the preceding error messages and their long texts for more

information on correcting the errors.

1 ETP111 exit code : "8"

>>> PLEASE READ THE REPORT DOCUMENTATION OF THE REPORTS MENTIONED ABOVE <<<

XPRAs are application reports that run at the end of an upgrade.

Most XPRA reports have a report documentation that explains what

the report does and how errors can be corrected.

Call transaction se38 in the SAP system, enter the report name,

select 'Documentation' and click the 'Display' button.

>>> The problematic XPRAs are mentioned in messages of type PU132 above <<<

I checked note Note 983821 - Upgrading to SAP ECC 6.0 with SAP ECC AFS 6.0 but didn't find anything relevant.

Regards,

Mridul Gupta

[markus_doehr2]

I would open an OSS call.

During XPRA you always have the option of ignoring the error (as I posted before) but I would neverless open an OSS call so the support can look on the system and decide what XPRA need to be executed manually after having solved the problem.

Since your upgrade seems to have an additional AddOn this is certainly a case for the support.

Markus

[Former Member]

Thanks Markus, I would also like to know wether we can make changes in the shadow system during downtime as I read somewhere that we should not, actually I want to maintain OSS connection so that support guys can look into it.

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

XPRAs run in the main instance, basically they are the programs that "merge" the content of the shadow instance into the main instance - so there is no more "shadow instance" to be started or not.

So basically you should be able to logon to the main instance (after having opened the system etc.).

Markus

[Former Member]

Hi Markus,

I do agree with your concept but I can login into shadow but main seems to be down.

Regards,

Mridul Gupta

[Former Member]

Hello Mridul,

I have exactly your error. Would u kindly tell me how did you resolve?

Regards

[Former Member]

Hi Bruno,

I haven't heard from SAP consultation for XPRA till yet, will let you know once I get some soln.

Regards,

Mridul

[Former Member]

hello Mridul,

I have exactly the problem you described. would you tell me how did u resolve it?

Kind regards

[Former Member]

They are still investigating?

[Former Member]

yes

[peter_larsson2]

Hi,

I also get the exact same error message in our upgrade from ERP 6.0 to ERP 6.0 EnhP4 SPS07 with patch 37 for the EnhP installer with all available SP included in the upgrade.

I logon client 000 with DDIC and started transaction CRDSNROASID (Number Range Maintenance: CRD_AS_ID) and get the error message "The number range object CRD_AS_ID does not exist"

Regards

/Peter

Edited by: Peter Larsson on Sep 22, 2010 12:55 PM

[peter_larsson2]

I think i got the solution.

It's note 1484591 which must be installed before the upgrade. If it's not it must be installad manually and You must unlock the system, implement the note manually and lock the system. After that repeat the phase. It work for me at least.

/Peter

[Former Member]

Hi Peter,

Thanks for the soln you gave me, I confirmed from SAP also and they told the same thing. But when I am unlocking the system I am getting this error

SAPehpi> Starting subprocess tp.exe with id 90784 at 20100927115731

EXECUTING E:\usr\sap\W6Q\DVEBMGS14\exe\tp.exe pf=E:\usr\sap\put\EHPI\abap\bin\SHADOW.TPP unlocksys W6Q

Environment: JAVA_HOME=C:\j2sdk1.4.2_25-x64

Environment: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

Environment: Path=E:\sapdb\programs\bin;E:\sapdb\programs\pgm;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\j2sdk1.4.2_25-x64\bin;E:\usr\sap\W6Q\SYS\exe\uc\NTAMD64

Environment: auth_shadow_upgrade=1

Environment: dbs_ada_schema=SAPW6Q

This is E:\usr\sap\W6Q\DVEBMGS14\exe\tp.exe version 372.04.71 (release 701, unicode enabled)

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter MAX_SEMAPHORE_WAIT in parameter file (line 9).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter MAX_SEMAPHORE_WAIT in parameter file (line 9).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

TRACE-INFO: 1: [dev trc ,00000] Mon Sep 27 11:57:31 2010 7082 0.007082

TRACE-INFO: 2: [dev trc ,00000] DlLoadLib success: LoadLibrary("dbsdbslib.dll"), hdl 0, addr 00000001873D0000

TRACE-INFO: 3: 19 0.007101

TRACE-INFO: 4: [dev trc ,00000] using "E:\usr\sap\W6Q\DVEBMGS14\exe\dbsdbslib.dll" 8 0.007109

TRACE-INFO: 5: [dev trc ,00000] } DbSlSdbControl(rc=0) 521 0.007630

TRACE-INFO: 6: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000) 11 0.007641

TRACE-INFO: 7: [dev trc ,00000] } DbSlSdbControl(rc=0) 38 0.007679

TRACE-INFO: 8: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202EBE0) 11 0.007690

TRACE-INFO: 9: [dev trc ,00000] } DbSlSdbControl(rc=0) 7 0.007697

TRACE-INFO: 10: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=0000000140EAEE28) 39 0.007736

TRACE-INFO: 11: [dev trc ,00000] } DbSlSdbControl(rc=0) 7 0.007743

TRACE-INFO: 12: [dev trc ,00000] { DbSlSdbConnect(con_info_p=0000000000000000) 50 0.007793

TRACE-INFO: 13: [dev trc ,00000] DBSDBSLIB : version 700.08, patch 0.047 (Make PL 0.69) 52 0.007845

TRACE-INFO: 14: [dev trc ,00000] MAXDB shared library (dbsdbslib) patchlevels (last 10) 11 0.007856

TRACE-INFO: 15: [dev trc ,00000] (0.047) MVCC support for MaxDB (note 1332203) 9 0.007865

TRACE-INFO: 16: [dev trc ,00000] (0.037) NUMC conversion corrected (note 1288313) 10 0.007875

TRACE-INFO: 17: [dev trc ,00000] (0.024) Default value for max. input variables is 2000 (note 655018) 11 0.007886

TRACE-INFO: 18: [dev trc ,00000] (0.024) Profile parameter to define max. input variables (note 655018) 11 0.007897

TRACE-INFO: 19: [dev trc ,00000] (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841) 11 0.007908

TRACE-INFO: 20: [dev trc ,00000] (0.024) Input parameters for SQL statements increased (note 655018) 11 0.007919

TRACE-INFO: 21: [dev trc ,00000] (0.018) Create index serial for MaxDB 7.6 (note 1267841) 10 0.007929

TRACE-INFO: 22: [dev trc ,00000] (0.018) More trace in case of packed to string conversion error (note 1262799)

TRACE-INFO: 23: 14 0.007943

TRACE-INFO: 24: [dev trc ,00000] (0.016) R3trans export aborts with signal 6 (note 1262245) 10 0.007953

TRACE-INFO: 25: [dev trc ,00000] (0.009) IA64 alignment errors (note 1245982) 9 0.007962

TRACE-INFO: 26: [dev trc ,00000] 14 0.007976

TRACE-INFO: 27: [dev trc ,00000] -> init() 23 0.007999

TRACE-INFO: 28: [dev trc ,00000] -> sdb_malloc(size=24) : 00000000026DC7A0 (40 bytes allocated) 42 0.008041

TRACE-INFO: 29: [dev trc ,00000] -> sdb_malloc(size=14) : 00000000026DF8E0 (70 bytes allocated) 19 0.008060

TRACE-INFO: 30: [dev trc ,00000] STATEMENT_CACHE_SIZE = 1000 118 0.008178

TRACE-INFO: 31: [dev trc ,00000] -> sdb_malloc(size=152000) : 000000000278A010 (152086 bytes allocated) 70 0.008248

TRACE-INFO: 32: [dev trc ,00000] -> sdb_malloc(size=656000) : 0000000002A800B0 (808102 bytes allocated) 49 0.008297

TRACE-INFO: 33: [dev trc ,00000] -> sdb_malloc(size=288000) : 0000000002B210B0 (1096118 bytes allocated) 253 0.008550

TRACE-INFO: 34: [dev trc ,00000] -> sdb_malloc(size=16144) : 00000000027B0010 (1112278 bytes allocated) 90 0.008640

TRACE-INFO: 35: [dev trc ,00000] -> sdb_malloc(size=32048) : 0000000002B680B0 (1144342 bytes allocated) 237 0.008877

TRACE-INFO: 36: [dev trc ,00000] -> loadClientRuntime() 5127 0.014004

TRACE-INFO: 37: [dev trc ,00000] Loading SQLDBC client runtime ... 22 0.014026

TRACE-INFO: 38: [dev trc ,00000] SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175 1179 0.015205

TRACE-INFO: 39: [dev trc ,00000] SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938 11 0.015216

TRACE-INFO: 40: [dev trc ,00000] SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938 55 0.015271

TRACE-INFO: 41: [dev trc ,00000] SQLDBC supports new DECIMAL interface : 0 23 0.015294

TRACE-INFO: 42: [dev trc ,00000] SQLDBC supports VARIABLE INPUT data : 1 9 0.015303

TRACE-INFO: 43: [dev trc ,00000] SQLDBC supports keepAlive indicator : 0 9 0.015312

TRACE-INFO: 44: [dev trc ,00000] -> getNewConnection() 9 0.015321

TRACE-INFO: 45: [dev trc ,00000] -> sdb_malloc(size=1672) : 0000000002B704E0 (1146030 bytes allocated) 116 0.015437

TRACE-INFO: 46: [dev trc ,00000] -> sdb_malloc(size=608) : 00000000027B7FB0 (1146654 bytes allocated) 167 0.015604

TRACE-INFO: 47: [dev trc ,00000] <- getNewConnection(con_hdl=0) 78 0.015682

TRACE-INFO: 48: [dev trc ,00000] -> checkEnvironment(con_hdl=0) 13 0.015695

TRACE-INFO: 49: [dev trc ,00000] -> connect() 25 0.015720

TRACE-INFO: 50: [dev trc ,00000] INFO : SQLOPT (set by environment) = -u SAPW6QSHD,*** 25 0.015745

TRACE-INFO: 51: [dev trc ,00000] INFO : SQLOPT= -I 0 -t 0 -S SAPR3 -u SAPW6QSHD,*** 66 0.015811

TRACE-INFO: 52: [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 89 0.015900

TRACE-INFO: 53: [dev trc ,00000] Mon Sep 27 11:57:32 2010 1599256 1.615156

TRACE-INFO: 54: [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

TRACE-INFO: 55: 104 1.615260

TRACE-INFO: 56: [dev trc ,00000] -> SetSapdbCA(errcode=-4008) 12 1.615272

TRACE-INFO: 57: [dev trc ,00000] -> freeConnection(con_hdl=0) 30 1.615302

TRACE-INFO: 58: [dev trc ,00000] -> sdb_free(p=00000000027B7FB0, size=608 (1146030 bytes allocated)) 107 1.615409

TRACE-INFO: 59: [dev trc ,00000] -> sdb_free(p=0000000002B704E0, size=1672 (1144342 bytes allocated)) 64 1.615473

TRACE-INFO: 60: [dev trc ,00000] } DbSlSdbConnect(rc=99) 14 1.615487

TRACE-INFO: 61: [dblink ,00433] ***LOG BY2=>sql error -4008 performing CON [dblink#4 @ 433] 122 1.615609

TRACE-INFO: 62: [dblink ,00433] ***LOG BY0=>POS(1) Unknown user name/password combination [dblink#4 @ 433] 23 1.615632

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

connect failed

ERROR: Connect to W6Q failed (20100927115732, probably wrong environment).

Process with ID 48616 terminated with status 232

I added Environment variable auth_shadow_upgrade=1 and dbs_ada_schema=SAPW6Q but got the same error again.

Please suggest.

Regards,

Mridul Gupta

[peter_larsson2]

Hi Mridul,

The instruction in manual (Troubleshooting manual) is wrong. I used the following command (in command prompt) to unlock the system:

logon as <sapsid>adm

start command prompt

write "tp unlock <SAPSID> pf=<path to enhpi-direcory>\abap\bin\DEFAULT.TPP"

to lock change unlock to lock

Good luck

/Peter

[Former Member]

Hi Peter,

I tried this but...

E:\usr\sap\put\EHPI\abap\bin>tp unlock W6Q pf=E:\usr\sap\put\EHPI\abap\bin\DEFAU

LT.TPP

This is tp version 372.04.71 (release 701, unicode enabled)

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter MAX_SEMAPHORE_WAIT in parameter file (line 9).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

ERROR: : action is unknown

"UNLOCK" unknown command: use "help" for an overview of possible commands

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0207

tp finished with return code: 207

meaning:

action is unknown

Regards,

Mridul

[peter_larsson2]

Hi Mridul,

I wrote the wrong command. It should have been "tp unlocksys <SAPSID> pf:.....\abap\bin\DEFAULT.TPP" and change to locksys when the change has been done. Sorry for the confusion.

/Peter

[Former Member]

thanks Peter..

[Former Member]

Hi Guys,

I have successfully being able to perform EHP upgrade...thanks a ton to Markus and other guys who helped me...

Regards,

Mridul

[Former Member]

hello peter, Mridul,

during the same phase I did "accept non sever errors" for XPRAS and I passed the phase . Now the EHPI is finished and during LONGPOST I have no errors .

However transaction CRDSNROASID as Peter said before shows problem regarding the number range.

Someone of you did the same and knows how to correct it?

regards

Edited by: Kir Sam on Oct 2, 2010 8:50 PM

[Former Member]

hi Mridul Gupta ,

plz tell us the steps for EHP4 upgrade. And sap notes that will help us during upgrade.

regards

Imran

[Former Member]

hi Mridul Gupta ,

plz tell us the steps for EHP4 upgrade. And sap notes that will help us during upgrade.

regards

Imran

[Former Member]

Hi Imran,

You need to look into guide for details and in the guide itself you will find the relevant notes as per your environment. To begin with..Create a solution( SMSY entry) in your solution manager and thru MOPZ download the relevant files for the upgrade and follow the guide..also look How-To Install EHP4 A practical guide, Installation Guide SAP EHP Installation, EHP_MustKnow etc..

Regards,

Mridul

[Former Member]

thanks ,

can u plz sent me the link

[Former Member]

https://websmp202.sap-ag.de/instguides browse the SAP ERP ->SAP Enhancement Packages for SAP ERP 6.0,..

[Former Member]

use note Note 1484591 to correct error during XPRAS_UPG.

Se38 - LSNR2F30

Line 193

FORM CHECK_OBJECT

Delta001

Context Block

• GOTSTATE =

• DD02V_WA =

• DD09L_WA =

Delete Block

TABLES

DD03P_TAB = i_dd03p

Insert Block

• TABLES

• DD03P_TAB =

[Former Member]

Hi!

still in my learning process.

Now I got a very time consumming phase : PREP_IMPORT/TOOLIMPD ( about 13 hours)

Found this warning coming again and again every 5 minutes in SLOG file:

WARNING: System LT1. Warning.        20100721001044 :
WARNING:       Background job not running properly. Function: S  Jobcount: 10000501  Status: S.
      Please check the system. Use transactions SM21, SM37, SM50.
WARNING:       (This warning is harmless if no further warnings follow.)

What will I have to look for in the syslog? Any clue ? May I launch manually the jobs -?

How will I prevent that for happening during the real update ?

BI_WRITE_PROT_TO_APPLLOG has some trouble (just freed and late ) : failed in periodic reschedule

[Former Member]

I believe you need to suspend jobs before start of upgrade using BTCTRNS1.

Regards,

Mridul

[Former Member]

you are right. Thanks. I am a bit confused, it is in the manual!

Next trouble : FAILED in phase MAIN_NEWBAS/STARTSAP_NBAS

SAPehpi.ECO says :

FAIL: process strdbs.cmd Database not running

I understand that The system can't start after downtime phase, but :

I can reach the database via SQLServer tools.

I did not find the error message in dev_xx files

[Former Member]

If your Db is not running make it run manually and retry this phase.

Regards,

Mridul

[Former Member]

Well, from my point of view Db is running an reachable .

Looks like in SAP Instance it is not true.

found that my strdbs.cmd files changed from :

@rem --------------------------------------------
@rem Startup script for MS SQL Server database 7.0
@rem --------------------------------------------

@rem --------------------------------------------
@rem start MS SQL Server service
@rem --------------------------------------------
call net start mssqlserver

@rem --------------------------------------------
@rem start MS SQL Server agent
@rem --------------------------------------------
call net start sqlserveragent

to

@rem --------------------------------------------
@rem Startup script for MS SQL Server database   
@rem --------------------------------------------
@rem --------------------------------------------
@rem start MS SQL Server service
@rem --------------------------------------------
ntscmgr start MSSQLSERVER -m VSAP-DEV
@rem --------------------------------------------
@rem start MS SQL Server agent
@rem --------------------------------------------
ntscmgr start SQLSERVERAGENT -m VSAP-DEV

Where VSAP-DEV is the hostname

if I launch manually the script it starts by a failuer -> service already running.

rolled Back the scripts -> no change

tried to stop the service priori to running again the phase -> no change

[Former Member]

If I launch sapcontrol by the hand I get :

>sapcontrol.exe -prot PIPE -nr 00 -function StartWait 10000 10

26.07.2010 01:00:43
Start
OK

26.07.2010 01:00:53
StartWait
FAIL: process strdbs.cmd Database not running

Finally found it :

PATH error ! Sorry for annoyance

Edited by: Edouard DUCRAY on Jul 26, 2010 10:06 AM

[Former Member]

still in my upgrade test process :

In the MAIN_NEWBAS/PARCONV_UPG phase, I got a recurring message in dev_w0 :

N RSEC: The entry with identifier /RFC/WORKFLOW_LOCAL_000

N was encrypted by a system

N with different SID and cannot be decrypted here.

I guess I forgot to stop something in the Original system. But what?

Will it bring some more trouble ?

It finally end with a

FAIL: JsfOpenAdmin failed: object not found

loks like some trouble with JAVA but it is an ABAP stack only

Edited by: Edouard DUCRAY on Jul 28, 2010 3:35 PM

[Former Member]

Hi Markus,

I am getting error in MAIN_SHDRUN/AC_UPG phase.

SAPehpi broke during phase ACT_UPG in module MAIN_SHDRUN / Shadow System Operations: SPDD and Activation

Error Message: Unresolved requests in buffer W6Q

Check logfiles 'ACTUPG.ELG' and 'D:\usr\sap\put\EHPI\abap\log\SAPehpi.ECO'

SAPehpi.ECO log

1. Phase ACT_UPG:

SAPehpi> Starting subprocess tp.exe with id 19388 at 20100730111013

EXECUTING D:\usr\sap\put\EHPI\abap\exe\tp.exe pf=D:\usr\sap\put\EHPI\abap\bin\ACTUPG.TPP put W6Q

Environment: JAVA_HOME=C:\j2sdk1.4.2_25-x64

Environment: PATH=D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\j2sdk1.4.2_25-x64\bin;C:\usr\sap\W6Q\SYS\exe\uc\NTAMD64;D:\usr\sap\W6Q\SYS\exe\uc\NTAMD64;E:\usr\sap\W6Q\SYS\exe\uc\NTAMD64;D:\usr\sap\put\EHPI\abap\bin

Environment: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

Environment: auth_shadow_upgrade=1

Environment: dbs_ada_schema=SAPW6Q

This is D:\usr\sap\put\EHPI\abap\exe\tp.exe version 372.04.71 (release 701, unicode enabled)

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter MAX_SEMAPHORE_WAIT in parameter file (line 8).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter MAX_SEMAPHORE_WAIT in parameter file (line 8).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Looking for effective putsteps ... ... ready (looking for putsteps)

stopping on error 12 during DD ACTIVATION

tp returncode summary:

TOOLS: Highest return code of single steps was: 12

WARNS: Highest tp internal warning was: 0118

tp finished with return code: 12

meaning:

A tool used by tp aborted

ERROR: stopping on error 12 during DD ACTIVATION

Process with ID 43452 terminated with status 12

ACTUPG.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPA-40401INEAIPPE.W6Q

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1 ETP111 exit code : "12"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPA-40405INEAIPPE.W6Q

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1 ETP111 exit code : "12"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPA-40406INEAIPPE.W6Q

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

Please check the logfiles

SAPA-40401INEAIPPE.W6Q
SAPA-40405INEAIPPE.W6Q
SAPA-40406INEAIPPE.W6Q

Markus

[Former Member]

Hi Markus,

I checked the files and the log over there referred to SAPAB70015.W6Q. Initially I found that was due to dump, for which I have increased the parameter of shadow instance abap/heap_area_total = 6441402368 from 26214400. After correcting this I am getting the below error in SAPAB70015.W6Q.

1 ED0301X*************************************************************************

1 ED0306 "Object Activation"

1 ED0322 End phase "001" ***********************************************************

2WEDO515X"TABL" "JHA_KOMPAJ1": Update of activation flag failed

1 ED0320XStart phase "002" **********************************************************

1 ED0306 "Final log"

1 ED0301 *************************************************************************

1 EDO578XFollowing objects not activated/deleted or activated/deleted w. warning:

1EEDO536X"Technical Settings" "USMDZ1FCRS" could not be activated

1EEDO536 "Technical Settings" "USMDZ1FRS" could not be activated

1EEDO536 "Technical Settings" "USMDZ6001C" could not be activated

1EEDO536 "Technical Settings" "USMDZ60020C" could not be activated

1EEDO536 "Technical Settings" "USMDZ6201C" could not be activated

1EEDO536 "Technical Settings" "USMDZ6300C" could not be activated

1EEDO536 "Technical Settings" "USMDZ6E201C" could not be activated

1 ED0301X*************************************************************************

1 ED0306 "Final log"

1 ED0322 End phase "002" ***********************************************************

1 ED0320XStart phase "003" **********************************************************

1 ED0306 "Statistics on Activated and Deleted Objects"

1 ED0301 *************************************************************************

1 EDO601XNumber of objects to be activated............: "86"

1 EDO605 Objects not activated........................: "7"

1 EDO606 Activated objects with errors in dependencies: "0"

1 EDO604 Objects activated with warning...............: "0"

1 EDO603 Successfully activated objects...............: "79"

1 EDO602 Number of objects to be deleted..............: "150"

1 EDO608 Objects not successfully deleted.............: "0"

1 EDO607 Successfully deleted objects.................: "150"

1 EDO609 Tables/views with DROP/CREATE................: "0"

1 EDO610 No. of them marked for DROP/CREATE: "0"

1 EDO611 Not marked for DROP/CREATE: "0"

1 EDO620 Number of nametabs to be deleted.............: "0"

1 EDO622 Successfully deleted nametabs................: "0"

1 EDO621 Nametabs that were not successfully deleted..: "0"

1 ED0301X*************************************************************************

1 ED0306 "Statistics on Activated and Deleted Objects"

1 ED0322 End phase "003" ***********************************************************

1 ED0302X=========================================================================

1 ED0314 Mass Activation

1 ED0302 =========================================================================

1 ED0327 Process..................: "wss-cha-w6q_8"

1 ED0319 Return code..............: "8"

1 ED0313 Phase 001..................: < 1 sec. (Object Activation)

1 ED0314 Phase 002..................: < 1 sec. (Final log)

1 ED0314 Phase 003..................: < 1 sec. (Statistics on Activated and ...)

1 ED0309 Program runtime..........: "00:00:58"

1 ED0305 Date, time...............: "06.08.2010", "11:52:00"

1 ED0318 Program end==============================================================

1 ETP155 ACTIVATION OF DD-OBJECTS

1 ETP110 end date and time : "20100806115200"

1 ETP111 exit code : "8"

1 ETP199 ######################################

4 EPU202XEND OF SECTION BEING ANALYZED

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

> 1EEDO536X"Technical Settings" "USMDZ1FCRS" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ1FRS" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ6001C" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ60020C" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ6201C" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ6300C" could not be activated

> 1EEDO536 "Technical Settings" "USMDZ6E201C" could not be activated

http://service.sap.com/notes

Enter e. g. "USMDZ1FCRS" as search term. You'll find

Note 1341975 - Add. info. on upgrading to SAP ERP 6.0 including EHP5 ABAP

Markus

[Former Member]

Hi Markus,

thanks for your help, but I am having a doubt the corrections has to be implemented in Shadow instance or main instance. Please advice.

Regards,

Mridul

[markus_doehr2]

Since the error occurs in the shadow instance you have to apply the correction there.

Markus

[Former Member]

Hi Markus,

I tried but it gave me error" Internal error: Upgrade is running! Component information is not valid" I also checked in the main instance, the note and its supplementary note ( 1263115) are implemented already. Please suggest.

Regards,

Mridul

[markus_doehr2]

This is expected since you're in the middle of the upgrade, you have to apply the correction manually.

Markus

[Former Member]

Hi Markus,

I tried to manually implement it, the note asks to

Context Block

nttb, nttt, ntdt,

sf01, sf02, sfsw, sfbs, sfbf,

enhd)

Delete Block

order by obj_name pgmid object as4pos trkorr.

Insert Block

order by obj_name object pgmid as4pos trkorr.

when I checked the RADMASGTC program it clearly hints that the note is already applied.

Transportorder exists -> Read DD-objects

select * from e071 into table e071_tab

where trkorr in trkorr

and object in (doma, domd, dtel, dted, tabl,

tabd, view, vied, sqlt, sqld,

tabt, sqtt, viet, indx, enqu,

enqd, mcid, mcob, mcod, maco,

macd, shlp, shld, ttyp, ttyd,

xinx,

nttb, nttt, ntdt,

sf01, sf02, sfsw, sfbs, sfbf)

order by obj_name object pgmid as4pos trkorr.

endif.

Please advice.

Regards,

Mridul Gupta

[markus_doehr2]

If you post code or logfiles, please make use of the code tag (<< >> next to the underline button) to make your post readable.

> I tried to manually implement it, the note asks to

You have now two options:

- continue by ignoring that error (as described in the note)

- open an OSS call under BC-UPG

Markus

[Former Member]

Hi,

i was told to make the EHP4 upgrade on our system.

I plan to test the process on a sandbox ( fresh copy of our dev system)

Everything goes OK until I was asked for the XML Stack File.

Our Solman 7.0 EHP1 does not generate anything.

Another trouble is that I order EHP4 CDs from SAP because our internet connection is very slow and buggee. I don't plan to download the files via MOPZ.

Where can i find any tips or information about the way to get this XML stck file description.

Sincerely,

Edouard

[former_member126060]

Mridul,

You need to download the right xml file and then proceed ahead. The components getting downloaded is dependent on the product you choose for your system is maintenance optimizer.

- Niraj

[Former Member]

Hi Niraj,

I think you have given me a hint and I think I did a blunder mistake, I haven't defined the system for dual stack, so now I have SAP ECC Server, SAP NW- Application server, SAP NW -EP core, SAP NW-Enterprise portal under my defined system W6Q under Landscape components ( I have installed Enterprise portal with ERP 6.0, just for your reference ). Now after defining the system when I am trying to download using MOPZ using auto selection its giving me error:

Evaluate failed fro product instance SAP NW -Application server Java (SAP ERP 6.0)

Evaluate failed fro product instance SAP NW -EP core (SAP ERP 6.0)

Evaluate failed fro product instance SAP NW Enterprise Portal (SAP ERP 6.0)

Please suggest.

Regards,

Mridul Gupta

[Former Member]

Hi Markus,

I am again in the same situation when I shutdown the instance and it didn't come up, but this time I got the problem, I checked with "x_cons W6Q show tasks" command which shows "LOG FULL" situation. How can I get this error corrected, I mean what all commands are needed(DBMCLI) to handel this.

Please help.

Regards,

Mridul Gupta

[markus_doehr2]

> I am again in the same situation when I shutdown the instance and it didn't come up, but this time I got the problem, I checked with "x_cons W6Q show tasks" command which shows "LOG FULL" situation. How can I get this error corrected, I mean what all commands are needed(DBMCLI) to handel this.

You will need to

- take a full backup

- enable automatic log backup

You can use DBMGUI to configure and process that.

Markus

[Former Member]

Hi Markus,

I want to change default location of my backup in case of db as maxdb as I don't have space in the default directory D:\sapdb\data\wrk\W6Q , I know in case of oracle we can define the same in init<sid>.sap. Please guide.

Regards,

Mridul Gupta

[Former Member]

Hi,

I got it, I have changed the location and backup is going on.

Regards,

Mridul

[Former Member]

problem is not yet solved...

[markus_doehr2]

Mridil,

what do you expect us to do? If you're not convinced with what we said then you should open an OSS call and let the support have a look on the system.

Markus

[Former Member]

the question was marked answered somehow so I marked it unanswered to continue and put the comment "problem not solved", I am grateful to u Markus for ur help..

[Former Member]

Hi,

I have moved on from previous phase and while moving to configuration phase it asked me to update SPAM stating the current level is too low in and asked to PREP_CONFIGURATION/SPAM_CHK_INI phase. I tried to apply SPAM update level 39 and getting this error(import log 😞

Start import R3TRTTYPTT_INSTSWPROD ... |

1 entry for TADIR updated (R3TRTTYPTT_INSTSWPROD ).

[dbsdbsql ,00000] *** ERROR => prepare() of C_0178, rc=1, rcSQL=-942 (POS(13) Unknown table name:DD43L)

47638 45.913470

[dbdssdb. ,00000] *** ERROR => PREPARE on connection 0, rc=-942 (POS(13) Unknown table name:DD43L)

31 45.913501

[dev trc ,00000] sc_p=000000000026C980,no=178,idc_p=0000000000000000,con=0,act=0,slen=66,smax=256,#vars=1,stmt=000000000681A0

32 45.913533

[dev trc ,00000] DELETE FROM DD43L WHERE TYPENAME = ? AND AS4LOCAL IN ('L','N','T'); 16 45.913549

[dbsdbsql ,00000] *** ERROR => prepare() of C_0178, rc=1, rcSQL=-942 (POS(13) Unknown table name:DD43T)

557 45.914106

[dbdssdb. ,00000] *** ERROR => PREPARE on connection 0, rc=-942 (POS(13) Unknown table name:DD43T)

30 45.914136

[dev trc ,00000] sc_p=000000000026C980,no=178,idc_p=0000000000000000,con=0,act=0,slen=94,smax=256,#vars=1,stmt=000000000681A0

31 45.914167

[dev trc ,00000] DELETE FROM DD43T WHERE TYPENAME = ? AND AS4LOCAL IN ('L','N','T') AND DDLANGUAGE IN ('D','E');

24 45.914191

1 entry for DD40L inserted (TT_INSTSWPROD N).

1 entry for DD42S inserted (TT_INSTSWPROD *).

[dbdssdb. ,00000] *** ERROR => More than 30 Native SQL cursors opened 973 45.915164

[dbeh.c ,00000] *** ERROR => missing return code handler 7767 45.922931

caller does not handle code 256 from dbdsqln#1[387]

==> calling sap_dext to abort transaction

sap_dext called with msgnr 900:

---

db call info -

---

EXEC SQL: DELETE FROM DD40T WHERE TYPENAME = 'TT_INSTSWPROD' AND (AS4LOCAL = 'T') AND DDLANGUAGE IN ('D','E')

Dictionary import

End date and time : 20100617181519

Ended with return code: ===> 12 <===

| ######################################

After getting error and looking for some solution I have applied the latest:

tp

R3trans

dbsdbslib.dll

but the error remains the same..

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

> | [dbdssdb. ,00000] *** ERROR => PREPARE on connection 0, rc=-942 (POS(13) Unknown table name:DD43T) |

This looks like a really serious error.

Did you try to apply this in the shadow instance?

Markus

[Former Member]

I tried to apply SPAM update in main instance..

Regards,

Mridul

[Former Member]

Hi Markus,

Should I reset the upgrade and try to update the SPAM first, will this workaround wud b fine?

Regards,

Mridul

[markus_doehr2]

> Should I reset the upgrade and try to update the SPAM first, will this workaround wud b fine?

yes, I'd do so. there seems to be a real problem on your system.

Markus

[Former Member]

I reset upgrade and reset SPAM and tried to update SPAM once again but I got same error.

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

> I reset upgrade and reset SPAM and tried to update SPAM once again but I got same error.

Did you just reset the upgrade or did you restore your database? Resetting just the upgrade won't help since the EHP4 installation reset only deletes the shadow instance but leaves the original system there.

Markus

[Former Member]

Hi Markus,

I have installed the system again as it was fresh installation and updated SPAM to 7.00/39 level and then again started the EHP upgrade but I got stuck again (72 hrs) at the same stage 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..earlier it moved to PREP_CONFIGURATION/SPAM_CHK_INI from PREP_IMPORT/RUN_GENPUTTBSHD phase when I changed the CACHE_SIZE from 262144 to 327680.

Please suggest.

Regards,

Mridul

[markus_doehr2]

> I can c again a batch process is running in Sequential read as action and table TADIR, where it hanged earlier..earlier it moved to PREP_CONFIGURATION/SPAM_CHK_INI from PREP_IMPORT/RUN_GENPUTTBSHD phase when I changed the CACHE_SIZE from 262144 to 327680.

Please write full english, not text message-like, not "i can c" (read the rules).

I would open an OSS call and let the support have a look on the system (on component BC-DB-SDB or BC-UPG). I would still say that the system is too small for such a huge upgrade.

Markus

[Former Member]

Hi,

In the configuration phase it is asking for Stack file but when I am trying to download the same through MOPZ it doesn't get downloaded when clicked on Download Cross system stack file, a prompt browser appears and hen disappears. I have checked the pop-up blocker is off and IE version is 7.0. Please suggest how can I download it or can I move ahead without giving the stack file or should I disable the web-dynpro and then try to download the file.

Regards,

Mridul Gupta

[markus_doehr2]

> In the configuration phase it is asking for Stack file but when I am trying to download the same through MOPZ it doesn't get downloaded when clicked on Download Cross system stack file, a prompt browser appears and hen disappears.

So you generated an XML file with a Maintenance Optimizer task in the Solution Manager system? You can find that file in /usr/sap/trans/EPS in.

Markus

[Former Member]

Hi Markus,

Thanks again for help, well i got stuck again in configuration phase after completing PREP_INSTALL/RUN_RSDBSCPY_INIT and getting following errors

1) It asked me to increase MaxSQLLock to 800000 from 300000 which I have increased already.

2) It asked me to increase MaxUserTasks, I increased it from 50 to 150.

I am getting the same error even after increasing these values as per ERRORS.

Please suggest.

Regards,

Mridul Gupta

[markus_doehr2]

> I am getting the same error even after increasing these values as per ERRORS.

Did you shut down and restart the database after changing the values? Those parameters are not dynamically changable.

Markus

[Former Member]

Hi Markus,

I did that and it worked fine till some time, when the WP got hanged, I restarted the server and now J2EE dispatcher is starting again and again when I am trying to start the SAP, I even reverted parameters like MaxSQLLock to 300000 from 800000, MaxUserTasks from 150 to 50 and CACHE_SIZE from 393216 to 262144, but the situation is same, server0 node and dispatcher starting again and again. I am not even able to connect J2EE engine through configtool, its showsing status connecting to DB.

Please suggest how can I bring up the system.

Regards,

Mridul

[markus_doehr2]

Please check the logs of the J2EE engine (dev_bootstrap, dev_server0.out etc.)

Markus

[Former Member]

Hi,

While proceeding I got this error

The execution of PREPARE/INIT/PREPARE_JSPM_QUEUE ended in error.

The stack D:\usr\sap\trans\EPS\in\SMSDXML_W6Q_20100710073202.412.xml contains no components for this system.

More information can be found in the log file D:\usr\sap\put\EHPI\java\log\PREPARE_JSPM_QUEUE_CSZ_03.LOG.

Use the information provided to trouble-shoot the problem. There might be an OSS note providing a solution to this problem. Search for OSS notes with the following search terms:

com.sap.sdt.j2ee.phases.PhaseTypePrepareJSPMQueue

com.sap.sdt.ucp.phases.PhaseException

The stack D:\usr\sap\trans\EPS\in\SMSDXML_W6Q_20100710073202.412.xml contains no components for this system.

PREPARE_JSPM_QUEUE

INIT

NetWeaver Enhancement Package Installation

SAPJup

Java Enhancement Package Installation

I found there were no components of JAVA(.SCA files) in the download and neither in the stack file the component was mentioned anywhere, I have chosen the system and downloaded the package with auto selection and even through the JAVA files were not mentioned and downloaded. I have downloaded now the SCA files but the problem is the upgrade will read the stack file and move accordingly. I just wanted to know can I jump on through this phase and install the JAVA package later on through JSPM in the same we do Solman upgrade or do I need to download the fresh stack file and repeat the phases.

Please advise.

Regards,

Mridul

[former_member126060]

Hello Mridul,

Download and use the latest version of EHpi.

This will resolve the problem