Hiding 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 06, 2023

Applies to:

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:

 [<TIMESTAMP>] [WC_Spaces] [WARNING] [] [oracle.adfinternal.view.faces.lifecycle.LifecycleImpl] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [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)
      ...... .
 .
 ]]
 [<TIMESTAMP>] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [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)
         .....
 .
 ]]
 [<TIMESTAMP>] [WC_Spaces] [ERROR] [] [oracle.webcenter.webcenterapp.internal.view.webapp] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [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