Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
8 replies Latest Post - ‏2014-03-24T16:32:21Z by juepo
cwoliveira
cwoliveira
25 Posts
ACCEPTED ANSWER

Pinned topic Documentation for event integration via ECM SM Database access

‏2014-02-27T01:37:53Z |

Hello,

I read on "ECM SM Event Forwarding" document about the passive way to integrate ECM SM events, for instance using IBM ITM ODBC.

Is there a documentation with ECM SM database schema/tables ?

Thanks,

Carlos.

  • juepo
    juepo
    28 Posts
    ACCEPTED ANSWER

    Re: Documentation for event integration via ECM SM Database access

    ‏2014-03-18T13:44:52Z  in response to cwoliveira

    Carlos,

    inside the User's Guide, Appendix B shows a Database Tables Overview.

    Another valuable function can be found in the ECM SM GUI, server configuration console, using the drop down menu in the Target / Plug-In List view. The entry "Show events query" displays the SQL query to select all current events.

    Regards,

    Juergen

     

    Attachments

    • cwoliveira
      cwoliveira
      25 Posts
      ACCEPTED ANSWER

      Re: Documentation for event integration via ECM SM Database access

      ‏2014-03-19T21:01:57Z  in response to juepo

      Thanks Juergen, I missed this User Guide's appendix.

      About the "show events query", I'll need to re-check because my menu doesn't display this option (also export/import pluginconfiguration are missing)

      Regards,

      Carlos.

      • juepo
        juepo
        28 Posts
        ACCEPTED ANSWER

        Re: Documentation for event integration via ECM SM Database access

        ‏2014-03-20T09:53:34Z  in response to cwoliveira

        Carlos,

        Which version ECM SM are you using? Is this the same server as in the ComponentManagerStatus question (ECM SM 5.1 FP2)?

        Did you change anything in user management (roles/rights) for user admin?

        Please post a screenshot of the version (Help - About - Installation history).

        Regards,

        Juergen

        • cwoliveira
          cwoliveira
          25 Posts
          ACCEPTED ANSWER

          Re: Documentation for event integration via ECM SM Database access

          ‏2014-03-21T17:24:03Z  in response to juepo

          Hi Juergen,

          Yes, it is the same system (ECM SM 5.1 FP2).

          No changes made under User Management console. Is there a role/function that can be verified about this behavior ?

          I opened a PMR with IBM Support about this.

          Thanks,

          Carlos.

          • juepo
            juepo
            28 Posts
            ACCEPTED ANSWER

            Re: Documentation for event integration via ECM SM Database access

            ‏2014-03-21T17:30:04Z  in response to cwoliveira

            Carlos,

            Very strange. The original ECM SM admin user got all rights that exist. I'm not at the office anymore, so I can't tell you the exact point to check. But it is very difficult to change exactly the rights for that behavior.

            Are there any error messages in the GUI log (var/log/gui.0.log)?

            Regards,

            Juergen

            • cwoliveira
              cwoliveira
              25 Posts
              ACCEPTED ANSWER

              Re: Documentation for event integration via ECM SM Database access

              ‏2014-03-21T20:20:03Z  in response to juepo

              Hi Juergen,

              Nothing in [gui.0.log], something on [gui.appsupervisor.log], however "this is probably, but not necessarily, a bug".

              2014-03-21 16:49:19,584 [INFO ] STDOUT: !ENTRY org.eclipse.rap.ui 4 0 2014-03-21 16:49:19.479
              2014-03-21 16:49:19,584 [INFO ] STDOUT: !MESSAGE Warning: Detected recursive attempt by part de.cenit.eb.sm.finca.gui.pluginconfigurationview.view to create itself (this is probably, but not necessarily, a bug)
              2014-03-21 16:49:19,584 [INFO ] STDOUT: !STACK 1
              2014-03-21 16:49:19,584 [INFO ] STDOUT: org.eclipse.ui.PartInitException: Warning: Detected recursive attempt by part de.cenit.eb.sm.finca.gui.pluginconfigurationview.view to create itself (this is probably, but not necessarily, a bug)
              2014-03-21 16:49:19,584 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:590)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at org.eclipse.ui.internal.ViewReference.getView(ViewReference.java:195)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage.findView(WorkbenchPage.java:1912)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at de.cenit.eb.sm.finca.gui.pluginconfigurationview.internal.handler.AbstractPluginConfigViewHandler.getPluginConfigView(AbstractPluginConfigViewHandler.java:197)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at de.cenit.eb.sm.finca.gui.pluginconfigurationview.internal.handler.AbstractPluginConfigViewHandler.getBaseEnabledState(AbstractPluginConfigViewHandler.java:224)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at de.cenit.eb.sm.finca.gui.pluginconfigurationview.internal.handler.DeletePluginConfigurationHandler.updateElement(DeletePluginConfigurationHandler.java:85)
              2014-03-21 16:49:19,585 [INFO ] STDOUT:  at org.eclipse.ui.internal.handlers.HandlerProxy.updateElement(HandlerProxy.java:469)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.commands.CommandService.registerElement(CommandService.java:308)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.commands.SlaveCommandService.registerElement(SlaveCommandService.java:299)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.commands.SlaveCommandService.registerElement(SlaveCommandService.java:299)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.commands.SlaveCommandService.registerElementForCommand(SlaveCommandService.java:287)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.menus.CommandContributionItem.<init>(CommandContributionItem.java:257)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.MenuAdditionCacheEntry.createCommandAdditionContribution(MenuAdditionCacheEntry.java:303)
              2014-03-21 16:49:19,586 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.MenuAdditionCacheEntry.createContributionItems(MenuAdditionCacheEntry.java:162)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.WorkbenchMenuService$5.run(WorkbenchMenuService.java:586)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.WorkbenchMenuService.processAdditions(WorkbenchMenuService.java:658)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.WorkbenchMenuService.addContributionsToManager(WorkbenchMenuService.java:746)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.WorkbenchMenuService.populateContributionManager(WorkbenchMenuService.java:732)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.SlaveMenuService.populateContributionManager(SlaveMenuService.java:202)
              2014-03-21 16:49:19,587 [INFO ] STDOUT:  at org.eclipse.ui.internal.menus.SlaveMenuService.populateContributionManager(SlaveMenuService.java:75)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:395)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:226)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:599)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:318)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:542)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:185)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:265)
              2014-03-21 16:49:19,588 [INFO ] STDOUT:  at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:64)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:479)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1262)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:678)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:585)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:573)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:269)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:980)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage.setPerspective(WorkbenchPage.java:3608)
              2014-03-21 16:49:19,589 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage.busySetPerspective(WorkbenchPage.java:1043)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage.access$16(WorkbenchPage.java:1027)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage$19.run(WorkbenchPage.java:3709)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:66)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.ui.internal.WorkbenchPage.setPerspective(WorkbenchPage.java:3707)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at de.cenit.eb.sm.finca.gui.application.base.AbstractPerspectiveSwitcherMenu$SwitchPerspectiveMenuListener.widgetSelected(AbstractPerspectiveSwitcherMenu.java:241)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.swt.events.SelectionEvent.dispatchToObserver(SelectionEvent.java:191)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.rwt.internal.events.Event.processEvent(Event.java:46)
              2014-03-21 16:49:19,590 [INFO ] STDOUT:  at org.eclipse.swt.events.TypedEvent.processEvent(TypedEvent.java:186)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.swt.events.TypedEvent.executeNext(TypedEvent.java:208)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.swt.widgets.Display.runPendingMessages(Display.java:1145)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:1135)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2733)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2694)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.internal.Workbench.access$5(Workbench.java:2530)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:702)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:685)
              2014-03-21 16:49:19,591 [INFO ] STDOUT:  at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:157)
              2014-03-21 16:49:19,592 [INFO ] STDOUT:  at de.cenit.eb.sm.finca.gui.application.fsm.Application.createUI(Application.java:92)
              2014-03-21 16:49:19,592 [INFO ] STDOUT:  at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle.createUI(RWTLifeCycle.java:177)
              2014-03-21 16:49:19,592 [INFO ] STDOUT:  at org.eclipse.rwt.internal.lifecycle.RWTLifeCycle$UIThreadController.run(RWTLifeCycle.java:289)
              2014-03-21 16:49:19,592 [INFO ] STDOUT:  at java.lang.Thread.run(Thread.java:738)
              2014-03-21 16:49:19,592 [INFO ] STDOUT:  at org.eclipse.rwt.internal.lifecycle.UIThread.run(UIThread.java:102)
              2014-03-21 16:49:19,592 [INFO ] STDOUT: !SUBENTRY 1 org.eclipse.rap.ui 4 0 2014-03-21 16:49:19.480
              2014-03-21 16:49:19,592 [INFO ] STDOUT: !MESSAGE Warning: Detected recursive attempt by part de.cenit.eb.sm.finca.gui.pluginconfigurationview.view to create itself (this is probably, but not necessarily, a bug)

              Regards,

              Carlos

            • cwoliveira
              cwoliveira
              25 Posts
              ACCEPTED ANSWER

              Re: Documentation for event integration via ECM SM Database access

              ‏2014-03-24T14:22:51Z  in response to juepo

              Juergen,

              Forget it. The options (events query / export / import) are there. I was looking on context (right-click) menu instead pull down menu.

              Regards,

              Carlos.

              • juepo
                juepo
                28 Posts
                ACCEPTED ANSWER

                Re: Documentation for event integration via ECM SM Database access

                ‏2014-03-24T16:32:21Z  in response to cwoliveira

                Carlos,

                That's good, nobody could explain this effect and was very puzzled.

                Regards,

                Juergen