# Caché

126
Posts: Questions
Sorting: By Date
Period: 2018

### How to Open Terminal In Caché Mac OS

HI,

I am a newbie so excuse my basic questions.

I have installed Caché on Mac Os High Sierra 10.13.6 and have started the ObjectScript tutorial but I cannot open Terminal in Caché.

The instructions provided on the tutorial don't appear to be for Mac OS as there is no cube icon:

Last answer 21 September 2018 Last comment 12 days ago
0   0 5
357

views

0

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.

+ 3   0 6
407

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
197

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
526

views

0

rating

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
333

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
672

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
180

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
312

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
317

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
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
373

views

0

rating

### 2018.1 field test 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
216

views

0

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

645

views

0

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
228

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
334

views

0

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
324

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
130

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
426

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?

0   0 2
0

223

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
295

views

+ 1

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
263

views

0

rating

### Entity Framework provider seems to generate incorrect SQL when implementing paging

I've mapped multiple tables (UNION on mapped SQL classes) into a view, using CREATE VIEW.

Through ODBC, in Entity Framework, I am querying against that view and offering paging. The paging is implemented using IQueryable.Skip and IQueryable.Take.

Skip seems to have unexpected results, I believe due to incorrect SQL generated by the Entity Framework provider, though perhaps I've done something incorrectly. The generated SQL looks similar to this (with some bits replaced or altered for security reasons), the basic structure is unaltered.

Last comment 16 January 2019
0   0 2
354

views

0

rating

### XMLIGNORENULL equivalent for object valued properties

I'm writing a SOAP client in Ensemble (2017.2.2) that is required to pass empty elements to the SOAP server in the form <xsi:type="ns:ResponsibleUser"/> where ResponsibleUser is a class that itself has no properties. I initially thought I'd found the answer with the XMLIGNORENULL parameter of XML enabled classes but this didn't make any difference for SOAP requests, only working when I wrote the XML to a file.

0   0 1
0

137

views

0

rating

### Try to send the JSON stream from Process to Operation and generate file

I created the Process to extract the required data from ADT message to a Dynamic Object. I wanted to send the JSON stream to EnsLib.File.PassthroughOperation operation and generate a file with the content of JSON stream.

Here are the codes for Process:

Last answer 12 December 2018 Last comment 9 January 2019
+ 1   0 3
286

views

+ 1

rating

### Calling Javascript within Cache Object Script

Has anyone called any outside Javascript code from inside their class files? I asked a long time ago if there was a way to manipulate an image within Cache Object Script, and since Cache doesn't have any image libraries its not really possible. However I have found Javascript to resize an image and wonder how hard it would be to mesh the two together.

Can anyone share any examples?

Thanks

Scott

Last answer 22 December 2018 Last comment 4 January 2019
+ 2   1 3
568

views

+ 2

rating

### How To Drag/Drop in TablePane?

Hi,

Is it possible to implement Drag and Drop with the TablePane component?

Last comment 3 January 2019
0   2 3
0

129

views

0

rating

### How to find multiple substrings in the string optimally?

Example: I have a list of tags that I have to find, and a string with these and other tags separated by commas.
How to find the desired tags in the string optimally?

Last answer 31 December 2019 Last comment 1 January 2019
0   1 4
274

views

0

rating

### Call method in background process

Hello everybody.

I have task to find out possibility call method from background task.  I need run some class with methods. I've found out than I can run it via ^%ZSTART routine. And now I wanna to learn is it possible to call this class and run it's methods.

Thank you

Last answer 27 December 2018 Last comment 27 December 2018
0   0 3
191

views

0

rating

### Using the Caché Entity Framework Provider

I am trying to use Entity Framework with Visual Studio 2017. After following the Intersystems documentation ("Using the Caché Entity Framework Provider") I still cannot see the data source in Server Explorer.  Any ideas why?

Last answer 21 December 2018 Last comment 21 December 2018
+ 1   1 8
583

views

+ 1

rating

### RemoteDatabase Creation Error

How to configure Remotedatabase into our local instance. While connecting remote database i am getting "ERROR #463: Database C:\InterSystems\HealthShare2\mgr\Remote\ is not allowed for ECP Mirror Connection". so can anyone  help me to sort this out.