TSAP 3.2.0.96 ( HANA ) do not show views under explorer

Toad for SAP Solutions
1

Hi,

I have installed TSAP 3.2

And in the explorer, all tabs are ok,

but the “views” tab do not show any views.

Parallel with TSAP 3.1 I can see all views.

There is no filter on “views” tab

Holger

2

Hi,

I tried it with TSAP 3.2 (64bit) and HANA 12. I am able get all views without any problem.

Can you tell us what version of HANA are you use? Can you also check (or send to me) ExceptionTrace.log (TSAP -> About -> Application Data Directory).

Filip

3

Hi,

HANA Version 1.00.102.02…

With TSAP 3.1 it works.

This is the error from “ExceptionTrace.log”.

New exception: 21.07.2017 10:14:15

System.IndexOutOfRangeException: Column HAS_STRUCTURED_PRIVILEGE_CHECK doesn’t exist

Stack trace:

Server stack trace:
at Quest.FastData.FastRow.get_Item(String columnName)
at Quest.Toad.SAPHana.Trl.SAPHana.View.ViewListTrl.CreateTrl(FastRow row)
at Quest.Toad.Trl.SqlTrl.FilterToTrls(FilterInfo info, FastTable table, Boolean bSorted, Int32 offset, Int32 maxCount)
at Quest.Toad.Trl.SqlTrl.GetFilteredTrls(FilterInfo info)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl, Boolean& displayExpandIndicator)

Exception rethrown at [0]:
at Quest.Toad.Util.Global.RethrowKeepingStackTrace(Exception e)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl, Boolean& displayExpandIndicator)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.updateContentTimer_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Holger

4

Hi,

seems that you are right and we have a bug for HANA versions older then SPS11 (you have a SPS10). I already created issue and we will fix it. You can check this number in our release notes: QAT-1154.

For now you can apply this fix:

  1. Go to Options -> Databases -> SQL Dictionary -> Db.CommonSql -> ListViews.

  2. Select SAP Hana:1.0.0 and use this SELECT:

select v.VIEW_NAME,v.SCHEMA_NAME,v.VIEW_OID,v.VIEW_TYPE,o.OWNER_NAME,v.IS_COLUMN_VIEW, v.DEFINITION, 0 as HAS_STRUCTURED_PRIVILEGE_CHECK, 0 as HAS_CACHE, 0 as CACHE_RETENTION, 0 as CACHE_FILTER from VIEWS v left join OWNERSHIP o on o.OBJECT_TYPE=‘VIEW’ AND v.SCHEMA_NAME = o.SCHEMA_NAME and v.VIEW_NAME = o.OBJECT_NAME WHERE v.SCHEMA_NAME = {{StringQuote(?)}} Order By v.VIEW_NAME

  1. Apply this change and restart TSAP.

Hope this help you for now and we are sorry about problems.

Filip

5

Hi,

this solve the problem.

Thx

Holger