Skip to Content
avatar image
Former Member

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

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.

error.jpg (138.7 kB)
ora.jpg (20.1 kB)
sqllist.jpg (15.7 kB)
import-monitor.txt (966.1 kB)
sapdfact.txt (17.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Nov 13, 2017 at 03:43 PM

    Hi

    Please check sap note 2372790

    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 13, 2017 at 01:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2017 at 10:01 AM

    Hi,

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

    Regards,
    PaweĊ‚

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2017 at 05:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10 at 11:46 AM

    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!?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06 at 09:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29 at 09:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded