#Caché

I'm trying to write an installer manifest that can create a namespace, resources (%DB_namespace) and a role (with the resource, above), based on the namespace.  So you could pass in "ABC", or "XYZ", and it would create the %DB_ABC resource and the ABC role with %DB_ABC:RW permissions; or it will create the %DB_XYZ resource and the XYZ role with %DB_XYZ:RW permissions, accordingly.

Hi Community,

Has anyone ever set up a web service that takes a stream data type as an argument? The client will be dotNet.

This is the error I see:-

   <SOAP-ENV:Fault>
      <faultcode>SOAP-ENV:Client</faultcode>
      <faultstring>Badly formed SOAP Message</faultstring>
      <detail>
    <error xmlns='http://soap.rmh.nhs.uk'&gt;
     <text>ERROR #5002: Cache error: &lt;INVALID OREF&gt;XMLLOOP+9^WebService.eDCGold.GetRootKeyLocalRef.1</text>
    </error>
</detail>
    </SOAP-ENV:Fault>

I have switched to a string data type for now and that is working fine.

Hi everyone,

I really like using dynamic objects and dynamic arrays, Usually ending up with an SQL query that returns a JSON object i throw into my application via REST and work out things from there.

Recently I noticed that I keep using dynamic objects as simple storage solutions like:

set settings.customerSelection = 1

instead of ending up with several variables flying around.

This certainly is way more inefficient than having simple variables but does it make a huge difference? Especially considering how much more organized the code appears?

Cheers

Hi ,

I am newbie working on Cache .

I have a global ^BB("QA",QDJ,QTM+i) , i want to create a table or a view to access the data from this.

I am expert in creating tables & views on RDBS like Oracle, SQL server. But no idea on Cache.

Can someone guide me from scratch how to pull the data from the global.

I have installed Cache Studio on my machine.

Regards

Recently, we scheduled two tasks (1008 and 1009) within Task Manager. Task ID 1008 is set to run after Purge Tasks (%SYS-ID:3), and Task 1009 is set to run at 7:00:00 each day.

In attempt to provide as much detail as possible, each of the tasks are as follows:

• Task 1008 WHILE (($p($h,",",2) < $ZTH("10:00 PM")) && ($P($g(^Task.1008(+$h,$j)),"^",1) = +$h)) { J ^ROUTINE, ^ROUTINE2 D SUB^ROUTINE3 H 5 }
• Task 1009 WHILE (($p($h,",",2) < $ZTH("10:00 PM")) && ($P($g(^Task.1009(+$h,$j)),"^",1) = +$h)) { d ^ROUTINE4, ^ROUTINE5 J SUB^ROUTINE6 }

I want to export a project from Studio, but when I do so I get an error that I cannot use the default name and should rename the project instead. However, I cannot find anywhere how I rename the project. 

I have an xml file that I read into objects and I am trying to print that file back in nested xml anyone with idea on how that can be achieved or where I can read in order to achieve this, here is an example of what I am trying to do.

From this

<Root>
  <FamilyMembers>
  <familyName>
  </familyName>
  <Name>
  </Name>
  <Age>
  </Age>
  <Employment>
  </Employment>
  </FamilyMembers>
</Root>

To this

<?xml version="1.0" encoding="UTF-8"?>
<Root>
  <FamilyMembers>
      <Family>
     <familyName>
        </familyName>
      </Family>
    <Name>
    </Name>
    <Age>
    </Age>
    <Employment>
    </Employment>
  </FamilyMembers>
</Root>

I have an application that as part of the registration process is using reCaptcha to provide a captcha. The issue is that service is served from Google and is unavailable in certain countries, namely China. I've been researching this some and believe it's possible to proxy the requests to the Google CDN to avoid the Chinese firewall ban on Google URLs, however I'm not quite sure how to do this in CSP. 

Does anyone have suggestions on how to solve this, either with a technical solution or an alternative service I can fall back to?
An example would be greatly appreciated.

Thanks

I am pleased to announce that Release Candidates of Caché and Ensemble 2017.2 are now available.

Many customers have already downloaded the Field Test over the past few months, and we appreciate your feedback.

This release contains significant improvements, including:

• Parallel dejournaling to improve throughput of mirroring and journal restore.
• New iFind and iKnow features like co-occurrence search, performance improvements, and more.
• SQL enhancements in Query Auditing, optional ANSI SQL operator precedence, and Frozen Plan Evolution, along with our normal cast of query optimization improvements.

I'm simply trying to evaluate what is available in terms of JSON projection of registered objects within Caché.

If you have an app that uses some Caché client Windows components that are not included into CacheODBC distribution (e.g. CacheActiveX.dll), you need to proceed Caché client installation on end user's client computers and/or MS Terminal Servers. Being a part of Caché client's installation, Caché Cube is installed along with other components and is autostarted with every user's session. So, it becomes visible to every user.

To make it completely invisible, you can just move CACHE.

Is there any Test Driven Development tool for Cache for the web development. If so can any one help me on this.

Thanks in advance.

