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

  • 1.  XQuery delete : XdtBufferOverflowException

    Posted Mon September 15, 2003 08:14 PM

    Hi,
    i’m trying to delete all documents of a certain DocType in a collection. I get a XdtBufferOverflowException when performing the update query. This only seems to happen when there are lots of documents (~500 it seems) of that Doctype in the collection.
    The only way i’m able to delete the documents in the collection is if i delete the Collection itself. This is really bothersome because i haveto re-import the schemas every time.

    –joey


      
NestedException:Tamino access failure (INOXME8599, Internal error, XdtBufferOverflowException)
Tamino access failure (INOXME8599, Internal error, XdtBufferOverflowException)

-XML-Stacktrace of class com.softwareag.tamino.db.api.common.TAccessFailureException--------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<exception java="1.3.1_07" name="com.softwareag.tamino.db.api.common.TAccessFailureException" os="Linux 2.4.9-e.3enterprise" tag="JavaTaminoAPI_4_1_4_42">
<message>
<text>Tamino access failure (INOXME8599, Internal error, XdtBufferOverflowException)</text>
<additional>
<returnValue>8599</returnValue>
<code>INOXME8599</code>
<text>Internal error</text>
<line>XdtBufferOverflowException</line>
</additional>
</message>
<stacktrace>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.newAccessFailureException(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.verify(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.verifyXQueryResponse(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TXMLObjectAccessorImpl.xquery(Unknown Source</at>
<at>com.softwareag.xtools.basic.ta.TaAccessorImpl.xqueryForXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.open(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.updateChildren(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.QueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XMLQueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XQueryImpl.execute(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanelModel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorComponent.actionPerformed(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.common.AbstractSharedAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.trigger(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.actionPerformed(Unknown Source</at>
<at>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1445</at>
<at>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1499</at>
<at>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:373</at>
<at>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:245</at>
<at>javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:211</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.Component.processMouseEvent(Component.java:3710</at>
<at>java.awt.Component.processEvent(Component.java:3539</at>
<at>java.awt.Container.processEvent(Container.java:1159</at>
<at>java.awt.Component.dispatchEventImpl(Component.java:2588</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1208</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451</at>
<at>java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216</at>
<at>java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1195</at>
<at>java.awt.Window.dispatchEventImpl(Window.java:923</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.EventQueue.dispatchEvent(EventQueue.java:334</at>
<at>com.softwareag.xtools.common.standard.awt.WaitCursorEventQueue.dispatchEvent(Unknown Source</at>
<at>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:126</at>
<at>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:93</at>
<at>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:88</at>
<at>java.awt.EventDispatchThread.run(EventDispatchThread.java:80</at>
</stacktrace>
</exception>



-XML-Stacktrace of class com.softwareag.tamino.db.api.accessor.TXQueryException--------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<exception java="1.3.1_07" name="com.softwareag.tamino.db.api.accessor.TXQueryException" os="Linux 2.4.9-e.3enterprise" tag="JavaTaminoAPI_4_1_4_42">
<message/>
<stacktrace>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.verifyXQueryResponse(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TXMLObjectAccessorImpl.xquery(Unknown Source</at>
<at>com.softwareag.xtools.basic.ta.TaAccessorImpl.xqueryForXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.open(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.updateChildren(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.QueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XMLQueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XQueryImpl.execute(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanelModel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorComponent.actionPerformed(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.common.AbstractSharedAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.trigger(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.actionPerformed(Unknown Source</at>
<at>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1445</at>
<at>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1499</at>
<at>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:373</at>
<at>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:245</at>
<at>javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:211</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.Component.processMouseEvent(Component.java:3710</at>
<at>java.awt.Component.processEvent(Component.java:3539</at>
<at>java.awt.Container.processEvent(Container.java:1159</at>
<at>java.awt.Component.dispatchEventImpl(Component.java:2588</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1208</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451</at>
<at>java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216</at>
<at>java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1195</at>
<at>java.awt.Window.dispatchEventImpl(Window.java:923</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.EventQueue.dispatchEvent(EventQueue.java:334</at>
<at>com.softwareag.xtools.common.standard.awt.WaitCursorEventQueue.dispatchEvent(Unknown Source</at>
<at>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:126</at>
<at>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:93</at>
<at>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:88</at>
<at>java.awt.EventDispatchThread.run(EventDispatchThread.java:80</at>
</stacktrace>
<exception java="1.3.1_07" name="com.softwareag.tamino.db.api.common.TAccessFailureException" os="Linux 2.4.9-e.3enterprise" tag="JavaTaminoAPI_4_1_4_42">
<message>
<text>Tamino access failure (INOXME8599, Internal error, XdtBufferOverflowException)</text>
<additional>
<returnValue>8599</returnValue>
<code>INOXME8599</code>
<text>Internal error</text>
<line>XdtBufferOverflowException</line>
</additional>
</message>
<stacktrace>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.newAccessFailureException(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.verify(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TAccessFailureVerifier.verifyXQueryResponse(Unknown Source</at>
<at>com.softwareag.tamino.db.api.accessor.TXMLObjectAccessorImpl.xquery(Unknown Source</at>
<at>com.softwareag.xtools.basic.ta.TaAccessorImpl.xqueryForXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.open(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.AbstractInstanceGroupImpl.updateChildren(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.QueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XMLQueryResultImpl.<init>(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.CollectionImpl.xqueryXML(Unknown Source</at>
<at>com.softwareag.xtools.basic.dm.XQueryImpl.execute(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanelModel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorPanel.executeQuery(Unknown Source</at>
<at>com.softwareag.xtools.xquery.editor.XQueryEditorComponent.actionPerformed(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.common.AbstractSharedAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.fireActionEvent(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.trigger(Unknown Source</at>
<at>com.softwareag.xtools.common.framework.service.menuaction.MenuAction.actionPerformed(Unknown Source</at>
<at>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1445</at>
<at>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1499</at>
<at>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:373</at>
<at>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:245</at>
<at>javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:211</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:225</at>
<at>java.awt.Component.processMouseEvent(Component.java:3710</at>
<at>java.awt.Component.processEvent(Component.java:3539</at>
<at>java.awt.Container.processEvent(Container.java:1159</at>
<at>java.awt.Component.dispatchEventImpl(Component.java:2588</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1208</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451</at>
<at>java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216</at>
<at>java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125</at>
<at>java.awt.Container.dispatchEventImpl(Container.java:1195</at>
<at>java.awt.Window.dispatchEventImpl(Window.java:923</at>
<at>java.awt.Component.dispatchEvent(Component.java:2492</at>
<at>java.awt.EventQueue.dispatchEvent(EventQueue.java:334</at>
<at>com.softwareag.xtools.common.standard.awt.WaitCursorEventQueue.dispatchEvent(Unknown Source</at>
<at>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:126</at>
<at>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:93</at>
<at>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:88</at>
<at>java.awt.EventDispatchThread.run(EventDispatchThread.java:80</at>
</stacktrace>
</exception>
</exception>



    X-Application Version: 4.1.1
    Tamino Version : 4.1.1
    Platform : Win2k
    WebContainer : Tomcat 4.1.24
    JDK Version : 1.4.1


    #API-Management
    #Tamino
    #webMethods


  • 2.  RE: XQuery delete : XdtBufferOverflowException

    Posted Tue September 16, 2003 10:11 AM

    Hi Joey,
    It’s infinitely much faster to undefine a collection and/or doctype than deleting it’s individual documents.
    Quite similar to SQL “drop table”
    Just remember to have a copy of the schema ! :wink:
    I usually do it by loading the schema into the schema-editor, choose “undefine” and the define right afterwards. - a matter of a few seconds.

    Finn


    #webMethods
    #API-Management
    #Tamino


  • 3.  RE: XQuery delete : XdtBufferOverflowException

    Posted Wed September 17, 2003 06:26 PM

    Hey Finn,
    I agree, it would go much faster that is if i wouldnt haveto programatically remove elements of a certain docType.
    I just tied your suggestion, to undefine the schema using the schema-editor, for now. Unfourtunately I get another error message
    Internal error: invalid object ID specification

    seems like a serious internal error.

    –joey

    X-Application Version: 4.1.1
    Tamino Version : 4.1.1
    Platform : Win2k
    WebContainer : Tomcat 4.1.24
    JDK Version : 1.4.1


    #webMethods
    #Tamino
    #API-Management


  • 4.  RE: XQuery delete : XdtBufferOverflowException

    Posted Wed September 17, 2003 06:44 PM

    I finaly managed to delete all the documents in my collected for the docType in question, but i still cannot undefined the Schema. The error message I get remains the same Internal error: invalid object ID specification

    now i’m starting to wornder if something is wrong with my schema document, although the schema editor shows that its correct and allows me to define it in Tamino.

    I have attached it to this post.

    –joey

    X-Application Version: 4.1.1
    Tamino Version : 4.1.4.1
    Platform : Linux
    WebContainer : Tomcat 4.1.24
    JDK Version : 1.4.1

    TaxonomyElement-dynamicComposition.tsd (5.62 KB)


    #API-Management
    #webMethods
    #Tamino


  • 5.  RE: XQuery delete : XdtBufferOverflowException

    Posted Thu September 18, 2003 09:38 AM

    I just found the following entry in SAGSIS
    this is also described in SI508390 in Servline24
    So you’ll have to change the objectref in the schema before you can undelete.
    -----------
    The problem is caused by an internal error: the deleted node will be
    read one again, which results in INOXRE8823.
    The problem only occurs if the referenced node is the doctype to be
    deleted. That’s why there is a workaround to undefine the doctype
    nevertheless:
    - Execute an update-define: change the invalid node reference
    tsd:nodeRefScreen/Discription</tsd:nodeRef>
    so that it points to another doctype, for instance:
    tsd:nodeRefImage/Discription</tsd:nodeRef>
    ----------
    Finn


    #Tamino
    #webMethods
    #API-Management


  • 6.  RE: XQuery delete : XdtBufferOverflowException

    Posted Fri September 19, 2003 05:20 PM

    Thanks Finn,
    i did have an object ref in my schema that i have forgotten to delete. That was causing the problem.


    –joey

    X-Application Version: 4.1.1
    Tamino Version : 4.1.4.1
    Platform : Linux
    WebContainer : Tomcat 4.1.24
    JDK Version : 1.4.1


    #API-Management
    #Tamino
    #webMethods


  • 7.  RE: XQuery delete : XdtBufferOverflowException

    Posted Wed December 17, 2003 05:33 PM

    Hi, seems like my update Exception…

    NestedException:Tamino access failure (INOXME8599, Internal error, Line 4, Column 26: XdtBufferOverflowException)

    200 line Document


    #Tamino
    #API-Management
    #webMethods


Related Content