ECC upgrade stuck in pre-processing phase

[Former Member]

Hi All,

Small query on SAP upgrade pre-processing phase.

Below are my queries :-

1. DBclone phase in pre-processing got successful

2.while trying to perform updatestats in the tables copied by from original schema owner to shadow schema owner it was throwing error i accepted error here.

3. In next phase also i got error....

In log file it was throwing error for this piece of command  GRANT ALL ON SAPSR3."SEOFRIENDS~" TO SAPECCSHD

When i checked this SEOFRIENDS table in SAPECCSHD it was not visbile for desc command , but for the rest of the tables it is showing in shadow schema .

So SEOFRIENDS table is not copied DBCLONE phase properly to shadow schema. In this case if i need to copy manually this table to shadow schema do i need to copy data as well as or structure.

Did any one faced this issue previously.

Appreciate your inputs.

Thanks,

Pradeep.

[Former Member · Accepted solution]

Hi All,

Issue got fixed after re-starting the upgrade Thanks Tomas for your valuable suggestion.

Issues encountered during this upgrade:-

1.DBLONE phase was successful  but it didn't copy tables properly. So restarted the upgrade from scratch.

2. I got this error in execution phase for XPRA ,  No Sutiable RFC found for RFC destination ,

i followed this blog http://scn.sap.com/community/enhancement-packages/blog/2013/03/20/no-suitable-rfc-destination-could-...

Thanks all for your valuable suggestions special thanks to Gaurav..

Thanks

Pradeep.

[former_member182657 · Accepted solution]

Hi Pradeep,

Thanks for the update and for sharing the outcomes of the thread.Request you to close the thread.

Good luck !!

[Former Member · Accepted solution]

Hi Pradeep, good day, I'd like to ask the steps (what did you erase, etc..) you did when you restarted the upgrade from scratch? I'm currently on the same phase and stuck at the moment with the same error on "ORA-20000: Unable to analyze TABLE". Thanks very much in advance for your help!

[Former Member · Accepted solution]

Hello Yel,

As per what suggested to Pradeep.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I strongly suggest you to reset the current upgrade and start afresh.

Please download the very last patch level of SUM SP12, which is PL 11, released 2 days ago.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Reset the upgrade, cleanup the SUM directory and start all over using the LATEST SUM.

Cheers,

Amerjit

[Former Member · Accepted solution]

Hi,

Try this solution too 2073326 - ORA-20000: Unable to analyze TABLE "sapsr3"."/BIC/A1234567B", insufficient privileges or d...

Thanks

Pradeep.

[Former Member]

Hi ,

What are the parameter used for calucaltion of R3trans, DDL sql , CRR .

How do we need to calcualte for the upgrade.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

Hope your issue for the thread has already been resolved,if yes kindly close the thread .For the query

How do we need to calcualte for the upgrade.

you could refer SAP KBA   1616401 - Understanding parallelism during the Upgrades, EhPs and Support Packages implementations

which i've also answered at your new thread

Regards,

Gaurav

[Former Member]

Hi All,

Upgrade is running in shadow_import_inc for last 24 hrs. Is there any way to optimize this phase in pre-processing.

Really appreciate your inputs.

Thanks,

Pradeep.

[Former Member]

Pradeep,

Don't worry too much about the runtime.

It will depend on what values you provided for the number of processes (config phase), the delta of your upgrade (stack you are coming from and going to) as well as the capacity of your machine.

Next time you can increase the number of processes during during the uptime phase. Be careful though overdoing parallel processes can also have a negative effect if you get to greedy 🙂

Cheers,

Amerjit

[Former Member]

Hi Tomas,

I have restarted the upgrade from the scratch and once completed will inform all of you. Thanks for your support.

Really appreciate your inputs.

Thanks & Best Regards,

Pradeep G.

[Former Member]

Hi All,

I need to get latest DBSL for 721 kernel 300 but it is not available in service market place.

Is there any way to get this.

Thanks

Pradeep

[Former Member]

Hi ,

Below is the result for the R3trans,

This is R3trans version 6.24 (release 721 - 14.10.14 - 20:14:08).

unicode enabled version

R3trans finished (0000).

Still no luck .

In log file it is showing as below

R3load: START OF LOG: 20150319145132

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 22146

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 28

R3load: job finished with 1 error(s)

(STAT) DATABASE times: 0.016/0.010/0.000 100.0%/100.0%/0.0% real/usr/sys.

R3load: END OF LOG: 20150319145132

Note:-

1.Kernel upgrade performed on source and target exe's including TP,R3trans,DBSL,R3load..

2.But there is some connection issue in upgrade phase trying to connect with shadow instance...

Appreciate your thoughts on this .

Thanks

Pradeep.

[Former Member]

Hi All,

The above issue for dbsl is fixed , by setting R3load and DBSL trace level

setenv DBSL_ORA_TRACE_LEVEL  3
setenv  R3LOAD_TL  3

Set this env variable and Ran the SUM tool then we got more logs there i found out SHADOW_DB_USER and SHADOW PASSWORD was not set in SSSFS.DAT file so we created SHADOW_USER , SHADOW_PASSWORD in SSFS.DAT file by running normal

rsecssfx put DB_CONNECT/SHADOW_DB_USER  schema user id  -plain

rsecssfx put DB_CONNECT/SHADOW_DB_PASSWORD zaq12wsx