One of the most important features during application development is the ability to debug your code easily. Because of the asynchrnous nature, a standard Node.js application server works single-threaded by default. When you are developing applications using an IDE like Visual Studio Code, you can very easily debug your Node.js process:

First, download the free Visual Studio Code IDE (@code) and install it on your development machine.

We will start with basic debugging using a very small test.

 how to set some specific value for the variable if the user enter that specific value then only it will go to next step  

When i tried to print .txt format,data will be coming without space between each row but when 
I tried to print .xls format mean ,it gives gap of each row.what is the reason behind this?

How to show alert message on ZEN when user closing window?

Standart js way to add listener is not working.

I tried this

 ClientMethod onloadHandler() [ = javascript ]

and this, but both are unsuccessfully .

 onloadHandler() [ = javascript ]

Hi All,

    I need some clarification on web service (Soap Service). For each Soap request, system consuming 1 license and it is not releasing until CSP session timeout and extra grace period 5.10 minutes(310 seconds).
    Due to this, at some time license consumption is full.
    If i use with Login credential (i.e password authenticated web service), it consumes one license for 25 connections(request).
    But i need to use it as anonymous user(Unauthenticated).
    Please advice.

Thanks,
Sabarinathan M

Hi,

We are having a problem where sometimes a websocket connection started from a CSP page does not share the same SessionId as the CSP page itself. We are also using ECP and can see that both sessions are often even on different application servers.

I have a class that has a list property, which contains a list of other objects, and I want to join against it in SQL.

Class Foo Extends %Persistent
{
Property MyBars As list Of Bar;
}

Class Bar Extends %Persistent { Property Name As %String; }

Simply querying the Foo table, I see that MyBars looks like a $LIST, so I tried using a query with the %inlist operator but that didn't seem to work as expected. The following query produces zero results:

select bar.name from foo join bar on bar.id %INLIST MyBars

Is there some convenient way to do this sort of join?

Hello,

we have to implement some application logic using either Java or .NET. Which should we choose? Given that all other considerations are equal, which is in your experience better way performance-wise to interact with external components in Caché: .NET Gateway or Java Gateway?

Thanks.

Hi

Please can someone send me an example of how to auto refresh a table pane. 

Thanks

Nigel

Hi-

I have an IP address (or hostname) and a port (in this case a super server port #) and I want to try to verify that network communications can be established between the host I'm on and the given hostname and port number of a remote server.

Is there any way pragmatically to do this within Cache?

I am trying connect DB using Oracle DB link (ODBC).  I am getting the following error. Please help me fixing this error.

I am using Oracle 12 c.

Thanks,

Raj

Hi, folks!

Is there any way to use $CASE or $SELECT functionality in SQL SELECT query?

E.g. something like this:

SELECT product, $CASE(status,"New":field1,"Payed":field2) as data from sales

To see either in data column either field1 or field2 values in regard of status value.

Hi-

I am running the latest version of Cache and am trying to use the Config.* classes in the %SYS namespace to be able to gather information from a cache.cpf file that was provided to me by a customer.  The customer is running an older version of Cache which had a different Version number in the cpf file.  Theirs is 2013.1 and mine is 2015.1.  

My question is, are the Config.* classes backwards compatible.  Can I use a 2017.1 version of Cache to read information from cpf file from a 2014 system?

Hi all-

We used to have this Java applet in our CSP page to "print all" and "download all" PDF medical reports.  We want this applet so that the user won't have to open each PDF in the browser just to print it.

But now most browsers do not support Java applets anymore due to security concerns, so that Java application is down.  We tried to migrate to Java Web Start but don't know how to invoke the JNLP file from the CSP page.  I am new to Cache so any help would be greatly appreciated.

Also, is there an easier solution to this print all problem?

Hello,

I am looking for ObjectScript implementation of crypt-compatible function, that generates md5 salted hashes (output is in the form of $1$salt$hash). From what I understand it uses its own spin on md5 algorithm:

https://en.wikipedia.org/wiki/Crypt_(C)
http://php.net/manual/en/function.crypt.php
http://www.gnu.org/software/libc/manual/html_node/crypt.html

Does Cache have something like that built in?

Has somebody here seen it implemented somewhere?

Thanks.

Added:

I have found description of the underlying algorithm here: https://www.vidarholen.net/contents/blog/?p=32

If you are facing out the license expire warning message on your terminal ("*** Warning: This Cache license will expire in 3 days ***") and you do not want that message to be displayed, you can disable/enable that by rinning the following commands:

Do ExpirationMessageOff^%SYS.LICENSE - Disable

Do ExpirationMessageOn^%SYS.LICENSE - Enable

Hi , i have a JSON record as follow {value1,value2, value3}

i want to write my switch statement in this form:

<switch> my value
<case> value1</case>
<case>value2</case>
<case>value3</case>
​</switch>

is there any possibility to extract values from JSON record and put them in a  switch statement?

thank's

I need to create a standards document for new developers who are coming to Cache from other backgrounds.

Does anyone have an in-house document they could share with me?

Regards

Mike