You can also start Caché in Emergency mode : https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…
 

Hi Kevin,

Try 'Do ^%RFIND' to find out in what code these globals are referenced.

Hi Matthew,
Can you enable auditing, enable the system event 'login failure' and check for login failures in the audit database ?
Do you have enough license available?

If property altura would be of type %Integer, you could use parameter d :
d - output Caché numeric properties that have value "" as null

As string, i don't see any parameters in %WriteJSONStreamFromObject that would return null in stead of "".
 

Personally, I am setting the json myself to have total control of JSON output like

Write "Happy new year" 

Hi Muhammad,

Create following class :

Class Test.Json{

ClassMethod Get(date = "24-09-2021", debug = 0) As %String{  #Dim status as %Status  #Dim response as %Stream  #Dim jsonResponse as %DynamicObjectSet objHttp = ##class(%Net.HttpRequest).%New()  Set objHttp.Server="api.aladhan.com"  Set objHttp.Https=0  Do objHttp.SetParam("date",date)  Set status = objHttp.Send("GET","v1/gToH")  If status'=1 Do $SYSTEM.OBJ.DisplayError(status) Quit ""  If objHttp.HttpResponse'="" Do  Set response = objHttp.HttpResponse.Data  Set jsonResponse = ..GetResponse(response)  If debug Write jsonResponse.data.hijri.%ToJSON(),!  Return jsonResponse.data.hijri.date}

ClassMethod GetResponse(response As %Stream, del As %String = "") As %DynamicObject{  #Dim jsonStr as %String = ""  If response'="" {    Do response.Rewind()    While 'response.AtEnd {      Set jsonStr = jsonStr _ response.ReadLine() _ del    }  }  Quit {}.%FromJSON(jsonStr)}

}

and call it like :

USER>set hijri=##class(Test.Json).Get()
 
USER>write hijri
16-02-1443
USER>set hijri=##class(Test.Json).Get(,1)
{"date":"16-02-1443","format":"DD-MM-YYYY","day":"16","weekday":{"en":"Al Juma'a","ar":"الجمعة"},"month":{"number":2,"en":"Ṣafar","ar":"صَفَر"},"year":"1443","designation":{"abbreviated":"AH","expanded":"Anno Hegirae"},"holidays":[]}
 
USER>Write ##class(Test.Json).Get("01-08-2021")
22-12-1442
USER>

Hi Kevin,

the variable statStr should be known inside your loop, e.g. following routine works fine in SAMPLES :

test    ;
         set statStr = "aa|bb|.."         set sqlStatement = "Select * From Cinema.Film"         set tState  = ##class(%SQL.Statement).%New()         set qStat   = tState.%Prepare(sqlStatement)         set rset    = tState.%Execute()         WHILE rset.%Next() {              Write rset.%GetData(1), " ",$Piece(statStr,"|",1),!         }         Quit

Hi Brandon,

There are some limitiation to the free Iris license : 
 

• Total data: 10 GB
• Connections: 5
• Cores: 8

More details on https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

Can you show the class definition ? Maybe it is better to try to find out why your iFilter is not taken as the best option for this query.

Hi Lutz,

You have to assign your new %DB_Database1 & 2 resources to database1 & 2  (via System Admin -> Configuration->local databases->  click on database1 & 2  and change Resource Name to %DB_Database1 & 2

Several companies in Belgium as well :

https://www.datam.be/producten.html

https://www.asci.be/customer-relationship-management/

This has probably to do with underscores ( _ ) in variable/method names. (not allowed in object script, but used with callbacks in the (deprecated) product VISM (or also called Cache Direct, hence the CD and CalBk in the error)
I get a similar error when doing :

%SYS>set _abc=1
 
<FUNCTION>SetProp+2^%CDCalBk
%SYS 3d1>

From the documentation :

Invalid Names

A local variable name that does not follow the above naming conventions generates a error. There is one exception: if an invalid variable name begins with an underscore character followed by a letter, the system generates a <_CALLBACK SYNTAX> error. (Note the underscore character within the error name.) For example, SET _abc = 123 or SET x = _abc. This is because Caché identifies these names as VISM control names, rather than local variable names.

Do you use CSP pages or REST (through portal or other applications) ? It uses a grace period that can hold a license slot longer than the actual login time.

You can look at the license usage in the Management Portal :
- Click on View System Dashboard, in Licensing tab :

You can click on Current License Use, and click on the bottom of the page on 'Click here for more details' to go to the License Usage page (also accessible via System Operation -> License Usage)
You can view the same figures in terminal by using Do $system.License.ShowSummary()
(Look at Do $system.License.Help() for other methods to show license stats.

I am using read queue to be able to monitor the output from Image like this :
 

Parameter INSTALLDIR = "c:\ImageMagick\";

/// Do ##class(Image.Utils).Resize(file, newFile500, "500X500", .msg)ClassMethod Resize(fileOrig As %String, fileNew As %String, newSize As %String, ByRef output as %String) As %Boolean{  Quit ..Convert(fileOrig, "-resize "_newSize_"^> """_fileNew_"""", .output)}

ClassMethod Convert(file, options, ByRef output as %String) As %Boolean{  Do ..Cmd("convert """_file_""" "_options, .output)  Quit 1}

ClassMethod Cmd(command As %String, ByRef outputStr As %String){  Kill outputStr  Try {    Set cmd=..#INSTALLDIR_command    Open cmd:("RQ")    For {      Use cmd Read line If $ZEOF=-1 Quit      Set outputStr($i(outputStr))=line    }  } catch {  }  Close cmd}

Look at the %Dictionary tables, you can find the docs here :
https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

Also look at following answer for examples :
https://community.intersystems.com/post/example-list-persistent-classes…