SAP Knowledge Base Article - Preview

1915978 - Error: 'It was not possible to retrieve the facets and their values. Can't retrieve the facets within the Explore tab. (PS 50004)' when reporting from Explorer connecting to HANA database

Symptom

  • When sorting measures in the Infospace using ‘Occurrences (row count)’ an error is received
  • Error: It was not possible to retrieve the facets and their values. Can't retrieve the facets within the Explore tab. (PS 50004)’
    com.businessobjects.datadiscovery.dataprovider.newdb.NewDBDataSourceProviderException: com.businessobjects.datadiscovery.dataprovider.newdb.NewDBDataSourceProviderException: The NewDB jdbc driver cannot execute the statement  : com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [xxx]: invalid column name: ALIAS_00000000: line x col xxx (at pos xxx)


Read more...

Environment

  • HANA SPS05 and SPS06
  • Business Intelligence Platform 4.1 SP1
  • Explorer 4.1 SP1

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Explorer 4.1

Keywords

KBA , BI-RA-EXP , Obsolete: Polestar, Explorer , Bug Filed

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.