SAP Knowledge Base Article - Preview

2260663 - Error "Invalid join type used with Transact-SQL outer join." occurs when refreshing a Webi report that uses Sybase or SQLServer as data source in BI 4.1

Symptom

  • Error "Invalid  join type used with Transact-SQL outer join." occurs when refreshing a Webi report that uses Sybase or SQLServer as data source in BI 4.1
  • This issue occurs on unx, unv or both, which depends the configuration of the prm files.
  • This issue may occur on different kinds of middlewares(odbc, oledb, jdbc and etc.), which also depends the configuration of the prm files.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform (BI) 4.1
  • Web Intelligence (Webi)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

BOE,BO4,BO41,BO40,BI40,BO41,4.0,connectionserver,cs, idt,unv,unx,udt,outer,join,1289950,odbc,sybase,ssa,outer_join,outerjoin,ourterleft,outerright,T-SQL,ANSI92,SQL,sqlanywhere,IQ,Database error,IES 10901,Error:INF,INF  , KBA , BI-BIP-SL , Semantic Layer , 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.