Page 1 of 1
Delivery-to (check-in) AS400 problem
Posted: Mon May 06, 2024 8:25 pm
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 (11.05 KiB) Viewed 158059 times
witch seems to be related to what looks like corrupt data into LX_FLG:

- 2024-05-06 12 13 53.png (71.15 KiB) Viewed 158059 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
Re: Delivery-to (check-in) AS400 problem
Posted: Tue May 07, 2024 8:23 am
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
Re: Delivery-to (check-in) AS400 problem
Posted: Fri Jun 06, 2025 6:52 pm
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 (6.33 KiB) Viewed 151692 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.
Re: Delivery-to (check-in) AS400 problem
Posted: Tue Jun 10, 2025 5:33 pm
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 (55.21 KiB) Viewed 151547 times
Hope this can help someone to answer about the problem.
Thanks in advance.