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 11.1.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
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>
<oracle.webcenter.datacomposer.internal.adapter.datacontrol.DataControlContext>
<BEA-000000> <Error Processing Data Control 'oracle.webcenter.siteresources.scopedMD.dataControl.s8bba98ff_4cbb_40b8_beee_296c916a23ed.DataControls.gsr54b75547_d039_4005_b6ab_89ef50b8d5eb'>
<TIMESTAMP> <Warning>
<oracle.webcenter.datacomposer.internal.dapter.datacontrol.DataControlContext>
<BEA-000000> <oracle.jbo.InvalidOperException: JBO-25070: Where-clause param variable companyId needs ordinal index array.
Changes
- 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.).
Example:
SELECT convert(varchar(30), companyName) companyName FROM Company WHERE companyId = (:CID)
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |