Hi Community!
How do you create SSL Configuration for InterSystems IRIS programmatically? E.g. for installation or deployment case?
E.g. if I need to create a very simple "default" SSL client configuration to let HTPPS Get requests to an arbitrary server?
Hi
I wish to use outlook.office365.com to send emails from an Ensemble production and require assistance on how to configure SSL for the connection
Nigel Salm
Hi All,
I have two tables LB_TestSet and LB_Transfer
LB_Transfer has a list if TestSet row IDs, so i am doing the following join
SELECTÂ
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSetÂ
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' ANDÂ '2019-05-10'Â
Without the date filter the query returns data, but if i add the date filter no data is returned
I also tried using %INTERNAL, %EXTERNALÂ TO_DATE('2009-01-01','YYYY-MM-DD')
if i filter by RowID for example the filters work.(this is to make sure that the where clause is working)
Only the date filter fails.
Any Suggestions
Hi,
recentley we started to work with Atelier & VSTS in our organization .
we are looking for a way to use the VSTS as Our Version/Source control system .
I have read the article about "Continuous Delivery of your InterSystems solution using GitLab" & now trying to find a way to use a similar metodology with the VSTS that we have in our organization.
It Apeares that it is possible to Create a Git Repository in the VSTS but i'm not sure how are we to use it from the atelier.
The main questions are
Need a sample of using %Net.HttpRequest and %NetHttpResponse from Cache to retrieve and then use/reuse a bearer token to send json data to a REST web service.
We have a business service that extendsÂ
This service polls for json files in a folder.
Method signature is like this:
And inside that method it tries to read the content like this:
Hi all,
I wonder how to sync my server code to my local code using Visual Studio Code.
Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.
I thing i shouls opening the ObjectScript: Explorer and select the code directaly, and right click -> Import and compile current file (Ctrl + F7)
If I use this command, the ouptut window shows
Hi everyone,
Im new in cache, i came from Java and im missing some features that i couldn't find in the documentation, I hope you can help me with this questions.
Just a brief introducction:Â
- Im in a project with old cache version, so saddly i can't use Eclipse + Atelier, so im using Studio.
- Currently im in a project with persistent classes, we want to turn apart the globals and focus on tables.Â
The questions:
Is there any way to make something like hibernate for cache %Persistent classes? For example, if i want to get all the records for a table in Java+Hibernate+Criteria i'll do something like this:
myListOfObjects = myPersistentClass.list(); // Equivalent to SELECT *
In cache i have toÂ
Hi,
 I have a permanent job opportunity which would suit anyone (including sponsorship, my license is incoming) who want's to experience the UK (initially London), the requirements are fluent in Cache Objects, SQL, XML, Integration, English Language and be self motivated with a desire to experience London
Hi everybody,
after importing an XML schema from xsd into Ensemble I´d like to add it to my Studio-Project but can´t find the imported schema in the namespace view. For example when working with custom hl7 schema, I could easyly add it to my project under namespace view schemaname.hl7. Is this also possible with xml schema? If so where can I find it on an component level?
kind regards,
sebastian
Atelier has reached a threshold of feature completeness. Atelier 1.3 which is currently in flight will mainly focus on supporting the latest release of Eclipse Photon. After release, Atelier and Studio will continue to receive critical software corrections.
Hello,
Need some technique to solve an issue about zen page table.
- "xyz" table exists in all my namespaces.
I have a simple Zen page in "USER 1" namespace. It has a tablepane which pulls data from "xyz" table.
OnLoad of the page i want the zenpage to pull the data from "USER 2" namespace with same "xyz" table name.
Â
Zenpage has to be in  "USER 1" namespace
Â
I tried to use the server side callback handler %OnAfterCreatePage()Â and do a ZNSPACE "USER 2" but still it is not doing the job of pulling data from another namespace.
Â
Any suggestions will be appreciated.
Thanks,
Jimmy Christian.
Hi All,
Just wondering if anyone had got this working.
In the documentation it says to set the username and password properties of the connection object but these properties don't exist and without authentication I can't connect to the MQ queue.
Any help would be greatly appreciated,
Dave Moss
Hi all. Today we are going to upload a ML model into IRIS Manager and test it.
Note: I have done the following on Ubuntu 18.04, Apache Zeppelin 0.8.0, Python 3.6.5.
These days many available different tools for Data Mining enable you to develop predictive models and analyze the data you have with unprecedented ease. InterSystems IRIS Data Platform provide a stable foundation for your big data and fast data applications, providing interoperability with modern DataMining tools.Â
Hi all,
I have a class that I want to serialize to JSon. So I'm using the object %ZEN.Auxiliary.jsonProvider)
set myClass = ##class(myapp.myclass).%New() set myClass.property1 ="value 1" set myClass.property2 = "value 2" set myClass.property3 = "value 3" do ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tStream,myClass ,,,1,"ed") write tStream.Read()
By definition of myclass, all properties are serialized, that's fine. But I want not serialize the property3. I think is using a XML attribute in the property, or something about. But I didn't find anything about.
Â
Anyone can help me?
Â
The last time that I created a playground for experimenting with machine learning using Apache Spark and an InterSystems data platform, see Machine Learning with Spark and Caché, I installed and configured everything directly on my laptop: Caché, Python, Apache Spark, Java, some Hadoop libraries, to name a few. It required some effort, but eventually it worked. Paradise. But, I worried. Would I ever be able to reproduce all those steps? Maybe. Would it be possible for a random Windows or Java update to wreck the whole thing in an instant? Almost certainly.
I am trying to create an ODBC class that includes all of these as records, but I don't see how I can since the first record has 3 subscripts, the rest have 4 subscripts:
Â
.png)
Here is my current storage definition
here is my trigger:
CREATE TRIGGER "SQLUser".SYM_ON_U_FOR_SYM_CHNNL_125123 AFTERÂ UPDATE Â Â ON "SQLUser"."sym_channel" REFERENCING OLD ROW AS OLD NEW ROW AS NEW FOR EACH ROWÂ Â Â DECLARE @var_row_data VARCHAR(16336); WHEN Â Â ( Â Â Â 1 = 1Â Â Â Â and 1 = 1 Â Â ) Â Â -- I will use OLD/NEW alias here set @var_row_data = ''; LANGUAGE sql insert into mytable (id, data) values(1, @var_row_data);
here is error message
I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show the percentage (100*number of rows for that member/all rows) .It should not matter what dimension is being viewed. Ex
There are a total of 100 rows in the source class.
For dimension columnA which returns value in ColumnA column in source class, 10 rows contain "A" the rest contain "null". When viewed on the analyzer, with columnA as a row and PercentOfAll as a measure, the cells values should be:
"A"Â Â Â Â 10%
"null"Â Â 90%
 I can achieve this using an expression that would be specific to columnA dimension Ex columnA. CurrentMember/columnA.[All columnA].%All
