topic Re: Local client copy cancelled in DevOps and System Administration Forum

Local client copy cancelled

former_member624966 — Mon, 21 Sep 2020 10:54:53 GMT

Hello Experts,

I installed 1709 S/4HANA system and part of the post installation activities is for me to create client 120 after which i did a copy of Customized only source client 000. but after some hours when i execute SCC3 to check the status it will show that client copy cancelled. Attach is the screen shot of the log. I need help please.

Regards

Kanayochukwu

Re: Local client copy cancelled

former_member484887 — Mon, 21 Sep 2020 11:00:14 GMT

Hello,

Could you please share the created dump too?

Re: Local client copy cancelled

cris_hansen — Mon, 21 Sep 2020 11:00:26 GMT

Hello Kanayochukwu,
You can check in ST22 about the dumps.
Check about the mentioned tables that doesn't exist.
Look for SAP Notes that can address the dump + missing table.
Regards,
Cris

Re: Local client copy cancelled

alichtenau — Mon, 21 Sep 2020 11:06:00 GMT

Hi Kanayochukwu,

please check the table in client 000 which was the source. Are table / DDIC consistent according to SAP Note 1248769?

Also, please verify that the latest transport tools (tp + R3trans) have been used.

Cheers,
Andreas

Re: Local client copy cancelled

former_member624966 — Mon, 21 Sep 2020 11:20:50 GMT

Hello Andreas,

Please assist me on step to check the table on client 000 and i don't understand what you mean by whether the DDIC consistent according to SAP note 1248769. Please clarify to enable me resolve this issue. Thanks

Regards

Kanayo

Re: Local client copy cancelled

alichtenau — Mon, 21 Sep 2020 11:32:21 GMT

Hi Kanayo:

- Call SE11 and choose the menu path "Utilities -> Database Object -> Check".
- Call SE11 and choose the menu path "Utilities -> Runtime Object -> Check".

Is there any suspicious result?

Also please attach the full dump from ST22 as mentioned by Cristiano and Oguzhan.

Cheers,
Andreas

Re: Local client copy cancelled

former_member624966 — Mon, 21 Sep 2020 11:51:58 GMT

Hello Andreas,

find attach of the dumps in ST22 as requested, on the SE11 when i execute the t-code attach is what i saw i couldn't find database object under Utilities.

Regards

Kanayo

dump-in-st22.txt

Re: Local client copy cancelled

alichtenau — Mon, 21 Sep 2020 12:08:24 GMT

Hi Kanayo,
sorry, missed a step.

- Call SE11, enter database table name, display and choose the menu path "Utilities -> Database Object -> Check".
- Call SE11, enter database table name, display and choose the menu path "Utilities -> Runtime Object -> Check".

Can you please send a specific DBSQL_TABLE_UNKNOWN dump for further checking?

Cheers,
Andreas

Re: Local client copy cancelled

former_member624966 — Mon, 21 Sep 2020 13:45:26 GMT

Hello Andreas,

On the SE11 tcode which of the database table name will i enter, secondly on which client should execute this action on client 000.

attached is the DBSQL_TABLE_UNKNOWN dump for your review. Thanks for all your support so far.

dbsql.txt

Re: Local client copy cancelled

alichtenau — Mon, 21 Sep 2020 14:09:48 GMT

Hi Kanayo,

forget what I said. This information can be found in the dump:

|Error analysis                                                                                    ||    In an SAP Open SQL statement, a table is specified that either does not                       ||    exist on the database, or that is not known to the ABAP Data                                  ||    Dictionary.                                                                                   ||    This is table "SDRAFT_LOCK_EXP", or another table which the statement wants to                ||    access. The database has returned SQL code "SQL code: 328" with the error text                ||    "SQL message: invalid name of function or procedure: VDRAFT_LOCK_EXP: line 1                  ||     col 359 (at pos 358)".

According to your dump please resolve your problem according to SAP Note 2543179.
Afterwards copy your client again.

