go to post Michael Lundberg · Mar 15, 2022 ***Solved*** s theResponse = ##class(%ListOfObjects).%New()s SQLQuery = "{call TheProcedure }"s tSC = ..Adapter.ExecuteProcedure(.theResponse , ,SQLQuery) s tSnapshot = theResponse.GetAt(1)
go to post Michael Lundberg · Mar 15, 2022 Hi and thanks for your reply! Since this is not a stored procedure in Iris database but in an MS SQL server, syntax does not work"SELECT PackageName.ClassName_ProcedureName ('parameter')" Normal call is Execute procedure name. For example, when I call a procedure that does not use an output parameter, I use"..Adapter.ExecuteQuery (.tResult, tQuery) Quit: $$$ ISERR (tStatus)" However, because this procedure fills an output parameter, this call does not work. It then returns "Error! Function must return a value". So i suppose i need to use ExecuteProcedure Sincerely, Michael
go to post Michael Lundberg · Sep 4, 2021 Hello again! Thanks for your answers and it was our service provider who turned out to have problems, just like you thought. They have corrected (but still have some problems) and it works pretty well now Regards Michael
go to post Michael Lundberg · Sep 1, 2021 Hello and thank you very much for your answer! That/this was/is the response in SOAP log (I just deleted Style/css info): **************************************************** Input to Web client with SOAP action = urn: submitFile ERROR # 6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: text / html; charset = utf-8. Input to Web client with SOAP action = urn: submitFile ERROR # 6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: text / html; charset = utf-8. HTTP Status 500 - Internal Server Error. The server encountered an unexpected condition that prevented it from fulfilling the request. javax.servlet.ServletException: An error occurred see.fohm.sminet.util.CheckFilter.doFilter (CheckFilter.java:38) org.apache.catalina.filters.ExpiresFilter.doFilter (ExpiresFilter.java:1232). Apache Tomcat / 8.5.39 (Ubuntu) End. ************************************************ We run in windows, not Ubuntu so it must come from their service Regards Michael
go to post Michael Lundberg · Mar 31, 2021 Thanks for your reply! It can be very helpful and we will try your suggestion and hope we can get something done. Regards Michael
go to post Michael Lundberg · Mar 29, 2021 Hi and thanks for your reply. It is not possible to queue up the requests from the external systems themselves, but they will be sent to our HC- integration regardless of how many we already have in our queue. The answer (response) may take a maximum of 15 seconds, otherwise the response must be saved in the database and delivered at a later request. The problem is knowing how long a message has waited (in a queue) before it is sent to the business process, if the queue exceeds what our business service can process at the time. Our allowed time to process the request will then be 15 seconds minus the waiting time in the queue. I hope I am clear enough with what I mean. Regards Michael
go to post Michael Lundberg · Apr 24, 2020 Hello I don't think so. This is a proxy-class of type %SerialObject which I populate and embed in to the request class /Michael
go to post Michael Lundberg · Apr 23, 2020 Hi and thanks for answer Eduard. It did not work properly and it is still labeled as UTC in the SOAP request I send.I.E 2019-09-12T10: 39: 00Z. Maybe i'm doing something wrong. I dont' know. Anyway, if I instead changed this type in my class from:Property VisitTime As% TimeStamp (XMLNAME = "VisitTime" , XMLPROJECTION = "ATTRIBUTE"); To:Property VisitTime As% TimeStamp (XMLNAME = "VisitTime " , XMLPROJECTION = "ATTRIBUTE", XMLTIMEZONE = "IGNORE"); it came out as 2019-09-12T10:39:00 (No Z at the end indicating UTC). And that's what I was looking for. However it can couse me trouble if the schema will be updated and i will lost my changes. And it would be easier to not change every %Timestamp-property in my class
go to post Michael Lundberg · Apr 23, 2020 Hi and thanks for your answer Robert. I can now see that I was unclear about my question, I apologize for that What I wanted is to see if it was possible to changethe value of parameter without changing the %TimeStamp classor building a new class in my solution.
go to post Michael Lundberg · Feb 21, 2019 Thank you for information! I will study or links and i sure now we can solve this out!/Michael
go to post Michael Lundberg · Feb 19, 2019 Hi and thanks for answer, i will investigate that!//Michael
go to post Michael Lundberg · Feb 20, 2018 I trace all lines and i never reach the line after (next property).
go to post Michael Lundberg · Feb 20, 2018 Hi and thanks for answer. It's not any explicit saving. It seems to happens immediately at allocation of the value even if there are more properties to set after that line. And there is of course a Quit later//Michael
go to post Michael Lundberg · Sep 4, 2017 HiThanks for that. We will decide some of these suggestionsSincerly,Michael
go to post Michael Lundberg · Aug 29, 2017 Hi and thank you for ansver!I have look at the InboundAdapter class and that will probably be our choice, since we not know any other way. As an option i was thinking to monitoring the eventlog in some way.Just by pure curiosity, what table is "done file table "?Appreciate your response, thanks!- Michael
go to post Michael Lundberg · Mar 31, 2017 With productdescription i mean what you se in the productionclass for each namespace (if there is a productionclass) between the tags <Description></Description>. You can set value from manager portal on product settings.What i want to do, is in a production in the process (with cos) get that description from any other namespace. Wihout to do any global mappings . Then i want to access the content in that productionclass and read out the value from<Description>Value</Description>.I will take a look at $SYSTEM.SYS.NameSpace() as suggested-Michael