XQuery delete : XdtBufferOverflowException

Joey_Cz · September 16, 2003, 12:14am

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

Finn_the_Dane1 · September 16, 2003, 2:10pm

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 !
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

Joey_Cz · September 17, 2003, 10:26pm

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

Joey_Cz · September 17, 2003, 10:44pm

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)

Finn_the_Dane1 · September 18, 2003, 1:37pm

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

Joey_Cz · September 19, 2003, 9:20pm

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

Alfonso59 · December 17, 2003, 10:32pm

Hi, seems like my update Exception…

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

200 line Document