HI *,

So last night I was doing a deployment which had a query to select from a large dataset of joined tables, to iterate through and populate data in a new table.

This was done in a classmethod using embedded SQL and the %PARALLEL keyword.
On a testing environment with the same dataset, this worked perfectly a few days earlier.

0 2
0 294
Question
· Nov 15, 2019
Question on sharding

Prior to IRIS, using ECP to share databases under heavy I/O load has known latency issues (in our environment), which pretty much restricted using shared database with relatively static or slow-changing data. In IRIS, will sharding mitigate the latency issue and allow any table to be shared?

David

0 2
0 294
Question
· Jul 13, 2023
$zu(96,9) Not working

Suppose you have routine ^A loaded in your partition in programmer mode and you call routine ^B. Routine ^B finds the value of $ZU(96,9) which should be the calling routine.

But $ZU(96,9) now returns null, as does $SYSTEM.Process.CallingRoutine()

Works on 2018.1.7 but not 2018.1.8

$ROLES= %All on both systems

More precisely I have line label ZZPP in ^%ZLANGC00 which needs to identify the original routine in the partition and do some work on it. When I type ZZPP I get nothing on the later version. Here's the line of code:

1 4
0 294

Hello,

lets have two abstract %Persistent classes A,B with NoExtent keyword (storing data in separate globals for each subclass).

Class A Extends %Persistent [Abstract, NoExtent]

{

}

Class B Extends %Persistent [Abstract, NoExtent]

{

Property Aref As A;

}

Let B class reference the A class. Since the A class has no extent the reference wont work in subclasses. It wont be even usable in SQL. Is it possible to solve this problem? Whats the recommended way to deal with references/relationships using NoExtent?

0 6
0 294

After I loaded the intersystems/iam:0.34-1-1 image in local, I am trying to do the next step of configuration.

2) Configure your InterSystems IRIS instance

2a) Enable the /api/IAM web application
2b) Enable the IAM user
2c) Change the password for the IAM user

Do we need to change these settings in iris.cpf file? any inputs where we have to configure? I have IRIS 2019.1.1 installed in my machine.

Thanks,

Nag.

0 2
0 294

Hello,
I am currently trying to create a namespace and I keep receiving error #197 when I try to create the database for it. My OS is Coentos 7.7, my cache version is 2016.2.3.903.6.18300 and here is a screenshot of the error.

0 2
0 294

Hi everyone

I have a datacombo that displayes value from a db table.

I would like to set one of this value as default value. How can I do that? Is there a way to say selected value given the text or the Id from the DB table?

Thanks a lot and kind regards

Milena

0 1
0 294
Question
· Jan 16, 2024
Where can I find $$$sysTRACE?

When I do $TRACE("message") I can see the message on the message viewer. However, I don't know where to find messages generated from $$$sysTRACE, and I haven't found anything about it in the documentation.

Do you know where I can find it?

0 6
0 294

After any installs upgrades we get the following

04/13/23-18:00:00:978 (18668) 0 [Utility.Event] d:\intersystems\healthshare\mgr\enslib\ (Database is readonly)
04/13/23-18:00:00:979 (18668) 0 [Utility.Event] d:\intersystems\healthshare\mgr\hslib\ (Database is readonly)

I think we must have before altered these to not read-only.

Not sure if the isssue is by default

-Running task as user with %ALL rather than SYS user

- Should the dbs be as default in the all backup list

- Should these be not ro so it backs up without error?

0 2
0 294
Question
· Mar 25, 2021
CLOB fields brock

hello,

I need help...rsrs

I have a query that return only one CLOB field and only one line, of oracle and in field have a xml.

if use pResultSet.Get the string truncate the xml.

I want display the xml as a service, because have many lines... i don't need iterate in xml, only get to oracle and display as xml soap.

any tip help.

thk

0 1
0 294

The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"

is there a SAFE way I can give him access to our database using an intelligent visual user interface.

I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.

0 3
0 294

Context: Ensemble development with ObjectScript in a healthcare context - lots of HL7, and some web service stuff. We've used Studio up till now, alongside a lot of leaning on an external developer, but are expanding our team and doing more in-house. We are wondering about Visual Studio Code - not least because it looks easier to hook up to source management solutions. And we've noticed that the test environments that you get connected to when doing many of the online training courses on learning.intersystems.com give you a Visual Studio Code environment.

0 3
1 293

Hi everyone.

Is there a sensible approach to having a lookup table in Namespace A, and then accessing this from Namespaces B, C, D (etc)?

I'm trying to avoid creating a Global mapping of the lookup table global (^Ens.LookupTable) as I fear that it would then link all other lookups in that global and lead to some unexpected behaviour, but would be open to trying something in this realm if it's the best option.

0 4
0 293

I am trying to execute a program from within cache using a $zf call

S X=$ZF(-1,"C:\""Program Files (x86)""\Car-Part\Messaging\iCPM.exe")

For the sake of this post I changed it to open notepad

S X=$ZF(-1,"C:\Windows\notepad.exe")

If I call it directly from terminal notepad opens and all is happy.

If I add it to a program we use to run certain tasks once an hour or even every 10 minutes it will fire off notepad but it will be in the background.

1 2
1 293
Question
· Oct 7, 2017
.xls format problem

When i tried to print .txt format,data will be coming without space between each row but when
I tried to print .xls format mean ,it gives gap of each row.what is the reason behind this?

0 1
0 293