Database error -444 at EXE

[Former Member]

SQL0444N Routine "SAPQAS".DB6PMCF" (specific name "SQL081016152645900") is implementedwith code in library or path "\db6pmcf", function 'Db6pmcf" which cannot be accessed. Reason code : "4". SQLSTATE=42724 row=1

[Former Member]

Erna,

Did you perform a system copy recently? I have seen this error when the UDF function library path is incorrect. Go to transaction db02 -> configuration -> monitoring settings.

Check the "location of user defined function library path" is correct. This should be /usr/sap/<SID>/SYS/exe/run .

If this is not correct, make the correction, hit save and then "test" to make sure that the right library path is reloaded.

- Sameer

[Former Member]

hi sameer,

thanks for your reply.

i have tried changing the path in the cockpit area as: /usr/sap/QAS/SYS/exe/run but database error still occurs in the SM21 and in the event viewer..

fyi,

erna

[paul_power]

Hi Erna,

Have you applied my recommendations?

"

Please firstly download and apply the latest library db6pmudf from SAP

Service Marketplace. This library is part of the DB6-specific SAP

ABAP kernel (SAPEXEDB.SAR).

Pls assign the authorization to execute the functions to the relevant

users that are entered in the DBA Cockpit for the database connection on

the monitored database. Specify the following commands for this

purpose:

db2 "grant execute on saptools.db6pmcf to <user>"

db2 "grant execute on saptools.db6pm_lst to <user>"

Please also check SAP notes:

978319 DB6: Incorrectly cataloged table functions

1238617 DB6: SQL0440N in SM21: DB6PM_LST not found

334777 DB6: Missing user-defined functions

"

If issues persist after this, check the sm21 entry and then check the corresponding work process trace file that encountered the error. Please post the error message contained in the dev_w* from the time the error occured.

Regards,

Paul

[Former Member]

Hi Sameer,

I tried again changing the path to d:\usr\sap\QAS\SYS\exe\run\

database error no longer appeared.

thanks for your help.

best regards,

erna

[Former Member]

Hi Paul,

I tried changing the path first & it went OK.. the error no longer appeared.

thanks & best regards,

erna

[Former Member]

Our SAPRouter was setup on Suse Linux. It was configured, certified, authenticated and running. We're able to access sapserv2 but we could not proceed sending larger files to SAP as we do not know yet how to.

Please provide us the command and procedures on how to send larger files via SAPRouter.

Thanks,

Erna Bolos

[paul_power]

Hi,

Root cause of this issue is due to the function "Db6pmcf" which cannot

be accessed by those users that are entered in the DBA Cockpit.

Please firstly download and apply the latest library db6pmudf from SAP

Service Marketplace. This library is part of the DB6-specific SAP

ABAP kernel (SAPEXEDB.SAR).

Pls assign the authorization to execute the functions to the relevant

users that are entered in the DBA Cockpit for the database connection on

the monitored database. Specify the following commands for this

purpose:

db2 "grant execute on saptools.db6pmcf to <user>"

db2 "grant execute on saptools.db6pm_lst to <user>"

Please also check SAP notes:

978319 DB6: Incorrectly cataloged table functions

1238617 DB6: SQL0440N in SM21: DB6PM_LST not found

334777 DB6: Missing user-defined functions

Regards,

Paul