# Caché

124
Sorting: By Date
Period: 2018

### Implementing concurrent access to shared resources using Semaphores

If you’ve ever wondered whether there is a way to regulate access to resources in Caché, wonder no more. In version 2014.2 special classes were added that allow developers to work with semaphores.

Last comment 4 days ago
+ 2   1 3
409

views

+ 2

rating

### Is there a function similar to Oracle's CDC in the cache database?

After enabling archiving log functions, Oracle can get real-time change data through CDC.

Can Cache database realize such functions?

My requirement is to take incremental data from the cache database regularly every day and synchronize it to other relational databases.

Incremental data can be text files.

Last answer 20 September 2018
+ 3   0 6
383

views

+ 3

rating

### How to get rid of JRNREST annoying questions?

I am still working on a generic task where I need to apply journal file records to another database. Initially I didn't want to use Journal.Restore class methods as I need to perform some data transformation, and it seemed that the clearest way to achieve it was to read journal file record by record using %SYS.Journal.Record API.

Last answer 16 June 2018 Last comment 28 August 2019
+ 2   0 3
190

views

+ 2

rating

HI,

I have been using evaluation version of Cache 2017.2, it was working fine and I was using Cache studio, SMP  & Cache Terminal/console till yesterday.

Today, cache was in shutdown status, then I restarted.  But, Cache terminal is not working and showing as Access Denied while otherthings like studio and SMP is working as expected. I checked all security level services on SMP, all are fine and enabled.

Can anyone help me to diagnose the problem and make it working.

Thanks.

Last answer 26 August 2019 Last comment 1 November 2018
0   0 6
481

views

0

rating

### Customizing Management Portal Header

Good day,

Is there a way to change the theme in management portal? or at least the color of the header.

Issue is, some users have access to Development and Testing and Production environments. I would like a way to color-differentiate the environments to reduce the errors.

Last answer 1 August 2019 Last comment 1 August 2019
0   0 4
305

views

0

rating

### Cache Studio 2017.2

Hi all,

I hope this is the right forum to ask this type of question, but I'm running out of ideas.

For reasons beyond my control, we run a version of Intersystems Caché (2013.1) that is not supported by Atelier. As such, I use Caché Studio to do my development.
The issue I have is, I don't run Windows or MAC, but Linux (Ubuntu 18.04 in my case). I've successfully managed to get Studio working using Wine and pretty much everything is usable.

Last answer 4 June 2018 Last comment 26 July 2019
0   0 4
639

views

0

rating

### Get the complete exec statement for store procedure executed with SQL.OutboundAdapter

I am looking to get the exec statement when we call the SP with ..Adapter.ExecuteProcedure.

Set tSQLQuery="exec pSPName ? ?  ?"

Last answer 11 July 2019 Last comment 17 May 2018
+ 1   0 2
167

views

+ 1

rating

### Has anyone used .NET Core EF with Caché?

What would a sample DbContext look like and how would you register the DbContext in the Startup.cs  ConfigureServices method?

Last answer 10 July 2019 Last comment 10 July 2019
+ 1   0 5
294

views

+ 1

rating

### Caché-Python Binding doesn't work

Hello,

I'm trying to set Caché-Python Binding on Mac, but there is a problem.

I performed installation and configuration of Caché-Python binding module based on the manual (URL)
including setting of PATH and LD_LIBRARY_PATH in "bash_profile",
and they seems to be done successfully (there was no error in the process).

Last answer 30 August 2018 Last comment 25 January 2019
0   0 2
294

views

0

rating

### Terminal can not be connected.

■Setting up CACHÉ preferred connection server.
server name:localhost
port:1972
Telnetport:23
web server port:57772
web server ip adress:
CSP server instance:
comment:

■hosts
localhost 127.0.0.1

■os
windows10 (virtual box)

Last answer 25 September 2018 Last comment 23 January 2019
0   0 3
338

views

0

rating

### 2018.1 field test release notes

Downloading the release notes for 2018.1 gives the 2017.1 PDF release notes.

Can someone please correct this or direct me where the release notes could be found

Last answer 8 August 2018 Last comment 11 April 2019
0   0 3
211

views

0

rating

