SAP Knowledge Base Article - Preview

3437537 - Error hierarchy generation function result is partially non-deterministic due to missing SIBLING ORDER BY clause

Symptom

  • While executing a query on a HANA View you get a blank report with the below warning message: 
    java.sql.SQLWarning: no row order on table set: hierarchy generation function result is partially non-deterministic due to missing SIBLING ORDER BY clause or missing ORDER BY clause in SOURCE specification


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB , SAP HANA Database , 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.