IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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

Batch Insert Adapter Service :: ERROR

  • 1.  Batch Insert Adapter Service :: ERROR

    Posted Mon May 09, 2011 10:17 PM

    I am trying to create a batch insert adapter service and i am getting the below error

    Database :Oracle9i
    Database Driver : ojdbc14.zip
    webMethods Server : webMethods 8 on Solaris
    JVM Version : 1.6.0_19
    JDBC Adapter : 6.5 (JDBC_6.5_Fix24)

    Adapter Connection details
    DataSource Class: oracle.jdbc.pool.OracleDataSource
    Transaction Type :LOCAL_TRANSACTION
    portNumber :1521
    networkProtocol :TCP
    Other Properties :driverType=thin


    ERROR


    com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
    [ADA.1.319] Cannot get the list of table columns. "
    (42000/904) ORA-00904: “T”.“DATA_DEFAULT”: invalid identifier
    "
    ORA-00904: “T”.“DATA_DEFAULT”: invalid identifier

    on tables.columnInfo [Ljava.lang.String;@194ae28

    java.lang.Exception: Adapter values are not available.

    The complete Stack trace
    ava.lang.Exception: Adapter values are not available.
    at com.webMethods.developer.adapter.metadata.AdapterMetadataException.(AdapterMetadataException.java:57)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.assertNoErrorString(AdapterMetadataParameterValue.java:3796)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.getValidValuesInternal(AdapterMetadataParameterValue.java:3681)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmIndexMapArrayValueInternal(AdapterMetadataParameterValue.java:3104)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmValueInternal(AdapterMetadataParameterValue.java:3296)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmValue(AdapterMetadataParameterValue.java:2880)
    at com.webMethods.developer.adapter.metadata.AdapterMetadata.confirmAll(AdapterMetadata.java:2098)
    at com.webMethods.developer.adapter.metadata.AdapterMetadata.notifyOfParameterValueChange(AdapterMetadata.java:2014)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.setValueInternal(AdapterMetadataParameterValue.java:1518)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.setValueInternal(AdapterMetadataParameterValue.java:1401)
    at com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.setValue(AdapterMetadataParameterValue.java:1349)
    at com.webMethods.developer.adapter.editor.ASEAbstractTableModel.setValueAt(ASEAbstractTableModel.java:468)
    at com.webMethods.developer.adapter.editor.ASEAbstractTable.setValueAt(ASEAbstractTable.java:308)
    at com.webMethods.developer.adapter.editor.SetSequenceParameterValueAction.(ConfigEditor.java:605)
    at com.webMethods.developer.adapter.editor.ConfigEditor.setSequenceValue(ConfigEditor.java:408)
    at com.webMethods.developer.adapter.editor.ASEMapTable$ComboTreeCellEditor.fireEditingStopped(ASEMapTable.java:225)
    at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(DefaultCellEditor.java:350)
    at javax.swing.DefaultCellEditor.stopCellEditing(DefaultCellEditor.java:215)
    at javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:367)
    at com.webMethods.developer.adapter.editor.UiComboTree.fireEditingStopped(UiComboTree.java:715)
    at com.webMethods.developer.adapter.editor.UiComboTree.stopCellEditing(UiComboTree.java:691)
    at com.webMethods.developer.adapter.editor.UiComboTree.doFinishEdit(UiComboTree.java:498)
    at com.webMethods.developer.adapter.editor.ComboTreeField.doChangeSelection(ComboTreeField.java:168)
    at com.webMethods.developer.adapter.editor.ComboTreeField.doChangeSelection(ComboTreeField.java:176)
    at com.webMethods.developer.adapter.editor.UiComboTree$6.valueChanged(UiComboTree.java:356)
    at javax.swing.JTree.fireValueChanged(JTree.java:2820)
    at javax.swing.JTree$TreeSelectionRedirector.valueChanged(JTree.java:3191)
    at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(DefaultTreeSelectionModel.java:629)
    at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(DefaultTreeSelectionModel.java:1078)
    at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(DefaultTreeSelectionModel.java:287)
    at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(DefaultTreeSelectionModel.java:170)
    at javax.swing.JTree.setSelectionPath(JTree.java:1598)
    at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(BasicTreeUI.java:2311)
    at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(BasicTreeUI.java:3520)
    at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(BasicTreeUI.java:3459)
    at java.awt.Component.processMouseEvent(Component.java:6260)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    at java.awt.Component.processEvent(Component.java:6028)
    at java.awt.Container.processEvent(Container.java:2041)
    at java.awt.Component.dispatchEventImpl(Component.java:4630)
    at java.awt.Container.dispatchEventImpl(Container.java:2099)
    at java.awt.Component.dispatchEvent(Component.java:4460)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4235)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
    at java.awt.Container.dispatchEventImpl(Container.java:2085)
    at java.awt.Window.dispatchEventImpl(Window.java:2478)
    at java.awt.Component.dispatchEvent(Component.java:4460)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    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)


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