# Announcements

0
Sorting: By Date
Period: 2018

### Information of Mirror servers

Hi

I'm using this query "Config.MapMirror.List" To get information of the list of servers that are in the mirror system.

I'd like to know how can I know which of the list is the primary and which is the failover or async member.

Is there a way to do it with this query? Is there another query to get this info?

Thanks a lot

0   0 4
174

views

0

rating

I am having trouble configuring the environment in eclipse have download eclipse  for java script and web developers  followed the video but could not connect to the server I have my Apache server 7.0 added to the java environment and I can start and stop the server through eclipse IDE but when I fire atelier and add server I get the above error any help please .This is the first time I am trying to use the plug in through eclipse .Just in case There is another installation I need to do please advice but I am guessing something to do with atelier not seeing my configurations or permissions

+ 1   0 5
215

views

+ 1

rating

Hi,

I have a business service that needs to run only once a day at an specific time. It is important that the service only runs once.

I have tried the scheduler but you can only define the times (start-stop) when the service will be running...so this will not work for me as I need this to run only once.

Looking at the documentation I found "tasks". Apparently this is exactly what I need. As per documentation:

0   0 5
690

views

0

rating

### How to run Backup with Sharding

In a single server environment, it is rather easy to create a transaction consistent backup.

Simplified:
You find (or force a specific point in time with no open transactions.
Freeze your server, take a snapshot and you are done.

+ 7   1 3
256

views

+ 7

rating

### Hiding columns / properties

I have a large and complex class containing information of various sensibility.
I need to hide some properties completely from Object and SQL for a dedicated application.

+ 5   0 1
207

views

+ 5

rating

### Special Char % in SQL Query

Hello everyone,

I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'

But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...

How can I take % to query, with

0   0 3
297

views

0

rating

### How to Open Terminal In Caché Mac OS

HI,

I am a newbie so excuse my basic questions.

I have installed Caché on Mac Os High Sierra 10.13.6 and have started the ObjectScript tutorial but I cannot open Terminal in Caché.

The instructions provided on the tutorial don't appear to be for Mac OS as there is no cube icon:

0   0 5
451

views

0

rating

### Incrementing Session ID through BPL

I have several BPL's that act like SQL Server Integration Services (SSIS) where they are transferring data. When I do this they are all being written under 1 session id, is it possible to make the BPL create multiple session ID's as it is cycling through a Snapshot, so it is easier to read in the trace?

Thanks

Scott Roth

0   0 3
334

views

0

rating

### How to get rid of JRNREST annoying questions?

I am still working on a generic task where I need to apply journal file records to another database. Initially I didn't want to use Journal.Restore class methods as I need to perform some data transformation, and it seemed that the clearest way to achieve it was to read journal file record by record using %SYS.Journal.Record API.

+ 3   0 3
249

views

+ 3

rating

Good day,

Is there a way to change the theme in management portal? or at least the color of the header.

Issue is, some users have access to Development and Testing and Production environments. I would like a way to color-differentiate the environments to reduce the errors.

0   0 4
364

views

0

rating

### Can you please fix the 'upload file' button to attach files to posts?

I discovered the upload file button does not appear to work properly but you can still attach files under 'change additional settings'.  Are there plans to fix this?

0   0 1
220

views

0

rating

### Terminal can not be connected.

■Setting up CACHÉ preferred connection server.
server name:localhost
port:1972
Telnetport:23
web server port:57772
CSP server instance:
comment:

■hosts
localhost 127.0.0.1

■os
windows10 (virtual box)

0   0 3
533

views

0

rating

### ObjectScript: Looping over a multidimensional global value and comparing

Hi,

I have a global that holds users name and date of birth.

I would like to loop through them and check if the date of birth is more than 2 years based on todays date

so I have ^checker("under2", "Eric David", "02-05-2018")

I want to check the birthdate based on todays date to see if it is greater than 2. How do I access the birthdate in the global

I tried :

0   0 6
497

views

0

rating

### Copy csv data into a global object

Hi, I have a CSV file with a list of 5000 records in the following format

Name, Acc, division

Eric, 1234, 567

John, 1235, 987

Peter, 3214, 879

I just want to copy the Acc, division to a global so eventually the global would be like the following:

^People("Customers", "Acc.division")

Can you advice on how I can perform this from the terminal? This is a one time task. I want to read all the values from the csv file and insert them into the global

Regards,

Eric

0   0 6
382

views

0

rating

### Rest return 500 error

I have an application which is distributed across maybe 5 servers since it has over a thousand users at a time we had an upgrade to the application last week and I had an integration build that uses the REST service (  ##class(%Net.HttpResponse) but since the upgrade the integration has not be able to communicate with the application tried testing my URL through Postman and all seems ok but if I test direct  I get a 500 error anything that I need to check on please or any advice on how to check what's going on.

0   0 2
159

views

0

rating

### csession with ##class command on a Windows machine

Hi community.

I'm trying to create a "setup" method to be called on a batch script but i'm getting the error <INVALID ARGUMENT> when I pass a string as an argument to this method.

The idea is to call the method with a folder as the parameter, for example:

##class(test.MyClass).MyMethod("D:\path\to\my\file.json")

My class (just for example)

Class test.MyClass

0   0 5
503

views

0

rating

### Using Caché OAuth 2.0 authorization server with password grant

I'm using Caché as an OAuth authorization server and I want to accept the password credentials grant type. I've found that if I make an authorize request, the Caché authorization server requires some URL parameters that shouldn't be required in password grant (redirect_uri, state, scope, and response_type). If I include these parameters, it calls my DirectLogin() method instead of just calling ValidateUser() as I would expect from the docs. I have two questions:

+ 1   1 2
359

views

+ 1

rating

### Pattern matching with '*' and '?'

I have an in-memory list of items and I want to check which items match my pattern string.

Pattern string is a comma-separated list of items and special symbols like '*' and maybe '?'.

There's something similar in $system.OBJ.Compile, it accepts patterns: "*.data.*,Sample.*" - and it would compile 'Sample' package and all 'data' packages. For example: set list=$lb("abc", "c", "aaa", "bbb")
set result = ..match(list, "a*,*b")
zw result
result=$lb("abc","aaa","bbb") Last reply 18 January 2019 0 0 4 294 views 0 rating ### Domains to whitelist to allow Atelier updates? ​​​​​​​Hi, I've been going through the instructions at https://download.intersystems.com/download/atelier.csp Our development team are on the main hospital infrastructure so we need to whitelist any plugin repositories that Eclipse will need to get updates from. I believe I need to whitelist the sites that host the both the Atelier and Eclipse plugin repositories: Last reply 17 January 2019 0 0 2 177 views 0 rating ### Embedding DeepSee Web dashboards into Web Appcation Hi Community, I am using a method taht calls a Dashboard in Deepsee web from an application , but I want to know if it's possible to not showing the header, this part that have the search button, the name of the namespace, etc.. This is the method : Method %OnAfterCreatePage() As %Status { //Set contratistaId =$Get(%session.Data("ContratistaId"),"")
//Set gerenciaId    = \$Get(%session.Data("GerenciaId"),"")

+ 1   0 5
276

views

+ 1

rating

### Entity Framework provider seems to generate incorrect SQL when implementing paging

I've mapped multiple tables (UNION on mapped SQL classes) into a view, using CREATE VIEW.

Through ODBC, in Entity Framework, I am querying against that view and offering paging. The paging is implemented using IQueryable.Skip and IQueryable.Take.

Skip seems to have unexpected results, I believe due to incorrect SQL generated by the Entity Framework provider, though perhaps I've done something incorrectly. The generated SQL looks similar to this (with some bits replaced or altered for security reasons), the basic structure is unaltered.

0   0 2
404

views

0

rating

### XMLIGNORENULL equivalent for object valued properties

I'm writing a SOAP client in Ensemble (2017.2.2) that is required to pass empty elements to the SOAP server in the form <xsi:type="ns:ResponsibleUser"/> where ResponsibleUser is a class that itself has no properties. I initially thought I'd found the answer with the XMLIGNORENULL parameter of XML enabled classes but this didn't make any difference for SOAP requests, only working when I wrote the XML to a file.

0   0 1
164

views

0

rating

### Try to send the JSON stream from Process to Operation and generate file

I created the Process to extract the required data from ADT message to a Dynamic Object. I wanted to send the JSON stream to EnsLib.File.PassthroughOperation operation and generate a file with the content of JSON stream.

Here are the codes for Process:

+ 1   0 3
354

views

+ 1

rating

### How to find multiple substrings in the string optimally?

Example: I have a list of tags that I have to find, and a string with these and other tags separated by commas.
How to find the desired tags in the string optimally?

0   1 4
336

views

0

rating

### How do I specify System Default Setting for Production setting

Added new System Default Setting  for Production (not Host) setting.

However, Production setting is still the same. I have tried restarting Production and instance, to no avail.

How do I specify System Default Setting correctly?

Production:

0   0 3
229

views

0

rating

### Seeking Clarification between REST Web Service and a API call

I am trying to explore some new possibilities outside of the normal day to day HL7 interfacing we do. I have only done 1 other Web Service interface but it was using a SOAP proxy wizard. Now I am tasked with trying to make a call to an external API

https://npiregistry.cms.hhs.gov/api/

+ 3   2 5
528

views

+ 3

rating

### RemoteDatabase Creation Error

How to configure Remotedatabase into our local instance. While connecting remote database i am getting "ERROR #463: Database C:\InterSystems\HealthShare2\mgr\Remote\ is not allowed for ECP Mirror Connection". so can anyone  help me to sort this out.

0   0 0
92

views

0

rating

### Remote Database

How to use remote database in Healthshare , can anyone suggest steps to connect remote database into our local namespace.