SAP Hana Mini Checks.

[Former Member]

I have run the Hana mini checks last week..
Is there a NOTE to reference some of the data responses?
One of the responses says critical but does not reference an SAP note..

CHID;DESCRIPTION;HOST;VALUE;EXPECTED_VALUE;C;SAP_NOTE

;;;189467;<= 100000;X;

Not sure what it is referencing as there in no description or host and just a bunch of the same from row 217 to 1000.. Which may be more as eclipse only allows for up to 1000 rows...

there is an AUTO merge table withmany delta records but it is not one of my tables and I cannot seem to find it?  Any help with finding this table would be insightful,

THank you for your time and diligence.

HANA_Configuration_MiniChecks_Rev90+_ESS

HANA 102 on AWS Linux SUSE SERVER 11 sp3

[lbreddemann · Accepted solution]

Just ran the scripts from the current SAP note version and had no issues.

There's also a mini-check version for SAP HANA rev. 100+, so you might want to use this one instead.

[Former Member · Accepted solution]

Yes sir.. I figured out the issue about the TEMPORARY_TABLE query with the COUNT(*)
..

I ended up running the TEMPORARY_TABLE query manually.. Took that value and replace COUNT(*) with that value..

Updated Hana Studio and web IDE with larger Result set value 2000..

Got the rest of the data i believe..

Fixing critical Issues.. One at a time.
Thanks Thanks!

[Former Member]

Don't run the mini checks and then filter for C= 'X' as you will loose information. Better run the mini checks with ONLY_POTENTIALLY_CRITICAL_RESULTS = 'X' in the "Modification section" if you only want to see the potentially critical lines. Then you won't loose information.

[Former Member]

Thanks thanks,

I did filter on that once and realized that a lot of the data about the issues was not in its proper place..

Thank you for your time and diligence,
-Z-

[Former Member]

For completeness sake.. I had a question regarding a table with large delta merge, which I could not find.
The table in question was a clients table and was found by

SELECT * FROM M_CS_TABLES WHERE TABLE_NAME = 'Fanprofile_Staging'

Good news!
Continue to be diligent!