Delivery-to (check-in) AS400 problem

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
Stefano Foresi
Posts: 10
Joined: Thu May 18, 2023 5:10 pm

Delivery-to (check-in) AS400 problem

Post by Stefano Foresi »

Hello,
in Lansa 14.2
when I delivery to (or check in) something to our AS400, I end with some errors:
2024-05-06 12 18 45.png
2024-05-06 12 18 45.png (11.05 KiB) Viewed 158054 times
witch seems to be related to what looks like corrupt data into LX_FLG:
2024-05-06 12 13 53.png
2024-05-06 12 13 53.png (71.15 KiB) Viewed 158054 times
That corrupt data also leads to errors in LH@PURG function when opening Lansa IDE, if not manually deleted,
because XLGDAT = "20" is not a valid date.

Any help would be appreciated.
Stefano
bark
Posts: 44
Joined: Thu Jan 05, 2017 9:56 am

Re: Delivery-to (check-in) AS400 problem

Post by bark »

Hi Stefano,
The quickest way to fix this error is to clear the entire LX_FLG table, however you would end up losing all of your Host Monitor history. Alternatively you could open the table in a Database editor and look for the record where XLGDAT is '00000020', and delete that record only.

HTH
Bark
Stefano Foresi
Posts: 10
Joined: Thu May 18, 2023 5:10 pm

Re: Delivery-to (check-in) AS400 problem

Post by Stefano Foresi »

I've started using Lansa 14 SP2 build 4158 with a new installation, that is, is using a new server.

I'm experiencing the same problem as for the older developing server I was connected to.

When checking-in an object, some time after connecting to my AS400, I receive error LII057E:
2025-06-06 09 29 57.png
2025-06-06 09 29 57.png (6.33 KiB) Viewed 151687 times
As in my post of 2024, when looking at LX_DTA.LX_FLG I get some strange data, that is, looks like bad written or corrupt.
There is "20" into XLGDAT witch is a bad value for data, and also other columns seems to contain truncated or badly formatted data.

So this looks like a machine-related problem, as it occurs wit both old and new developing environment (old and new servers).

Any help would be appreciated.
Thanks.
Stefano Foresi
Posts: 10
Joined: Thu May 18, 2023 5:10 pm

Re: Delivery-to (check-in) AS400 problem

Post by Stefano Foresi »

As you can see in the following screenshot, looks like that LX_DTA.LX_FLG is filled with bad formatted data.

There are a lot of records where XLGMSG contains definition of object I'm delivering to AS400:
2025-06-10 09 28 01.png
2025-06-10 09 28 01.png (55.21 KiB) Viewed 151542 times
Hope this can help someone to answer about the problem.
Thanks in advance.
Post Reply