Database error -440 at OPC in sm21

[Former Member]

Hi All,

While monitoring tcode SM21.

From last two days it shows repeted error as Database error -440 at OPC .

I serached for SDN links, I find -551 at POC.

I am not able to find -440 at OPC.

Error Details:

Task : 04748

Process : Background Processor No. 012

User : DDIC

Program : RSAL_BATCH_TOOL_DISPATCHING

Problem cl : SAP Web AS Problem

Please help me on this.

Advance Thanks to all.

Regards,

jhansi

[deeraj_shetty]

Dear Jhansi,

How did you fix this issue. I am facing same issue in ERP 6.0/DB2 10.5.

Please help.

Regards,

Deeraj Shetty

[Former Member]

Hello,

Can you please provide more details on the nature of this problem? the return code of -440 is not enough infomation for us to say what the problem is here definitively...

Can you include the relevant extract from the dev_w12 trace file (you mentioned this was the wp number?)

Please include at least the section from the initial "sql error -440..." you should include at least the next 10 lines.

Similar issues have been resolved in the past by manually calling the command

'db2 invoke db2sap'

Which will catalogue the library db2sap, this may resolve the issue for you. (See online documentation on this command first)

Please also see SAP notes:

1304436 - DB6: Documentation for db6_update_db scripts

1124987 - DB6: Availability of administration functions

Regards,

Paul

[Former Member]

Hi Paul,

Thanks a lot in advance.

When i monitor the Tcode SM21 it shows below error repeatedly.

Time Type Nr Clt User TCode Priority Grp N Text

21:27:16 BTC 014 000 DDIC BY 2 Database error -440 at OPC

21:27:16 BTC 014 000 DDIC BY 0 > SQL0440N No authorized routine named

21:27:16 BTC 014 000 DDIC BY 0 > "FUNCTION" having compatible argumen

21:27:16 BTC 014 000 DDIC BY 0 > SQLSTATE=42884

21:27:16 BTC 014 000 DDIC BY 1 Database error -440

21:27:16 BTC 014 000 DDIC BY 2 Database error -440 at OPC

21:27:16 BTC 014 000 DDIC BY 0 > SQL0440N No authorized routine named

21:27:16 BTC 014 000 DDIC BY 0 > "FUNCTION" having compatible argumen

21:27:16 BTC 014 000 DDIC BY 0 > SQLSTATE=42884

21:27:16 BTC 014 000 DDIC BY 1 Database error -440

21:27:16 BTC 014 000 DDIC BY 2 Database error -440 at OPC

21:27:16 BTC 014 000 DDIC BY 0 > SQL0440N No authorized routine named

21:27:16 BTC 014 000 DDIC BY 0 > "FUNCTION" having compatible argumen

21:27:16 BTC 014 000 DDIC BY 0 > SQLSTATE=42884

21:27:16 BTC 014 000 DDIC BY 1 Database error -440

21:27:17 BTC 014 000 DDIC BY 2 Database error -440 at OPC

21:27:17 BTC 014 000 DDIC BY 0 > SQL0440N No authorized routine named

21:27:17 BTC 014 000 DDIC BY 0 > "FUNCTION" having compatible argumen

21:27:17 BTC 014 000 DDIC BY 0 > SQLSTATE=42884

21:27:17 BTC 014 000 DDIC BY 1 Database error -440

21:27:17 BTC 014 000 DDIC BY 2 Database error -440 at OPC

21:27:17 BTC 014 000 DDIC BY 0 > SQL0440N No authorized routine named

21:27:17 BTC 014 000 DDIC BY 0 > "FUNCTION" having compatible argumen

21:27:17 BTC 014 000 DDIC BY 0 > SQLSTATE=42884