Symptom
Solution
A tp step could not be executed. You can find the details log from /usr/sap/trans/log (DIR_TRANS). The cancellation message will contains a tp step 6, N or S. As per above error. The error is tp step 6.
tp step 6: P<YY><MM><DD>.<SID>
1. Go to OS directory and find the approriate log as per step. (as this example, step 6)
more P850403.SID
2WETP000 01:20:00: Retcode 1: error in DDL statement for "xxxx " - repeat 2EETP345 01:21:00: Retcode 1: SQL-error "959-ORA-00959: tablespace 'xxxx' does not exist" in DDL 2EETP334 01:22:00: error in DDL, nametab for "xxxx" not activated
2. The error is stated that,
SQL-error "959-ORA-00959: tablespace 'xxxx' does not exist"
3. Refer to https://itsiti.com/br0989w-unknown-tablespace-defined
