cancel
Showing results for 
Search instead for 
Did you mean: 

Errors in EU_CLONE_CRE_SHDVIEWS

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

former_member182657
Active Contributor
0 Kudos

Have a look with SCN thread

as you're getting error


DbSl Trace: Connect to database failed, rc=1, rcSQL=-10709

do_db_connect(): connection to the database failed

Hope this will help you.

Thanks,

former_member182657
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

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!

former_member182657
Active Contributor
0 Kudos

Hi Krisel,

Could you share R3LDCALLPRP.LOG for analysis.

Thanks,

Former Member
0 Kudos

Hi Gaurav,

Please see attachments. Thanks!

former_member182657
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

R3ldctl is already at latest PL111. will check on those notes. Thanks!

former_member182657
Active Contributor
0 Kudos

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 !!

Former Member
0 Kudos

Hi Gaurav,

I confirm we're using SUM 1.0 SP13 with the latest R3ldctl but upon repeating phase, the error reoccurs. Thanks!

former_member182657
Active Contributor
0 Kudos

Hi Krisel,

Suggest you to raise support ticket in parallel with SAP. Issue could be related with SUM 1.0 SP13 tool .

Regards,

former_member182657
Active Contributor
0 Kudos

Thanks i found the required as you've already attached.

Regards,

former_member182657
Active Contributor
0 Kudos

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,

Sriram2009
Active Contributor
0 Kudos

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