Works?

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

Upon upgrading to 2023.1.4 we noticed that code exposed some issues with our HL7 DTLs during runtime (not compile). That codebase contains code which references invalid PropertyPaths. With our current version 2021, those invalid references appear to evaluate out to "" and no errors are produced. Of course the code is not generating output as expected but the router does not error.

Our dilemma is that we need to identify any DTLs whereby we are referencing non-existent property paths so we can address before upgrading live environment.

Hi Guys,

I'm getting ERROR #6237: Unexpected tag in XML input: imageclickbutton when running Build All for all existing classes, imageclickbutton is one of custom components we use in our application and I can actually compile imageclickbutton.cls class with no issues and also I can compile the class containing the imageclickbutton tag with not issues but I get the errors when running the Build All not sure why?

As I was trying to create a routine search query via RoutineList, I discovered that documentation both for Cache and Iris offers only ABC* and ABC? syntax for including routine names and, unlike %RO, does not offer name ranges. Is that indeed so?

After some system files reading, I discovered that you can EXCLUDE certain routines with ', by using the 'ABC or 'ABC* syntax. That is not documented but it should be. Any other non-documented RoutineList syntax capabilities?

Example:

When I try to run my app as a Docker Container locally it works fine, but I attempted to create a Hugging Face Space to try to deploy my app to and when I run with the Docker SDK selected I run into the following IRIS error report.

Has anyone seen something like this before?

Hi Guys,

Is there a way to import /export Web Applications? I can see that those web application that I created are also showing in Studio under CSP Files folder and I tried right clicking on some on the folders that seems to be representing my web application then export but didn't work.

Thanks

After performing Concurrent External Backup and restarting the instance, if I want to perform an incremental backup of Concurrent External Backup again.

Should I redo the following steps?

1.  Do CLRINC^DBACK("QUIET")

2.  Set x=$$BACKUP^DBACK("","E","Dirty external backup - incrementals must be applied.","","","")

3. Set x=$$BACKUP^DBACK("","I","Nightly","test.bck","N","bck.log","QUIET","N","Y")

Our client getting sometimes this error and we need to change port number on JavaGateway process to continue,

Failed to start the Gateway server: ERROR #5023: Remote Gateway Error: Communication failure on port: 5000
> ERROR #5001: External Language Server: invalid ping response

Can you tell as why it is happenning? intersystems runtime is under linux.

Hi Guy,

I'm currently using a classmethod to load my page's display content in a form of html want look good, I'm wondering if I can add a Zen component in my classmethod eg. <dataCombo> or Label...etc?

I've tried the bit of code (circled in red) but didn't work

Thanks

Hi all, I am trying to use Polybase in SQL Server 2019 to access an external Cache/IRIS Database. I have followed the initial steps of enabling Polybase, creating a Database, DB scoped credential and then an External Data Source. These steps have not caused any issues and appear to be successful, I am using the same DSN we use for a Linked Server connection that works normally. I am running into an Error when trying to Create an External Table. The error is a generic Native Code 469 "Driver Not Capable".

Hi Team,

This is very urgent can you please guide me to convert the date string to ISO format.

set date = "20240501144800-0500"

set result = $SYSTEM.SQL.Functions.TOTIMESTAMP(date, "YYYYMMDDHHMISS")

write result -> 2024-05-01T16:49:00:00+00:00

so here timezone is dropped off but i need that.

expected result -> 2024-05-01T16:49:00-05:00

Please help me here how i can convert in this format.

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

I have an HL7 message that contains NTE segment with line break inside.

when I try to transform it (with DTL) it stops reading the message after the line break inside the NTE because it treat that as "End of Message".

Is there a way to solve this in the DTL or I need to run a pre process on the HL7 message that identify the line break inside the NTE segments and replace it with an escape char?