Phase ADJUSTPRP - include TR SPDD & SPAU

[Former Member]

Hi,

I'm stuck at phase ADJUSTPRP, posted message to SAP awaiting their reply but if any of you encountered this problem before would be great! Below is extract from SAPup.ECO

1. Phase ADJUSTPRP:

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 10528 at 20080611115213

ENV <0x4013ccc8>: DIR_LIBRARY=/usr/sap/DCA/SYS/exe/run

ENV <0x4013d0c8>: SHLIB_PATH=/usr/sap/DCA/SYS/exe/run:/opt/java1.4/jre/lib/PA_RI

SC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.0:

/oracle/DCA/102_64/lib:/usr/sap/DCA/SYS/exe/run

ENV <0x77ff0738>: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV <0x77ff0765>: dbs_ora_tnsname=DCA

ENV <0x77ff0779>: ORACLE_PSRV=DCA

ENV <0x77ff0789>: ORACLE_SID=DCA

ENV <0x77ff0798>: ORACLE_HOME=/oracle/DCA/102_64

ENV <0x77ff07b7>: ORA_NLS33=/oracle/DCA/920_64/ocommon/nls/admin/data

ENV <0x77ff0804>: dbms_type=ORA

ENV <0x40134578>: dbs_ora_schema=SAPR3

ENV <0x40134178>: auth_shadow_upgrade=0

EXECUTING /usr/sap/DCA/SYS/exe/run/tp (tp) pf=/usr/sap/put/bin/ADJUSTPRP.TPP cmd

all DCA -Ddblibpath=/usr/sap/DCA/SYS/exe/run

This is /usr/sap/DCA/SYS/exe/run/tp version 270.00.37 (release 45B) for ORACLE database

This is /usr/sap/DCA/SYS/exe/run/R3trans version 6.05 (release 45B - 21.03.07 - 11:35:00).

1AETW000 ===> PANIC: No conversion table <unknown codepage (0x1000)> --> ASCII (ISO 8859-1) available. Please contact the SAP support. exiting ...

/usr/sap/DCA/SYS/exe/run/R3trans finished (0016).

This is /usr/sap/DCA/SYS/exe/run/R3trans version 6.05 (release 45B - 21.03.07 - 11:35:00).

1AETW000 ===> PANIC: No conversion table <unknown codepage (0x1000)> --> ASCII (ISO 8859-1) available. Please contact the SAP support. exiting ...

/usr/sap/DCA/SYS/exe/run/R3trans finished (0016).

ERROR: stopping on error 16 during CMDIMPORT

stopping on error 16 during CMDIMPORT

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

WARNS: Highest tp internal warning was: 0118

tp finished with return code: 16

meaning:

A tool used by tp broke down

Process with ID 10528 terminated with status 16

Below is log from ADJUSTPRP.LOG

1 ETQ000 ==================================================

1 ETQ009 PREPARING UPGRADE PHASE ADJUSTIMP

1 ETQ001 START time "20080611115201"

4 ETQ430 START reading "umodauto.lst" in directory "/usr/sap/trans/bin"

4 ETQ431 "2" entries read

3 ETQ433 END reading "umodauto.lst" in directory "/usr/sap/trans/bin"

4 ETQ008 >

4 ETQ422 START checking for relevant releases

4 ETQ423 release "700" accepted for "SPDD"

4 ETQ424 --> transport "DCDK900002"

4 ETQ423 release "700" accepted for "SPAU"

4 ETQ424 --> transport "DCDK900354"

3 ETQ426 END checking for relevant releases

4 ETQ471 START looking for different source systems

4 ETQ474 found source system "DCD"

4 ETQ473 "1" different source systems found

3 ETQ472 END looking for different source systems

4 ETQ008X >

4 ETQ496 copy correct buffer to "DCA"

4 ETQ008X >

4 ETQ439 START preparing data file(s), cofiles and buffer for 'tp cmd'

4 ETQ508 INFO trans data path : "/usr/sap/trans/data"

4 ETQ509 INFO trans cofile path: "/usr/sap/trans/cofiles"

4 ETQ008 >

4 ETQ442 START preparing transport "DCDK900002"

