This discussion is archived
14 Replies Latest reply: Dec 4, 2012 5:44 AM by Bhabani Ranjan RSS

Reg : Knowledge Module

user132819 Newbie
Currently Being Moderated
Hi All ,

Earlier i had a requirement like to fetch the data from .csv file and push them in to Oracle table for this i have selected LKM File to Oracle(SQLLDR) and

IKM Oracle Incremental Update and now i got a requirement like to fetch the data from Oracle Tables and push them in to .csv file .

Can anyone suggest me what are knowledge modules (LKM and IKM) need to be imported to achieve this .

Thanks ,
Karthik
  • 1. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    You can go for below options

    1. LKM SQL to SQL and IKM Sql to File Append
    2. OdiSqlUnload

    Thanks
    Bhabani
    http://dwteam.in
  • 2. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    Hi Bhabani ,

    I have imported LKM SQL to SQL and IKM SQL to File Append Knowledge Modules , then i can see LKM SQL to SQL for SrcSet in LKM Selector drop down , but for Target Area i unable to see IKM SQL to File Append option in IKM selector drop down .

    Thanks
    Karthik
  • 3. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    your staging must be one RDBMS. So go to definition tab of your interface and select the staging area different than target.
    Then save the interface and close it. Now reopen your interface. You should be able to find it right there.

    Thanks
    Bhabani
    http://dwteam.in
  • 4. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    After moving the stagging area to some other it woked but now when i execute i am facing a different issue like File /home/oracle/odifiles/IN/Test.csv was not found

    but i placed that file and able to see that file in that location .

    Thanks
    Karthik
  • 5. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    In your interface right click on the target table and view data.
    If you will get error means interface is not able to locate the file. Check you might have some case sensitive issues or may be privilege issues.

    Thanks
    Bhabani
    http://dwteam.in
  • 6. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    Hi Bhabani ,

    Yes i got the below error when i right click on datastore

    See com.borland.dx.dataset.DataSetException error code: BASE+62
    com.borland.dx.dataset.DataSetException: Execution of query failed.

    Thanks
    Karthik
  • 7. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    Please copy the entire error message. There must be

    See com.borland.dx.dataset.DataSetException error code: BASE+62
    com.borland.dx.dataset.DataSetException: Execution of query failed.
    Chained exception:
    java.sql.SQLException: ODI-40438: File not found: /home/oracle/odifiles/IN/Test.csv


    Please check again your file. If you are still not able to trace it then drop the data store and recreate it again. It will solve your problem.

    Thanks
    Bhabani
    http://dwteam.in
  • 8. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    i have dropped and recreated it again , complete error msg

    See com.borland.dx.dataset.DataSetException error code: BASE+62
    com.borland.dx.dataset.DataSetException: Execution of query failed.
         at com.borland.dx.dataset.DataSetException.a(Unknown Source)
         at com.borland.dx.dataset.DataSetException.queryFailed(Unknown Source)
         at com.borland.dx.sql.dataset.QueryProvider.a(Unknown Source)
         at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
         at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
         at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
         at com.sunopsis.graphical.frame.DwgDataFrame.initialize(DwgDataFrame.java:368)
         at com.sunopsis.graphical.frame.DwgDataFrame.<init>(DwgDataFrame.java:77)
         at oracle.odi.ui.etlmodeler.diag.inspector.pane.popup.DiagramActionDispayDataTarget.actionPerformed(DiagramActionDispayDataTarget.java:87)
         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
         at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
         at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
         at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
         at java.awt.Component.processMouseEvent(Component.java:6290)
         at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
         at java.awt.Component.processEvent(Component.java:6055)
         at java.awt.Container.processEvent(Container.java:2039)
         at java.awt.Component.dispatchEventImpl(Component.java:4653)
         at java.awt.Container.dispatchEventImpl(Container.java:2097)
         at java.awt.Component.dispatchEvent(Component.java:4481)
         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
         at java.awt.Container.dispatchEventImpl(Container.java:2083)
         at java.awt.Window.dispatchEventImpl(Window.java:2482)
         at java.awt.Component.dispatchEvent(Component.java:4481)
         at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
         at java.awt.EventQueue.access$000(EventQueue.java:84)
         at java.awt.EventQueue$1.run(EventQueue.java:607)
         at java.awt.EventQueue$1.run(EventQueue.java:605)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
         at java.awt.EventQueue$2.run(EventQueue.java:621)
         at java.awt.EventQueue$2.run(EventQueue.java:619)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
         at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
         at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
         at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    Chained exception:
    java.sql.SQLException: ODI-40438: File not found: /home/oracle/odifiles/IN/Test.csv
         at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(FileResultSet.java:162)
         at com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(CommandSelect.java:57)
         at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:33)
         at com.sunopsis.jdbc.driver.file.FilePreparedStatement.executeQuery(FilePreparedStatement.java:135)
         at com.borland.dx.sql.dataset.o.f(Unknown Source)
         at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
         at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
         at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
         at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
         at com.sunopsis.graphical.frame.DwgDataFrame.initialize(DwgDataFrame.java:368)
         at com.sunopsis.graphical.frame.DwgDataFrame.<init>(DwgDataFrame.java:77)
         at oracle.odi.ui.etlmodeler.diag.inspector.pane.popup.DiagramActionDispayDataTarget.actionPerformed(DiagramActionDispayDataTarget.java:87)
         at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
         at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
         at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
         at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
         at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
         at java.awt.Component.processMouseEvent(Component.java:6290)
         at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
         at java.awt.Component.processEvent(Component.java:6055)
         at java.awt.Container.processEvent(Container.java:2039)
         at java.awt.Component.dispatchEventImpl(Component.java:4653)
         at java.awt.Container.dispatchEventImpl(Container.java:2097)
         at java.awt.Component.dispatchEvent(Component.java:4481)
         at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
         at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
         at java.awt.Container.dispatchEventImpl(Container.java:2083)
         at java.awt.Window.dispatchEventImpl(Window.java:2482)
         at java.awt.Component.dispatchEvent(Component.java:4481)
         at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
         at java.awt.EventQueue.access$000(EventQueue.java:84)
         at java.awt.EventQueue$1.run(EventQueue.java:607)
         at java.awt.EventQueue$1.run(EventQueue.java:605)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
         at java.awt.EventQueue$2.run(EventQueue.java:621)
         at java.awt.EventQueue$2.run(EventQueue.java:619)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
         at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
         at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
         at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    Thanks
    Karthik
  • 9. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    I think you are using agent to run it. The agent might not have access to that location.
    Try using local(noagent).

    Thanks
    Bhabani
    http://dwteam.in
  • 10. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    I am not using agent while execution , i am using only local(no agent) for this

    in the steps it is getting failed at the step Generate Header step , in that it is giving below error


    Caused By: java.sql.SQLException: ODI-40433: File /home/oracle/odifiles/IN/Test.csv was not found


    Thanks ,
    Karthik
  • 11. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    Hi Bhabani ,

    I have done it , data transferred in to file successfully !

    But here while execution we have to select Agent and execute it , then we can achieve this ..


    Thanks
    Karthik
  • 12. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    Glad you resolved it. May be your agent has privilege to read that location where as it wont have for local agent.

    Thanks
    Bhabani
    http://dwteam.in
  • 13. Re: Reg : Knowledge Module
    user132819 Newbie
    Currently Being Moderated
    Hi Bhabani ,

    Can you help me on this

    I have to implement Triggers , cursors and procedures in ODI ,

    Can you help me by providing some documents on this .

    Thanks
    Karthik
  • 14. Re: Reg : Knowledge Module
    Bhabani Ranjan Guru
    Currently Being Moderated
    Please close this thread as the issue has been resolved.

    For your last question you can ping me at odiissue@gmail.com as well as you can search for the same in forum. If you wont find anything you can post another question.

    Thanks
    Bhabani
    http://dwteam.in

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points