Program terminated (job: "RDDEXECL") during tr import

[Former Member]

Hi All,

While trying to import TR in BW system. we are getting following dump:

Please find further TR logs :

more YYYR902538.XXX

1 ETP199X######################################

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP101 transport order     : "XXXK902538"

1 ETP102 system              : "XXX"

1 ETP108 tp path             : "tp"

1 ETP109 version and release : "380.03.82" "720"

1 ETP198

2 EPU126XPost-import methods for change/transport request: "YYYK902538"

4 EPU111    on the application server: "nqlsbwaps1"

2 EPU122XPost-import method "RS_AFTER_IMPORT" started for "UPDR" "L", date and time: "20130509145450"

1AETR012XProgram terminated (job: "RDDEXECL", no.: "14545000")

1AEPU320 See job log"RDDEXECL""14545000""XXX"

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP110 end date and time   : "20130509145755"

1 ETP111 exit code           : "12"

OUR SAP BW SUPPORT PACK IS SAPKW730007 and system details are: BI 7.3,oracle 11gr2 ,SunOS 5.10

Please provide me with valuable solutions.

Regards,

Girish

[Former Member · Accepted solution]

Thanks all,

We did a complete database recovery and the system is working fine now.

[former_member185239 · Accepted solution]

Thanks Lekshmi for letting us know.

Just mark your last comment as correct!!

With Regards

Ashutosh Chaturvedi

[former_member144433 · Accepted solution]

Hi Girish,

It is great to know that the issue is resolved.

Thank You.

Regards,

Deepika

[former_member144433]

Hi Girish,

Regarding the block corruption, please proceed with the following

checks;

- Perform a complete consistency check of the database as per sap note

  23345 because maybe there are more blocks corrupted, not just the one

  reported by the ORA-01578:

Note: 23345 - Consistency check of ORACLE database

- Please also refer to the following note to fix the block corruption:

Note: 365481 - Block corruptions

The following notes may also be of help to you:

Note: 605062 - FAQ: Restore and recovery

Note: 4161 - Complete Recovery

Thank You.

Regards,

Deepika

[former_member188883]

Hi Girish,

Refer SAP Note 365481 - Block corruptions

1. Identify the object that belongs to this corrupt block

Following the steps described in this section will help you identify the object which falls under the corrupted data block.

Based on the object further course of action can be decided.

Hope this helps.

Regards,

Deepak Kori

[former_member185239]

Hi Lekshmi,

Things to check,

1. Check at os level , any tp process is running or not.

2. Check the /usr/sap/trans/tmp directory whether it is getting updated or not.

Also check the below link

http://www.dba-oracle.com/t_ora_01578_data_block_corrupted.htm

With Regards

Ashutosh Chaturvedi