Hi All

I have created a SOAP Service from a tutorial, using sample code, as follows:

I need to do an audit of Linked tables which are using a specific SQL Gateway connection, and there are many.

This is defined by the parameter CONNECTION contained within the table class which extends Extends %Library.Persistent

Is parameter exposed within a table somewhere?

Hi Guys

How do get the item name of a class? I have several items derived from the same class, and for error reporting I want to get the name of the item which created it, rather than the class it is derived from from.

e.g. InPhase.LEGACY.GetUpdateNotification, InPhase.LFPSE.GetUpdateNotification and InPhase.ADHOC.GetUpdateNotification are all derived from the same class InPhase.Services.LoadInPhaseUpdates

I'm aware that the $CLASSNAME($THIS) can be used to get classname, but this doesn't help.

Can anyone help?

Andy

Hi

I have a question about terminal, when I run a class from it that contains an error I get a report of error as I would expect, and then an apparently random three letter code is appended to the namespace name in the prompt, as shown below.

GMMHTIE>do ##class(temp.Nothing).What()
 
 w !, tParisAnswer
      ^
<UNDEFINED>zWhat+23^temp.Nothing.1 *tParisAnswer
GMMHTIE 2d1>

Then, when I try to enter a command I get an error

GMMHTIE 2d1>do ##class(temp.Nothing).What()
 
DO ##class(temp.Nothing).What()
^
<COMMAND>^temp.Nothing.1
GMMHTIE 2d1>

Hi

I've started seeing the following alerts in the message log of my Primary HealthConnect server

05/23/24-11:20:09:718 (6732) 2 [Utility.Event] Process 7248 generated 3 alerts in 10 seconds. Suspending alert notifications for this process.

Process 6732 corresponds to 

Hi Guys

Two of the HC servers I manage (a mirrored pair) have lost the ability to debug code, and I am unsure as to why this has happened. Clearly something has changed, as the other three are working just fine.

When I select a Class Method as debug target, add a few break points and run it, I get the following Output

Debugger executing '##class(InPhase.Test.CanUpdate).TestBIU()'
Executing ##class(InPhase.Test.CanUpdate).TestBIU()

<COMMAND>zDebugStub+40^%Debugger.System.1

Program has terminated.
Target has exited debugger

Hi 

I'm having a tidy up of code across my multiple namespaces, and have moved the common code to a new database called DEVTOOLS.

Currently, I'm copying code and updating code into new namespaces. 

How might I make code from namespace available to others?

Cheers

Andy

I've created a Rest Service as described here 

Configured the webapplication as described in the previous link, and now have a URL which I call in PostMan

http://VIR-HC-DEV-01.gmmh.nhs.uk:52773/api/mgmnt/v2/parisconnect/PCRest

Which returns the JSON spec as I would expect:

Update - I answered my own question, so I'll just leave this here in case it can help someone.

Hi All

I'm following the tutorial Creating and Editing REST Services and have reached the step Using ^%REST to Create a Service and have encountered an error.

Here is grab of the terminal command:

Hi All

I'm having a problem with cleaning user inputted text from a HealthCare system my HealthConnect system interfaces with.

The input can be anything posted into an RTF box on an app which stored in oracle, and extracted by HealthConnect from oracle via an XML based API.

When the XML is returned, various values are read out of it using %XML.XPATH.Document and it is the presence certain characters entered into the RTF fields cause XPATH to throw an error. For example,

Hi all

I need to do hardware maintenance on a physical HealthConnect server which forms one half of a mirrored pair, and  It will require multiple restarts.

So, I will need to prevent any HealthConnect services from restarting until all maintenance is completed. Is this just a case of disabling the service "HealthConnect Controller for <SERVERNAME>", or is there anything else I need to be aware of?

Andy

I'm using %XML.Reader  to open an XML file and use it's correlate method to try and convert it to a class.

The conversion fails with an error of:

ERROR #6277: Type attribute, LimitedFreeTextFieldInstance, does not specify valid type for XML input tag: Field (ending at line 3 character 118).

This is the XML

<Fieldsxmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><Fieldxsi:type="UDFLookupFieldInstance"ID="2925"Description="FIRE ALARM ACTIVE"Suffix="FDT_ACTIVATE"/></Fields>

Hi Guys

I've been using the example code %SQL.ExportMgr taken from here (an example from the intersystems community) an am having a few problems with it.

The code I have is below, and I'm having the following problems:

Hi

I have two tables: one a local table using cache and the other is via an SQL gateway connection to an MSSQL Server via a 64bit ODBC driver (ODBC Driver 17 for SQL Server).

