#Caché

Hi, I want to use linux system to develop cache, but I dont want to use wine, any other way to???

Working with a client who has two TryCache instances on his W10 machine. Trying to bring in globals from a text file which works fine in my environment but on his, he cannot make ^%GI accept a file from his C drive. His Cache is on C as is mine. Checking the path and the file name carefully, it is accurate. D ^%GI and enter the path with filename (as works fine for me on my system) and he gets a message [unavailable] and when he hits enter out of that message, he sees Cannot import from THIS device. I think I'm missing a config or security setting of some kind but I don't know what it is.

I have a process which is passed a .rtf within a GlobalBinaryStream. I am trying to then output just the .rtf to a folder on a server, but not even sure where to start.

Is there a Built in Operation that I can pass the GlobalBinaryStream to which will then write the file to a folder, or do I need to use a custom class for the operation?

Thanks 

I wrote a ZAUTHENTICATE.mac a couple of months back, and found recently that it is creating coredumps on almost a nightly basis. I think I have figured out this problem to be not clearing out my MsgSearch after I am doing 2 of them within the code.

1. Get User Attibutes from AD

2. Get User Groups From AD

So while I am trying to cleanup the code I thought it would be a good time to add a Certificate and TLS to the mix since I should of been using that all along.

The following code allows a user to view the audit settings of their instance. Run the code by running the class method "test":

