Question sansa stark · Oct 3, 2016

Hi All,

We are accessing the InterSystems`s cache database via UNIX ODBC and displaying the data in PHP website . Recently we have upgraded the PHP version to 5.6.  We are getting the nondisplayable characters (�) for only strings. But the numbers and date fields are displaying correctly. 

While querying the database via ISQL everything working fine (No Special characters).

I have looked around the internet and found the PHP 5.6 changed the default character to UTF-8.

For this issue anything, we can do from cache side.

Thanks in advance.

2
0 634
Question GUILHERME CRUZ DA CUNHA · Nov 10, 2016

Hello, I would like to know if CACHE has any limitations on uploading files.
Why am I asking this, why am I going through a problem here.
What happens is that when uploading files or images that are larger than 2.7 MB CACHE is limiting the size to 2.7 MB, any file larger than that is saved corrupted.
Already at the time of uploading the file or image, CACHE is limiting the size of the file to 2.6 MB.

3
0 1103
Question Archunan K · Nov 8, 2016

Hi Everyone,

         I have frequently received this below error message in my ensemble 2009 Cconsole log.

         " 11/08-13:05:06:114 (9784) 2 Skipping SET due to compare and swap failed on ^["^^e:\test\data\"]Debug("CalcTotal1") for records in e:\test\data\ addr=39745548 "

        Please explain this, am very much trouble with this alert. And also want to know it will cause any system hangsup ?

please response quickly. Thanks

Archunan K.

5
0 628
Question William Proctor · Nov 9, 2016

Thanks for all replies in advance.  In monitoring our audit log we are getting the error below.  We have 4 different servers running CACHE  2014.1.1 and this is happening on all 4 of them.  I have not been able to find what process is trying to logon but it is happening every 30 minutes.  We have no user processes that are running so this has to be a CACHE process.  Does anyone have an Ideal what could be running to cause this?  What kind of trace can I run to determine what process is running it?

2 2016-11-09 15:17:15.997 %System %Login LoginFailure 7748    

%Service_SuperS

1
0 966
Question Jon Jensen · Nov 7, 2016

I clicked on my name to view my profile.  It shows a list of recently read posts.  This list is incorrect.   It seems to be listing all the posts on the homepage as post I have read.  I have not read the majority of these posts. 

Perhaps the recently read logic is broken?  I assume recently read would require me to actually view the posting to consider it read?

Can you correct (or remove) this information in the profiles

6
0 297
Question Rajath Muthappa · Nov 8, 2016

Hi,

Currently i am building a CSP application using Intersystems cache to automate few tasks in Ensemble. Basically, I have 2 .csp class files, file1.CSP and file2.CSP in namespaces namespace1 and namespace2 respectively. On satisfaction of a condition I forward the request from file1.csp to file2.csp. while forwarding it prompts me to enter the log-in credentials again as the second .csp file is in a different namespace. Is there any way i can bypass the login screen while forwarding the request from 1 csp to another (as i am using the same credentials for both the namespaces) ?

PS: While fo

3
0 458
Question Mohan Sujay · Nov 9, 2016

Hi,

How to post and get data using php. I'm using a php external url. In the body in parsing the request as xml and when i execute this using fiddler it response the result as xml but when i consume it in classmethod it fails. I don't have a wsdl file how can i work it out?

2
0 519
Article Stuart Salzer · Nov 8, 2016 38m read

What is a core file? and When are they use­ful?

The in­for­ma­tion in this doc­u­ment is cur­rent as ver­sions of InterSystems prod­ucts re­leased through 2024-06-06. This up­date date cov­ers er­rors in that dis­covered up to 2024-08-12, but not changes present in new ver­sions of InterSystems prod­ucts.

Nevertheless, the de­tails for ex­ist­ing prod­ucts are not sub­ject to fre­quent change.

The WRC can supply you with a .PDF ver­sion of this article suitable for printing on either US 8½″ × 11″ or A4 210 mm × 297 mm paper.

Table of Contents

Core file ba­sicsSuSE LinuxWindows
AIX















1
2 34781
Question Mohan Sujay · Nov 7, 2016

hi,

I have created a asp web service and it is hosted in our internal server. How can i consume that web service in cache class method? It is a soap web service with xml input and xml output. It works fine in all the browser.

3
0 557
Article Jorma Sinnamo · Nov 8, 2016 4m read

This is the first article in a series discussing how to regain disk space from Caché databases at the operating system level. This introductory article discusses Caché database growth and gives an overview of various methods you can use to return unused disk space that is allocated to database files back to the file system. But before we talk about returning space to the file system, let’s first review how does it get allocated in the first place.

Caché databases always have the name CACHE.DAT and can reside on practically any file system supported by the underlying operating system, including

0
0 2015
Question DQ Hu · Nov 7, 2016

Environment: Cache for Windows (x86-64) 2015.2.2 (Build 811U) Thu Mar 3 2016 12:55:48 EST [HealthShare Modules:Core:14.01.351 

When try the following to send back SOAP Fault, is the following correct way?

Set fault=##class(%SOAP.Fault).%New()
Set fault.faultcode=$$$FAULTServer
Set fault.faultstring="Processing Error"
Set fault.detail= "Error on server"
Do ..ReturnFault(fault)

Got the error 

ERROR #5659: Property '%ZHSLIB.Audit.LogParticipant::Log'
required
Stack:
  • $$^zGetErrorTrace+3 ^Ens.Util.Trace.1 +1
  • DO^zLogNoTrace+10^Ens.Util.Log.1 +1
  • DO^zLog+2^Ens.Util.Log.1 +1
  • DO^zLogStatus+4^Ens.Util.Log.1 +1
  • DO^zonOu
1
0 813
Question Rajath Muthappa · Nov 8, 2016

Hi,

I am using the &sql () tag to retrieve the value from the Cache DB.

below is the piece of code i am using:

script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String" &sql( select columnA, into :tempVariable1 from TABLE where COLUMNC = pVariable

quit tempVariable1

i have to return the ColumnA value back to the calling procedure.

can i know how it can be done ? since i am getting an javascript error.

4
0 500
Article Matthew Giesmann · Nov 8, 2016 4m read

Beginning in Caché 2013.1, InterSystems introduced Outlier Selectivity to improve query plan selection involving fields with one atypical value.

In this article, I hope to use an example 'Projects' table to demonstrate what Outlier Selectivity is, how it helps SQL performance and a few considerations for writing queries.

Selectivity

First, let's take a quick look at Selectivity. Selectivity is meta information about the values in one column in a table. Assuming a typical distribution of data, it answers the question "If I ask for all the rows in this table that have a certain value in this col

1
0 805
Question Eduard Lebedyuk · Nov 8, 2016

I have a following ZEN report:

Class ZENApp.Report Extends %ZEN.Report.reportPage
{

/// Class name of application this report belongs to.
Parameter APPLICATION = "ZENApp.SampleApp";

/// Specifies the default display mode used for this report if
/// the URL parameter, <var>$MODE</var>, is not present.
Parameter DEFAULTMODE As STRING  = "xlsx";

/// 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="MyReport
2
0 431
Announcement Evgeny Shvarov · Nov 2, 2016

Hi, Community!

Let me introduce  Dmitry Maslennikov as our new Developer Community Moderator.

Dmitry continuously shows the outstanding contribution to InterSystems Developer Community and we decided to trust Dmitry this role and hope that Dmitry can even help to make the Developer Community better in this new status.

Thanks for your great contribution, Dmitry! 

And, we are looking for the new moderators from Community!  

InterSystems Developer Community is growing! yes

1
0 337
Question Thomas Kotze · Nov 7, 2016

Hi,  We have a business process that receives back a character stream that has csv content from a SOAP Operation call. I was hoping to make use of the record mapper to map the content to a record map to be able to process the transactions.

I only see examples/documentation of how to use a File or ftp business operation/service to map the stream to a record map.

Is this at all possible to get the csv stream into a record map batch object.

Regards

Thomas

1
0 554
Article John Murray · Mar 16, 2016 2m read

Prompted by the words Rick didn't actually say to his pianist in Casablanca, I want to draw attention to the the "Resend" button at the top of the Ensemble Message Viewer.

It's pretty easy to use. Find the message or messages you want to resend, set the associated selection checkbox(es), then click the button.

The Message Viewer page is replaced by the Resend Messages page where you can review the message(s) you selected, then proceed. To proceed you typically click "Resend", but if your selection consists of a single message you can alternatively click "Edit and Resend" which allows you to amen

3
0 1006
Question Ray Hitchins · Nov 7, 2016

Hi,

I have a problem which i think has a simple solution but which i and others haven't yet cracked. I want to display text output to a text box in monospaced font. At the moment the style sheet is shown below, I have tried various other options such as specifying a specific font such as Courier New.  None of the browsers I have tried (Safari, Firefox on OSX, IE) display as monospace, although the last 2 come close. I wonder whether I need a <pre> tag, but I can't see how to do that in Zen.

Suggestions?

XData Style
{
<style type="text/css">
/* style for title bar */
/* style for text box, non proport

1
0 348
Article Justin Lavoie · Nov 7, 2016 5m read

After upgrading an Information Exchange/HealthShare instance that has a registry namespace, you may notice that the Caché audit log gets filled with frequent login failures by the HS_Services user (check this by going to Management Portal > System Administration > Security > Auditing > View Audit Database). Clicking the “details” shows event data like:

Error message: Access Denied
CSP Application: /csp/healthshare/hsregistry
Authentication: Delegated

 

Problem Background

Every time a remote HealthShare instance makes a call to the registry (“hsregistry” in this example), it first fai






0
0 1015
Article Peter Steiwer · Nov 7, 2016 2m read

Whether you are accessing DeepSee for the first time ever or you are configuring DeepSee on a new instance, there are two common issues that are encountered after clicking on the “DeepSee” option in the System Management Portal.

Issue #1: Architect/Analyzer is grayed out!

Issue #2: DeepSee must be enabled before use.

Issue #1: Architect/Analyzer is grayed out!

There are two common causes for this problem.

Cause 1 - License

Cause 2 - Security

The first common cause is that the license does not have these DeepSee options enabled. To confirm if these options are enabled, you can run the


1
0 1659
InterSystems Official Andreas Dieckow · Nov 7, 2016

Starting with the Field Test of 2017.1 InterSystems products will include Feature Tracker. It is enabled by default during the Field Test and is explained more fully in the product documentation included below. Information collected by Feature Tracker is limited to technology usage information and instance identification.  This tool has been carefully crafted to not transmit sensitive information related to customer applications or data. It is important to note that sharing of information about your system is under your control and the information being shared with InterSystems is always visib

0
0 979