4 ETQ014 copy "K900002.DCD" from "/usr/sap/trans/cofiles" to "/usr/sap/put/cofiles"

4 ETQ404 START read cofile "K900002.DCD"

4 ETQ510 INFO number of ADOs: "0"

4 ETQ014 copy "R900002.DCD" from "/usr/sap/trans/data" to "/usr/sap/put/data"

4 ETQ445 START add transport "DCDK900002" to buffer

4 ETQ399 ext. env.: DIR_LIBRARY=/usr/sap/DCA/SYS/exe/run

4 ETQ399 ext. env.: SHLIB_PATH=/usr/sap/DCA/SYS/exe/run:/opt/java1.4/jre/lib/PA_

RISC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.

0:/oracle/DCA/102_64/lib:/usr/sap/DCA/SYS/exe/run

4 ETQ399 2008/06/11 11:52:12: put_execute: (tp) forkpid:10526

4 ETQ006 successful

4 ETQ446 addtobuffer: rc="0"

4 ETQ447 END add transport "DCDK900002" to buffer

3 ETQ444 END preparing transport "DCDK900002"

4 ETQ434 START writing entry to "umodauto.lst" in directory "/usr/sap/put/bin"

4 ETQ435 entry: "SPDD" "700" "DCDK900002"

4 ETQ006 successful

4 ETQ437 write: rc="0"

3 ETQ438 END writing entry to "umodauto.lst" in directory "/usr/sap/put/bin"

4 ETQ008 >

4 ETQ442 START preparing transport "DCDK900354"

4 ETQ014 copy "K900354.DCD" from "/usr/sap/trans/cofiles" to "/usr/sap/put/cofiles"

4 ETQ404 START read cofile "K900354.DCD"

4 ETQ510 INFO number of ADOs: "0"

4 ETQ014 copy "R900354.DCD" from "/usr/sap/trans/data" to "/usr/sap/put/data"

4 ETQ445 START add transport "DCDK900354" to buffer

4 ETQ399 ext. env.: DIR_LIBRARY=/usr/sap/DCA/SYS/exe/run

4 ETQ399 ext. env.: SHLIB_PATH=/usr/sap/DCA/SYS/exe/run:/opt/java1.4/jre/lib/PA_

RISC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.

0:/oracle/DCA/102_64/lib:/usr/sap/DCA/SYS/exe/run

4 ETQ399 2008/06/11 11:52:13: put_execute: (tp) forkpid:10527

4 ETQ006 successful

4 ETQ446 addtobuffer: rc="0"

4 ETQ447 END add transport "DCDK900354" to buffer

3 ETQ444 END preparing transport "DCDK900354"

4 ETQ434 START writing entry to "umodauto.lst" in directory "/usr/sap/put/bin"

4 ETQ435 entry: "SPAU" "700" "DCDK900354"

4 ETQ006 successful

4 ETQ437 write: rc="0"

3 ETQ438 END writing entry to "umodauto.lst" in directory "/usr/sap/put/bin"

3 ETQ441 END preparing data file(s), cofiles and buffer for 'tp cmd'

4 ETQ008X >

4 ETQ448 START 'tp cmd all "DCA"'

4 ETQ019 tp cmd: rc="-1"

3 ETQ449 END 'tp cmd all "DCA"'

4 ETQ008 >

4 ETQ493 restoring original buffer

1 ETQ002 END time "20080611121444"

1 ETQ003 exit code: "-10"

1 ETQ010 meaning PE0666 'tp cmd all <SID> u1' failed

1 ETQ009 PREPARING UPGRADE PHASE ADJUSTIMP

1 ETQ000 ==================================================

[Former Member · Accepted solution]

Hi,

Have you updated karnel before starting PREPARE?

Your tp version is looking too old. 270.00.37 (release 45B)

Please update to 46D_EXT kernel before starting PREPARE.

[Former Member · Accepted solution]

Hi Sharad Singh,

Thanks for your advice. I'm attempting to update the kernel to 46D but the work process seem to be not running properly.. Attached below from dev_wp0 file

-

---

trc file: "dev_w0", trc level: 1, release: "46D"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

M

M Wed Jun 11 15:37:38 2008

M relno 4640

M patchlevel 0

M patchno 1668

M intno 0

M pid 18747

M

M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 18747) [thxxhead.c 995]

M ThSysUsrCheck: clear T0

M calling db_connect ...

C Got ORACLE_HOME=/oracle/DCA/102_64 from environment

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@DCA on connection 0 ...

C Now I'm connected to ORACLE

C Got SAPR3's password from table SAPUSER

C Disconnecting from connection 0 ...

C Now I'm disconnected from ORACLE

C Try to connect with the password I got from OPS$-user

C Connecting as SAPR3/<pwd>@DCA on connection 0 ...

C

C Wed Jun 11 15:37:39 2008

C Now I'm connected to ORACLE

C Database instance DCA is running on bspqas with ORACLE version 10.2.0.2.0 sin

ce 20080611

B Connection 0 opened

B Wp Hdl ConName ConCnt ConState TX PRM RCT Date Time

B 000 000 R/3 000000 ACTIVE NO YES NO 20080611 153738

M db_connect o.k.

I

I Wed Jun 11 15:37:53 2008

I MtxInit: 0 0 0

I Profile configuration error detected, use temporary corrected setup

I Shared Pool 40: ipc/shm_psize_40 = 14250000 (too small)

I Shared Pool 40: (smaller than min requirement 72162816)

I Shared Pool 40: (estimated size assumed 76000000)

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

X ES initialized.

B db_con_shm_ini: WP_ID = 0, WP_CNT = 16

M rdisp/reinitialize_code_page -> 0

M PfReadDBVersion: use compatibility mode for stat-files

S

S Wed Jun 11 15:37:55 2008

S *** init spool environment

S initialize debug system

T Stack direction is upwards.

T debug control: prepare exclude for printer trace

T new memory block 8000000101b1d230

S *** ERROR => TSP01-RQDOCTYPE not found (field count). [rspoini.c 519]

S spool kernel/ddic check: Failed

S using table TSP02F for frontend printing

S 1 spool work process(es) found

S direct frontend printing

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S immediate print option for implicitely closed spool requests is disabled

M ***LOG R19=> tskh_init, rspoi_init ( Spooler 000001) [thxxhead.c 1400]

M *** ERROR => .--

---

============--

---

-

---

. [thxxhead.c 779]

M *** ERROR => | RSPO - Error

| [thxxhead.c 779]

M *** ERROR => | code: 1 RSPOEINTERN Some other internal error

| [thxxhead.c 779]

M *** ERROR => | TSP01-RQDOCTYPE not found (field count).

| [thxxhead.c 779]

M *** ERROR => | module: rspoini no: 1 line: 520 T10

0: PO001 | [thxxhead.c 779]

M *** ERROR => | TSL01: F8T p3: TSP01-RQDOCTYPE not found (field count).

| [thxxhead.c 779]

M *** ERROR => |----

---

-

---

| [thxxhead.c 779]

M *** ERROR => | No entry in error history

| [thxxhead.c 779]

M *** ERROR => `----

---

-

---

' [thxxhead.c 779]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: rspoi_init (step 1, th_errno 2, action 3) [thxxhead.c 8074]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource = 0

M ext_checked_resource = 0

M report = > <

M action = 0

M tab_name = > <

M Entering ThSetStatError

M call ThrShutDown (1) ...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 18747) [dpuxtool.c 281]

[Former Member]

thx for the input

[Former Member]

Hi Wei,

I noticed in your ADJUSTPRP.LOG file, the following entries:

I Profile configuration error detected, use temporary corrected setup

I Shared Pool 40: ipc/shm_psize_40 = 14250000 (too small)

I Shared Pool 40: (smaller than min requirement 72162816)

I Shared Pool 40: (estimated size assumed 76000000)

Find this parameter "ipc/shm_psize_40" in your instance profile, and increase the value to at least 72162816

You should now be able to restart SAP, and be able to login to your system

Cheers

Ian

[Former Member]

Hi,

Could you tell me previously you were using 45B or 45B_EXT kernel?

Please go for latest version of 45B_EXT kernel if available. I this 46D_EXT is not compatible to source release as it is failing in kernel/ddic check.