Try logging into the System Management portal with that user, assuming the user has access to do so.  If you can log in.   Try to switch namespaces and see if you can see the list of namespaces.

One other thing to check is that your user or a role your user is part of has SQL Procedure access to %Library.RoutineMgr_StudioOpenDialog in %SYS

Very nice article. 

I would add some points:

1. With regard to selecting a super class (extends)

• %Persistent - if you want to store data
• %SerialObject - if you want to provide a structure to be stored as part of a %Persistent class, but never as a separate object. (ie not a forgein reference)
• %Registered - if you are creating a class that contains utilility methods or other in-memory only structures.  These classes will never store anything in the database.

  I would also add that IRIS supports multi-inheritence, which many languages do not.  So you can add capabilities to your classes by extending muliple classes.  For example Extends (%Persistent, %XML.Adaptor) creates a class that will support storage to the database and adds XML capabilities like import and export to the class 

   8. error handling

What you indicated is spot on.  I will add understanding and using Exceptions.  If you are working with a new code base using Exceptions for error handling versus returning %Status object is a more modern and better option. If you need to integrate into existing code the direction may be unclear.  In that case returning %Status values may be necessary.
Finally, I would add Post Conditionals that are available on most commands.  This replaces the need to wrap the execution of a single command in an IF statement.  For example, given your code defines an optional feature that is only processed if the feature option flag is turned on.  You could write

if option1 {
    do##Class(Features.Option1).DoSomething()
}

 OR

do:option1 ##Class(Feature.Option1).DoSomething()

Dave, 

Interesting start into Angular.  If I might let me make a couple of suggestions

1) In your update method explicitly test for the put method.  If anything but POST or PUT is gets into this method return an error.  This can avoid security holes in the future or inadvertent changes.  Having gone through a few penetration testing rounds and it can be surprising how and where holes can be exploited.

2) You might want to investigate NG Formly.  This is a great module that allows you to describe your forms in code much like we used to do with ZEN and provides a lot of features.

3) I am not really sure what you truly gain by creating all your own custom components for field types.  That is a question not a criticism.  I would caution on this however as you may end up in the same bind that ZEN was in.  Where you want to use a neat new component you found but have to wrap it or do extra work to incorporate it into your framework.  Going back to item 2 NG Formly, or some other similar toole, may help here.

Is this beta still open?  I heard the date was extended.

Daniel, 

Excellent article both from a historical and current perspective!

Rich

Robert,

I'd be happy to respond.  First I want to confirm/clarify some things.  When you say that you have a Universe database "attached" to Cache I am assuming you mean that you have migrated said database to cache and the data is now stored natively in Cache.

So the short answer is that you never need to do resizing in Cache as was required in Multivalued databases like Universe and Unidata.  The reason for this is that the fundamental storage methodology is quite different.  

In Multivalue (MV) each table/file/Global (to use a Cache term) is a hashed entity.  When created it  starts with a known number of groups that comprise the storage for that table.  Every record stored is "hashed" to determine which group it belongs in.   Another part of defining a hashed table in what MV calls a separation.  This is an indication of the database block size.  As data is inserted into the table groups will tend to fill up.  At this time a new block is added to the group so that new records can be stored.  In a hashed table a give record key will only ever hash to the same existing group.  When looking up a record hashing to the group is very fast.  However once in the group the lookup is a linear function that examines every record in every block of the group to find the record being retrieved. Inserts are always appended to the end of the group.   This is what tends to slow down an MV system.  Pick a poor initial group size or separation size and performance will suffer.  This is the reason for the need to RESIZE.

Cache, at its base table storage level, behaves similar to a key-value store which is internally implemented as a high-performance binary structure.   No hashing is preformed and key look-ups and inserts are consistently extremely fast.  I would also like to correct one thing you stated.  You don't have to be concerned with the initial size of the Cache database as you indicated though getting size close to what is needed is always recommended.  The database can grow dynamically as records are added.  It will grow up to the maximum size of a Cache database within any OS level limitations.  The only performance concern would be disk level fragmentation.  

I hope this helps.  If you have any further questions please reach out. 

Regards,

Rich Taylor

Adam,

First a disclaimer.  I have not worked with Polybase in MS SQL Server. 

