Table entroes Deletion - Client Deletion

[Former Member]

Hi All,

During process of deletion of client in our QAS system, one of the table entries were not deleted due to rollback space shortage. The deletion of client is complete with error and we would like to delete those entries of the deleted client. Please can some suggest how we go about it?

Option (1): Re create entry for that client in SCC4 and logon to that client and execute client deletion job. Would this take care of old entries?

or

Option (2): Delete entries from backend using sqlplus with "MANDT" option.

I would have left those entries in table if it was small table, but size of table is 5 GB.

The table is T552A.

Regards,

Priyank.

[Former Member · Accepted solution]

What is the SAP/Oracle software version?

Could you provide error log entries for rollback problem?

[Former Member · Accepted solution]

Hi A,

SAP version ECC 5.0 and Oracle - 9.2.0.7.

Statistics for this Run

- No. of Tables 34.431 of 34.432

- Deleted Lines 3.103.080

Warnings and Errors

Table/Object Component Error

T552A PT Deletion Fields (See SM21)

ERROR: Cannot delete in client: 211 table T552A

T552A The database returned a value containing an error

Regards,

Priyank.

[former_member204746 · Accepted solution]

re-create client in SCC4

login again into that client with SAP*/pass

delete client again

if it fails again, consider using PSAPROLLBIG or extend PSAPUNDO

[Former Member · Accepted solution]

Hi Eric,

What are the implcations of leaving those entries in table? I size of the table is 5 GB and it's an Non-Productive system.

Regards,

Priyank.

[former_member204746 · Accepted solution]

Impact?

you will use 5GB of hard disk space unnecessarily.

if you ever re-create a client with the same client number, these leftovers may create problems.

so, in an effort to keep your system clean, follow my previous recommendation.