Re: CPF5035 on a QRY/400 -- MIDRANGE-L

Your joblog for the query should give you some of what you need - it should
be giving you the field name involved, the relative record number, and
an error code as to what the issue is.. if you are not seeing this
detail in your job log, find the job description in use, and change its
logging levels to 4 0 *MSG plus log CL *Yes

Message ID . . . . . . . . . : CPF5035

Message file . . . . . . . . : QCPFMSG

Library . . . . . . . . . : QSYS

*Message . . . . : Data mapping error on member &1.
Cause . . . . . : A data mapping error occurred on field &9 in record
number &5, record format &7, member number &8, in member &1 file &2 in
library &3, because of error code &6. The error code meanings follow:
*
1 -- There is data in a decimal field that is not valid.

2 -- A significant digit was truncated.

3 -- A floating point value exceeded the maximum representable value.

4 -- A floating point value was less than the minimum representable
value.
5 -- A binary floating point value could not be used for the attempted

operation because it is not a number, or is not valid.

6 -- A floating point value could not be mapped to packed decimal,
zoned
decimal, or binary.

8 -- A binary floating point value that is not a number is not allowed
as

More...
* If that does not have a clear picture, look at the job *(before the halt
answered) using wrkjob or wrkactjob - opt14 for files, and F11 for IO
details will tell you the rrn of each table in the query at the halt (and
no rrn may indicate some join condition not met). Its tedious work, but if
you get the 18 files you should be able to determine exactly which records
involved.
Job . . : BNCW User . . : QTMHHTTP Number . . . :
721647
Member/ Record File I/O ----Open---
Relative
File Library Device Format Type Count Opt Shr-Nbr
Record
DHST XXXFIL DHST @DHST PHY 6964 IO NO
1611442

Jim Franz

On Wed, Nov 27, 2024 at 10:39 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

I’d make new queries, start at the first file, run your selection, then add
the first join, etc

I bet it won’t take as long as it sounds

On Wed, Nov 27, 2024 at 5:38 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I did run the retrieve SQL but it did not produce any output, basically

no

records found.

There is an OR condition. I commented out the first part of the OR and it
ran showing me a bunch of null columns but gave data. I then switched to
the condition after the OR and it too produced output. When they ran
together, they produce no output. Makes no sense as the only difference

is

the first condition selects warehouse 002 and the second part of the OR

is

warehouse 007. The rest of the where conditions are identical.

There were no messages when I ran it.

Thanks, Darryl.

On Wed, Nov 27, 2024 at 4:59 PM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Bryan

How is RSS going to run a Query for i query? And if Darryl isn't

getting

a QMQRY that really works, it won't help, methinks, to run it in RSS -
he could run the QMQRY and see various SQL* messages that might give

him

a clue.

Cheers
Vern

On 11/27/2024 10:48 AM, Bryan Dietz wrote:

use Run SQL Scripts instead of green screen

Bryan

a4g atl wrote on 11/27/2024 10:38 AM:

I have inherited a QRY that was created before 2020. It has been

running

daily ever since until this weekend.
The QRY is a complex QRY with 18 files.

Does anyone know of a way to get a dump of the values in the fields
of the
QRYDFN when it fails? DMPJOB does not work.

I tried converting to a QMQRY to get the SQL. The SQL produces no

errors

but returns an empty list of records. I see some records when

working

in

WRKQRY and use F5 to display the report and it does give me records.

The

column in error has ++++.

I need to see the contents of the fields at the time to locate the
problem.

TIA, Darryl Freinkel.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.