but prevoiuss issue ,

R3load: START OF LOG: 20150325120724

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 16417

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(RDI) INFO: /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.STR has format version 2

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(DB) ERROR: DDL statement failed

(DROP VIEW "SQLRCUST")

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=28508160)

(DB) ERROR: DDL statement failed

(CREATE VIEW "SQLRCUST" ( "SQLRPROG" , "SQLRTAB" , "SQLRFUNCID" , "SQLRGROUP" , "SQLLANGU" , "SQLRRELUL" , "SQLRRELOL" , "SQLRPRIO" , "SQLRBEFORE" , "SQLRAFTER" , "SQLRGROUPD" , "SQLRFUNCDS"  ) AS SELECT T0

1. 001."SQLRPROG", T0001."SQLRTAB", T0001."SQLRFUNCID", T0001."SQLRGROUP", T0002."SQLLANGU",  T0001."SQLRRELUL", T0001."SQLRRELOL", T0001."SQLRPRIO", T0001."SQLRBEFORE", T0001."SQLRAFTER", T0002."SQLRGROUPD", T
2. 0003."SQLRFUNCDS" FROM "SQLRTAB" T0001, "SQLRTEXT1" T0002, "SQLRTEXT2" T0003 WHERE T0001."SQLRFUNCID" = T0002."SQLRFUNCID" AND T0001."SQLRFUNCID" = T0003."SQLRFUNCID" AND T0001."SQLRGROUP" = T0002."SQLRGROUP

" AND T0002."SQLLANGU" = T0003."SQLLANGU")

DbSlExecute: rc = 99

  (SQL error 1031)

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) ERROR: DDL statement failed

(DROP VIEW "SRESETDEVC")

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=37814272)

(DB) ERROR: DDL statement failed

(CREATE VIEW "SRESETDEVC" ( "OBJ_TYPE" , "OBJ_NAME" , "SUB_TYPE" , "SUB_NAME" , "INT_TYPE" , "INT_NAME" , "OPERATION" , "MAIN_PROG" , "MOD_LANGU" , "MOD_USER" , "MOD_DATE" , "MOD_TIME" , "PROT_ONLY" , "MARK

" , "SPAU" , "TRKORR" , "DEVCLASS"  ) AS SELECT T0001."OBJ_TYPE", T0001."OBJ_NAME", T0001."SUB_TYPE", T0001."SUB_NAME", T0001."INT_TYPE",  T0001."INT_NAME", T0001."OPERATION", T0001."MAIN_PROG", T0001."MOD_L

ANGU", T0001."MOD_USER", T0001."MOD_DATE", T0001."MOD_TIME", T0001."PROT_ONLY", T0001."MARK", T0001."SPAU", T0001."TRKORR", T0002."DEVCLASS" FROM "SRESETLOG" T0001, "TADIR" T0002 WHERE T0001."OBJ_TYPE" = T00

1. 02."OBJECT" AND T0001."OBJ_NAME" = T0002."OBJ_NAME" AND T0002."PGMID" = 'R3TR')

DbSlExecute: rc = 99

  (SQL error 1031)

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) ERROR: DDL statement failed

(DROP VIEW "SRMRGRULENAME")

Can anyone tell me how to resolve the above the error.

Thanks

Pradeep.

[Former Member]

But here the prevoius issue is still persisting ..

R3load: START OF LOG: 20150325120724

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 16417

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(RDI) INFO: /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.STR has format version 2

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(DB) ERROR: DDL statement failed

(DROP VIEW "SQLRCUST")

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=28508160)

(DB) ERROR: DDL statement failed

(CREATE VIEW "SQLRCUST" ( "SQLRPROG" , "SQLRTAB" , "SQLRFUNCID" , "SQLRGROUP" , "SQLLANGU" , "SQLRRELUL" , "SQLRRELOL" , "SQLRPRIO" , "SQLRBEFORE" , "SQLRAFTER" , "SQLRGROUPD" , "SQLRFUNCDS"  ) AS SELECT T0

1. 001."SQLRPROG", T0001."SQLRTAB", T0001."SQLRFUNCID", T0001."SQLRGROUP", T0002."SQLLANGU",  T0001."SQLRRELUL", T0001."SQLRRELOL", T0001."SQLRPRIO", T0001."SQLRBEFORE", T0001."SQLRAFTER", T0002."SQLRGROUPD", T
2. 0003."SQLRFUNCDS" FROM "SQLRTAB" T0001, "SQLRTEXT1" T0002, "SQLRTEXT2" T0003 WHERE T0001."SQLRFUNCID" = T0002."SQLRFUNCID" AND T0001."SQLRFUNCID" = T0003."SQLRFUNCID" AND T0001."SQLRGROUP" = T0002."SQLRGROUP

" AND T0002."SQLLANGU" = T0003."SQLLANGU")DbSlExecute: rc = 99  (SQL error 1031)  error message returned by DbSl:ORA-01031: insufficient privileges(DB) ERROR: DDL statement failed(DROP VIEW "SRESETDEVC")DbSlExecute: rc = 103  (SQL error 942)  error message returned by DbSl:ORA-00942: table or view does not exist(IMP) INFO: a failed DROP attempt is not necessarily a problemDbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=37814272)(DB) ERROR: DDL statement failed(CREATE VIEW "SRESETDEVC" ( "OBJ_TYPE" , "OBJ_NAME" , "SUB_TYPE" , "SUB_NAME" , "INT_TYPE" , "INT_NAME" , "OPERATION" , "MAIN_PROG" , "MOD_LANGU" , "MOD_USER" , "MOD_DATE" , "MOD_TIME" , "PROT_ONLY" , "MARK" , "SPAU" , "TRKORR" , "DEVCLASS"  ) AS SELECT T0001."OBJ_TYPE", T0001."OBJ_NAME", T0001."SUB_TYPE", T0001."SUB_NAME", T0001."INT_TYPE",  T0001."INT_NAME", T0001."OPERATION", T0001."MAIN_PROG", T0001."MOD_LANGU", T0001."MOD_USER", T0001."MOD_DATE", T0001."MOD_TIME", T0001."PROT_ONLY", T0001."MARK", T0001."SPAU", T0001."TRKORR", T0002."DEVCLASS" FROM "SRESETLOG" T0001, "TADIR" T0002 WHERE T0001."OBJ_TYPE" = T00

1. 02."OBJECT" AND T0001."OBJ_NAME" = T0002."OBJ_NAME" AND T0002."PGMID" = 'R3TR')

DbSlExecute: rc = 99

  (SQL error 1031)

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) ERROR: DDL statement failed

(DROP VIEW "SRMRGRULENAME")

Can anyone help

Thanks

Pradeep

[Former Member]

Hi All,

How do i generate SQLFiles.LST file in upgrade .

Really appreciate your thoughts..

Thanks

Pradeep.

[tomas_black]

Hello Pradeep,

you're still stuck on DBCLONE phase since March 10th?

I strongly suggest you to reset the current upgrade and start afresh.

Please download the very last patch level of SUM SP12, which is PL 11, released 2 days ago.

DBCLONE is a very sensitive phase, where the source system is cloned into the shadow one. Any hickup on this phase means severe problems on the subsequent ones.

Repeat the upgrade from scratch and get back to us on this thread in case you face problems again.

Best regards,

Tomas Black

[Former Member]

Hi Team,

I guess it is a SSFS issue and i have changed the  path in env variable to below

c shell

RSEC_SSFS_DATAPATH=/usr/sap/SID/SYS/global/security/rsecssfs/data; export RSEC_SSFS_DATAPATH

RSEC_SSFS_KEYPATH=/usr/sap/SID/SYS/global/security/rsecssfs/key; export RSEC_SSFS_KEYPATH

rsdb_ssfs_connect=1; export rsdb_ssfs_connect

korn shell

setenv RSEC_SSFS_DATAPATH /usr/sap/SID/SYS/global/security/rsecssfs/data

setenv RSEC_SSFS_KEYPATH /usr/sap/SID/SYS/global/security/rsecssfs/key

setenv rsdb_ssfs_connect 1

After this i am getting below error ,

R3load: START OF LOG: 20150313190734

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 29713

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 28

R3load: job finished with 1 error(s)

(STAT) DATABASE times: 0.172/0.000/0.010 100.0%/0.0%/100.0% real/usr/sys.

R3load: END OF LOG: 20150313190734

htdohir1:orair1 47> more ../shdviews/SHDVIEWS_00002_IMP.LOG

R3load: START OF LOG: 20150313190734

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 29714

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 28

R3load: job finished with 1 error(s)

(STAT) DATABASE times: 0.167/0.010/0.010 100.0%/100.0%/100.0% real/usr/sys.

R3load: END OF LOG: 20150313190734

Thanks

Pradeep

[Former Member]

Hi Pradeep,

The error mentioned contains lines as below:

-------------------- Start of patch information ------------------------
patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)
DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)
--------------------- End of patch information -------------------------
process id 29714
(DB) ERROR: db_connect rc = 256
(DB) ERROR: DbSlErrorMsg rc = 28

Just to check was the oracle upgrade performed before the Upgrade and have you update the kernel with latest R3trans, R3load, tp & dbsl libraries.

And once your ssfs environment is changed have your tested your R3trans -d & r3trans -x.

Let us know the details.

Regards,

Ram

[Former Member]

Hi Gaurav,

Query is in pre-processing i need to start from DBclone phase again for that what needs to be done , as per the the link it will stop update .

I will try to set ssfs env to 0 and try .

Thanks

Pradeep.

[former_member182657]

Hi Pradeep,

Have you checked it thoroughly ? This will provide you RESET option.

Thanks,

[former_member182657]

Hi Pradeep,

I will try to set ssfs env to 0 and try .

No need to set it with value 0,as you're using SSFS database connection.

Thanks,

[Former Member]

Hi Gaurav,

If we select this option it will reset the upgrade to scratch ???

I need to reset the upgrade for pre-processing only...

There is no option  in the link it is for full reset of the ugrade.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

Unfortunately reset upgrade in pre-processing phase will push you at the beginning of upgrade ( need to start it from scratch ). Here i could be wrong as i've not face such type of issue during any of my upgrade projects,especially under pre processing phase.

But before doing reset i suggest you to take backup of complete SUM dir as well as follow SCN link at

Regards,

[Former Member]

Hi All,

Is anyone having idea on how to reset the pre-processing to starting ,  for this what all needs to comment in MEMSAPup.dat file .

Please  give your valuable inputs.

Thanks

Pradeep.

[former_member182657]

Follow SCN doc How to reset an update when you are in Preprocessing roadmap with SUM SP11 - Technology Troubleshoot...

[former_member182657]

Hi,

Previously you executed below

GRANT ALL ON SAPSR3.SEOFRIENDS TO SAPSR3SHD;

But in your first response issue is showing with

GRANT ALL ON SAPSR3."SEOFRIENDS~" TO SAPECCSHD

getting .Could you execute the correct one & re share the results.

[Former Member]

Hi Gaurav,

Executed the command for creating view but in which schema do i need to run also there are around 100 or more view entries displayed in the logs file as similar.

Granted sapconn permission and ran still getting same error.

Thanks Pradeep.

[former_member182657]

Before execution of above command could you provide SAPCONN to SAPSR3SHD by using command.

grant SAPCONN to SAPSR3SHD;

& then execute the above command.

Regards,

[former_member182657]

Hi Pradeep,

In regards of your system current situation,i requests Reagan Benjamin & Tomas Black to give their valuable suggestions on the issue,as per me you need to reset the upgrade due to skipping of errors during the upgrade pre processing phase.

Let's wait for their responses on the same for resolution.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

I have executed this command

GRANT ALL ON SAPSR3.SEOFRIENDS TO SAPSR3SHD;

After that we are getting different sort of error's.

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

R3load: job finished with 183 error(s)

(STAT) DATABASE times: 3.442/0.240/0.260 100.0%/100.0%/100.0% real/usr/sys.

R3load: END OF LOG: 20150312182638

Thanks,

Pradeep.

[former_member182657]

Could you share R3load.exe.log file

Thanks,

[Former Member]

Hi Gaurav,

R3load.exe.log file is not existing in /SUM/ abap/log file,

Is this file you require ,

1. more R3LDCALLRUN.ELG

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

ANALYSIS OF LOG FILE '/ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.LOG'

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

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

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

ANALYSIS OF LOG FILE '/ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.LOG'

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

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

2. log file SHDVIEWS_00001_IMP.LOG

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=43646976)

(DB) ERROR: DDL statement failed

(CREATE VIEW "SQADBREV_V" ( "QUEID" , "ANSWERTYPE" , "ANSGLOBAL" , "FSTUSER" , "FSTTSTAMP" , "FSTREL" , "LSTUSER" , "LSTTSTAMP" , "LSTREL" , "CHTAB" , "CHFIELD" , "STATUS" , "LANGU" , "ADDON" , "QTEX

T" , "PROB" , "PRIO" , "USAG" , "AGENDA" , "SUBJAREA" , "SUBJECT" , "MEMO"  ) AS SELECT T0001."QUEID", T0001."ANSWERTYPE", T0001."ANSGLOBAL", T0001."FSTUSER", T0001."FSTTSTAMP",  T0001."FSTREL", T0001

."LSTUSER", T0001."LSTTSTAMP", T0001."LSTREL", T0001."CHTAB", T0001."CHFIELD", T0001."STATUS", T0003."LANGU", T0003."ADDON", T0003."QTEXT", T0002."PROB", T0002."PRIO", T0002."USAG", T0002."AGENDA", T0

002."SUBJAREA", T0002."SUBJECT", T0002."MEMO" FROM "SQADB01" T0001, "SQADB01REV" T0002, "SQADB01T" T0003 WHERE T0001."QUEID" = T0002."QUEID" AND T0001."QUEID" = T0003."QUEID")

DbSlExecute: rc = 99

  (SQL error 1031)

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

R3load: job finished with 183 error(s)

(STAT) DATABASE times: 16.614/0.270/0.270 100.0%/100.0%/100.0% real/usr/sys.

R3load: END OF LOG: 20150312190041

Both the log files getting the above same error as ORA-00942

Kindly give your valuable suggestion.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

Could you execute query

CREATE VIEW "SQADBREV_V" ( "QUEID" , "ANSWERTYPE" , "ANSGLOBAL" , "FSTUSER" , "FSTTSTAMP" , "FSTREL" , "LSTUSER" , "LSTTSTAMP" , "LSTREL" , "CHTAB" , "CHFIELD" , "STATUS" , "LANGU" , "ADDON" , "QTEX
T" , "PROB" , "PRIO" , "USAG" , "AGENDA" , "SUBJAREA" , "SUBJECT" , "MEMO"  ) AS SELECT T0001."QUEID", T0001."ANSWERTYPE", T0001."ANSGLOBAL", T0001."FSTUSER", T0001."FSTTSTAMP",  T0001."FSTREL", T0001
."LSTUSER", T0001."LSTTSTAMP", T0001."LSTREL", T0001."CHTAB", T0001."CHFIELD", T0001."STATUS", T0003."LANGU", T0003."ADDON", T0003."QTEXT", T0002."PROB", T0002."PRIO", T0002."USAG", T0002."AGENDA", T0
002."SUBJAREA", T0002."SUBJECT", T0002."MEMO" FROM "SQADB01" T0001, "SQADB01REV" T0002, "SQADB01T" T0003 WHERE T0001."QUEID" = T0002."QUEID" AND T0001."QUEID" = T0003."QUEID" ;

at SQL prompt & share the results.

[Brindavan_M]

Hi ,

This  privilege issue in database,could you try the below queries and let me the error.

kindly check this..

1) SELECT * FROM all_objects WHERE object_type IN ('TABLE','VIEW')

AND object_name = 'OBJECT_NAME';

If the error occurred then it dont have access to the table or view. You have to give grant permission

2) SELECT *FROM "objectname";  -> find the owned schema of this table

