webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

TN Profile import: cannot insert null key

  • 1.  TN Profile import: cannot insert null key

    Posted Tue September 12, 2006 03:34 PM

    Hi all

    I have some trouble imorting TN profile data from 1 server to another.
    Both systems are running webMethods 6.5.

    Does anyone have a clue what might cause the following error?
    The databases looks the same.

    I get the following error message:

    ErrorMessage:
    TRNCONS.000000.000002
    ERROR






    ImportExportDialog
    doImport
    Tue Sep 12 15:28:44 CEST 2006
    [BAC.0001.0060] RuntimeException: cannot insert null key


    com.wm.ui2.UiException: wm.tn:importData

    com.wm.util.BasisRuntimeException [BAC.0001.0060] RuntimeException: cannot insert null key
    null
    wm.tn:importData
    com.wm.util.BasisRuntimeException [BAC.0001.0060] RuntimeException: cannot insert null key
    null
    null

    com.wm.ui2.UiException: wm.tn:importData

    com.wm.util.BasisRuntimeException [BAC.0001.0060] RuntimeException: cannot insert null key
    at com.wm.ui2.UiException.handle(UiException.java:215)
    at com.wm.ui2.UiException.handle(UiException.java:184)
    at com.wm.app.tn.ui.Server.invoke(Server.java:379)
    at com.wm.app.tn.ui.importexport.ImportExportDialog.doImport(ImportExportDialog.java:328)
    at com.wm.app.tn.ui.importexport.ImportExportDialog.okActionPerformed(ImportExportDialog.java:197)
    at com.wm.app.tn.ui.util.swing.TNDialog.actionPerformed(TNDialog.java:181)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
    at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
    at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
    at java.awt.Component.processMouseEvent(Component.java:5100)
    at java.awt.Component.processEvent(Component.java:4897)
    at java.awt.Container.processEvent(Container.java:1569)
    at java.awt.Component.dispatchEventImpl(Component.java:3615)
    at java.awt.Container.dispatchEventImpl(Container.java:1627)
    at java.awt.Component.dispatchEvent(Component.java:3477)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
    at java.awt.Container.dispatchEventImpl(Container.java:1613)
    at java.awt.Window.dispatchEventImpl(Window.java:1606)
    at java.awt.Component.dispatchEvent(Component.java:3477)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
    at java.awt.Dialog$1.run(Dialog.java:540)
    at java.awt.Dialog.show(Dialog.java:561)
    at com.wm.app.tn.ui.TNMainFrame$7.run(TNMainFrame.java:317)
    at com.wm.app.tn.ui.TNMainFrame.askToSave(TNMainFrame.java:1194)
    at com.wm.app.tn.ui.TNMainFrame$6.actionPerformed(TNMainFrame.java:310)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
    at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
    at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
    at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
    at java.awt.Component.processMouseEvent(Component.java:5100)
    at java.awt.Component.processEvent(Component.java:4897)
    at java.awt.Container.processEvent(Container.java:1569)
    at java.awt.Component.dispatchEventImpl(Component.java:3615)
    at java.awt.Container.dispatchEventImpl(Container.java:1627)
    at java.awt.Component.dispatchEvent(Component.java:3477)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
    at java.awt.Container.dispatchEventImpl(Container.java:1613)
    at java.awt.Window.dispatchEventImpl(Window.java:1606)
    at java.awt.Component.dispatchEvent(Component.java:3477)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)



    wm.tn:importData

    com.wm.util.BasisRuntimeException
    [BAC.0001.0060] RuntimeException: cannot insert null key
    com.wm.util.BasisException: [BAC.0001.0060] RuntimeException: cannot insert null key
    at com.wm.util.BasisRuntimeException.(BasisRuntimeException.java:46)
    at com.wm.util.data.MemData$Cursor.insertAfter(MemData.java(Compiled Code))
    at com.wm.data.ValuesEmulator.put(ValuesEmulator.java:178)
    at com.wm.app.tn.db.Import.installProfiles(Import.java:489)
    at com.wm.app.tn.db.Import.installData(Import.java:106)
    at wm.tn.adminimpl.importData(adminimpl.java:1042)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
    at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:322)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:612)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:226)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:407)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:369)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
    at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:168)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:298)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
    at java.lang.Thread.run(Thread.java:568)




    Regards
    Mikael


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: TN Profile import: cannot insert null key

    Posted Fri September 22, 2006 07:34 AM

    Hi Mikael,

    My experience was that I had to make sure I HAD all the dependants before I import my TN profile.

    Hope this help.

    Cheers,
    v8mirage


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods