Symptom
When creating an Oracle linked server on a SQL Server database, if a Web Intelligence report"s data source is on the linked server the following error message appears when refreshing the report:
Database error: [Microsoft][SQL Native Client][SQL Server]The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform
- Information Design Tool (IDT)
- Universe Design Tool (UDT)
- Web Intelligence (WEBI)
Product
Keywords
Linked Server, data source linking to an Oracle database , KBA , BI-RA-WBI , Web Intelligence , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.