SELECT owner

FROM all_objects

WHERE object_type IN ('TABLE','VIEW')

AND object_name = 'table';

Give the grand permission for the table and owned the schema.

1) GRANT privileges ON SAPSR3.SEOFRIENDS TO SAPSR3SHD;

2) GRANT SELECT, INSERT, UPDATE, DELETE ON SAPSR3.SEOFRIENDS TO SAPSR3SHD;

3) GRANT EXECUTE ON SAPSR3.SEOFRIENDS TO SAPSR3SHD;

If you got error while executing  the queries paste the error

Thanks,

BM

[Former Member]

Hi ,

I have given the above permissions ran earlier due to this the error got changed and now it is view creation i am getting.

1. more R3LDCALLRUN.ELG

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

ANALYSIS OF LOG FILE '/ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.LOG'

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

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

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

ANALYSIS OF LOG FILE '/ehpupg/SUM/abap/shdviews/SHDVIEWS_00002_IMP.LOG'

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

ERROR: Found pattern "R3load: job completed" 0 times, but expected 1!

Analyze the log file for further error messages or program abort.

2. log file SHDVIEWS_00001_IMP.LOG

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=43646976)

(DB) ERROR: DDL statement failed

(CREATE VIEW "SQADBREV_V" ( "QUEID" , "ANSWERTYPE" , "ANSGLOBAL" , "FSTUSER" , "FSTTSTAMP" , "FSTREL" , "LSTUSER" , "LSTTSTAMP" , "LSTREL" , "CHTAB" , "CHFIELD" , "STATUS" , "LANGU" , "ADDON" , "QTEX

T" , "PROB" , "PRIO" , "USAG" , "AGENDA" , "SUBJAREA" , "SUBJECT" , "MEMO"  ) AS SELECT T0001."QUEID", T0001."ANSWERTYPE", T0001."ANSGLOBAL", T0001."FSTUSER", T0001."FSTTSTAMP",  T0001."FSTREL", T0001

."LSTUSER", T0001."LSTTSTAMP", T0001."LSTREL", T0001."CHTAB", T0001."CHFIELD", T0001."STATUS", T0003."LANGU", T0003."ADDON", T0003."QTEXT", T0002."PROB", T0002."PRIO", T0002."USAG", T0002."AGENDA", T0

002."SUBJAREA", T0002."SUBJECT", T0002."MEMO" FROM "SQADB01" T0001, "SQADB01REV" T0002, "SQADB01T" T0003 WHERE T0001."QUEID" = T0002."QUEID" AND T0001."QUEID" = T0003."QUEID")

DbSlExecute: rc = 99

  (SQL error 1031)

  error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

R3load: job finished with 183 error(s)

Both the log files getting the above same error as ORA-00942

Kindly give your valuable suggestion.

Thanks,

Pradeep.

[Former Member]

Hi ,

Anyone faced this error ,

more SHDVIEWS_RUN.LOG

#!--------------------------------------------------------------

#!---- MASKING file "SHDVIEWS_00001_IMP.LOG" from "/ehpupg/SUM/abap/shdviews"

#!---- TIME: 20150313150144  PHASE: MAIN_SHDINST/SUBMOD_SHDALIASCRE/EU_CLONE_CRE_SHDVIEWS

#!--------------------------------------------------------------

R3load: START OF LOG: 20150313141412

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Feb  7 2015 01:56:04

R3load -i /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.CMD -dbcodepage 4102 -l /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.LOG

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.210) SUM DMO with Unicode Conversion: Minimum Kernel Patchlevel (note 2108396)

DBSL patchinfo (patches.h): (0.211) Undefined values instead of NULL in STRING (LOB) (note 2108597)

--------------------- End of patch information -------------------------

process id 17442

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(RDI) INFO: /ehpupg/SUM/abap/shdviews/SHDVIEWS_00001_IMP.STR has format version 2

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(DB) ERROR: DDL statement failed

(DROP VIEW "/BEV3/CHTADIRTV")

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1031 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=36831232).

I guess (SQL) INFO: SQLFiles.LST not found due to this create view command is getting failed , my query is how to generate this file in upgrade.

Updated R3load , R3ldctl , DBSL patches in current and upgrade exe locations still no luck.

Thanks

Pradeep.

[Brindavan_M]

Hi ,

The below two error issue releated to database permission issue. which need to fix to continue your upgrade. Check once complete check there must be some group persmission missed up.

1)ORA-01031

2) ORA-00942

Thanks ,

BM

[Former Member]

Hi ,

My query is why SQLFiles.LST file is not found error coming.

Then i have updated SAP scheme for current and shadow schema with dba , sysdba , group .

Now it should be running but still it is failing .

Thanks,

Pradeep.

[former_member182657]

If possible please share SQLEXEGR.LOG file for analysis.

Thanks,

[Former Member]

Hi Gaurav,

SQLEXEGR.LOG

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

ERRORS and RETURN CODE in PTALGR02.LOG

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

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCLASSTX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCOMPOEX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

PTALGR02.LOG:-

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

4 ETQ399 Rollback.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

This 2 are the errors i skipped as warnings.

Never recommended to accept/skip any error without performing recommended resolutions or steps.Skipping of issues might be the reason here for the failure of phase here.

[Former Member]

Hi Gaurav,

You are right there is some issues with SSFS , but i have already skipped  2 error's as warnings, which shouldn't  have much impact on the upgrade.

My question is during DBCLONE phase it should have copied all the tables from original schema to new upgrade schema.

But there happened some inconsistency here. that is the reason seofriends table not there in shadow schema, even DBCLONE phase was successful then why this happended.

So what would be the ideal scenario to proceed  with the upgrade  from here,

A. Shadow updatestatics wont be an issue , it will slow down the system , but not sure how many tables not copied .... so do i need to reset the upgrade from the begining?

B.If i copy this particular table from original schema to shadow schema , what should i copy , is it structure alone or with data i need to copy. and proceed?

Kindly suggest.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

As you've already skipped two error warnings during the upgrade,and most probably causing the issue here.

Shadow updatestatics wont be an issue , it will slow down the system , but not sure how many tables not copied .... so do i need to reset the upgrade from the begining?

Could you execute report UPGSHDCLONDBSTATSFIX by selection of check & fix & share the results by re-execution of phase.

Also i'll suggest you to raise SAP OSS or reset the upgrade if still issue persists ( As skipping of errors during the upgrade will cause you issues in further steps as well ).

Regards,

[Former Member]

Hi Gaurav,

Do i need to run this report UPGSHDCLONDBSTATSFIX in shadow instance , please suggest as shadow instance is not yet created..

Where should i run this report.

Thanks,

Pradeep.

[former_member182657]

Hi Pradeep,

Apologies,yes this script is executed at shadow,but you're already facing issue at

CURRENTPHASE MAIN_SHDINST/SUBMOD_SHDALIASCRE/EU_CLONE_CRE_SHDVIEWS

If possible please share log SQLEXEGR.LOG & raise SAP OSS or best would be to reset the upgrade & try again.

Regards,

[Former Member]

Hi Gaurav,

SQLEXEGR.LOG:-

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

ERRORS and RETURN CODE in PTALGR02.LOG

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

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCLASSTX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCOMPOEX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

PTALGR02.LOG

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

4 ETQ399 Rollback.

4 EPU202XEND OF SECTION BEING ANALYZED END OF SCEXEC_GRANT =================================================

PF the logs message.

Thanks,

Pradeep.

[former_member182034]

hi Pradeep,

Please follow the instruction of this note to resolve above issue.

1957148 - rc = 103, table "QCMXXX" SQL error 942 during the export

1909263 - table or view does not exist during abap export

Regards,

[former_member182657]

I also suggest you to recheck with SSFS connection method for successful database connection.Additionally please share the snap shot of upgrade phase where facing issue with relevant log files as well.

Regards,

[Former Member]

Hi Gaurav,

Currently upgrade is in pre-processing phase.

1.UPDATE_DBSTATS_SHDCLONE

CURRENTPHASE MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE

...started at 20150305152014

# Using phase log file 'UPST_SHDCLONE.LOG'.

..finished at 20150305153044 with status ABORTED.

# Error message set: 'Non single errors (code > 😎 found in logfile 'UPST_SHDCLONE.ELG'

1 error during parallel execution of processes, check 'UPST_SHDCLONE.ELG' for details

2 processes failed, check 'SQLSTMTSTD.*' for details'

...begin dialog at 20150305153048

...end dialog at 20150305163458

..answered at 20150305163458.

-> decided to ignore the warnings.

...change status at 20150305163458 for MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE to IGNORED

1st error accepted as warning for updatestats for shadow table, it's error log

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

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE02.LOG

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

4 ETQ010 Date & Time: 20150305152823

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPISU"', TABNAME =>

3 ETQ398XSQL:  '"SEOFRIENDS~"' ); END;

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

4 ETQ010 Date & Time: 20150305152823

1EETQ008 Error message: DBSL error 99 (db code 20000):

ORA-20000: Unable to analyze TABLE "SAPISU"."SEOFRIENDS~", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 23891

ORA-06512: at "SYS.DBMS_STATS", line 23953

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

2. MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT

CURRENTPHASE MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT

...started at 20150305164518

..finished at 20150305164611 with status ABORTED.

# Error message set: 'Non single errors (code > 😎 found in logfile 'SQLEXEGR.LOG'

1 error during parallel execution of processes, check 'SQLEXEGR.LOG' for details

2 processes failed, check 'SCEXEC_G.*' for details'

# WARNING: Unknown macro 'SCRIPT_PREFIX' found!

...begin dialog at 20150305164615

...end dialog at 20150305165125

..answered at 20150305165125.

-> decided to ignore the warnings.

...change status at 20150305165125 for MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT to IGNORED

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

ERRORS and RETURN CODE in PTALGR02.LOG

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

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCLASSTX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCOMPOEX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

In this table SEOFRIENDS is not existing in the schema of shadow instance.

This 2 are the errors i skipped as warnings.

3. Current error

CURRENTPHASE MAIN_SHDINST/SUBMOD_SHDALIASCRE/EU_CLONE_CRE_SHDVIEWS

...started at 20150305183344

# Using phase log file 'EUCLONECRSHDVIEW.LOG'.

..finished at 20150305183347 with status ABORTED.

# Error message set: 'Process /ehpupg/SUM/abap/exe/R3ldctl exited with 2, see '/ehpupg/SUM/abap/log/R3LDCALLPRP.LOG' for details'

...begin dialog at 20150305183350

...end dialog at 20150305183554

..answered at 20150305183554.

-> decided to try again.

error log,

DbSl Trace: Error 1031 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=1310720)

ERROR: Select for get_version failed

SAPup> Process with PID 18737 terminated with status 2 at 20150311161741!

While i am checking seofriends table in shadow schema i am not able to see it.

Thanks,

Pradeep.

[Former Member]

Hi Pradeep,

As suggested by Gaurav, Have you re-verified your ssfs. also can you try to set the below parameter,

Profile parameter : rsdb/ssfs_connect = 0

Environment variable:  rsdb_ssfs_connect  0

And give a retry and let us know if this worked. I had similar issue and during which i tries this and which passed the phase.

Let us know the updates.

Regards,

Ram

[former_member182657]

Hi Ram.

Profile parameter : rsdb/ssfs_connect = 0

Environment variable:  rsdb_ssfs_connect  0

For SSFS database connection above parameters should have value to be set with 1 not with 0 .I think you typed this by mistake.

Regards,

[former_member182657]

You need to follow SAP Notes  400241 - Problems with ops$ or sapr3 connect to Oracle

&  1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Regards,

[Former Member]

Hi Gaurav,

Getting the same error again.

Thanks,

Pradeep.

[Former Member]

Hi Gaurav,

While checking this table in SAP shadow schema  owner i am not able to find this table SEOFRIENDS.  Even i have accepted 2 error's as warnings in upgrade , due to this

i am getting below error

DbSl Trace: Error 1031 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=1310720)

ERROR: Select for get_version failed

SAPup> Process with PID 16548 terminated with status 2 at 20150311153810!

Is there any way to sort out this.

Regards,

Pradeep

[former_member182657]

Hi Pradeep,

Even i have accepted 2 error's as warnings in upgrade

Would you share which error warnings you ignored/accepted ?

Also are you still getting

ORA-20000: Unable to analyze TABLE "SAPSR3"."SEOFRIENDS~", insufficient privileges or does not exist

Thanks,

[Former Member]

Hi Gaurav,

Below are the 2 error's as warnings,

1.UPDATE_DBSTATS_SHDCLONE

CURRENTPHASE MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE

...started at 20150305152014

# Using phase log file 'UPST_SHDCLONE.LOG'.

..finished at 20150305153044 with status ABORTED.

# Error message set: 'Non single errors (code > 😎 found in logfile 'UPST_SHDCLONE.ELG'

1 error during parallel execution of processes, check 'UPST_SHDCLONE.ELG' for details

2 processes failed, check 'SQLSTMTSTD.*' for details'

...begin dialog at 20150305153048

...end dialog at 20150305163458

..answered at 20150305163458.

-> decided to ignore the warnings.

...change status at 20150305163458 for MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE to IGNORED

1st error accepted as warning for updatestats for shadow table, it's error log

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

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE02.LOG

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

4 ETQ010 Date & Time: 20150305152823

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPISU"', TABNAME =>

3 ETQ398XSQL:  '"SEOFRIENDS~"' ); END;

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

4 ETQ010 Date & Time: 20150305152823

1EETQ008 Error message: DBSL error 99 (db code 20000):

ORA-20000: Unable to analyze TABLE "SAPISU"."SEOFRIENDS~", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 23891

ORA-06512: at "SYS.DBMS_STATS", line 23953

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

2. MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT

CURRENTPHASE MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT

...started at 20150305164518

..finished at 20150305164611 with status ABORTED.

# Error message set: 'Non single errors (code > 😎 found in logfile 'SQLEXEGR.LOG'

1 error during parallel execution of processes, check 'SQLEXEGR.LOG' for details

2 processes failed, check 'SCEXEC_G.*' for details'

# WARNING: Unknown macro 'SCRIPT_PREFIX' found!

...begin dialog at 20150305164615

...end dialog at 20150305165125

..answered at 20150305165125.

-> decided to ignore the warnings.

...change status at 20150305165125 for MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_GRANT to IGNORED

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

ERRORS and RETURN CODE in PTALGR02.LOG

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

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCLASSTX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOCOMPOEX~" TO SAPSR3SHD

3 ETQ398 SQL: GRANT ALL ON          SAPSR3."SEOFRIENDS~" TO SAPSR3SHD

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

4 ETQ010 Date & Time: 20150305164551

1EETQ008 Error message: DBSL error 103 (db code 942):

ORA-00942: table or view does not exist

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

In this table SEOFRIENDS is not existing in the schema of shadow instance.

This 2 are the errors i skipped as warnings.

3. Current error

CURRENTPHASE MAIN_SHDINST/SUBMOD_SHDALIASCRE/EU_CLONE_CRE_SHDVIEWS

...started at 20150305183344

# Using phase log file 'EUCLONECRSHDVIEW.LOG'.

..finished at 20150305183347 with status ABORTED.

# Error message set: 'Process /ehpupg/SUM/abap/exe/R3ldctl exited with 2, see '/ehpupg/SUM/abap/log/R3LDCALLPRP.LOG' for details'

