Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Wednesday, June 7, 2017

Smartview Ad hoc grid cannot be opened as there are no valid rows of data


In smarview when trying to do the ad-hoc analysis you may see the below error message:

Ad hoc grid cannot be opened as there are no valid rows of data
















Fix:

Under Data Options:
you should clear the suppress options in the Data Options tab of the Options dialog box. Ensure that all Suppress Rows and Suppress Columns options are cleared, and that the Suppress missing blocks option is cleared



3 comments:

Anonymous said...

Thanks! Super simple fix but only because i found this article!

Feeroz Khan said...

Thanks

Anonymous said...

Thank you it work!