Question Thembelani Mlalazi · Mar 27, 2018

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 pobject=##class(%FileCharacterStream).
2
0 771
Question JAQUELINE KRIEGER · Mar 19, 2018

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

3
0 466
Question John Jacobs · Mar 26, 2018

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. Come to find out the client needs the bolding of certain text within printe

5
0 1000
Article John Murray · Nov 7, 2016 1m read

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. "

1
0 658
Question Thomas Noitz · Apr 3, 2018

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

1
0 973
Question Evgeny Shvarov · Mar 31, 2018

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. there a

9
0 559
Announcement Evgeny Shvarov · Apr 1, 2018

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 LebedyukPosts,  667

Peter CooperPosts,  289

Mark ConnellyPosts,  128

Murray OldfieldPosts,  81

Evgeny ShvarovPosts,  60

Artem Daugel-DaugePosts,  52

Alessandro MarinPosts,  36

Top 10 Experts to Follow

Robert CemperAnswers,  +4

Timothy LeavittAnswers,  +3

Tomas VaverkaAnswers,  +2

Eduard LebedyukAnswers,  +2

Dmitry MaslennikovAnswers,  +2

Michael MoulckersAnswers,  +1

Mark HansonAnswers,  +1

Ray FucilloAnswers,  +1

Alessandro MarinAnswers,  +1

John MurrayAnswers,  +1

0
0 270
Question p rd · Mar 26, 2018

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 ]
{

   
6
0 2185
Question p rd · Mar 21, 2018

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

1
0 810
Question Anzelem Sanyatwe · Mar 29, 2018

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'. The problem with this is that when Secondary was full, it did not switch back to 'Primary' and obvio

3
0 1113
Question Diones Forteski · Mar 29, 2018

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 pa

1
0 333
Article Artem Daugel-Dauge · Mar 28, 2018 9m read

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.

1
1 1123
Question Steve Pisani · Feb 28, 2018

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.  This wouldn't be a problem

8
0 859
Question Max Dimukhametov · Mar 21, 2018

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
    Connection=##class(%Library.SQLGatewayConnection).%New()
    sc=Connection.Connect("jdbcurl","user","pass",0)
    If $$$ISERR(scdo $System.Status.DisplayError(scquit
    S sc=Connection.AllocateStatement(.Statment)query="SELECT * FROM students"
    sc=Connection.Prepare(Statment,query)sc=Connection.Execute(
7
0 581
Question Lucas Fernandes · Feb 26, 2018

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?

2
0 1165
Question Minoru Horita · Mar 27, 2018

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?

2
0 486
Question Rosti Zacharias · Mar 21, 2018

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.

6
0 535
Question Davidson Espindola · Mar 26, 2018

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 appli

4
0 340
Article Eduard Lebedyuk · Mar 26, 2018 5m read

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.

0
1 1545