14 Replies Latest reply: Dec 4, 2012 7:44 AM by Bhabani Ranjan RSS

    Reg : Knowledge Module

    user132819
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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