Error during upgrade in phase MAIN_SHDINST/RUN_RSVWSCPY

[Former Member]

We are upgrading our solution manager 7.1 to SP 10(ST:10 Basis 13). Stuck with the below two errors in phase MAIN_SHDINST/RUN_RSVWSCPY

Any clues here experts.. ?

------------------

cat RSVWSCPY.ELG

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

Clone shadow views ERRORS and RETURN CODE in RSVWSCPY.SX1

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

3 ETGCLN create view "V_ADCP_SO" (  "CLIENT", "PERSNUMBER", "DATE_FROM", "NATION", "COMP_PERS", "SO_KEY", "ADDRNUMBER", "NAME_TEXT" ) as SELECT T1."CLIENT", T1."PERSNUMBER", T1."DATE_FROM", T1."NATION", T2."COMP_PERS", T2."SO_KEY", T2."ADDRNUMBER", T1."NAME_TEXT" FROM "ADRP" T1, "ADCP" T2, "ADRC" T3 WHERE T1."NATION" = T2."NATION" AND T1."CLIENT" = T2."CLIENT" AND T1."PERSNUMBER" = T2."PERSNUMBER" AND T3."NATION" = T2."NATION" AND T3."CLIENT" = T2."CLIENT" AND T3."ADDRNUMBER" = T2."ADDRNUMBER"

3 ETGCLN CREATING VIEW V_ADCP_USR

3 ETGCLN create view "V_ADCP_USR" (  "CLIENT", "PERSNUMBER", "DATE_FROM", "NATION", "MC_NAMEFIR", "MC_NAMELAS", "SO_KEY", "MC_NAME1", "ADDRNUMBER", "DATE_ADRC", "DATE_ADCP", "PERS_GROUP", "NAME_FIRST", "NAME_LAST", "NAME_TEXT" ) as SELECT T1."CLIENT", T1."PERSNUMBER", T1."DATE_FROM", T1."NATION", T1."MC_NAMEFIR", T1."MC_NAMELAS", T2."SO_KEY", T3."MC_NAME1", T2."ADDRNUMBER", T2."DATE_FROM", T3."DATE_FROM", T1."PERS_GROUP", T1."NAME_FIRST", T1."NAME_LAST", T1."NAME_TEXT" FROM "ADRP" T1, "ADCP" T2, "ADRC" T3 WHERE T1."NATION" = T2."NATION" AND T1."CLIENT" = T2."CLIENT" AND T1."PERSNUMBER" = T2."PERSNUMBER" AND T3."CLIENT" = T2."CLIENT" AND T3."ADDRNUMBER" = T2."ADDRNUMBER" AND T3."NATION" = T2."NATION" AND T1."PERS_GROUP" = 'BC01' AND T2."COMP_PERS" = 'C'

3 ETGCLN CREATING VIEW V_ADDR_USR

