New post
AllAccepted answers
Yuval Golan · Apr 24, 2018

At the Caché side it was generated as %Date using the link table wizard, through the SMP it worked with to_date when it was %Date and worked also after i changed it to %String.

Through terminal couldn't make it work no mater what i tried, not when it is %Date and using $h without to_date nor when it is %String and translating the date to yyyy-mm-dd with or without to_date (at prepare or at execute).

I also tried using ##class(Package.SomeClassName).%New() and %Save()  and it also return ORA-01861 error ($h when %Date and yyyy-mm-dd when %String).

Also %String with %New/Save with "to_string ('"_FormattedDate_"','yyyy-mm-dd')" as the field value returned ORA-01858 error.

Don't know the table/field definition/format at the oracle db - hope to get this info soon.

Yuval Golan · Apr 23, 2018

Still not working in the code, at the SMP it worked in every mode Display/Logical/ODBC. isn't the mode affect only on select statements? At the code i set the property back to %Date, and the sql statement and execute without the to_date, at the execute just converted to $h as you mentioned and i'm getting error [Oracle][ODBC][Ora]ORA-01861: literal does not match format string.

Yuval Golan · Apr 22, 2018

According to your code you know the different subscripts and want to continue on the same clientId and you only care for the first 4 subscripts, so try this (running only on the given clientid so no need to check it, and running only on the first 4 subscripts so no need to check if we are beyond the (or on the same) 4th subscript), haven't tested it!!:

    ; Get log for given 'clientid'
    ; 'maxlog' records max, starting from given 'date','dek','idx'
GetXLog(clientid,date,dek,idx,maxlog) public
{
    set:maxlog="" maxlog=400
    set counter=0
    ; ^cxlog("EFRW1000",20161219,2,1,"date")=20161219
    ;
    ;setting the subscripts for their previous subscripts so the next iteration will get to the values you asked for
    ;if you want to continue after idx and not to repeat idx then comment the next line
    set idx=$order(^cxlog(clientid,date,dek,idx),-1)
    set dek=$order(^cxlog(clientid,date,dek),-1)
    set date=$order(^cxlog(clientid,date),-1)
    for {
        quit:counter=maxlog
        set date=$order(^cxlog(clientid,date)) quit:date=""
        for {
            quit:counter=maxlog
            set dek=$order(^cxlog(clientid,date,dek)) quit:dek=""
            for { 
                quit:counter=maxlog
                set idx=$order(^cxlog(clientid,date,dek,idx)) quit:idx=""
                write idx,!
                set counter=counter+1
            }
        }
    }
    w !
}

Yuval Golan · Jan 17, 2018

I meant from the cache client "cube" I can't get to the System Management Portal of the cache server (the cache server isn't running the IIS server and the IIS is accessible only through https).

Another clarification: at the moment if I want to get to the SMP (System Management Portal) of this server than I chose the SMP in the cube (right click on the cache cube -> Remote Server Access -> Management Portal -> clicking on the server name I want to connect to) and after the internet browser is opened with the wrong url (http) I change it to https and its working.

Yuval Golan · Jan 15, 2018

- 'Should we be using percent globals or %SYS/CACHESYS globals to store the global we want accessible between namespaces? '

I will stay with a no answer (look at @Amir Samary comment).

-  'Can I explicitly address a global in another namespace/database?'

Well -----> Yes you can.

check this out:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GGBL_structure#GGBL_str_extrefs

Yuval Golan · Jun 26, 2017

Hi @Nikita Savchenko

Thanks for a full install info.

I'm using Cache for Windows (x86-64) 2013.1.1 (Build 501_1_13062) Sun Aug 11 2013 23:20:33 EDT

Step 1 and 2 are going fine, i'm able to downlad ver 2 beta8, and i'm able to import and compile it on the %SYS namespace.

At step 3 i'm getting the login page and after i authenticate i get the Cache WEB Terminal in the title but with an empty body.

At step 3 i used IE 11, using the debugger it throw the next error from terminal.js:

"{if("undefined"==typeof JSON)throw new Error("Browser does not support html5 local storage. Please, update your browser")}"

So i tried step 3 on chrome  and now it's better but i get the following error (It's displayed in the body):

"WebSocket connection error (ws://servername/%25WebTerminal.Engine.cls). Trying to connect again in 10 seconds...
WebSocket connection closed. Code 1006, reson: ." which came from terminal.js

And now finally step 3 is working - using chrome and using the port 57772 (instead of 80)  i'm getting the prompt to %SYS namespace.

 

Thank you very much.

Yuval Golan · Jun 25, 2017

Hi there

I just saw the web terminal running on ensemble 2016 , and i'm trying to install it on Cache 2013.1 server.
What should i do in order to install WebTerminal-2.0.0-beta.7/beta.8 on a Cache 2013.1 server?
At what namespace should i import the xml?
Should i manualy set a web application? if so - what should i define?
 

Thanks, Yuval

Yuval Golan · Sep 25, 2016

Write !!,"******************************"
Write !,"Method: Levels With For Structure"
Write !,"******************************"
Set Sub1=""

Do FLevel1

Do ZOrder

Do EndLevels

Quit
FLevel1
     For  {

           Set Sub1=$O(^Trans(Sub1)) Quit:Sub1=""
           Write !,"Sub1: ",Sub1
            Set Sub2="" Do FLevel2

    }

    Quit
FLevel2
     For  {

             Set Sub2=$O(^Trans(Sub1,Sub2)) Quit:Sub2=""
             Write !," ==> Sub2: ",Sub2
             Set Sub3="" Do FLevel3

     }
     Quit
FLevel3
     For  {

         Set Sub3=$O(^Trans(Sub1,Sub2,Sub3)) Quit:Sub3=""
        Write !," ====> Sub3: ",Sub3
        Set Data=(^Trans(Sub1,Sub2,Sub3))
        Write !," ======>"," Data: ",Data,!
    }

    Quit

ZOrder

    Write !!,"******************************"
    Write !,"Method: ZOrder"
    Write !,"******************************"
    Set Global="^Trans"

     For  set Global=$Zo(@Global) Quit:Global=""  Do

     . Set Indent=""

     . For Sub=1:1:$QL(Global) Do

     . . Write !,Indent,"Sub",Sub,": ",$QS(Global,Sub)

    . . Set:Indent="" Indent=">"

    . . Set Indent="=="_Indent

    . Set Indent="=="_Indent

    . Write !,Indent," Data: ",@Global,!

   Quit

EndLevels