But I do not want to have to define meausure for each and every dimension. I just want to have a measure that will be used for all dimensions. ExÂ
I am building a cube based on a source class, which IÂ Â will call, Â Family.DadÂ
In the class definition for Family.Dad, there is a relationship, offspring As Child Â
In the class definition for Child, there is a relationship called father As Dad Â
In the actual data, a dad can have many children, but a child can only have 1 dad.
Using DeepSee, I am trying to analyze to answer questions such as how many dads have children called Joseph ( Ex dad.offspring.GetAt(x).Name) etc .Â
Is there a way to have a context property be available across 2 or 3 different business processes? For example if I am setting a value in a context property within one business process and want to use the same context property in a second business process, is this possible? Is this something that can be done with the "Context Superclass"?
Hey Community!
The latest webinar, recorded by InterSystems Sales Engineers @Sergey Lukyanchikov and @Eduard Lebedyuk, is already on DC YouTube Channel! Please welcome:
"Machine Learning Toolkit (Python, ObjectScript, Interoperability, Analytics) for InterSystems IRIS"Â
Â
Hello guys,
I have been playing around with the deployment tools from Ensemble (mostly based on this article https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...) , but so far the one thing I still couldn't figure out is how to release the fact that I deleted files/components from my source production and that will get reflected in my target production.
Basically the target production has got A, B, C and D. Source has got A and B, because C and D aren't needed anymore. How do I generate a deployment XML with these information and once I release in the target production, Healthshare will get rid of C and D?
I couldn't find any info in the above documentation, so any tips would be more than welcome.
I have come across a few bugs in the deployment tool in the past and I hope this isn't another one or a lack of the functionality I need
Hi!
Â
When I try to send a hl7 message via TCP / IP with SSL certificate, I get the following error:
ERROR <Ens>ErrTCPTerminatedReadTimeoutExpired: Tiempo de espera de lectura TCP (600) superado mientras se esperaba el terminador SegTerminatorAscii=13, on |TCP|35000|6596, datos recibidos =''
Â
Â
I have increased the response time to 10 minutes but still, I do not get to receive the message.
As I said in the remote system the process of negotiating the SSL certificate takes about 10 minutes and after that the message appears. I think it's too long. Is there any way to see more traces of the SSL certificate negotiation process in Ensemble?
Â
Framing = MLLP
Hey Community!
It's time again for good tidings for you on Global Masters Advocacy Hub!Â
New branded limited edition rewards are waiting for YOU!
Be first to redeem our new prizes! Please welcome:Â
For simplicity let's assume we have a page
Property State As %String = "CA"
Our filter should run this query to show all cities of state ca
"SELECT Name FROM City WHERE State= "_%page.State
When I try to open a DTL in the tabbed editor I always get this error:
You are using Internet Explorer 7. This version is obsolete and is not compatible with diagram editors. Please update Internet Explorer to a recent version.
My actual Internet Explorer is version 11.
I'm running Eclipse Photon.
 Atelier IDE   1.3.141   com.intersystems.atelier.feature.group   InterSystems Corporation
The same error occurred with Atelier 1.2 on Eclipse Oxygen. I've never been able to get this to work.
It seems hard to believe that no one has solved this problem, but I never found any solution at Developer Community.Â
Â
Hello,
I'm trying to get ODBC running on a Mac but I don't get it working.
Has someone an overview how te install,configure and use it in Excel on MacOSX ?
Regards,
Kurt Hofman.
Hi! I'm Andreas, the developer of Caché Monitor.
Caché Monitor is a database tool with special feature for InterSystems Caché. Since today also with support for InterSystems IRIS!
A public pre release is available for download: https://www.cachemonitor.de/cache-monitor-beta-releases/
Please give it a try! Feedback (email preferred) is always very welcome!
Thanks for your time!
Â
Andreas
