#Caché

Hello,

I'm just re-going through the Caché foundations course exercises using a copy of Try-Caché on my home pc.

I'm trying to create a web application to receive REST calls however, when I use the Restlet client I get no response.

My web application config is:

test

code

Hi, I don't know if there is a bug in the function $zdate.

if i do:
w $zd("43433",4)  the result is    01/12/59

but if i do:
w $zd("64448",4) the result is   14/06/2017
 

Hi,

I am new to Intersystems Cache. I have a requirement to replace $ZF("%ZSET_DIR","/hold/rsm") using Cache Class. Which class and which method i need to use

Thanks & Regards,

Sadagopan TS

hi all,

        how to configure the crystal report in iis?

        how to generate the crystal report via intersystem cache ?

info :

  sap crystal report 2011

  iis 6 and windows 3 server

cache 5.02

Thanks,

sansa.

My CSP app uses <IMG> to display images that are on a network drive mapped on my server.  In addition to the virtual path that already exists for my CSP app, should I create another virtual path to the root of the images I want to display

How do I call an excel report class from another class and name the report from the call class in cache?

This is the Report Class:

/// ProjekCin.Cinema.report.report
Class ProjekCin.Cinema.report.OLSQL16REP Extends %ZEN.Report.reportPage
{

/// Class name of application this report belongs to.
Parameter APPLICATION = "ProjekCin.report.Browse";

/// Specifies the default display mode used for this report if
/// the URL parameter, <var>$MODE</var>, is not present.
Parameter DEFAULTMODE As STRING [ Constraint = ",html,tohtml,toxslfo,pdf,xml,xslfo,excel,toexcel,ps,pdfprint,xlsx,tiff,displayxlsx,fo2pdf,foandpdf", Flags = ENUM ] = "xlsx";

/// Set om multiplesheets te kan save in excel
Parameter EXCELMULTISHEET = 1;

/// This is the optional XML namespace used for the report.
Parameter REPORTXMLNAMESPACE;

/// This is the logical name of this report.
/// If not provided, class name is used.
Parameter REPORTNAME As STRING = "Tutorial";

/// This XML defines the logical contents of this report.
XData ReportDefinition [ XMLNamespace = "http://www.intersystems.com/zen/report/definition" ]
{
<report xmlns="http://www.intersystems.com/zen/report/definition"
 name="report" sql="SELECT 
FTR, ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL" runonce="true">
<group name="SQL161" sql="SELECT 
FTR, ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150601'" excelSheetName="1">
<group name="g1">
<element name="No" field="FTR" />
<element name="COARno" field="COARno" />
<element name="NominalAccountNo" field="NominalAccountNo" />
<element name="Description" field="Description" />
<element name="Natureofaccount" field="Expression" />
<element name="TotalAmount" field="Amount" />
</group>
</group>
<group name="SQL161" sql="SELECT 
FTR,ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150602'" excelSheetName="2">
<group name="g1">
<element name="No" field="FTR" />
<element name="COARno" field="COARno" />
<element name="NominalAccountNo" field="NominalAccountNo" />
<element name="Description" field="Description" />
<element name="Natureofaccount" field="Expression" />
<element name="TotalAmount" field="Amount" />
</group>
</group>
<group name="SQL161" sql="SELECT 
FTR,ID, Amount, BusinessDate, COARno, Description, Expression, NominalAccountNo, OBJVersion
FROM ProjekCin.LSL WHERE BusinessDate = '20150602'" excelSheetName="Selection">
<group name="Selec">
<element name="sql" field="sql" />
</group>
</group>
</report>
}

/// This XML defines the display for this report.
/// This is used to generate the XSLT stylesheets for both HTML and XSL-FO.
XData ReportDisplay [ XMLNamespace = "http://www.intersystems.com/zen/report/display" ]
{
<report xmlns="http://www.intersystems.com/zen/report/display"
 name="report" title="Tutorial">
<!-- Optional Init element inserts custom XSLT instructions at the top level of the generated XSLT stylesheet. 
<init ></init>-->
<!-- Optional Document element specifies page layout and style characteristics.--> 
<document width="8.5in" height="11in" marginLeft="1.25in" marginRight="1.25in" marginTop="1.0in" marginBottom="1.0in" ></document>
<!-- Optional Pageheader element. 
<pageheader ></pageheader>-->
<!-- Optional Pagefooter element. Does not apply in HTML output. 
<pagefooter ></pagefooter>-->
<!-- Required Body element. -->
<!--<body>
 add display definition of the report here. -->
 <!-- <table group="ProjekCin/cin" 
   excelSheetName="Cinema" >
    <item field="ID"/>
    <item field="FilmShowing"/>
    <item field="NrOfSeats" isExcelNumber="true"/> 
    
   </table>
  
</body>-->
</report>
}

}

The first step when dealing with performance is the ability to measure it. In this article, we will show you a way to measure the performance of your CSP and/or ZEN applications. You will be able to answer questions such as: Which pages of my application are hit the most? or Which pages in my application are the slowest?

Advent of Code is a series of 25 small programming challenges, created by Eric Wastl, see https://adventofcode.com/.

There are small and bigger puzzles, which you can solve typically in half an hour to a few hours. (Looking at the leaderboard, the top aces can do them in less than 10 minutes.) 

