Are there locks against this global?  You can check this with View Locks in the Management Portal

Also, are you sure that the Backup was taken using an appropriate backup tool?   Generally a backup will be taken from a consistent state, and would not include locking

So I think you're encoding it as an Authorization Header?  

In that case, you can extract this from

set Auth = %request.GetCgiEnv("HTTP_AUTHORIZATION")

then process this however you need to (for example if you have something like "Basic 123908109abc", this will unpack it and decode the Base64)

 set AuthType = $P(Auth," ",1)
  set AuthString = $P(Auth," ",2)
    set DecodeAuthString = $SYSTEM.Encryption.Base64Decode(AuthString)
    set userid = $p(DecodeAuthString,":",1)
    set token  = $p(DecodeAuthString,":",2)

HI Soufiane

I'd need more info about the format of the data and how you are sending it to comment any further

If you're iterating that would typically be done with a CURSOR.  Each fetch cycle would pop the new state of the variables in, in line with each row (make sure you check for SQLCODE while doing this, to determine if there is a row to fetch).

More documentation on this is at

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

EDIT:

Mixed my dynamic SQL methods there.  You would use rset.%Next to do this iteration in %SQL.Statement, but the general theory still holds

http://localhost:57773/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_dynsql#G...

Hi Paul

You will need to execute it after Preparing it

  SET rset = tStatement.%Execute()

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

$EXTRACT can also be used for substringing, and should prove useful

HI Rui

Unicode 0x3 is the ETX character, which can be used as newline in certain text editors.  Any control chars are disallowed in XML processing, so these should be stripped from whatever query you are using to drive this report

HTH

Chris

HI Minu

GBLOCKCOPY is used to create a smaller database, after some data is removed and leaves sparse space in the database.  If your database is full, then copying it will not save space.  Before anything else, you should check the size of your globals and remove any data that you do not need.  GBLOCKCOPY should then reclaim some space for you

Hi Kishan

A method is attached to a specific instance of an Object class.  A Classmethod can be called without having to instantiate the object.

So, we could have a Method on a Person object to update address

do person.UpdateAddress("New address")

Whereas, for a ClassMethod, we could define a Classmethod to give us as object instance to then work on

set person = ##class(User.Person).CreatePerson("FirstName","LastName",Age)

Hope that helps?

Jeffrey, there's usually free parking on Cambridge Parkway, which is a short walk from the ISC Office

Hi Rubens

Fabian wrote a great article about RegExp matching in the Routes here:

https://community.intersystems.com/post/advanced-url-mapping-rest

However, I don't believe that you can do conditional expressions inside the Route.  I think you would instead have to do this in your Method code (happy to be corrected by someone more clever than I am)

HI Sebastian 

You may want to look at the Caché FileServer linked from the comments on this post

https://community.intersystems.com/post/url-security-over-2-applications

This may be a helpful starting point for you?

This tip has saved me a ton of hassle in a number of occasions.  One thing to note is that you will inherit the OS user that Caché is running under, so always remember to select your operating user carefully when installing Caché, so as to not give terminal users network access that they may not otherwise have