Would like to know if there is an alternative or better way to paginate through a dataset using dynamic SQL than what I am using below. The problem is that as the potential pool of data gets larger, this code slows down to the point of not being useable. In analyzing each line of code below, it appears the slow down is related to the initial rset.%Next() iteration. Is there anything available which does not require a subquery/%VID such as a simple LIMIT/OFFSET?
We see a lot of TCPIP connection error for few of the components not sure if it is a network glitch at the source/target or is it with us. And most of the times these errors are very transient and vanish on their own and the connection gets re established and the messages get processed. Here is the error we mostly see
ERROR <Ens>ErrTCPTerminatedReadTimeoutExpired: TCP Read timeout (30) expired waiting for terminator SegTerminatorAscii=13, on |TCP|50007|10620, data received =''
I'm executing a query using JDBC on a PostgreSQL db:
SET statement_timeout TO 600000000; COMMIT SELECT * FROM bi_hour
The query is aborted with the following message:
FOUT #5023: Fout in Java Gateway: JDBC Gateway getClob(0,2) errorBad value for type long : active
The column 'blocked_status' contains the value 'active' is of type 'text'. I figure somewhere the SQL Gateway tries to convert the text value into a long but I can't find where, any suggestions?
Traditional Caché Objectscript has the multi-dimensional array as its main form of complex data structure and the $order command as the main means of traversing said data structures. But newer versions of Caché ObjectScript also have data structures that are direct parallels of what languages such as JavaScript provide, in the form of %DynamicObject and %DynamicArray. These have an easy to use iterator feature via the %GetIterator method, and even a handy built-in literal syntax for constructing new objects.
In PHP, I'm able to utilize the implode and str_getcsv functions to convert a comma-delimited string to a tab-delimited string. The following is an example.
Is there a way to change the theme in management portal? or at least the color of the header.
Issue is, some users have access to Development and Testing and Production environments. I would like a way to color-differentiate the environments to reduce the errors.
We are trying to script a High Availability Shutdown/Start script in case we need to fail over to one of our other servers we can be back up within mins. Is there a way to configure the startup procedure to Automatically Stop/Start the JDBC server when shutting down or starting up cache? is there an auto setting we can change?
Is there a way to get the list of Business Services from a command line call? We are trying to see if there is a way we can automate bring down our Inbound Business Services during a fail over.
I am trying to work with Java Selenium through Cache my java programme works fine but I would like to pass parameters to the jar file form my Ensemble production.
I would like to know any experience working with OPC UA standard in industry sector or IoT. Currently there is no adaptor implemented in IS IRIS for it but it seems to be pushed as the main standard in industry. Did anyone had to implement their own libraries or adaptors to deal with it? Or do you advice to use any already implemented library in Java, Python,...? Any feedback would be appreciated.
I made a new timeline with Patient Encounters. Did this using a external javascript outside Zen Component used for current chartbook.
So, i need to call function inside Zen Component. When i choose any encounter in current timeline is invoked a function, is name is SelectOneEp(' PatientID HERE ',''), i need help how to invoke this method in Zen Component estructure.
I am doing an implementation of a SAML 2.0 SingleSignOn protocol integration which requires a signed message with the signature element in the body of the SOAP message, not the header as is default SOAP security handling. Any suggestions for how to do this would be greatly appreciated. When it is passed in the header, it is not processed by our partner and we just get a "Signature Required" response.
I'm trying to get my Combo Chart to dynamically scale the Y axis, but it's not doing what I would like. The 1st Y series, if the MAX value is set to null, scales the chart and the series fine, but then the subsequent Y axis are not to that same scale. Each "null" Max'ed series is setting it's own scale based only on it's own ranges and not in sync with anything else.
Is there a way to force all of the "null" scaled columns to be in the SAME scale as each other AND be dynamic.
we are trying to call a Webservice that is hosted on a Ensemble production from a .net program.
The web application in ensabmle is defined with password authntication
we can't get to set the security header in the .net program (<soapenv:Header> ... <wsse:Security ... <wsse:UsernameToken ... ) in SoapUI we added the Wss usertoken and it worked like a charm.
Doe's anyone have a idea to guide us? (links, ,samples, etc. )
By update
.png)