LOAD DATA requires activation of JavaGateway.
>> active in docker community version by default
- Log in to post comments
All
Accepted answers
You run [IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2024.1 (Build 262U)
when 2024.1 was fresh I had problems because of a processor mismatch and no explicit message related. I bought a new processor to escape this trap.
you may try to check
containers.intersystems.com/intersystems/iris-community:2023.3
that didn't have that problem.
just guessing
- Log in to post comments
GREAT! forward-compatible
I was waiting for it almost 2 decades!
- Log in to post comments
You started webserver here
04/29/24-15:09:00:014 (14882) 0 [Utility.Event] Private webserver started on 52773
BUT then you ran a Shutdown
04/29/24-15:09:33:048 (15564) 0 [Utility.Event] Shutdown complete
05/08/24-01:34:34:288 (406) 0 [Generic.Event] Global buffer setting requires attention. Auto-selected 25% of total memory.
and Webserver was NOT started again 9 days later
in fact the whole startup is incomplete.
You may take a look to this old article on a similar case
OR see doku: Restart Webserver
Start/Stop of the container might be the last to try
- Log in to post comments
some decade+ back there was a decision that SQL should be identic
whether embedded, in SMP, ODBC, SQL Shell, or SQL.Statement.
- Log in to post comments
your CASE statement is wrong in multiple ways:
and doesn't work in ENSEMBLE /Caché either
- double quotes " mark column names, strings require single quotes '
- !="" is an Objectscript construct
- you have to write NOT IS NULL instead
select CASE WHEN StarterKitName NOT IS NULL THEN ....See also example in ENS/Caché docu :
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_case
- Log in to post comments
💐 Thanks! @Iryna Mologa
- Log in to post comments
I reproduced it on my machine
* Not so much surprise:
* Your messages.log is missing at least 50 lines of startup (after the -------- mark)
05/08/24-13:40:53:035 (455) 0 [Utility.Event] Using OpenSSL 3.0.2 15 Mar 2022
05/08/24-13:40:53:149 (455) 0 [Database.MountedRW] Mounted database /usr/irissys/mgr/iristemp/ (SFN 3) read-write.
05/08/24-13:40:53:155 (455) 0 [Utility.Event] /usr/irissys/mgr/iristemp/ initialized as IRISTEMP
05/08/24-13:40:53:156 (455) 0 [Utility.Event] Switching to default %SYS Namespace
-----------------------------------------------------------------------------------------------------------
05/08/24-13:40:53:186 (456) 0 [Utility.Event] Log Monitor Started
05/08/24-13:40:53:300 (457) 0 [Utility.Event] Clean Daemon Started
05/08/24-13:40:53:311 (455) 0 [Utility.Event] No archives configured
05/08/24-13:40:53:321 (455) 0 [Utility.Event] Performing Journal Recovery
05/08/24-13:40:53:322 (455) 0 [Utility.Event] Graceful system shutdown, journal restore not required
05/08/24-13:40:53:322 (455) 0 [Utility.Event] Graceful system shutdown, transaction rollback not required
05/08/24-13:40:53:338 (455) 0 [Utility.Event] START: /usr/irissys/mgr/journal/20240508.001
05/08/24-13:40:53:368 (455) 0 [Generic.Event] INTERSYSTEMS IRIS JOURNALING SYSTEM MESSAGE
Journaling started to: /usr/irissys/mgr/journal/20240508.001
05/08/24-13:40:53:368 (455) 0 [Utility.Event] Journaling to /usr/irissys/mgr/journal/20240508.001 started.
05/08/24-13:40:53:368 (455) 0 [Utility.Event] Processing WorkQueues section
05/08/24-13:40:53:371 (455) 0 [Utility.Event] Processing Startup section
05/08/24-13:40:53:387 (458) 0 [Utility.Event] Purging old application errors
05/08/24-13:40:53:387 (455) 0 [Utility.Event] Processing config section
05/08/24-13:40:53:399 (459) 0 [Utility.Event] LMF Info: Licensed for 8 users.
05/08/24-13:40:53:412 (455) 0 [Utility.Event] Initializing Security system
05/08/24-13:40:53:432 (455) 0 [Utility.Event] Processing Network section
05/08/24-13:40:53:435 (455) 0 [Utility.Event] Activating Network
05/08/24-13:40:53:439 (455) 0 [Utility.Event] Processing Databases section
05/08/24-13:40:53:545 (455) 0 [Database.MountedRW] Mounted database /usr/irissys/mgr/irisaudit/ (SFN 4) read-write.
05/08/24-13:40:53:549 (455) 0 [Utility.Event] Processing Namespaces section
05/08/24-13:40:53:549 (455) 0 [Utility.Event] Namespaces are up to date
05/08/24-13:40:53:549 (455) 0 [Utility.Event] Activating namespaces
05/08/24-13:40:53:551 (455) 0 [Utility.Event] Activating new namespace map
05/08/24-13:40:53:563 (455) 0 [Utility.Event] Namespace changes have been activated
05/08/24-13:40:53:572 (462) 0 [Utility.Event] Starting superserver on port 1972
05/08/24-13:40:53:572 (455) 0 [Utility.Event] Network Lock Upload Phase Starting
05/08/24-13:40:53:572 (455) 0 [Utility.Event] Lock Upload Phase Complete
05/08/24-13:40:53:572 (455) 0 [Utility.Event] Processing Miscellaneous section
05/08/24-13:40:53:596 (465) 0 [Utility.Event] Starting Servers
05/08/24-13:40:53:597 (455) 0 [Utility.Event] Processing Devices section
05/08/24-13:40:53:601 (455) 0 [Utility.Event] Processing DeviceSubTypes section
05/08/24-13:40:53:606 (455) 0 [Utility.Event] Processing MagTape section
05/08/24-13:40:53:608 (455) 0 [Utility.Event] Processing IO section
05/08/24-13:40:53:610 (455) 0 [Utility.Event] Processing SQL section
05/08/24-13:40:53:612 (455) 0 [Utility.Event] Processing Macro Pre-Processor (MPP) section
05/08/24-13:40:53:613 (455) 0 [Utility.Event] Processing OS Package Requirements section
05/08/24-13:40:53:680 (455) 0 [Generic.Event] Auditing to /usr/irissys/mgr/irisaudit/
05/08/24-13:40:53:705 (455) 0 [Utility.Event] Executing ^ZSTU routine
05/08/24-13:40:53:706 (455) 0 [Utility.Event] Executing ^%ZSTART routine
05/08/24-13:40:53:707 (455) 0 [Utility.Event] Enabling logons
05/08/24-13:40:53:711 (465) 0 [Utility.Event] Private webserver started on 52773
05/08/24-13:40:53:711 (465) 0 [Utility.Event] Processing Shadows section (this system as shadow)
05/08/24-13:40:53:714 (465) 0 [Utility.Event] Processing Monitor section
05/08/24-13:40:53:724 (616) 0 [Utility.Event] Starting TASKMGR
05/08/24-13:40:53:797 (455) 0 [Database.MountedRW] Mounted database /usr/irissys/mgr/user/ (SFN 5) read-write.
05/08/24-13:40:53:801 (617) 0 [Utility.Event] [SYSTEM MONITOR] System Monitor started in %SYS
05/08/24-13:40:53:815 (619) 0 [Utility.Event] WorkQueue: Starting work queue daemon parent=465
05/08/24-13:40:53:815 (465) 0 [Utility.Event] Shard license: 0
05/08/24-13:40:55:158 (455) 0 [Database.MountedRO] Mounted database /usr/irissys/mgr/enslib/ (SFN 6) read-only. Database label is marked read-only.
05/08/24-13:40:55:161 (455) 0 [Utility.Event] Initializing Interoperability during system startup
05/08/24-13:42:40:619 (653) 0 [Utility.Event] %SYS.Task.FeatureTracker transferred data to ats.intersystems.comEspecially the red marked step wasn't executed.
So no listener on 52773:
Hard to guess the reasons, Docker may run out of resources.( memory ?)
You IRIS is definitely OK.
- Log in to post comments
#1 iris runs in /usr/irissys/
#2 iris view shows the actual status
#3 check messages ./mgr/message.log for detailed reasons
- Log in to post comments
And here is the real documentation on $VECTOR in ObejctScript.
And also well hidden: $VectorOperations
- Log in to post comments
As you now explained what you really are looking for: $System.SQL.Schema.SetDefault()
From Docu:
classmethod SetDefault(schema As %Library.String = "", ByRef oldval As %Library.String, Namespace As %Library.Boolean = 0) as %Library.Status
Sets the default schema used by SQL.
This configuration setting provides the ability to define a default schema name other than SQLUser, the default. When an unqualified table name is encountered in an SQL statement (and there is no #import statement specified), the default schema will be used. This setting has nothing to do with the mappings between SQL schema names and the class package name, it only specifies the default schema. Parameter:
- schema
- String containing the default SQL schema name. If schema is "" or not defined, the default schema will be set to SQLUser.
- oldval
- Passed By Reference. Contains the previous value of the setting.
- Namespace
- Boolean 1/0 flag. If TRUE, set the default schema for the current namespace only. The default for Namespace is FALSE
Returns:
- Status Code
NOTES:
- - You must have the "USE" permission on the %Admin Manage Resource in order to change this configuration setting.
- - Changing this configuration setting will affect all processes immediately.
- Log in to post comments
I found the correct use of host variables in embedded SQL:
UPDATE: TO_VECTOR(:myvec,INT,2)
set myvec="1314,-7979"
Nothing special: Just a plain String with comma separated values
It seems I couldn't believe that simple approach.
My apologizes to ISC Engineering.
- Log in to post comments
I just discovered in class code a different way to get Vector Values from object
USER>set obj=##class(AG.GEO).%OpenId(13)
USER>write obj.VBASE
8EB052EF186E024A8AAC58ED708EB114@$vector
USER>zwrite obj.VBASE
{"type":"integer", "count":2, "length":2, "vector":[4812,-1622]} ; <VECTOR>
;
;;; THIS is from the generated code
USER>set vec=obj.VBASELogicalToOdbc(obj.VBASE)
USER>zw
obj=<OBJECT REFERENCE>[17@AG.GEO]
vec="4812,-1622"
USER>- Log in to post comments
From Terminal in namespace %SYS you can run
- DO ^JOBEXAM
- select your job by list of PID
-
Job# NSpace Routine Commands Globals State PID Current device 23 USER shell 425 64 READ 17060 |TRM|:|17060 Namespace: USER SessionID: Routine: shell Open Devices: |TRM|:|17060* Mem Lim/Peak/Curr: 256M/154K/116K In Trans: No Priority: 8 Info: User Name: UnknownUser Roles/EscalatedRoles:%All/None OS User Name: cemper EXE Name: Client Node Name: TRM: IP Address: 127.0.0.1 Location: PrivGblBlks: 3 Last reference: ||RCC(5) Current line: Entry Process X# S# Flg Item Locked (V)ariable, (L)ocks, (S)tack, (P)rocess Private Globals, (Q)uit => P - and can see PPG
Process Private Global (?): RCC ^||RCC(1)=1 ^||RCC(2)=2 ^||RCC(3)=3 ^||RCC(4)=4 ^||RCC(5)=5 Process Private Global (?):
- Log in to post comments
Hi @Michael Davidovich !
you hit exactly what I addressed in in my recent article
The bewitched line terminator
As long as you get (text-) files from your own OS the default is OK
BUT: if you work cross OS platforms - rather likely for CSP pages -
the approach of %CSP.BinaryStream is the best for import.
For output stream you have to decide based on the expected target OS.
My personal trigger to that subject was file transfer between
WIN as Docker host and a Container (Ubuntu) causing a lot of confusion until detected.
- Log in to post comments
System Utility %ETN.int takes a snapshot with all actual variables somehow similar to WRITE command
Description: Using %ETN
It may give you some feeling how to analyze a running process.
ATTENTION:
reading requires some experience in ObjectScript
you might get lost
- Log in to post comments
Functional Background (since decades)
- simple ; (semicolon) is passed down into the final .INT code (and generated .OBJ)
useful it working with $TEXT() function
while
- #; in CLS or MAC is skipped while compiling .INT
so it is smaller saves space
mainly useful for larger comment blocks kept for documentation
- Log in to post comments
Is there some deeper reason not to contact LIB-IT DMS that produced FILERO ?
They should know from the hip where their code is located and how to move it.
As your installation is talking German, there should be no lingual hurdle.
They even offer TeamViewer Support
- Log in to post comments
Are you sure your HealthShare and the related ODBCdrivers are all 64bit?
the ending U of your $ZV might mean Unicode == 64 bit
And OK. SMP doesn't need any ODBC
- Log in to post comments
If XML content is well formatted
it might be sufficient to remove all trailing text before
<?xml version="1.0" encoding="UTF-8 ?>
- Log in to post comments
still works.
* don't forget all CSP content
* don't forget to run $SYSTEM.OBJ.Upgrade()
- Log in to post comments
Way back some years I simple renamed CACHE.DAT to IRIS.DAT with IRIS stopped.
No guaranty this still works.
- Log in to post comments
For testing I'd suggest to try an IRIS Community version
Latest IRIS 2024.1 runs fine on Win11
the testing effort for that archaic code would be the same either for IRIS or latest Caché
the gap to bridge is about 2 decades in any case
- Log in to post comments
you describe 2 different record layouts that reside within the same storage
#1 - just a name
#2 - a name + a "transferred" property
depending on the situation you use either layout #1 or layout #2 for INSERT
reading might be OK for layout #2 in both cases.
Caché once had a somewhat similar sample with Person
and Employee extending Person.
available here: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=ASAMPLES
this Repo:
https://github.com/intersystems/Samples-Data/tree/master/cls/Sample
- Log in to post comments
set var="MyClass"
execute "set obj=##class("_var_").%New()"a bit dirty but matches your request
- Log in to post comments
BTW: from bash inside the container run
/iris-main -h
to see all available options
- Log in to post comments
in docker-compose.yml set
command: -b "sleep 1d" - then you have a full day to access your container
- start IRIS manually from bash as you need it
- Log in to post comments
CONGRATULATIONS to the Winners !
- Log in to post comments