Hi there.

I was wondering if there was a supported way of editing the Title bar of the management portal so that at a glance it is clear as to what environment is being worked on. This would be in addition to the namespace and server name being displayed.

Ideally I would like to make it clear at a glance that a user is working within the Dev or Live environment.

0 3
0 374

Hi,

I've added a REST service which worked fine on our test system but failed on the production environment because UnknownUser does not have %All set and I really don't want it set on production (in fact I've also switched it off on test).

Is there a way to allow a single REST service to have unauthorised access?

I was thinking adding a resource/role to UnknownUser specifically for that service but I've never touched on Users/Roles/Resources so I'm struggling to work out what needs adding where.

Thanks

0 2
0 374
Question
· Jan 24, 2023
SQL Query needs optimization

Hi All,

I am having an SQL query (mentioned below). When I am running this query it is taking 90 min to retrieve all records (approx 1 million records).

Fetching data from 5 tables using inner join in cache. Relative cost displaying 10 million

I wan to confirm How this query can be optimized

0 12
0 373
Question
· Mar 27, 2023
JSON Validation Errors

When using %JSONImport it seems to only report a single error, is there a way to report all the errors with out having to do multiple requests?

{

"errors": [

{

"code": 9406,

"domain": "%ObjectErrors",

"error": "ERROR #9406: Unexpected format for value of field, CurrencyCode, using Update mapping",

"id": "JSONImportError",

"params": [

"CurrencyCode",

"Update"

0 1
0 373
Question
· May 17, 2017
Soap Messaging

HI ,

Please let us know the solution to the below error which appeared during SOAP Wizard.

ERROR #5805: ID key not unique for extent '%Dictionary.ClassDefinition' : '^oddDEF("GuruBaseAllah.BLZServiceSOAP11porthttp")' exists. Id counter location = ''

Thanks,

Shobha

0 1
0 373
Question
· Mar 1, 2020
SQL Inbound Adapter Errors

Hi,

I created a BS with a SQL Inbound Adapter.

Query = "SELECT rowid, fname ,lname,datesent
FROM labs
WHERE datesent IS NOT NULL"

DeleteQuery = " update labs set datesent = Getdate() where rowid = ?"

KeyFieldName = "rowid"

i am getting the following errors.

"NOT assuming network disconnect error based on: Gateway failed: DropStatement."

"Skipping previously errored row '235'"

0 1
0 373
Question
· Jul 20, 2017
Cursor placement

Greetings,

What methods are available to position a cursor on a screen to begin writing as not to disrupt other areas of the screen? I have used ?# , ie: ?5 but this is destructive from the let to character 5. I would like to enter a command that will position at row,col and then start writing? Can I create a window in a window type display to write text and then when done viewing, remove it?

Please advise,

Thanks in advance for everyone's time.

0 2
0 373
Question
· Sep 18, 2019
Error to load IAM image

Hi folks,

I started to play with docker and InterSystems products, it's amazing, but I got the error when try to load the IAM-0.34-1-1.tar.gz image to docker:


[root@CONF-RHEL-DOCKER-IRIS-API admconf]# docker load -i IAM-0.34-1-1.tar.gz
open /var/lib/docker/tmp/docker-import-547148651/IAM/json: no such file or directory

Bellow docker and docker-compose version:

[root@CONF-RHEL-DOCKER-IRIS-API admconf]# docker --version
Docker version 19.03.2, build 6a30dfc

0 4
0 373

I have a case where I need to look up the NPI provider against an External MS SQL database to retrieve our Provider Identifier to send to a downstream system. In the past I would use a Business Process (BPL) to connect to the outside MS SQL via JDBC and get that information for me. But I was thinking instead of creating a BPL process to do this, would it be better just to link to the outside MS SQL database table to retrieve the information in a SQL statement within a DTL?

0 3
0 373
Question
· Nov 29, 2022
Apache with SSL Certificates

Hi Guys,

Our system admin has installed a new SSL certificate to replace the old one in our Windows server 2016.

So should it be ok to just then remove the old Certificate given that we installed the new one, knowing that the old one has been used previously or do we need to do something in existing SSL/TLS configurations ?

0 2
0 373

For my Embedded Python ONLY demo package I need some user input.
Similar to ObjectScript

read "say somthing",reply

I use the Python equivalent

reply = input("say something")

And this works excellent without problems from Terminal or Doker console

BAD SURPRISE:
with WebTermnial ObjectSscript works fine, but embedded Python fails badly.

1 7
0 372

Good morning:


Thank you very much for reading the doubt and above all thank you very much for answering.

Given the following use case:

If we have a Destination Service that through a HTTP GET by REST gives us a certain JSON response, where it should be noted that it is a list of objects where each object in the list does NOT have a key:

0 3
0 372
Question
· Oct 1, 2019
Atelier: Install

I've installed Atelier according to instructions but after rebooting Eclipse there is not opportunity to launch Atelier. In preferences there is not Atelier. I've tried to update and reinstall Atelier but it didn't get a result. I checked it was installed on my PC.

How can I solve this problem? And why I faced to this situation?

All needed components were been installed earlier.

0 2
0 372

I have a class:

Class test.Person Extends (%Persistent, %XML.Adaptor)
{
Property Name;
}

I want to serialize it into this XML:

<Person>
    <Id>1</Id>
    <Name>Ed</Name>
</Person>

Is it possible?

It's for the Visual Trace so I can't use %XML.Writer.

0 2
0 372