on 05-23-2015 5:50 AM
Hi SCN Team,
We are currently performing the SPS08 upgrade for our DEV ECC6 system when we encountered issue in EU_CLONE_CRE_SHDVIEWS Preprocessing phase of SUM.
Based from the logs, we found numerous "cannot use duplicate view name" errors.
Follow below some observations that I consider important:
1) In DROPVIEWS.LOG I can see the SQL commands including the shadow schema id SAPSR1SHD:
3 ETQ398 SQL: DROP VIEW SAPSR1SHD."/IWFND/V_MED_NAE"
2) In SHDVIEWS_00003_IMP.LOG I can’t see reference to shadow schema id:
(CREATE VIEW "V_WIORGTSK" ( "CLIENT" , "WI_ID" , "ORG_OBJ" , "TASK" , "BEGDA" , "ENDDA" ) AS SELECT T0001."CLIENT", T0001."WI_ID", T0002."ORG_OBJ", T0001."WI_RH_TASK",
T0001."WI_CD", T0001."WI_AED" FROM "SWWWIHEAD" T0001,"SWWORGTASK" T0002 WHERE T0001."CLIENT" = T0002."CLIENT" AND T0001."WI_ID" = T0002."WI_ID")
3) At this moment we have any tables in schema SAPSR1SHD:
select count(*) from m_tables where schema_name = 'SAPSR1SHD'
COUNT(*)
0
3) I could see that all tables created by job "DBCLONE1", "DBCLONE2" and "DBCLONE3", were created in schema SAPSR1
Ex. CREATE COLUMN TABLE "/IWBEP/C_MGWUMDC~" ("CLIENT" NVARCHAR (000003) DEFAULT '000
Follow attachments for more details.
Thank you very much,
Edson Alvarenga
Thanks Gaurav for the responses.
I have opened a ticket at SAP, but so far they have not helped me.
The current situation is:
Using the version 111 of lib_dbsl i got the error below in ../shdviews/SHDVIEWS_00001_IMP.LOG:
cannot use duplicate view name: xxxxxxxxx : line 1 col 13 (at pos 12)
Using the version 114 of lib_dbsl I got the error below in R3LDCALLPRP.LOG:
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
Thanks,
Edson Alvarenga
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please follow SAP KBA 1897303 - Errors in phase 'EU_CLONE_CRE_SHDVIEWS'
& patch the dbsl library with the latest available at SMP.
DbSlExecute: rc = 102
(SQL error 322)
error message returned by DbSl:
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks everyone for the responses. I'm Edson's backup for now.
I updated tp and R3trans with the latest patches (from PL38 to PL116). Replaced it in /SUM/abap/exe and kernel directory. I tried to repeat phase EU_CLONE_CRE_SHDVIEWS but arrived with the same error (cannot use duplicate view name: xxxxxxx: line 1 col 13 (at pos 12)).
Then I followed sap note 1897303. R3load is already at PL111 so I only updated dbsl to PL114 in /SUM/abap/exe. When I retriggered the phase, I received a new error with regards to R3ldctl.
EXECUTING /mediaarchive/SUM_DEV/abap/exe/R3ldctl -p /mediaarchive/SUM_DEV/abap/shdviews -i /mediaarchive/SUM_DEV/abap/shdviews/DUMMY.LST -o /mediaarchive/SUM
_DEV/abap/shdviews/DUMMY.OUT
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
ERROR: DbSlConnect rc= 99
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
do_db_connect(): connection to the database failed
SAPup> Process with PID 4599 terminated with status 2 at 20150523032931!
SAPup> Starting subprocess with PID 4618 in phase 'EU_CLONE_CRE_SHDVIEWS' at 20150523032952
ENV: DIR_LIBRARY=/mediaarchive/SUM_DEV/abap/exe
ENV: LD_LIBRARY_PATH=/mediaarchive/SUM_DEV/abap/exe:/mediaarchive/SUM_DEV/jvm/jre/lib/amd64/server:/mediaarchive/SUM_DEV/jvm/jre/lib/amd64:/mediaarchive/
SUM_DEV/jvm/jre/../lib/amd64:/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/usr/sap/DEV/SYS/exe/uc/linuxx86_64/hdbclient
ENV: PATH=/mediaarchive/SUM_DEV/abap/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/usr/sap/DEV/SYS/exe/run:
/home/devadm:.:/usr/sap/DEV/SYS/exe/uc/linuxx86_64/hdbclient
ENV: SAPSYSTEMNAME=DEV
ENV: auth_shadow_upgrade=1
ENV: dbms_type=HDB
ENV: dbs_hdb_schema=SAPSR1
ENV: dbs_hdb_userkey=UPGSHDKEY
PWD: /mediaarchive/SUM_DEV/abap/tmp
EXECUTING /mediaarchive/SUM_DEV/abap/exe/R3ldctl -p /mediaarchive/SUM_DEV/abap/shdviews -i /mediaarchive/SUM_DEV/abap/shdviews/DUMMY.LST -o /mediaarchive/SUM
_DEV/abap/shdviews/DUMMY.OUT
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
ERROR: DbSlConnect rc= 99
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
do_db_connect(): connection to the database failed
SAPup> Process with PID 4618 terminated with status 2 at 20150523032952!
Hi Krisel,
DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709
do_db_connect(): connection to the database failed
Could you check with SAP KBA 1828028 - DBCON connection to remote HANA database cannot be established & 1597627 - SAP HANA connection
As you've already on latest PL for R3trans & tp,could you share PL for R3ldctl if it's on low than patch this too.
Regards,
Please confirm the SUM version with which you're performing the upgrade,if using SUM 1.0 SP13 than you could also refer SAP Note 1813548 - Database Migration Option (DMO) of SUM 1.0 up to SP13 .
Note suggests for
-----------------< D056915 13/FEB/2015 >------------------------------
TPL error in phase EU_CLONE_CRE_SHDVIEWS
You encounter an error in phase phase EU_CLONE_CRE_SHDVIEWS, which is decribed in log file SHDVIEWS_PRP<number>_IMP.LOG as follows:
(TPL) ERROR: unknown template variable "crestm"
To solve this error, replace the kernel tool R3ldctl (located in directory <SUM_DIR>/abap/exe ) with a new version with minimum patchlevel 29 or higher. Afterwards repeat the phase EU_CLONE_CRE_SHDVIEWS.
As the version of R3ldctl is already the latest one,could you try the process once again .
Good luck !!
Thanks i found the required as you've already attached.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
2EETQ109 Found 3 errors in logs.
2EETQ106 3 processes failed.
Could you share SHDVIEWS_00001_IMP.LOG for analysis.Mean while try to restart the system & re-execute the process.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Edson
1. Could you check the same version and release of TP , R3trans, R3load, R3dctl,R3ta, R3szchk and DBSL ?
2. If possible upgrade the latest kernel and then retry the same phase.
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.