Failed Export query in MEC Mapping

Hello,

This query ( PSMTNO from MPDSUM where PSPRNO = 'ITNO' ) works on MI test (EXPORTMI API , Select Transaction ) but I got this error in MEC log

A record with these values does not exist

I try this query in the mapping with fixed value and got the same error

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Can you please try * from MPDSUM where PSPRNO = 'ITNO'.

Not the same but I had a similiar kind of issue when I was trying to fetch VONO from FCR040. I had issue in MTEST itself.

Then export the excel from MITEST and do formatting on excel and see PSMTNO is at which position (column).

Then by split functionality of Type script I fetched VONO from 17th index. I was doing this for H5 scripting

Can you please try this in MEC and check the MEC logs if it works?

antonio-caria

in ExportMI.SELECT You don't need prefix table after where:

PSCONO from MPDSUM where PSPRNO = 'ITNO'.

can be

PSCONO from MPDSUM where PRNO = 'ITNO'.

of course CONO should be used in where also ....

Legacy Contributor

MEC mapper uses MECSVC user, Check what is the default company of the MECSVC cause the query will be executed on that company. And check if the Product is available in the company table MPDSUM.

If the above is causing the issue you can set the company in your mapper using M3 settings.

Lamis Alaa

Thank you all , the issue was in the API Reference in PAT using different CONO

Copyright © 2025 Infor. All rights reserved.