Hi all,

I wonder how to sync my server code to my local code using Visual Studio Code.

Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.

Hey Community, 

Get ready for the next French Stream on InterSystems Technologies!

The new monthly event hosted by @Guillaume Rongier for French-speaking developers familiar with InterSystems technologies will be live stream October 7th at 12:00 Paris time. You will discover all the news and tips related to our solutions!

👉 Direct link to join: https://youtu.be/Rbp-u-3vY-8

On the Agenda:

Hello,

I'm experiencing a recurrent problem that I haven't found the way to solve, so I'm coming here with the hope somebody can give me a new approach.

To make it short: we are creating categories on-demand to be able to place the maximum numbers of workers in memory, avoiding the limits established by system categories. But from time to time, one of this creation fails and system is no able to start the queue. The error we are getting is:

ERREUR #7823: Invalid work queue manager category supplied 'User.65733'.1<INVALID OREF> 

The code is very simple:

s ^%SYS("WQM","MaxActiveWorkers","User.

Hi developers, 

Serenji 3.2.0, the latest version from George James Software, was released last week and our current users have been enjoying trying out the new features (which you can find more about here). 

If you're thinking about trying Serenji for the first time, we've made it easier to get set up by adding a walkthrough on the VS Code Welcome page. It takes you through: 

• Setting up the server components.
• Selecting a server namespace.
• Saving and extending your workspace.
• Requesting a debug license (don't forget we offer a free 30 day trial!) 

We've also added prompts and guidance throughout VS Code to open and add Serenji folders to your workspace and when going to run and debug code. 

This is just one of the ways we've enhanced the Serenji debugger to make straightforward and easy to use - so all you need to do is focus on your code. 

I am trying to convert a valid date range (Previous Day - Current Day) to a valid date/time range (-15 mins from current date/time to current date/time) for a Task to run (Format needs to be YYYY-MM-DD hh:mm:ss)

Code being used currently for date range is 

set previousDay=$zdatetime($horolog-1,3)
set currentDay=$zdatetime($horolog-0,3)

Can anyone help?

I am executing the command:

      set fileComp = ##Class(SYS.Database).FileCompact(obj.Directory, freeSpace, .actualFree)

      where obj.Directory contains the location of the current database

This executes correctly. However, the resultant OREF object does not contain any displayable properties but rather is of the value:

       "0 "_$lb($lb(380,,,,,,,,,$lb(,"%SYS",$lb("e^zFileCompact+38^SYS.Database.1^1","e^^^0"))))/* ERROR #380: Completed but skipped some blocks, details recorded in the console log. */

Which is what I expected.

I can start cache without issue. There are no errors in the console log. However, when I access the management portal the page fails to display instead displaying the error page with the error "CSP application closed the connection before sending a complete response". This was working yesterday so the root cause is not clear. Reviewing all log files, the only error I have found is in the csp.log. The error is:

>>> Time: Mon Sep 20 06:54:19 2021; RT Build: 1801.1632a (win32/apapi:srv=2.4.20/apr=1.5.2/apu=1.5.

I want to restore to a certain point in time through the Journal log, and I can't find relevant information in the help documentation.  Can someone help me?   

very thankful 

How to find a global's original namespace ? Potentially mapped from a different namespace .

I have a global ^Custom that exists in multiple namespaces but it could mapped from namespace Drone(A) to Launch(B)

Without access to Cache management portal how to find where is my global located using cache code ?

Like if ^Custom == ^[Drone]Custom ??

https://www.appeon.com/products/powerbuilder

Appeon PowerBuilder is an enterprise development tool that allows you to build data-driven business applications and components.
It is one of a suite of Appeon products that together provide the tools to develop client/server, Web, mobile, and distributed applications.

Hi all,

I'm deploying IRIS for Health on a Google Cloud VM, and I note that the SuperServer port is 1971, rather than good old 1972. Is this as it's supposed to be? I can't see that it's documented anywhere.

Cheers,

Otto

Starting installation
Starting up InterSystems IRIS for loading...
../bin/irisinstall -s . -B -c c -C /usr/irissys/iris.cpf*IRIS -W 1 -g2 
Starting Control Process
Unable to allocate 242 MB shared memory...
Unable to allocate 232 MB shared memory...
Configuring minimum system...
Unable to allocate 139 MB shared memory...
Unable to allocate shared memory minimum of 139MB (errno=22)
Startup aborted.
Startup error. See messages.log for more information.
Call InterSystems Technical Support if you need assistance.
IRIS startup returned 1.
InterSystems IRIS failed to start.
Check

Hey Community,

Please welcome 4 new videos on InterSystems Developers YouTube from HackMIT 2021 healthcare track:

1. Meet InterSystems and Get Ready for the Challenge

Hi!

We're doing a small data integration project at our university and I've run into a problem.

I'm trying to make a counter that records the amount of messages (a simple .txt file transfer) that pass through a process and dumps that amount into a text file (preferably with a timestamp) every 10 minutes or so.

What I've gathered it's possible to do it via SQL query but linking that query into a process is something I haven't found any info on.

Are there any semi-beginner friendly ways to do this?

Thanks in advance!

Hello,

first of all thanks for your time reading this question, and thanks for your time:

We are expected to send a file as an attachment in a SOAP request using MTOM protocol.

It is expected to include a "name" parameter inside the "Content-Type" header, as we show below:

Currently, we have developed a SOAP Operation which sends the files using MTOM protocol, however it is not including the parameter "name" inside "Content-Type" header, as you would observe:

How could we adapt it to send the parameter "name"?

Could you provide us some example or documentation?

We have read:

https://docs.

Good Day

I have http response comes with strange characters "ليس لديه الØ", but it's normal when i test in postman. Is there any method to read arabic.

Regards

Hello all

How can I convert cache date to hijri date format in object secript.

please help.

Hi Team,

I want to consume(call) third-party API by passing JSON as a request from Iris.

I have a terminal script that queries sys.process' and then parses the results writing to a logfile. As part of the processing of the results, each row of the result set includes an element from the static string.  But I am not clear on the scoping of the static string. The write statement sees the static string as undefined. What I want is something to the affect:

     set statStr = "aa|bb|.."

   set sqlStatement = xxx

   set tState  = ##class(%SQL.Statement).%New()

   set qStat   = tState.%Prepare(< sql statement> )

   set rset    = tState.%Execute()

  WHILE rset.

is there a command line  function I can use to export the user file.  The names off all the  user in Health Share or Health Connect.  Export it into some type of flat file?

Intersystems Software Developer – Grand Traverse Plastics Corp.

Location:  Williamsburg, MI

Note:   This position is an ‘on site’ position.

We are looking for an accomplished InterSystems developer to join our team.    Grand Traverse Plastics is a fast growing and leading edge plastics injection molder.  With 145 employees and 35 million in annual sales we offer an excellent place to work in one of the nicest areas in the Midwest.

The candidate will assist in the development of our custom ERP system running on Cache.

I'm trying to install IRIS 2021.1 in the Ubuntu 18.04 but all the time I got the message below:

Starting installation
Starting up InterSystems IRIS for loading...
Invalid ownership for ./irisdb
InterSystems IRIS is already up!
Status code is 1
InterSystems IRIS failed to start.
Check /mnt/WinData/InterSystemsLinux/mgr/messages.log for more details.
Call InterSystems Technical Support if you need assistance.

* Installation aborted *

Post-installation tasks failed, installation is not complete

Has anyone had the same problem?

I tried to install with root as well but the problem persist.

Thank you all.

Hi community,

I have a SOAP Client class that connect to a WS Service. This structure and configuration is the same for some providers that are integrated with my solution.

If I call to a provider, it returns the XML expected. But there is a provider that raises an error:

ERROR #6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: application/wsdl+xml

I've tried to set the ContentType to the adapter.%Client with this value, but it doesn't work.

Benjamin De Boe wrote this great article about Universal Cached Queries, but what the heck is a Universal Cached Query (UCQ) and why should I care about it if I am writing good old embedded SQL?  In Caché and Ensemble, Cached Queries would be generated to resolve xDBC and Dynamic SQL.  Now in InterSystems IRIS embedded SQL has been updated to use Cached Queries, hence the Universal added to the name.  Now any SQL executed on IRIS will be done so from a UCQ class.

Why did InterSystems do this?  Good Question!  The big win here is flexibility in a live environment.

Hello,

We upgrade from CACHE 2016 to IRIS 2021 and when we try to start a production gives the error behind.

I think the error could be that the Ens.Director is deprecated on IRIS 2021, is this possible? 

09/22/21-14:35:35:563 (16501) 1 [Utility.Event] Production AutoStart: ERROR in namespace 'REGINUS': 'ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+29^Ens.Director.1 *%Library.CacheStorage -- logged as '22 Sep 2021' number 1 @''' $ZU(56,2)='$Id: //adhocs-iris/2020.1.0.217.1/ISC_INTERNAL_BASE_20418_001/kernel/common/src/aclass.c#1 $ 9520 0'

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Showcasing New X12 Enhancements

The latest release of Serenji by George James Software introduces zero configuration debugging, so it's ready to go in just one click - no matter where you are or what you're doing, your on-the-spot debugger is ready to go. 

We have introduced a host of new features to enhance the debugging experience so you can focus on identifying and fixing errors, without losing focus by spending time setting up a launch configuration. 

Check out the new features in our release notes. 

If you've already started using Serenji 3.2.0 let us know how you're getting on! 

At the top right corner in Clinical Viewer we have a wrench icon with which Administrator is able to change the layouts as and if needed. 

Are there any logs created when anyone modifies the layout and save the layout. 

When overwriting the Read method (that has a %CacheString return type) on a new class that inherits %Stream.FileCharacter class, returns an error about incorrect return type, must be Binary, even if it matched the real signature.

Looking at the compile global information we can see:

^oddCOM("%Stream.FileBinary","m","Read",42)="%Library.Binary"

After further investigation we realise that there is a generator method looking at the OdbcType class definition.

Setting LONGVARCHAR results in:

^oddCOM("User.CStream","m","Read",42)="%Library.String"

We found out recently that when compiling an objectscript class that has a java projection, using the -d flag, it ignores it for the projection part:

After talking with intersystems luckily the've provided a solution that will be included in the next release: