Morning guys  I have a SQL operation that I use to read data and results to a record map. But seems to have trouble saving the objects to a record map as I get this message

ERROR ErrException:
zInsertObject+2^%Library.RelationshipObject.1 -- logged as '-' number - @''

please help  here is my code let me know if I missing anything thank you in advance

Method OnRequest(pRequest As DQToolsSet.PrimaryMessageREQ, Output pResponse As HSCIC.DBS.RequestRBAT) As %Status
{
 #dim status as %Status=$$$OK
    #dim resultSet as %SQL.StatementResult
   
    set

Hi Community!

Check the new video on InterSystems Developers YouTube:

Managed File Transfer

Hi

The message is received at all times.

cconsole.log

(12660) 0 Failed to mount c:\intersystems\ensemble\mgr\ensemble\ because its default collation (20) is not available...(repeated 60 times)

What it this?

Help-me

Tks

The following post is a guide  to implement a basic architecture for DeepSee. This implementation includes a database for the DeepSee cache and a database for the DeepSee implementation and settings.

Hi community,

When I export the cube and the pivots that I made and import to another environment , the calculated metrics and dimension and also de pivot variable didn´t appear in the other environment. Because of this the pivot that use these metrics show error when you try to open. 

I want to know that this behavior is normal or exist a way that you can export everything, independent if you build inside the cube or inside analyzer.  

Thanks.

Jaqueline Krieger

I'm converting a DTM system to Caché and trying to use the Caché Terminal as the UI.I've come across and removed some DTM formatting for printed text that does not do anything in Caché (actually, it caused errors).The printed output to the default Windows printer ("|PRN|") has been working and the printed documents in text-only format look fine.I am testing on a low-end HP laser printer and a Brother laser.The client has done a print test to his own older HP laser from his Caché  instance and the text renders fine.

I'm pleased to see this in the documentation of the just-published 2017.1 Field Test of Ensemble:

"In certain circumstances, it is useful to create namespaces that are not enabled for Ensemble. In this release you can do this by clearing the Make this an Ensemble namespace checkbox when creating a new namespace. "

I've collated a list of public Caché Projects that I've been able to find through GitHub topics and various other searches, let me know if I have missed any and I will add them to the list.

The full list is here...

https://github.com/SeanConnelly/Public-Cache-Projects/blob/master/README.md

Hi guys,

is there an easy way to compare two objects in os?

Example:

I have a registered order-object at runtime. Now I want to call a specific export-service just in the case that sth in this order has changed since the last export. So I have to compare the persisted order-object (last export) with the current order-object.

Ist there an easy way to compare these two objects or do I have to check each object-value separately?

Thanks for your help!

Regards, Thomas

The Link() method of %CSP.Page claims to take a link and an array of query parameters and transform them into a URL. The documentation is here. But when I pass in query parameters, they aren't included.

What am I missing?

How do I use tls v1.2 on older version of  Cache for Windows (x86-64) 2011.1.2 (Build 701) 

thanks,

Rich 

Hi, DeepSee experts!

I need to call a listing programmatically other than the default. 

I can do that with %LISTING keyword. E.g. in Samples:

SAMPLES>d $SYSTEM.DeepSee.Shell()
DeepSee Command Line Shell
----------------------------------------------------
Enter q to quit, ? for help.
>>DRILLTHROUGH SELECT FROM [HOLEFOODS] %LISTING [Listing]

   #  ID   Date City Chan Prod Unit Reve Disc Comm
   1: 475  01/1 Madr Reta Life 1    0.92 20%
   2: 843  01/1 Manc Onli Frui 1    4.95 0%
   3: 808  01/1 Osak Onli Bund 4    79.8 0%

But how can I call custom listings in MDX?E.g.

Hi, Community!

This post is a digest of the Developer Community postings in March 2018.

Most viewed

(Webinar Mar 14) REST API Design and Development  272

Replacing ZEN - Part 1 - Introduction  195

Continuous Delivery of your InterSystems solution using GitLab - Part I: Git  194

REST Design and Development  161

Deployment Strategies: Do You Compile ObjectScript on a Production Site?  161

Angular 4 (2-5), CacheAutentication, Cache2017.1, REST  155

Parallel execution in COS  154

Continuous Delivery of your InterSystems solution using GitLab - Part II: GitLab workflow  144

problems renaming/copying classes  129

Sending Alerts to Mobile Phone using Pushover from HTTP.OutboundAdapter  128

Most voted

Continuous Delivery of your InterSystems solution using GitLab - Part I: Git  6

Replacing ZEN - Part 1 - Introduction  5

Save the Date - InterSystems Partner's Day 2018 in Austria  5

(Webinar Mar 14) REST API Design and Development  5

Replacing ZEN - Index to articles  5

Continuous Delivery of your InterSystems solution using GitLab - Part II: GitLab workflow  4

Minimum Monitoring and Alerting Solution  4

Sending Alerts to Mobile Phone using Pushover from HTTP.OutboundAdapter  3

Caché Native Access — working with native libraries in Caché   3

DeepSee: Databases, Namespaces, and Mappings - Part 1 of 5  3

Most commented

problems renaming/copying classes  19

Deployment Strategies: Do You Compile ObjectScript on a Production Site?  19

GetSwizzled error in cache  14

creating a test server  13

translation of data ready to push to and from a JSON restAPI  13

(Webinar Mar 14) REST API Design and Development  10

Filters in DeepSee Dashboards  10

SqloutBound Adapter with Output to File  8

Multiple installs of Eclipse/Atelier with different server connections  8

How to Call a Custom Listing in MDX?  8

Top 10 Authors to Follow by Views

Eduard Lebedyuk, Posts,  667

Peter Cooper, Posts,  289

Mark Connelly, Posts,  128

Murray Oldfield, Posts,  81

Evgeny Shvarov, Posts,  60

Artem Daugel-Dauge, Posts,  52

Alessandro Marin, Posts,  36

Top 10 Experts to Follow

Robert Cemper, Answers,  +4

Timothy Leavitt, Answers,  +3

Tomas Vaverka, Answers,  +2

Eduard Lebedyuk, Answers,  +2

Dmitry Maslennikov, Answers,  +2

Michael Moulckers, Answers,  +1

Mark Hanson, Answers,  +1

Ray Fucillo, Answers,  +1

Alessandro Marin, Answers,  +1

John Murray, Answers,  +1

Hi, Community!

We introduced new tags for the posts:

• Callout 
• C++

Server:

Class webservice.SOAPResponse Extends (%RegisteredObject, %XML.Adaptor){Property CustomerID As %String;Property Name As %String;Property Street As %String;Property City As %String;Property State As %String;Property Zip As %String;}

//--------------------

///
Class webservice.webServiceServer Extends %SOAP.WebService [ ProcedureBlock ]
{

Parameter SERVICENAME = "webServiceServer";

Parameter NAMESPACE = "http://tempuri.org";

Parameter USECLASSNAMESPACES = 1;

Method info(queryInfo As %String) As webservice.SOAPResponse [ WebMethod ]
{

Problems encountered with Java Gateway

I am writing a framework for use on the Java Gateway. The role of the framework is:

1. Import the framework jar file into ensemble studio (test completed);
2. In the framework jar, handle the related functions of the remaining jar files (the rest of the jar files are written by colleagues).

The general idea is as follows:

Send: Ensemble Java Gateway -> Framework Jar -> Plugin Jar (colleagues write, processing data).
Returns: Plugin Jar (processed return data) ->Framework Jar->Ensemble Java Gateway.

The problems I encountered were:

I refer to gson and Bouncy

We have an application made in asp.net and want to make a integration for our client who is using cache database. So can any one suggest how to communicate with the database as we are new to this system.

Sounds odd - but I encountered it - twice now.Cache was restarted.in that period the primary journal directory was full and it was writing to the secondary journal directory.So upon start-up, it was quite obvious that it was not going to write to the primary.Cache reported this but was able to continue with the start-up but writing to the secondary.All of a sudden it doesn't recognize the 'primary' config any more and started saying 'Alternate and primary journal directories are the same'.

For the browser to not update the screen and direct you to top after the onchange event of the combobox, just remove href="#" from the piece:
html[html.length] = '<tr id="item_'+n+'_'+this.index+'" class="comboboxItem" onmousedown="zenPage.getComponent('+this.index+').itemMouseDown(event,'+n+');" onmouseup="zenPage.getComponent('+this.index+').itemMouseUp(event,'+n+');"><td width="100%"><a href="#">'+text+'<\/a><\/td><\/tr>';

Of course to do this you'll have to customize the %ZEN.Component.combobox component and inherit it from %ZEN.Component.abstractComboBox.

This solved my problem with long

There are numerous ways to interact with InterSystems Caché: We can start with ODBC/JDBC that are available via SQL gateway. There are API for .NET and Java too. But if we need to work with native binary libraries, such interaction is  possible through Caché Callout Gateway, which can be tricky. You can read more about the ways of facilitating the work with native libraries directly from Caché in the article below.

Hi Everyone!

New webinar "Rest API Design and Development" is available now on  InterSystems Developers YouTube Channel:

Hi,

A site has a Mirror set, and an Asynchronous DR.  The disk drives for each of the instances are local disks and the databases are large (>2 TB)

The current backup strategy is started off as using Cache Backup and is still the case today, but the size and time it take t do the backup is obviously prohibitive.

The External Backup procedure requires a Freeze/Thaw of the Cache environment, with a copy of the environment executing between these 2 steps, however, being on local disks, there seems to be no way to quickly copy off the OS files and cache databases in time.

Hi all.

I have some problem with getting data from external source (PostgreSQL) via JDBC and load it in DeepSee and I resolved some problems while writing this question :)

So..Below I proved my steps of working:

1. Created SQL Gateway Connection
2. Created class for loading data via JDBC
   

   S Connection=##class(%Library.SQLGatewayConnection).%New()
   S sc=Connection.Connect("jdbcurl","user","pass",0)
   If $$$ISERR(sc) do $System.Status.DisplayError(sc) quit
   S sc=Connection.AllocateStatement(.Statment)S query="SELECT * FROM students"
   S sc=Connection.Prepare(Statment,query)S sc=Connection.Execute(Statme

Hi community,
I need to monitor Caché Intersystems with some custom indicators.
I started customizing the SNMP Mib.But I've been in a Zabbix event, all speakers use ODBC to monitor their database, Oracle, MySQL, PostgreSQL ...
What is the best way?Use ODBC or SNMP Custom Mib?
What are you guys using?

I am trying to create an iKnow domain programmatically like:

    Set dom = ##class(%iKnow.Domain).%New("TestDom")
    Do  dom.SetParameter("DefaultConfig", "MyConfiguration")
    Set sc = dom.%Save()

   ...

Although "MyConfiguration" sets the language to "ja", i.e. Japanese, it doesn't seem to be respected, and what I see on the top right pane in Knowledge Portal is related concepts, instead of proximity profiles, which I expect to see  in Japanese language mode.

Also resulting segmentation of sentences looks to be it is in English mode.

Can someone tell me how I can do this?

Hi,

There have been similar questions asked before, but a few years ago now. My problem is that when I create an application in plain CSP, a typical link to a page will look like this in the browser..

https://omnidata.com.au/csp/lcda/StudentList.csp?CSPCHD=001000010000EYn…

One user sent back a comment.. 'I'm not using your application as it is un-secure' .. based on the fact that the elements are spelled out in the URL.

Is there now some way of hiding the path and the .csp page in the URL?

Thanks in advance,

Rosti.

Good morning, employees

I'm having trouble compiling in studio, I already reported it to intersystems support, but it did not solve the problem.

when calling a method of a class by putting $, follows an example:

set obj = ## class (% AbstractObject). $ fromJSON (data)ERROR: SearchCep.int (29) # 1011: Invalid name: '## class (% Library.AbstractObject) $ fromJSON (data)': Offset: 45 [SearchCep + 28 ^ SearchCep]

the studio compiles, and the application performs perfectly, but in the studio it presents error.
Someone has already encountered this type of error.

Following is a sample application.

W #

I would like to remove the login requirement, such that when

the Terminal option on the Cache Cube is clicked, the session goes directly

to the mumps prompt.

Also, how can I change terminal user's login password.

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

• Git 101
• Git flow (development process)
• GitLab installation
• GitLab Workflow
• Continuous Delivery
• GitLab installation and configuration
• GitLab CI/CD
• Why containers?
• GitLab CI/CD using containers

In the first article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software.

In the second article, we covered GitLab Workflow - a complete software life cycle process and Continuous Delivery.

In the third article,  we covered GitLab installation and configuration and connecting your environments to GitLab

In the fourth article, we wrote a CD configuration.

In this article, let's talk about containers and how (and why) they can be used.

As an advanced alternative for REST calls, the new vue-qewd plugin for Vue.js allows easy integration with QEWDjs using WebSockets.