Oracle Logical Standby as data source

Post Author: garyreit

CA Forum: Data Connectivity and SQL

Has anyone succesfully used an Oracle Logical Standby server as a

data source? When I try I get "table not found" for all the

tables in Crystal reports, but the report runs fine. When I run

the same report in BOE, The report fails with the error:Error in File D:\Program Files\Business Objects\BusinessObjects

Enterprise

11.5\Data\procSched\biapp1.reportjobserver\~tmp1c4c50845f07b62.rpt:

Error in formula <Record Selection>.

'{PS_CANC_TERM_CLASS.BATCH_ID} = {?Batch ID} and

'

This field name is not known.

Details: errorKind We are using BOE XI R2 sp2 and Oracle 10g with an ODBC using the Oracle connector.

Any Ideas?Thanks