Hinding columns in Spaces Data Control Causes Internal Server Error and javax.el.PropertyNotFoundException: Target Unreachable, Identifier 'vs' Resolved to Null

(Doc ID 1517833.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 24-Jun-2015

Symptoms

In WebCenter Spaces,  a page has Data Control mashup (SQL based). When attempting to  filter on the table,  the following error occurs:

Internal Error (WCS#2012.11.26.11.19.38)
If the error persists, report the problem to your administrator.

Click here to go to home

 
Log file WC_Spaces-diagnostic.log  shows:

 [2012-11-26T11:19:38.518+11:00] [WC_Spaces] [WARNING] [] [oracle.adfinternal.view.faces.lifecycle.LifecycleImpl] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 829e29b88fa8d3f8:-528ffc76:13adda254f5:-8000-000000000001ced4,0] [APP: webcenter#11.1.1.4.0] ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase APPLY_REQUEST_VALUES 2[[
 javax.el.PropertyNotFoundException: Target Unreachable, identifier 'vs' resolved to null
         at com.sun.el.parser.AstValue.getTarget(AstValue.java:84)
         at com.sun.el.parser.AstValue.isReadOnly(AstValue.java:149)
         at com.sun.el.ValueExpressionImpl.isReadOnly(ValueExpressionImpl.java:248)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer._getUncachedReadOnly(EditableValueRenderer.java:486)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.getReadOnly(EditableValueRenderer.java:400)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._hasPopupChooser(SimpleInputDateRenderer.java:837)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._setupPopupChooser(SimpleInputDateRenderer.java:1376)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer.decodeInternal(SimpleInputDateRenderer.java:75)
         at oracle.adfinternal.view.faces.renderkit.rich.LabeledInputRenderer.decodeInternal(LabeledInputRenderer.java:56)
         at oracle.adf.view.rich.render.RichRenderer.decode(RichRenderer.java:293)
         at org.apache.myfaces.trinidad.component.UIXComponentBase.__rendererDecode(UIXComponentBase.java:1118)
      ...... .
 .
 ]]
 [2012-11-26T11:19:38.519+11:00] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 829e29b88fa8d3f8:-528ffc76:13adda254f5:-8000-000000000001ced4,0] [APP: webcenter#11.1.1.4.0] [[
 javax.el.PropertyNotFoundException: Target Unreachable, identifier 'vs' resolved to null
         at com.sun.el.parser.AstValue.getTarget(AstValue.java:84)
         at com.sun.el.parser.AstValue.isReadOnly(AstValue.java:149)
         at com.sun.el.ValueExpressionImpl.isReadOnly(ValueExpressionImpl.java:248)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer._getUncachedReadOnly(EditableValueRenderer.java:486)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.getReadOnly(EditableValueRenderer.java:400)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._hasPopupChooser(SimpleInputDateRenderer.java:837)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._setupPopupChooser(SimpleInputDateRenderer.java:1376)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer.decodeInternal(SimpleInputDateRenderer.java:75)
         at oracle.adfinternal.view.faces.renderkit.rich.LabeledInputRenderer.decodeInternal(LabeledInputRenderer.java:56)
         at oracle.adf.view.rich.render.RichRenderer.decode(RichRenderer.java:293)
         at org.apache.myfaces.trinidad.component.UIXComponentBase.__rendererDecode(UIXComponentBase.java:1118)
         .....
 .
 ]]
 [2012-11-26T11:19:38.520+11:00] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp.internal.view.webapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 829e29b88fa8d3f8:-528ffc76:13adda254f5:-8000-000000000001ced4,0] [APP: webcenter#11.1.1.4.0] [[
 javax.el.PropertyNotFoundException: Target Unreachable, identifier 'vs' resolved to null
         at com.sun.el.parser.AstValue.getTarget(AstValue.java:84)
         at com.sun.el.parser.AstValue.isReadOnly(AstValue.java:149)
         at com.sun.el.ValueExpressionImpl.isReadOnly(ValueExpressionImpl.java:248)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer._getUncachedReadOnly(EditableValueRenderer.java:486)
         at oracle.adfinternal.view.faces.renderkit.rich.EditableValueRenderer.getReadOnly(EditableValueRenderer.java:400)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._hasPopupChooser(SimpleInputDateRenderer.java:837)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer._setupPopupChooser(SimpleInputDateRenderer.java:1376)
         at oracle.adfinternal.view.faces.renderkit.rich.SimpleInputDateRenderer.decodeInternal(SimpleInputDateRenderer.java:75)
         at oracle.adfinternal.view.faces.renderkit.rich.LabeledInputRenderer.decodeInternal(LabeledInputRenderer.java:56)
 



Steps to Reproduce:

  1. Create Data Control
    1.1. Login to Spaces
    1.2. Administration - Resources Tab - Under Mashups, Data Controls
    1.3. Create
    1.4. a. Enter password
        b. Enter SQL statement on a table that has date columns   e.g. select table_name, last_analyzed from  user_tables
        c. Name and Description
        d. Create
     
    1.5. Select the new Data Control, Edit and show
  2. Use Data Control
    2.1  Create Page. e.g. page98
    2.2 Add Content - Mash-Ups - Data Controls - Open the Data Control create above.
    2.3 There will be 3 items listed, Commit, Data Control create and Rollback
    2.4 On the Data Control , Select Add, Small pop up will display, select Table
    2.5 In the Create Table dialog:
          a. Select Table
          b. Behavior: Filtering
          c. Create   
    2.6  Save Page.
    2.7  Continue Editing , Edit the Data Control.  A popup dialog will display: "Component Properties: table1"
    2.8  Select Child Components Tab
    2.9  For the DATE column,  e.g. last_analyzed,  uncheck.
    2.10 OK
    2.11 SAVE and CLOSE
    2.12 View the Page,
    2.13 Above the Column name, in the  white box, enter a filter e.g. wc_l  and Enter
    2.14 Error is displayed.


Cause

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