Hey Community! 

Welcome to the 3rd edition of the InterSystems Ideas news bulletin! Curious about what has happened on the Ideas Portal since the previous one? Read on!

First of all, we've created a short video that explains the lifecycle of the ideas on the Portal:

⏯ Lifecycle of ideas on the InterSystems Ideas

Hi Team,

Can You please provide the solution of my problem ASAP as below :

How can I import the table using InterSystems Command Line from Terminal based on exported tablename.txt file?

Please provide the command if available.

Note : As I am not able to Login into Management Portal.

Thanks,

Harshdeep Acharya

Hello Community!

We're pleased to welcome @Yuxiang Niu as our new Moderator in the Developer Community Team!

Let's greet @Yuxiang Niu with big applause and take a closer look at his bio!

@Yuxiang Niu is currently the clinical team leader of the Information Center at Beijing Friendship Hospital, Capital Medical University

Here is a brief introduction from @Yuxiang Niu:

I have nearly 10 years of experience in medical informatization. Now I lead a small team focused on the hospital information system (Hospital Information System, HIS) applied research and development based on the Ensemble database.

Hi All,

I want to move into CACHE/IRIS DBA role. Can anyone suggest what all learning must be done in order to move in this role. 

It would be great if you can provide the learning path as well for the topics. (links from I can learn the provided topics)

Thanks in advance!!

We're having a problem with the way Python modules are being cached in Iris. If we modify some code and then reimport a module it is still processing the old code.

E.g. Create a python file:

helloWorld.py

def helloWorld() :
  return "Hello world"

The run the following in the Iris terminal:

Hi

I have a pvot table defined. that generates a set of data.   I want. to. execute the pivot table programatically  which I believe involves using %DeepSee.ResultSet.  Does someone have an example showing how to apply filters to the results?

For. example

[DateTime of Filing].[Date].[Date Filed Year] = &[2023]

Thanks

Hi Community,

I have created Tier 1 CCR and when I move it to Live it shows the below error.

I initially had changes deployed through a different CCR to the TEST environment and were not deployed to LIVE for the same class.

I tried to cancel it so that I can move these latest changes but I still get the below message.

It's time to announce the Winners for December! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in December:

🥇 @Cristiano Silva , InterSystems Developer at First Line Software

🥈 @Iryna Mykhailova , Associate professor, Igor Sikorsky Kyiv Polytechnic Institute

🥉 @Rob Schoenmakers , Integration specialist at SInt Maartenskliniek

Learn more about the competition and our awesome winners below.

Hi Interoperability experts!

I'm into interoperability now with data transformations and I wonder: how can I use DTLs?

I've created one that transform Ens.Request into Ens.Response. How can I use it now in the production?

I'm trying to add the business process expecting to see it available in the list but it seems it is not the case. 

Tried documentation and it doesn't say either what to do after creation the DTL.  If it is obvious could you please help?

Hello Team,

 I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist.

SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000

SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000

Error getting attributeColumn: Name

Error getting attributeColumn: Amount

Error getting attributeColumn: RollNumber

Thanks in advance !!

A Minute Of Laughter on the Developer Community with #InterSystemsMemes.

Here is the Holiday edition of the memes sent/created by Developer Community members!
Enjoy the memes and don't forget to check our Winter Holiday challenges on Global Masters (available till Jan 2).

1. Meme author: @Udo Leimberger

Hi everyone.

I have a use case where I'm using embedded SQL within a Business Process to interact with a SQL table. However, when it comes to deployment into our production, the table wont form part of the deployment package created from the production.

Beyond manually creating the table on the production system, is there a standard way of ensuring that a table needed for a class is created during deployment?

Why I decided to write this

Recently I had the challenge to create a secure authentication method to authorize access to some data, but unfortunately I had zero experience with those security configurations and I felt that I was missing some basic concepts to have a better understanding of the official documentation.

After studying and managing to deliver the classes that I was asked to develop, I'd like to share a little bit of my new knowledge, which helped me follow the topics in the documentation.

A client recently upgraded from Cache2010 to Cache2017 and now reports that for certain tables, WinSQL does not show the indices which were previously visible in Cache2010.  Has anyone heard of this type of behavior before?  Is there a remedy or some change which needs to be made to the table definitions?  Thanks.

Hello community,

is there anything special to consider when running a foundation production regarding purge jobs (Ens.Util.Tasks.Purge)? I am thinking specifically of the QuickStreams, which according to my information are stored in a temporary database until the system is restarted. Since a system reboot is much less frequent then the purges, I wonder what happens to the QuickStreams whose messages and headers have already been purged. Is there a way to view Quickstreams (not content, but rather metadata) e.g. via the Management Portal?

Thanks for your comments and hints,

best regards, Martin

When running the command 

do ##class(TestCoverage.Manager).RunTest(,"/nodelete",.userParams)

I now get the following error. these tests used to run fine.

LogStateStatus:0:TestCoverage.Manager:OnBeforeAllTests:ERROR #6060: Somebody else is using the Monitor. <<==== **FAILED**

Can someone please point me in the right direction?

Hi Community,

