I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

0 0
0 68

Hi Guys,

I've created a webservice where a third party web application that can communicate with Ensemble via webservices to post and get data in from of JSON, first call is a post call to login with user/password and Ensemble responds with success or failure than the following get calls, but I've been advised that I also need to return a Cookie to control the exchange and the session for a specific user, I'm not familiar with Cookie so any suggestions, how can I create a an authentication cookie and do i need to add it to my next Get calls ?

Thanks

0 0
0 61

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

0 0
0 54

Hello,

I'm trying to carry a custom error from one business process to another.

BPL:LookupClass fails it's lookup and a custom error of "Lookup XYZ" is generated.

The class quits with that error, but upon quitting, the custom error gets wrapped in an Ensemble System error:

ERROR <Ens>ErrBPTerminated: Terminating BP LookupClass # due to error: Lookup XYZ

0 0
0 48

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.

0 0
0 43
Question
· Dec 4
Error importing XSD

I'm attempting to import all the FHIR XSD files provided by http://hl7.org/fhir but get the immediate and unhelpful error message:

I've tried different versions of EOLs to no avail. Any idea what this error could mean?

Here's the XSD I'm trying to import:

<?xml version="1.0" encoding="UTF-8"?>
<!--
Copyright (c) 2011+, HL7, Inc
All rights reserved.

0 0
0 11