Visual LANSA Forum

Does anyone else utilize SQL Views and experience the Views are removed when the file is imported or checked in. We had not been saving the source code as it can be regenerated as needed, but it seems that saving the source code doesn't help.

Any suggestions, advice and guidance would be ...

Transform file works with .xls files not .xlsx.

Has anyone had success exporting and importing tables with SQL Views in a library different than the Default file library? We have encountered errors and had to remove the SQL View from the table before exporting. Then manually recreating the SQL View(s) in both the exporting system and the ...

Is there a way to prevent the delete of DB2 table views when you import a file into a new partition? It seems to be a bit random, but typically all the table views have been removed when I file is imported.

OR is there something we are doing wrong on export/import?

Don

You may need to reset the identity column value after adding a column.

Find the last identity column value and use
ALTER TABLE TEST ALTER TEST_ID RESTART WITH X;
where X is the next value.

Resolved.

I'm guessing some of the services were not restarted properly.

Thanks all.

Thanks Christophe.

Wasn't critical, but was annoying.

Don Nelson

Hi Christophe,

The file LangMap.txt does not exist in the partition execute directory.

Regards,

Don

Where's Hamad when I need him. lol

Getting this error during login to LANSA V14 No EPC. I've encountered it before and I'm sure it's probably in the old incident system, but can't find anything related to it any where open to the public.

After logging in you get the Language CCSID Mappings like you would when you system init, but it ...

The debug issue was unrelated to this message the solution Art gave was the issue with debug. The message still appears at login though it doesn't seem to to cause any issue with the IDE. It is not a VM just a normal slave install to an IBM i.

Additional Information:
Debug is not working in the IDE. When you run in DEBUG in the IDE the job executes, but debug is not engaged.

I've seen this error before, but can recall how to eliminate it. It seems to be prevent me from running the IDE in DEBUG.

Any help would be appreciated.

Thanks,

Don

https://docs.lansa.com/15/en/lansa015/i ... 4_0120.htm

Give this a try

If your host monitor isn't shut down properly, this will occur. Go to subsystem LANLISTEN and end all TP jobs with your user name. It may also require you end and restart the LANLISTEN subsystem.

Check out the Predetermined Join logic to link fields from other files and use the LANSA Fetch to retrieve all the data.

An update just to close out this issue. We are still on V14 with no EPCs or SPs so the issue was we had to have LANSA V10 on the remote PC. Once we had this machine setup, DEBUG worked fine. So, it would seem running via Remote Desktop was not related to our issue.

Thanks Art for your help,

Don ...

Does anyone know where the *AUTONUM value are stored. They are processed through the M@SYSVAR 3GL program, but I can't determine where the data is actually stored. I'd like to get at it from a stored procedure.

Does anyone have tips or tricks on how to get debug to work in VL IDE when running via remote desktop(not sure that really matters)? I have it running on my PC, but I am setting up a system on a remote PC which we use for consultants to access the system. Debug in the LANSA Settings says the Debug ...

We are getting this error repeatedly in our x_err.log which is eventually filling up and crashing. Any suggestions on where to start our investigation or have you experienced us before.

Fri Mar 18 01:12:05 2022
Release 14.0.0 Build 4120 iSeries
Message : (0586) - Component Manager request of type ...