Database error -440 at OPC

[Former Member]

Hi all,

Database error -440 at OPC

I get this error in system log (SM21) in lots everyday. I am new to SAP basis and need your help in analyzing  this error .

Regards

Deepesh

[Former Member · Accepted solution]

Hi Deepesh,

  Can you please provide the screenshot of the error message as well as  please let us know the DB you are using ???

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Maria Joseph Vimalan ,

Sorry i dont have access to OS level .But I have attached the screen shotdon't

[Former Member · Accepted solution]

HI,

Can you please confirm the SAP_BASIS package ( please go to system -> status -> click on

component version ( small button near the version of the ERP you are using) and the DB you are using ?

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

component version:SAP SCM 7.0

DB: DB6

[Former Member · Accepted solution]

Thank you.

Please refer the SAP NOTE Note 1238617 - DB6: SQL0440N in SM21: DB6PM_LST not found as well as Note 978319 - DB6: Incorrectly cataloged table functions.

Please go to work directory under /usr/sap/SID/DV*/work and search for the file dev_w7 and check whether you are getting as below lines

C  *** ERROR in DB6Open[dbdb6.c, 3230] CON = 0 (BEGIN)

C  &+     dsql_db6_open( SQLExecute 😞 [IBM][CLI Driver][DB2/AIX64]

       SQL0440N  No authorized routine named "DB6PM_LST" of type

C  &+  "FUNCTION" having compatible arguments was found.

               SQLSTATE=42884 row=1

C  &+

C  &+     CALL ADMIN_CMD( ? )

C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=NO,

            optlevel=5, degree=1, buffer_lobs=YES, op_type=24,

            reopt=0

C  &+       ABAP location info:

              'CL_SQL_STATEMENT==============CP', 383

C  &+

C  &+     Input SQLDA:

C  &+                        1 CT=WCHAR           T=VARCHAR

          L=210   P=210   S=0

C  &+

C  &+     Input data:

C  &+     row 1:             1 WCHAR           I=210

          "DESCRIBE SELECT SYSOUT FROM SYSIBM.SYSDUMMY1,

           TABLE("...

C  &+

C  &+     ABAP location info 'CL_SQL_STATEMENT==============CP',

If yes, you need to implement the first note.

THanks and Regards,

Vimal

[Former Member]

Have you checked in db02,,for any db error listed there

[JPReyes]

Read SAP Note 978319 - DB6: Incorrectly cataloged table functions

That should help you.

Regards, Juan