×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have googled the user define function error cpf503e and I can't find anything that makes sense. When I do a call here is the errors I get. We are running V7R3 Attached is our program.
call engxml
User-defined function error on member QSQPTABL.
User-defined function error on member QSQPTABL.
Trigger program or external routine detected an error.
Number of rows 0 not valid.
The description for user defined function error
Message ID . . . . . . : CPF503E Severity . . . . . . . : 30
Message type . . . . . : Sender copy
Date sent . . . . . . : 04/08/19 Time sent . . . . . . : 09:11:17
Message . . . . : User-defined function error on member QSQPTABL.
Cause . . . . . : An error occurred while invoking user-defined function
GET_XML_FILE in library QSYS2. The error occurred while invoking the
associated external program or service program QDBSSUDF2 in library QSYS,
program entry point or external name QSQGTXML, specific name GET_XML_FILE.
The error occurred on member QSQPTABL file QSQPTABL in library QSYS2. The
error code is 1. The error codes and their meanings follow:
1 -- The external program or service program returned SQLSTATE 42704. The
text message returned from the program is: *N in *N type *FILE not found. .
2 -- The external program failed before it completed.
3 -- The database timed out waiting for the program to return. The timeout
value used by the database was 0 minutes and 30 seconds.
The description for the trigger program or external error
Message ID . . . . . . : SQL0443 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 04/08/19 Time sent . . . . . . : 09:11:17
Message . . . . : Trigger program or external routine detected an error.
Cause . . . . . : Either a trigger program, external procedure, or external
function detected and returned an error to SQL. If the error occurred in a
trigger program, the trigger was on table QDBSSUDF2 in schema QSYS. If the
error occurred in an external procedure or function, the external name is
QDBSSUDF2 in schema QSYS. The associated text is *N in *N type *FILE not
found.. If the error occurred in a trigger program, the associated text is
the type of trigger program. If the error occurred in an external function,
the associated text is the text of the error message returned from the
external function.
Recovery . . . : Refer to the joblog for more information regarding the
detected error. Correct the error and try the request again.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.