#Caché

How can you find referenced entries in a table that have been deleted with the drop column?
I have to find all fields in the database afterwards and then delete them properly.
Has anyone had this problem yet?
Can the information be found in the class or storage definitions?
Thanks for a quick feedback.

After linking in Oracle Table with Field Column's Data Types of NUMBER, my updates into these table fields are resulting in data that is being rounded to 2 decimal places. I insert a record with 1234.1234 and 1234.12 is stored.

It appears Cache xDBC might be manipulating my values prior to sending to Oracle. Is there a setting or system parameter that is controlling this? If so, is there a way to relax this from occurring so the values I send are being stored in Oracle with the same values?

Hi all
    Is there anyway to decrypt the PBKDF2 encrypted data in a table?

Thanks,
Syed M

I'm trying to debug a CSP page but I'm not able to set up a breakpoint into <script> tag.

Is it possible to setup on CSP files? Am I forgeting something?

PS:

this is the tag

Good morning everybody,

In Html sometimes we need to use entities code for don't have problems with browsers all over the world. Ex. 'á' is converted to code: '&aacute;' / 'é'  is converted to '&eacute;'. 

I have a question, how can i convert a string like my name to this type of code? Ex. "Flávio" will be "Fl&aacute;vio". I tried this way:

USER>write $zconvert("Flávio","I","HTML")
Flávio

but don't worked :(
 

Best Regards.

Hello,

We need to upgrade our cache instance from 2016.2 to the latest version.

I find the documentation about the "Upgrade Path" but I cant  find where I can get the files to upgrade in the documentation.

Also I cant find how to make this upgrade, they talk about strategies but dont talk how to perform the task to upgrade.

Is there any documentation of how to make and upgrade and where I can get the files?

We have the instance installed on RedHat unix. 

Thanks!! 

Hi developers, 

We have just published an update to the Deltanji version control extension for Visual Studio Code.

When used in certain Deltanji workflows, triggering an automatic checkout on first keystroke could result in the developer working on an outdated copy of the code and only being notified of this later when saving their changes. In order to prevent this from happening checkout now reloads the document immediately. 

Error messaging has been improved in two areas - when attempting to cancel code that is not checked out, and when trying to register new code onto a withdraw system. 

We have also improved interoperability between the Deltanji extension and the InterSystems ObjectScript one, as well as its handling of multi-component objects.

If you're already a user of Deltanji then your extension with automatically update. You can find out more information on Deltanji and the latest release here. 

Hi developers!

Do you know a CRM that is built with InterSystems IRIS or Caché or Ensemble on a backend?

How to create and delete a namespace from the terminal?

Hello, first of all thanks for your time reading our question 💭

We would need to be able to transform a hexadecimal string to a base64 coded one. 🔄

To be specific, our use case is this:

1º We have our hexadecimal as follows:

4C5803040101020179C3913EC3BA7C4C580708010101021824584D4C

2º We convert it to ASCII:

LXyÑ>ú|LX$XML

using this online tool:

https://www.binaryhexconverter.com/hex-to-ascii-text-converter

3º Then we should be able to translate the ASCII to base64:

TFgDBAEBAgF5wyYjMTQ1Oz7DunxMWAcIAQEBAhgkWE1M

We are being helped by this useful web:

https://www.motobit.com/util/base64-decoder-encoder.

I'm trying to implement an OAuth2 server, but I have som issues when trying to setup JWT under OAuth 2.0->Client.

I get the error message saying "No match between server name 'localhost' and SSL certificate values 'cache'". I have set up a SSL/TLS configuration as simple as possible without any certificate files. I'm accessing my server via HTTPS with an unsigned certificate.

Can anyone point me in the right direction on how to resolve the issue I'm encountering.

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a default setting value by code

My objective is to find routine's Date/Time Saved someplace inside Cache. The routine's Date/Time Modified as returned by various queries like %Library.RoutineIndex and as seen on the File Open screen is actually Date/Time Compiled last, not Date/Time Saved last. Does anyone know if Date/Time Saved is created when the Save icon is pressed or the routine is imported? Such a timestamp should be immune to subsequent compilations with no changes.

I am also curious about the internal Cache mechanism that marks the routine's tab with + which means saved but not compiled yet.

I am unable to download Cache Studio from the Intersystems web page. The download link times out.

https://www.intersystems.com/developing-with-intersystems-iris/ 

Scroll down and click on 'Studio'.  Spins then times out.

@Andreas Dieckow can you provide any insight?

Joe

