Hi guys,
is there any way to configure Ensemle Web Service (EnsLib.SOAP.Service ) to accept HTTP Basic authentication instead of SOAP security headers?
Thanks.
Help, after a day of coding, I wanted to backup my files. I found out that alle of my 3 instances of caché refuse to start.
the error says: cstart-exe-fout (112 Service for Caché instance did not start).
Is there a way to solve this? (off course the management portal does not work either.)
I think there has been a power interruption as the battery from my laptop does not work, and the power went off before
shutdown.
Thanks in advance!
New Book, Caché and MUMPS – Part II
By Paul Mike Kadow
Edited by Deborah Graham and John J. Mitchell
Go to http://cosmumps.org for a download of just the examples of the book and the table of contents.
From the Forward
InterSystems, from a humble beginning, has grown into a worldwide company with its flagship product, Caché, leading the way.
First, this book chronicles and explores some of the many areas InterSystems has grown into and has influenced over the years.
Next, turning to the Caché and MUMPS developer, this book has multiple chapters on Globals, Classes, SQL/Query, etc.
Hi,
I want to splice a PID segement returned from a query, so I can use it in a DTL:
<assign value='context.pidSegment' property='target.{PIDgrp.PID}' action='set' />
I need to set the value of 'context.pidSegment' to something I can use in the DTL objectscript expression
but I'm not sure what method (or property) to use to get the class EnsLib.HL7.Segment segment into a datatype that can be used in the DTL?
I've tried the following to no avail;
- context.K21response.GetSegmentAt("PIDgrp.PID")
- context.K21response.FindSegment("PIDgrp.PID")
- context.K21response.GetSegmentAt("PIDgrp.PID").RawContent
- contex
Hi,
I was wondering if there is any way to count elements from an array. I guess not as an array could be multi-dimensional and that would be a problem to return the number of elements inside the array.
As an example:
S a(1) = "blue"
S a(2) = "red"
S a(3) = "yellow"
w a.count() ==> 3
Information about arrays: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…
Thanks
I have a server with rusw locale but in my cube the time dimension shows dates such as "JAN-2018". Is there a way to either localize that (preferably) or just output numbers like "01-2018"?
Architect:
Analyzer:
Also in architect, in level settings there is a "Time Format" property, what's that? Tried setting it to 3 but it didn't help.
Note: with support for Overlay storage driver for InterSystems IRIS containers this article is no longer relevant. The article is left here for archive purposes.
Does anyone have any sample code for updating Caché users (and specifically Full Name and Comments) via SQL?
Bonus points for knowing specifically what security resource needs to be assigned to allow someone to run the SQL.
Thanks in Advance!
Ben
I have a cache client with a list of several servers.
One of the server is working with an IIS server that is not the Cache DB server.
The connection to the IIS server is only through https (SSL)
I tried to define the Web Server IP Address to https://some.server.name but it didn't let me to specify the https
So I tried to define Web Server Port to 443 but when I chose the SMP it's trying to open http://some.server.name:443/csp/sys/UtilHome.csp
and the same for documentation it tries to open http://some.server.name:443/csp/docbook/DocBook.UI.Page.cls
What should I do in order for the SMP to open the
I'm working on a task where I need to apply journal file records to another database. I can't use Journal.Restore class methods as I need to perform some data transformation, therefore I'm reading journal file record by record using %SYS.Journal.Record API.
It seems that there are only few journal records that I need to process, namely:
Type TypeName 6 SET 7 KILL 8 KILLdes 9 ZKILL 10 RemoteSET 11 RemoteKILL 12 RemoteZKILL 14 BitSET
No problem, while I'm just curious: which COS command could provide KILLdes record? I've met it only once in the context like this:
KILLde
Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain.
I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain?
Thanks
Scott
Hi - has anyone successfully used the python binding on a mac. I carried out the install instructions per InterSystems documentation and it fails completely. 204 warnings and 9 errors. Obviously this was never tested by InterSystems. Is it even worth pursuing?
Thanks
Hi, Community!
This is just a short announcement what we did to make life better on DC for June Release.
What's inside?
Better tables formatting, anti-spam, better email notifications and bug-fixes.
See the details inside!
I need to send a PATCH call from the server to a given url.
Until now I was using %Net.HttpRequest to issue calls for get/post/put but today I had to make a PATCH and I can't find a way to do it.
Hi Guys,
have a file located in \\servername\Myfiles\pull.csv but for some reason my cache routine can't file, but can when using the local drive C:\servername\Myfiles\pull.csv.
FYI I can access \\servername\Myfiles\pull.csv via Win explorer with no problems.
anyway how I can fix this?
Thanks Guys
Hi, Community!
$CASE is a fine syntax sugar for "Ifs" with one-line/one-word expressions, like in docs:
SET daynum=$ZDATE($HOROLOG,10)
WRITE $CASE(daynum,
1:"Monday",2:"Tuesday",3:"Wednesday",
4:"Thursday",5:"Friday",
6:"Saturday",0:"Sunday",:"entry error")But if my expression for a current case is a multi-line business logic? Can I use "{}" somehow or better go with "IF" instead?
Hello community, simple question. I've been able to use a ternary operator equivalent by using $select for inline if statements using this pattern:
set x = 1
set result = $select(x = 1: "true", x = 0: "false")
These can be nested and can have a lot of options. But I'm curious if there is a native way of using ternary operators in ObjectScript?
Thank you
Hi Community!
Save the date for InterSystems Global Summit 2018! This year Global Summit is Sept. 30 – Oct. 3, 2018 at the JW Marriott Hill Country Resort & Spa in San Antonio, TX.
Registration for Global Summit is now open!
Is there a datatype class with validation for global references? I can't find one in a brief scan of the documentation / class reference.
In System Administration | Configuration | System Configuration | Journal Settings there is a check box for Freeze on error.
From reading the documentation, it sounds like the choice to freeze on error is one of system availability vs system integrity.
Curious to know whether Ensemble users choose to freeze on error or not.
If you have a best practice recommendation based upon your experience or knowledge, that would be helpful information too.
I am working with a client to try and export a set of tasks defined in the Task Manager from one system to another. I am not seeing any API for this. I can query this information in SQL. So I tried to use the Data Export Wizard from the System Management portal in the SQL window. Export was fine. Importing failed with a "can't insert into read only field" error. Looking at the class definition does not help since the implementation details are not visible.
So how would one accomplish this? Export scheduled tasks from one system to another?
Hi Everyone!
Enjoy a new session recording from Global Summit 2017 on InterSystems Developers YouTube Channel:
Tell Your Story With Dashboards
Hi guys, I'm helping one of our customer to use unattended install to standardize their deployment. I'm using Unattended Installation and Installation Manifest.
Although I can use the combination to install HealthConnect and then create namespaces and DBs as they need, there are still several tasks that I did not find the solution yet. As following:
1. Configure mirrors
2. Set the directory to store journals
3. For a given Ensemble name space, configure the period length in purging messages.
4. Set up some scheduled tasks to PurgeErrorsAndLogs or PurgeAudit
I wonder whether it is possible to use
Ensemble 2017.2.
I am writing a DTL code action based on the solution described in the posting "How to avoid truncation in HL7 messages with very large fields (32K+)". Because the source value is in a repeating segment, and the specific repetition in which the value is located can vary, I would like to use a variable (specifically the k1 key) to specify the repetition to get. I have been unable to get it to work.
OBXgrp is the location in the path at which the repetition occurs. Hard-coding an index, as in the example below, works.
do source.GetFieldStreamRaw(.stream,
Good afternoon, I have a tabGroup where I populate tabs with images using the scr property. If a user scrolls to the bottom of the image on a tab, when they go to the next tab, they are also at the bottom. When moving between tabs, I would like the user to always be presented with the top of the tab content. I have not been unsuccessful in doing this. Would someone have input on how to make this happen? Thank you in advance for any and all feedback.
I have generated a class using the linked procedure wizard however I can't get it to work if the datatype of one of the parameters is VARCHAR(MAX). It works fine if I change it to say VARCHAR(500) and rerun the stored procedure wizard.
I get the following error returned.:
ErrorMsg: SQLState: (07002) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
Can anyone see what I am doing wrong? I think it is to do with the way I am using the %Stream.GlobalCharacter? Any help is much appreciated.
Class generated by linked procedure wizard:
Inclu
Hi, Community!
This post is a digest of the Developer Community postings in May 2018.
Most viewed
Atelier 1.2 has landed! 190 views
Replacing ZEN - Part 2 - Strategic Issues 156
Atelier 1.2 Beta Updates - May 2018 149
##class( autocomplete for class names 136
How to move defined tasks from one Instance of Cache to another 127
Create table for the results of a SQL statement 123
Using Source Control with Atelier on existing code 116
Continuous Delivery of your InterSystems solution using GitLab - Index 109
In old Caché versions it was possible to create a new role based on predefined %Developer by copying it and adding some resources as needed. It was true at least from 2010.1 to 2015.1.
After upgrade from 2015.1.4 to 2017.2.1 it turned that it's only partially true now. User with a "New-Developer" role can enter Studio and open existing cls/mac/etc for editing and everything is OK unless he tries to create something new (Ctrl-N), than he gets a pop-up with %msg: <User xxx does not have enough privilege to execute stored procedure %CSP.StudioTemplateMgr_Templates>
The solution found was simple:
Hi I am getting below error after rebooting Linux system and restarting cache services.
Daemons are running (shared memory object is missing)
cconsole giving error 3 Daemon WRTDMN (pid 28161) died. Freezing system
