Solved: SAP EHP 7 Severe error(s) occurred in phase PREP_E...

former_member280874 · ‎08-24-2015

Hi everyone

We are in the process of upgrading our ECC ERP system from EHP5 to EHP 7 on OS: HP-UX.

as for preparation, we did a system copy of this system (NP3) to a test

system (NP3) and successfully upgraded the test system to EHP 7.

we now want to continue with the rest of the system but got stuck in

PREP_EXTRACT/SSFS_PREP for the past 10 days. we configured SSFS and the

SAP system is up and running. R3trans -d returns no errors. please see below for log,

***********************************************************************************************************************************

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000 [ dev trc,00000] Thu Aug 20 20:00:34 2015 35709 0.035709

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/NP3/SYS/exe/run/dboraslib.so' ... 587 0.036296

4 ETW000 [ dev trc,00000] Thu Aug 20 20:00:35 2015 765425 0.801721

4 ETW000 [ dev trc,00000] Library '/usr/sap/NP3/SYS/exe/run/dboraslib.so' loaded 41 0.801762

4 ETW000 [ dev trc,00000] Version of '/usr/sap/NP3/SYS/exe/run/dboraslib.so' is "721.02", patchlevel (0.518)

4 ETW000 80304 0.882066

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 12714 0.894780

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] dbs/ora/stmt_cache_size = 250 69087 0.963867

4 ETW000 [ dev trc,00000] Register application info. 20059 0.983926

4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.4.0, V2, default build, (dbsl 721 300615, UNICODE[2])

4 ETW000 37523 1.021449

4 ETW000 [ dev trc,00000] Installed Oracle client patches: 47 1.021496

4 ETW000 [ dev trc,00000] # Patch 12985200 : Created on 2 Jul 2014, 09:45:20 hrs PST8PDT

4 ETW000 28 1.021524

4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 6 Nov 2013, 15:22:08 hrs CET 21 1.021545

4 ETW000 [ dev trc,00000] Thu Aug 20 20:00:36 2015 1611270 2.632815

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000 67 2.632882

4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@NP3 on connection 0 (nls 0) ... (dbsl 721 300615, UNICODE[2])

4 ETW000 1212 2.634094

4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=6Z1269b78 created, rc=0 6713 2.640807

4 ETW000 [ dev trc,00000] Thu Aug 20 20:00:37 2015 480337 3.121144

4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=6Z1269b78): New server hdl. srv=6Z126c240 attached to 'NP3'

4 ETW000 66 3.121210

4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=6Z1269b78, srv=6Z126c240='NP3'): start session usr=6Z12db700='SAPSR3', rc=0

4 ETW000 360408 3.481618

4 ETW000 [ dev trc,00000] Now 'SAPSR3/<pwd>@NP3' is connected: con=0, nls=0, session=6, time='2015-08-20 20:00:37'

4 ETW000 95663 3.577281

4 ETW000 [ dev trc,00000] DB instance NP3 is running on npdev with ORACLE version 11.2.0.4.0 since AUG 20, 2015, 19:59:53.

4 ETW000 11046 3.588327

4 ETW000 [ dev trc,00000] con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8

4 ETW000 10327 3.598654

4 ETW000 [ dev trc,00000] # CharacterSet NCharSet envhp errhp er2hp bathp

4 ETW000 1194 3.599848

44y0CBtrans.log (59%)@44y0C44y0C4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 6Z12383c0 6Z1267b18 6Z1268bb8 6Z1269c58

4 ETW000 32 3.599880

4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 46 3.599926

4 ETW000 [ dev trc,00000] DbSlControl(DBSL_CMD_SAPRELEASE_SET,abap='702') 75934 3.675860

4 ETW000 [ dev trc,00000] NTAB: version is VERS_B, UNICODELG=2, SAP_UC_LN=2 118209 3.794069

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'NP3' --- SYSTEM = 'NP3'.

4 ETW690 COMMIT "0" "0"

4 ETW000 trace to file pointer closed

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 20.08.2015 - 20:00:38

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [ dev trc,00000] Thu Aug 20 20:00:38 2015 12454 0.012454

4 ETW000 [ dev trc,00000] Disconnecting from ALL connections: 19 0.012473

4 ETW000 [ dev trc,00000] dbcon[db_con_disconnect_all]: disconnecting from connection 0 ... 17 0.012490

4 ETW000 [ dev trc,00000] Disconnecting con=0 41 0.012531

4 ETW000 [ dev trc,00000] OCISessionEnd(con=0, svc=6Z1269b78, srv=6Z126c240='NP3'): Close session usr=6Z12db700, rc=0

4 ETW000 25826 0.038357

4 ETW000 [ dev trc,00000] OCIServerDetach(stale1 con=0, svc=6Z1269b78, srv=6Z126c240='NP3') successfully detached

4 ETW000 23776 0.062133

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=6Z1269b78): Server handle srv=6Z126c240 freed

4 ETW000 33 0.062166

4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service hdl. svc=6Z1269b78 freed. 18 0.062184

4 ETW000 [ dev trc,00000] dbcon[db_con_disconnect_all]: disconnected from connection 0 28 0.062212

4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=1, com_tx=1) 16 0.062228

4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 15 0.062243

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 20.08.2015 - 20:00:38

***********************************************************************************************************************************

but still we cant get pass this phase. Below you will get all the diffirent log files related to SSFS

we using the latest SUM tool version 1.0.13.4. We also upgraded our

kernel from 720 to 721 level 500. we also upgrated the Lib_dbsl to lib_dbsl_518-10011323 but that did not help.

