#Ensemble

Hi,

I am using this "$ZDATETIME($h,3,1,3)" and getting response as 2024-09-03 12:07:45.000
But I need proper values at the end instead of zeros (000)

Something like below -
2024-09-03 12:07:45.658

 I have some Services using EnsLib.File.InboundAdapter to go directly to respective operations using EnsLib.File.OutboundAdapter which has a 'File Path' specified.

Using this File Path as a root directory, I'd like to instead pass this through a Router  where I could somehow inject a subdirectory to place the file into on the outbound side based off the source service it is coming from. There will likely be several inbound services writing to each outbound operation and I'd like to be able to sort the output into subfolders.

i use %SYSTEM.WorkMgr  to handle data by multicompile=1,but i find that,after WaitForComplete,the processes created by %SYSTEM.WorkMgr  are still stand by,

and status is evtw,after i run many times,the processes are more.and this will cause server falls into trouble.so my question is ，how to kill the processes that created by using the %SYSTEM.WorkMgr，and how to avoid  to make the server falls into trouble,why  this will cause server falls into trouble。and is there a better way to handle data by mult process？

We have a CSP pages script, which gets and sets a cookie for email tracking purposes, we had problems with cookies not being passed to this script when the URL was opened from an email client due to being cross-site, so I set Session Cookie Scope & User Cookie Scope to None instead of Strict.

This solved the issue with cookies not being passed, however the script entirely does not work anymore due to the error:

"Invalid CSP response cookie. SameSite cannot be set to None without Secure.

LS,

I'm executing a query using JDBC on a PostgreSQL db:

SET statement_timeout TO 600000000; COMMIT SELECT * FROM bi_hour

The query is aborted with the following message:

FOUT #5023: Fout in Java Gateway: JDBC Gateway getClob(0,2) errorBad value for type long : active

The column 'blocked_status' contains the value 'active' is of type 'text'. I figure somewhere the SQL Gateway tries to convert the text value into a long but I can't find where, any suggestions?

I have a requirement where in I had to read a HL7 message string ( which is a String )
from a SQL TBL to my Business Service.
and I need to convert that string to EnsLib.HL7.Message format and traverse through the PID segment.

I need  some inputs please.

So, here is a novice question; but, I can't seem to figure out how to do it, or find any comments. I simply want to close out this DTL, under the Interoperability / Build / DTL screen:

There do not seem to be any buttons to 'close' the current DTL item. I tried logging off and back on, and, it brings it right back. Ideas?

InterSystems FAQ rubric

The following code downloads https://www.intersystems.com/assets/intersystems-logo.png and saves the file as c:\temp\test.png.

You need to define an SSL configuration called SSLTEST before executing this code

