System Copy Import / R3Load error interpretation

[benoit-schmid]

Hello,

I am running a System Copy on Target system for an ECC 6.04.

There are a few R3Load that are terminating in error:

% grep "import package is" /var/tmp/sapinst_instdir/BS2008/ERP604/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/import_monitor.log | grep -v "is started." | grep -v "successfully completed"

Loading of 'RFBLG' import package is interrupted with R3load error.

Loading of 'REGUC' import package is interrupted with R3load error.

Loading of 'DOKCLU' import package is interrupted with R3load error.

Loading of 'EDI40' import package is interrupted with R3load error.

Loading of 'CDCLS-10' import package is interrupted with R3load error.

Loading of 'CDCLS-1' import package is interrupted with R3load error.

Loading of 'CDCLS-7' import package is interrupted with R3load error.

Loading of 'CDCLS-6' import package is interrupted with R3load error.

Loading of 'CDCLS-4' import package is interrupted with R3load error.

Loading of 'CDCLS-5' import package is interrupted with R3load error.

Loading of 'CDCLS-2' import package is interrupted with R3load error.

Loading of 'CDCLS-3' import package is interrupted with R3load error.

Loading of 'CDCLS-9' import package is interrupted with R3load error.

Loading of 'CDCLS-8' import package is interrupted with R3load error.

If I look at the log, there is the following error:

(SQL) INFO: Searching for SQL file CLUST.SQL

(SQL) INFO: CLUST.SQL not found

(SQL) INFO: Searching for SQL file /SAP-DVD/ExportEcc/ABAP/DB/ORA/CLUST.SQL

(SQL) INFO: /SAP-DVD/ExportEcc/ABAP/DB/ORA/CLUST.SQL not found

(DB) INFO: EDI40 created #20130409105842

myCluster (127.23.Imp): 676: error when retrieving table description for physical table EDI40.

myCluster (127.23.Imp): 677: return code received from nametab is 32

myCluster (127.23.Imp): 299: error when retrieving physical nametab for table ED

I40.

(CNV) ERROR: data conversion failed.  rc = 2

(DB) INFO: disconnected from DB

Could you help me interpreting this error?

Would you know what is the root cause of this error?

Thanks in advance for your answer.

[JPReyes · Accepted solution]

CLUST.SQL not found

This file should have been created by SMIGR_CREATE_DLL, did you run it before the export?

Regards, Juan

[benoit-schmid · Accepted solution]

Hello Juany,

Juan Reyes wrote:
CLUST.SQL not found
This file should have been created by SMIGR_CREATE_DLL, did you run it before the export?
Regards, Juan

Yes, I have run SMIGR_CREATE_DLL on source.

It has not generated the CLUST.SQL.

It has generated the following 3 files because SAP has configure Oracle Compression for a few GVD_ tables.

# cat /var/tmp/SQLFiles.LST

#

# ORACLE : LIST OF .SQL FILES OF NATIVE SQL EXPORT GENERATED AT 20130405141309

#

APPL1.SQL

APPL2.SQL

When I saw that it was only for compression, I have not taken these files.

But I should have.

Where must I put them (DATA or DB dir)?

Thanks in advance for your answers.

[JPReyes · Accepted solution]

I wonder why is looking for a non-generated <tabart.SQL file. did you point the import to SQLFiles.LST?

Searching for SQL file /SAP-DVD/ExportEcc/ABAP/DB/ORA/CLUST.SQL

They should be in the DB dir.

Regards, Juan

[benoit-schmid · Accepted solution]

Hello Juan,

Juan Reyes wrote:
I wonder why is looking for a non-generated <tabart.SQL file. did you point the import to SQLFiles.LST?
Searching for SQL file /SAP-DVD/ExportEcc/ABAP/DB/ORA/CLUST.SQL
They should be in the DB dir.
Regards, Juan

No I did not provide the SQLFiles.LST for export or import.

In the past, with NW 6.40, it was ok.

I have tried to provide it to import.

But it did not help.

I am restarting the export again.

Regards,

[benoit-schmid · Accepted solution]

Hello,

After adding these files for export/import, it has worked.

Regards,

[JPReyes · Accepted solution]

Great

[benoit-schmid]

Hello,

As I had no fast answer, I have checked 🙂

These files should be in /ABAP/DB/ORA/ (same location of DBSIZE.XML).

Do I have to rerun the export on source system?

Thanks in advance for your answer.

[Former Member]

Hi,

You can try with my earlier reply. Please shutdown the old system if SID is same and then try the system copy on new box. This tym issue may not come.

Regards,

Venkat

[benoit-schmid]

Hello,

venkatesh babu wrote:
Hi,
You can try with my earlier reply. Please shutdown the old system if SID is same and then try the system copy on new box. This tym issue may not come. 
Regards,
Venkat

I am a little puzzled with your answer.

Buy the old system, you mean the source system don't you?

I do not see why I should perform so.

Regards,

[Former Member]

Hi,

Check that the old system from which you are copying is not running. while running the system copy on the new box , if you have disconnected or shutdown the old system database then it wil be reflected here and it is showing the error disconnected from DB (if SID is same for system copy, as it is for source system).

Regards,

Venkat

[Former Member]

Hi,

Can you please attached  SAPCLUST.log and SAPSSEXC.log along with CLUST.SQL for further analysis.

Also please  can check the consistency of copied CD/DVD according the note:

#927974 - SAP Original Software - SHA checksum test

Rgds,

Sachin

[former_member188883]

Hi Benoit,

Can you do a search for this file in export dump location as well as installation directory

CLUST.SQL

As per the error import of all the clustered tables are failing due to missing CLUST.SQL file.

Regards,

Deepak Kori

[benoit-schmid]

Hello Deepak,

Deepak Kori wrote:
Hi Benoit,
Can you do a search for this file in export dump location as well as installation directory
CLUST.SQL
As per the error import of all the clustered tables are failing due to missing CLUST.SQL file.
Regards,
Deepak Kori

There is no CLUST.SQL and SMIGR_CREATE_DLL has not generated any.

Regards,