I defined the variables in Cache, as follows:

Property Content As% Stream.GlobalCharacter [Required, SqlColumnNumber = 3, SqlFieldName = B_Content];

And then use the SQL statement to add:

insert into table_name (B_Content) values ('very long string');

But the error:

 org.springframework.http.converter.HttpMessageNotWritableException: Could not write content: No serializer found for class com.intersys.jdbc.CacheInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com

Apache Spark has rapidly become one of the most exciting technologies for big data analytics and machine learning.Spark is a general data processing engine created for use in clustered computing environments.Its heart is the Resilient Distributed Dataset (RDD) which represents a distributed, fault tolerant, collection of data that can be operated on in parallel across the nodes of a cluster.Spark is implemented using a combination of Java and Scala and so comes as a library that can run on any JVM.

Hi, Community!

Please find a new session recording from Global Summit 2017:

An InterSystems Guide to the Data Galaxy

I am designing the software architecture for an Ensemble/Healthshare production to be deployed on Amazon AWS EC2 servers (2 mirrored m4.large - 4 vCPUs / 16 GiB RAM running RedHat Linux  3.10.0-327.el7.x86_64 and Healthshare for RHEL 64-bit 2016.2.1). It's a rather CPU-intensive production involving massive XSLT 2.0 transformations (massive both in terms of size and volume). I was wondering if anyone has experience configuring Ensemble productions on EC2 servers. My question or concern has to do with the following statement in the Ensemble documentation:

"InterSystems recommends that, as a

Greetings to all!!!How to get the value of the Content-Type field from the object of the class %Stream.Object obtained with:

stream=% request.GetMimeData (FormDataName, 1)

I tried:

write stream.GetAttribute("Content-Type")write %request.Get("Content-Type")

but always returns a void, although it should be "image/jpeg", "application/pdf" or something like that.
In JS:

    var formData = new FormData();
    formData.append('file', element[0].files[0]);
    console.log(element[0].files[0].type);

The console of browser displays "image / jpeg", "application / pdf",  etc.

Looking through Mirroring routines sources, I've noticed these terms, while even the latest documentation keeps silence on them. I'm just curious what are they, and how to configure / to use them?

Greetings to all!!!Suppose there is a table Mother (ID, Name) and Child (ID, Name, Mother), Mother in the table Childis a relationship.Let's say the task is to deduce the names of all the children whose their moms' names start with the letter 'A', I can do this in two ways in sql, and I can not understand the difference, the pros and cons that when to use:

1) SELECT Child.Name FROM Mother INNER JOIN Child ON Mother.ID = Child.Mother WHERE Mother.Name LIKE 'A%'
2) SELECT Child.Name FROM Child WHERE Child.Mother->Name LIKE 'A%'

I have two databases, and both of them have a global ^Data with subscripts going from 1 to 10 000 000.

I want to get one database with global ^Data but with subscripts going from 1 to 20 000 000.

Since each db is around 100 Gb and they are on a different hosts, what's the best way to merge them?

Hi,

I have a persistent class “sp.SensorReading” which has a number of Properties: Date, SensorName, SensorReading.   (sometimes multiple readings from the same sensor, on a given day)

...
Temp    28 Jan                    33.5
Temp    29 Jan                    31.2
Temp    30 Jan                    33.1
Temp    30 Jan                    34.1
Temp    31 Jan                    32.1
Temp    31 Jan                    33.1

Say I built a cube built to analyse data  from this persistent class.  With a simple date dimension, and SensoRName filter, I can show the default COUNT of readings for a given

Hi all,

For special definition of the company, we need to define a PoolSize according to the environment that the "Ensemble" is working.

So the first try as been add the parameter into "System Default Setting"

However, this parameter is not available in "Setting default values" in Setting tab.

I've opened the code of my production and I've noted that this parameter is a attribute of the XML element of this item

I have a batch record mapper that reads a csv file and passes the message to a process that uses the EnsLib.MsgRouter.RoutingEngine and would like to pass the message to an operation that will output that as a XML file but so far been unlucky as the operation that I use , uses the EnsLib.EDI.XML.Operation.FileOperation which only works with the messages("BusinessOperation class for writing XML messages to a file. Works with XML messages of type EnsLib.EDI.XML.Document.") is there a way to achieve this or somewhere to read in order to achieve this I have asked before on this post but the

Hi all, 

Is there a way to setup a classmethod or routine to execute immediately after cache is started?

I wrote a batch file that does execute the cache start, but I'm getting an Access Denied error on the cession command despite running as Administrator:

ccontrol start HEALTHSHARE1
csession HEALTHSHARE1 -U %SYS "##class(SomeClass).SomeMethod()"

Thanks for the help/suggestions

A lot of tools in InterSystems products are designed to help facilitate high availability solutions (Mirroring and ECP come to mind readily). Since a lot of concerns about these technologies are in a similar thread regarding High Availability, I believe it might be worthwhile to create a High Availability Group within the Developer's Community.
What thoughts do people have on the addition of such a group?

Hi everyone,

before contacting WRC i thought to ask dev com about some questions related to Ensemble DICOM related implementation. These are more practical things and I hope to have someone around with experience in the field. We´ve created a DICOM Worklist application and are now in the process of roll-out.

