go to post Enrico Parisi · Oct 1 If the header is called "AUTHORIZATION", then use: Set authHeader = %request.GetCgiEnv("AUTHORIZATION")
go to post Enrico Parisi · Sep 23 I strongly discourage the use of embedded sql, it has many disadvantages. Sorry Theo but I don't agree at all. The differences (disadvantageous or not) between Embedded SQL and Dynamic Queries have evaporated since few years now, please have a look to this article from @Benjamin De Boe : New in 2020.1: the Universal Query Cache In general, I advice to use the query type (Embedded vs. Dynamic) that best fit in given code pattern, for example Embedded SQL is very convenient for query that returns 1 row. Or maybe you have other issues with Embedded SQL?
go to post Enrico Parisi · Sep 17 I think you are mixing hosts (production component) and jobs. A host can be enabled or disabled, when a host is enabled there are a number (PoolSize) of jobs and each job has a status. You can view/list the status/details of production jobs in the Management portal Interoperability -> Monitor -> Jobs. You already know how to get if an host is enabled/disabled, to get the status of all jobs you can use the query Enumerate in the Ens.Job class, to test it: Set rs=##class(Ens.Job).EnumerateFunc() Do rs.%Display()
go to post Enrico Parisi · Sep 16 I'm not familiar with ODBC on Linux, however it seems that Caché is unable to use the configured DNS named "DSN". Is that DSN properly configured and successfully tested in Linux? For configuring ODBC, have a look to this "Ask AI" answer. If you still have issues, I suggest to open a new question and provide detailed information on what you have configured/done and the results/errors you had.
go to post Enrico Parisi · Sep 15 What do your refer to with "Iris Health dashboard"? What web server are you using? Apache?Is the web server installed on the same system where IRIS is running? Did you install IRIS after installing the web server? During IRIS installation, was the web server configured? You mentioned a "VM", is this a "normal" or a container installation?
go to post Enrico Parisi · Sep 12 Is this on Windows or Linux? Are you using 32 or 64 bit Cachè/Ensemble? If Windows, did you configure the DSN named "DSN" in windows? 32 bits or 64 bits?
go to post Enrico Parisi · Sep 11 What is reported in the WIndows Event log? In addition, check the cconsole.log in the installation mgr directory.
go to post Enrico Parisi · Sep 11 Yes, for ODBC connection you can use the SQL Gateway directly from code, I suggest to start from documentation: Using the SQL Gateway Programmatically
go to post Enrico Parisi · Sep 10 I advise to use: TROLLBACK 1 Instead of TROLLBACK This way you rollback "your stuff", not EVERYTHING...god knows what! 😉
go to post Enrico Parisi · Sep 10 The last message/error is pretty clear:Unable to allocate shared memory minimum of 146MB Although it seems strange to me that a modern system is not able to allocate 146MB of memory! Can you try to reboot the system?
go to post Enrico Parisi · Sep 8 What puzzle me is the "EnsLib.NullAdapter"! EnsLib is a "system" package mapped to a read only database. There is no such a "EnsLib.NullAdapter" class in the ENSLIB database. Does this class even compile?!
go to post Enrico Parisi · Sep 8 How is configure the "Stay Connected" setting in the BO that use the EnsLib.SQL.OutboundAdapter? How many/how often you have messages sent to this BO?
go to post Enrico Parisi · Sep 2 Just to check, how did you "build index on both EnsLib.HL7.SearchTable and OSU.HL7.SearchTable."?
go to post Enrico Parisi · Aug 28 it doesn't seem like the Results of the Class Method are coming back correctly 100% of the time. This is VERY strange, I would add a test/check if an error occur testing SQLCODE and %msg after &SQL() to see if/when/why it fails. When using embedded SQL you are not supposed to check/access a returned variable (ExtDisplay in your case) before checking for success/failure via SQLCODE variable. If you need to check if the query found a row, you should check the SQLCODE value, not ExtDisplay value.
go to post Enrico Parisi · Aug 26 Went to the sea or a lake: Hiked/enjoyed nature: Earned points and redeemed a reward on Global Masters 🏆Many rewards...too many to count! 😊 Joined READY 2025 🎉Yep! See first picture in this Discussion 😉 Spent time with family or friends: And, a lot of relaxing!...I definitely needed it!
go to post Enrico Parisi · Aug 26 This is very confusing, I understand editing names for privacy reasons, but you are changing the actual format, not only names. I've never seen "##class(|"NS"|Path.To.Class)" in errors. Can you reproduce the issue with a simple sample code using generic names? This way you can post your code so we can understand what's going on and how to fix/log the problem.
go to post Enrico Parisi · Aug 25 I don't think that ##class(|"NS"|Path.To.Class).ClassMethod() is a valid syntax. I believe the "|NS|" makes it a syntax error.
go to post Enrico Parisi · Aug 25 s %sc=##class(|"NS"|Path.To.Class).ClassMethod(..%p1,%p2) Is this really contained in the error message? Is that your code? To me |"NS"| and ..%p1 look strange.
go to post Enrico Parisi · Aug 25 Try with: <Map Prefix="/v([0-9]{1,2})/news/([^/]*)" Forward="API.Dispatch.news"/>
