DevOps and System Administration Discussions
Dive into SAP DevOps and system administration. Join discussions to collaborate on optimizing workflows, share knowledge, and leverage resources effectively.
cancel
Showing results for 
Search instead for 
Did you mean: 

Local client copy cancelled

former_member624966
Participant
0 Kudos

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

1 ACCEPTED SOLUTION

alichtenau
Advisor
Advisor
0 Kudos

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

View solution in original post

19 REPLIES 19

0 Kudos

Hello,

Could you please share the created dump too?

0 Kudos

Hello Oguzhan,

Attach is the created dump from ST22 as requested. Thanks

Regards

kanayochukwu

st22-error.txt

cris_hansen
Advisor
Advisor

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

alichtenau
Advisor
Advisor
0 Kudos

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

former_member624966
Participant
0 Kudos

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

0 Kudos

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

former_member624966
Participant
0 Kudos

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

alichtenau
Advisor
Advisor
0 Kudos

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

former_member624966
Participant
0 Kudos

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

alichtenau
Advisor
Advisor
0 Kudos

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

former_member624966
Participant
0 Kudos

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

0 Kudos

Hello Andreas,

Attach is the SCC3 log files

scc3-log.txt

Regards

Kanayochukwu

alichtenau
Advisor
Advisor
0 Kudos

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

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

0 Kudos

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.

former_member624966
Participant
0 Kudos

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

former_member624966
Participant
0 Kudos

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

alichtenau
Advisor
Advisor
0 Kudos

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

former_member624966
Participant
0 Kudos

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.