Question Rui Figueiredo · Nov 25, 2018

ERROR #5002: Cache error: <STORE>

Hi,

I'm having the following error when returning a large dataset from a REST API.

"errors":[ {
            "code":5002,
            "domain":"%ObjectErrors",
            "error":"ERROR #5002: Cache error: <STORE>%0NmGk1+5^xxxxxx",
            "id":"CacheError",
            "params":["<STORE>%0NmGk1+5^xxxxxxxxxxxxxxxxxxxx"
            ]
        }
    ],
    "summary":"ERROR #5002: Cache error: <STORE>%0NmGk1+5^xxxxxxxxxxx"

My understanding is that this error is related to the amount of memory available. 

Please see my method implementation below.

#Caché #REST API
1
0 5059
Question Rui Figueiredo · Nov 19, 2018

JSON Syntax

Hi,

I'm using InterSystem Cache v2015.2.5 and I'm implementing a REST API and returning JSON.

Following the documentation I see examples like this

Set obj = {"destinations": ["London","Madrid","Tokyo"]}
Write obj.%ToJSON()

However, I have a compilation error 

ERROR #1054: Invalid expression : '{"destinations":' 

Is there something that needs to be enabled on Studio to allow this syntax?

Thank you,

Rui


#Caché #REST API
5
0 580
Question Rui Figueiredo · Sep 22, 2018

Zen reports - Error rendering Excel output

Hi,

We maintain a few Zen reports that output in Excel format.

Recently we started to observe that some reports fail and return the following error.

CSP error occurred
Error: Error rendering: OS code =1Use $log=1 to check
ErrorNo: 5001

I have extracted the exception details from the log file

java.lang.OutOfMemoryError: Java heap space
at com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.createElementNS(Unknown Source)
at com.sun.org.apache.xalan.internal.xsltc.trax.SAX2DOM.startElement(Unknown Source)
at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.

#Caché #ZEN
1
0 587
Question Rui Figueiredo · Jan 4, 2018

Dynamic Report Header Height

Hi, 

I would like to set the report headerHeight dynamically based on a group records count.

Example:

If GroupA has 5 records then the headerHeight should be 50mm

If GroupA has 3 records then the headerHeight should be 30mm

 

Could you please advice the best approach to achieve this?

 

Thank you,

Rui

#Caché #ZEN
1
0 290
Question Rui Figueiredo · Aug 25, 2017

Zen Report - ErrorNo: 5540

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

 

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

 

Regards,

Rui

#Caché #ZEN
4
0 511
Question Rui Figueiredo · Aug 21, 2017

Zen Reports error

Hi,

I'm having the following error visualizing a PDF report.

An invalid XML character (Unicode: 0x3) was found in the value of attribute "Reaction" and element is "Allergies".

 

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-height set to: 11in

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-width set to: 8.26in

Aug 18, 2017 10:50:30 AM org.apache.fop.cli.Main startFOP

SEVERE: Exception

org.apache.fop.apps.FOPException: org.xml.sax.SAXParseException; systemId: file:/D:/SOJHSSDTC/mgr/Temp/Vte547p7Yyihkg.

#Caché
3
0 489