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…
