Question Dustin Knudsen · Jun 28, 2021

Currently have an SFTP server setup to deliver a CSV file to a company "Company XYZ"

Failed to move '\\dir-01\files\Company XYZ\Outbound\To Be Processed\Company XYZ data v1.csv' to Archive file '\\dir-01\files\Company XYZ\Outbound\Archive\Company_XYZ_v1.csv'

The Business Service File Spec : Company XYZ v1.csv

archive path same as listed above

Is it the File Spec that needs to be changed for this to prevent erroring out? 

2
0 259
Question Michael Lei · Jun 28, 2021

Why do I upload files faster with webservice than with csp?

The soap protocol used by webservice has to go through http protocol. csp directly handles http, no xml encapsulation, so it should be faster.

After testing, for a 1M file, csp is about 0.1s slower. After the gateway connection to 1972, there is a stall of about 0.1s, not sure why.

Is there any way to make the file upload speed of csp faster than webservice?

webservice用的soap协议也得走http呀。csp直接处理http,少了xml的封装,按理来说应该更快。

经测试,1M的文件,csp慢了0.1s左右。在网关连接到1972后,有0.1s左右的停滞,不知道原因。

有什么办法能够使csp的文件上传速度比webservice快吗?

1
0 476
Article Sergey Mikhailenko · Jun 28, 2021 1m read

For a long time, we have been using a utility in production to export the result of a query to an Excel spreadsheet. Moreover, we have applied a modification of it, in which the explicit setting of column formats is a priority.

This utility used the module %SYS.ZENReportExcelExporter and is based on a java program. Every year the report grew and there was not enough java RAM, so we had to increase the value of the environment variable. The value has reached 7gb and now it has become a problem.

We decided to find and create a replacement for the utility.

2
0 549
Question Flávio Lúcio Naves Júnior · May 20, 2021

Hello everyone,

I created a Class with this 3 properties

Class TestDynamic Extends (%RegisteredObject, %XML.Adaptor)
{

Property number As %xsd.string;

Property exam As %xsd.string;

Property result As list Of %DynamicObject;

}

I'm adding objects to list normally

set objTest=##class(TestDynamic).%New()
set objDynamic={"field":"value"}
do objTest.result.Insert(objDynamic)

But when i use this method to convert to JSON

##class(%ZEN.Auxiliary.jsonProvider).
7
0 568
Question Cindy Fawcett · Jun 28, 2021

Has anyone else seen this error?  From the API Manager Catalog, I can select an API and use the "Try it Out" feature.  An error is returned - TypeError: Failed to fetch.

The same Curl can be imported into Postman and executed successfully.  For us, API Manager is in a container and the container can ping the server.

1
0 276
Question Dustin Knudsen · Jun 22, 2021

Currently we're using InterSystems Cache Studio Client 2017.2.2 Build 865

I'm currently going through training and one of the videos mentioned using Control+Space to bring up the content assist window.

It's in reference to Atelier IDE, but I'm curious if Studio also might have a tool similar to that?

2
0 189
Question Purushothaman Thirugnanasambandam · May 26, 2021

Hi Team,
I have a requirement to disable the Production Start/Stop buttons for specific support users. But they should be able to stat/stop Ensemble Hosts.
For that new Role, As per documentation along with other Ens resources, I have added %Ens_ConfigItemRun with RWU access and didnt add %Ens_ProductionRun resource.
This makes the Start/Stop buttons disappear from Production Configuration page ( meeting my requirement). But those users are Unable Start/Stop/Restart Ensemble Business Hosts.

3
0 464
Article Robert Cemper · Apr 26, 2020 5m read

A VIEW in SQL is basically a prepared SQL statement.
It has to be executed and assembled like any other SQL query.
MATERIALIZED VIEW means that the content is collected before hands and can be retrieved rather fast.
I saw the concept first with my favorite competitor named O* and they made a lot of noise about it.

  { favorite: because I could win every benchmark against them devil }

3
1 1013
Article John Murray · Mar 3, 2016 2m read

