Visual LANSA Forum

Hey All,
We just upgraded our Power9 system to V7R4 and we are finding this error in the logs regarding the DCXJSMLIB.

JVMJ9VM148E java.endorsed.dirs=/LANSA_dcxpgmlib/jsm/instance/endorsed is no longer supported. The endorsed-standards override mechanism
Unable to create Java Virtual Machine ...

Where is the System Initialization Log on Windows 10?
Just got back from vacation and need to update my password. Its been updated on our Power9 system, but when I go to refresh it in the Development Environment I get a "System Initialization has failed with one error. Review the initialization log ...

Thanks Dino, I did not realize there was a JSON sample out there, will have to check it out.
I got it resolved, albeit not with a CLOB.

I was using a CLOB because I thought it was the only way to generate a VARCHAR(MAX). All of the STD_* text based fields where to small, I think STD_STRNG is 512. I ...

It's been a long time since I have done any LANSA work or posted here. :D
It's coming back, but I am having trouble getting a CLOB field to work with a PRIM_MD.Edit.

We have a table defined that contains a CLOB field to store a JSON object.

I am trying to create a UI that will allow us to edit ...

Its been a while, but by try setting the ColumnVisible property to false.
Note this is NOT #column.Visible := false, but #column.ColumnVisible := false (super confusing I know. :D)
Also I am doing this by memory so it may not be syntactically correct. ;)


if (#AVLISTMANAGER.avVisualList *IsNot ...

For VLWEB and the PRIM_LIST control, you can set the ColumnStyle on the list.

begin_com role(*EXTENDS #PRIM_WEB) LayoutManager(#Layout1)

define_com class(#PRIM_VS.Style) name(#Style1) BackgroundBrush(#Brush1)
define_com class(#PRIM_VS.SolidBrush) name(#Brush1) Color(0:150:136)

define_com class ...

Hi Megumi,

I think it depends on what type of template you are using.
I don't think formulas and things like that work, but you can have a template and use that as a starting point.
That is how we handle a couple different reports.

For example, I have three templates defined in a "templates ...

LOL, I can't tell you how many rabbit holes I have been down only to find out there was a port that was not open.

Glad you got it worked out.

Joe

Hey Jim,

Have you been able to access the xvlwebtst.html from your server?
For example, localhost:{port}/{pgmlib}/{partition}/xvlwebtst.html

you should get blue LANSA box that states the web server is running.
If that works, then try out of localhost such as tstnesaapi:{port}/{pgmlib}/{partition ...

I don't know if you can do it directly from a Server Module, but you can using Integrator. Its how we do it at least.

Look into the OpenLDAPService. https://docs.lansa.com/14/en/lansa093/index.htm#lansa/intengb7_3640.htm

We wrap this type of stuff up in a LDAP Process with LDAP Functions which ...

Hey Jim,

You won't access the url from on the iSeries. You access the url from the Windows Proxy, which will call the corresponding ServerModule on the iSeries.

On your Windows Server, IIS will be installed and should be handling all the requests. The LANSA install on the Windows Server will ...

We have a REST API in production on the IBM i, but as others have mentioned, you must have a Windows IIS server in front of it.

Interestingly, you don't actually do anything with it once you get the LANSA bits on it, it just proxies the request through.

One word of caution I would tell anyone who ...

Brendan,

I can't tell you how long I spent looking at that trying to figure out how to do this.
For whatever reason, I never thought I could just wrap it double quotes.

That was exactly what I needed. lol

Thanks for replying.
Joe

We use Integrator's OpenLDAP to authenticate users with Active Directory.

For the most part this works great, but we are running into an issue with users that have passwords with special characters like a parentheses.

The character in the password seems to blowing up the command.

The auth code ...

Yeah I saw that it was still associated with the Task which in this case is ok.
I just needed to dump these changes and start over.

I've not been doing much LANSA work in the past few months, so I am a bit rusty on all the small particulars.

Thanks for the reminder!

The unlock was the piece I was missing.

Thanks!

I have a Server Module and some other Reusable Parts that are checked out with Task Tracking.

They have changes that have not been checked in. I would like to revert all my local changes with the copy that is on the server, essentially removing all my changes.

A "refresh" does not seem to be doing ...

I had the same issue some time ago and I raised an issue with support, this was before the Idera acquisition and the move to the new support system, however I think the solution was to use the STD_DATEX field instead of the PRIM_MD.DateTime.

I forget the exact details as to why, but it was ...

I can and will probably do that instead of trying to do some dynamic where clause.
The issue is that this is in production and we have automated deployments so we will kick this off at night when no one is on the system. At which point I will have to log in from home and run the update script.

Its ...

That means setting the ASQN attribute which also means having to check for NULL or True for EVERY QUERY.

Ugh.

Was hoping to not have to do that, but it seems like the only way.

Thanks Art.