3 ETGCLN create view "V_ADDR_USR" (  "CLIENT", "ADDRNUMBER", "PERSNUMBER", "DATE_FROM", "NATION", "DATE_FR_C", "NATION_C", "DATE_FR_P", "NATION_P", "DATE_TO", "SO_KEY", "DEPARTMENT", "FUNCTION", "BUILDING_C", "FLOOR_C", "ROOMNUM_C", "ID_CODE", "IH_MAIL", "SORT1_C", "SORT2_C", "SORT_PHN_C", "DEFLT_COMM", "TEL_NUMBER", "TEL_EXTENS", "FAX_NUMBER", "FAX_EXTENS", "TITLE_P", "NAME_FIRST", "NAME_LAST", "NAME2_P", "NAMEMIDDLE", "NAME_LAST2", "NAME_TEXT", "CONVERTED", "TITLE_ACA1", "TITLE_ACA2", "PREFIX1", "PREFIX2", "TITLE_SPPL", "NICKNAME", "INITIALS", "NAMEFORMAT", "NAMCOUNTRY", "PROFESSION", "SEX", "LANGU_P", "PERS_GROUP", "SORT1_P", "SORT2_P", "SORT_PHN_P", "ADDR_COMP", "PERSORIGIN", "LANGU_CR_P", "TITLE", "NAME1", "NAME2", "NAME3", "NAME4", "NAME_TXT", "NAME_CO", "CITY1", "CITY2", "CITY_CODE", "CITYP_CODE", "HOME_CITY", "CITYH_CODE", "CHCKSTATUS", "REGIOGROUP", "POST_CODE1", "POST_CODE2", "POST_CODE3", "PCODE1_EXT", "PCODE2_EXT", "PCODE3_EXT", "PO_BOX", "PO_BOX_NUM", "PO_BOX_LOC", "CITY_CODE2", "PO_BOX_REG", "PO_BOX_CTY", "POSTALAREA", "TRANSPZONE", "STREET", "STREETCODE", "STREETABBR", "HOUSE_NUM1", "HOUSE_NUM2", "HOUSE_NUM3", "STR_SUPPL1", "STR_SUPPL2", "STR_SUPPL3", "LOCATION", "BUILDING", "FLOOR", "ROOMNUMBER", "COUNTRY", "LANGU", "REGION", "ADDR_GROUP", "SORT1", "SORT2", "SORT_PHN", "TEL_NUMCMP", "TEL_EXTCMP", "FAX_NUMCMP", "FAX_EXTCMP", "ADDRORIGIN", "EXTENSION1", "EXTENSION2", "TIME_ZONE", "TAXJURCODE", "ADDRESS_ID", "LANGU_CREA" ) as SELECT T2."CLIENT", T2."ADDRNUMBER", T2."PERSNUMBER", T2."DATE_FROM", T2."NATION", T3."DATE_FROM", T3."NATION", T1."DATE_FROM", T1."NATION", T2."DATE_TO", T2."SO_KEY", T2."DEPARTMENT", T2."FUNCTION", T2."BUILDING", T2."FLOOR", T2."ROOMNUMBER", T2."ID_CODE", T2."IH_MAIL", T2."SORT1", T2."SORT2", T2."SORT_PHN", T2."DEFLT_COMM", T2."TEL_NUMBER", T2."TEL_EXTENS", T2."FAX_NUMBER", T2."FAX_EXTENS", T1."TITLE", T1."NAME_FIRST", T1."NAME_LAST", T1."NAME2", T1."NAMEMIDDLE", T1."NAME_LAST2", T1."NAME_TEXT", T1."CONVERTED", T1."TITLE_ACA1", T1."TITLE_ACA2", T1."PREFIX1", T1."PREFIX2", T1."3 ETGCLN create view "V_ADCP_SO" (  "CLIENT", "PERSNUMBER", "DATE_FROM", "NATION", "COMP_PERS", "SO_KEY", "ADDRNUMBER", "NAME_TEXT" ) as SELECT T1."CLIENT", T1."PERSNUMBER", T1."DATE_FROM", T1."NATION", T2."COMP_PERS", T2."SO_KEY", T2."ADDRNUMBER", T1."NAME_TEXT" FROM "ADRP" T1, "ADCP" T2, "ADRC" T3 WHERE T1."NATION" = T2."NATION" AND T1."CLIENT" = T2."CLIENT" AND T1."PERSNUMBER" = T2."PERSNUMBER" AND T3."NATION" = T2."NATION" AND T3."CLIENT" = T2."CLIENT" AND T3."ADDRNUMBER" = T2."ADDRNUMBER"

1EETGCLN con=1(SX1): ORA-01740: missing double quote in identifier

1EETGCLN Creation of view V_ADDR_USR failed

3 ETGCLN create view "V_SOUCADCP" (  "MANDT", "SAPNAM", "USRTP", "USRYR", "USRNO", "ADDRNUMBER", "PERSNUMBER", "DATE_FROM", "NATION", "USRNAM", "DELETED", "NAME_TEXT" ) as SELECT T1."MANDT", T1."SAPNAM", T2."USRTP", T2."USRYR", T2."USRNO", T3."ADDRNUMBER", T3."PERSNUMBER", T3."DATE_FROM", T3."NATION", T1."USRNAM", T1."DELETED", T4."NAME_TEXT" FROM "SOUC" T1, "SOUD" T2, "ADCP" T3, "ADRP" T4 WHERE T1."MANDT" = T2."MANDT" AND T1."SAPNAM" = T2."SAPNAM" AND T1."USRTP" = T2."USRTP" AND T1."USRYR" = T2."USRYR" AND T1."USRNO" = T2."USRNO" AND T2."MANDT" = T3."CLIENT" AND T2."USRADR" = T3."SO_KEY" AND T3."CLIENT" = T4."CLIENT" AND T3."PERSNUMBER" = T4."PERSNUMBER" AND T3."DATE_FROM" = T4."DATE_FROM" AND T3."NATION" = T4."NATION"

