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.

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?

Hello Community,

Generally we could insert the stream object through SQL for stream properties and insert the list values for list of %String property. So, Is there any way to achieve this insert for the list of objects property( ex: Property CodeTable As list of Sample.CodeTable) via SQL?

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 :

Can you provide a specific version number？thx

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)

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.

Hi,

I'm currently working on a Business Process Language (BPL) project where I'm using ##Class(%SQL.Statement).%ExecDirect to execute a SQL query. The query returns more than one row, and I'm facing an issue in handling the result set.

<property name='tResult' type='%SQL.StatementResult' instantiate='0' />

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

This question originally appeared in the comments of the post: The Art of Mapping Globals to Classes (5 of 3)

Hey

I need to know how to exclude row after checking his data, for example:

^global(1,2)=a*b

^global(1,3)=a*c

if $P(^global(key1,key2),"*",2)=c Q

how can i do this?

thanks

I would be interested to know is it possible to implement alerts about messages (errors etc that show in message viewer or event log) to show in the SAM portal? So far I've only been able to see system alerts there.

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

When I creating the package for datatype Integer then while binding at the created endpoint it is not binding Provide me the package for integer & boolean datatype.

I am trying to run the CSP server. But I get the error:

It worked once, but when I made some changes is displayed an error.
Also, a WEB page looks like this:

Did you face this issue? What is the reason for it?