SAP Knowledge Base Article - Preview

2630088 - SQL0551N "REPLACE VIEW" for replace_HEXTORAW.sql SAP note #2465138

Symptom

  • Install Db2 fixpack of DB2 v10.5 or DB2 v11.1 with SAP Basis 750 -752 and run post update script ./db6_update_db.sh -d <SID>
  • The db6_update_db.log results in the following error
    ************************************************************
    * ERROR:
    * ERROR: At least 1 CDS view or table function using the built-in routine HEXTORAW was found.
    * ERROR: Urgently replace this function according to SAP Note 2465138.
    * ERROR: The list of affected CDS views/tablefunctions is found in the following files:
    * ERROR: - db6_update_db.log
    * ERROR: - db6_update_db_out.log
    * ERROR: Look for labels "HEXTORAW occurence(s) in cds [views|functions]"
    * ERROR: In addition it is recommended to apply SAP Note 2511399 for CDS performance optimization.
    * ERROR:
  • The SAP note 2465138 includes the script replace_HEXTORAW.sql as an attachment
  • When running this script, you may hit the following error
    SQL0551N  The statement failed because the authorization ID does not have the
    required authorization or privilege to perform the operation.  Authorization
    ID: "DB2<SID>".  Operation: "REPLACE VIEW". Object: "SAP<SID>.DEMO_CDS_BINFUNC".
  • An SQL statement that makes use of the SAP CDS function HEXTOBIN aborts with SQL0415N or SQL0171N.

 


Read more...

Environment

Db2 LUW
SAP ERP 6.0
SAPK-750.....INSAPBASIS
SAPK-751.....INSAPBASIS 
SAPK-752.....INSAPBASIS

Product

SAP ERP 6.0

Keywords

CDS, fixpack, update , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.