Question Tom Philippi · Jan 31, 2018 DSN does not show up on InterSystems Ensemble SQL Gateway configuration. I am running InterSystems Ensemble 2016.2 on ubuntu and trying to connect to a remote MS SQL server database.Insofar, I have successfully configured my ubuntu machine to connect to the remote MS SQL server database using unix-odbc. That is: #ODBC #Ensemble 0 1 0 680
Question Tom Philippi · Jan 17, 2018 Http response incomplete when attemting to set up ODBC connection on Ensemble. We are trying to make an ODBC connection via our intersystems ensemble (2016.2 running on ubuntu). However, when I am testing the connection I receive a pop-up that: "Http object response incomplete or invalid.0,#R". Note that the iodbctrace.log remains empty (and it is working because on the first try it registered a 459 error that I should activate kerberos, which I did). Any advise where I should look?I have taken the following actions: 1. Expand the cacheodbc.ini in the mgr directory as follows: #ODBC #Ensemble 0 2 0 1.5K
Question Tom Philippi · Jan 8, 2018 Processing multiple SQL-rows at the same time using SQL Inbound adapter I have a database which needs to be synced to another system and considering to use the SQL Inbound adapter to 'watch' the database. The other system, however, has a bulk API so I'd prefer to send multiple SQL rows in a single message to that system. The SQL Inbound adapter seems to trigger a single call (to a process or business operation) per SQL-row. #SQL #Ensemble 0 3 0 742
Question Tom Philippi · Dec 13, 2017 Running SQL queries on Dynamic objects Recently viewed a demo on the new Dynamic Objects in InterSystems (we are still running 2016.1); together with the upcoming IRIS data platform I started thinking about possibilities of building dynamic databases. That is, I can imagine some projects were it might be really nice to store dynamic objects and then run sql queries on them without ever defining the fields of the dynamic objects (i.e. not at storage, but only if you run your sql query). #SQL #Caché #InterSystems IRIS 0 3 0 734
Question Tom Philippi · Nov 28, 2017 How to best share External Login Tokens accross Business Processes When executing a business process I'd like to share the Login Token from an external system retrieved via one of my business operations across multiple process instances. This means I need to persist the token somewhere. What would be the best approach/pattern to implement this? #Beginner #Business Process (BPL) #Ensemble 1 1 0 324
Question Tom Philippi · Nov 27, 2017 Business Process doesn't result in error when the called business rule does. I am calling a business rule from one of my business processes and I noticed that when the business rule reports an error that the business process calling that rule just stops without any errors. Resultingly it fails to trigger the scope - catch-all construction that is surrounding the business rule. I know that it is possible to view the errors in business rules in the business rules log, but I really like to push an error message to Ens.Alert or something similar when my business rules report an error. How do I achieve that? #Business Process (BPL) #Business Rules #Ensemble 0 2 0 325
Question Tom Philippi · Nov 27, 2017 How to set URL for a httpRequest send via SendFormArray()? How do I set an URL when I post a httpRequest via SendFormArray of my Ensemble Business Operation. Here is my code: #JSON #REST API #Ensemble 0 1 0 864
Question Tom Philippi · Nov 23, 2017 Configuring %CSP.REST for SSL connections I have an Ensemble installation and just build my first RestService (using %CSP.Rest that forwards them to my Business Service). This works nice and fine when I use postman to make REST calls over http (port 57772). However when I attempt to make a request using https over port 443 I receive the following error: #REST API #SSL #Ensemble 1 7 0 907
Question Tom Philippi · Nov 21, 2017 How to update a BPL proces using business rule. Initial questions have been answered. Expanded the post with actual code (see below)So, I'd like to update one (and preferably) more context-fields in my ensemble BPL business process based upon the information in the request that initiates said BPL proces. I got a few questions about that: #Business Process (BPL) #Ensemble 0 5 0 633
Question Tom Philippi · Nov 7, 2017 Connecting to a system over SSL explicit mode I have an Ensemble installation with an FTP business operation which I would like to connect to a server over SSL in explicit mode (see also: https://www.rebex.net/kb/tls-ssl-explicit-implicit/default.aspx). I keep running into timeouts while attempting to do this via Ensemble. Does Ensemble actually support SSL in explicit mode??? Because I can't seem to find any setting where to switch it on. #SSL #Ensemble 0 1 0 560
Question Tom Philippi · Oct 11, 2017 How to rename a project in Studio I want to export a project from Studio, but when I do so I get an error that I cannot use the default name and should rename the project instead. However, I cannot find anywhere how I rename the project. #Studio #Caché 1 1 0 517
Question Tom Philippi · Oct 11, 2017 Deployment package does not automatically include Soap Webclients I just deployed my production from test to acceptance but I found that the deployment misses some Soap Webclient classes which are used by my business operation components. I have used the management portal to create the deployment (i.e. production settings -> Export) and I expected that all classes used by the production were automatically included. Apparantly, that is not the case. Is this default behaviour for Ensemble? And can I somehow force Ensemble to automatically include these classes? #Deployment #Ensemble #Business Operation 0 1 0 300
Question Tom Philippi · Aug 23, 2017 Testing for not existing item in collection I have a call in a business process that returns a response which may contain a collection of error message. I use the following code in my response builder to extract the messge value from the first error and map them to a context variable:Set context.ErrorMessage callresponse.result.GetAt(1).errors.GetAt(1).message #Business Process (BPL) #Ensemble 0 2 0 329
Question Tom Philippi · Aug 22, 2017 How to include process context in data transformations I have been building Business Processes in Ensemble for a few months and in a process i'd use a combination of data from the request that started the process and context variables that where filled by earlier calls in the process as input for a data transformation. I do not know how to achieve that. #Ensemble #Business Process (BPL) #Mapping 0 6 0 1.4K
Question Tom Philippi · Aug 16, 2017 Ensemble soap client misses soapaction http header So I have an ensemble soap client which I use to send a message. The target web service is, however, giving a soapfault stating that my message misses the "SoapAction http header".When I copy paste the message from my Cache Soap Log and fire it from Soap UI I get a proper response from the target web service. This suggests that my intersystems installation is somehow not including or losing some http headers. I am running Ensemble 2016.2 SUSE on an ubuntu machine.Here is the InterSystems message with the http headers from Soap UI: #Ensemble 0 2 0 1K
Question Tom Philippi · Aug 16, 2017 Activating and checking the SOAP Log I'd like to access and view the soap log. Apparently there is a global for that (^ISCSOAP) (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...), but insofar I have been unsuccessful finding the exact cache command for viewing the soap log or changing it so that it logs both incoming and outgoing traffic. Can anyone enlighten me?I.e. I am trying stuff like:set ^ISCSOAP("Log") = io write ^ISCSOAP("Log) #Beginner #Caché 0 5 1 4.1K
Question Tom Philippi · Aug 15, 2017 Adding soap header to imported WSDL I have an imported WSDL from SalesForce and I am trying to send a login-request to the SalesForce-servers via InterSystems. The login requires a username and a password in the body, and an organizationId in the header. I am having trouble filling the organizationId in the header.Via SoapUI I can send a successfull message to the SalesForce-servers. The message should look like this: #SOAP #Ensemble 0 4 0 3K
Question Tom Philippi · Aug 14, 2017 Dependency loop error when importing SalesForce WSDL I am trying to import the SalesForce Enterprise WSDL in InterSystems Ensemble Studio using the SOAP Add-In. However, when I do so I receive a class dependency loop, Error #5316 during compilation. The WSDL is the standard WSDL provided with SalesForce and works fine in SoapUI. In the SalesForce WSDL it is allowed for an object A to include an object B as an element, while at the same time object B is allowed object A as an element. I think this is what causes the class dependency loop for InterSystems. Does anyone has any suggestion how I can circumvent this error? #Compiler #SOAP #Ensemble 0 7 0 768
Question Tom Philippi · Aug 7, 2017 Where are local studio settings stored? Okay, so I ran into a rather odd bug. I have a remote test machine (tst-intersystems) running for which I accidently opened a lot of windows in my Studio (i.e. 500+). The result is that the studio runs out of memory and crashes. Now, every time I try to connect to this remote machine studio immediately attempts to open all windows effectively not allowing me to start studio anymore. #Studio #Caché 0 2 0 610
Question Tom Philippi · May 18, 2017 ERROR #5002: Cache error in Ensemble Soap Service I am getting an ERROR #5002 in a soap service defined in ensemble. Odd thing is that I allready have a functioning business service running as a soap service, but we needed another, but that one returns an error: #Caché #Ensemble 1 3 0 4.1K