Syndicate content 0  
 

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

0 1
0 91

[InterSystems IRIS SEVERE ERROR HSFLIVE] [Utility.Event] ISCLOG: WorkMgr CountWorkers: Found dead job ns=%SYS rtn=%SYS.WorkQueueMgr data=$lb("job","3209241","jobnum",67,"group","Run","category","SYS","breadcrumb","","jobtype",59)

Did anyone else get this type of alert?

0 3
1 241

01/10/24-09:00:54:225 (14316) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1
01/10/24-09:00:58:210 (5096) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1

0 3
0 96

I am trying to get data out of a cache backup. I am completely new to Intersystems Cache.

I got a docker image of Cache from this post:

I want to get the data from my backup into this docker image. First, I need access to a gui and a cli, then I need some instructions or documentation for actually pulling in the backup data.

Thanks! This is all new, so pardon my lack of knowledge here. If I can provide any more information let me know.

0 3
0 187

Hello,

I have been facing a problem for several months, I have several flows that work in SFTP with the iris class EnsLib.FTP.PassthroughService

The problem is that from time to time I get an error message that says:

"A connection could not be established because the target computer expressly refused it"

I had the case for a server at our house and we solved the problem by extending the call interval parameter to 60 seconds,

1 3
0 165

Hi all,
Does anyone have experience with obtaining logs from Caché databases and parsing them now? Please leave me a message.

I ask because my project involves some hospitals that used Caché when creating databases over 10 years ago. Currently, we cannot replace the database, but we need to check and parse the database logs from the Caché.

Thanks.

0 12
0 119

Hi Community,

I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it.

The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect.

0 1
0 68

We have a service account that is running queries to pull some data. It has read only access to the tables, but, unfortunately, the tool is starting a transaction before it reads the database. The query takes more than 20 minutes (21 - 23 minutes), so we're getting the console message that the transaction is open longer than 20 mins. Is there a way to prevent a user/service account from being able to start a transaction since it only has read access to all of the tables in the database?

0 10
0 426

I am using the event logger from CSP gateway with level "v9r" enabled, in order to dump the raw content of some HTTP requests.

I would like to decode the body response data, when it's in binary form. AFAIK the event logger will convert characters outside the 32-127 range (EBCDIC) to the "\xff" notation (where ff is a hexadecimal value). Here is an example :

0 4
0 286
Question
· Dec 27, 2023
Code Quality Checks: Javascript

Is it possible to get a code quality stamp of approval on the Open Exchange with an application written in Javascript?

My Iris Whiz application is a browser extension written in Javascript and I wonder if having the code quality stamp missing from my application page will put people off from using it.

0 2
0 124

Hi all ,

I just started learning objectScript . Online TEST instance is not opening terminal.

Management Portal (system configuration, direct SQL access, reporting)

Server Address:
Web Terminal:
InterSystems Username: tech
InterSystems Password: demo

IDE Connections (VS Code)

Host Server Address:
Host Server Web Port: 80

External Connections (InterSystems Studio)

0 2
0 114

Hi ,

I'm currently working on a BPL (Business Process Language) in InterSystems Ensemble, and I'm facing an issue when trying to call the SendRequestSync() method within a code activity. My understanding is that SendRequestSync() is part of Ens.BusinessProcess, and since Ens.BusinessProcessBPL extends Ens.BusinessProcess, I believe it should be accessible.

However, during compilation, I'm encountering an error stating that the method doesn't exist in the class.

0 4
0 127

I have written an in network single web page containing a jquery datatable. I want to add the "href" tag to link the Terminal window based on the IP.

Below is a list of failed attempts to make this work.

W " <td><a href=""javascript:pass('"_PASS_"|"_IP_"|"_USER_"|"_PORT_"')"">Terminal</a></td>"

or

0 3
0 123

Hello Community,.

I've updated the IRIS community form 2023.2 to 2023.3 and I didn't see the User defined(Sample) error messages in ^IRIS.Msg global even I verified in both pointer and data level. I re run the set x=##class(%MessageDictionary).Import("error.xml") After import I could see the pointers and data in ^IRIS.Msg

Is the User defined error will reset from the server after IRIS upgrade?

0 1
0 85

Hi community,

I´ve setup a local FHIR server via the framework functionality und set a service config name for the created endpoint since I plan to use a production based FHIR server. I´ve created an additional ressource "FhirClientRessource" and role "FhirClientRole" as well as a user named "FhirClient". The Role resource "FhirClientRessource" ist set as "required resource" in the FHIR server configuration page. The user "FhirClient" is member of the Role "FhirClientRole" which in turn holds RWU priveliges on the "FhirClientRessources".

0 4
0 162

I'm receiving a JSON payload via a REST API, I'd like to %JSONImport this stream into a class which extends %JSON.Adaptor. The problem is that the JSON is an array whose elements have no key (as you can see in the example JSON below). Right now I'm having to do some manipulations to convert the stream into a dynamic object and do a %Set which inserts a made up key "record" so "thingone" and "thingtwo" have an associated key that I can use when referencing "thingone" and "thingtwo"...such as record.GetAt(1).thingone

0 3
0 170