Recreate Cofile and datafile

[former_member196442]

Hello All,

I accidently deleted cofile and datafile of already release transport.Let me know if its possible to regenerate cofile and datafile for this transport request.I dont want to create new transport and add object to it.

Thanks

Nilesh

[former_member195313]

Hello Nilesh ,

You can recreate deleted COFILES and DATA files via TP EXPORT method.

Just use the following command for this ;

tp export <REQUEST NUMBER> pf=TP_DOMAIN_<SID> .PFL

This command will recreate the related files under /DATA and /COFILES directories.

Recreate COFILES and DATA Files under TRANS Directory

[laszlo_herbert]

Hi guys,

please take into account, that reexporting the same tr.request does not meen, that the same data will be exported.

Each  tr.request has the snapshot of the export time!

If any of the objects were changed in the meantime, the content will not be the same.

The real solution to get the old data is to restore the transport directory content.

Best regards,

Laszlo

[Former Member]

Hi Nilesh,

You can create a transport of copies in this case and release it to get data and cofiles.

I would not recommend to change request status in E070. Its against SAP standards and will take more efforts than creating transport of copies.

Regards,

Sarim

[Former Member]

Hello,

first, workaround to unrelease transport and create it should be used very carefully

however for those who still would like to do it this is the way:

example:

SQL> select * from SAPR3.E070 where TRKORR='GT1K900882';
TRKORR               T T TARSYSTEM  KORR AS4USER      AS4DATE  AS4TIM  STRKORR

GT1K900882           K R            SYST SAPBASIS     20090519 112237

SQL>  update SAPR3.E070 set TRSTATUS='D' where TRKORR='GT1K900882';

1 row updated.

SQL> commit;

Commit complete.

[Former Member]

Hello Stanislav,

Thanks for your sharing of the codes,

We also faced the same issue of /usr/sap/trans/data missing, But the /cofiles is there,

We don't know how to re-create them,

After i saw your posting,

I think this is really a way to fetch it from the database table,

But we are using the HANA database,

I don't know how and where to input  the code as your posting.

Could you please help to guide?

Best Regards!

Lawrance

[tomas_black]

Hello Nilesh,

you can recreate the cofile lost by issuing the following command on the OS level:

tp CREATECOFILE <request_number> pf=<profile_name>

Cofiles are header files that can be recreatew/o problems. However, Datafiles can NOT be created from scratch. Datafiles - as the name suggests - hold the data to be transported. If they don't exist anymore, you can't recreate (and import) them.

At this points I believe your salvation is to restore the directory /usr/sap/trans/data from backup.

Best regards,

Tomas Black

[former_member196442]

Hi Tomas,

I used the workarround.I change the status of transport request from released to modifiable and release the request again which bring back Cofile and Datafile.This fixed my issue.

Thanks.

Nilesh Mokadam