### Continuous Delivery of your InterSystems solution using GitLab - Part IV: CD configuration

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:

Last comment 22 May 2019
+ 2   1 6
875

views

+ 2

rating

### Determine programmatically if unit tests failed

I needed to know programmatically if last ran failed or not.

After some exploring, here's the code:

ClassMethod isLastTestOk() As %Boolean
{
set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result)
for i=1:1:in.TestSuites.Count() {
#dim suite As %UnitTest.Result.TestSuite
set suite = in.TestSuites.GetAt(i)
return:suite.Status=0 $$NO } quit$$$YES } Last comment 13 April 2019 + 1 1 4 289 views + 1 rating ### Replacing ZEN - Part 3 - Progress to date 01 Index to Articles Hi All It's been 6 weeks since my original article - - - - -but I have been busy on this project I have been looking at/thinking about a replacement for ZEN for around 12 months but only really started in depth 4 months ago. Also been in IT for long enough that I can "get a feel" for a product/technology and make decisions accordingly without going into great detail. Any new technology has a learning curve and I don't want to waste time and effort on something that won't fly. And, as always, I am looking to minimise the learning curve as I want to concentrate on delivering business benefit. Last comment 11 April 2019 + 15 0 4 497 views + 15 rating ### Replacing ZEN - Part 2 - Strategic Issues Index to Articles Published 2018-05-11 Last edit - Hi All I this article I detail some strategic issues that a new development UI will need to address - these are the ones that I can think of now - others may come to light during this journey. See the webinar by Eduard Lebedyuk here from the last Global Summit describing modern web development and Caché #### And, as always, if I have missed something please comment.... Last comment 8 April 2019 + 13 2 6 747 views + 13 rating ### Replacing ZEN - Index to articles Hi All This is the index to a series of articles I hope to create over the coming months. ZEN and ZEN Mojo are no longer being actively developed by Intesystems - this is a great shame as it is a fine product that works so well for business applications. However ZEN is a 15 year old product and I need a path forward to replace the ZEN UI with a supported development framework. This article is an index of the other articles I have, or plan to write. - the articles will be subject to change as I develop my thoughts and climb the learning curve. Last comment 5 April 2019 + 12 0 7 766 views + 12 rating ### InterSystems Cache with Laravel (Eloquent) using ODBC Hi Community I have created a simple package that allows the use of Cache with the Laravel Framework. From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package. For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache Thanks in advance Last comment 25 March 2019 + 4 3 3 270 views + 4 rating ### Querying ODBC SQL Server Hi I've got a service setup to query a sql server via ODBC. I've got all the parameters etc setup and everything is ok My Query is Last comment 22 March 2019 0 1 3 0 answers 620 views 0 rating ### Caché eXTreme for .NET - direct access to globals from C# InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET Last comment 19 March 2019 + 4 2 5 648 views + 4 rating ### How to mimic selenium in cache object Script Is it possible to mimic what selenium does like navigating to a site and logging in and filling out a form then logout in COS.I am trying to do that in COS using %Net.HttpRequest class or should I be using a different class the idea is to be able to call a web app login into it and fill out form and log out Last answer 18 March 2019 Last comment 11 December 2018 0 0 3 218 views 0 rating ### %UnitTest.TestCase I need to start doing unit testing for some of my code. Why does it delete the unit testing class from Cache when I run the test? Is there a way to turn this off? Last answer 16 August 2018 Last comment 12 March 2019 0 0 6 316 views 0 rating ### Minimum Monitoring and Alerting Solution InterSystems Data Platform includes utilities and tools for system monitoring and alerting, however System Administrators new to solutions built on the InterSystems Data Platform (a.k.a Caché) need to know where to start and what to configure. This guide shows the path to a minimum monitoring and alerting solution using references from online documentation and developer community posts to show you how to enable and configure the following; 1. Caché Monitor: Scans the console log and sends emails alerts. 2. System Monitor: Monitors system status and resources, generating notifications (alerts and warnings) based on fixed parameters and also tracks overall system health. 3. Health Monitor: Samples key system and user-defined metrics and compares them to user-configurable parameters and established normal values, generating notifications when samples exceed applicable or learned thresholds. 4. History Monitor: Maintains a historical database of performance and system usage metrics. 5. pButtons: Operating system and Caché metrics collection scheduled daily. Remember this guide is a minimum configuration, the included tools are flexible and extensible so more functionality is available when needed. This guide skips through the documentation to get you up and going. You will need to dive deeper into the documentation to get the most out of the monitoring tools, in the meantime, think of this as a set of cheat sheets to get up and running. Last comment 11 March 2019 + 10 5 4 798 views + 10 rating ### Continuous Delivery of your InterSystems solution using GitLab - Part II: GitLab workflow 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 In the previous 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. Still, our focus was on the implementation part of software development, but this part presents: • 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 can be reliably released at any time. It aims at building, testing, and releasing software faster and more frequently. Last comment 1 March 2019 + 5 0 4 1258 views + 5 rating ### Copy csv data into a global object Hi, I have a CSV file with a list of 5000 records in the following format Name, Acc, division Eric, 1234, 567 John, 1235, 987 Peter, 3214, 879 I just want to copy the Acc, division to a global so eventually the global would be like the following: ^People("Customers", "Acc.division") Can you advice on how I can perform this from the terminal? This is a one time task. I want to read all the values from the csv file and insert them into the global Regards, Eric Last answer 26 February 2019 Last comment 19 November 2018 0 0 6 317 views 0 rating ### Rest return 500 error I have an application which is distributed across maybe 5 servers since it has over a thousand users at a time we had an upgrade to the application last week and I had an integration build that uses the REST service ( ##class(%Net.HttpResponse) but since the upgrade the integration has not be able to communicate with the application tried testing my URL through Postman and all seems ok but if I test direct I get a 500 error anything that I need to check on please or any advice on how to check what's going on. Last answer 3 December 2018 Last comment 18 February 2019 0 0 2 126 views 0 rating ### csession with ##class command on a Windows machine Hi community. I'm trying to create a "setup" method to be called on a batch script but i'm getting the error <INVALID ARGUMENT> when I pass a string as an argument to this method. The idea is to call the method with a folder as the parameter, for example: ##class(test.MyClass).MyMethod("D:\path\to\my\file.json") My class (just for example) Class test.MyClass Last answer 31 October 2018 Last comment 14 February 2019 0 0 5 410 views 0 rating ### How to expose Cache data as an OData API? We have a Cache database in Azure, and want to expose it as an OData source (link). My first attempt was to use Microsoft's Visual Studio 2017 and Entity Framework to create the data models...but it seems as if EF and Cache don't work together. (I do have those instructions from 2013, but they don't work. (See other post. Best answer seems to be "migrate to IRIS 2019.1.") Is there any other form of OData support? Last answer 13 February 2019 0 0 2 0 comments 218 views 0 rating ### Using Caché OAuth 2.0 authorization server with password grant I'm using Caché as an OAuth authorization server and I want to accept the password credentials grant type. I've found that if I make an authorize request, the Caché authorization server requires some URL parameters that shouldn't be required in password grant (redirect_uri, state, scope, and response_type). If I include these parameters, it calls my DirectLogin() method instead of just calling ValidateUser() as I would expect from the docs. I have two questions: Last answer 6 February 2019 Last comment 11 February 2019 + 1 1 3 279 views + 1 rating ### GraphQL for InterSystems Data Platforms GraphQL is a standard for declaring data structures and methods of data access that serves as a middleware layer between the client and the server. If you’ve never heard about GraphQL, here is a couple of useful online resources: here, here and here. In this article, I will tell you how you can use GraphQL in your projects based on InterSystems technologies. Last comment 22 January 2019 + 13 9 5 984 views + 13 rating ### Pattern matching with '*' and '?' I have an in-memory list of items and I want to check which items match my pattern string. Pattern string is a comma-separated list of items and special symbols like '*' and maybe '?'. There's something similar in$system.OBJ.Compile, it accepts patterns: "*.data.*,Sample.*" -  and it would compile 'Sample' package and all 'data' packages.

For example:

set list=$lb("abc", "c", "aaa", "bbb") set result = ..match(list, "a*,*b") zw result result=$lb("abc","aaa","bbb")
Last answer 31 December 2019 Last comment 18 January 2019
0   0 4
250

views

0

rating