Yes!

This is better! But still 2 lines per error. Is it possible to have one per error?

I have 75 rows per error in this table.

Is it possible to have one line per error - like a summary table ERRORS_SUMMARY, link to this details table? And the summary will have only:

reference, date,type(SYNTAX, UNDEFINED,etc),line of code,$ZV

Yes, thank you Robert!

Did the same but with

catch e {

Do e.Log()

}

Which is more "stylish" if you may.

Example of the usage  in a freshly baked objectscript-errors package.

Eventually, I introduced a module that reproduces typical ObjectScript errors: UNDEF, SYNTAX, PARAMETER, etc.

Pull request for more examples! )

I mean what is the simplest snippet which generates errors to ^ERRORS?

Cool!

How to generate errors to test the module? 

This looks like a bug in OEX. Thanks, @Robert Cemper 

And this "SQL format" could be imported then into PostgreSQL only or to any SQL-driven DBMS?

There is no such feature in IRIS, but if you share an example I think it could be baked shortly.

IRIS can export data into Globals format in Global output file (GOF), or XML. which could be imported then into any IRIS.

And you can export CSV file from IRIS class/table.

Augusto, what do you mean by “sql format”?

Docker Images with IRIS 2020.3 and ZPM 0.2.4:

intersystemsdc/iris-community:2020.3.0.200.0-zpm

intersystemsdc/iris-community:2020.2.0.204.0-zpm

intersystemsdc/irishealth-community:2020.3.0.200.0-zpm

intersystemsdc/irishealth-community:2020.2.0.204.0-zpm

intersystemsdc/iris-aa-community:2020.3.0AA.331.0-zpm

And to launch IRIS do:

docker run --name my-iris -d --publish 9091:51773 --publish 9092:52773 intersystemsdc/iris-community:2020.3.0.200.0-zpm

docker run --name my-iris -d --publish 9091:51773 --publish 9092:52773 intersystemsdc/iris-community:2020.2.0.204.0-zpm

docker run --name my-iris -d --publish 9091:51773 --publish 9092:52773 intersystemsdc/irishealth-community:2020.3.0.200.0-zpm

docker run --name my-iris -d --publish 9091:51773 --publish 9092:52773 intersystemsdc/irishealth-community:2020.2.0.204.0-zpm

docker run --name my-iris -d --publish 9091:51773 --publish 9092:52773 intersystemsdc/iris-aa-community:2020.3.0AA.331.0-zpm

And for terminal do:

docker exec -it my-iris iris session IRIS

and to start the control panel:

http://localhost:9092/csp/sys/UtilHome.csp

Thanks, Stefan!

What about integratedML image store/intersystems/iris-aa-community:2020.3.0AA.331.0 released a while ago. Was it updated too?

Another example which I use in Covid-19 online dashboard to update the data:

ClassMethod CreateTask() As %Status
{
    Set task=##class(%SYS.Task).%New()
    Set task.Name = "Update data"
    Set task.NameSpace=$Namespace
    Set task.TimePeriod=0 // Daily
    Set task.TimePeriodEvery=1 // Every 1 day
    Set task.DailyFrequency=1 // Run Several times in a day
    Set task.DailyFrequencyTime=0 // Run every x minutes
    Set task.DailyIncrement=60 // # of minutes between runs
    Set task.DailyStartTime = 0 // Start at 00:00:00
    Set task.DailyEndTime = 86399 // End at 23:59:59
    Set task.StartDate = $p($H,",",1) // Start today
    
    Set taskdef = ##class(Covid19.UpdateTask).%New()
    Do task.AssignSettings(taskdef)
    Set task.TaskClass=$classname(taskdef)
    
    Set st = task.%Save()
    Return:$$$ISERR(st) st
    Return ##class(%SYS.Task).RunNow(task.%Id())
}

But you need to have the class,  Covid19.UpdateTask in this case:

Class Covid19.UpdateTask Extends %SYS.Task.Definition
{

Method OnTask() As %Status
{
    return ##class(Covid19.Utils).DailyUpdate()
}

}

HTH

Thanks, Robert! Yes, this is relevant stuff. I'm not sure if this fits in that case, I mean if the approach could be used with ntegratedML

Hi Yuri!

It is still not working for me using the docker run. 

Any ideas on how can I fix it?

1000 cols problem looks serious. I bet we discussed it before: @Dmitry Maslennikov , @Robert Cemper , @Eduard Lebedyuk ?
 

Hi Renato!

A small note:

SELECT id, Name, Tags, Text FROM Community.Post Where not text is null order by idSELECT id, Name, Tags, Text FROM Community.Post Where not text is null order by id

Do we really have posts without text there?