I have package mapped SYS.History but two classes in the package are giving me problems.

SYS.History.SysData and  SYS.History.PerfData has an Include ( Include (%sySite, MONEXT))

When I try to open the corresponding table in SQL I get the following error

ERROR #5540: SQLCODE: 400 Message: Process 213004 failed to compile Cached Query Class %sqlcq.BAM.cls26 with these errors: ERROR #5475: Error compiling routine: %sqlcq.BAM.cls26. Errors: ERROR: %sqlcq.BAM.cls26.

I need to redirect user to a url, which is 5000+ characters long.
To do that I set:

set %response.Redirect = url

However, in the browser I receive this header:

LOCATION: <First 3972 characters of the 'url' variable>

In WriteHTTPHeader method of %CSP.Response, where the LOCATION header is
written:

After I added a buffer flush, after the above-mentioned line:

Then in browser I received full, correct value of a LOCATION header.
Is there a better solution?
It's a rest API, so maybe there's some callback method I can override to flush the output buffer? Set device mode? Change buffer size?

My new question regards connecting to the external database to insert the data. I have the following code:

#include %occInclude// winsurge6// insert winsurge data into cancer registry database

Compiling routine : winsurge6.MAC
ERROR:winsurge6.MAC(30) : SQLCODE=-30 : Table 'WINSURGE_RESULT_FACT' not found within schemas: CANREG,SQLUSER
 
Detected 1 errors during compilation in 0.026s.

I'm not sure what this error indicates. I've tried a few different things regarding the  #SQLCompile Path=canreg  and the

