Caché | InterSystems Developer Community

Question

Thembelani Mlalazi · Apr 11, 2019

I have a query that I would like to have refreshing at certain intervals lets say every 30 seconds with out refreshing the page content using the META TAGS

refreshes the whole page but I have a jquery function that will run at those intervals that I can use the problem is getting the jquery to call my COS function or is the way to do it with pure COS

#CSP #JavaScript #ObjectScript #Frontend #Caché

0 2

0 464

Question

Jimmy Christian · Apr 23, 2019

SQL CREATE Table Name with System defined variable

Hello all,

I am still learning CACHE and have below question.

In one of my ZEN method i am creating a table using

#SQL #Caché

0 2

0 272

Question

Jimmy Christian · May 8, 2019

Cache Studio Error

Hello,

I am facing an issue where i am not able to start the Healtshare environment.

#Studio #Caché

0 5

0 642

Question

Krishnamuthu Ve... · May 30, 2019

No 'Access-Control-Allow-Origin' header issue with Cors issue.

Hi All,

I have a REST dispatcher class in which I enabled the Parameter HandleCorsRequest = 1;

I can able to access the API using Postman, but not with my web application. It throws the below error.

#REST API #Frontend #Caché #InterSystems IRIS

0 3

0 1.8K

Question

Richard Roeder · Jun 10, 2019

Force Indice

How to force a specific index in SQL?

#SQL #Caché

0 3

0 424

Question

Julian Matthews · Jun 26, 2019

EnsLib.DICOM.Document - GetValueAt truncating "large" files

I have a process that receives a EnsLib.DICOM.Document, and then attempts to extract a PDF from the dataset to save to a folder.

When I use the GetValueAt method to get the pdf from the document (from the EncapsulatedDocument section), the status returned is 1, but I'm only getting the first 32648 characters(?) from the PDF.

I thought it was a string max length problem, but long strings are enabled and the final PDF is tiny (94kb) so it's not hitting the long string.

Is there some form of limit to using the GetValueAt method that I'm missing?

#Caché

0 3

0 372

Question

savita singh · Jul 9, 2019

On IIS Server CreateObject("CacheObject.Factory") not working

When publish my application on the iis server below function not working..

Public Shared Sub Connection()
Try
factory = CreateObject("CacheObject.Factory")
If Not factory.IsConnected() Then
Dim connectstring As String
connectstring = ConfigurationManager.AppSettings.Get("con")
Dim success As Boolean
success = factory.Connect(connectstring)
End If

#.NET #Caché

0 1

0 430

Question

David Kilburn · Aug 8, 2019

Error copying CSP files to prjoect

I am trying out Atelier. I have installed it and managed to get it to connect to a cache instance to test it. I have created a local project and I am trying to copy the server files to it using the "Copy to Project" item on the popup menus. I can copy both classes and routines to the project without issue, but when I try to copy the CSP files, I get the following message:

com.intersystems.atelier.utils.CheckedExceptionWrapper: Input length = 1

#Caché

0 3

0 264

Question

Alex Anderson · Aug 21, 2019

Cubic Spline and 5 PL curve fit and data reduction

Has anyone used Cache \ DeepSee for graphical curve fitting and data reduction using Cubic Spline and/or 5 PL for complex curve fitting

#.NET #C++ #Caché #InterSystems IRIS BI (DeepSee)

0 1

0 489

Question

reinhard lebensorger · Sep 17, 2019

Cache and SQL Performance

We often have troubles with performance when joining tables with about 10 million rows together.

Sometimes we can't say what the cache engine is doing, it's just sucks and never finishes.

Then we have to rebuild the query and loop first on Orders and then on OrderPositions.

this is what we want:

EDITED: the join was only forgotten

#Caché

0 5

0 448

Question

Thembelani Mlalazi · Sep 25, 2019

Soap Service How to pass a Stream Response

