Question Ramesh Ramachandran · Jul 1, 2022 MAXLEN usage for strings Is it a good practice to set the MAXLEN value of %Library.String property type? Will it lead to wasted storage if its not really using it? For example, I have to store a 5 characters long string into the below str field. Which of the statement is recommended? Property str As %String; vs Property str As %String(MAXLEN="5"); #ObjectScript #HealthShare 0 2 0 1.6K
Question Ramesh Ramachandran · Sep 23, 2020 ODBC Invalid cursor state Error We use ExecureProcedure() to execute a stored procedure which returns a result set. But we see lot of "Invalid cursor state" errors when the result set is empty. The connection to SQL server database is made through ODBC. ERROR #6022: Gateway failed: Fetch. + ERROR <Ens>ErrGeneral: SQLState: (24000) NativeError: [0] Message: [Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state Here is the code snippet from the business operation class which uses EnsLib.SQL.OutboundAdapter #Business Operation #SQL #Ensemble 0 2 0 9.5K
Question Ramesh Ramachandran · Jun 5, 2019 Consuming CDS Service in Healthshare Hi, I want to know if anyone tried calling a CDS service from Healthshare/Ensemble. Will that be similar to any other API or is there anything different in constructing CDS Hooks and consuming the CDS Cards received in the response? #Ensemble #HealthShare 0 1 1 277
Question Ramesh Ramachandran · Feb 15, 2019 How to Set Query params while calling an API I need to post data to an api which expects certain data in body, query, path and header. I am using Post method of %Net.HttpRequest class. I was able to set body and header values, but couldn't figure out how to set the query and path variables. Appreciate any assistance! Is it the SetParam method()?http://servername/api/get/?param1=true #Caché #Ensemble #HealthShare 0 2 0 689
Question Ramesh Ramachandran · Mar 30, 2017 ErrJobRegistryNotClean Hi,We have an HTTP business operation where the messages gets stuck and we had to recycle the operation to resume the processing. We are trying to work around this (for time being until we find the root cause) using below code which should recycle the component. #System Administration #Ensemble 0 5 0 879
Question Ramesh Ramachandran · Jan 27, 2017 EDI 837 Parsing I wanted to parse an EDI 837 X12 document to extract a value from CLM segments. We tried with the below DTL and did not get it working. Appreciate any ideas. #DTL #Ensemble 0 1 0 799
Question Ramesh Ramachandran · Dec 12, 2016 Startup Task Hi,I would like to know how to start Object gateway automatically when Ensemble starts up. Is there a way we can include it as part of Start up settings?ThanksRamesh #System Administration #Ensemble 0 2 0 390