ClassMethod download() As %Status
{
    Set sc = $$$OK
    Set httprequest=##class(%Net.HttpRequest).%New()
    set httprequest.Port = 443
    set httprequest.Https = 1
    set httprequest.SSLConfiguration = "SSLTEST"
    Set httprequest.Server="www.intersystems.com"
    Do httprequest.Get("/assets/intersystems-logo.png")
    Set httpresponse=httprequest.

Question: can a business process with pool size > 1 invoke external programs in parallel via $ZF(-100)?

We have a production that takes HL7 (ORU_R01) messages in and produces a PDF from each one for onward transmission to a document store.

The PDF creation is implemented in a business process which transforms the HL7 to XML, saves the XML to the filesystem, then calls Apache FOP (the version distributed with Ensemble) via $ZF(-100) to produce the PDF, which is stored on the filesystem.

Hello, I am total newbie when it comes to ObjectScript (just started going through the tutorial).  We have a task where we have to update the port number for 75-100 items (say for half of the items in our production).  Going through the documentation and other community posts it looks like we could utilize class method 'ApplySettings' in Ens.Production.  But we are running into an issue.  Below is what we currently have.  When we hard code the item, it works.  But, if we store the item in a variable and try it pass it through.  Then it doesn't work.  We are also not seeing an error.

InterSystems FAQ rubric

Temporary globals stored in the IRISTEMP/CACHETEMP databases are used when a process does not need to store data indefinitely, but requires the powerful performance of globals. The IRISTEMP/CACHETEMP databases are not journaled, so using temporary globals does not create journal files.

The system uses the IRISTEMP/CACHETEMP databases for temporary storage and are available to users for the same.

For more information about temporary globals and the IRISTEMP database, see the following document:
Temporary Globals and the IRISTEMP Database

The globals used as temporary are:

1.

Hi Guys

I'm getting  syntax error using && operator in using JS in my Zen page, the || works fine!?

Thanks

Hi

I've more than 100 classes that are packed like  CRD.Health.MyClass so I've defined the global mapping as CRD*, but now I would like to map some of the classes (CRD.Health.SomeClass) to different database so how can I exclude it from my current mapping to be in the new one because if I map it in the new database it will still conflict with the old mapping?

Thanks     

Is CR/LF changes to DTL files edited/committed to git via VS Code a known issue?

We had an issue with exporting files from one server and importing on another, using XML code exported from Studio: ERROR #6301: SAX XML Parser Error. Turns out that issue was down to CR/LF changes made when transferring the XML from one server to the other.

A nice feature that we recently added to version 2.12.6 of the VS Code ObjectScript extension is controlled by this new setting:

objectscript.serverSourceControl.respectEditableStatus

When set true in JSON, or checked in the Settings Editor, a server-side file will be read-only if the source control class for the namespace reports that it is not editable.

This option may be of particular interest to users of our Deltanji source control product, particularly when used in combination with the Deltanji extension for VS Code.

when doing ETL process from cache database to mysql database(ods) and to another mysql database(dwd).

There are  lots of DR columns in one table.

In the first step we need two databases to be totally consistent(ods=cache database)

However, the DR column in another database lost its meaning and become to normal number.

In the last step we do the data governance in ODS to DWD. My question is how to write sql without many `join` in this step.

InterSystems FAQ rubric

If you do not specify the option to remove the mirror attribute of the mirror database when deleting the mirror configuration, the database cannot be restored to a normal state and will be mounted read-only the next time it is mounted. To restore the database to a read-write state, you must remove the mirror attribute using the system routine ^MIRROR.

Hi,

I created a property in a Business Process class and added that property to the "settings" parameter to display it as a field in production settings.

Property ServerName As %String(MAXLEN = "");

Parameter SETTINGS = "ServerName:Server Config";

Property names cannot contain characters such as underscore or whitespace. Is there any way to change the display name in production so that I can show this setting as "Server Name" and not "ServerName"?
 

Thank you in advance.

Hi All ,

I have a dateTime in the format = "2024-08-07 17:58:51.563"
I need the difference between current date time and above one 
I need it in seconds.

Hi Guys,

I'm getting " ERROR #6084: Unknown errors detected" when compiling my CSP pages, the pages still works fine in the new 2018 system but can do any changes because of this error?

Thanks

I have an Interoperability Enabled namespace, however, when I try to configure it for production, the Production Configuration page freezes, and, it does not show a listing of my Interoperability Enabled namespaces-

I ran into an issue trying to create new BPL and DTL items. I thought there may be an issue with the fact that my namespace was not cloned from the correct namespace (with all routines/globals/etc); or, that it was not enabled correctly for production, hence, 5002 errors.

Hi all.

Recently, I have noticed Scott Roth's mission to resolve issues with Orphaned messages with a lot of focus on prevention, and I envy that level of dedication.

Not wanting to be left out, this has sparked an interest in checking my environments for orphaned messages. Amongst a few different posts on the subject, I came across this post from Suriya Murugan in 2016 that included an interesting class in a Github Gist that seems to be built to do a deep dive into the identification and cleanup of Orphaned Messages.

Hi Guys,

I've configured my web application and set the Path to where my CSP pages and I can login into my application loads fine with a side menu to links to my CSP pages but when clicking to go any CSP page I got kicked back to the Login page so is there a security setting or configuration that I'm missing ?  

Thanks

Hi Guys,

I've created a website and set the path to my csp pages in Web application setting and can populate all my .cls zen pages with no issues but when it comes to CSP pages I always get sent back to login page am I missing something in  security ? 

Thanks 

Hi:

I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available. 

The next phase is I am storing the date from and to time for a more complete search cache 

zenPage.getComponent(36).value

it works in the chrome console ok 

I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions

InterSystems FAQ rubric

Here, we will introduce a sample code for registering and referencing task schedules.

 ①Sample of task schedule registration

*Create a task to execute do ^TEST every day at 1:00 am. 

 set task=##class(%SYS.Task).%New()
 set task.Name="MyTask1"
 set taskDescription="Execute ^xxx every day at 1:00 AM" // Optional
 set task.NameSpace="USER"
 set task.TimePeriod=0
 set task.DailyFrequency=0
 set task.DailyFrequencyTime=""
 set task.DailyIncrement=""
 set task.DailyStartTime=$ZTimeh("01:00:00")
 set task.DailyEndTime=""
 set task.TaskClass="%SYS.Task.RunLegacyTask"
 set task.

Hi guys,

Stange problem that I'm facing, when running the below code is inside system task scheduled to run every 5 mins it execute till check("gg")=3, stops at While Rs.Next() and you might thing that's because there no records but yest there records because If I run the same task from the terminal it run fine and process all records, also if I copy the whole code into a classMethod and run the classmethod from the terminal it run fine as well, its only if it runs through the scheduling process or by click run in SMP that runs till check point 3 and doesn't go any further !

Hi Guys,

Migrated our system from Ensemble 2014 to 2018 and but for some reason my tasks keep getting the attached error not sure why? 

Thanks

Works?

InterSystems FAQ rubric

To compile class routines including the mapped modifier, specify the compiler modifier "/mapped=1" or "/mapped". For example, do the following:

[Example 1] Get the class list and compile 

 do $System.OBJ.GetClassList(.list,"/mapped")
 // build your classes starting from .list
 do $System.OBJ.Compile(.list) 

[Example 2] Compile all classes 

 do $system.OBJ.CompileAll("/mapped")