The purpose of this post is to raise the profile of a powerful mechanism that has long been available to us, and to open a discussion about ways in which it can be used or abused.

You can read more detail about the mechanism here. To summarize, your class definition can use the Projection keyword to reference one or more projection classes. A projection class can implement methods that get invoked at key points in the lifecycle of your class.

A projection class must extend %Projection.

18
1 1715
Job Berta Perez · Jun 25, 2021

Hi,

We have an immediate requirement for an experienced Intersystems Ensemble/Healthshare Connect developer to join our team with a good grounding programming ,Healthcare Integration and experience with InterSystems Ensemble/Healthshare Health Connect.

 

Contractor or Full Time.

 Please if you are interested and need more info contact :

Perez.bertamaria@srft.nhs.uk

0
0 266
Article Michael Braam · Jun 2, 2021 3m read

InterSystems SAM is a great tool to monitor your InterSystems IRIS and InterSystems IRIS For Health clusters on prem or in a cloud environment. This article describes how you can implement a customized alert handler. This is currently an undocumented and most likely an unknown feature of InterSystems SAM. With future releases it will be probably made easier to leverage this useful concept.

In the interest of shortness, I will only mention InterSystems IRIS in this article, but the following applies to InterSystems IRIS and InterSystems IRIS For Health.

2
1 914
Question Nezla · Jun 24, 2021

Hi Guys,

 

for some reason the height in my tablepane are very big, how can I adjust the height in the rows in a tablepane?

 

Thanks

5
0 244
Question A.R.N. H Hafeel · Jun 13, 2021

Hello there community, 

I recently posted an article regarding a technological aspects that could boost the internet speeds of every individual/s personal work station in the given situation of the pandemic. 

But, unfortunately my article is not published and I see it under draft. 

Is there a particular reason for this please?

Have I missed something that needs to be followed? 

Is that why the article that was published is now under the draft section? 

I would like to know more on this please. 

Regards. 

2
0 297
Question Eduard Lebedyuk · Dec 21, 2016

I'm in a process of acquiring a corpus  of documents on educational courses. 

For example there is an educational course called "OOP" and it can have documents from 2008, 2009, ... 2016 etc.
And there are a lot of these courses, each one with programs from different years (hopefully)

So 1 document is 1 programm of one course for one year.

I want to calculate how much does a course changes per year.

7
0 726
Question Utsavi Gajjar · Jun 23, 2021

Hello,

I have a Business Process where I am receiving a JSON payload in the "Body" property of the my request class. I defined a context variable as an object of a class that represents the JSON schema I expect to receive and load the JSON payload in that context variable.

e.g.

/// BPL Definition
XData BPL [ XMLNamespace = "http://www.intersystems.com/bpl]
{
<process language='objectscript' request='mapi.core.msg.rq.RestBusinessServiceRequest' response='mapi.core.msg.rp.RestBusinessServiceResponse' height='2000' width='2000' >
<context>
<property name='cm' type='mapi.exchange.msg.

4
0 436
Question ROBSON SERPA DA ROSA · Jun 23, 2021

Hello community...
As there is a certain restriction of commands in Caché, and assuming that the base of most colleges ends up being MySQL, Oracle, SQL Server and others... And the last two with very simple IDEs to use and with the possibility to handle the operation in the database very well, which IDE (if there is an "official" or something like that) would be the best for me to start working more effectively with Caché?

3
0 538
Question Johnny Wang · Jun 22, 2021

I am using .net to connect to the cache database via ODBC, OdbcConnection connection = new OdbcConnection(dbConnection); connection.Open(); This error is reported when the link is opened, how should this be solved? Thank you very much!

2
0 312
Article Yuri Marx · Feb 18, 2021 2m read

There are many options to do a full security scan in your docker images, the most popular option is Anchore community edition.

Anchore will use the main public vulnerabilities databases available, including CVE.

To install Anchore is very ease (source: https://engine.anchore.io/docs/quickstart/), follow the steps:

  1. Create a folder in your OS and download the anchor docker compose file to the created folder.
    curl -O https://engine.anchore.io/docs/quickstart/docker-compose.
1
1 331