#Caché

Hi, colleagues!

When you export the Caché ObjectScript code to VCS (Git, SVN, Perforce, etc) do you export the Storage schema for persistent classes?  If so, what are the Pro/Contra?

Thanks!

Hi -

In Management Portal I can view Processes and their details.

I have a long running job and would like to set the  "Client Application Details" -> "Info" indicator in my code so that I can monitor the process.

Does anyone know how I can set that string in my COS code?

TIA

Since most of our customers moved to Caché 2015.1, some admins became abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert?

We have multiple server and multiple namespace. 

I have a script having sql query  which fetch data from current  namespace of a server. 

If I want to run the same query on different server to fetch data, but I want to run that script on just one server for all server. 

Please let me know how can I proceed. 

From a browser, an XMLHttpRequest to a CSP page on a different server will obviously hit the CORS security check.

To get around this I can set the Access-Control-Allow-Origin header on that particular CSP class.

However, setting any request headers on the XMLHttpRequest object will trigger a pre-flight OPTIONS request.

This OPTIONS request is not handled by the target CSP page and the Access-Control-Allow-Origin header is never set, triggering a CORS error.

I can see in the new REST class that it can get a handle on the OPTIONS request but standard CSP pages don't seem to get them.

I need a trick to display the cellTitle for just ONE column in a tablePane with a unique value.  Here are the issues:

1. OnDrawCell has access to the cell data for that row/column, in %query(pName),  but setting the cellTitle property to a column doesn't refresh the column object

2. Setting showValueInTooltip is good for the entire table, not just one cell

3. ** the column element does not evaluate zen expressions, so I can't say cellTitle="#(%query.Comment)#", for example.  That's the crux of the problem.

Hello.
I would like to know if there's a way to batch a certain amount of writes done inside a job and display it sequentially on the main process.
My idea is to prevent the main process from freezing while displaying the batched data. The main process's device could be

the terminal or the Studio output.

%Studio.Debugger does something close to that when printing the output from the debug target process.
$System.Event.Signal($zparent) doesn't signals the parent if a device is open. So I can't create the batch buffer along, because I can keep the buffering device open and notify the main process.

Hi all,

Sorry to bother

I have a Business Object with SOAP.OutboundAdapter and it gets the response from a WebApi.

Following the sample Creating REST Services and Clients with Ensemble - Developing a REST Operation, I've done the call and it retrieves a JSon with the information. The result is a JSon with a Base64 content (at least 15000 bytes)

I've put a trace to check the content  with $$$TRACE(tHttpResponse.Data.Read() I have a cut result (to 1200 character), so the JSonStreamToObject is not able to allocate the full result into a object.

The Art of Mapping Globals to Classes  (2 of 3)

If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL.

This example is going to cram in 4 or 5 different things beyond what was covered in Part 1 

All that is left after this is the Parent Child mapping example and then you will be on your way.

Same disclaimer:  If you can’t make heads or tails of your globals after reviewing these articles please contact the WRC and we will try to help you out:  Support@InterSystems.

How to define placeholder for dataCombo?

set dc.placeholder = "Some text"  doesn't work.

HI,

Please let us know the solution to the below error:

ERROR:#5388 - You do not have write permission on the database class . %SOAP.WebClient is in , so class lock cannot be obtained .

Thanks, Shobha

Hi All

I'm looking for some field experiences, lessons learned, or actual deployed solutions to the problem of replicating non-CACHE.DAT data in a mirrored Cache environment.  

Environment:

• Operating System is IBM AIX
• Hardware is IBM Power w/ virtualised storage
• Cache 2017.1
• 2x Production mirror members
• 1x DR mirror member

There are a number of different data types that we're looking at mirroring, and a number of identified solutions.

Most frameworks support either REST or WebSockets, and don't make it easy to switch between the two, and/or support both styles of application at the same time.  WebSockets offer many advantages over REST, eg:

- most benchmarks show WebSocket messaging to be significantly faster than over HTTP

- you break free of the HTTP Request/Response protocol limitations, allowing the server/back-end to send messages to the browser as and when it wishes, not simply when polled by the browser.

We understand, unit testing in cache can be done with X Unit testing frameworks.

Can we automate unit testing in cache ? . Please let know

hi

   I want to online backup one Caché database by windows bat, I find some article from the online documentation about  terminal script and the ^DBACK tool and External Entry Points for ^DBACK,  so I can invoke the External Entry Points for ^DBACK from terminal  script like this:    send: Do BACKUP^DBACK<CR>

Is there other better way for backup database from bat/script?

Thanks

How to use front end angular js and back end cache.If It is possible and how to connect it.

Anyone can explain iKnow technology? Then Why iknow technology is uses a "bottom up" approach?

which queries can search for text containing words of interest in Cache?

This is a translation of the following article. Thanks @Evgeny Shvarov  for the help in translation.

Let's assume that you wrote a program that shows "Hello World!", for example:

  write "Hello, World!"

The program works and everyone is happy.

With time, however, your program becomes more complex, gets more features and you eventually need to show the same string in different languages. Moreover you don't know the number and names of these languages.

The spoiler below contains a description of how the task of multi-language localization is solved in Caché.

Hi everyone,

This is:

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2016.2 (Build 736U) Fri Sep 30 2016 12:25:56 EDT

The server is on RedHat Linux while the browser is running on Windows (Firefox).

I am helping a partner build a complex modern HTML5 web application that talks with Caché using REST calls. They have been using %CSP.REST very successfully. Security works great as well. 

Some time ago, I had defined the parameter CONVERTINPUTSTREAM = 1 on their %CSP.REST classes and that seemed to work.

I am trying to set up a sensor in PRTG to connect to Cache, specifically the ens_util.log, so that I can have a live feed of my error count. I am having trouble getting the sensor to log in to Cache. Has anyone had any luck getting PRTG to connect on the database level? Thanks!

how to convert $$zt^%zu2f%zt to macro?

How to make SAMPLES namespace support Ensemble?

Hi,

I have an XML file with many repeating elements to validate.

Hi,

Is there a way you can limit the amount of physical memory Cache uses?

During Cache backup it appears that all the available memory on the server is being used.

We are running Ensemble 2016.1 on Windows Server 2008 R2 with 32GB of RAM.

The database we are backing up is about 300GB.

Thanks,

Graham

What are the differenent format handles the data from Rest services?

Please give the real time example for indirection in Cache.

Hi,

I am trying to support a use case where a test instance is created from a production backup.  At a high level, the process works by mounting all relevant file systems and then bringing the instance up. This works well as long as the file systems are mounted using same mount points as the source instance. However, I would like to support a case where file systems are mounted using different paths. 

For example, if the source instance uses the mount points "/cache" and "/cachejournal", assume that the restore process mounted the same file systems at "/cache_123" and "cachejournal_123".

I am getting an ERROR #5002 in a soap service defined in ensemble. Odd thing is that I allready have a functioning business service running as a soap service, but we needed another, but that one returns an error:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.

How to create macro function and  what is the difference between $$$ and $$ function.