3 ETGCLN CREATING VIEW V_SOUCADRP

3 ETGCLN create view "V_SOUCADRP" (  "MANDT", "SAPNAM", "USRTP", "USRYR", "USRNO", "USRNAM", "DELETED", "ADRNAME" ) as SELECT T1."MANDT", T1."SAPNAM", T1."USRTP", T1."USRYR", T1."USRNO", T1."USRNAM", T1."DELETED", T3."NAME1" FROM "SOUC" T1, "SOUD" T2, "SADRP" T3 WHERE T2."MANDT" = T1."MANDT" AND T2."USRTP" = T1."USRTP" AND T2."USRYR" = T1."USRYR" AND T2."USRNO" = T1."USRNO" AND T3."MANDT" = T2."MANDT" AND T3."ADRNR" = T2."USRADR" AND T3."NATIO" = T2."NATIO"

3 ETGCLN CREATING VIEW V_SOUDADCP

3 ETGCLN create view "V_SOUDADCP" (  "MANDT", "USRTP", "USRYR", "USRNO", "CLIENT", "ADDRNUMBER", "PERSNUMBER", "DATE_FROM", "NATION", "CROTP", "CROYR", "CRONO", "CRONAM", "CRDAT", "CRTIM", "CHOTP", "CHOYR", "CHONO", "CHONAM", "CHDAT", "CHTIM", "SAPNAM", "USRNAM", "LOADAT", "EXMAX", "RCMAX", "INMAX", "USRAU", "CRGDL", "CRFCL", "CRFCC", "CRFPL", "CRFDP", "CRFAD", "CRFGR", "HOMAX", "HOCNT", "GLMAX", "GFMAX", "GFCNT", "AUTEXT", "NOTTP", "CALEN", "OUTFL", "SQWIN", "SYUSR", "SYUSRINB", "SYUSROUT", "ADREXT", "PRWYR", "PRWNO", "PUWYR", "PUWNO", "INBYR", "INBNO", "OUTYR", "OUTNO", "WSTYR", "WSTNO", "PFRYR", "PFRNO", "PDLYR", "PDLNO", "VORYR", "VORNO", "NOTYR", "NOTNO", "DELETED", "RSWORKDAY", "RSFACID", "USRADR", "LFDNR", "SNDART", "FLAG1", "FLAG2", "FLAG3", "NATIO", "LADAT", "VLADAT", "LASDAT", "EXTTELE", "EXTSMTP", "EXTX400", "EXTSAP", "AREPYR", "AREPNO", "AREPABDAT", "AREPAEDAT", "FAXFORM", "SCRFORM", "DEPARTMENT", "BUILDING", "ROOMNUMBER", "NAME_TEXT", "CHATSEND", "NOARSDEX", "PRPARCHG", "PRPARNDH", "PRPARRCL", "PRPARNOP", "DELFORIB", "GHRAWDOC", "FOLDSORT", "DELTRASH", "RSDOCFOR", "FOLASDYR", "FOLASDNO", "FOLLINYR", "FOLLINNO", "FOLCRDYR", "FOLCRDNO", "LINKDOYR", "LINKDONO", "NORTFEDIT", "PCOLE" ) as SELECT T1."MANDT", T1."USRTP", T1."USRYR", T1."USRNO", T2."CLIENT", T2."ADDRNUMBER", T2."PERSNUMBER", T2."DATE_FROM", T2."NATION", T1."CROTP", T1."CROYR", T1."CRONO", T1."CRONAM", T1."CRDAT", T1."CRTIM", T1."CHOTP", T1."CHOYR", T1."CHONO", T1."CHONAM", T1."CHDAT", T1."CHTIM", T1."SAPNAM", T1."USRNAM", T1."LOADAT", T1."EXMAX", T1."RCMAX", T1."INMAX", T1."USRAU", T1."CRGDL", T1."CRFCL", T1."CRFCC", T1."CRFPL", T1."CRFDP", T1."CRFAD", T1."CRFGR", T1."HOMAX", T1."HOCNT", T1."GLMAX", T1."GFMAX", T1."GFCNT", T1."AUTEXT", T1."NOTTP", T1."CALEN", T1."OUTFL", T1."SQWIN", T1."SYUSR", T1."SYUSRINB", T1."SYUSROUT", T1."ADREXT", T1."PRWYR", T1."PRWNO", T1."PUWYR", T1."PUWNO", T1."INBYR", T1."INBNO", T1."OUTYR", T1."OUTNO", T1."WSTYR", T1."WSTNO", T1."PFRYR", T1."PFRNO", T1."PDLYR", T1."PDLNO", T1."VORYR", T1."VORNO", T1."NOTYR", T1."3 ETGCLN create view "V_SOUCADCP" (  "MANDT", "SAPNAM", "USRTP", "USRYR", "USRNO", "ADDRNUMBER", "PERSNUMBER", "DATE_FROM", "NATION", "USRNAM", "DELETED", "NAME_TEXT" ) as SELECT T1."MANDT", T1."SAPNAM", T2."USRTP", T2."USRYR", T2."USRNO", T3."ADDRNUMBER", T3."PERSNUMBER", T3."DATE_FROM", T3."NATION", T1."USRNAM", T1."DELETED", T4."NAME_TEXT" FROM "SOUC" T1, "SOUD" T2, "ADCP" T3, "ADRP" T4 WHERE T1."MANDT" = T2."MANDT" AND T1."SAPNAM" = T2."SAPNAM" AND T1."USRTP" = T2."USRTP" AND T1."USRYR" = T2."USRYR" AND T1."USRNO" = T2."USRNO" AND T2."MANDT" = T3."CLIENT" AND T2."USRADR" = T3."SO_KEY" AND T3."CLIENT" = T4."CLIENT" AND T3."PERSNUMBER" = T4."PERSNUMBER" AND T3."DATE_FROM" = T4."DATE_FROM" AND T3."NATION" = T4."NATION"

