#Caché

When working with the dateText component in a Zen Application and setting the parameters "format:DMY" and "separtator:/" I cannot save the  right date to the database.

In short, I have a structure similar to :

Class View.A Extends  %ZEN.Component.page{XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{... <dataController id="a-controller" modelClass="MVC.A"/> <dynaForm id="a-form"  controllerId="a-controller" onsubmit="return zenPage.saveForm();"/>}}

Class MVC.A Extends %ZEN.DataModel.ObjectDataModel{Property DOB As %Date  (ZENATTRS =

Hi,

I'm trying to send emails to a distribution list but it doesnt work. However, When I send emails to individual emails it works fine. Is there a configuration that I need to be checking or enable?

I'm doing it within a Business Operation:

Set SendList="grouplist@email.com, eric@email.com"f a1=1:1:$l(SendList,",") s ToAdd=$p(SendList,",",a1) d  .Set Mailer = ##CLASS(%Net.SMTP).%New().Set Mailer.smtpserver = "10.xx.200.000".Set Msg = ##class(%Net.MailMessage).%New().Set Msg.From="manager@email.com.Do Msg.To.Insert(ToAdd).Set Msg.Subject = "Sample Email to distribution list".S

Hi All

I'm sharing this ticket just posted to wrc as I believe it is inconsistent behaviour. and other developers may trip over it....

<wrc ticket>

I have found something that appears to me to be inconsistent
Simple example

set x={"theValue":true} write x.theValue
this correctly converts true to 1

However if " (double quotes are placed around it
eg
set x={"theValue":"true"} write x.theValue
it does not convert and displays the string "true"

!!!!!

</wrc ticket>

Peter

The documentation only provides the syntax but does not provide any sample DDL for this case.

I am modifying some DB2 queries to Cache SQL but always meet some errors, please provide a sample query for this case.

Thanks.

Hi,

Please let me know best way to restore single cache database of 300 GB from one server to another with minimum downtime.

Cold backup will take lot of time for 300 GB database size and snapshot backup not possible.

Not sure about cache online backup which take all databases backup.

Hi Guys,

is the there a way that I can make a routine call from one cache to another?

I've a client that still on Cache 2008 and given that JSON is not much supported in V2008 we thinking of installing Cache 2014 in the same server Create a routine that handles JSON (in Cache2014), and then simply call in their current Cache 2008 just make a routine call of that is V2014?

thanks

hi

    I cannot connect to Caché sometimes,   the error message is 

            [Cache JDBC] Communication link failure: Communication error: Connection reset

   and I cannot access the management portal

so I plan to restart  Caché with "ccontrol stop cache"， it prompted "unable to get access to pid table"

what's the problem?

thanks!

I am managing a very large logistic's software company utilizing Cache as the main infrastructure.

I have many customers around the world and I need to upgrade the authentication process add 2 factor authentication, access management, captcha etc.

Does anyone have experience with this ? are there any suggested external software that can be integrated with our infrastructure ?

Hello ISM Community,

Is it possible to copy all the classes in a package to a new package in Studio?

If not does anyone have some ObjectScript code that does this?

Regards

Mike

In this article I would like to present the RESTForms project - generic REST API backend for modern web applications.

The idea behind the project is simple -after I wrote several REST APIs I realized that generally, REST API consists of two parts:

• Work with persistent classes
• Custom business logic

And, while you'll have to write your own custom business logic, RESTForms provides all things related to working with persistent classes right out of the box.
Use cases

• You already have a data model in Caché and you want to expose some (or all) of the information in a form of REST API
• You are developing a new Caché application and you want to provide a REST API

Hello, I'm trying to install CSP Gateway on Ubuntu 18.04 (Apache) with the installer CSPGateway-2018.1.1.638.0-lnxubuntux64.tar.gz but it doesn't seem to work.  I keep getting access-denied when I try to open CSP-pages or the CSP Management portal.

Does someone have an installation-manual or so ?

Hi all,

Do you know if there is a way to create a Lock that is related to an existing transaction, in the sense that if transaction is finished (commit or rollback) Lock is removed. I ask this because in the following example Lock is there until process is killed.

Example :

TSTART

Lock  +^MyLock

TROLLBACK

I know, that, Caché itself is locking internally a table register  when doing an OpenId with exclusive flag during the transaction life. For example :

TSTART

Do ##class(MyTable).%OpenId(<TableID>, 4) (This internally is creating a Lock +^User.MyTable(<TableID>)

TROLLBACK (This action removes the

Hello,

In all web services, i need to my get login and token. So with Postman, i tried to call a HTTP request where I put the login/token in the header :

I tried to get data from Http request header. The REST APi use %CSP.REST. I tried something like that : 

But it didn't work..

Someone can give me some example or other method ?

Regards,

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:

• First article
  • Git basics, why a high-level understanding of Git concepts is important for modern software development,
  • How Git can be used to develop software (Git flows)
• Second article
  • GitLab Workflow - a complete software life cycle process - from idea to user feedback
  • Continuous Delivery - software engineering approach in which teams produce software in short cycles, ensuring that the software

Would anyone recommend techniques on how to limit the amount of calls that external groups are making to our resources?

Recently we had an issue where one of our ODBC accounts maxed out the license to one of our DB servers (50 max).

I have been tasked with creating a class that will handle error logging in a consistent manor for an application I am working on.  The need is to have all variables in the calling method logged along with some other information. 

The example given was zwrite which is exactly what I need, however, I somehow need to capture the output of ZW and put it into a database table.  Any easy way to capture this data?  I was able to dump ZW to a file, but that is not ideal.

Any help is appreciated!

Hello Global masters!

I developed Web with Spring framework (JAVA, Jdbc Cache) and I wrote SQL when I made it.

And Window program with VB6, Cache Object and VisM.

Is there a significant performance gap? SQL and Cache Object?

same function, same computer performance just different Java and VB6.

Thank you.

Minsu.

Hello Global masters.

I am junior developer about Intersystems cache in South Korea.

I want to develop process management program on server.

My code :

    .

InterSystems is pleased to announce the availability of these maintenance releases

·         Caché and Ensemble 2017.1.3

·         HealthShare Health Connect v15.03 for 2017.1.3

For Caché and Ensemble

·         Oracle Solaris 10, 11 for SPARC-64 and Oracle Solaris 10, 11 for x86-64 platforms are now approved for release.  They were not available for earlier 2017.1 releases.

·         The full list of corrections can be found in the release notes

·         The version number of the kits is 2017.1.3.317.0

HealthShare Health Connect v15.03 on core technology 2017.1.3.317.0

·         Contains the

Hi, 

someone knows how to change the "required" to portuguese.

it's a property(Required) on persistence.

i want to change from "required" to "obrigatório"

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:

Write "Location: ", <Redirect>,!

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

Write *-3

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?

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// Create new Gateway connection objectset gc=##class(%SQLGatewayConnection).%New()If gc=$$$NULLOREF quit $$$ERROR($$$GeneralError,"Cannot create %SQLGatewayConnection.")//Make connection to target DSNs pDSN="CGDEV"s usr="WINSURGE_DMP"s pwd="xxxxxxxx"s sc=gc.Connect(pDSN,usr,pwd,0)If $$$ISERR(sc) quit scif gc.ConnectionHandle="" quit $$$ERROR($$$GeneralError,"Connection failed")se

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.

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?

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)

Classes that were concerned stayed not compiled

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.

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?

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. Do Intersystems have plans to adopt this "2007 ANSI standard proposal" and "SQL:2016 standard"

My problem is regular need to do analytics on medical lab data dynamics and correlations, and while its always doable by COS and multiple SQL statements, such handcrafting for every new hypothesis/idea or