When I try to join them on a date field I don't get any matches, and I know that there are matches, e.g. running both views separately returns resuls for 30/11/2022.

The following statement returns rows for the first table r, but nothing for the table l

Hi

Can anyone explain how to display custom icons in a TablePane?

Andy

Hi 

I have a  Zen Page with tablepane which has a datasource in a different namespace to that of the Zen Page. When the page is run, no data is returned and the tablepane is not populate,  even though the rerferenced table contains dat.

The tablePane code is as follows:

<tablePaneid="DataExtractionCurrent"showZebra="true"cellSpacing="2px"OnCreateResultSet="DataExtractionCurrent"></tablePane>

The OnCreateResultSet points to the following method:

Hi

So, I have a zen toolbar and I've figured on how to populate with menu items. How do I add a hyperlink to menu items - I've been all over the support docs, and don't seem to be able to find anything.

Also, I see that this component is marked as deprecated - is there a recommended replacement?

Andy

Hi

I have a Zen toolbar which I want to share across many pages as common feature - I know it can be populated with a javascript clientmethod that returns a JSON on each page as per this example - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

How do I define a common datasource for it so it can be one location and easily updated rather than have it on many pages?

Cheers

Hi Guys

Is there a zen control that exposes the "Copy code to clipboard" functionality , as seen in the code sample of this page?

Cheers

Hi All

I'm building a ZEN page that will dispay HL7 from a database, and am currently displaying it an textarea.

 Is the HL7 viewer that is displayed when HL7 message is selected in a visual trace available as an out of the box tool I can plug into a webpage?

Andy

Hi

The following page references the Zen Demo

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

Where can I find it to download. I'm drawing a blank here.

Cheers

Hi Guys

I have a table data in one namespace that I want to access from another Namespace  - is that possible?

Cheers

Hi all

I have a pair of servers configured as a mirror, each server sits in a separate data centre.

I have noticed that occasionally, the primary will report that the backup is disconnected in the Mirror Monitor, and I believe this to be due to connection conditions between the two data centres.

What I want to do is log the status of both servers from the primary on a regular basis using a service. I know %System.Mirror can return the status of the current member, but how can I log the get the status of the other member as well?

Cheers

Hi

This  morning I noticed that the ISCAgent.log for one of my high availabilty healthconnect servers has many entries that say:

"Mirror remote control command requested access to instance directory not found in registry."
Requested:d:\intersystems\healthconnect\

In addition, Messages.log has many of the following entries:

ValidateFailoverPartner: Failed: Server at SERVER:2188 (d:\intersystems\healthconnect\) sent /NE/ not /OK/...(repeated 20 times)

As far as I can see, nothing has changed on either server (01 and 02) and the arbiter they use is working correctly.

Any idea?

Andy

I have a table with a Varchar(max) column that I have created via the HealthShare SQL portal, and I see that in it's underlying class that column corresponds to a %Stream.GlobalCharacter

When I try to do a text search on that column (referenced as cd.Code in the example below) I get an error

select * 
from DevTools_CodeAnalysis_tables.Code cd
inner join DevTools_CodeAnalysis_tables.MethodData mtd
on charindex( mtd.qualifiedRef,  cd.Code) > 0

It produces the error

 Scalar function CHARINDEX (arg2) not supported for stream fields

How do I search it?
 

Hi Guys,

So I've been following this guide in using a %Library.ResultSet with a  ClassName / QueryName as described in the first example.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

The code I've got so far doesn't work and is as follows:

set rs=##class(%ResultSet).%New()
set rs.ClassName="GMECC.DocmanConnect.Tables.vwNewGPs"set rs.QueryName="GetRows"set sc=rs.Execute("a")  If$$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quitwhile rs.%Next() { do rs.%Print() }		

And the referenced class is

Hi all

I'm working in Zen - how might I get the name of the currently logged in user?

Andy

Hi

I have a few Zen pages, one of which is implementation of %CSP.StreamServer which I'm using to download a PDF file, however, any file downloaded is 5Kb smaller than the original. This is the code I'm using:

Hi all

I have a Zen page which displays the contents of a table. One of the columns is a file path to a file on a local disk.

Is it possible, on a Zen page, to allow that file that described by the file path to be downloaded when a hyperlink is clicked on?

Cheers

Hi 

Does anyone know where the user generated code resides, the stuff one might write for a production,  I presume it lives in a table somewhere within a database?

Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know  I can export it to an XML file and work on that, but direct access on a table would be quicker for me.

Cheers