How to Reset/Revert the WebCenter Page Customizations Due to Internal Server Error 500 When Trying to View or Edit a Page or If Page Cannot be Reset from Browser (Doc ID 1416074.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 and later
Information in this document applies to any platform.
Checked for relevance on 20-Jan-2015

Goal

This article explains how to  make changes to the page when it is not possible to edit the page from Spaces browser due to errors  or the System Pages cannot be reset using the 'Restore Default' option.
This scenario can occur under a few circumstances and this article shows 3 scenarios.

  1. Invalid Data entered on Content Presenter Task Flow (Possibly other task flows).

    a. Create Page.
    b. Add Content Presenter Task Flow.
    c. Edit the Task Flow properties ( the right most edit icon).
    d. Select Data Source Type: Query Expression.
    e. Data Source: select * from cmis_document where cmis_name like 'pdf'.
    f. Apply.
    g. "Internal Error" is displayed.
    h. Restart Spaces and login and re-edit the same page.
    i. "Internal Error" still persists.

    <Feb 16, 2012 4:24:25 PM EST> <Warning> <oracle.adfinternal.view.faces.lifecycle.LifecycleImpl> <BEA-000000> <ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase RESTORE_VIEW 1
    javax.el.ELException: Error Parsing: ${'select * from cmis_document where cmis_name like 'pdf''}
    at com.sun.el.lang.ExpressionBuilder.createNodeInternal(Unknown Source)
    at com.sun.el.lang.ExpressionBuilder.build(Unknown Source)
    at com.sun.el.lang.ExpressionBuilder.createValueExpression(Unknown Source)
    at com.sun.el.ExpressionFactoryImpl.createValueExpression(Unknown Source)
    at oracle.adf.share.el.OracleExpressionEvaluatorImpl.evaluate(OracleExpressionEvaluatorImpl.java:111)
    at oracle.adf.share.el.OracleExpressionEvaluatorImpl.evaluate(OracleExpressionEvaluatorImpl.java:69)
    at oracle.adf.model.binding.DCUtil.elEvaluate(DCUtil.java:821)

    Caused By: com.sun.el.parser.ParseException: Encountered "pdf" at line 1, column 55.
    Was expecting one of:
    "}" ...
    "." ...
    "[" ...
    ">" ...
    "gt" ...
    "<" ...
    "lt" ...
    ">=" ...
    "ge" ...
    "<=" ...
    "le" ...


  2. User Profile Page cannot be accessed and cannot even reset to defaults from Administration.
    Assuming you have NOT done these steps, Download the DesignWencenter and Extend Spaces samples and follow OTN white paper: Section "Sample - Customizing User Profiles "

    a. In Spaces Administration, Resource - Resource catalog , copy the Default home Space Catalog.
        Edit the Copy and add Component.
        Enter ADF to display (From Step 6.b of white paper) e.g.
             
    b. Administration - Configuration - change Resource Catalog for Home Space AND Resource Catalog for BRP to use the copied catalog.
    c. Administration - Pages - system Pages - CUSTOMIZE the My Profile page , ABOUT Tab: add the above created component.
    d. At this point, the browser will not work and you will get errors something like:

    <Feb 17, 2012 9:36:14 AM EST> <Warning> <oracle.adf.view.rich.component.fragment.UIXRegion> <ADF_FACES-00009> <Error processing viewId: /extended-profile/singleEditableView URI: /oracle/webcenter/peopleconnections/profile/view/jsf/regions/extended/singleEditableExtendedView.jsff actual-URI: /oracle/webcenter/peopleconnections/profile/view/jsf/regions/extended/singleEditableExtendedView.jsff.
    javax.el.PropertyNotFoundException: Target Unreachable, identifier 'wcProfileCustomAttribute' resolved to null
    at com.sun.el.parser.AstValue.getTarget(Unknown Source)
    at com.sun.el.parser.AstValue.isReadOnly(Unknown Source)


  3. In another case  the white paper mentioned in 2 above is implemented and everything is working. The component  is then changed from inputText to outputText.  The errors will be :

    javax.servlet.ServletException: OracleJSP error:
    oracle.jsp.parse.JspParseException: <br>/mdssys/site/webcenter/mdssys/oracle/webcenter/peopleconnections/profile/view/jsf/regions/ootbviews/viewbasic.jsff: Line # 6, &lt;af:outputText columns="40" id="e7649098031" maximumLength="50" shortDesc="Enter Division detail" simple="true" value="#{wcProfileCustomAttribute[(pageFlowScope.userId == null ? securityContext.userName : pageFlowScope.userId)].division}" xmlns:af="http://xmlns.oracle.com/adf/faces/rich"/> <br>Error: "columns" is not a valid attribute name.
    at oracle.jsp.runtimev2.JspReportUtil.reportException(JspReportUtil.java:181)
    at oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:694)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:385)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:802)


In any case, it may be not possible to reset the profile page to default or edit the page containing the task flow. The page may or may not be displayed and Internal Error displayed.  The errors may vary depending on the problem.


In the above cases :

  1. Errors in Content presenter : the syntax should be:
    select * from cmis_document where cmis_name like \'pdf\' (The single quote needs to be escaped using \)
  2. Errors with singleEditableExtendedView.jsff : The "wcProfileCustomAttribute" used in ADF tasgs does not exist becase the white paper mentioned in 2 above was not implemented.
  3. Errors with viewbasic.jsff : incorrect usage ADF Faces "outputText" tag. The outputText tag does not have "columns" attribute.

    What occurred was initiallly "inputText" was used with "columns" attribute and then later changed to outputText But "columns" attribute was not removed.
    Sometimes the page can be deleted and re-created.  But in cases where the page has lots of other components/portlets/task flows, the page cannot be  deleted and lose all the work.
    Since the page can be edited  in mds  using the following steps.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms