Weblogic Portal – Create Streaming Desktop Page Definition Error
| Posted by watashii | Filed under Java, Programming, Web
Got the following error when (re)creating a streaming desktop from an updated .portal file, using the Create Desktop Wizard on Portal Admin Console.
javax.ejb.EJBException: SQL Error while trying to createPageDefinition: SQL [insert into PF_PAGE_DEFINITION ( PAGE_DEFINITION_ID, MARKUP_DEFINITION_ID, IS_PUBLIC, IS_HIDDEN, INTERSECTION_ID, PAGE_LABEL, WEBAPP_NAME) values (?,?,?,?,?,?,?)] database error code [25,222] SQL state [22028] .; nested exception is: java.sql.SQLException: Data exception -- row already exist in index AX1_PAGE_DEF on table PF_PAGE_DEFINITION.
To temporarily bypass this error this so the streaming desktop can be created with the wizard, remove all the Pages manually from the Library.
The problem is one of the Page definition(s) in the .portal file is corrupted which prevents the library page resource from being refreshed. You will need to work out which page is causing the problem, then the redo the page in the .portal file via Weblogic Portal Workshop.
Tags: error, portal, streaming desktop, weblogic