&sql(WINSURGE_RESULT_FACT 

Hi,

I have a client who is considering encryption options in order to comply with a tendering requirement.

Were they to encrypt the production database then what would be a reasonable expectation forthe impact on message throughput. Or possibly more easily answered: what would be the expected impact be on I/O rate and CPU utilization. Are there any benchmarks to which could support an estimate ?

How would this compare with plan B: to use disk encryption ?

Thanks

Hi, Community!

I have a problem with a table while move it from Cache to SQL Server by SSIS tool, the table was moved but there is an issue in one of the feild, it's bring only the first 2 digit and truncate the other. The datatype for this feild in the Cache is VARCHAR  and the same thing in the SQL, I tried multiple datatype (char, number, intger, text.etc) and multiple tool to bring the table again (ESF, SQL Server 2014 Import and Export Data and FullConvert) and  the same issue appear. The version of the Cache system is : Cache for UNIX (Oracle Solaris for SPARC-64 U2/M) 2012.

If your looking to develop a Node.JS to Caché library then you might want to consider using a pure TCP connection with a custom message transport protocol. This bypasses the native Caché connector libraries that can get stale with a new release.

Node.JS is very good at non blocking code development, so building a performant solution isn't that complex. 

The idea behind this example is that we have a node HTTP server that maps HTTP requests to a Caché TCP connection.

I was following the Node.js: installation and connection test for use with Caché and was wondering how to populate a subscript with a value calculated by a built-in COS function eg. $HOROLOG without having to write wrappers for every built-in function or use temporary global storage. Any ideas?

Hi

We have a vendor that has supplied a cert in .der format, instead of the usual pem or cer formats

is there a way to convert to CER or PEM?

Kind regards, 

Stephen

(PS the interface is HL7 v2 over TLS/SSL)

During programmatic classes compilation performed by the code like this:

set status=$system.OBJ.Load(updaterFile,"cruk-d",,.resList)

strange messages appear in console log, e.g.

05/06/18-15:54:12:424 (308512) 0 oops: was expecting crc 0x21e96e85,5a4c8b2c for rtn (Update.Import.1) rbufnum-15523
...
05/06/18-16:17:45:305 (4224) 0 oops: was expecting crc 0x21e96e85,5a4c8b2c for rtn (Update.Import.1) rbufnum-15523
05/06/18-16:22:30:485 (4224) 0 oops: was expecting crc 0x21e96e85,5a4c8b2c for rtn (Update.Import.1) rbufnum-15523...(repeated 3 times)

If you have ever issued the command ccontrol help to discover what ccontrol is capable of, perhaps you noticed this section:

Syntax:
        ccontrol default
Description:
        Display the name of the default Cache instance,
        if one has been designated.

Hi, Community!

I'm pleased to share the news of Developer Community April 2018 release.

We improved Performance, Tags, and UI. 

See the details below.

1. Performance improvements

We fixed a lot of performance issues and the site became more responsive on main, groups and tags pages.

2. Tags descriptions

All the tags have descriptions nows so it is easier to understand what the tag relates to. E.g. Caché, ObjectScript, Beginner.

3. Special tags

We introduced the option to have "private" tags - the tags, which only dedicated people can put for a topic.

The following post concludes the series with a list of all databases seen in the example for the fully flexible architecture.

Hi Community!

Join us at the FHIR event of the year in the US: the HL7 FHIR Dev Days 2018!
A unique chance to meet 400 colleagues and discuss all topics relating to your field.

InterSystems is proud to be the Host Sponsor of HL7 FHIR Dev Days for its first U.S. edition, Boston, June 19 – 21st! We support the HL7 FHIR standard as it is critical for rapid innovation. FHIR can be used as an accelerant to bring all the information that matters for a patent into a unified health record. 

I need to create a document with a root like this:

<?xml version="1.0" encoding="UTF-8"?>
<RCMR_IN200002FI01 xmlns="urn:hl7-org:v3" ITSVersion="XML_1.0">
...

</RCMR_IN200002FI01>

However, the CreateDocument in %XML.Document only allows namespace as an additional argument.

I did override this method, but trying to do something like

Do document.SetAttribute("ITSVersion",,"XML_1.0") only results an empty document with the <?xml> declation only.

-Pasi-

Question:

My journal files are growing  rapidly - what could be the cause? How can I minimize the phenomena?

Is there anything native in Ensemble that will support converting HL7 to PDF?

I see there are numerous examples in .Net and Java for this capability.

Dave

Hi

We are trying to create a new operation wich gets a XML message and send it's contents in an email.

We've used the SOAP Wizard to generate the Proxy Classes but now we are a bit lost...

What we are trying to achieve is to Create appointments in a Outlook Calendar and send emails.

Any insights, news, alternatives or experience about sequence pattern querying like with Oracle's MATCH_RECOGNIZE, more declarative, less simple direct COS way? Both obvious solutions (shadowing data to oracle cloud or implementing MATCH_RECOGNIZE compiler in COS from scratch) seem big overkill.

Hi community.

I want to create a custom list inheriting %ListOfDatatypes in order to implement some methods like Map, Filter, ForEach, but I have some questions.
Just to mention, I have already read the topic about DeclarativeCOS.

When I define a property like following, caché uses %Collection.ListOfDT or %Collection.ListOfObj, as it's shown in the documentation

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_propcoll#GOBJ_propcoll_def.

I have a lookup table and record batch Table I would like to do a count on the records stored in that batch by counting the number of records in that batch that have  a certain key on the responseKey column. This column keys are stored in the look up table for comparison. So I would like to do a join sql pivot that will use my keys stored in the lookup as columns and count as values

so far I have managed to do this but this is not efficient I would like to fire that sql once not on every count

SELECT * FROM
(
SELECT tMatch.DataValue, Count(*)
FROM ResponseRMAP.Record bRecord
JOIN Match ON tMatch.TableName = 'Match' AND tMatch.KeyName = bRecord.ResponseCode
WHERE bRecord.%ParentBatch = 55

)
 

I need to know what options exist to execute methods on the failover members of a mirror system from the primary.

Hello all,

I'm attempting to create a pop-up box with "Yes" and "No" for the buttons. I currently have a JavaScript confirm box but it has "OK" and "Cancel" as the response buttons. I have read that JQuery is a way to do, but is there a possibility of doing this with CSP instead of JQuery?

Thanks

Hello !   I am still trying to get the sample email working on my computer.  I am getting the below error.   I have tried a number of things and researching it on the net.  I am not sure what I am doing wrong.

Below is a sample class that I have been testing.  

Class email.test Extends %Persistent

{

// set myval= ##class(Package.Class).Method(Args)

// set myval= ##class(email.test).XSendSimpleMessage("")

ClassMethod SendSimpleMessage(server As %Net.SMTP) As %List

{

  Set server=##class(%Net.SMTP).%New()

  Set server.smtpserver="Smtp.aol.

Hi Everyone!

Enjoy a new video on InterSystems Developers YouTube Channel:

Sizing and Capacity Planning

Hi WRC,

In a terminal session it is possible to ZLOAD a MAC or INT program and ZP to display it.

Please advise - Is there a similar way of doing this for a CLS?

Best,

Wil

Currently, we are receiving an alert that states, "Write Daemon still on pass 31". It's been that way for a few hours.

I was wondering if it is possible to identify what the WD has left to work on so that we can see how we can reduce this and possibly identify if there are issues with the way something is written.

Thanks in advance for any insight.

Hi,

I'm trying to export a global with this library %Library.Global with this call:

Do ##class(%Library.Global).Export(pstrNamespace, pstrGlobalName, pstrOutputPath,,,"-d")

When I call this method $ZERROR is setted to "<NOTOPEN>OpenDev+15^%Wprim"

Can someone tell me where is the problem on this?

Thanks a lot

Hi,

Is it possible to call a REST service from a business operation in Cache? Does anyone have a sample for me to take a look at.

Note:

I am new to Cache, just started learning:)

What is the best way to pass a list(collection) of integers from one BPL to another BPL?

Here is what I have now, but this doesn't seem to be working. In the CALL to the other BPL I am trying to pass the EOBList. Not sure what I am doing wrong.

<call name='Call COPYBATCH and Finish' target='CopyBatch and Finish' async='1' xpos='200' ypos='850' >
<request type='MSI.IN835.bp.CopyBatchAndFinishOut' >
<assign property="callrequest.StageBatchId" value="context.tStageBatchId" action="set" />
<assign property="callrequest.Filename" value="request.Source" action="set" />
<assign property="callrequest.

Hi everybody,

 I like to know how Ican determine the same colors of Series Detail of a graph that applies to all widjets. I created a theme based on a specific widjet and apply to others, but didin´t  change the colors of the graph. 

 Thanks. 

Jaqueline Krieger