Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Issue with deleting a page in the websphere portal server

14 views
Skip to first unread message

Anitha

unread,
Nov 13, 2008, 8:17:11 AM11/13/08
to
Hi All,

I was doing a clean-up of the portlets and pages created by the team. I could delete all the pages except one label and a page under that label . When i tried to delete these pages, i get the following execption in the log.

EJPDB0001E: Error occurred during database access. Last SQL statement is [DELETE FROM PAGE_INST WHERE ((OID = ?) AND
(MODIFIED = ?))].
com.ibm.wps.util.DataBackendException: EJPDB0001E: Error occurred during database access. Last SQL statement is [DELETE FROM
PAGE_INST WHERE ((OID = ?) AND (MODIFIED = ?))].
at com.ibm.wps.datastore.impl.DataStoreContext.handleException(DataStoreContext.java:135)
at com.ibm.wps.datastore.impl.ResourcePersister.deleteInternal(ResourcePersister.java:586)
at com.ibm.wps.datastore.impl.ResourcePersister.delete(ResourcePersister.java:633)
at com.ibm.wps.datastore.impl.ResourceImpl.delete(ResourceImpl.java:135)
at com.ibm.wps.datastore.impl.PageInstanceImpl.delete(PageInstanceImpl.java:938)
at com.ibm.wps.datastore.impl.PageInstanceCacheWrapper.delete(PageInstanceCacheWrapper.java:399)
at com.ibm.wps.datastore.impl.ResourceCleanerImpl.cleanupPageInstances(ResourceCleanerImpl.java:639)
at com.ibm.wps.datastore.impl.ResourceCleanerImpl.deleteUnregisteredPageTree(ResourceCleanerImpl.java:267)
at com.ibm.wps.command.util.CompositionUtil.cleanupCompositionTree(CompositionUtil.java:341)


SQL Exception: DELETE on table 'PAGE_INST' caused a violation of foreign key constraint 'FK280E' for key (302). The statement
has been rolled back.
ERROR 23501: DELETE on table 'PAGE_INST' caused a violation of foreign key constraint 'FK280E' for key (302).
The statement has been rolled back.
at db2j.dl.b.newException(Unknown Source)
at db2j.v.bz._gs(Unknown Source)
at db2j.v.at.doPKCheck(Unknown Source)
at db2j.v.z.runFkChecker(Unknown Source)
at db2j.v.q.runFkChecker(Unknown Source)
at db2j.v.q.open(Unknown Source)
at db2j.br.e.execute(Unknown Source)
at db2j.ai.m.executeStatement(Unknown Source)
at db2j.ai.p.executeStatement(Unknown Source)


I am not able to find out the dependencies. Please let me know what could be the possible cause for this exception.

Thanks and Regards,
Anitha.

0 new messages