SPAM Update

[Former Member]

Dear Sir/Madam,

I am trying to updat spam from 7.01/0036 to 7.01/0057, but it prompt import_proper,tp_step_failure,return code 0008, error message: ocs package all, tp step 6, return code 0008. I have update tp and R3trans to the latest. Attachment is the trans log. would you please help to solve it. our environment is ecc6.0, db is oracle 11.2

log of trans.txt.zip

[Reagan]

>>2WETP000 16:07:14: Retcode 1: error in DDL statement for "PATHISTORY                    " - repeat

2EETP345 16:07:26: Retcode 1: SQL-error "1157-ORA-01157: cannot identify/lock data file 256 - see D

2EETP345 BWR trace file

2EETP345 ORA-01110: data file 256: '/oracle/H01/oradata/sapdata2/temp_2/temp.data2'" in DDL stateme

2EETP345 nt for "PATHISTORY <<

I see issue is at the database level.

Have you checked the Oracle alert log?

Check the existence of the temp file /oracle/H01/oradata/sapdata2/temp_2/temp.data2

It looks strange that the sapdata2 is located inside oradata.

If PSAPTEMP tablespace is not correctly created then fix that issue and update SPAM

[Former Member]

Hello,

Please check following SAP links.

SPAM 7.02 - Error TP_FAILURE IMPORT_PHASE | SAP is EASY and EASY

ORA-01157: cannot identify/lock data file 201 -... | SCN

1763972 - Corrections in BR*Tools 7.20 Patch 26

Regards

Anand

[Sriram2009]

Hi

Just stop the import and retry again,

BR

SS