SAP IDES ECC 6.0 EHP7 Oracle Installation error (DDIM.SQL is missing)

[gkmhpvp]

Hi Experts,

I'm experiencing following error while installation of IDES ECC 6.0 EHP7 Oracle in Windows Server 2008 R2.

(IMP) ERROR: Task failed with error: (SQL) Cannot read 'E:\SAPIDESERP6EHP7\51050166_1\DATA_UNITS\EXPORT_1\DB\ORA\DDIM.SQL': The system cannot find the file specified. (IMP) INFO: A failed DROP attempt is not necessarily a problem (IMP) ERROR: Task failed with error: (SQL) SQL file 'E:\SAPIDESERP6EHP7\51050166_1\DATA_UNITS\EXPORT_1\DB\ORA\DFACT.SQL' did not occur in 'SQLFiles.LST'

The DDIM.SQL file is indeed missing in the directory. but the SQLFiles.LST contains the name of three .SQL files DDIM.SQL, DFACT.SQL & DODS.SQL.

Screenshot of Error

ORA Directory Content

SQLList Content

import_monitor.log import-monitor.txt

SAPDFACT.log sapdfact.txt

import_monitor.java.log import-monitorjava.txt

I would like to know whether there are missing .SQL files in Installation Export or the SQLFiles.LST is wrong w.r.t to Oracle DB.

In anticipation of a quick response.

[prithvirajr]

Hi

Please check sap note 2372790

Regards,

Prithviraj

[former_member523280]

Dear,

Please following the KBA 2372790

Workaround:

If there is no "SQLFiles.LST", create it in "<export-directory>/ABAP/DB/<TARGETDBNAME>", putting all *.SQL file names one per line.Repeat the export or import step.

[Former Member]

Hi

My solution to install the IDES EHP7 Oracle on Windows 2008 Server

I downloaded in the marketplace the latest EHP7 IDES components :
- Oracle Client 12.1.0.2
- Oracle RDBMS 12.1.0.2
- SAP Kernel 7.42 Windows Server on x64 64bit
- DBATL740O11_33-70001662.SAR (DBA Tools)
- IDES SAP ERP 6.0 EHP7 Inst. Export 1
- IDES SAP ERP 6.0 EHP7 Inst. Export 2
- SOFTWARE_PROVISIONING_MGR_1.0_SP22

Change done before starting the installation:
1°) following the note 2295187, I removed the Line: "crestm" and "drpstm" from DDLORA_LRG.TPL, DDLORA.TPL
2°) following the note 2372790, i moved the file SQLFiles.lst from the generic directory "<export-directory>/ABAP/DB to the DB directory
<export-directory>/ABAP/DB/ORA in my case for Oracle
3°) I changed the SQLFiles.lst in the export_1 directory (removed with Notepad++ the line DDIM.SQL and DODS.SQL)

Changes done when error alted on Abap Import Step:
1°) Open Import_monitor.log file from directory "\Program Files\sapinst_instdir\BS2013SR2\ERP607SR2\ORA\INSTALL\STD\ABAP" to find the detail of error.
Following the note 885441, Opened the SAPDFACT.TSK file and look up for index with err (meaning error) at the front.
Change to ign (meaning ignore). Save and resume the execution again. Do the same steps if the error popping up again.

And installation finished.
On the first login in the client 000, i ran the prgram SAP_INFOCUBE_INDEXES_REPAIR.

[mandeep_kauldhar]

The solution is Implement "SAP note 2372790 - R3load error during SWPM export: "SQL file ... did not occur in 'SQLFiles.LST'";
Move (not copy) file F:\Download\Inst_Export\51050166_1\DATA_UNITS\EXPORT_1\DB\SQLFiles.LST to DB specific folder F:\Download\Inst_Export\51050166_1\DATA_UNITS\EXPORT_1\DB\\ORA\SQLFiles.LST .

Now correct the file SQLFiles.LST to include *.LST files in each line as in (F:\Download\Inst_Export\51050166_1\DATA_UNITS\EXPORT_1\DB) DB specific folder. SQLFiles.LST will be created in folder F:\Download\Inst_Export\51050166_1\DATA_UNITS\EXPORT_1\DB after you retry execution of installation with correct *.LST files in location
F:\Download\Inst_Export\51050166_1\DATA_UNITS\EXPORT_1\DB\\ORA\SQLFiles.LST.

Mandeep

[Former Member]

Hello G Kurumurthy,

Have you managed to solve it? or what did you do then?

I have the exact same issue now and really do not know what to do?

may we install IDES on Sybase instead!?

[Former Member]

Hello All,

I have same problem as mentioned above(no file DDIM.SQL & DODS.SQL) any one can help here to solve it.

Best Regards

Anurag

[janikowskip]

Hi,

We have the same problem as You (no file DDIM.SQL & DODS.SQL). Have you managed to solve it?

Regards,
Paweł

[hendrikweise]

Hey,

in E:\SAPIDESERP6EHP7\51050166_1\DATA_UNITS\EXPORT_1\DB you should have a file 'SQLFiles.LST'.
Open it in a text editor of your choice and remove the lines: DDIM.SQL, DODS.SQL.
Save and try to continue the import afterwards

Regards,

Hendrik

[gkmhpvp]

Yes I tried deleting them (similar to "crestm" error) but no success :(.