Credentials for a Productions are stored as plain text in ^Ens.SecondaryData.Password and exposed as plain text via SQL table Ens_Config.Credentials which is not ideal as only admins should know the credentials.
I can create my own adapter etc... to store and use encrypted passwords but does anyone know if there is a standard way to do this in a Production?
Alternatively, am I missing how to secure this so the production can run and someone can monitor and operate a production without access to the SQL table or global?
Hello! I am currently creating a class for a small error trap. I have it working and all is good but I really want to change the order of the fields in the SQL return from Alphabetical to something else.
The current Order is ID, ActionType, ErrorCount, ErrorDetails, Model, ResultCode, ResultMessage, Stock and Yard
I would really like for the field order to be ID, Yard, Stock, Model, etc.
Is it possible to access (read, write) to an external Oracle database via Cache SQL Gateway using JDBC in Cache Object Script? I am currently using ODBC successfully but wanted to see if JDBC was an option too. If it is possible, does anyone have a basic Object Script example(s) that I can review?
SELECT Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub INTO #tempfemale FROM Aviation.Crew WHERE Sex = 'F'
I have created a simple package that allows the use of Cache with the Laravel Framework.
From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.
When I use jdbc driver to query the column info ,the "REMARKS" field always show the same as the "COLUMN_NAME" field.
When I use the sql "select * from INFORMATION_SCHEMA.columns a where a.table_name='some table name ' " to query columns info,there has a "DESCRIPTION" field ,the value is some comment for the current field.
So is there anyway to return the description to the jdbc remarks field? And is there anyway to update the desciption or remarks field? Or is there some other way that I don't know to manage column comment info?
I am receiving a JSON File as Stream container Using pRequest As Ens.StreamContainer and output as Output pResponse As %Persistent in a Custom Business Operation
Healthcare interoperability is instrumental in improving patient care, decreasing healthcare provider costs, and providing a more accurate picture to providers. However, with so many different systems, data is formatted in many different ways. There are many standards that have been created to try to solve this problem, including HL7v2, HL7v3, and CDA but each one has its drawbacks.
I created a password validation routine for the management portal, which is called from the System-wide Security Parameters. The validation process works correctly, but the error message that is displayed to the user when the entered password fails validation, consists of two separate error codes and messages
During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks).
Your application is deployed and everything is running fine. Great, hi-five! Then out of the blue the phone starts to ring off the hook – it’s users complaining that the application is sometimes ‘slow’. But what does that mean? Sometimes? What tools do you have and what statistics should you be looking at to find and resolve this slowness? Is your system infrastructure up to the task of the user load? What infrastructure design questions should you have asked before you went into production? How can you capacity plan for new hardware with confidence and without over-spec'ing? How can you stop the phone ringing? How could you have stopped it ringing in the first place?
I'm getting wrapped around the axle with CAST and CONVERT and can't seem to find a way to do this (short of adding a stored procedure wrapping $zdt($zdth(posix,-2),3), which I'm refusing to do on principle, because there has to be some way to make this work).
I am calling a stored procedure over an ODBC connection and every time I call it there are several warnings written to the log event {Found no Parameter 1 (used as 1) for query}.I seem to be getting this on every query executed and that seems to happen a number of times the query parameters are per query and its filling up my disc.
1) Is there a way to suppress these warnings as the query seems to be executed and data written to the database?
Mixing Object syntax with SQL is one of the nice features in Object Script. But in one case, it gave strange results, so I decided to isolate the case and describe it here.
Let's say you need to write a classmethod that updates a single property on disk. Usually, i would write that using SQL like this :
I want to display to the user on their Zen page how much time is left before their session times out.
I know I can set the %session.AppTimeout to a particular value (or manage this in the Web Application) and I know I can retrieve this value from the %session object. I also know that I can set an event handler to do something when the session has timed out but I cannot find any way to determine how long before the session ends via the application timeout so that I can keep the user informed.
There are many ways to generate excel files using Intersystems, some of them are ZEN reports, IRIS reports ( Logi reports or formally known as JReports), or we can use third party Java libraries, the possibilities are almost endless.
But, what if you want to create a simple spreadsheet with only Caché ObjectScript? (no third party applications)
Hi, can anyone tell me how I should do the parameter calculation below in the MSM / MUMPS of Intersystems? STAP SIZE STACK SIZE MAX MODIFIED BUFFERS DISK I / O RATE SLICE COMMANDS PARTITION SIZE BUFFER POOL SIZE
In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:
By update
