AnsweredAssumed Answered

Issue with ChangeClass in IBM Content Manager

Question asked by popeye on Nov 13, 2012
Latest reply on Nov 15, 2012 by popeye
Hi,
We are using OpenWorkdesk 3.2.0.1 that connects to IBM CM => we were testing the change class feature ==> this is basically working fine. But we saw that it is not working when there are attributes with foreign keys involved. Can this be solved by configuration?

Here is the stacktrace
   
Error Source: OECM
   java.lang.reflect.InvocationTargetException
      at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:600)
      at com.wewebu.ow.server.ui.OwAppContext.handleRequest(OwAppContext.java:1315)
      at com.wewebu.ow.server.app.OwMainAppContext.handleRequest(OwMainAppContext.java:642)
      at com.wewebu.ow.server.ui.OwWebApplication.handleRequest(OwWebApplication.java:352)
      at com.ibm._jsp._default20._jspService(_default20.java:102)
      at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
      at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
      at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121)
      at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:241)
      at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
      at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
      at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
      at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:275)
      at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
      at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
      at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
      at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
      at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
   at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
      at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
      at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
      at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1563)
   Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:600)
      at com.wewebu.ow.server.ui.OwNavigationView.navigate(OwNavigationView.java:301)
      at com.wewebu.ow.server.ui.OwNavigationView.onNavigate(OwNavigationView.java:407)
      … 33 more
   Caused by: com.wewebu.ow.server.exceptions.OwInvalidOperationException: Cannot change class.
      at com.wewebu.ow.server.plug.owdms.OwChangeClassDialogDocument.changeClass(OwChangeClassDialogDocument.java:142)
      at com.wewebu.ow.server.plug.owdms.OwChangeClassDialog.performChangeClass(OwChangeClassDialog.java:186)
      at com.wewebu.ow.server.plug.owdms.OwChangeClassDialog.onUpdate(OwChangeClassDialog.java:170)
      at com.wewebu.ow.server.ui.OwDocument.update(OwDocument.java:66)
      at com.wewebu.ow.server.dmsdialogs.views.OwObjectPropertyView.safeUpdate(OwObjectPropertyView.java:1336)
      at com.wewebu.ow.server.dmsdialogs.views.OwObjectPropertyView.onApply(OwObjectPropertyView.java:695)
      … 39 more
   Caused by: com.wewebu.ow.server.exceptions.OwInvalidOperationException: An error occurred on changing the document class.
      at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMObject.changeClass(OwIBMCMObject.java:645)
      at com.wewebu.ow.server.plug.owdms.OwChangeClassDialogDocument.changeClass(OwChangeClassDialogDocument.java:137)
      … 44 more
   Caused by: com.ibm.mm.sdk.common.DKUsageError: DGL3616A: An unexpected SQL error occurred;  ICM7015: During an SQL operation in the library server, an unexpected error occurred.  For details on the error, refer to the database document. (STATE) : [LS RC = 7015, SQL RC = 2291]
      at com.ibm.mm.sdk.server.dkAbstractItemCRUDICM.throwException(dkAbstractItemCRUDICM.java:663)
      at com.ibm.mm.sdk.server.PCreateItemICM.parseCreateReturnParameters(PCreateItemICM.java:211)
      at com.ibm.mm.sdk.server.PMoveObjectICM.moveObject(PMoveObjectICM.java:447)
      at com.ibm.mm.sdk.server.PMoveObjectICM.moveObject(PMoveObjectICM.java:389)
      at com.ibm.mm.sdk.server.DKDatastoreICM.moveObject(DKDatastoreICM.java:6380)
      at com.ibm.mm.sdk.server.DKDatastoreICM.moveObject(DKDatastoreICM.java:6316)
      at com.wewebu.ow.server.ecmimpl.ibmcm.OwIBMCMObject.changeClass(OwIBMCMObject.java:622)
      … 45 more

Thank you so much - any help is appreciated…

Outcomes