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
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
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
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
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.