SAP Knowledge Base Article - Preview

2340123 - SQL0440N No authorized routine named "MEMORY_TABLE"

Symptom

  • During the upgrade to NetWeaver 7.50 the following error occurs during phase MAIN_SHDPREPUT/START_SHDI_PREPUT.
    Severe error(s) occurred in phase MAIN_SHDPREPUT/START_SHDI_PREPUT!
    Last error code set: Shadow instance couldn't be started, check 'STARTSSC.LOG' and 'DEVTRACE.LOG': RFC error system SID nr 00 function 'UPG_IS_SHADOW_SYSTEM' failed with code 3 key DBSQL_SQL_ERROR: SQL error SQL code: -440 occurred while accessing table DD02L.
  • To analyze errors during the start of the shadow instance, check the
    'STARTSSC.LOG' and 'DEVTRACE.LOG' files in directory
    '/usr/sap/SID/SUM/SUM/abap/log'.
  • 'DEVTRACE.LOG':
    SQL0440N  No authorized routine named "MEMORY_TABLE" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884
  • Similar error can also occur after kernel upgrade:
    "SQL message: SQL0444N  Routine "*RY_TABLE" (specific name "MEMORY_TABLE") is implemented with code in library or path "...lib/bin/routine/db2sap", function "db2sap_memory_table" which cannot be accessed.  Reason code: "6".  SQLSTATE=42724" ."


Read more...

Environment

  • SAP Netweaver 7.50
  • Db2 Linux, Unix and Windows

Product

SAP Customer Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

invoke, FAE, For All Entries, shadow, db2sap, sql0444n, db2sap, library, fix pack, DB6, db6_update_db , KBA , BC-DB-DB6-UPG , Upgrade SAP System , Problem

About this page

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

Search for additional results

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