class objectscript.checkAudit Extends %RegisteredObject
{
classmethod test() {
w "Checking for Auditing.",!
Set SYSOBJ = ##class(Security.System).%OpenId("SYSTEM")
If +SYSOBJ = 0 Set SYSOBJ = ##class(Security.System).%New()
i SYSOBJ.AuditEnabled {
w "Security Auditing is enabled for the following services",!
s rs=##class(%ResultSet).%New("Security.Events:ListAllSystem")
s sc=rs.Execute()  If $$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quit
while rs.

Hi,

this is a public announcement for the first release of Intersystems Cache Object-Relational Mapper in Python 3. Project's main repository is located at Github (healiseu/IntersystemsCacheORM).

About the project

CacheORM module is an enhanced OOP porting of Intersystems Cache-Python binding. There are three classes implemented:

• CacheClient This is the super class of CachePython module. It wraps two functions from intersys.pythonbind module pythonbind3.connection() and pythonbind3.database().

• CacheQuery A subclass of CacheClient that wraps methods and adds extra functionality in intersys.pythonbind.databaseand intersys.pythonbind.query classes

• CacheClass A subclass of CacheClient, that wraps methods and adds extra functionality in intersys.pythonbind.databaseand intersys.pythonbind.object classes

The intersys.pythonbind package is a Python C extension that provides Python application with transparent connectivity to the objects stored in the Caché database.

I'm trying to have my REST service return the entire data set for one of our legacy globals.  Currently I am parsing the object from a SQL statement into generic objects to be returned like this:

         Set specimenArray=[]
        
        WHILE resultSet.%Next() {
            Set specimen = {}
            Set specimen.SpecimenId= resultSet.SpecimenId
            Set specimen.ProjectId = resultSet.ProjectId
            
            Set Oref = specimenArray.%Push(specimen)
        }
        
        Set tProxy = specimenArray.%ToJSON()
        set %response.Status = 200
        set %response.

How to Make a Https/SSL Request in Caché ObjectScript ? If possible please provide some working example with some https url.

Hi,

I have a problem with CSP Application Authentication, when the user input you correct password, however the message "Invalid password" returns.

This error returns just Cache password user type, for user delegated don't.

this error is momentary also, if you wait a moment, it stops.

Is there any COS API to create the database (with designated path) and the namespace ?

Also, the API to attach a given database to a given namespace?

Thanks.

Hi, Community!

Have a question for general discussion. 

In ObjectScript we have cls for classes and mac code, which both compile into int code. 

Is there any reason when you use mac instead of cls  for non-persistent classes?

For me the benefits for cls are:

1. Inheritance and other OOP features

2. Auto-documented code 

For mac one visible benefit is easier call in terminal:

do method^Utils(p1,p2)

vs

do ##class(Package.Utils).method(p1,p2)

What is your choice and why?

Hey, the question is simple!

Is possible one classe is not generated journal?

I would like a given class not to generate this data but on a configured basis to generate, is possible?

I would linke to have the functionalities provided by the Table Field/Property Collation, but applying a transformation which differs from the provided ones.

Does anyone know if there is a way do accomplish that?

Hey Guys.

Is possible i know in COS the state of the one service the operation system?
One example:

What's state of service WinDefend for example, in operating system Windows.
I would like to know the status of the service.

How best can I capture %GSIZE all pages? Or parameters to use?

The output file is only showing the last page.

I used these options

Device: /usr/cache/mgr/gsizedoc.txt

Parameters? "WNS" =>

--------------------------

Page: 23                          GLOBAL SIZE                                                                            12 Jul 2018
                                                                                                                             3:56 PM
      Global        Blocks       Bytes Used  Packing   Contig.

I have a class that has a property calledTags (like DescriptiveWords, but tags), where multiple tags are possible.  I am trying to decide on list of Objects vs. array of Objects.

Based on this post: https://community.intersystems.com/post/querying-list-property-sql, sounds like using an array of Objects is the better way to go. Indeed, I already noticed that it's not possible to have duplicates when using an array of Objects.

However, I am unable to make my queries on the array of Object use an index.

InterSystems products (InterSystems IRIS, Caché and Ensemble) support AIX on Power 9 chips starting with:

Caché/Ensemble 2017.1.3

InterSystems IRIS 2018.1.1

Hi I am getting below error in xDBC error log

<-400>: Dispatch+14^%SYS.BINDSRV ServerLoop

When I check the detail of error I am getting below information. Please suggest as our schedule job getting failed due to same error.

Namespace: ******* Process: 5569 Error: 2018-07-10 06:27:17 [SQLCODE: <-400>:] [Cache Error: <Dispatch+14^%SYS.BINDSRV>] [Location: ] [Client info: ] [%protocol: <50>] $Id: //dev/2017.2.1/kernel/common/src/aclass.c#1 $ 23289 104

Hi,

I have a Caché project with some HTML files in a CSP folder.

Using Atelier when I access "Server Explorer" and execute the option "Copy to Project" to my local project I have this error:

Has anyone had this same problem? Any solution?

I'm trying write a JavaScript generator to perform pattern match validations using existing pattern match expressions in a legacy application.

I could make a server call to perform the pattern match operation but is there a way to automatically translate the pattern match expressions into RegEx expressions so I can perform the operation in JavaScript on the client to save making an Ajax call back to the server?

Thanks

Jay Ayliff

M-Tech

hi

when I logon linux with a not root user, and then call ccontrol start/stop cache,    show no permisson .

 how to grant start/stop/restore privilege to user who is not root .

thanks

I am trying to fetch the data from cache database. But i got the error like "CSP application closed the connection before sending a responce".

Below is the query.

SELECT
CallbackComment
FROM SQ.CBPhoneResult_View Where PhoneDateODBC = '2018-04-09'

I have investigated and found that "CallbackComment" contains the special character single quotes " ' "  for one result and due to this i got this error.

In this field data is enter by customer. so we cannot restrict them like Do Not use single quotes.

Please provide some solution as soon as possible.

Thanks in advance. 

Lost the raid array on our server. We were able to recovery all the data from backup but now are running into road blocks getting the Cache database up and running. We are running version 5.0.7 which is quite old but works for our needs. Our most current road block it is getting CTTerm (Telnet) to connect with the database. After entering the user and password nothing happens beside the carriage return dropping down one more line in CTTerm.  If you are familiar with the older revs of Cache please feel free to contact me or provide input.  Any help or direction would be invaluable to us.

Im using below code to display page number. But i only display as 1,2..etc. I need to display it as I,II,III..etc...

special="page-number"

Hello everyone

I have a problem with $ ZF (-1)

I need to delete file from windows folder example c: \ sys \ text.txt, when executing the w $ zf (-1, "c: \ sys \ text.txt") command, the file does not delete.
There is some other cache command that performs this task.

hugs

Davidson

Hi, I found some issues with $ZF(-100) whilst replacing our old $ZF(-1) calls following the security alert. They're easy enough to work around, just figured it might be useful to someone :)

There seems to be some inconsistency with how $ZF(-100) is functioning between Unix and Win, contrary to the documentation. For example, for a simple ‘output directory listing to file’  operation:

Windows:

set dev="dir.txt"

set com="dir"

set options(1)=""

set options(2)="e:\nbupg\webserver\"

w $ZF(-100,"/SHELL /STDERR=""NUL"" /STDOUT="_dev,com,.

I am trying to write a generic process that will take any incoming message but would like to know where it came from so in my code I would like to do something like this

If (Document.Source="some serviceorProcess").

Just to be clear in the route you get these features is there a way of accessing them in code

Hi All,

On button click from my zen page am calling the $System.SQL.ShowPlan() to calculate the cost of the SQL query.

In Cache` 2016.2 I faced a problem , when the logged in user didn't have the %development resource(<PROTECT> error).

But in Cache` 2017.2 it's working without the %development resource.

Is there any changes done on this area in the versions above 2016.2.

Thanks,

Dinesh

I try to run below two statements

Set tRS = ##class(%ResultSet).%New("%Dictionary.ClassDefinition:SubclassOf")
​set tSC = tRS.Execute("%Persistent")

and I always get <PROTECT>check+5^%Dictionary.ClassDefinitionQuery.1

The login user is _SYSTEM and should have all the permissions.

I cannot run queries in the $SYSTEM.SQL.Shell(). I would get <PROTECT>%GenerateMetadata+16^%SQL.StatementMetadata.1

However, when I run the query through SMP, everything is fine.

Any idea where could I start to investigate ?

Thanks.

or "Didn't you say you would cover Persistent Objects in Part 5, Chris?"

Yes, that was the plan.  This is a pretty important topic, so it get's its own Article

Up until now, we've display widget JSON that has been created by a basic loop.  Clearly this isn't of much value.  Now we have our stack connected together, and we can see that the data is flowing to the Welcome page, it's time to complete the stack and start feeding our service from "real" data.

Let's start with our (very basic) Persistent class for Widgets.  We have 4 properties to hold Name, Description, Price and current Quantity.