I am new to ensemble and cache object scripts ,i am trying to create a business service using Ens.BusinessService

but i have doubt what is the difference or uses between Parameters and property in defining classes in defining business service

Joe

I'm trying to get started with IRIS for Health but every time I got to a step that asks me to install a .whl-package I cant continue. I'm getting an error that the file does not exist.

Here is the complete error message:

PS C:\Users\x\GIT\quickstarts-multimodel-python> pip install nativeAPI_wheel\irisnative-1.0.0-cp39-cp39m-win_amd64.whl    
WARNING: Requirement 'nativeAPI_wheel\\irisnative-1.0.0-cp39-cp39m-win_amd64.whl' looks like a filename, but the file does not exist
ERROR: irisnative-1.0.0-cp39-cp39m-win_amd64.whl is not a supported wheel on this platform.

Am I doing something wrong?

Hi

I'm trying to configure IIS for csp

After following the steps here

Configuring IIS to Work With the Web Gateway (Windows) | Web Gateway Guide | InterSystems IRIS Data Platform 2022.1
 

I get this on accesing a csp page

Web Gateway Version 2022.1.0.209.0

Systems Management
Invalid Request : Cannot identify application path

I need to test specific values in %DeepSee.Dashboard.Utils. For that i have to change them but this appears:

ERROR #5883: Item '%DeepSee.Dashboard.Utils' is mapped from a database that you do not have write permission on.

How can i get past it?

Hello,

Created my Learning Lab yesterday evening and for the first hour or so everything was fine, but after that it just stopped working and I get Server unavailable for Management Portal:

And nothing would load in VSCode

Is there anything to be done? Because I wanted to upload my student's test on it. And the system wouldn't allow me to create another server, because I already have one.

Product version

I try the 2021.2 2020.2 , they own have this issus

For this issus i have submit to dotnet , hope they can solve this or find the reson for this and solve this.

platform

ubuntu using unixOdbc dirver

Describe the problem you're observing:

using dotnet nuget System.Data.Odbc to connet the iris for some sql will have bug on linux,but it is ok on windows
and that driver is ok for other db type .
I have put a issue on dotnet also (dotnet/runtime#80015)
Is anyone can have a look for that

In trying to define a Class Parameter that I can use in SQLComputeCode I can't seem to get any of the syntaxes for the using of the parameter where the SQL compute code will actually evaluate the parameter values. There is nothing specific that I can find in the docs about SQLCompute Code and Parameter usage.

Is there some specific syntax for accessing a class defined parameter in the SQL Compute Code that works?

This is on: IRIS for Windows (x86-64) 2022.1.1 (Build 374U) Tue Oct 18 2022 17:37:34 EDT

Hi Developers!

"objectscript.conn" :{
      "ns": "IRISAPP",
      "active": true,
      "docker-compose": {
        "service": "iris",
        "internalPort": 52773
      }

I want to share with you a nice new feature I came across in a new 0.8 release of VSCode ObjectScript plugin by @Dmitry Maslennikov and CaretDev.

The release comes with a new configuration setting "docker-compose" which solves the issue with ports you need to set up to make your VSCode Editor connect to IRIS. It was not very convenient if you had more than one docker container with IRIS running on the same machine. Now, this is solved!

Read below how it works now.

I want to grant access to view the Error Trap in System Management Portal to certain admins, without giving them access to anything that would alter Caché behavior, such as users or database sizes.  I was looking for a granular Resource that would do this, but haven't been able to find what I'm looking for.

Secondly, I granted %Developer role to my developers, but they don't appear to be able to use custom menus in Cache Studio until I grant them %All. Is there a granular Resource that I could use to add to a custom Role and grant to them that would allow custom menus in Cache Studio?

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Importing Relational Data Using a DDL Script

Hi Guys,

we this format of url with port required, and my guess that if we specify port 57772 as the default port in the web server which I'm assuming that would be Apache , we don't have to specify the port in our url, so how can set a default port in Apache?  

http://localhost:57772/us-serenity/MSDS.SelectApplication.UI.SelectAppl…

Thanks

Hi Community,

Can anyone explain how to apply early binding and late binding to a transformation.

Example:

I have DOB value as 12/12/2000

In transformation i need to format  DOB value to 20001212-->this value i can achieve by using  $E(DOB,7,10)_$E(DOB,4,5)_$E(DOB,1,2)

But how can i apply early binding and late binding to the above Data tranformation?

I have this code:

SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id

What i do to access the "client" name?

set rs = $SYSTEM.SQL.Execute("SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id")

zw rs.%Get("name")
"return functionary name"

In Interoperability productions Inbound Adapters extract and separate retrieval logic from actual payload processing, which is left to a BS.

At a high level, an adapter looks like this:

Class MyAdapter Extends Ens.InboundAdapter {

Method OnTask() As %Status
{
  Set request = ..RetrieveRequest()
  Set sc = ..BusinessHost.ProcessInput(request)
  Set ..BusinessHost.%WaitForNextCallInterval=1
  Quit sc

}
}

However, in many cases, RetrieveRequest retrieves a batch payload, so our adapter looks like this instead:

Class MyAdapter Extends E