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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.