1EETGCLN con=1(SX1): ORA-00936: missing expression

1EETGCLN Creation of view V_SOUDADCP failed

[Former Member]

Praveen,

Do one thing, Check which DBCONE job is failing then execute it manually by SE38->Select that DBCONE Progam with its variant->next screen uncheck EXE option and then execute .

After it Retry Upgrade, It should go.

Regards,

Shivam

[Former Member]

Did reset the upgrade and started from scratch again.. it went through fine without any issues this time 🙂

[Reagan]

Just a quick question :

Did you update the kernel on the main instance or for the shadow instance ?

Regards

RB

[Former Member]

Both

[former_member182657]

Hi,

For

1EETGCLN con=1(SX1): ORA-01740: missing double quote in identifier

kindly follow SAP Note  1839796 - DBSL: ORA-01740: missing double quote in identifier

Try to update system kernel.

After that re execute phase.

Regards,

Gaurav

[Former Member]

We are already above the kernel level suggested in the note

--------------------

kernel release                720

kernel make variant           720_REL

compiled on                   Linux GNU SLES-9 x86_64 cc4.1.2 use-pr140212 for linuxx86_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Mar  8 2014 09:28:13

update level                  0

patch number                  600

[former_member182657]

Hi,

Try to upgrade it up to 7.21EXT. After that share the results again if issue persists.

Regards,

Gaurav

[Former Member]

Upgraded the kernel and restarted the upgrade.. Same error..

kernel release                721

kernel make variant           721_EXT_REL

compiled on                   Linux GNU SLES-11 x86_64 cc4.3.4 use-pr140507 for linuxx86_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  May 24 2014 05:39:00

update level                  0

patch number                  300

source id                     0.300

[former_member182657]

Kindly follow SAP Note 741311.

[Former Member]

Thank you Gaurav...but no luck..

Note suggests to run this report RDDPURI2 and repeat the phase.. did that but with same error..