My Oracle Support Banner

Unable To Add Data Controls To Task Flow In Spaces (Doc ID 1577943.1)

Last updated on APRIL 21, 2021

Applies to:

Oracle WebCenter Portal - Version and later
Information in this document applies to any platform.


Data Control query with bind variables (executed against MS Sql Server or other data sources) fails with errors.

Following error is reported in Spaces logs:

<TIMESTAMP> <Warning>
<BEA-000000> <Error Processing Data Control 'oracle.webcenter.siteresources.scopedMD.dataControl.s8bba98ff_4cbb_40b8_beee_296c916a23ed.DataControls.gsr54b75547_d039_4005_b6ab_89ef50b8d5eb'>
<TIMESTAMP> <Warning>
<BEA-000000> <oracle.jbo.InvalidOperException: JBO-25070: Where-clause param variable companyId needs ordinal index array.



- Start Managed Server with a JBO java property (jbo.SQLBuilder, with the value DB2 or SQLServer and jbo.TypeMapEntries="JAVA") to allow connection to a non-Oracle data source (MS SQL Server or DB2). Details documented in "Oracle® Fusion Middleware User's Guide for Oracle WebCenter Portal: Spaces" under the section "Prerequisites When Using a DB2 or SQL Server Database"

- Create a new Data Control to query from a data source.

Oracle WebCenter Portal Spaces
  => Administration (direct access URL http://<HOST>:<PORT>/webcenter/spaces/admin)
  => Resources
  => Data Controls
  => Create a new Data Control. Create a new JDBC connection or use an existing one. SQL Statement (query) must include a bind variable and connects to any data source (MS SQL Server, DB2, Oracle etc.).


  SELECT convert(varchar(30), companyName) companyName FROM
  Company WHERE companyId = (:CID)


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.