Hi Guys,

I’m trying to delete an old project and start anew, however when I try to delete my Portlet from Folders>System>Portlets using the tools link. I get the following error.

java.sql.SQLException: [wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (DEV5BPM.PK_TBLTHINGARCHIVE) violated

at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeUpdate(BaseSqlWorker.java:261)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeUpdate(BaseSqlWorker.java:223)
at com.webmethods.portal.service.sql.runtime.oracle.ThingDeactivate.executeUpdate(ThingDeactivate.java:66)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeUpdateProc(BaseSqlWorker.java:851)
at com.webmethods.portal.service.meta2.thing.impl.Thing.deactivate(Thing.java:164)
at com.webmethods.portal.service.meta2.thing.impl.Thing.deactivate(Thing.java:185)
at com.webmethods.portal.service.meta2.thing.impl.Thing.delete(Thing.java:219)
at com.webmethods.portal.mech.storage.impl.BasicMechanics.delete(BasicMechanics.java:2373)
at com.webmethods.portal.bizPolicy.command.meta.DeleteCommand.delete(DeleteCommand.java:219)
at com.webmethods.portal.bizPolicy.command.meta.DeleteCommand.delete(DeleteCommand.java:102)
at com.webmethods.portal.bizPolicy.command.meta.DeleteCommand.handle(DeleteCommand.java:69)
at com.webmethods.portal.framework.dispatch.handlers.system.CommandHandler.handle(CommandHandler.java:105)
at com.webmethods.portal.framework.dispatch.DispatchManager.handle(DispatchManager.java:438)
at com.webmethods.portal.framework.dispatch.DispatchManager.handleDispatch(DispatchManager.java:371)
at com.webmethods.portal.framework.impl.PortalServlet.service(PortalServlet.java:242)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.webmethods.portal.framework.impl.NTLMFilter.doFilter(NTLMFilter.java:50)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at com.webmethods.caf.faces.servlet.GZIPFilter.doFilter(GZIPFilter.java:34)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at com.webmethods.portal.webApplication.WmWebAppContext.handle(WmWebAppContext.java:159)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

Can anyone help me get this portlet deleted?