From a purely ODBC access perspective my initial thought is the driver you are using is wrong.  Try using the InterSystems ODBC driver which you can obtain from the Software downloads area of the Worldwide Response Center web page.  (https://wrc.intersystems.com/wrc/coDistGen.csp)

Here is the docs for creating an IRIS ODBC datasource on windows just in case.  https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=BNETODBC_winodbc

Hope that helps

Regards,

Rich Taylor

There are two projects in Open Exchange.  I have not worked with them myself, but you could use them as a starting point at least.

https://openexchange.intersystems.com/package/blockchain---%5B-IRIS--python-%5D

https://openexchange.intersystems.com/package/Ethereum-Interoperability-Adapter

Or use embedded Python

for x in [1,2,3,4,5,6,7,8]:
  print('this is x: '+repr(x))

There are two thoughts I have on this example:

• The use of %All is a very bad idea.  This gives the maximum permissions to the connection.  Having just attended a seminar on penetration testing it is frightening how small gaps in security can be exploited to compromise a system.  Better to identify the specific resources  and roles needed for this action to complete and give only those.
• Authentication is only taking place after the connection has "breached the castle walls".   The code is already running inside you environment and with %All privileges

Your utility methods are fine.  However I would implement them using Delegated Authentication.  This feature of IRIS allows you to provide your own code to do authentication.  The difference is that it executes as part of the normal authentication process.  The connection has not yet gained access to the environment and will not gain access if authentication is not passed.  Any failure or attempted breach of the code causes an "Access Denied" message to be returned and the connection terminated.  It is also possible to use this in combination with other authentication methods so this only needs to be used on REST services where it is needed.  This would also remove the need to add any special permissions like %All to the Web Application definition.  Here is the documentation for this.

Delegated Authentication

This command will do this also:

set str ="$lb("""_$replace($listtostring(x),",",""",""")_")"

There is a caveat though,  If the list is empty the $listtostring() will through a NULL exception. So you will need to check for an empty string.

First I have had success just leaving the GetCredentials out, but you are correct in that the documentation says you should have this.  Change your GetCredentials code to be just

return $$$GetCredentialsFailed

This will cause the process to revert to normal username and password prompting.   You only need to implement GetCredentials code if you are pulling the username and password from somewhere else such as taking the authentication header out of a REST call.

Link to the docs   https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GAUTHN_delegated#GAUTHN_delegated_zauthgetcreds

Julio,

Well, the short answer is that you don't.  Solutions like Health Connect/IRIS for Health/Ensemble work autonomously.  There is no one sitting there to respond to the MFA Request.

The way that this is normally handled is by requesting from the MFA provider something referred to by several names.   For example in GitLab you go to your profile and request an "Access Token".  In Gmail you would go to security and get an "App Password".

The SFTP server administrator would likely have to provide this to you.

Usually these are setup specific for your application even specific to the operation if you want.  What this provides is a token that you would use as the password on the authentication.

Hope this helps.

Regards,

Rich Taylor

This error is coming out of IRIS rather than the OS.  To determine what is happening would require knowing the authentication method you are using and the IRIS user you are attempting to log in as.  At first glance I would believe that your organization is in the process of tightening security.  If this worked before and does not work now then the IRIS permissions that control access to Terminal have been removed from your user.   I would discuss this with your system administrators to determine what has changed and have access restored if that is in keeping with policy.

Due to this involving aspects of your security, if you need further assistance I would encourage you to contact InterSystems support rather than share details here.  The contact numbers are:

+1-617-621-0700 (US)

+44 (0) 844 854 2917 (UK)

0800615658 (NZ Toll Free)

1800 628 181 (Aus Toll Free)

You could also use a regular expression with the %Regex.Matcher class

set regex = ##Class(%Regex.Matcher).%New("(/w)*")

The "/w" refers to any word character include alphabetic, numeric, and connecting characters).  This is wrapped in a grouping expression '()' and finally the * say match 0 or more occurences.  

You can then examine the GroupCount and Group multidimensional properties to see the results.

As someone else indicated applications will normally have a configuration page for the driver.  

In dBeaver for example when you setup a connection there is a "Driver Settings" button 

Clicking on this will allow you to configure a JDBC driver for connecting.  To start you would go to the libraries tab and point at the InterSystems JDBC jar file as shown below.  Your path would look something like c:/InterSystemsJDBC/intersystems-jdc-3.2.0.jar (your folder may be different).

Finally on the Settings tab you would indicate the class name and other connection settings

If you are trying to connect programaticaly you can use whatever library you wish and provide the same type information.  Here is an example in Python using the JayDeBe API library.

    IRIS_JARFILE = "c:\JDBCdrivers\intersystems-jdbc-3.2.0.jar"
    IRIS_DRIVER = "com.intersystems.jdbc.IRISDriver"

    JDBC_JARFILES = [IRIS_JARFILE]
    # Database settings - this should be in a config file somewhere# credentials.MyCreds = ["username","password"]
    dbConn = jaydebeapi.connect(IRIS_DRIVER, 
      jdbc:IRIS://10.17.10.84:1972/B360",
      credentials.MyCreds, JDBC_JARFILES)