SAP Knowledge Base Article - Preview

3202561 - SQLCODE -328 No procedure with name SAP_DB2_PSS_SET_SPAGPA_ACC found.

Symptom

You've migrated from DB2 to Hana DB and notice the following DB2 report and sqlcode 328 error message reported in the work process traces:

=========================================================================
C Wed Mar 9 02:44:01:194 2022
C  *** ERROR => PREPARE C_0137 on connection 0, rc=328
 [dbslsdb.cpp  9700]
C  {root-id=0AC3280AC9351EECAEDD7A9707B04336}_{conn-id=0AC3280AC9351EECAEDD7A9707B06336}_1
C  SQLCODE    : 328
C  SQLERRTEXT : invalid name of function or procedure: no procedure with name SAP_DB2_PSS_SET_SPAGPA_ACC found: line\
C                1 col 7 (at pos 6)
C  sc_p=7f327fe58db8,no=137,idc_p=(nil),con=0,act=1,slen=67,smax=256,#vars=0,stmt=7f223822b060,table=SAP_DB2_PSS_SET_SPAGPA_ACC    
C  CALL  SAP_DB2_PSS_SET_SPAGPA_ACC  WITH RANGE_RESTRICTION('CURRENT');
=========================================================================

The system is functioning without issue but you don't want these errors messages reported any more.


Read more...

Environment

  • SAP Netweaver AS any version
  • IBM DB2 any version

Product

SAP HANA, platform edition 2.0

Keywords

-328, Accounting for Web Services, SAP_DB2_PSS_SET_SPAGPA_ACC , KBA , BC-DB-DB2 , DB2 for z/OS , HAN-DB , SAP HANA Database , 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.