I have been trying to pass a %Global character stream back on a Soap Response has anyone one out there done it before please help with guide lines on how to achieve this thanks in advance just some working sample code and will take it from there thanks again

#API #SOAP #Caché

0 5

0 742

Question

Yone Moreno · Oct 13, 2019

Using class queries to select all rows and return an array: unexpected behaviour

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

Query BooksLoaned() As %SQLQuery
{
SELECT *
FROM Library.Book
WHERE Friend IS NOT NULL
}

Which I have tested throught the portal:

#Code Snippet #SQL #Caché #Ensemble

0 6

0 445

Question

Sergey Madiev · Oct 30, 2019

SQL query index using

Hi guys,
I ran into a strange (for me) situation, when I run same query but change the WHERE clause the plan is different and is not connected to the additional condition.
Query that doesn't use the necessary index:

#SQL #Caché

0 9

0 643

Question

Ikara Ikliki · Nov 13, 2019

SQLCompute does not work when Insert/Update done via the Caché ODBC DLL

I have SQLCompute with SQLComputeCode on a couple of Properties in my class.

These work fin when I insert/update via ObjectScript or SQL from the ManagementPortal.

However, if I insert (create new record) via my C# app using the Caché ODBC DLL the SQLCompute is ignored, it does not run.

Is this expected InterSystems Caché behaviour? We are on latest IRIS platform.

#.NET #ObjectScript #ODBC #Caché

0 7

0 481

Question

Duncan Samarasinghe · Nov 26, 2019

How do run a class from the terminal, and pass parameters?

Please can I have a quick simple answer.

I am still learning.

Thank-you.

#Caché

0 2

0 543

Question

Kelly Blake · Dec 10, 2019

File transfer to Microsoft SharePoint online (SPO)

Our current file repository was on a linux server, but it has been having issues. For this reason, we are moving the data to SharePoint online, since we already pay for the service. It seems there is not an option to ftp/sftp files to/from the SharePoint Online server from our RedHat server (Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2015.2.3 (Build 855_0_17370))

How would I send and receive From the RedHat server to the SPO Server?

I'd love full example code, but any help pointing me in the right direction would be much appreciated.

#Caché

0 3

0 3.2K

Question

Orlando Lagman · Jan 16, 2020

debugging web client

I used the soap wizard to create a web client based on the wsdl. I was able to get a valid response back, and now it looks like the error is in decrypting the soap message response "inbound"

ERROR #6284: Security header error: SecurityTokenUnavailable.

#Security #SOAP #Caché

0 1

0 566

Question

Brian Cromwell · Feb 4, 2020

Crystal Reports returning a Database Vendor Code 30

I am developing a viewer for Crystal Reports using the Crystal Reports for Visual Studio (CR13SP26). I have also installed the latest ODBC Drivers for Cache, but when I connect some reports to the Cache database using a connection string, I get an error that I failed to retrieve data from the database, and it reports the Database Vendor Code 30. Has anyone used Crystal Reports connecting via a connection string and received this error? If so, how did you correct it?

Thank you,

Brian Cromwell

#.NET #ODBC #Caché

0 2

0 915

Question

Anzelem Sanyatwe · Feb 19, 2020

Disabling Telnet

Good Day;

looking at disabling Telnet - on Windows - Cache 2012,2017. The security scans don't need it on network.

