1972414 - How to enable version validation for an SAP HANA stored procedure

By default, when creating a stored procedure in an SAP HANA database, version validation for that stored procedure is not enabled.

The following symptoms may be encountered:

1. Errors in the Netweaver application server's system log (i.e. Netweaver transaction SM21):
   
   Database error 1341 at OPC
   Procedure version validation failed: Version validation is not enabled for this procedure: line 1 col 151 (at pos 150)
2. Errors in the Netweaver application's work process log (i.e. ST11):
   
   SQLCODE       : 1341
   SQLERRTEXT  :  Procedure version validation failed: Version validation is not enabled for this procedure: line 1 col 151 (at pos 150)
   CALL "_SYS_BIC"."sap.erp.dimp.ad.gdp/GET_GDP_ASSIGNMENTS_RPEGALL2F04" ( ... ) WITH VERSION VALIDATION ? ;
   SQSC: WARNING => Procedure Version Validation was disabled
   SQSC: Procedure name was "_SYS_BIC"."sap.erp.dimp.ad.gdp/GET_GDP_ASSIGNMENTS_RPEGALL2F04"
     WARNING: prepare() of C_0221, rc=4, rcSQL=432
   ...
3. Error within HANA Studio:
   
   

   Could not execute 'CALL "_SYS_BIC"."sap.erp.dimp.ad.gdp/GET_GDP_ASSIGNMENTS_RPEGALL2F04" ( ... ) WITH VERSION VALIDATION 1'
   SAP DBTech JDBC: [1341]: Procedure version validation failed: Version validation is not enabled for this procedure: line 1 col 151 (at pos 150)

4. STT2 Dump 

         Procedure version validation failed: Procedure version is not matched with given version number 

SAP HANA Database 1.00

SAP HANA Database 2.00

CX_SY_DB_PROCEDURE_SQL_ERROR  DB_SEL_STD_VAR DSQL_OPEN_PROC , KBA , HAN-DB , SAP HANA Database , IS-ADEC-GPD , Grouping, Pegging & Distribution , How To