1) One of our customers came up with a question to bundle modalities of certain locations to use a single Ensemble Service (EnsLib.DICOM.TCPService).

Hi, Community!

We are pleased to invite you to the InterSystems UK Developer Community Meetup on 17th of October!

The UK Developer Community Meetup is an informal meeting of developers, engineers, and devops to discuss successes and lessons learnt from those building and supporting solutions with InterSystems products. 

The Installer Manifest has the option to modify the production level settings for AutoStart but is there a way to change settings such as ActorPoolSize and other settings? What would the format be to change such a setting to change the ActorPoolSize to 2?

<Production Name="MyProduction">

??????

</Production>

Hi,

I am getting the following error while logging in using LDAP authentication,

"An error occurred with the CSP application and has been logged to system error log (^ERRORS)". I've set the connection up and using Authentication Test  was successful. I seem to be able to login as well but keep getting that error. If I allows unauthenticated access then the page works but changing it to LDAP is not working.

The LDAP account once created in Cache has U access to the resource related with the web application.  

Also, when I check the ^ERRORS variable there is no data there. 

Kind regards,

Alice

I was wondering if anyone has a good way to process individual messages from a queue. I run into this fairly often where I have test data coming in that I am queuing at the disabled business process, while I am working on the DTL or class to process the messages. What I would like to do is be able to send one message through to see the effects of my changes. What happens is I turn the business process back on and all of my test data goes through the current DLT/class set up. If anyone has any insight it would be greatly appreciated.

Thanks!

I need to have both Cache and the Mirroring Arbiter startup when the HP UX system starts.  Having not worked on HP UX much I am not familiar with the method for accomplishing this.

I would appreciate any information or even sample scripts that would help resolve this.

Hello Community,

I need advice converting a comma delimited string container with multiple records into some type of recordmap that iterates through all the records.

My string container has several records and I would like to loop through the number of records in the string container and transform each record in the container individually. Number of records will vary but the number of fields per record is static (28 fields). Meaning after every 28 fields, a new record begins. The goal is to convert to individual delimited flat file records.

I am attaching sample data for clarification.

Example :

set property.Name = element.LocalName
set property.Type = "%Library.String"
set property.Parameters = ???

Hi, Community!

We are pleased to invite you to participate in the InterSystems Documentation Satisfaction survey. As part of ongoing efforts to make our content more usable and helpful, Learning Services wants your feedback about InterSystems documentation. The survey covers many different areas of documentation, and you can complete it in about five minutes. The deadline for responses is October 30. Also, responses are anonymous.                                                                                           

The survey is over, thanks!

Hi, folks!

Suppose you called an MDX which takes a really long period of time.

Is there any way to cancel its execution programmatically?

Hi,

I am receiving a CSV file as Ens.StreamContainer using pRequest As Ens.StreamContainer

In the studio code, pRequest.Stream.ReadLine()  returns following records when read in a while loop using pRequest.Stream.AtEnd = 0

Appt ID , Patient ID , Patient Name    , Program ,   Appt Date , Appt Start

       102 ,            1002 ,    "Gene, Jill"       ,  HTR          , 06/06/2017 , 10:00

       103 ,            1044 ,    "Smith, John" ,  HTR          , 06/10/2017 , 08:00

Question:  How do I extract individual data values from the pRequest.Stream  Stream Container?

Has anyone written a custom http adapter that simulates entering data into a web portal?  My support person said to check with the Developer Community.

Sometimes you can face the situation when you did update the web app on Caché server but you cannot get the newest version of the app in a browser.

Here are couple recipes which help me to solve it. From simplest to more sophisticated and not obvious.

1. Refresh page in a browser

In Chrome it is Ctrl+R or 'Refresh' button. Obvious, but helpful.

2. Hard reset in a browser

If you are in Chrome, open Developer tools

and then right click on Refresh button.  Less obvious and very helpful sometimes.

3. Clear cache in CSP Gateway

If 1 and 2 don't work for you, try to flush the CSP Gateway cache.

Open Caché

Hi,

I have a class with around 400k lines and 60 columns. Class storage is Cache SQL storage (Mapped from a global).

 I want to create multiple indices on certain fields.

I am familiar with two approaches:

1. Create a new map (Index type) on a pointer global.

2. Create a bitmap index

Which approach is more recommended to be used in the case I described? If there are any other approaches, I will be happy to hear.

Thanks :)

Greetings,

I'm pleased to invite you to InterSystems Developers Meetup being held in Cambridge on October  25^th at 5:30 PM at the Cambridge Innovation Center!

Hi Community! 

Check a new  session recording from Global Summit 2017:

Angular, JSON, and REST – Oh My!

InterSystems is pleased to announce the availability of these maintenance releases:

• Caché and Ensemble 2017.1.2
• HealthShare Health Connect v15.03 for 2017.1.2

Caché and Ensemble are available on the same platforms as 2017.1.1

• The full list of corrections can be found in the release notes
• The version number of the kits for these releases is 2017.1.2.217.0
• Oracle Solaris 10, 11 for SPARC-64 and Oracle Solaris 10, 11 for x86-64 are not yet approved for release.  They are expected to be included in the next maintenance release.

HealthShare Health Connect v15.03 on core technology