1 Reply Latest reply: Aug 26, 2013 6:57 PM by Ayush Ganeriwal RSS

    Unable to upload delimited flat file (Datastore)

    user7374943

      Dear All,

      Drilling down the tutorial:  ODI11g: Creating an ODI Project and Interface: Exporting a Flat File to a Flat File

      facing quite a problem while reverse-engineering delimited flat file (Datastore ->Model). No matter which type of delimited flat file is uploaded (txt, csv,prn), the system stayes intact while pressing "Reverse Engineering" button.  Changing to Fixed Flat File option reveals that the system uploads correctly only the first row - Header of the columns (second option from the top)..and ...of cource, all the rest of the rows were placed in the first column.

       

      I was preparing delimited flat files using Excel 2007 and  2010, in both cases no success. I tryied to create Fixed Flat File with Excel....confused completely since I could not realise how doing that?!

       

      Properties are below. Please, help!

       

      About
      -----

      Oracle Data Integrator 11g 11.1.1
      Standalone Edition Version 11.1.1
      Build ODI_11.1.1.6.0_GENERIC_111219.1055
      Copyright (c) 1997, 2011 Oracle.  All Rights Reserved.
      IDE Version: 11.1.1.6.38.61.92
      Product ID: oracle.odi
      Product Version: 11.1.1.6.0.0.0

      Version
      -------

      Component Version
      ========= =======
      Java(TM) Platform 1.6.0_21
      Oracle IDE 11.1.1.6.0

      Properties
      ----------

      Name Value
      ==== =====
      awt.toolkit sun.awt.windows.WToolkit
      class.load.environment oracle.ide.boot.IdeClassLoadEnvironment
      class.load.log.level CONFIG
      class.transfer delegate
      eclipselink.xml.platform org.eclipse.persistence.platform.xml.jaxp.JAXPPlatform
      file.encoding Cp1251
      file.encoding.pkg sun.io
      file.separator \
      ice.browser.forcegc false
      ice.pilots.html4.ignoreNonGenericFonts true
      ice.pilots.html4.tileOptThreshold 0
      ide.AssertCheckingDisabled true
      ide.AssertTracingDisabled true
      ide.bootstrap.start 14794412430839
      ide.build ODI_11.1.1.6.0_GENERIC_111219.1055
      ide.conf C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi\bin\odi.conf
      ide.config_pathname C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi\bin\odi.conf
      ide.debugbuild false
      ide.devbuild false
      ide.extension.search.path jdev/extensions
      ide.firstrun true
      ide.java.minversion 1.6.0_04
      ide.launcherProcessId 2932
      ide.main.class oracle.ide.boot.IdeLauncher
      ide.patches.dir ide/lib/patches
      ide.pref.dir C:\Users\Администратор\AppData\Roaming\odi
      ide.pref.dir.base C:\Users\Администратор\AppData\Roaming
      ide.product oracle.odi
      ide.shell.enableFileTypeAssociation C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi64.exe
      ide.splash.screen splash.gif
      ide.startingArg0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi64.exe
      ide.startingcwd C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client
      ide.user.dir C:\Users\Администратор\AppData\Roaming\odi
      ide.user.dir.var IDE_USER_DIR
      ide.work.dir C:\Users\Администратор\Documents\odi
      ide.work.dir.base C:\Users\Администратор\Documents
      ilog.propagatesPropertyEditors false
      java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
      java.awt.printerjob sun.awt.windows.WPrinterJob
      java.class.path ..\..\ide\lib\ide-boot.jar;..\..\..\..\oracledi.sdk\lib\ojdl.jar;..\..\..\..\oracledi.sdk\lib\dms.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\log4j-1.2.8.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\odi_hfm.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\odihapp_common.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\ess_es_server.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\ess_japi.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\odihapp_essbase.jar;..\..\jdev\extensions\oracle.odi.navigator\lib\odihapp_planning.jar
      java.class.version 50.0
      java.endorsed.dirs C:\Java\jre\lib\endorsed
      java.ext.dirs C:\Java\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
      java.home C:\Java\jre
      java.io.tmpdir c:\Temp\
      java.library.path C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\app\master\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\
      java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory
      java.protocol.handler.pkgs null|oracle.odi.ui.url
      java.runtime.name Java(TM) SE Runtime Environment
      java.runtime.version 1.6.0_21-b07
      java.specification.name Java Platform API Specification
      java.specification.vendor Sun Microsystems Inc.
      java.specification.version 1.6
      java.util.logging.config.class oracle.core.ojdl.logging.LoggingConfiguration
      java.vendor Sun Microsystems Inc.
      java.vendor.url http://java.sun.com/
      java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi
      java.version 1.6.0_21
      java.vm.info mixed mode
      java.vm.name Java HotSpot(TM) 64-Bit Server VM
      java.vm.specification.name Java Virtual Machine Specification
      java.vm.specification.vendor Sun Microsystems Inc.
      java.vm.specification.version 1.0
      java.vm.vendor Sun Microsystems Inc.
      java.vm.version 17.0-b17
      line.separator \r\n
      LOG_FILE studio.log
      native.canonicalization false
      ODI_ORACLE_HOME C:\oracle\product\11.1.1\Oracle_ODI_1\
      oracle.core.ojdl.logging.config.file ODI-logging-config.xml
      oracle.home C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client
      oracle.odi.studio.ess false
      oracle.odi.wls.template.generator.agentEarLocation C:\oracle\product\11.1.1\Oracle_ODI_1\setup\manual\oracledi-agent\oraclediagent.ear
      oracle.security.jps.config ./jps-config.xml
      oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
      oracle.xdkjava.compatibility.version 9.0.4
      org.apache.commons.logging.Log org.apache.commons.logging.impl.Jdk14Logger
      os.arch amd64
      os.name Windows Server 2008 R2
      os.version 6.1
      path.separator ;
      python.cachedir c:\Temp\cachedir
      python.home C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting
      python.packages.paths java.class.path,sun.boot.class.path,odi.class.path
      reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
      sun.arch.data.model 64
      sun.boot.class.path C:\Java\jre\lib\resources.jar;C:\Java\jre\lib\rt.jar;C:\Java\jre\lib\sunrsasign.jar;C:\Java\jre\lib\jsse.jar;C:\Java\jre\lib\jce.jar;C:\Java\jre\lib\charsets.jar;C:\Java\jre\classes;C:\Java\lib\tools.jar;C:\Java\lib\dt.jar
      sun.boot.library.path C:\Java\jre\bin
      sun.cpu.endian little
      sun.cpu.isalist amd64
      sun.desktop windows
      sun.io.unicode.encoding UnicodeLittle
      sun.java2d.noddraw true
      sun.jnu.encoding Cp1251
      sun.management.compiler HotSpot 64-Bit Server Compiler
      sun.os.patch.level Service Pack 1
      user.country RU
      user.dir C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi\bin
      user.home C:\Users\Администратор
      user.language ru
      user.name master
      user.timezone Europe/Moscow
      user.variant
      windows.shell.font.languages en

      External Components
      -------------------

      Name Version Path
      ==== ======= ====
      HspJS.jar 11.1.1.1.0 Build 137 Built with CIS Drop 27 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\HspJS.jar
      HspJS.jar 11.1.1.1.0 Build 137 Built with CIS Drop 27 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\HspJS.jar
      HspJS_11.1.2.0.jar 11.1.2.0.01.10 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\HspJS_11.1.2.0.jar
      HspJS_11.1.2.0.jar 11.1.2.0.01.10 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\HspJS_11.1.2.0.jar
      activation.jar 1.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\activation.jar
      binding-2.0.2.jar 2.0.2 2008-01-18 10:01:08 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\binding-2.0.2.jar
      coherence.jar 3.7.1.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\coherence.jar
      commons-beanutils-1.7.0.jar 1.6 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-beanutils-1.7.0.jar
      commons-codec-1.3.jar 1.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-codec-1.3.jar
      commons-collections-3.2.jar 3.2 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-collections-3.2.jar
      commons-discovery-0.4.jar 0.4 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-discovery-0.4.jar
      commons-io-1.2.jar 1.2 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-io-1.2.jar
      commons-lang-2.2.jar 2.2 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-lang-2.2.jar
      commons-logging-1.1.1.jar 1.1.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-logging-1.1.1.jar
      commons-net-1.4.1.jar 1.4.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-net-1.4.1.jar
      commons-vfs-1.0.jar 1.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\commons-vfs-1.0.jar
      cpld.jar Version 11.1.2.0.00, Build 589, March 25 2010 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\cpld.jar
      cpld.jar Version 11.1.2.0.00, Build 589, March 25 2010 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\cpld.jar
      dbswing.jar 011.000.044.108 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\dbswing.jar
      dx.jar 007.001.175.112 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\dx.jar
      eclipselink.jar 2.3.1.v20111018-r10243 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\eclipselink.jar
      enterprise_data_quality.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\enterprise_data_quality.jar
      enterprise_data_quality.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\enterprise_data_quality.jar
      ess_es_server.jar 11.1.2.0.0.615 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\ess_es_server.jar
      ess_es_server.jar 11.1.2.0.0.615 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\ess_es_server.jar
      ess_japi.jar 11.1.2.0.0.615 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\ess_japi.jar
      ess_japi.jar 11.1.2.0.0.615 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\ess_japi.jar
      fmwgenerictoken.jar 1.0.0.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\..\..\..\..\..\odi_misc\fmwgenerictoken.jar
      forms-1.2.0.jar 1.2.0 2008-02-23 08:37:50 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\forms-1.2.0.jar
      groovy-all-1.7.4.jar 1.7.4 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\groovy-all-1.7.4.jar
      hsqldb.jar 2.0.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\hsqldb.jar
      http_client.jar December 9 2011 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\http_client.jar
      javax.security.jacc_1.0.0.0_1-1.jar 1.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\javax.security.jacc_1.0.0.0_1-1.jar
      mail.jar 1.4 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\mail.jar
      odi-sap.jar 10.1.3.12 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\odi-sap.jar
      odi_hfm.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\odi_hfm.jar
      odi_hfm.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\odi_hfm.jar
      odihapp_essbase.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\odihapp_essbase.jar
      odihapp_essbase.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\odihapp_essbase.jar
      odihapp_planning.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\odihapp_planning.jar
      odihapp_planning.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\odihapp_planning.jar
      odihapp_planning_11.1.2.0.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\odihapp_planning_11.1.2.0.jar
      odihapp_planning_11.1.2.0.jar 11.1.1.6.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\odihapp_planning_11.1.2.0.jar
      ojdbc6dms.jar 11.2.0.3.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\ojdbc6dms.jar
      oracle.ucp_11.1.0.jar 11.2.0.3.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\oracle.ucp_11.1.0.jar
      pop3.jar 1.1.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\pop3.jar
      spring-aop.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-aop.jar
      spring-beans.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-beans.jar
      spring-context.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-context.jar
      spring-core.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-core.jar
      spring-dao.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-dao.jar
      spring-jdbc.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-jdbc.jar
      spring-jmx.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-jmx.jar
      spring-jpa.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-jpa.jar
      spring-web.jar 2.0.3 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\spring-web.jar
      trove.jar 2.1.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\trove.jar
      wlthint3client.jar 10.3.5.0 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi.sdk\lib\wlthint3client.jar
      woodstox.jar 3.2.1 C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib\woodstox.jar

      Extensions
      ----------

      Name Identifier Version Status
      ==== ========== ======= ======
      BM metamodel framework oracle.bm.meta 11.1.1.6.38.61.92 Loaded
      Code Editor oracle.ide.ceditor 11.1.1.6.38.61.92 Loaded
      Diagram Framework oracle.diagram 11.1.1.6.38.61.92 Loaded
      Diagram Javadoc Extension oracle.diagram.javadoc 11.1.1.6.38.61.92 Loaded
      Diagram Thumbnail oracle.diagram.thumbnail 11.1.1.6.38.61.92 Loaded
      Extended IDE Platform oracle.javacore 11.1.1.6.38.61.92 Loaded
      Groovy Support oracle.ide.groovy 11.1.1.4.37.58.91 Loaded
      Help System oracle.ide.help 11.1.1.6.38.61.92 Loaded
      Import/Export Support oracle.ide.importexport 11.1.1.6.38.61.92 Loaded
      Index Migrator support oracle.ideimpl.indexing-migrator 11.1.1.6.38.61.92 Loaded
      JViews Registration Addin oracle.diagram.registration 11.1.1.6.38.61.92 Loaded
      Log Window oracle.ide.log 11.1.1.6.38.61.92 Loaded
      Modeler Framework oracle.modeler 11.1.1.6.38.61.92 Loaded
      Modeler Framework Common Layer oracle.modeler.common 11.1.1.6.38.61.92 Loaded
      Navigator oracle.ide.navigator 11.1.1.6.38.61.92 Loaded
      ODI Navigator oracle.odi.navigator 11.1.1.6.0.0.0 Loaded
      Object Gallery oracle.ide.gallery 11.1.1.6.38.61.92 Loaded
      Oracle Data Integrator oracle.odi 11.1.1.6.0.0.0 Loaded
      Oracle IDE oracle.ide 11.1.1.6.38.61.92 Loaded
      Peek oracle.ide.peek 11.1.1.6.38.61.92 Loaded
      Persistent Storage oracle.ide.persistence 11.1.1.6.38.61.92 Loaded
      Property Inspector oracle.ide.inspector 11.1.1.6.38.61.92 Loaded
      Runner oracle.ide.runner 11.1.1.6.38.61.92 Loaded
      Virtual File System oracle.ide.vfs 11.1.1.6.38.61.92 Loaded
      Web Browser and Proxy oracle.ide.webbrowser 11.1.1.6.38.61.92 Loaded
      audit oracle.ide.audit 11.1.1.6.38.61.92 Loaded
      jdukshare oracle.bm.jdukshare 11.1.1.6.38.61.92 Loaded
      mof-xmi oracle.mof.xmi 11.1.1.6.38.61.92 Loaded
      oracle.ide.indexing oracle.ide.indexing 11.1.1.6.38.61.92 Loaded
      palette2 oracle.ide.palette2 11.1.1.6.38.61.92 Loaded