...begin dialog at 20150305183350

...end dialog at 20150305183554

..answered at 20150305183554.

-> decided to try again.

error log,

DbSl Trace: Error 1031 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=1310720)

ERROR: Select for get_version failed

SAPup> Process with PID 18737 terminated with status 2 at 20150311161741!

While i am checking seofriends table in shadow schema i am not able to see it.

Thanks,

Pradeep.

[Brindavan_M]

Hi Pradeep,

I believe this is user privilege error in database level.

This error may occur if the user was granted the necessary privilege at a higher label than the current login.

1)check database whether able to login " sys /as sysdba  and  their DBA user like system,sys..ect  and their password expiration

2)check this parameter REMOTE_LOGON_PASSWORDFILE=EXCLUSIVE, and to allow the granting of SYSDBA and SYSOPER privileges to users.

3)check the environment variable for SID

export ORACLE_SID= SID

Thanks,

BM

[Former Member]

Hi Team,

Assigned all the roles and everything from sysdba and sys , still persisting the issue.

Thanks everyone for your valuable comments.

Thanks,

Pradeep.

[former_member182657]

Hi,

Please follow previous suggested note  2073326 - ORA-20000: Unable to analyze TABLE "sapsr3"."/BIC/A1234567B", insufficient privileges or d...

& re-share the results again .

Hope your issue will get resolved.

Good luck !!

[Former Member]

Hi Gaurav,

Sorry  i am getting the below error ,

EXECUTING /ehpupg/SUM/abap/exe/R3ldctl -p /ehpupg/SUM/abap/shdviews -i /ehpupg/SUM/abap/shdviews/DUMMY.LST -o /ehpupg/SUM/abap/shdviews/DUMMY.OUT

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

(IDL) Info:  ddldb2lib version is 741.37

(CLL) Info:  creating initial tpl data

DbSl Trace: Error 1031 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01031 occurred at SQL stmt (parse error offset=1310720)

ERROR: Select for get_version failed

SAPup> Process with PID 16548 terminated with status 2 at 20150311153810!

Thanks

Pradeep.

[former_member182657]

Hi Pradeep,

Is your previous issue has been resolved ? Please confirm .If resolved kindly close the thread & open a new discussion with new issue.

Regards,

Gaurav

[former_member182657]

So SEOFRIENDS table is not copied DBCLONE phase properly to shadow schema. In this case if i need to copy manually this table to shadow schema do i need to copy data as well as or structure.

No need to do manual interventions until & unless recommended by any SAP Note or from the support,this leads to severe errors into the system as well.( Always need to follow recommended resolutions first as generally provided under notes ) .

Hope you'll also agree here .

Thanks,

[Former Member]

Logs for 2 option :-

CURRENTPHASE MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE

...started at 20150305152014

# Using phase log file 'UPST_SHDCLONE.LOG'.

..finished at 20150305153044 with status ABORTED.

# Error message set: 'Non single errors (code > 😎 found in logfile 'UPST_SHDCLONE.ELG'

1 error during parallel execution of processes, check 'UPST_SHDCLONE.ELG' for details

2 processes failed, check 'SQLSTMTSTD.*' for details'

...begin dialog at 20150305153048

...end dialog at 20150305163458

..answered at 20150305163458.

-> decided to ignore the warnings.

...change status at 20150305163458 for MAIN_SHDCRE/SUBMOD_SHDDBCLONE/UPDATE_DBSTATS_SHDCLONE to IGNORED

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE02.LOG

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

4 ETQ010 Date & Time: 20150305152823

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL:  '"SEOFRIENDS~"' ); END;

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

4 ETQ010 Date & Time: 20150305152823

1EETQ008 Error message: DBSL error 99 (db code 20000):

ORA-20000: Unable to analyze TABLE "SAPSR3"."SEOFRIENDS~", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 23891

ORA-06512: at "SYS.DBMS_STATS", line 23953

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

wht should i do in this case....

[former_member182657]

Hi,

ORA-20000: Unable to analyze TABLE "SAPSR3"."SEOFRIENDS~", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 23891
ORA-06512: at "SYS.DBMS_STATS", line 23953

Are you using SSFS database connection methods during the process,If yes then follow resolution from SAP Note   2073326 - ORA-20000: Unable to analyze TABLE "sapsr3"."/BIC/A1234567B", insufficient privileges or ...

& try to restart the system to check again.

Additionally required complete UPST_SHDCLONE.LOG

decided to ignore the warnings.

Regards,

[Former Member]

Hi Gaurav,

Yes I am using SSFS mehtod for connection

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

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE02.LOG

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

4 ETQ010 Date & Time: 20150305152823

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPISU"', TABNAME =>

3 ETQ398XSQL:  '"SEOFRIENDS~"' ); END;

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

4 ETQ010 Date & Time: 20150305152823

1EETQ008 Error message: DBSL error 99 (db code 20000):

ORA-20000: Unable to analyze TABLE "SAPISU"."SEOFRIENDS~", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 23891

ORA-06512: at "SYS.DBMS_STATS", line 23953

ORA-06512: at line 1

1EETQ003 exit code: "12"

<NO EXIT CODE FOUND - PROGRAM ABORTED?>

Thanks ,

Pradeep.

[former_member182657]

Hi Pradeep,

Could you share the log file where you're getting the issue ?

Regards,