#Ensemble

42

InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record

time.

Learn more

Documentation

Hi Guys 

how do I deal with single Quote inside string in an SQL query?

currently this type of query is failing with an error asking me for a closing quote :

Select * from cnd.Facilities  where name like ''%Grill's BBQ%'

Thanks

0 5
0 100
Question
Rochdi Badis · Jul 20
Inbound Adapters

Hi Guys,

Is there online tutorials or samples on how to use Inbound Adapters ?

All I'm looking for at this stage is to create and inbound Adapter in a production to request to connect to a client where I can Get JSON file and what do I need to establish the connection?

 

Thanks

 

 

0 1
0 89
Question
Rochdi Badis · Jul 21
Zen Page source url

Hi Guys,

usually when I want to find out which class is a zen page is, I just right click on the page and go to properties and this will show me the class url, but with this client I don't get properties as below !?

 

Thanks

0 3
0 74

Hello everyone!

I am writing a SQL CALL (using JDBC) to a stored procedure that outputs a structured object (Oracle Object).

However, the adapter method is not accepting the corresponding JDBC Data Type STRUCT for the output parameter, returning the following error:

0 1
0 241

Hi Guys,

I have a service that picks up jobs and process them, is there a way that I can cap the number of attempts to pickup a certain job eg. 10 times if no response then just discard ? 

 

Thanks

0 1
0 93

Good morning,

We would appreciate if you could read us and if you have the opportunity, please respond to us.

 

The current situation is as follows:

We have 2 environments PREproduction and INTegration :

Ensemble version in PREproduction:

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.6 (Build 717U) Thu Feb 24 2022 13:27:54 EST

Version of the tool to convert XML to ER7 and vice versa, the ITB, in PRE (we get it in the ITB.info.cls file):

0 1
0 46

Hi Guys,

I'm getting the below TLS error in SSL_connect(), SSL_ERROR_SYSCALL, I've treid mulitple SSL/TLS configuration and still get the same error, so should I be asking the client that I'm trying to connect if there a specific certificate or configuration!?

 

0 4
0 135
Question
Rochdi Badis · Jul 14
Clone Class

Hi Guys,

 

How can I create a clone class so I can keep a copy of all records in that clone class?

Basically, I have a class where sometime records might be delete from it, so I would like to create clone class or merge the global content in another backup global so that records can be deleted from the original class but still have a copy of those delete records in my clone or backup global ?

 

Thanks  

0 2
0 108
Question
Rochdi Badis · Jul 19
Empty HTTP response

Hi Guys,

We use the below code to send JSON file to one of our clients and was working fine but I think lately they did a windows update and now whenever we send file we aren't getting any HTTP responses, success or Error, just empty response ()

the think is that it works fine and we get 200 response if we send the JSON file using our client's portal called swagger which is a website where you can assign the token and url (Swagger UI (vibra-api-prod.azurewebsites.net))

0 6
0 70