In a typical database, changing the type of a column from some kind of date/time to a string would require a degree of migration effort for existing values. In Caché, my suspicion is that this is not the case, and I could simply change a property definition from %Timestamp to %String (MAXLEN = "30") and recompile, without needing to worry about damaging the existing data stored for this property. Is this correct? Or would I find the existing data in this property being lost or corrupted?

Thanks in anticipation

Dear,

  From time to time I get the following error after executing a select statement:

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]
[Location: <ServerLoop>] InterSystems.Data.CacheClient.CacheException [SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]

After repeating the query, the query succeeds.

How do I start debugging this type of issue?

Thanks,

Bart

Hi,

How to write code in table trigger to send SMS upon any modification on particular column?

Thanks
 

Hello,

First of all thanks for your time reading our question, and thanks for your replies and help

We would need to know if a patient has less than 65 years old, using their birthday from the PID 7.1

So far we have developed the following code:

 // 
  set nacimiento             = request.GetValueAt("PID:DateTimeofBirth.Time")
  $$$LOGINFO("nacimiento: "_nacimiento)


  //22/04/1976
  set nacimientoFormateado   = ##class(Util.FuncionesComunes).DateFormatConvertToXML(nacimiento)


  // ""
  set nacimientoFormateado65 = $extract($system.SQL.DATEADD("yy",65,nacimientoFormateado),1,10)
  // 2021-06-21
  set hoy = $zdate($h,3)


  $$$LOGINFO(nacimientoFormateado_" - "_nacimientoFormateado65_" - "_hoy)


  if (hoy<nacimientoFormateado65){
     $$$LOGINFO("hoy: "_hoy)
     $$$LOGINFO("nacimientoFormateado65: "_nacimientoFormateado65)
     set edad = "1"
  }

Hi all,
    We have a session values in a cache method and need to get those values in a client method (JavaScript).
   
Eg : 
    ClassMethod Method1()
{
    Set %session.Data("Param1")="Data 1"
}

ClientMethod onloadHandler [Language = javascript]
{
   var ret = zenPage.getSessionValues();
}

ClassMethod getSessionValues() As %String [zenMethod]
{
   Set Data = $G(%session.Data("Param1"))
   Quit Data
}

This is the code we implemented. But the problem is getSessionValues() method isn't called.
We need to know how to call a class method from client method.

Thanks,
Syed M

Hello, first of all thanks for your time reading this question ◀️

We would need to achieve the following task:

We have a Ens.Response message with this structure:

<?xml version="1.0" ?>
<!-- type: Mensajes.Response.Justicia.PLATINO.EnviarIniciadoresGeneralResponse  id: 10986665 -->
<EnviarIniciadoresGeneralResponse>
    <EnviarIniciadoresGeneralOut>
        <![CDATA[<?xml version="1.0" encoding="ISO-8859-1"?>
<mensajeWS xmlns="https://wslexnet.webservices.lexnet/3.22"><respuestaEnvioMensaje xmlns=""><idEnvio>1947625809</idEnvio><tamBloque>524288</tamBloque><bytesMIME>TFgDBA.

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

How strange this is to me.  I'm querying a table against a numeric(15,2) column call max_client_resp_service.  When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g. 2.00.  When I query < 110 of any higher number I get zero results.  It's as though the comparison operator, especially less than function is not working.  See attachments for screen shots.  I'm stumped.  Ok looking at this further, it appears ">" returns all records, "<" returns no results.

Does Caché or IRIS have Data Masking capability natively to Test/Dev/Report environment, like other databases?

Hi community,

I'm going to publish several articles on how to perform actions that you can do in the web portal but via code.

Today.... Web Applications via code

Is there a shorter way than

$P($ZD($H),"/",3)

?

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

any persistan class can be used as msg body, if i use one of my persistent class(ex sample.person) as msg in the ensemble then perform purge  management where inculde msg bodies .. will we loose the sample.person data?

Is there somewhere  a dialect  class for Cache 2018.1  with  Hibernate  version 5.x ?

I have a routine tag that takes an argument and I want this argument to be an array reference.  So I try something like:

do mytag(.myarr)

The mytag tag, adds subscripts to myarr.

When I evaluate myarr after the tag call, only the subscripts passed in are retained in myarr.  The subscripts added by mytag are missing.  Is there a way to pass an array so it will behave the way I want it to?

If I export a class definition to an XML file, is there a way to programmatically import it so that I could schedule a task to look in a given location for XML files once a day and import class definitions?