What is the Criteria datatype?

Can you show the property definition?

If for example you have Criteria defined like this:

Property Criteria As %String(MAXLEN = 2000); // MAXLEN>512

Try to define the property like this:

Property Criteria As %String(COLLATION = "TRUNCATE(490)", MAXLEN = 2000);

How to debug SQL queries:

1. In SMP > System > Configuration > General SQL Settings  enable the following flags (don't forget to press Save):

• Retains SQL Statement as Comments in .INT Code
• Cached Query - Save Source  

2. Purge all Cached Queries - execute in terminal (namespace with query):

• Do $SYSTEM.SQL.Purge()

3. Execute the query again to get an error

4. Open in studio %sqlcq.HSREGISTRY.cls966.1.int routine (it would be %sqlcq.HSREGISTRY.cls1.1.int after purge)

5. Go to %0AmEdun+4 in this routine and see what this is about. Set try/catch, and debug.

In this case the most likely scenario is that the code tries to set global subscript longer than the maximum of 511 characters. Since the only change between queries is the column (there is also "as Relevance" part in your error query, but I think it's irrelevant) then it's probably something with that.

A lot of foss source samples to analyze are availible at our GitHub organizations:

• intersystems-ru
• intersystems

Also thank you & forked.

We use several providers, on all of them there are servers for development & testing and production. Some features are availible on DO, some only in other places. Can't say I found a cloud provider offering everything I want in one place.

Yes, DigitalOcean is quite good. I manage around 50 servers there and they don't disappoint. One issue I have is that  they don't offer backup/snapshot management. All you can do with a backup is restore it to current or a new server.  I'm used to features offered by other cloud providers, such as:

• Browse backup disk image
• Download disk image

But to do it in DigitalOcean I need to create a new droplet from a backup (takes time and costs  money) and browse it.

Also their in-browser-web-access is quite lacking -  they offer only VNC access, but not:

• SSH console access
• File explorer access
• File explorer access for a powered off server

"/" itself is also a valid REST path:

<Route Url="/" Method="GET" Call="Index"/>

Since when removing working functionality became a good thing?

WYSWIG does not support some formatting when creating an article (break tag for example).

How do I get to groups list now?

Learn -> Grous are missing.

Can't choose editor type now.

Turns out FF renders the <pre> tag node with horisontal scrollbar (if required) and Chrome without. Ok.

I'm against that. As it is right now, I can copy/paste code from <pre> tag into the terminal and it would work.

The advantage of <pre> block is that it would be displayed exactly as the author intended.

If we add line breaks the code would not work after copy/paste into the terminal.

Some notes:

• When writing a post title don't use URL escaped characters (namely - é). Title goes into url and it may break the link
• To add code switch into Filtered HTML view, paste your code inside<pre> </pre> tag, afterwards switch into Community Member WISIWYG to post
• To add headings use <h1> to <h6> HTML tags (in Filtered HTML view)

Please note, that another approach (put tstVar in the "public" list) suggested by Timothy Leavitt  works better in most cases, as once defined a % variable can be modified anywhere within the process. With "public" list you retain full control over variable visibility which makes debugging much easier.

You can use script command for that

script --quiet myoutput.log
csession cache
work in terminal
hang
exit

If you want to log every command then you can enable it in SMP ->  System Administration -> Security -> Auditing ->  Configure System Events. Once there enable %System/%DirectMode/DirectMode event and every terminal command would be logged along with time and user who executed it. Audit must also be active, of course.