It's an ideal way for beginners to start learning a computer language, and for advanced people to sharpen their programming skills.

To help you get trained for this year's challenges which start at December 1st, I will try to solve and comment the puzzles from 2016.

hi ,

     How to install and configure intersystem cache ODBC in CENTOS7 linux box.

 Thanks,

sansa.

Index to Articles

Under Construction

Index to Articles

Hello everyone,

I have the following problem in generating a PDF report in ZEN, which has many items, a general total of approximately 30,000 items, but gives an error, I can generate a report with a maximum of 8,000 items, which may be wrong.

==========

Class Ideal.ListaEstoquePDF Extends %ZEN.Report.

test

@evgeny test

test

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

This article is about how to gain as much transparency in controlling processes in ECP environment as in traditional (non ECP) one.

The technology of load balancing between several servers with relatively low capacity has been a standard feature of Caché for quite a while. It is based on the distributed cache technology called ECP (Enterprise Cache Protocol); note that we are referring to “cache”, not “Caché”, here. ECP provides a host of possibilities for horizontal scaling of an application, ensuring high performance and fault-tolerance, and yet keeping the project budget fairly low. Another apparent advantage of ECP network is the possibility to conceal its architecture in the depths of Caché configuration so that applications developed for the traditional (vertical) architecture can be fairly easily migrated to a horizontal ECP environment. The ease of this process is so mesmerizing, that you start wishing it was always this way. For instance, everybody is used to having a possibility to control Caché processes: the $Job system variable and associated classes/functions work magic in skilful hands. Stop, but now processes can end up being on different Caché servers… The text below is about how I managed to cope with this problem.

Hello,

Our Intersystems Cache database is running in a Windows 2008 R2, and is installed and configured as "UNICODE" .

We are using Apache+PHP with  ODBC to get data but we have some problems with character encoding.

We also have two configurations:

• Ubuntu 16.04 LTS + Apache2 + PHP 5.6 + UnixODBC
  • using isql command everything works fine, data returned is OK   (all special characters  in Spanish displayed ok).
  • using PHP with  PDO function to connect the database and libcacheodbcu35.so driver
    • with  default_charset=""  in  php.ini
    • Special characters in spanish not displaying   (  like   ü , é , ó , à , .

The following code snippet contains a class method "test" that determines the value of a specified property for an instance of its class:

/// get property value within class by indirection
Class objectscript.getPropOfThisClass Extends %RegisteredObject
{
// extra code to help test
Property myProp as %Integer;
// need to instantiate an object to access property value
method test() {
	// extra code to help test
	set ..myProp = 32
	
	// code from the CODE post
	set property = $PROPERTY($THIS, "myProp")
	
	// extra code to help test
	write property
}

Hi all,

    i need one help regrading telnet.In cache 5.02 while we take telnet it open some program(By using ^login Global in %Sys nameSpace).But i could not create same process in cache 2016.

example:

telnet 127.0.0.1 it open some routine in "TRAIN" namespace.

Thanks,

Sansa.

Hi,

I would like to know if there is any code to compare and update two directories/namespaces for class files.
If file is present in directory1 and not present in diectory2, it should import the classfile.
If file is not present in directory1 and it is present in directory2, the corresponding file should be deleted from  directory2.

Please suggest code for the task.

Thanks,
Arpitha R

In Oracle sql Developer, you can still listing the records in a desk the use of the statistics tab when viewing a desk. there where can add, delete, edit or just viewing facts of desk currently viewd

the trouble is that we regularly actually need to view a couple of table immediately, then we want more than one tab opened, issue that i dont recognise how to do that, any sugestion. tq earlier

Recently I have been working on a performance issue reporting about that Sets or Kills in the same global performed by multiple processes in a very focused time period can sometimes take a long time (several seconds) to complete. I feel this is an interesting case study to understand about some performance tunings of Caché.

Case background:

A testing routine creates multiple processes to do set (or kill) random nodes of a global in tight loop and records the timing how long a set (or kill ) operation takes.  For a global with a large number of nodes (e.g.

Hi all,

          Is there any possibilities to set the null password for user account in cache 2016?

Thanks,

sansa.

Hi All, I am taking a namespace and routines from one table for particular user.if the user have name space and routine means it execute well but after executed the routine it is automatically quit and close the session.I need to keep the same namespace after executing the routine. Please help to proceed further anyone.

Index to Articles

Under Construction

Index to Articles

Hi All, I configured the crystal report SAP 2011 with IIS 10 in windows server 2012 r2 standard,when I tried to open it shows failed to open the connection error .database is Cache.how to recover that problem.

test

@evgeny test

test

Disclaimer: This is not a how to guide and I personally do not do any of the following unless its for penetration testing. It's important to think like a hacker in order to beat them at their own game.

To start off click on this google search link (its safe)...

https://www.google.co.uk/search?q=cache+error+page&oq=cache+error+page&….

Currently we have a setup where we have an external IIS webserver that our CSP Gateway sits on that routes requests to our ensemble server. When working with soap everything was routed to the CSPms module since the site's handler mappings have *.cls going to this module. However, now that we are working with rest services that don't have a file extension we will have to have all traffic on the IIS box be routed through the CSPms module. 

I was curious if anyone has encountered this type of issue, and if so, what steps did they take to resolve it?