***********************************************************************************************************************************

in summary of the log file point to this error

oracle/NP3/SUM/SUM/abap/bin/SAPuptool dbversion

3EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

2 ETQ399 Connecting to database 'ORA'.

3EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

4EETQ399 1 [ dboci.c, 5092]: # CharacterSet NCharSet envhp errhp er2hp bathp

1EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

1EETQ003 exit code: "20"

2 ETQ399 Connecting to database 'ORA'.

3EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

4EETQ399 2 [ dbsloci.c, 1719]: -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=1, tagset=1

4EETQ399 2 [ dbsloci.c, 1660]: -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4EETQ399 2 [ dbsloci.c, 2217]: -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='721')

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=24, mem_dbsl=24

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=30, mem_dbsl=54

4EETQ399 1 [ dbsloci.c,13008]: dbs/ora/stmt_cache_size = 250

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=38016, mem_dbsl=38070

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=72016, mem_dbsl=110086

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=76016, mem_dbsl=186102

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=4928, mem_dbsl=191030

4EETQ399 3 [ dbsloci.c,15598]: my_malloc: size=8064, mem_dbsl=199094

4EETQ399 3 [ dboci.c, 2295]: -->oci_init1()

4EETQ399 1 [ dboci.c, 2335]: Register application info.

4EETQ399 1 [ dbsloci.c, 2332]: Oracle client version: 10.2.0.4.0, V2, (dbsl 721 030315, UNICODE[2])

4EETQ399 1 [ dbsloci.c, 2390]: Installed Oracle client patches:

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 7294776 : Created on 17 Sep 2008, 13:39:38 hrs US/Pacific

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 7253620 : Created on 24 Jul 2008, 02:56:15 hrs PST8PDT

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 7252962 : Created on 4 Aug 2008, 05:18:48 hrs PST8PDT

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 6944036 : Created on 9 Jun 2008, 17:53:13 hrs US/Pacific

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 6826661 : Created on 28 May 2008, 03:27:17 hrs PST8PDT

4EETQ399 1 [ dbsloci.c, 2392]: # Patch 6775231 : Created on 30 Sep 2008, 04:50:08 hrs PST8PDT

4EETQ399 2 [ dbsloci.c, 2434]: Default connection: tnsname ='NP3'

4EETQ399 2 [ dboci.c, 2535]: -->oci_initialize(con=0, char='UTF16', nchr='AL16UTF16', nls=0),uc_ln=2

4EETQ399 3 [ dbsloci.c,15623]: my_malloc1: size=184, mem_dbms=184

4EETQ399 3 [ dbsloci.c,15623]: my_malloc1: size=24, mem_dbms=208

4EETQ399 3 [ dbsloci.c,15623]: my_malloc1: size=280, mem_dbms=488

4EETQ399 2 [ dboci.c, 4114]: check: OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR

4EETQ399 2 [ dboci.c, 4166]: OCIErrorGet() failed with rc=-2

4EETQ399 2 [ dboci.c, 4167]: -> no further error details available

4EETQ399 2 [ dboci.c, 2613]: OCIEnvCreate(mode=16384=OCI_UTF16) -> rc=-1, env=6700680069006a (for default NLS hdl)

4EETQ399 1 [ dboci.c, 5092]: # CharacterSet NCharSet envhp errhp er2hp bathp

4EETQ399 2 [ dbsloci.c,18013]: ocica() -> OCI return code -1

4EETQ399 2 [ dbsloci.c, 2763]: DbSlConnect(con=0) -> orc=-1, rc=99=DBSL_ERR_DB

1EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

1EETQ003 exit code: "20"

2 ETQ399 Connecting to database 'ORA'.

3EETQ008 Error message: DBSL error 99 (db code -1): Connect failed

***********************************************************************************************************************************

but that does not tell me much.

I logged a call with SAP and its been 7 days with no reply

please assist

thanks in advance

regards

Steven

Reagan · ‎08-24-2015

Your system is running on Oracle database 11.2.0.4.0 but it is still using Oracle Instant 10.2.0.4.0

Stop the complete system. Update the client and restart the upgrade.

former_member185239 · ‎08-24-2015

Dear Steven,

SSFS configuration is not getting reflected for Oracle.

Try to remove the parameter from spfile and pfile

1. OS_AUTHENT_PREFIX = ops$

2. REMOTE_OS_AUTHENT = true.

Now setup the SSFS configuration and retry the steps.

With Regards

Ashutosh Chaturvedi

former_member182657 · ‎08-24-2015

Hi,


SAP system is up and running. R3trans -d returns no errors

I would like to first analyze trans.log file for SSFS configuration from the R3trans -d output.

Regards,

Former Member · ‎08-24-2015

Hello Steven,

I could see it your DB is Oracle.

Please check tablespace PSAPTEMP size.

Perform log backup and try again.

Regards

Anand

lrwxr-xr-x 1 np3adm	sapsys	21 Aug 25 13:04 10x_64 -> /oracle/client/11x_64
drwxrwxr-x 3 np3adm	sapsys	8192 Jul 31 2011 10x_64.old
drwxrwxrwx 4 np3adm	sapsys	8192 Aug 31 11:31 11x_64

SAP EHP 7 Severe error(s) occurred in phase PREP_EXTRACT/SSFS_PREP!

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

Screen enhancement for EK92 - Payment plan creatio...

Re: Partial settlement not reversing accruals in S...

Build of MDKWebpackFactory failed for SSAM 2310

Eliminating Formatted search

NOTIFICATION FOR FAILED MEASURING POINT VALUES