on 05-19-2016 1:26 PM
Dear all,
In HANA SP12, there is a new feature that HANA Scripted views can be replaced by table functions.
I migrated one of my script-based calculation view, and when I was trying to activate this migrated view, I met the error message:
Error reading table function TABLE_FUNCTION_XXX
I seached the SYS_BIC schema and could not find this table: TABLE_FUNCTION_XXX. (I think a corresponding table starting with TABLE_FUNCTION will be created under SYS_BIC schema, cause I see some other tables with similar name).
So my question is:
Is there any step I missed when I migrate the script-based view to table function?
Should I manually create TABLE_FUNCTION_XXX? Or this table will be created automatically during migration?
Thanks and best regards,
Tim
Found the solution.
After migrating script-based view to table function, a new object TABLE_FUNCTION_XXX.hdbtablefunction will be generated automatically and its initial status is inactive.
Need to activate this .hadtablefunction manually from repositories window, afterwards can activate the view successfully.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.