Best regards,
Andreas

Re: Local client copy cancelled

former_member624966 — Tue, 22 Sep 2020 09:50:10 GMT

Hello Andreas,

I have applied the SAP note 2543179 after which i re-initiated another client copy after it has copied about 83,000 out of 93,000 tables, then i call SSC3 to see the status and it shows me error as attached

Regards

Kanayochukwu

Re: Local client copy cancelled

former_member624966 — Tue, 22 Sep 2020 09:56:11 GMT

Hello Andreas,

Attach is the SCC3 log files

scc3-log.txt

Regards

Kanayochukwu

Re: Local client copy cancelled

alichtenau — Tue, 22 Sep 2020 11:27:02 GMT

Hi Kanayo,

V_RFC_BL_* issue
==> can be ignored according to SAP Note 1680045

|Error scheduling a batch job
|> client 160
|> Job R_JR_BTCJOBS_GENERATOR
|> Batch user SAP_SYSTEM does not exist

==> see SAP Note 2494541

Just for my information: Did you execute all post installation steps according to the swpm and installation guides?

Best regards,
Andreas

Re: Local client copy cancelled

former_member624966 — Tue, 22 Sep 2020 15:05:20 GMT

Hello Andreas,

Based on your question whether i executed all the post installation steps, below are what i did

Configured TMS, created RFC user, configure logical system and run SGEN before i start the creation of client and client copy, that is all i did please if there any one i didn't do please advice me further. Thanks for your support so far i appreciate,

Regards

Kanayochukwu

Re: Local client copy cancelled

alichtenau — Tue, 22 Sep 2020 15:27:25 GMT

I do not have all Post-Installation steps in my head. Always follow the release specific installation guide, SWPM guide and the respective release note in case of issues.

Regarding your errors please follow the steps I have written above.

Re: Local client copy cancelled

former_member624966 — Wed, 23 Sep 2020 07:06:06 GMT

Hello Andreas,

I have created a background job user "SAP_SYSTEM" and SAP_ALL access was assigned to the user on client 000 and created a new client 150 Dev System after which i started my local client copy which i selected the profile customized only. Target client is 150 while source client is 000, but the error persist. i want to know whether i should create the batch job user on the new client as well. attached is theSCC3 log file

.scc3-log-2.txt

Regards

Kanayochukwu

Re: Local client copy cancelled

former_member624966 — Wed, 23 Sep 2020 09:17:02 GMT

Hello Experts,

Please i need assistance on the above issue. attached is the log i got from ST22. i will appreciate anybody help in this situation.

Regards

Kanayochukwu

st22-error.txt

Re: Local client copy cancelled

former_member624966 — Wed, 23 Sep 2020 09:45:31 GMT

Hello Oguzhan,

Attach is the created dump from ST22 as requested. Thanks

Regards

kanayochukwu

st22-error.txt

Re: Local client copy cancelled

alichtenau — Wed, 23 Sep 2020 16:19:41 GMT

Hi Kanayo,

to be honest: I'm a little bit lost without just having the logs here.

Can you please open an incident on component BC-CTS-CCO? Or do you already have? The experts should check it on the system directly.

Cheers,
Andreas

Re: Local client copy cancelled

former_member624966 — Sun, 27 Sep 2020 05:19:34 GMT

Hello Experts,

For record purpose, i finally adopted another approach to resolved this issue. i went to DB02 to check how many Tables and views that is missing on the DB, i saw 21,000 tables and views that is not created on the Database, i said to myself creating 21,000 table on the DB is a whole lot of work i rather uninstalled the instance and re-installed back. and what was the course. during my installation on the stage of executing ABAP program i hard a server shutdown impromptu and i later continued with the installation and finished doing the post-installation during client copy it was dumping seriously returning error of Table missing on the DB. That was the issue.

As soon i did a fresh installation i was able to do client copy without any issue. i appreciate you all for your support. issue resolved.