But still leave users able to use `Terminal - direct - on the box should be fine.

am posting here for quick refs (as this is a common security vulnerability out there).

Regards;

Anzelem.

#Microsoft Windows #Terminal #Caché

0 5

0 893

Question

Stuart Byrne · Mar 10, 2020

Reducing the end variable in a FOR loop once executed

Dear All,

I'm looping through a list with characters (Parenthesis, square brackets etc) and I wish to remove these from the list.

The for loop and IF logic are effectively removing these items from a list.

However the variable I use for the maximum number of loops carries on beyond the number of items of the list after removal.

In the output value for these I get the integer of the for loop instead of a null for the empty list fields.

I can see in the documentation that the end variable is not editable once the loop is started.

#ObjectScript #Caché

0 12

0 751

Question

Yone Moreno · Mar 26, 2020

Correct way to set a value into a list?

Hello,

We have a tranformation where we would like to convert a date from the following format:

"'dd/mm/yyyy' 'hh:mm'" (double quotes are just visual to indicate this is a string)

to date and time separated:

date: dd/mm/yyyy

time: hh:mm

We have already splitted the datetime into date and hour as follows:

#ObjectScript #Caché

0 1

0 437

Question

瑞王 · Apr 7, 2020

Stored procedure call

When using CallableStatement to call a stored procedure, the log shows an error. SqlCode-400.

This is my calling statement.

CALL web_DHCENS_CDSS.patadviceinfo_patadviceinfo(?,?,?)

#SQL #Caché #InterSystems IRIS

0 4

0 646

Question

lw wei · Apr 28, 2020

Starting caché without automatic WIJ recovery in non-interactive way

After the database is restored, the WIJ file may be incompatible, so I deleted the WIJ file, and it needs to be set manually at startup

message in cconsole.log:

Enter Cache' with 
     csession CACHE2016 -B
and Do ^STURECOV for help recovering from the errors

after command " Do ^STURECOV":

#Caché

0 2

0 1.1K

Question

Jo Ellen Laansma · May 13, 2020

SQL Server - How to write column with empty string instead of NULL

I have a class that writes to an external SQL Server database. When the field is empty, it does not write the column and the column has the value NULL. In some cases, I want the column to be the value of the empty string instead of NULL.

#JDBC #ObjectScript #SQL #Caché #HealthShare

0 5

0 16.5K

Question

Mahmudul Hasan · May 31, 2020

Startup aborted on Mac OS Catalina

I am new on Mac. I have tried to install Caché on Mac. The installation completed successfully but it failed to start up.

It shows following failure message on the terminal:

#Apple macOS #Caché

0 5

1 645

Question

Yone Moreno · Jun 16, 2020

How could we move all files from a set of directories to one directory inside the server?

Hello,

We would like to learn how would you approach this task.

We would need to check every day a set of folders which are outside our server (in fact we could see them as if they were "inside" the server), then we need to check for modified or created files in the last day, and move all the ones which match the criteria to just one folder in our server.

We have thought about doing the following:

1) Create a task to run it each day:

#Code Snippet #Caché

0 5

0 713

Question

Ihsan Ahmed · Jun 28, 2020

Stream Read - Multi Languages

Hi, I am doing a stream read so that I can do some inserts to the table however other language read is not supported, any idea what I need to do to achieve this?

Thanks

#ObjectScript #Caché

0 4

0 254

Question

Meenakshi Shanmugam · Jul 15, 2020

TO_CHAR Function not working for 12/31/1840 in Cache DB

Hi,

Below To_Char function is not working as expected

SELECT TO_CHAR('12/31/1840','mm/dd/yyyy') ---01/12/1841

I expect the result to be 12/31/1840. Let me know If there are any suggestion to get the correct result.

Thanks,
Meena

#Databases #Caché

0 8

0 552

Question

Muni Ganesh · Aug 1, 2020

How to Retrieve Data from Journals for Killed global in CACHE

Hi,

We are using CACHE 2017.2.1, I would like to retrieve data from Journal for killed global. Let say we have global name ^ EMP(123) with data and also have some child nodes and it has been killed by using cache kill command for some reason and we don't know who has executed this and when. My questions are below.

1) Can we get back the data of killed global from journal files,Is it possible or not ?

#Globals #Journaling #Caché

0 5

0 719

Question

Joao Palma · Aug 21, 2020

IRIS SQL Linked Table

Hi everyone

Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?

I've tried different queries. It does not fail but does not add the column either...

#SQL #Caché

0 4

0 552