Issue with ChangeClass in IBM Content Manager

[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…

[vahe]

Hi,

in fact there is a problem with Change Class (Item-Type change) in IBM Content Manager,  with Item-Types that contains Foreign Key attributes.. (Internal Jira Ticket OWD-4389 and OWD-2579).

The fix will be available in OWD 3.2.0.3 Final and OWD 4.0.0.0 Final.

For the OWD 3.2.0.3 Final we do not have an official Release date.
The OWD 4.0.0.0 Final was released on 30.Oct.2012.

Please send me a private message with your email, so I can send you a pre-release of the OpenWorkdesk 3.2.0.3 Version.

Best regards,

[popeye]

Thanks for the temporary fix…it works fine, so I wait for the official release.

Bye 🙂