Solution : https://service.sap.com/sap/support/notes/1646695 (SAP Service marketplace login required)
Summary :
After upgrading to SAP HANA Revision 17, some procedures may be invalidated due to an automated migration during the index server startup, which can fail to recompile them successfully. To address this, the provided python script, sqlscript_utils.py, helps recompile all invalidated procedures. The script generates DDL statements for the reactivation/recompilation which are saved to a SQL file. Users need to manually execute these DDL statements after checking the current schema used. Detailed guidance for script usage and execution conditions, including user permissions and dependent objects, is included to ensure a smoother recompilation process.
Key words :
py --action=3 --mode=0 --filter=1remarks, py --action=3 --mode=1 --filter=1remarks, upgrading sap hana database, sap hana database upgraded, trigger interactive reactivation/recompilation, index server startup, alter session statement, user credentials manually, invalid dependent objects, generate ddl statements
Related Notes :
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |