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)