Unresolved request in Buffer Error in pahse DDIC_UPG of ehp4 upgrade

[Former Member]

Hello Expert,

We are doing ehp4 upgrade on production ,And facing the following error .

Error message set: 'Unresolved requests in buffer PRD

Check logfiles 'DDICUPG.ELG' and 'E:\EHPI\abap\log\SAPehpi.ECO''

SAPehi.ECO----

---

TRACE-INFO: 64: 144 0.094852

TRACE-INFO: 65: [dev trc ,00000] Now I'm disconnected from ORACLE 407 0.095259

TRACE-INFO: 66: [dev trc ,00000] Connecting as SAPSR3SHD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

TRACE-INFO: 67: 23 0.095282

TRACE-INFO: 68: [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

TRACE-INFO: 69: 21 0.095303

TRACE-INFO: 70: [dev trc ,00000] 0 UTF8 0000000002B8A0C0 0000000002760D00 0000000002B92A68

TRACE-INFO: 71: 45 0.095348

TRACE-INFO: 72: [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0000000002761518 14 0.095362

TRACE-INFO: 73: [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0000000002761518 20 0.095382

TRACE-INFO: 74: [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3SHD/<pwd>, svchp=0000000002B92928, srvhp=0000000002B931D8, usrhp=0000000002761518)

TRACE-INFO: 75: 23 0.095405

TRACE-INFO: 76: [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 4488 0.099893

TRACE-INFO: 77: [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 125 0.100018

TRACE-INFO: 78: [dev trc ,00000] ORA-01017: invalid username/password; logon denied

TRACE-INFO: 79: 26 0.100044

TRACE-INFO: 80: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 25 0.100069

TRACE-INFO: 81: [dev trc ,00000] set_ocica() -> SQL error code 1017 47 0.100116

TRACE-INFO: 82: [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 11 0.100127

TRACE-INFO: 83: [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 103 0.100230

TRACE-INFO: 84: [dev trc ,00000] ORA-01017: invalid username/password; logon denied

TRACE-INFO: 85: 17 0.100247

TRACE-INFO: 86: [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 38 0.100285

TRACE-INFO: 87: [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#4 @ 433]

TRACE-INFO: 88: 17 0.100302

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 PRD failed (20101014170836, probably wrong environment).

Process with ID 57832 terminated with status 232

-

---

Before the starting this phase ehpi gave me warning .

Unable to read the status of RDDIMDP.

WE CHOOSE OK OPTION and continnued

Ehpi then prompted to run report RDDNEWPP in shadow instance .

But sm37 didnt show any job entry for job RDDIMDP.

-

---

Please help.........

Thanks,

Rushi123

Edited by: RUSHI123 on Oct 14, 2010 2:20 PM

[former_member215759]

At the beginning of SAPehpi there was such a dialogue:

Enter the password for the database shadow user:

ABAP DBA SHADOW PASSWORD: *********

If for any reasons there are any mismatches you'll get ORA-01017 error

FYI: The password for SAPR3SHD is saved in two places:

1. On Oracle level it can be changed with BRCONNECT:

brconnect -u system/password -f chpass -o sapr3shd -p password

• Please make sure, that the current password is sap

2. On R/3 level for the upgrade:

Please reset the password with the help of the Function Module CREATE_SHDDBCON for the db user sapr3shd to sap.

You can execute with SE37 the FM CREATE_SHDDBCON -> press F8

Input the following:

Import parameters Value

DBUSER sapr3shd

DBPASS sap

CONENV DTE

Please check tp connection with R3trans-d command, then repeat phase and let me know if you were able to connect and

proceed further with EHP4 installation.

Regarding ORA-01017: invalid username/password; logon denied error, please also check attached SAP Note 400241 - Problems with ops$ or sapr3

Regards,

Snow

[Former Member]

Thanks for your reply . Really helpful answer .

I solved the proble in the following way sice I was not aware of option provided by you..............

1. Initially I reset the password of sapsr3shd with alter statemnent .

2. Changed the same password with brtools.

Thanks,

Rushikesh