SAP Knowledge Base Article - Preview

1613617 - Error: "The ORDER BY clause is invalid (WIS 10901)"

Symptom

A database error occured. The database text is: 
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common tableexpressions, unless TOP or FOR XML is also specified. (WIS 10901)
  • ERROR: "The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common tableexpressions, unless TOP or FOR XML is also specified. (WIS 10901)"
  • While trying to create a Web Intelligence report based on Universe pointing to Sybase.
  • The Web Intelligence report contains Case statement which is used in WHERE clause that causes error.


Read more...

Environment

  • BusinessObjects Enterprise XI 3.1 Service Pack 3
  • Reporting Datasource: Sybase

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

WIS 10901, ORDER BY, Input Prompt values, Sybase boe xi 3.x 3.1 business objects , 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.